VCE Data Analytics U3O1 Word Scramble: Data types and relational databases to Sourcing, validating and referencing data (Modules 17–49)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
RRVC0AA(3H)
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.
2
HVRAR50(CA)
A column's data type and size set in CREATE TABLE. ______ holds text up to 50 characters. Other types: INT, DECIMAL(8,2), DATE, BOOLEAN. They control what a column stores.
3
DAN, RO, ONT
Combine WHERE conditions: AND needs both true, OR needs at least one true, NOT reverses a condition. Brackets set the order and decide which rows are returned.
4
NACIHETTU TAAD
Real data collected by a trusted organisation and kept in a large repository; check its publisher, date and relevance to your question.
5
EILF TRMFAO
The way a dataset's data is structured and stored in a file, such as CSV, XLSX, JSON or XML. Choose the format that suits the software you will open it in.
6
KAINLBS
A spreadsheet function that checks a cell. It returns TRUE if the cell is empty and FALSE if it holds data, so it works as an existence check. COUNTBLANK counts empty cells in a range.
7
BMURSNIE
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
=0DB(02>=2,A1<=0NB)
A range check formula. It returns TRUE only if the value in B2 is at least the minimum (0) and at most the maximum (100), so boundary values pass and anything outside is rejected.
Answer Key
VCE Data Analytics U3O1 · Modules 17–49
1RRVC0AA(3H) → VARCHAR(30) — Field size sets the maximum length or storage a value may use. VARCHAR(30) allows up to 30 characters; longer values are rejected or cut. Smaller sizes save storage.
2HVRAR50(CA) → VARCHAR(50) — A column's data type and size set in CREATE TABLE. VARCHAR(50) holds text up to 50 characters. Other types: INT, DECIMAL(8,2), DATE, BOOLEAN. They control what a column stores.
3DAN, RO, ONT → AND, OR, NOT — Combine WHERE conditions: AND needs both true, OR needs at least one true, NOT reverses a condition. Brackets set the order and decide which rows are returned.
4NACIHETTU TAAD → authentic data — Real data collected by a trusted organisation and kept in a large repository; check its publisher, date and relevance to your question.
5EILF TRMFAO → file format — The way a dataset's data is structured and stored in a file, such as CSV, XLSX, JSON or XML. Choose the format that suits the software you will open it in.
6KAINLBS → ISBLANK — A spreadsheet function that checks a cell. It returns TRUE if the cell is empty and FALSE if it holds data, so it works as an existence check. COUNTBLANK counts empty cells in a range.
7BMURSNIE → ISNUMBER — 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=0DB(02>=2,A1<=0NB) → =AND(B2>=0,B2<=100) — A range check formula. It returns TRUE only if the value in B2 is at least the minimum (0) and at most the maximum (100), so boundary values pass and anything outside is rejected.