Refine by resource type
Refine by year level
Refine by learning area
Refine by topic
Related topic
Digital technologies / Year 9 and 10 / Digital Technologies Processes and Production Skills
Curriculum content descriptions
Analyse and visualise data to create information and address complex problems, and model processes, entities and their relationships using structured data (ACTDIP037)
Elaborations
- using visualisation software tools to identify patterns and relationships between sets of data and information, and support abstract reasoning, for example representing data using histograms, network diagrams and maps
- summarising data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases
- automating calculations, for example using absolute cell referencing to automatically extend formulas, and automating arithmetic calculations using built-in functions such as trigonometry, compound interest
- simulating simple, iterative processes, for example modelling compound interest or ecological models using a spreadsheet
- documenting the attributes of complex objects and processes using a data dictionary
- interpreting schemas that represent relationships between entities and querying data across tables, for example using foreign keys to represent relationships and joining tables in structured query language (SQL) SELECT statements
General capabilities
ScOT terms
Data representation, Data analysis, Problem solving, Information management, Data storage