01
Pick a topic
Choose one of the Digital Solutions topics above or type your own, then pick your state. WACE, VCE, HSC, QCE and SACE each word their questions differently, and the paper follows yours.
02
Attempt it yourself
Exam-style questions with the mark allocation showing, so you know how much to write. You answer them — nothing is handed to you.
Write an SQL query that returns the name of each customer and the total value of their orders, for customers with more than three orders, sorted from highest total to lowest. (6 marks)
03
Get it marked
Your answer comes back marked criterion by criterion in seconds — what you earned, what you half-earned, and what the examiner never saw.
4/6 · ✓ Correct join between the two tables on the key
04
Fix the gap
The topics you keep losing marks on come back around in your review until they're strong. That's the whole point.
user experience and interface design
Choose your system
WACEVCEHSCQCESACE
Then your topic
user experience and interface designusability heuristics and prototypingalgorithm design and pseudocodeprogramming in Python
Write an SQL query that returns the name of each customer and the total value of their orders, for customers with more than three orders, sorted from highest total to lowest. (6 marks)
Digital Solutions · QCE
Marked in seconds
✓ Correct join between the two tables on the key
✓ Aggregates with SUM and groups by the customer
✓ Sorts descending on the aggregated total
✕ Filters the aggregate with HAVING — COUNT() in WHERE is an error and the query will not run
Weak topics, resurfacing
user experience and interface design
usability heuristics and prototyping
algorithm design and pseudocode