VCE Data Analytics U3O1 Crossword: Data types and relational databases to Sourcing, validating and referencing data (Modules 17–49)
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
- 1. Save the rows a ______ returns as a ______ file with a header row of field names. Import it into a spreadsheet, then check the columns came across correctly before further analysis. Word 2 of: ______ _____ results as ___ (5)
- 4. Field size sets the maximum length or storage a value may use. ______ allows up to 30 characters; longer values are rejected or cut. Smaller sizes save storage. Word 1 of: _______(30) (7)
- 8. A function that tests whether a cell value is a number. It returns TRUE for a number and FALSE for text, so it works as a type check. ISTEXT does the same job for text. (8)
- 10. Combine WHERE conditions: AND needs both true, OR needs at least one true, ______ reverses a condition. Brackets set the order and decide which rows are returned. Word 3 of: AND, OR, ___ (3)
Down
- 2. Word 1 of the term in 1 Across: ______ _____ results as ___ (6)
- 3. Word 5 of the term in 1 Across: ______ _____ results as ___ (3)
- 5. Real data collected by a trusted organisation and kept in a large repository; check its publisher, date and relevance to your question. Word 1 of: _________ data (9)
- 6. The way a dataset's data is structured and stored in a ______, such as CSV, XLSX, JSON or XML. Choose the format that suits the software you will open it in. Word 1 of: ____ format (4)
- 7. ______ record in a primary table matches ______ records in a related table. The foreign key sits on the ______ side, e.g. ______ class has ______ students, so class details are not repeated. Word 1 of: ___-to-____ relationship (3)
- 9. Word 3 of the term in 7 Down: ___-to-____ relationship (4)
Answer Key
VCE Data Analytics U3O1 · Modules 17–49
1Q
U
2E
R
Y
X
3C
P
S
O
4V
A
R
C
H
5A
R
T
U
T
6F
7O
H
8I
S
N
U
9M
B
E
R
L
E
A
N
E
10N
O
T
Y
I
C
Across
1QUERY — Save the rows a ______ returns as a ______ file with a header row of field names. Import it into a spreadsheet, then check the columns came across correctly before further analysis. Word 2 of: ______ _____ results as ___
4VARCHAR — Field size sets the maximum length or storage a value may use. ______ allows up to 30 characters; longer values are rejected or cut. Smaller sizes save storage. Word 1 of: _______(30)
8ISNUMBER — A function that tests whether a cell value is a number. It returns TRUE for a number and FALSE for text, so it works as a type check. ISTEXT does the same job for text.
10NOT — Combine WHERE conditions: AND needs both true, OR needs at least one true, ______ reverses a condition. Brackets set the order and decide which rows are returned. Word 3 of: AND, OR, ___
Down
2EXPORT — Word 1 of the term in 1 Across: ______ _____ results as ___
3CSV — Word 5 of the term in 1 Across: ______ _____ results as ___
5AUTHENTIC — Real data collected by a trusted organisation and kept in a large repository; check its publisher, date and relevance to your question. Word 1 of: _________ data
6FILE — The way a dataset's data is structured and stored in a ______, such as CSV, XLSX, JSON or XML. Choose the format that suits the software you will open it in. Word 1 of: ____ format
7ONE — ______ record in a primary table matches ______ records in a related table. The foreign key sits on the ______ side, e.g. ______ class has ______ students, so class details are not repeated. Word 1 of: ___-to-____ relationship
9MANY — Word 3 of the term in 7 Down: ___-to-____ relationship