TeaCheese Achievement Standards Content Descriptors Blog About
Descriptors›Technologies›Year 9›Processes and production skills›Acquiring, managing and analysing data›AC9TDI10P03
AC9TDI10P03: Year 9 Technologies Content Descriptor – Acquiring, managing and analysing data
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 Descriptor

model and query entities and their relationships using structured data

Elaborations

  • • 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
  • • 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
  • • 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

Achievement Standard This Supports

This Content Descriptor contributes to the following Achievement Standard:

Year 9 ASTECTDIY910
Year 9 Technologies Achievement Standard
By the end of Year 10 students develop and modify innovative digital solutions, decompose real-world problems, and critically evaluate alternative solutions against stakeholder elicited user stories. Students acquire, interpret and model complex data with databases and represent documents as content, structure and presentation. They design and validate algorithms and implement them, including in an object-oriented programming language. Students explain how digital systems manage, control and secure access to data; and model cyber security threats and explore a vulnerability. They use advanced features of digital tools to create interactive content, and to plan, collaborate on and manage agile projects. Students apply privacy principles to manage digital footprints.