Year 6 – Data and information - Introduction to 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

Updated: 10 Feb 2023

Learning graph

Updated: 10 Feb 2023

Summative assessment

Updated: 10 Feb 2023

Summative answer

Updated: 10 Feb 2023


Lesson 1

Collecting data

Lesson 2

Formatting a spreadsheet

Lesson 3

What's the formula?

Lesson 4

Calculate and duplicate

Lesson 5

Event planning

Lesson 6

Presenting data