Seeing the wood for the trees

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

Additional details

Year band(s) 9-10
Content type Lesson ideas
Format Web page
Core and overarching concepts Data acquisition, Data interpretation
Australian Curriculum Digital Technologies code(s)

Analyse and visualise data interactively using a range of software, including spreadsheets and databases, to draw conclusions and make predictions by identifying trends and outliers


Model and query entities and their relationships using structured data

Keywords Data analysis, Spreadsheets, Problem-solving, Pivot tables



Creative Commons Attribution 4.0, unless otherwise indicated.