week 6

2.6 Using data in digital support

2.6.1 Understand how tabular data is organised:

• worksheet

• row

• column.

2.6.2 Know the definition of validation checks and understand their purpose and when each is used:

• presence

• length

• range

• type

• format.

2.6.3 Know techniques to interrogate data and understand their purpose and when they are used:

• order by key field

• sort on a field(s)

• filter on field(s)

• arithmetic functions

• SUM, MIN, MAX, AVERAGE

• IF, COUNTIF

2.6.4 Be able to use techniques to interrogate data in spreadsheets.

2.6.5 Understand the purpose of saving data to and importing data from text-based files.

Last Updated
2025-06-05 09:28:49