Introduce the concept of spreadsheets and data handling by playing a round of battleships…
Data handling in computing can often be overlooked, but it’s an important part of the KS1 and 2 curriculum. Furthermore, data handling skills provide so many cross-curricular links, the obvious example being numeracy (coordinates, for example).
This lesson is a fun way to introduce spreadsheet modelling skills to KS2 pupils before they progress to adding data and creating charts.
What they’ll learn
- Understand that a spreadsheet is made up of cells and that each cell has a reference
- Select a specific area of cells
- Adjust the colour and outline of a cell
- Find the correct cell reference when asked
- Type letters into cells
This download contains
- Full PDF lesson plan
Adam Foster is an experienced primary school computing teacher and education author. He launched iLearn2.co.uk in 2016 to help teachers and pupils with primary computing skills. Follow Adam on Twitter at @ilearn2primary.

Similar resources
- KS1/2 computing lesson plan – Create your own mobile style games
- Roman Mosaics and Computing Worksheets for KS2 Computing
- Sherlock Syllogisms Puzzles Worksheets for KS2/3 Computing
- Code-Cracking Puzzles Worksheets for KS2 Computing
- Computational Thinking: Pixel Puzzle Pictures Worksheets for KS2 Computing