ACARA Digital Technologies Years 7–8 Crossword: Analysing and Visualising Data and Structured Data and Queries (Modules 331–360)
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
10
Across
- 5. Word 5 of the term in 2 Down: ________ > prepare > _______ > _____ > ________ (8)
- 6. A trend statement says what changed, which way it went and the numbers that show it, plus a limit or reason such as 'because' or 'might'. Word 1 of: _____ ____ from 40 to 65 (5)
- 8. Word 4 of the term in 2 Down: ________ > prepare > _______ > _____ > ________ (5)
- 9. Word 1 of the term in 1 Down: ______ * FROM ________; (6)
- 10. Word 2 of the term in 6 Across: _____ ____ from 40 to 65 (4)
Down
- 1. Type an SQL statement in the tool's query window, run it, then read the results table. If an error shows, read the message and fix the statement. Word 3 of: ______ * FROM ________; (8)
- 2. The order of a data investigation: ask a ______, prepare the data, use formulas and sort or filter, ______ it, then ______, predict and report limits. Word 1 of: ________ > prepare > _______ > _____ > ________ (8)
- 3. Word 3 of the term in 2 Down: ________ > prepare > _______ > _____ > ________ (7)
- 4. The four database objects: a table stores records, a query finds records, a ______ enters records and a report presents them. Word 3 of: table, query, ____, report (4)
- 7. Structured Query Language: the standard language for asking a database for data, and for adding, changing or deleting it. Each statement ends with a semicolon. (3)
Answer Key
ACARA Digital Technologies Years 7–8 · Modules 331–360
1S
2Q
3A
T
4F
U
N
U
5C
O
N
C
L
U
D
E
A
D
R
6S
A
L
E
7S
E
M
8C
H
A
R
T
Y
Q
N
I
9S
E
L
E
C
T
10R
O
S
E
S
N
Across
5CONCLUDE — Word 5 of the term in 2 Down: ________ > prepare > _______ > _____ > ________
6SALES — A trend statement says what changed, which way it went and the numbers that show it, plus a limit or reason such as 'because' or 'might'. Word 1 of: _____ ____ from 40 to 65
8CHART — Word 4 of the term in 2 Down: ________ > prepare > _______ > _____ > ________
9SELECT — Word 1 of the term in 1 Down: ______ * FROM ________;
10ROSE — Word 2 of the term in 6 Across: _____ ____ from 40 to 65
Down
1STUDENTS — Type an SQL statement in the tool's query window, run it, then read the results table. If an error shows, read the message and fix the statement. Word 3 of: ______ * FROM ________;
2QUESTION — The order of a data investigation: ask a ______, prepare the data, use formulas and sort or filter, ______ it, then ______, predict and report limits. Word 1 of: ________ > prepare > _______ > _____ > ________
3ANALYSE — Word 3 of the term in 2 Down: ________ > prepare > _______ > _____ > ________
4FORM — The four database objects: a table stores records, a query finds records, a ______ enters records and a report presents them. Word 3 of: table, query, ____, report
7SQL — Structured Query Language: the standard language for asking a database for data, and for adding, changing or deleting it. Each statement ends with a semicolon.