ACARA 9-10 Digital Technologies: Validating data
Students apply validation checks in spreadsheets, online forms and databases to block or flag bad data, and see what validation can and cannot prove.
One content description (AC9TDI10P01) from the full ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data journey. All 17 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (17)
1
Validation versus verification
2
Validation: why data is checked on entry
3
Types of validation check
4
Setting spreadsheet data validation rules
5
Number range validation in a spreadsheet
6
Drop-down list validation in a spreadsheet
7
Validation messages and error alerts
8
Existence checking in a spreadsheet
9
Type checking in a spreadsheet
10
Range checking in a spreadsheet
11
Length checking with LEN
12
Format checking text and dates
13
The IF function in a spreadsheet
14
Flagging invalid entries with IF
15
Double entry check
16
Validation rules on database fields
17
SQL constraints for validation
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 →