ACTDIP026

Analyse and visualise data using a range of software to create information, and use structured data to model objects or events

Elaborations

• using features and functions of software to summarise data to create information, for example calculating a simple budget of income and payments and creating a summary table for analysis (Skills: Literacy, Numeracy, Information and Communication Technology (ICT) Capability, Critical and Creative Thinking)
• visualising data to create information, for example identify trends and outlier data from spreadsheets using plots, or displaying geocoded data on a map (Skills: Literacy, Numeracy, Information and Communication Technology (ICT) Capability, Critical and Creative Thinking)
• applying a set of conditions to a spreadsheet to organise and filter data, for example using conditional formatting to highlight the state of particular cells, and filtering and sorting categorical data using column filters (Skills: Literacy, Numeracy, Information and Communication Technology (ICT) Capability, Critical and Creative Thinking)
• querying an existing database to extract data for analysis, for example devising multiple selection criteria or using simple structured query language (SQL) SELECT statements to select records and retrieve specified fields (Skills: Literacy, Numeracy, Information and Communication Technology (ICT) Capability, Critical and Creative Thinking)
• describing the attributes of complex objects, for example defining the records, fields, formats and relationships of a simple dataset (Skills: Literacy, Numeracy, Information and Communication Technology (ICT) Capability, Critical and Creative Thinking)
• modelling the attributes of real-world objects for a computer game (Skills: Literacy, Numeracy, Information and Communication Technology (ICT) Capability, Critical and Creative Thinking)

(View this topic on www.australiancurriculum.edu.au )