Budget |
Level of difficulty: Intermediate |
|
As a prinicpal you are required to draw up a budget for your school's new computer room expenditure. You will submit this to the Governing Body. This proposed budget will be debated and you may need to adjust figures. You may need to change expenditure amounts. Decisions about how many computers to buy and how many staff to train could change the structure of your budget. Working with Microsoft Excel you will be able to create and then adapt this budget at the actual meeting.
|
![]() |
|
Create your own budget - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps: |
Description |
Resources |
|
1 | Start Microsoft Excel | How to start Microsoft Excel |
2 | Type the name of the school and the description of the budget. | |
3 | Save the file: Save your work regularly. | How to save a file |
4 | Modify the heading: Select the heading, change the font, change the font size and colour to make the heading attractive. | |
5 | Enter the budget information: Type the budget categories of your choice in Column A , and type the columns headings (consult the example budget for ideas). | |
6 | Adjust column widths: Change the columns widths so that the text fits the column. | How to adjust columns |
7 | Draw lines: Draw lines of your choice to separate columns and sections of the budget. | How to create borders |
8 | Calculate values (multiply): Use formulae for multiplication to calculate the total costs in the "Total" column. |
|
9 | Copy Formulae: Instead of repeatedly typing a similar formula, you can copy and paste one formula to many cells. Excel changes the row and column references automatically. | How to copy formulae |
10 | Absolute cell reference: When you refer to a value in a specific cell in a formula (e.g. Number of computers in B15) and wish to copy that formula, you have to make the cell reference an "absolute cell reference" so that it does not change when the formula is copied | How to create an absolute cell reference |
11 | Add the total costs: You will need to add the costs at the bottom of the "Total" column. | How to add a range of values |
12 | Change the number format: Change the format of the value to indicate currency (R) where appropriate. | How to change the number format |
13 | Save the file: Save the budget. | How to save a file |
14 | Print the file: Print the budget. | How to print a file |
|
|||
Related scenarios Write a report in Microsoft Word Create a chart in Microsoft Excel Insert a chart from Microsoft Excel in your report |
|||