data that has been given structure or meaning

Collecting data for a purpose

Computing

Formatting data in a spreadsheet

Spreadsheet calculations

Analysing and visualising data

Sorting and searching data

Applying conditional formatting to data

By the end of this unit pupils should be able to model data within a spreadsheet. Pupils will progress from using basic formulas to using inbuilt functions. Pupils will apply sorting and searching techniques to data and explore how conditional formatting can be used to present data effectively.

Data modelling

facts and figures that have been organised so that they have meaning

data that you have collected and that you are using yourself

data that somebody else collected and that you are using

You are using government statistics on how many children have smartphones. What is this is an example of?

You create a poll you give to your class to ask if they have a smartphone. This is {{}} data.

needed to do a calculation, must start with the = symbol

the location of a cell, made up of a column name and a row number

a tool that fills the selected cells with repeating values

Match the keyword to the correct definition.

This lesson was made for home learning during the pandemic.

Collecting data for a purpose

Lesson outcome

This lesson was made for home learning during the pandemic.