QCE Digital Solutions Unit 3 Word Scramble: Real-World Problems and Solution Requirements (Modules 194–250)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
{"EMAN": "VAA", "RYAE": 21}
JSON stores data as key-value pairs inside curly braces, with lists in square brackets. Objects can nest inside each other, so programs can read it easily. It is a lighter alternative to XML.
2
EDLOMU
A self-contained part of a program that does one job, so it can be built, tested on its own, reused in other places and changed without breaking the rest of the solution.
3
NMEU OOPL
A loop that prints the options, uses a print prompt then input to read a choice, runs the matching action with if / else if, and repeats until the user picks the exit option.
4
LIWEH UPNIT SI LIDNAIV
A loop that reads input, tests it (presence, type, range or length), then shows an error message and asks again until the input passes the check.
5
NTPRI "ATOTL: " + OATTL
A print statement that joins a label to a value so results are readable. Use headings, labels and one record per line, often inside a loop, to build a report.
6
ADTA NILEGACN
Finding and fixing mistakes in data, such as typos, spelling variations, duplicate rows, missing values and impossible values, so the data is accurate and ready to use.
7
ICNNALEG OLMRITHGA
A loop that checks each record with if conditions, trims and standardises text, rejects or fixes bad values, and writes only the good records to a new clean array, leaving the raw data untouched.
8
EERMG IMARTHGOL
Loops through one data source, finds the record with the matching key in the other, then combines them or appends unmatched records, avoiding duplicate keys.
9
NAHCLCTEI OPOPLRAS
A structured document that sets out the problem, scope, constraints, requirements, criteria, data design and algorithm outlines in order, so a reader can approve the planned solution.
Answer Key
QCE Digital Solutions Unit 3 · Modules 194–250
1{"EMAN": "VAA", "RYAE": 21} → {"name": "Ava", "year": 12} — JSON stores data as key-value pairs inside curly braces, with lists in square brackets. Objects can nest inside each other, so programs can read it easily. It is a lighter alternative to XML.
2EDLOMU → module — A self-contained part of a program that does one job, so it can be built, tested on its own, reused in other places and changed without breaking the rest of the solution.
3NMEU OOPL → menu loop — A loop that prints the options, uses a print prompt then input to read a choice, runs the matching action with if / else if, and repeats until the user picks the exit option.
4LIWEH UPNIT SI LIDNAIV → while input is invalid — A loop that reads input, tests it (presence, type, range or length), then shows an error message and asks again until the input passes the check.
5NTPRI "ATOTL: " + OATTL → print "Total: " + total — A print statement that joins a label to a value so results are readable. Use headings, labels and one record per line, often inside a loop, to build a report.
6ADTA NILEGACN → data cleaning — Finding and fixing mistakes in data, such as typos, spelling variations, duplicate rows, missing values and impossible values, so the data is accurate and ready to use.
7ICNNALEG OLMRITHGA → cleaning algorithm — A loop that checks each record with if conditions, trims and standardises text, rejects or fixes bad values, and writes only the good records to a new clean array, leaving the raw data untouched.
8EERMG IMARTHGOL → merge algorithm — Loops through one data source, finds the record with the matching key in the other, then combines them or appends unmatched records, avoiding duplicate keys.
9NAHCLCTEI OPOPLRAS → technical proposal — A structured document that sets out the problem, scope, constraints, requirements, criteria, data design and algorithm outlines in order, so a reader can approve the planned solution.