Year 6 – Data and information - Introduction to spreadsheets
This unit introduces the learners to spreadsheets. They will be supported in organising data into columns and rows to create their own data set. Learners will be taught the importance of formatting data to support calculations, while also being introduced to formulas and will begin to understand how they can be used to produce calculated data. Learners will be taught how to apply formulas that include a range of cells, and apply formulas to multiple cells by duplicating them. Learners will use spreadsheets to plan an event and answer questions. Finally, learners will create charts, and evaluate their results in comparison to questions asked.
Formatting a spreadsheet
What's the formula?
Calculate and duplicate
Enjoyed teaching these lessons? Found a mistake?
Fill in a short form to give feedback on these resources.