ACARA 7-8 Digital Technologies: Cleaning data
Students learn to keep a raw copy and then find and fix missing, duplicate, out-of-range and badly formatted values using spreadsheet formulas and techniques.
One content description (AC9TDI8P01) from the full ACARA Digital Technologies Years 7–8 — Acquiring and Storing 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
Data quality: accuracy
2
Cleaning data
3
Keeping an untouched copy of the raw data
4
Existence checking in a spreadsheet
5
Handling missing values
6
Flagging duplicates with a COUNTIF formula
7
Removing duplicate rows
8
Range checking in a spreadsheet
9
Flagging out-of-range values with IF and OR
10
Type checking in a spreadsheet
11
Converting text to numbers and fixing date formats
12
Conditional formatting
13
Cleaning text with TRIM, UPPER and PROPER
14
Fixing spelling variations with Find and Replace
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 →