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

Which of the following is NOT a key component of a spreadsheet model?

a rectangular box used in a spreadsheet to store data

a ready-made instruction that performs a specific mathematical job

Match the keywords to their correct definitions:

What is the purpose of spreadsheet formatting?

Type in the formula to subtract B5 from J2:

Type in the function to add cell A1 to A5.

Which symbol is used for addition in calculations?

Which symbol is used for division in calculations?

a set of instructions to perform a calculation

What is the purpose of tables in software?

This lesson was made for home learning during the pandemic.

Spreadsheet modelling

Lesson outcome

This lesson was made for home learning during the pandemic.