ACARA Digital Technologies Years 9–10 Crossword: Acquiring and Validating Data and Analysing and Visualising Data (Modules 333–377)
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. Finds the mean of only the values in the last range whose matching cell in the first range meets the criterion, such as the average mark for just Year 9 students. Word 7 of: =AVERAGEIF(A2:A50,"Year 9",C2:___) (3)
- 4. Work through a scenario in stages: define the objective, acquire ______, validate and clean it, analyse it, report insights, and go back a stage if the ______ is poor. Word 1 of: ____ science process (4)
- 5. 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. (8)
- 6. 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. Word 2 of: Communicate ________ (8)
- 8. 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. Word 1 of: ____+T (4)
Down
- 1. A record of each change made to the data: what changed, how many rows it affected and why. It lets other people check the ______ and repeat it. Word 1 of: ________ log (8)
- 2. A spreadsheet tool that splits the ______ in one column into separate ______ at a chosen delimiter, such as a comma or space, e.g. a full name into first and last name. Word 3 of: ____ to _______ (7)
- 3. AND or OR inside IF joins several tests into one TRUE/FALSE. AND needs every test true. OR needs only one true. The IF then gives its first result if TRUE, otherwise its second. Word 7 of: =IF(AND(B2>50,C2="Yes"),"____","Fail") (4)
- 7. Word 1 of the term in 2 Down: ____ to _______ (4)
- 8. 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. Word 1 of: =_______(A$2:A$100,A2) (7)
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 333–377
1C
5
0
L
2C
E
3P
O
4D
A
T
A
L
N
S
5C
O
U
N
T
I
F
S
M
N
6I
N
S
I
G
H
7T
S
S
E
X
8C
T
R
L
O
U
N
T
I
F
Across
1C50 — Finds the mean of only the values in the last range whose matching cell in the first range meets the criterion, such as the average mark for just Year 9 students. Word 7 of: =AVERAGEIF(A2:A50,"Year 9",C2:___)
4DATA — Work through a scenario in stages: define the objective, acquire ______, validate and clean it, analyse it, report insights, and go back a stage if the ______ is poor. Word 1 of: ____ science process
5COUNTIFS — 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.
6INSIGHTS — 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. Word 2 of: Communicate ________
8CTRL — 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. Word 1 of: ____+T
Down
1CLEANING — A record of each change made to the data: what changed, how many rows it affected and why. It lets other people check the ______ and repeat it. Word 1 of: ________ log
2COLUMNS — A spreadsheet tool that splits the ______ in one column into separate ______ at a chosen delimiter, such as a comma or space, e.g. a full name into first and last name. Word 3 of: ____ to _______
3PASS — AND or OR inside IF joins several tests into one TRUE/FALSE. AND needs every test true. OR needs only one true. The IF then gives its first result if TRUE, otherwise its second. Word 7 of: =IF(AND(B2>50,C2="Yes"),"____","Fail")
7TEXT — Word 1 of the term in 2 Down: ____ to _______
8COUNTIF — 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. Word 1 of: =_______(A$2:A$100,A2)