ACARA 9-10 Digital Technologies: Conditional and calculation formulas

Students use counting, conditional, logical and lookup functions plus rounding, percentages and percentage change to analyse groups within a data set.

One content description (AC9TDI10P02) from the full ACARA Digital Technologies Years 9–10 — Analysing and Visualising 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 The COUNTA function 2 COUNTIF and SUMIF 3 The AVERAGEIF function 4 COUNTIFS and SUMIFS with several criteria 5 IF with AND and OR 6 The IFERROR function 7 Looking up values with XLOOKUP or VLOOKUP 8 The ROUND function 9 Calculating a percentage of a total 10 Calculating percentage change

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?