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. Students should have prior experience creating a flat file database.
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) |
AC9TDI10P01
Develop techniques to acquire, store and validate data from a range of sources using software, including spreadsheets and databases |
Keywords | Database, Database evaluation, Data collection, Manipulation of data |
Organisation | ESA |
Copyright | Creative Commons Attribution 4.0, unless otherwise indicated. |
Related resources
-
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.
-
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.