ACARA Digital Technologies Years 7–8 Crossword: Digital Footprints and Data Minimisation (Modules 752–770)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
Across
- 1. After removing or generalising data, ______ that the columns left can still answer your question and that no column can still identify a person. Scan every column and sheet again. Word 1 of: ___-for-purpose _____ (3)
- 5. Word 4 of the term in 1 Across: ___-for-purpose _____ (5)
- 6. Word 1 of the term in 5 Down: ______ ______ (6)
- 8. A nested IF formula that replaces an exact age with an age band, so the sheet shows a group like 13-15 instead of the exact number. This keeps less personal data. Word 4 of: =IF(B2<13,"_____ 13",IF(B2<16,"13-15","16+")) (5)
Down
- 1. Invented but realistic values made by a data generator, so you can build and ______ a solution without collecting any real person's data. Word 1 of: ____ ____ data (4)
- 2. Builds a unique ID code like P01 for each row. Copy it down, paste as values only so the codes stay, then delete the name column. Word 2 of: ="P"&____(ROW()-1,"00") (4)
- 3. A ______ is only out of sight. Its data stays in the file and is shared with it, and anyone can unhide it. Delete the column to really remove the data. Word 1 of: ______ ______ (6)
- 4. Word 2 of the term in 1 Down: ____ ____ data (4)
- 5. Right-click a ______ header and choose ______ to remove the whole ______ and all its data. Undo with Ctrl+Z if it was a mistake, and check formulas that used the ______. Word 2 of: ______ ______ (6)
- 7. Keeps only the first 2 characters of the postcode in cell C2, so an exact location becomes a wider region. This helps protect privacy. Word 1 of: =____(C2,2) (4)
Answer Key
ACARA Digital Technologies Years 7–8 · Modules 752–770
1F
I
2T
3H
4T
A
E
I
5C
H
E
C
K
X
D
O
S
E
T
6D
E
L
E
T
E
E
U
N
M
7L
8U
N
D
E
R
F
T
Across
1FIT — After removing or generalising data, ______ that the columns left can still answer your question and that no column can still identify a person. Scan every column and sheet again. Word 1 of: ___-for-purpose _____
5CHECK — Word 4 of the term in 1 Across: ___-for-purpose _____
6DELETE — Word 1 of the term in 5 Down: ______ ______
8UNDER — A nested IF formula that replaces an exact age with an age band, so the sheet shows a group like 13-15 instead of the exact number. This keeps less personal data. Word 4 of: =IF(B2<13,"_____ 13",IF(B2<16,"13-15","16+"))
Down
1FAKE — Invented but realistic values made by a data generator, so you can build and ______ a solution without collecting any real person's data. Word 1 of: ____ ____ data
2TEXT — Builds a unique ID code like P01 for each row. Copy it down, paste as values only so the codes stay, then delete the name column. Word 2 of: ="P"&____(ROW()-1,"00")
3HIDDEN — A ______ is only out of sight. Its data stays in the file and is shared with it, and anyone can unhide it. Delete the column to really remove the data. Word 1 of: ______ ______
4TEST — Word 2 of the term in 1 Down: ____ ____ data
5COLUMN — Right-click a ______ header and choose ______ to remove the whole ______ and all its data. Undo with Ctrl+Z if it was a mistake, and check formulas that used the ______. Word 2 of: ______ ______
7LEFT — Keeps only the first 2 characters of the postcode in cell C2, so an exact location becomes a wider region. This helps protect privacy. Word 1 of: =____(C2,2)