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

What is a line of data running horizontally called?

Why are column labels important in a table?

Put these actions in the order they should be done:

What tool do you use to type information on a computer?

What tool do you use to select objects on a computer screen?

Which application is used for writing documents?

Which of these is a way of organising information?

This lesson was made for home learning during the pandemic.

Collecting data

Lesson outcome

This lesson was made for home learning during the pandemic.