Year 6
Year 6
Spreadsheets
Lesson 1 - Collecting Data
Learners will collect and organise data in a format of their choice. They will then explore how data can be structured in a table. Finally, they will input data into a spreadsheet.
To create a data set in a spreadsheet
● I can collect data
● I can suggest how to structure my data
● I can enter data into a spreadsheet
Lesson 2 - Formatting a spreadsheet
Learners will develop their understanding of the structure of a spreadsheet. They will be introduced to cell references, data items, and the concept of formatting cells. Learners will see data items formatted in different ways. They will then choose formats for data items before they apply formats in their own spreadsheets.
To build a data set in a spreadsheet
● I can explain what an item of data is
● I can choose an appropriate format for a cell
● I can apply an appropriate format to a cell