Year 4 Data Handling – teacher notes
Pupil Activity Code: DHQ4 – What is it?
Progression of skills in this pack:
1. Change appearance of cells in a spreadsheet (fill colour and border) then add and align text. (Activity 1 and 2)
2. Find and add data to a spreadsheet, resize cells and use the software to create a suitable chart with a title. (Activity 3)
National Curriculum Content
Collecting, analysing, evaluating and presenting data and information.
3-4 hours
Introduction
Data Handling has been an ever-present in the ICT/Computing curriculum for many years. It is a skill that should be performed regularly within different subjects.
What will pupils and teachers need?
Pupils will need access to spreadsheet software such as Excel on Windows, Numbers on an iPad or Google Sheets (Chromebook).
The 3 activities below with video tutorials for each software (Excel, Numbers for iPad and Google Sheets) depending on which pupils have access to in school.
Pupil activity 3 below requires pupils to have completed task 1 of the Internet Research Activity Pack (finding mini-beast data) and this mini-beasts website.
Teacher Input
The video below introduces spreadsheets and different types of charts and why we use them (the video is also included in the pupil activity pack). You may wish to show pupils the video tutorials from the Pupil Activity Pack below before they begin each activity.
🚦 Differentiation
Less able pupils may need need to buddy up with a partner to find the data and with more able pupil for Battleships activity below.
✅ Assessment
Pupils should be encouraged to save their spreadsheets Excel, Numbers or Google Slides.
📝 Unplugged Assessment Activities
Below is a downloadable and printable activity sheet/cards that can be used to assess pupil understanding of the vocabulary and application of the skills, either individually or as a group task/extension task.
🏅 Certificates
Below is a certificate of completion for pupils that can be edited in Microsoft Word and printed. This could be awarded if you feel pupils have demonstrated the skills taught in the activities below.
Pupil Activity Pack (Teacher view)
Pupil Activity 1. Battleships Game
In this first video, it demonstrates how to make and play a 2 player battleships game. You will need to have a partner who creates a spreadsheet the same as yours but with battleships in difference places. You also need to make sure you cannot see each other’s screens.
Excel
Numbers (iPad)
Google Sheets
This activity demonstrates how to make a single or multi-player game to help learn times tables.
Watch the videos below to help you set up and play the game
Excel
Numbers (iPad)
Google Sheets
2. Add numbers in the times table you are learning to each of the cells on the pitch. This example uses the 4 times table and you can go up to 6x or 12x. For this example, it goes up to 6×4.
Once you have added all the numbers, you can highlight all the cells and centre align plus add borders.
Excel
Numbers (iPad)
Google Sheets
3. To play the game use a dice (either a real dice or you could use this website). If your times table only go up to 6 x (e,.g 4×6=24 in this example) then only roll the dice once. If you go up to 12x then roll it twice.
– Start by selecting the goal cell at the bottom of the pitch.
– Multiply your times table number by the number on the dice and if the answer is on the row above your cell you can move it. If the answer is not in the row above, you roll again.
– Once you reach the top row, keep rolling dice until you roll a 6 to score a goal.
– You could time yourself using an online stopwatch. Just Google ‘online stopwatch.’
Excel
Numbers (iPad)
Google Sheets
4. To play the 2 player version, fill the goals two different colours and the objective is to take it in turns to get your colour to your opponent’s goal then roll a 6 to score a goal.
Excel
Numbers (iPad)
Google Sheets
Pupil Activity 3. Minibeasts Activity
Use the skills you have gained from the Battleships activity to create a table of different minibeasts, put the different habitats in the A column and the number of insects that live there in the B column (insects can be in more than one habitat). You will need access to this mini-beasts website.
Then use the video below to create a chart of your table. What title could you give it?
Excel
Numbers (iPad)
Google Sheets