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
  • Literacy Literacy
  • Numeracy Numeracy
  • Critical and creative thinking Critical and creative thinking
  • ICT capability Information and Communication Technology (ICT) capability
ScOT terms

Data representation,  Data analysis,  Problem solving,  Information management,  Data storage

Audio

Faith Lutheran College – Podcast

This podcast includes information about the aims, challenges, insights and accomplishments of Faith Lutheran College's participation in the Digital Technologies in Focus project.

Text

Faith Lutheran College – PL ecosystem

This document illustrates the network of people and resources that make up Faith Lutheran College's Professional Learning ecosystem.

Text

Faith Lutheran College – Project proposal

This PDF outlines Faith Lutheran College's proposal to participate in the Digital Technologies in Focus project.

Video

Expert webinar video: Jennifer Hemer: Tasmanian Smart Seafood Partnership

Jennifer Hemer from Natural Resource Management Tasmania explains what's happening in the seafood industry in her state and how digital technologies are used to make the industry more sustainable.

Video

Expert webinar video: Professor Tim Bell – Computational thinking

In this video, Professor Tim Bell discusses helpful ways of understanding and teaching computational thinking, a key idea of the Australian Curriculum: Technologies.

Text

Australian Curriculum: Digital Technologies key concepts mapping - Years 9 and 10

This PDF uses colour coding to provide a line of sight between key concepts, content descriptions and achievement standards in the Digital Technologies subject in the Australian Curriculum.

Text

Australian Curriculum: Digital Technologies: years 9-10

This PDF provides a line of sight from content descriptions to achievement standards in the Digital Technologies subject in the Australian Curriculum.

Text

Australian Curriculum: Digital Technologies Years 7–10 achievement standards and aligned content descriptions on a page

This PDF presents content descriptions and achievement standards for the Digital Technologies subject in the Australian Curriculum

Text

ACARA sample assessment task: years 9-10

This resource provides strategies for assessing students' ability to interpret, process, analyse and represent data using spreadsheets, pivot tables, plotting data and scripting activities. A link to a data set from a koala hospital provides extensive data for students to use. The resource includes maps, graphs and charts, ...

Text

Years 9–10: Data science skills

This unit introduces data science as a process, focusing on specific skills used in data science. These include the acquisition of data from surveys, sensors or online repositories; storage and analysis of that data; and its visualisation, including with interactivity. When acquiring and analysing data, students can apply ...

Text

Visualising climate change | The GiST

In this STEM lesson students explore local temperature and rainfall datasets over time and represent trends in innovative ways.

Online

Filter bubbles, bias, rabbit holes and nudging

This lesson focuses on the AI systems that recommend content in various applications that students use on a day-to-day basis. It draws on students’ ethical understandings during analysis of these systems. This lesson was developed by the Digital Technologies Institute in collaboration with the Digital Technologies Hub.

Assessment

Assessment resources

Browse assessment resources.

Online

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

Online

Who wants to be a millionaire?

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

Online

Spreadsheets come alive

In this lesson sequence use the ‘Odds and evens’ problem as a springboard. Students construct interactive spreadsheets designed to address particular needs. This lesson also demonstrates an approach to programming known as rapid application development (RAD).

Online

A spreadsheet's secret weapon

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

Online

Coding a sentimental chatbot in Python

Incorporating 11 tutorial videos and two informative lecture videos, this learning sequence explores natural language processing, a significant application of artificial intelligence. Teachers and students are led through the coding in Python of a chatbot, a conversational program capable of responding in varied ways to ...

Online

Book analysis with AI techniques

This learning sequence explores text analysis through Natural Language Processing, a significant application of Artificial Intelligence. Teachers and students are led through a series of video tutorials to develop a Python program that can break down and analyse the content of a complete text and use smart sentiment analysis ...

Online

Seeing the wood for the trees

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.