Digital Technologies / Levels 9 and 10 / Data and Information
Content description
Analyse and visualise data to create information and address complex problems, and model processes, entities and their relationships using structured data
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
