Sign In
Sign In
Register for Free

Computing KS2 lesson plan – Use Battleships to introduce spreadsheets and data handling

Key Stage



Years 3-6


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 in 2016 to help teachers and pupils with primary computing skills. Follow Adam on Twitter at @ilearn2primary.

Computing KS2 lesson plan – Use Battleships to introduce spreadsheets and data handling

You'll also receive regular updates from Teachwire with free lesson plans, great new teaching ideas, offers and more. (You can unsubscribe at any time.)

Which sectors are you interested in?

By signing up you agree to our Terms & Conditions and privacy policy

Explore teaching packs

Pie Corbett Ultimate KS2 Fiction Collection
Pie Corbett Ultimate KS2 Fiction Collection
Fire up KS2 pupils' imagination with this collection of 20+ fictional stories, written by literacy expert Pie Corbett. Each ... more
20 x resources
Pie Corbett KS2 Non-Fiction Collection
Use Pie Corbett’s non-fiction texts to inspire your KS2 pupils to get writing. Each resource contains an original text in ... more
6 x resources
Pie Corbett KS2 Poetry Collection
Inspire KS2 pupils to be creative and express themselves with this pack of Pie Corbett poetry. Each of these Pie Corbett Tal... more
7 x resources
WAGOLL classroom resources
Expert WAGOLL Packs from Real Authors
Peer inside the mind of award-winning authors and help pupils understand how to create engaging characters, captivating atmo... more
4 x resources
Inspiring KS2 Art Medium Term Plans
Get pupils' creative juices flowing with these expert medium-term art plans for KS2. Each resource consists of a full half-t... more
6 x resources
Magical Harry Potter Teaching Ideas
Magical Harry Potter Teaching Ideas
Spark pupils' imaginations with these inventive and exciting teaching ideas, all themed around the wonderful world of Harry ... more
12 x resources