British English CC

Formatting a spreadsheet

Computing

Collecting data

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 rectangular box in a spreadsheet used to store data called?

to ensure that data is displayed correctly

Why is it important to format cells in a spreadsheet?

What should you do if spreadsheet software doesn't format data correctly?

Order these steps for formatting a cell in a spreadsheet.

a line of data in a table that runs from left to right

a group of data in a table that runs from top to bottom

where the doors and windows are in the room

How can you tell where things are kept in the classroom?

In a spreadsheet, what is used to organise data in a group running from the top to the bottom?

What is a line of data in a spreadsheet that runs from left to right?

Lesson video

File you will need for this lesson