AC9TDI8P03

Acquiring, managing and analysing data

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

Elaborations

AC9TDI8P03_E1modelling 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_E2using a spreadsheet table to model objects and events, including choosing appropriate formats for each column, and filtering and sorting rows to answer questions
AC9TDI8P03_E3interpreting 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