Skip to main content
ANNOUNCEMENT

Education recovery: Explore our curated collection of CPD, resources and support.
Online courses: FutureLearn are changing what data they store as part of GDPR on 20 Oct 2021. You may need to take action.

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 graphs and 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]