That Blue Square Thing
Year 7 Computing – Spreadsheets
Fomrulas and functions in spreadsheets
There are all sorts of interesting things you can do in spreadsheets.
Lighthouse spreadsheets
We might use these first...
Making a Lighthouses Spreadsheet
The music store spreadsheet
The Shakes are a band. They sell their music in their online store.
This spreadsheet will help them work out how much money they've made.
You need to download the spreadsheet first.
Then there are things to do with it.
The merch spreadsheet
The Shakes also sell merch.
This spreadsheet has some different skills...
Then there are things to do with it.
Olympic medals
Spreadsheets can be really useful when you're trying to deal with lots of numbers...
Instructions for sorting and filtering: