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) |
AC9TDI10P02
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
AC9TDI10P03
Model and query entities and their relationships using structured data |
| Keywords | Data analysis, Spreadsheets, Problem-solving, Pivot tables |
| Organisation | ESA |
| Copyright | Creative Commons Attribution 4.0, unless otherwise indicated. |
Related resources
-
Everything you always wanted to know…
In this lesson sequence students design, build and evaluate their own database and perform queries and build reports based on that database.
-
A spreadsheet's secret weapon
In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.
-
Future proofing data
This lesson sequence aims to identify strengths and weaknesses of past, present and future methods of data storage and recognise the risks and benefits for users.
-
Seven seasons
In this lesson sequence students investigate the CSIRO indigenous seasons calendars and produce a searchable database that will capture data using two data sources.