ACARA 7-8 Digital Technologies: De-identifying data in spreadsheets
Students clean and depersonalise a spreadsheet by filtering, removing personal columns, creating ID codes and generalising values, then check the result is still useful and safe.
One content description (AC9TDI8P01, AC9TDI8P02, AC9TDI8P14) from the full ACARA Digital Technologies Years 7–8 — Digital Footprints and Data Minimisation journey. All 18 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (18)
1
Importing data from a CSV file
2
Organising data in a table with headings
3
Filtering data
4
Spotting personal data columns in a dataset
5
Direct and indirect identifiers
6
Saving a working copy before changing data
7
Deleting a spreadsheet column
8
Hiding a column does not remove the data
9
Anonymising data
10
De-identifying survey and interview data with participant codes
11
Splitting and joining text with LEFT, RIGHT and CONCAT
12
The IF function in a spreadsheet
13
Creating ID codes with a formula
14
Generalising an exact value into a range
15
Turning an age into an age band with IF
16
Shortening a postcode to a region with LEFT
17
Re-identification risk from small groups and combined details
18
Checking de-identified data still answers the question
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 →