Introduction

Students will again need access to the Activity Sheet in this lesson.

Some short written tasks should also be completed on the Student worksheet for this lesson. You can provide your students with paper copies or make a copy of the sheet yourself and share it with them as an assignment in Google Classroom, so they have their own editable digital copy.

 

The purpose of this lesson is to look at spreadsheets as ways to sort and organise information into useful and more meaningful data sets.

For these exercises you will need to be able to move between the presentation and the example spreadsheet.  If you are using Windows, then you can arrange the screen to show both windows at the same time. 

Open the Teacher’s presentation and the Demonstration Spreadsheet in different windows, not as tabs in the same window (you can drag a tab into a new window by simply clicking the tab and dragging it down and away from the other tabs). 

Select one of the windows and hold the Windows key +left/right arrow key. See HERE for more detailed instructions.

 

 

You should now be able to work through the presentation and demonstrate using the spreadsheet.

Begin with a quick vocabulary check.  Ask: Can you define the terms on the presentation and remember any others?

 

Sorting data

The slide titled 'What next?' asks the class a number of questions which they should be able to offer suggestions to by the end of the lesson.  Explain that all of the examples you show today and all of the practice they complete will help them answer these.

Examples of when sorting would be carried out in school might include

E.g. Sorting children

• into classes
• into school meals and packed lunches
• Children into family groups for school photos etc.

In ‘Demonstration spreadsheet activities’ open the tab ‘Sample Data’ and discuss the question in the presentation.  Ask the class:

• What does this spreadsheet show us?
• Is there any data  missing? They might spot that there were no World Cups between 1938 and 1950 due to World War 2. The 2022 Qatar World Cup is also not included.
• Who might use this information?
• Is it well organised?
• How else could we organise this data?

This world cup data can be viewed on one sheet and we could scan the information to find the biggest / smallest / earliest but in huge data sets that cover thousands of rows or columns that’s not possible.

Model how to sort the data in column I showing goals scored, from the smallest to the largest number.  Following the instructions in the spreadsheet and recap with the screen recording demonstration to reinforce.

 

 

Ask the children to lead you through a new sort.  Sort column F, showing average attendance from largest to smallest.  Can the children suggest any other ways of sorting the data?

 

Main tasks

Ask the children to open the Activity sheet and open the demonstration spreadsheet ‘Students 'Series 20' to copy’.

When the children students have clicked on the link they will need to make a personal copy.

Select File and then choose ‘Make a copy’ from the menu.  This will create a personal version that can be edited by each student.

 

 

Give the class some time to complete Task 1 and 2 in the Activity sheet.

Talk through some of the answers the children found and model their sorting on the Demonstration Spreadsheet.

 

Ask the class to then complete Task 3 in the Activity sheet.

Ask all the children to open the animation tab from their Lesson 3 spreadsheet.

 

 

Explain that the sheet shows data for 50 animated films.  It shows the amount of money each film made.  The sheet can be sorted in a different way to show when the films were released.

Ask the children to sort the ‘Animation’ spreadsheet to answer each question in turn. They should record their answers on their Student worksheet.

Work alongside them modelling each search.

 

Answers (also displayed on the presentation).

1. Which film had the lowest peak?

How to Train Your Dragon: The Hidden World

2. Which film was released first and what was the year?

The Lion King (1994 original), 1994

3. How many films peaked at 10 and what are they called?

1, Inside Out

4. How many films in the list begin with the letter 'T'?

5. How do we sort the table to get back to the original view?

Select the whole sheet, choose ‘Data’ from the menu then select ‘Sort range’ from the menu, tick ‘Data has a header row’, Sort by ‘Rank’ A-Z.

 

Plenary

Revisit the questions from the beginning of the lesson, can the children suggest answers to them now?

• How would you organise a column of numbers from smallest to largest?
• Why would you need to do this?
• When would a hospital administrator do this?