ACARA 7-8 Digital Technologies: Spreadsheet formulas and functions
Students write formulas and use functions such as SUM, COUNT, AVERAGE, MIN, MAX and ROUND, and learn to copy, lock, format and check their results.
One content description (AC9TDI8P02) from the full ACARA Digital Technologies Years 7–8 — Analysing and Visualising Data journey. All 14 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (14)
1
Formulas start with =
2
Arithmetic operators + - * /
3
The SUM function
4
The COUNT function
5
The COUNTA function
6
The AVERAGE function
7
The MIN and MAX functions
8
Choosing SUM, COUNT, AVERAGE, MIN or MAX for a question
9
Range as MAX minus MIN
10
Copying a formula down a column
11
Absolute cell references with $
12
The ROUND function
13
Formatting numbers and cells
14
Checking a result with the status bar summary
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 →