ACARA 9-10 Digital Technologies: Cleaning data with spreadsheet tools
Students clean data with sorting, filters, formulas and functions, handle duplicates, missing values and outliers, and record and check their work.
One content description (AC9TDI10P01, AC9TDI10P02) from the full ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data journey. All 20 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (20)
1
Cleaning data
2
Sorting data
3
Filtering data
4
Cleaning text with TRIM, UPPER and PROPER
5
Standardising spelling variations with Find and Replace
6
Removing duplicate rows
7
The COUNTIF function
8
Relative and absolute cell references
9
Finding duplicates with COUNTIF
10
Handling missing values
11
Converting text to numbers and fixing date formats
12
Splitting and joining text with LEFT, RIGHT and CONCAT
13
Splitting one column into several with Text to Columns
14
Formula error values and how to fix them
15
The MIN and MAX functions
16
Conditional formatting
17
Deciding what to do with an outlier
18
Keeping a cleaning log
19
Testing a formula against a hand-calculated answer
20
Checking end-to-end data integrity from collection to visualisation
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 →