ACARA Digital Technologies Years 7–8 Word Scramble: Acquiring and Storing Data and Analysing and Visualising Data (Modules 261–300)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
AWR AATD YOCP
An untouched copy of the original data, made by duplicating the worksheet or using Save As before cleaning, so you clean only the copy and never lose the original.
2
=AAU211I($F$N:$2$AO0,TC)>0
Gives TRUE when the value in A2 appears more than once in column A. Put it in a helper column to flag duplicate rows, then filter for TRUE.
3
=FK(OO(0H<E,R2>012),"B0CBC","IK")
Shows Check if B2 is below 0 or above 100, otherwise OK. OR needs just one true test, so it catches both ends. AND would never work because no value is both below 0 and above 100.
4
NIDF NAD CALRPEE
A spreadsheet tool (Ctrl+H) that finds every cell with one spelling and changes them all to the correct spelling in one step, like turning Sydeny into Sydney.
5
=2DONC1T(UH:CEIC,"KF00D")
A quality summary counts problems with formulas like this one. It counts cells flagged Check. COUNTBLANK counts empty cells. Each problem count should reach 0 after cleaning.
6
IEANGNLC OLG
A record of each data problem found, the fix applied and how many rows were affected, so every change, including deleted rows, can be explained and checked.
7
ADTA NTOQESUI
A clear question that can be answered with numbers you can collect or already have, such as how many, how much or what changed over time.
8
=2CA01U(AT:0OAN)
COUNTA counts every cell in a range that is not empty, including text. Use it to count survey responses. COUNT only counts numbers.
9
=UMUNO(BNREDR, IGISTD)
Rounds a number to a set number of decimal places. Use 1 for one decimal place or 0 for a whole number, e.g. =ROUND(AVERAGE(B2:B9),1). It changes the value itself, not just how it looks.
Answer Key
ACARA Digital Technologies Years 7–8 · Modules 261–300
1AWR AATD YOCP → raw data copy — An untouched copy of the original data, made by duplicating the worksheet or using Save As before cleaning, so you clean only the copy and never lose the original.
2=AAU211I($F$N:$2$AO0,TC)>0 → =COUNTIF($A$2:$A$100,A2)>1 — Gives TRUE when the value in A2 appears more than once in column A. Put it in a helper column to flag duplicate rows, then filter for TRUE.
3=FK(OO(0H<E,R2>012),"B0CBC","IK") → =IF(OR(B2<0,B2>100),"Check","OK") — Shows Check if B2 is below 0 or above 100, otherwise OK. OR needs just one true test, so it catches both ends. AND would never work because no value is both below 0 and above 100.
4NIDF NAD CALRPEE → Find and Replace — A spreadsheet tool (Ctrl+H) that finds every cell with one spelling and changes them all to the correct spelling in one step, like turning Sydeny into Sydney.
5=2DONC1T(UH:CEIC,"KF00D") → =COUNTIF(D2:D100,"Check") — A quality summary counts problems with formulas like this one. It counts cells flagged Check. COUNTBLANK counts empty cells. Each problem count should reach 0 after cleaning.
6IEANGNLC OLG → cleaning log — A record of each data problem found, the fix applied and how many rows were affected, so every change, including deleted rows, can be explained and checked.
7ADTA NTOQESUI → data question — A clear question that can be answered with numbers you can collect or already have, such as how many, how much or what changed over time.
8=2CA01U(AT:0OAN) → =COUNTA(A2:A100) — COUNTA counts every cell in a range that is not empty, including text. Use it to count survey responses. COUNT only counts numbers.
9=UMUNO(BNREDR, IGISTD) → =ROUND(number, digits) — Rounds a number to a set number of decimal places. Use 1 for one decimal place or 0 for a whole number, e.g. =ROUND(AVERAGE(B2:B9),1). It changes the value itself, not just how it looks.