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'.
-
Build a webpage
In this introduction to web development with HTML and CSS for beginners, you will learn how to structure and style webpages with images, lists, fonts, quotes, links, and animation.
-
Bird watch website 3.0
These Sushi Cards will show you how to make a website look polished and professional using cool effects and layouts.
-
Bird watch website 2.0
Build upon your existing HTML/CSS skills to make a website and gain more control over how it looks. Apply this to the first website you built in Bird watch website 1.0.
-
Bird watch website 1.0
Build a website like the example provided viewed using trinket. Trinket is a free downlaodble app that lets you run and write code in any browser, on any device.
-
Web design
Build websites and apps by learning HTML, CSS, and JavaScript. Projects for beginners and intermedaite learners.
-
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.