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
Fire up KS2 pupils' imagination with this collection of 16 fictional stories, written by literacy expert Pie Corbett. Each r... more
16 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
5 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
6 x resources
Expert Medium-Term Science Plans for Primary
Sorting out your medium term planning for KS1 science and KS2 science? Let science experts such as Deborah Herridge and ment... more
6 x resources
Amazing Handwriting Worksheets for EYFS & KS1
Help your EYFS and KS1 pupils with their handwriting practice with these simple and eyecatching free printable handwriting w... more
21 x resources
Bumper Lesson Plan Templates Pack
Get your lesson plan done in a jiffy with this range of teacher-made printable lesson plan templates, including a 5 minute l... more
11 x resources