← All Journeys

ACARA 7-8 Digital Technologies: Spreadsheet formulas and tools for data

Students learn to use formulas, functions, sorting and filtering to summarise and examine stored data.

One content description (AC9TDI8P01) from the full ACARA Digital Technologies Years 7–8 — Acquiring and Storing Data journey. All 10 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.

Modules (10)

1 Formulas start with = 2 Copying a formula down a column 3 Absolute cell references with $ 4 The MIN and MAX functions 5 The COUNT function 6 The AVERAGE function 7 Sorting data 8 Filtering data 9 The IF function in a spreadsheet 10 COUNTIF and SUMIF
Add to class →
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 →

Have a class code?