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.
Additional details
| Year band(s) | 9-10 |
|---|---|
| Content type | Lesson ideas |
| Format | Web page |
| Core and overarching concepts | Data acquisition, Data representation, Data interpretation |
| Australian Curriculum Digital Technologies code(s) |
AC9TDI10P01
Develop techniques to acquire, store and validate data from a range of sources using software, including spreadsheets and databases
AC9TDI10P03
Model and query entities and their relationships using structured data |
| Keywords | Pivot tables, Summarising data, Spreadsheets |
| Organisation | ESA |
| Copyright | Creative Commons Attribution 4.0, unless otherwise indicated. |
Related resources
-
Classroom ideas F-10: Aboriginal and Torres Strait Islander connections to Digital Technologies
This resource provides examples of ways Aboriginal and Torres Strait Islander Histories and Cultures can be integrated into Digital Technologies. Examples include 'classification and sorting data' and 'designing solutions'.
-
Dynamic route planning
In this learning sequence, students think critically about the types of data artificial intelligence (AI) algorithms need to analyse for real-time traffic data.
-
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.
-
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.