ACARA Digital Technologies Years 7–8 Word Scramble: Analysing and Visualising Data and Structured Data and Queries (Modules 331–360)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
AESLS EORS MFRO 04 OT 56
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'.
2
ITTBAETUR
One fact that describes an object, such as a pet's name, colour or age. Each ______ holds a single piece of information.
3
VNTEE SBRTUITEAT
The facts that describe an event: what happened, the date, the time, the place and who took part, like a race at a sports carnival or a bus trip.
4
OCERDR
One row in a table that stores one object. Each attribute of the object becomes a field, so one pet's Name, Species and Age fill one ______, and every ______ uses the same fields.
5
VENET OERRCD
One occurrence of an event stored as a single row, where each attribute of the event, such as Date, Winner or Time, becomes a field.
6
AETBADSA
A ______ gives every record the same fields and data types and lets you query large amounts of data; a spreadsheet is a flexible grid.
7
EBTLA, YUREQ, RFMO, ETORRP
The four database objects: a table stores records, a query finds records, a form enters records and a report presents them.
8
LSQ
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.
9
EETLCS * MROF TDTUENSS;
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.
Answer Key
ACARA Digital Technologies Years 7–8 · Modules 331–360
1AESLS EORS MFRO 04 OT 56 → Sales rose from 40 to 65 — 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'.
2ITTBAETUR → attribute — One fact that describes an object, such as a pet's name, colour or age. Each attribute holds a single piece of information.
3VNTEE SBRTUITEAT → event attributes — The facts that describe an event: what happened, the date, the time, the place and who took part, like a race at a sports carnival or a bus trip.
4OCERDR → record — One row in a table that stores one object. Each attribute of the object becomes a field, so one pet's Name, Species and Age fill one record, and every record uses the same fields.
5VENET OERRCD → event record — One occurrence of an event stored as a single row, where each attribute of the event, such as Date, Winner or Time, becomes a field.
6AETBADSA → database — A database gives every record the same fields and data types and lets you query large amounts of data; a spreadsheet is a flexible grid.
7EBTLA, YUREQ, RFMO, ETORRP → table, query, form, report — The four database objects: a table stores records, a query finds records, a form enters records and a report presents them.
8LSQ → SQL — 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.
9EETLCS * MROF TDTUENSS; → SELECT * FROM students; — 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.