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

Improving a spreadsheet model

Computing

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?

Introduction

What will you need for this lesson?

Are you ready to learn?

Files you will need for this lesson

Equipment

Worksheet