Elaboration (2) ACTDIP037
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
Elaboration (2) | ACTDIP037 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (3) ACTDIP037
simulating simple, iterative processes, for example modelling compound interest or ecological models using a spreadsheet
Elaboration (3) | ACTDIP037 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (2) ACTDIP041
considering different algorithms and selecting the most appropriate based on the type of problem, for example choosing appropriate algorithms for particular problems
Elaboration (2) | ACTDIP041 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration ACTDIP040
designing algorithms to solve real-world problems and describing algorithms using flow charts and structured English, for example START, END, IF and UNTIL
Elaboration | ACTDIP040 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (2) ACTDIP040
tracing algorithms to predict results and program state for a given input, for example desk checking or using an interactive debugging tool
Elaboration (2) | ACTDIP040 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (3) ACTDIP040
using tracing techniques to test algorithms, for example desk checking an algorithm for a given input by stepping through the algorithm while keeping track of contents of the variables
Elaboration (3) | ACTDIP040 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (1) ACTDIP037
summarising data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases
Elaboration (1) | ACTDIP037 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (5) ACTDIP037
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
Elaboration (5) | ACTDIP037 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (3) ACTDIP041
selecting different types of data structures such as an array, record and object to model structured data
Elaboration (3) | ACTDIP041 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration ACTDIP037
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
Elaboration | ACTDIP037 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (2) ACTDIP044
investigating indicators of economic success, for example the capacity to scale up an innovative solution to meet the demands of a mass market and the savings accrued through sustainable practices
Elaboration (2) | ACTDIP044 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (3) ACTDIP036
extracting specific data from an external source and storing it in a format that is more useful for analysis, for example combining mapping data from multiple electronic data sets to build a composite representation
Elaboration (3) | ACTDIP036 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (1) ACTDIP038
investigating different types of functional requirements for solutions, for example increasing the speed of processing, calculating new results, improving the quality of reports
Elaboration (1) | ACTDIP038 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (5) ACTDIK034
explaining encryption of data as a means of protecting data, for example secret keys and ‘exclusive or’ (XOR) and hashing algorithms to digitally sign data
Elaboration (5) | ACTDIK034 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration ACTDIK035
explaining how simple compression schemes reduce the size of repetitive data, for example how run length encoding reduces the size of images
Elaboration | ACTDIK035 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration ACTDIP036
developing strategies and techniques for capturing accurate and usable qualitative and quantitative data of different formats, for example using text entry for open-ended questions to acquire qualitative data; using radio buttons or checkboxes for closed …
Elaboration | ACTDIP036 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (1) ACTDIP036
identifying strengths and weaknesses of collecting data using different methods, for example online surveys, face-to-face interviews, phone interviews, observation, blog entries in response to a posting, phone logs, browser history and online webcam …
Elaboration (1) | ACTDIP036 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum
Elaboration (2) ACTDIP036
developing strategies to ensure the privacy and security of survey data, for example using numbers rather than names as identifiers; password protecting files to reduce risks of modifying data and using CAPTCHA™ to confirm human responses
Elaboration (2) | ACTDIP036 | Content Descriptions | Years 9 and 10 | Digital Technologies | Technologies | F-10 curriculum