Sign In
Sign In
Register for Free
PrimaryComputing

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

Key Stage

KS2

Age

Years 3-6

Subjects

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.

DOWNLOAD A FREE RESOURCE!
Computing KS2 lesson plan – Use Battleships to introduce spreadsheets and data handling
PrimaryComputing

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
17 x resource packs
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 resource packs
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 resource packs
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 resource packs
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 resource packs
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 resource packs