Revision Resources
Everything you need to prepare for the Higher Computing Science exam.
Exam Hints & Tips (2025 Report)
1. The "Explain" Challenge
Don't just say how code works. Say why.
1. The "Explain" Challenge
Don't just say how code works. Say why.
Context is King: Explain why the code is used in this specific scenario. Always include the impact or consequence of the code.
2. SQL Grouping Rule
Using SUM, AVG, or COUNT?
2. SQL Grouping Rule
Using SUM, AVG, or COUNT?
If you select non-aggregated fields alongside an aggregate function, you MUST include a GROUP BY clause for those fields.
3. Evaluation Standard
No generic textbook definitions!
3. Evaluation Standard
No generic textbook definitions!
Refer to your actual code. Mention specific data structures (arrays of records), loops, or sub-programs when discussing efficiency.
4. Security Terms
Signature vs Certificate.
4. Security Terms
Signature vs Certificate.
- Digital Signature: Proves Authenticity & Integrity.
- Digital Certificate: Proves ownership of a Public Key.
5. SQL Precision
Watch out for "At least".
5. SQL Precision
Watch out for "At least".
"At least £300" means >= 300. Using > is a common error that fails the requirement.
6. CSS Layout
Box Model & Floats.
6. CSS Layout
Box Model & Floats.
Box Model: Padding/Margin adds to width. Watch for overflow.
Clear: Use clear: both to fix layout breakage after floating elements.
7. Data Flow
Parameter efficiency.
7. Data Flow
Parameter efficiency.
Only pass data strictly required for the sub-program. Unnecessary parameters reduce efficiency.
Software Design Cheat Sheet
8. Vector Terms
Don't describe pixels.
8. Vector Terms
Don't describe pixels.
Use terms like objects, attributes, and mathematical properties. Do not talk about grids of pixels.
9. Hardware
Impact on performance.
9. Hardware
Impact on performance.
Explain how improvements help. e.g., "Larger cache reduces slow fetches from RAM."
Computer Systems Cheat Sheet
10. RTFQ
The most important rule for exam success.
10. RTFQ
The most important rule for exam success.
Don't skim! Look for keywords like 'Describe', 'Explain', or specific data types. Check how many marks are available to gauge how much detail is needed.
Common Mistakes
-
Generic Evaluations
Saying "It is readable" without evidence.
Fix: "It is readable because I used meaningful variable names like 'totalCost'." -
SQL Grouping Errors
Selecting a column with an aggregate without grouping.
Fix:SELECT house, COUNT(*) ... GROUP BY house -
Imprecise Explanations
Describing what code does instead of why it is needed in that context.
2025 Exam
Most Recent2024 Exam
2023 Exam
Recommended Revision Resources
Key Websites
-
Scholar (Heriot-Watt University)
The primary resource for Higher theory and interactive testing (Access via Glow).
-
Mr McKay's Computing Science
Excellent for exam-style questions and design practice.
-
W3Schools
Essential for verifying complex SQL (Joins, Group By) and CSS (Flexbox, Box Model).
YouTube Playlists & Channels
-
Mr McKay - Computing Science
Essential walkthroughs for the most recent SQA exam papers.
-
Mr Neil - Computing Science
Excellent guides for the technical implementation of Higher SDD and DDD.
-
Computing Science Scotland
Focused recaps on complex Higher topics like Floating Point and Data Flow.