AC9TDI8P03

See also: Learning Areas / Technologies / Digital Technologies / Processes and production skills / Acquiring, managing and analysing data / Years 7 and 8

model and query the attributes of objects and events using structured data

Elaborations

• AC9TDI8P03_E1 - modelling objects and events as structured data, that is, the attributes relevant to the task, for example products in the canteen and the sale of those products, with attributes such as the product name, price, quantity and nutritional value
• AC9TDI8P03_E2 - using a spreadsheet table to model objects and events, including choosing appropriate formats for each column, and filtering and sorting rows to answer questions
• AC9TDI8P03_E3 - interpreting and querying single-table databases using visual or simple SQL queries with SELECT, WHERE and ORDER BY clauses, for example answering queries in a database for a historical event

Achievement Standard Components

• ASTEC7803 - They acquire, interpret and model with spreadsheets and represent data with integers and binary.
• ASTECTDI7802 - Students acquire, interpret and model data with spreadsheets and represent data with integers and binary.