Below are some techniques that are suitable for projects at different NCEA levels for Data Modelling and spreadsheets.
Basic (Level 1)
- Basic Functions and formula
- Sum
- Count
- Count if
- If
- Average
- Min
- Max
- Modifying Data types
- printing – page setup features
- Logical operators
- Graphs and charts
- Table
- Basic filters
Advanced (Level 2)
- Sort / Filter
- Text manipulation formulae
- Mail merge
Complex (Level 3)
- Managing multiple worksheets
- Lookup tables
- Financial formulae
