Spreadsheet modelling

Computing

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

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

a cell reference that changes when a formula is copied or replicated to another cell

a cell reference that remains constant no matter where it is copied or replicated

automatically break long text within a cell onto multiple lines

combining two or more adjacent cells into one larger cell

applies a style or format to a cell based on whether a cell matches a certain criteria

a tool that controls what kind of data can be entered into a cell

the rules set in data validation that decide what data is allowed in a cell

Data validation - whole number

a function that looks for a value in one column and finds matching information from the same row in another column

a function in a spreadsheet that checks if something is True or False

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

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

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

Primary

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Secondary

Year 7

Year 8

Year 9

Year 10

Spreadsheets

Choose a lesson (9)