a rectangular box that holds data in a spreadsheet

a vertical group of cells that runs from the top to the bottom

a horizontal line of cells that runs from left to right

modifying the appearance of data in a spreadsheet

Formatting data in a spreadsheet

Computing

Spreadsheet calculations

Collecting data for a purpose

Analysing and visualising data

Sorting and searching data

Applying conditional formatting to data

By the end of this unit pupils should be able to model data within a spreadsheet. Pupils will progress from using basic formulas to using inbuilt functions. Pupils will apply sorting and searching techniques to data and explore how conditional formatting can be used to present data effectively.

Data modelling

a horizontal group of cells that runs from left to right

What is the cell range of these highlighted cells?

There is a column of houses and vertical rows outside the town hall

There is a row of houses and vertical columns outside the town hall

There is a row of houses and vertical rows outside the town hall

There is a column of houses and vertical column outside the town hall

Which one of these statements make sense?

write everything in random places on the page

write everything in big circles and colour them in

write everything in a list with the most important thing to do at the top

If you are writing a list of things you need to do, so you don’t forget them. What is the best way to keep the list organised?

In the data: 34, 87, 21, 39, 34, 73 and 20, which is the highest value?

use a highlighter to colour the background of your favourite

write the title of your favourite book twice

write your favourite book in very small letters

draw a picture of the book next to each title

If you want to make a list of your favourite books, but also want to show which one is your absolute favourite, what could you do?

write it using the same style as the rest of the text

You are designing a poster for a school event. How could you make the title stand out?

A {{}} is a software tool used to store and analyse data.

Formatting data in a spreadsheet

Lesson outcome