Visualising data using charts in a spreadsheet

Computing

Spreadsheet modelling

Formulas in a spreadsheet model

Formatting in a spreadsheet model

Data validation in a spreadsheet model

Lookup and reference functions

Improving a spreadsheet model

Spreadsheet project I

Spreadsheet project II

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer “what if…?” questions.

Spreadsheets

Which chart is best for showing parts of a whole?

What type of chart is best for showing trends over time?

What is the best chart for comparing multiple categories?

Match the following examples with the correct chart type:

Arrange the steps to create a chart into the correct order:

Write the formula to calculate the average of the values in cells A1 to A5.

to retrieve data from another sheet based on a matching value

What is the purpose of the VLOOKUP function?

What does the IF function do in spreadsheets?

What is the role of a function in spreadsheets?

What is a key benefit of using functions in spreadsheets?

What spreadsheet feature changes the appearance of cells based on rules?

Starter Quiz

Write the formula to calculate the average of the values in cells A1 to A5.