AC9TDI10P03
Year 9
Technologies
AC9TDI10P03 – Year 9 Technologies: Acquiring, managing and analysing data
Strand
Processes and production skills
Substrand
Acquiring, managing and analysing data
This Content Descriptor from Year 9 Technologies provides the specific knowledge and skills students should learn. Use it to plan lessons, create learning sequences, and design assessments that align with the Australian Curriculum v9.
Content Description
model and query entities and their relationships using structured data
Elaborations
-
1
modelling entities and processes, their attributes and the relationships between them, for example creating database tables for a movie, a user and their movie review, where a movie has a title, genre and release date, and a review has a movie, a user and their rating and comments
-
2
using structured data to help in decision-making, for example creating a data schema for a relational database and building the database, incorporating query and reporting functionality to solve a problem of student choice
-
3
interpreting and querying multi-table databases using SQL queries with SELECT, WHERE and simple JOIN/GROUP BY clauses and counting, for example checking that each user has only reviewed each movie once
Related Achievement Standards