something that will stay the same no matter how many people attend the event

changes depending on how many people attend the event

the amount of money made after subtracting all costs from total revenue

occurs when total costs are greater than total revenue

the point at which the total revenue equals total costs

Spreadsheet project I

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

Improving a spreadsheet model

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

What is a key benefit of using a spreadsheet model for an event?

What does “break-even” mean in the context of an event?

Which formula could calculate profit in a spreadsheet?

What formula would you use in a spreadsheet to find the mean average of values in cells C1 to C10?

spreadsheets can predict and model costs before the event

spreadsheets can only be used after the event to record costs

Which statement is correct about using spreadsheets for event planning?

What does the fill handle do in a spreadsheet?

What spreadsheet formula would you use to multiply the value in cell A2 by the value in cell D10?

Match each formatting feature to its purpose:

What spreadsheet formula would you use to add together the values in cells A1 to A5?

Arrange these steps for using conditional formatting:

a set of data and formulas to test scenarios

Spreadsheet project I

Lesson outcome