ACARA 9-10 Digital Technologies: Interactive charts, dashboards and conclusions
Students build formula-driven interactive charts and a dashboard with drop-downs, named ranges and form controls, then check them and communicate evidence-based conclusions.
One content description (AC9TDI10P01, AC9TDI10P02, AC9TDI10P07) from the full ACARA Digital Technologies Years 9–10 — Analysing and Visualising Data journey. All 15 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (15)
1
Referencing a cell on another worksheet
2
Drop-down list validation in a spreadsheet
3
Named ranges
4
A drop-down list as a chart selector
5
Feeding a chart from a selected cell with INDEX and MATCH
6
Option buttons and combo boxes as form controls
7
Scroll bar and spin button form controls
8
A chart title linked to a cell
9
Charting a filtered table
10
Mock-up of a data visualisation
11
Laying out a dashboard sheet
12
Confirming charts and graphs represent the data
13
Describing a trend in a sentence with evidence
14
Drawing conclusions from data
15
Communicating insights to an audience
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →