Collecting data

Computing

Formatting a spreadsheet

Spreadsheet formulas

Using formulas in a spreadsheet

Event planning using a spreadsheet

Presenting data using charts

This unit introduces pupils to how spreadsheets can be used to organise data and create their own data sets. They will discover the importance of formatting data to support calculations, while also examining how formulas can be used to produce calculated data and how graphs can present this data.

Introduction to spreadsheets

a rectangular box in a spreadsheet used to store data

the way in which data is arranged and presented in a spreadsheet

working out an answer using numbers and mathematical operations

a mathematical action like adding, subtracting, multiplying, or dividing numbers

to make a copy or repeat something in the same way

a ready-made instruction that performs a specific mathematical job

a group of cells that are next to each other

a part of an overall total based on some of the values

a circular chart where sectors represent different groups in proportion to each other

Introduction to spreadsheets

Choose a lesson (6)