Skip to main content

Year 6

Data and information – Spreadsheets

Curriculum > KS2 > Unit

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.

Unit guide

Learning graph

Summative assessment

Summative answer

Help us make these resources better

Provide your feedback

Or email us at [email protected]