Learning Intention: Can I create a spreadsheet to help with finances?
Success Criteria:
I can download a spreadsheet and understand how to format
I can insert the shop data
I can create formulas to calculate the total costs
I can create graphs that show this information
I can download a spreadsheet and understand how to format
Your teacher will show you how to create a spreadsheet like this:
Tools you will use next week when you create your own:
BORDERS
Cell Colour
I can insert the shop data + I can create formulas to calculate the total costs
You can just type numbers into a spreadsheet
If you want it to do Maths you have to put in a formula - Every formula starts with an = sign
FIXED COSTS + Formulas
FIXED COSTS - A cost that is the same each week
Website cost = 50 per week
Adverts = 30 per week
Formula answers
VARIABLE COSTS + Formulas
Variable Costs - A cost that changes depending on how many products you buy or sell
Standard FS = 3
Flashing FS = 5
FS Sold
Week 1: 8 Standard & 4 Flashing
Week 2: 6 Standard & 5 Flashing
Week 3: 10 Standard & 5 Flashing
Week 4: 7 Standard & 7 Flashing
Formula answers
Total Variable costs:
Can you work out what formulas you need to put into the totals?
Formula answers
Finished Spreadsheet - Results
Finished Spreadsheet - Formulas
Extension - Making a graph
I can create graphs that show this information
Step 1: Highlight the weeks and the weekly total costs
(Highlight the weeks and then hold CTRL and highlight the weekly costs)
Step 2: Click on Insert and then Column Chart
(See picture below for help)