B062 practical use of ICT Introduction I have been asked by the deputy head teacher at Lakeview School, Mr Brown to produce a system that will help him to give out awards. Therefore Mr Brown is my target audience. Since Mr Brown is not an experienced user of ICT I will have to make a system which is easily usable. Analysis Design specification My system will need to have the following: * Text which is changeable * Store numerical data (e.g. book token budget) * Do calculations (e.g. so that I don’t overcome the budget) Test plan Development First I opened excel: Then I saved the document with the name ‘Lakeview School awards system’: Then I renamed the worksheets so that I could record macros on them: …show more content…
Alongside this I also filed in the cell which contained the text of the year group. Next I went onto the ‘book tokens’ worksheet. On this worksheet I shall have the budget of the book token alongside with what each student receiving the book token shall get. Firstly I need to have a budget. So I will have to enter this into a cell. Next I will need to edit this text slightly. I will make it bold and underline it. Then I shall need to format the cell next to it so that I can enter the amount of money without having to insert the pound sign. Then I entered the people who shall receive the book token. Whilst entering the data I thought that it would be best to fill the entire page instead of going down in a column. After entering all the data I changed the format of all the cells which were to contain the pricing to a currency format. Then to make sure that the value of book tokens does not exceed the budget I decided to have a total cell as well. But when trying to insert the total I had problem doing it effectively in one cell. Therefore I decided to get a total of the pupils from education and sports then add them all up in one cell. Then I made the ‘total’ cell look more like a ‘total’ cell. I did this by changing the style of the cell Next I went onto the ‘Other Awards` worksheet. Firstly I wrote down the different awards available in this worksheet. Then I added a box and
3. Explain two methods that can be used in order to identify realistic estimations when developing a budget. [2.2]
3. Explain two methods that can be used in order to identify realistic estimations when developing a budget. [2.2]
Staying on budget is one of the key factors that will play a significant role in ensuring the success and the completion of the project in a timely manner. In addition, budgeting will allow this project to develop a spending plan which will ensure that we do not exceed the $3,000 dollars allotted for the project. Furthermore, by having a budget plan in place, we are on the path to setting and meeting our financial goals.
| Ensure that the worksheets are correctly named and placed in the following order in the workbook: Summary, Franklin Ave., Main St. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
By creating a budget this facility will be better prepared in knowing how much money they spend and
Reason for error: The cell DI7 has a text 'Flat'. The cell DJ7 and DK7 is blank and if text was entered in those cells the error still occurred.
The line amounts allocated in to spreadsheet that I sent to you are the budgets that I received from Maura. My task is to align each budget with Maura’s spreadsheet.
7. What, if any, expenses are involved with this project? How will you be able to pay for these expenses?
a.) Imaging entering a list of sales on a piece of note paper and then taking your calculator to total 50 transactions that day, Excel does it automatically with a sum formula. Now imagine wondering what your sales would have been like with different prices on some of your items. Excel allows you to quickly model such what-if scenarios.
Personal Budget Exercise – Excel Creating a spreadsheet track personal business expenses is an excellent use of Microsoft Excel. For this exercise, you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $2,500. Here are suggested budget categories if you are not using a real budget. At a minimum, you must have 9 budget categories: Housing (mortgage or rent) Utilities Car payment Insurance Student Loans Food Misc. Entertainment Gas Savings
Joy’s request is to have individual binders for her subjects this school year vs. the all-in-one huge binder that she has tried in the past two years. She likes the idea of using loose leaf instead of the spiral. Jermel Ford with her so-called brilliant and amazing ideas wants for Joy Ford to consider using these flexible, poly binders that can easily fit in Joy’s one bookbag for her seven subjects. They have agreed to try this system for this math class this summer with the goal of implementing the sam system for Joy’s sophomore year. Joy has so graciously agreed to give this a try with the implementation of seed money AND with agreed upon as follows: $300 on Joy’s card. This money will be given to Joy Ford by Jermel Ford in
* As you complete sections of this template, please remove all italicized text in all sections of this template and replace it with your own or you will lose points!
Now, you need to configure your grid. For this, go to the grid setting option, select the spacing, Padding, number of columns, pagination setting, Layout style, etc, as per your specific needs. For example-
* The getRowCount method gets what row to fill based on how full every row is already