ACARA Digital Technologies Years 9–10 Word Scramble: Acquiring and Validating Data and Analysing and Visualising Data (Modules 333–377)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
=ACAF2A0(0$2:1$NTI,UO)
Counts how many times the value in A2 appears in the whole column range. A result above 1 flags a duplicate, so review those rows before deleting any.
2
XETT OT LNSUOCM
A spreadsheet tool that splits the text in one column into separate columns at a chosen delimiter, such as a comma or space, e.g. a full name into first and last name.
3
UIETOLR
A value far from the rest. Check if it is a data entry error or a real extreme value, then correct, remove or keep it, and record your decision.
4
IENLNGAC GLO
A record of each change made to the data: what changed, how many rows it affected and why. It lets other people check the cleaning and repeat it.
5
NACIEUTCOMM GTHINSIS
The final life cycle stage: present findings so the audience sees the answer to the original question. State the key finding first, link to the objective and note data limits.
6
ATDA CCNESEI RPCSSEO
Work through a scenario in stages: define the objective, acquire data, validate and clean it, analyse it, report insights, and go back a stage if the data is poor.
7
LRCT+T
Shortcut that converts a data range into a Table with named columns, filter buttons and automatic growth when new rows are added. Tick 'My table has headers' first.
8
TIFCUSNO
Counts only rows that meet two or more criteria at once, using pairs of criteria range and criterion. SUMIFS works the same way but adds numbers, and its sum_range comes first.
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 333–377
1=ACAF2A0(0$2:1$NTI,UO) → =COUNTIF(A$2:A$100,A2) — Counts how many times the value in A2 appears in the whole column range. A result above 1 flags a duplicate, so review those rows before deleting any.
2XETT OT LNSUOCM → Text to Columns — A spreadsheet tool that splits the text in one column into separate columns at a chosen delimiter, such as a comma or space, e.g. a full name into first and last name.
3UIETOLR → outlier — A value far from the rest. Check if it is a data entry error or a real extreme value, then correct, remove or keep it, and record your decision.
4IENLNGAC GLO → cleaning log — A record of each change made to the data: what changed, how many rows it affected and why. It lets other people check the cleaning and repeat it.
5NACIEUTCOMM GTHINSIS → Communicate insights — The final life cycle stage: present findings so the audience sees the answer to the original question. State the key finding first, link to the objective and note data limits.
6ATDA CCNESEI RPCSSEO → data science process — Work through a scenario in stages: define the objective, acquire data, validate and clean it, analyse it, report insights, and go back a stage if the data is poor.
7LRCT+T → Ctrl+T — Shortcut that converts a data range into a Table with named columns, filter buttons and automatic growth when new rows are added. Tick 'My table has headers' first.
8TIFCUSNO → COUNTIFS — Counts only rows that meet two or more criteria at once, using pairs of criteria range and criterion. SUMIFS works the same way but adds numbers, and its sum_range comes first.