Unit 1g
Unit 1g - Creating a Spreadsheet
Right then, more work to do. Your flyer and letter really helped get the fundraising off to a good start, we've had donations coming in hand-over-fist. We want to make sure we are managing the money well. There is no use raising money if it is going to waste. I've heard that a spreadsheet might be the answer as it can perform calculations and update figures instantly. The problem is, I wouldn't know where to start. |
Task 1 Instructions
Using a spreadsheet
Jay needs to work out how much money the charity is spending on its day-to-day running costs. He has sent you a list of the current animals in the centre with information about how much they cost to feed each day.
Download the information and type it into a spreadsheet.
Adjust the fonts, row heights and column widths to make sure all the information is displayed.
Make sure you have used sensible headings for each column
Task 1 Files
download_list.jpg 
Task 2 Instructions
Using formulae
In the next available column, write in a formula that will work out the total spent per day on feeding all the big dogs.
Use a formula, don't just work it out yourself.
Copy down the formula so that it works out the amounts spent on the other animals
Task 2 Help
The inpictures website can help you with lots of different spreadsheet tasks
Task 3 Instructions
Using functions
Use the SUM function to total up all the money spent on all of the animals.
Use the ROUND function round the total cost to the nearest pound.
Task 3 Help
You could try this lesson from Office Online which shows how to use the ROUND function.
Task 4 Instructions
Formatting a spreadsheet
Format the spreasheet so that all of the CURRENCY items display with a pound sign. Screenshot how you do this.
Add borders and titles to make the spreadsheet easy to understand and to improve the way it looks.
Put the words ACCOUNTS, the date, and page numbers into the header
Save the spreadsheet and call it daily accounts
Task 4 Files
screenshots.doc 
Task 5 Instructions
Deleting rows
The work you have done so far is great but Jay needs to make some quick adjustment to the spreadsheet. The category "other animals" is too vague.
Delete the "Other Animals" row from the spreadsheet and shift cells up. Screenshot how to do this.
Task 5 Files
Task 6 Instructions
Inserting rows
Add two empty rows below the Guinea Pigs and shift the total down. Screenshot how to do this.
Now add the information
- Reptiles, 34, cost per day 0.90
- Birds, 26, cost per day 0.24
Save the spreadsheet and call it full animal list
Task 6 Files
Task 7 Instructions
What if...
The centre has been asked to take in a lot of big dogs from another centre which is closing down.
Jay is worried how much this will cost, and does not want daily costs to rise above £300.
Investigate how many large dogs the centre could take on without going above the £300 figure.
Save the spreadsheet and call it extra dogs
Task 8 Instructions
More formulae
Jay has realised that he has not taken fundraising into account on the spreadsheet. He need to know how much money is left over.
To do this you will need to include an area for fundraising on the spreadsheet. Download the information.
Find the total raised in the last month and work out using a formula how much this is per day.
Find the total remaining by subtracting the costs from the income.
Save the spreadsheet and call it Tilsham Trust funds
Task 8 Files
fundraising.jpg 
Task 9 Instructions
Subtitle here
Create a chart showing the total amount spent looking after each of the different types of animal.
Format the chart so that it has a correct title, and use colour in the chart to make it suitable for use in a newletter to customers.
Task 9 Help
You could try this lesson from Office Online which shows how to create a chart.
To make your chart look better, this lesson might help
Task 10 Instructions
Final Printing Checklist
Use Set Print Area and suitable landscape or portrait and print:
daily accounts spreadsheet
Screenshots showing currency formatting
full animal list spreadsheet
Screenshots showing delete row
Screenshots showing add row
extra dogs spreadsheet
Tilsham Trust funds spreadsheet
Tilsham Trust funds spreadsheet in formula view
the chart you have created
Task 10 Files
checklist.pdf
Task 10 Help
You can compare your work to this portfolio.
Thanks for your help so far, its time to move on. You can go straight to the next task from here See you there!
|
