Sorting and searching data

Computing

Formatting data in a spreadsheet

Spreadsheet calculations

Collecting data for a purpose

Analysing and visualising 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

Applying a {{}} to data arranges it into a different order.

When a filter is applied to a data set the data that is filtered is removed permanently.

returns the lowest value in a range of cells

returns the highest value in a range of cells

returns the total value of a range of cells

returns the total number of non-empty cells in a range of cells

returns the total number of cells that meet set criteria

returns different things depending on a criterion

What is the function that adds up all the values in a selected range and then divides by how many items there are in the range?

What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?

Name the function that tells you the highest value in a range of cells.

Name the function that tells you the lowest value in a range of cells.

Name the function that tells you the number of non-blank cells.

Give the cell range for the first 10 cells of column B.

Give the cell range for all of the cells in column A.

Lesson video

File you will need for this lesson