Professional Learning PDCS

Spreadsheets

Spreadsheets

Reception / Early Years

Create a simple pictogram using suitable software

Year 1

Record data collected in a suitable format - JIT CHART

Collate and group given data using simple words - JIT PICTOGRAM

Year 2

Record data collected in a variety of suitable formats - JIT CHART

Collect and organise data into groups - JIT PICTOGRAM

Year 3

Collect data, enter and begin to analyse data in a given format
Add information and create a graph

JIT Chart or Excel / Google Sheets / J2Office

Year 4

Begin to create data sets
Extract information from a given data set
Add information to a given spreadsheet

JIT Chart or Excel / Google Sheets / J2Office

Year 5

Create a a data set in excel with a range of simple formulas = sum + * - /
Explore patterns, relationships and change variables

JIT Chart or Excel / Google Sheets / J2Office

Year 6

Create a more complex data set
Formulas to include max, min, average
Make predictions about what would happen if you changed, perform change and record outcomes.

JIT Chart or Excel / Google Sheets / J2Office

Year 7

Use of complex formulae and formatting e.g. If, and conditional formatting.

JIT Chart or Excel / Google Sheets / J2Office

Page updated

Report abuse