ACARA Digital Technologies Years 7–8 Word Scramble: Structured Data and Queries and Algorithms, Flowcharts and Pseudocode (Modules 365–411)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
EKIL '%TA%'
LIKE in a WHERE clause matches part of a text value. The % wildcard stands for any characters, so '%at%' finds text containing at, 'S%' starts with S and '%s' ends with s.
2
LCETES HRWEE EDORR YB
Read a query one clause at a time: SELECT names which fields are shown, WHERE picks which records, and ORDER BY sets the order the results appear in.
3
EETSND OLOP
A REPEAT placed inside another REPEAT. The inner loop runs all its repeats again for every repeat of the outer loop, so an outer 3 and an inner 4 gives 12 inner passes.
4
ECSDDUOEOP TOLUYA
Write keywords like IF, THEN, ELSE and REPEAT in capitals, one step per line, and indent the steps inside each structure so ELSE lines up with its IF.
5
NED FI / NED TAREEP
Each IF and each REPEAT needs its own end line. Close the innermost block first, so END IF comes before END REPEAT when an IF is inside a loop. A missing end line is an error.
6
ESCOIDIN ESIDNI A OOLP
A decision diamond on the loop path is asked on every pass. Its Yes and No paths both rejoin before the arrow returns to the loop test.
7
OPLO NO EHT SYE HTPA
A loop drawn on the Yes arrow of a decision diamond. It only runs if Yes is taken. The No path skips it. When the loop ends, its exit arrow rejoins the main flow.
8
IDRW.OA
A free online editor where you drag standard flowchart shapes onto the page, type text inside them and join them with connector arrows.
9
ARTLFOWCH DT
Starts a Mermaid script that draws a flowchart top-down. Shapes are an id plus text, like A[Step] or B{Question?}, joined by --> arrows.
Answer Key
ACARA Digital Technologies Years 7–8 · Modules 365–411
1EKIL '%TA%' → LIKE '%at%' — LIKE in a WHERE clause matches part of a text value. The % wildcard stands for any characters, so '%at%' finds text containing at, 'S%' starts with S and '%s' ends with s.
2LCETES HRWEE EDORR YB → SELECT WHERE ORDER BY — Read a query one clause at a time: SELECT names which fields are shown, WHERE picks which records, and ORDER BY sets the order the results appear in.
3EETSND OLOP → nested loop — A REPEAT placed inside another REPEAT. The inner loop runs all its repeats again for every repeat of the outer loop, so an outer 3 and an inner 4 gives 12 inner passes.
4ECSDDUOEOP TOLUYA → pseudocode layout — Write keywords like IF, THEN, ELSE and REPEAT in capitals, one step per line, and indent the steps inside each structure so ELSE lines up with its IF.
5NED FI / NED TAREEP → END IF / END REPEAT — Each IF and each REPEAT needs its own end line. Close the innermost block first, so END IF comes before END REPEAT when an IF is inside a loop. A missing end line is an error.
6ESCOIDIN ESIDNI A OOLP → decision inside a loop — A decision diamond on the loop path is asked on every pass. Its Yes and No paths both rejoin before the arrow returns to the loop test.
7OPLO NO EHT SYE HTPA → Loop on the Yes path — A loop drawn on the Yes arrow of a decision diamond. It only runs if Yes is taken. The No path skips it. When the loop ends, its exit arrow rejoins the main flow.
8IDRW.OA → draw.io — A free online editor where you drag standard flowchart shapes onto the page, type text inside them and join them with connector arrows.
9ARTLFOWCH DT → flowchart TD — Starts a Mermaid script that draws a flowchart top-down. Shapes are an id plus text, like A[Step] or B{Question?}, joined by --> arrows.