Modelling Data - Spreadsheets

Emerging: I can identify the reference of a cell. I can add simple data into a spreadsheet that I have collected myself.

Developing A: I can collect some data of my own and input it into a spreadsheet. I can colour format cells in order to make my spreadsheet clear.

Developing B: With support I can apply a formula to do a calculation using some data I have collected myself. I can create a chart and filter my data.

Mastery: I can collect and display data, formatting cells suitably (including conditional formatting). I can use filtering, formula and functions to perform tasks, including countif. I can create a suitable chart that answers a question.

Greater Depth: Mastery plus - Mastery plus the ability to use more complex formula confidently, using formula to clarify and organise my data.

Week 1:

• Identify columns, rows, cells, and cell references in spreadsheet software

• Use formatting techniques in a spreadsheet

Week 2:

• Use basic formulas with cell references to perform calculations in a spreadsheet (+, -, *, /) 

• Use the autofill tool to replicate cell data

Week 3:

• Explain the difference between data and information

• Explain the difference between primary and secondary sources of data

• Collect data

Week 4:

• Analyse data

• Create appropriate charts in a spreadsheet

• Use the functions SUM, COUNT, MAX, and MIN in a spreadsheet

Week 5:

• Analyse data

• Use a spreadsheet to sort and filter data

• Use the functions AVERAGE, COUNTIF, and IF in a spreadsheet

Week 6:

• Use conditional formatting in a spreadsheet

• Apply all of the spreadsheet skills covered in this unit