PrimaryComputing

Data handling KS2 – Use Battleships to introduce spreadsheets

What's included?

PDF lesson plan

Key Stage

KS2

Age

Years 3-6

Subjects

Introduce the concept of spreadsheets by playing a round of battleships with this data handling KS2 lesson plan…

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.

Data handling KS2 learning objectives

  • 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

Starter activity

To begin, introduce the concept of the game battleships. Explain that it’s a two-player game where each player guesses where the ships are on the other player’s grid, using coordinates to make their guess.

Give pupils the opportunity to play the game in pairs, using a small five-by-five grid. Write A-E along the top and 1-5 down the side. Children must draw one small boat (contained inside one square) and a larger boat spanning three squares.

They can now take it in turns to call out a coordinate to find their opponent’s ships. Pupils will need to mark their own hits and misses on their grid. The first player to sink all of the enemy ships wins


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.

Data handling KS2 lesson plan
DOWNLOAD A FREE RESOURCE!
Data handling KS2 – Use Battleships to introduce spreadsheets
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
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
21 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
7 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
WAGOLL Packs from Real Authors
Peer inside the mind of award-winning children's authors and help pupils understand how to create engaging characters, capti... more
13 x resources
Art KS2 inspiring medium term plans
Art KS2 Inspiring 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
11 x resources