Year 5 Data Handling (Teacher notes)
Pupil Activity Code: SVW4 – What is it?
Progression of skills in this pack
1. Select and use non-adjacent cells plus resize multiple cell widths and copy/paste cells (Activity 1)
2. Find data and create a spreadsheet to suit it. (Activity 2)
3. Use formulae to find totals, averages and maximum/minimum numbers (Activity 2)
4. Search a database for specific information. (Activity 3)
National Curriculum Content
Select, use and combine a variety of software (including internet services). 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. They are skills that should be performed regularly within different subjects.
Prior Learning
If pupils are new to using programs such as Excel, Numbers or Google Sheets then it is worth looking at ourĀ Year 4 Data Handling Activity Pack first, which covers creating spreadsheets and charts from data.Ā The activities below consolidates the skills in the year 4 pack and also introduces new ones such as usingĀ formulae.
š What will teachers and pupils need?
Pupils will need access to spreadsheet software such as Excel on Windows, Numbers on an iPad or Google Sheets (Chromebook).Ā
A route map of the Tour De France Map. One can be foundĀ here
Google MapsĀ website, foundĀ here and J2data website for activity 3.
Due to the different versions of Microsoft Office (Word, Excel, PowerPoint), it is a good idea to show pupils the help menu, to help locate tools.Ā
ā
Assessment
PupilsĀ should beĀ encouraged to save their spreadsheets and write down their answers for activity 3.
šĀ Unplugged Assessment Activity
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.
Activity 1 – Pixel Art in a Spreadsheet
Watch the video to learn how toĀ resizeĀ multiple cells at once then select non-adjacent cells (cells not touching each other) to create some pixel art.Ā
Begin by creating the scene from the tutorial below and then try creating your own pixel art.
Excel
Numbers (iPad)
Google Sheets
The Tour de France is a bike race around France (and nearby countries). Each part of the race is divided into stages between two places. In this project you are going to find the distances of the different stages create and spreadsheet with formulae to find different totals. Use the videos below to help you.
Excel
Numbers (iPad)
Google Sheets
2. Watch the video below to learn how to use the Tour De France map and Google Maps to find the distances of the different stages and add them to your spreadsheet.
Excel
Numbers (iPad)
Google Sheets
3. The video below shows how to addĀ formula to your cells to find the totals, including longest/shortest stage and stage average.Ā
Excel
Numbers (iPad)
Google Sheets
Watch the video above which talks about databases and how to search them to find specific information. Then answer the questions on the sheet below using the different databases on the J2Data website.
Answers
- Hong Kong
- Switzerland
- No
- Argentinosaurus
- Pantydraco
- Herbivorous
- Elizabeth Gladys āMillvinaā (first two records have age unknown)
- 3rd class
- Cherbourg