ACARA Digital Technologies Years 9–10 Word Scramble: Acquiring and Validating Data (Modules 255–329)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
PNEERSSO TNIVOADAIL
A rule set on an online form question, such as required, a number range or multiple choice instead of free text, that blocks bad answers so only valid data is collected.
2
NILGGOG EANITVLR
How often a sensor records a reading. Short intervals give more detail but bigger files; long intervals save space but can miss fast changes.
3
ENO ORW EPR ARNDGIE
A sensor log stores each reading as its own row: a timestamp column for the date and time, then one column per measurement, with units in the header, such as Temp (C).
4
NSSERO RROER
A reading that is wrong due to a faulty or uncalibrated sensor or electrical noise, so check for stuck values, impossible spikes and offsets against a known value.
5
AWR ATAD PCYO
Keep the original data untouched on its own Raw sheet or file, then clean a copy on a Clean sheet, so any mistake can be undone. Version numbers like data_v2 and backups help.
6
=2L4(AN)=E
LEN counts the characters in a cell, spaces included. Comparing it to a number, like ______ for a 4-digit postcode, gives TRUE if the length is right and FALSE if not.
7
RTMAOF HECCK
A validation check that tests a value follows an expected pattern, like two letters then three digits or a real date. A correct pattern does not prove the data is right.
8
=B1(H0F(AC>=E,O0<=IC2),"DN","K2KB2")
Shows OK if B2 is between 0 and 120, otherwise Check. Copy it down the column beside the data, then filter on Check to find the invalid entries.
9
IFDN DAN LPACERE
A spreadsheet tool that swaps every spelling variation of a category, such as Vic or VIC, for one agreed value like Victoria, so each category is counted only once.
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 255–329
1PNEERSSO TNIVOADAIL → response validation — A rule set on an online form question, such as required, a number range or multiple choice instead of free text, that blocks bad answers so only valid data is collected.
2NILGGOG EANITVLR → logging interval — How often a sensor records a reading. Short intervals give more detail but bigger files; long intervals save space but can miss fast changes.
3ENO ORW EPR ARNDGIE → one row per reading — A sensor log stores each reading as its own row: a timestamp column for the date and time, then one column per measurement, with units in the header, such as Temp (C).
4NSSERO RROER → sensor error — A reading that is wrong due to a faulty or uncalibrated sensor or electrical noise, so check for stuck values, impossible spikes and offsets against a known value.
5AWR ATAD PCYO → raw data copy — Keep the original data untouched on its own Raw sheet or file, then clean a copy on a Clean sheet, so any mistake can be undone. Version numbers like data_v2 and backups help.
6=2L4(AN)=E → =LEN(A2)=4 — LEN counts the characters in a cell, spaces included. Comparing it to a number, like =LEN(A2)=4 for a 4-digit postcode, gives TRUE if the length is right and FALSE if not.
7RTMAOF HECCK → format check — A validation check that tests a value follows an expected pattern, like two letters then three digits or a real date. A correct pattern does not prove the data is right.
8=B1(H0F(AC>=E,O0<=IC2),"DN","K2KB2") → =IF(AND(B2>=0,B2<=120),"OK","Check") — Shows OK if B2 is between 0 and 120, otherwise Check. Copy it down the column beside the data, then filter on Check to find the invalid entries.
9IFDN DAN LPACERE → Find and Replace — A spreadsheet tool that swaps every spelling variation of a category, such as Vic or VIC, for one agreed value like Victoria, so each category is counted only once.