a set of data, formulas and calculations used to test different situations

Improving a spreadsheet model

Computing

Spreadsheet modelling

Formulas in a spreadsheet model

Formatting in a spreadsheet model

Data validation in a spreadsheet model

Lookup and reference functions

Visualising data using charts in a spreadsheet

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

Why are spreadsheet models important for real-world scenarios?

What is a recorded set of steps in a spreadsheet that can be repeated automatically?

Match the following examples with their purposes:

How can a macro be assigned for easy access?

Macros can be assigned to buttons for easy access.

Macros improve efficiency in spreadsheet models.

Which of the following statements about macros is incorrect?

What is one way charts improve data presentation?

Which chart is best for showing changes over time?

to explain the chart’s colours or symbols

What is the purpose of a legend in a chart?

Improving a spreadsheet model

Lesson outcome