where different sets of input values are used within a spreadsheet to explore various potential outcomes

function used to count how many cells meet a set criterion

The COUNTIF function

British English CC

Spreadsheet project II

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 I

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

to test different input values and see possible outcomes

What is the main purpose of a spreadsheet model in what-if analysis?

to make data easier to understand and compare

Why would you use a chart in a spreadsheet model?

Which chart type is best for showing parts of a whole?

make recommendations based on the outcomes

Arrange these steps for modelling a scenario:

Put these steps in order for using COUNTIF in a spreadsheet:

What does the SUM function do in a spreadsheet?

What is a cell reference in a spreadsheet?

What formula would you use to find the mean value of the numbers in cells A1 to A20 in a spreadsheet?

If you want to highlight all cells with values over 100, what should you use?

Spreadsheet project II

Lesson outcome