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.
Links to Learning Outcomes |
Links to Assessment criteria |
|
|---|---|---|