a predefined formula that performs a calculation

Analysing and visualising data

Computing

Formatting data in a spreadsheet

Spreadsheet calculations

Collecting data for a purpose

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

Which of these is used to visualise information as a picture?

Which of these functions would you use to add up a range of numbers?

What function would you use to find the smallest value?

Which of the following are acceptable cell references?

Facts and figures that have been organised so that they have meaning is the definition of __________.

A school publishes a report on the number of students who are entitled for free school meals. Is this primary or secondary data?

The government issues leaflets containing new health and nutrition guidelines published by researchers in France. Is this primary or secondary data?

{{}} is raw facts or figures without any meaning.

Lesson video

File you will need for this lesson