ACARA Digital Technologies Years 7–8 Crossword: Analysing and Visualising Data (Modules 302–324)
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
9
Across
- 4. Word 1 of the term in 3 Down: ______ ___ (6)
- 7. A moving ______. It averages the latest 3 values. Copy it down and the range slides by one row each time, smoothing the ups and downs to show the trend. Word 1 of: =_______(B2:B4) (7)
- 8. Word 1 of the term in 1 Down: ___________ the _______ (11)
- 9. Word 3 of the term in 2 Down: ______ Chart ____ (4)
Down
- 1. Check if an ______ is a typing error or a real extreme value. Fix errors, keep real values, and compare results with and without it. Never delete data just to fit your story. Word 3 of: ___________ the _______ (7)
- 2. A chart option (right-click the chart) that switches it to another ______, like column to line, using the same data so you do not have to enter it again. Word 1 of: ______ Chart ____ (6)
- 3. The ______ at the bottom of a spreadsheet. Select a range of number cells to see their sum, average and count, then compare with your formula. Right-click it to choose what shows. Word 2 of: ______ ___ (3)
- 4. Adds a second set of values to a chart so two groups can be compared on the same axes, with a legend to tell them apart. Word 2 of: Add ______ (6)
- 5. First filter the table to keep only one group, then ______ a number column from largest to smallest. The top row is the highest value and the bottom row is the lowest in that group. Word 3 of: ______ then ____ (4)
- 6. A ______ that keeps only the rows where a number meets a condition, such as greater than a value or between two values. The other rows are hidden, not deleted. Word 2 of: Number ______ (6)
Answer Key
ACARA Digital Technologies Years 7–8 · Modules 302–324
1O
U
2C
3B
4S
T
A
T
U
5S
H
6F
7A
V
E
R
A
G
E
L
O
A
I
R
R
I
R
N
L
8I
N
V
E
S
T
I
G
A
T
E
9T
Y
P
E
R
E
E
S
R
Across
4STATUS — Word 1 of the term in 3 Down: ______ ___
7AVERAGE — A moving ______. It averages the latest 3 values. Copy it down and the range slides by one row each time, smoothing the ups and downs to show the trend. Word 1 of: =_______(B2:B4)
8INVESTIGATE — Word 1 of the term in 1 Down: ___________ the _______
9TYPE — Word 3 of the term in 2 Down: ______ Chart ____
Down
1OUTLIER — Check if an ______ is a typing error or a real extreme value. Fix errors, keep real values, and compare results with and without it. Never delete data just to fit your story. Word 3 of: ___________ the _______
2CHANGE — A chart option (right-click the chart) that switches it to another ______, like column to line, using the same data so you do not have to enter it again. Word 1 of: ______ Chart ____
3BAR — The ______ at the bottom of a spreadsheet. Select a range of number cells to see their sum, average and count, then compare with your formula. Right-click it to choose what shows. Word 2 of: ______ ___
4SERIES — Adds a second set of values to a chart so two groups can be compared on the same axes, with a legend to tell them apart. Word 2 of: Add ______
5SORT — First filter the table to keep only one group, then ______ a number column from largest to smallest. The top row is the highest value and the bottom row is the lowest in that group. Word 3 of: ______ then ____
6FILTER — A ______ that keeps only the rows where a number meets a condition, such as greater than a value or between two values. The other rows are hidden, not deleted. Word 2 of: Number ______