Scotland National 5 Computing Science study guide
Qualifications Scotland National 5 Computing Science course specification version 3.0, September 2024 specimen assignment, current course resources and 2025 course report reviewed 29 July 2026
601 practice questions
144 flashcards
Completely free

National 5 Computing Science Study Guide

Build software-development and computer-systems knowledge, then deepen the database or web route offered by your centre.

Qualifications Scotland · current
Mandatory core + one option
80-mark paper + assignment

Most popular

Start with free practice questions

Jump into a mixed set drawn from 601 free practice questions.

Free Practice Questions

Exam structure

Know the split before you start drilling

Software Design and Development

250 items

250 scored + 0 pretest

Computer Systems

95 items

95 scored + 0 pretest

Database Design and Development

128 items

128 scored + 0 pretest

Web Design and Development

128 items

128 scored + 0 pretest

Current specification

May 2023 · v3.0

The current course page confirms that this specification remains valid.

Question paper

80 marks · 1 hour 30 minutes

The externally set and marked paper contributes 67% of the 120 course-assessment marks.

Mandatory paper section

55 marks · SDD + CS

Every candidate completes Software Design and Development plus Computer Systems.

Paper option

25 marks · DDD or WDD

Candidates answer either the Database section or the Web section, not both.

Assignment

40 marks · 6 hours

The assignment contributes 33% and is completed under a high degree of supervision and control.

Assignment route

SDD 25 + option 15

Task 1 is mandatory, followed by either the Database task or the Web task.

Course scope

4 areas · 24 topic groups

This guide covers both options so learners can select the route offered by their centre.

Start here

How to study National 5 Computing Science

Build one repeatable development chain, secure the mandatory systems content, then practise the information-systems route offered by your centre.

1

1. Trace requirements into designs

Identify purpose, users and functional requirements, then represent data, logic, navigation or interface layout.

2

2. Read before you write code

Trace data types, arrays, conditions, loops and standard algorithms before implementing or correcting a solution.

3

3. Secure the systems core

Practise binary and graphics representation, basic architecture, energy-use reasoning, firewalls and encryption.

4

4. Deepen your centre’s option

Study the full Database or Web analysis–design–implementation–testing–evaluation sequence while recognising both official routes.

About the exam

National 5 Computing Science Exam structure

An independent National 5 Computing Science study guide aligned to the current Qualifications Scotland May 2023 course specification.

Issuer and path

National 5 Computing Science Study Guide is administered through Qualifications Scotland. Check official resources before booking, retesting, or relying on a stale requirement.

Software Design and Development

250 items

250 scored + 0 pretest

Iterative development and the analysis, design, implementation, testing and evaluation of software solutions.

Computer Systems

95 items

95 scored + 0 pretest

Binary data representation, basic computer architecture, energy use, firewalls and encryption.

Database Design and Development

128 items

128 scored + 0 pretest

Analysis, two-entity relational design, SQL implementation, testing and evaluation.

Web Design and Development

128 items

128 scored + 0 pretest

Analysis, small multimedia website design, HTML, CSS, JavaScript, testing and evaluation.

Use the secure live task for the correct year

The public specimen shows assignment structure, but Qualifications Scotland issues a new secure task for each academic year. Follow your centre’s controlled-assessment instructions and complete the Database or Web route actually assigned or offered.

Official Outline Coverage Map

Coverage is mapped to official outline item counts so content depth can be checked without hard-coding a single exam.

Official outline
TopicOfficial outline itemsYour questionsYour flashcardsConfidence
Iterative Development Process0246
Good
Purpose and Functional Requirements0226
Priority
Design Techniques and Wireframes0386
Priority
Data Types and One-Dimensional Arrays006
Priority
Expressions, Selection, Loops and Functions006
Priority
Validation, Running Totals and Array Traversal0346
Priority
Test Data, Test Tables and Errors006
Priority
Fitness, Efficiency, Robustness and Readability0226
Priority
Binary, Text and Graphics Representation0346
Priority
Architecture, Memory, Buses and Translators006
Priority
Energy Use and Environmental Impact0146
Good
Firewalls and Encryption006
Priority
Database Users and Requirements0146
Good
UK GDPR, Relationships, Dictionaries and Queries0346
Priority
Two-Table Databases and SQL006
Priority
Testing SQL Operations006
Priority
Database Fitness and Accuracy006
Good
Website Users and Requirements0146
Good
Structure, Wireframes, Media, Copyright and Prototypes006
Priority
Internal and External CSS006
Priority
HTML, Media, Lists and Links006
Priority
JavaScript Mouse Events006
Priority
Testing Design, Navigation, Media and Consistency006
Good
Website Fitness for Purpose006
Good

How to use this guide

How to study National 5 Computing Science

Move from functional requirements to designs and implementation, trace data and code carefully, and support testing and evaluation with evidence.

1. Identify the requirement

Name the end-user, input, process, output, data rule or system property the response must address.

2. Select the representation

Choose a structure diagram, flowchart, pseudocode, data type, SQL clause, HTML or CSS feature, algorithm or systems model.

3. Trace the behaviour

Follow data and control step by step, including conditions, loop bounds, array positions, query criteria, links, events and expected outputs.

4. Support the judgement

Use a requirement, test result, implementation feature or scenario fact to justify correctness, security, fitness or improvement.

Official course map

Build the mandatory core, then deepen one option

Use all 24 topic groups to connect the development lifecycle with systems knowledge and the Database or Web route offered by your centre.

Development Methodologies

The analysis, design, implementation, testing, documentation and evaluation phases of iterative development.

18 items

Choose a topic to open below

Software Analysis

Purpose and functional requirements expressed as inputs, processes and outputs.

20 items

Choose a topic to open below

Software Design

Data choices, structure diagrams, flowcharts, pseudocode, efficient designs and interface wireframes.

35 items

Choose a topic to open below

Implementation: Data Types and Structures

Characters, strings, integers, real numbers, Booleans and one-dimensional arrays.

32 items

Choose a topic to open below

Implementation: Computational Constructs

Assignment, arithmetic, concatenation, conditions, logical operators, loops and predefined functions.

48 items

Choose a topic to open below

Implementation: Standard Algorithms

Input validation, running totals within loops and traversal of one-dimensional arrays.

33 items

Choose a topic to open below

Software Testing

Normal, extreme and exceptional test data, test tables and error classification.

34 items

Choose a topic to open below

Software Evaluation

Fitness for purpose, efficient constructs, robustness and readable code.

30 items

Choose a topic to open below

Data Representation

Positive binary values, floating point, extended ASCII, vector graphics and bitmapped graphics.

35 items

Choose a topic to open below

Computer Structure

Processors, memory, buses and the role of compilers and interpreters.

25 items

Choose a topic to open below

Environmental Impact

Energy use, environmental implications and power-management settings.

15 items

Choose a topic to open below

Security Precautions

The role of firewalls and the use of encryption in electronic communications.

20 items

Choose a topic to open below

Database Analysis

End-user and functional requirements for database problems.

15 items

Choose a topic to open below

Database Design

UK GDPR, two-entity relationships, data dictionaries and query design.

35 items

Choose a topic to open below

Database Implementation

Two linked tables, referential integrity and National 5 SQL operations.

42 items

Choose a topic to open below

Database Testing

Testing whether SQL operations work correctly.

20 items

Choose a topic to open below

Database Evaluation

Fitness for purpose and accuracy of database output.

16 items

Choose a topic to open below

Website Analysis

End-user and functional requirements for website problems.

14 items

Choose a topic to open below

Website Design

Small site structures, wireframes, copyright, media formats, compression and low-fidelity prototypes.

25 items

Choose a topic to open below

Implementation: CSS

Internal and external CSS, selectors, classes, IDs and required text and background properties.

25 items

Choose a topic to open below

Implementation: HTML

Required HTML elements, media, lists and internal and external hyperlinks.

24 items

Choose a topic to open below

Implementation: JavaScript

Reading and identifying JavaScript related to onmouseover and onmouseout events.

20 items

Choose a topic to open below

Website Testing

Testing design match, navigation, media display and consistency.

10 items

Choose a topic to open below

Website Evaluation

Evaluating whether a website is fit for purpose.

10 items

Choose a topic to open below

Development Methodologies
Software Development

Iterative Development Process

Describe and implement analysis, design, implementation, testing, documentation and evaluation as a repeating development process.

Key rules

Rule 1

An iterative process revisits phases as evidence and feedback reveal changes.

Exam cue: Link each named phase to its concrete output.

Rule 2

Analysis establishes the problem, design plans the solution, and implementation creates it.

Exam cue: Explain iteration by showing why a later finding sends work back to an earlier phase.

Rule 3

Testing supplies evidence, documentation communicates the solution, and evaluation judges it against requirements.

Exam cue: Name the requirement or criterion, cite observable evidence and explain the effect before proposing an improvement.

Common traps

Presenting the phases as a one-way sequence that can never be revisited.

Prevention: Check option route, data type, valid boundary, loop condition, array index, identifier and expected output before committing to the response.

Confusing evaluation against requirements with testing individual cases.

Prevention: Check option route, data type, valid boundary, loop condition, array index, identifier and expected output before committing to the response.

Memory anchors

Analysis

Identify the problem’s purpose and functional requirements.

Design

Plan data, logic and interface before implementation.

Implementation

Translate the design into a working digital solution.

Testing

Use planned data and expected results to find whether the solution behaves correctly.

Documentation

Record information needed to understand, use or maintain the solution.

Evaluation

Judge the completed solution against requirements and quality criteria.

Next best moves

Quick check-up

Use a short quiz to confirm the rule pattern is actually sticking.

Check-up Questions

1-2 question checkpoint

Which phase establishes what a new program must do?

A client comments on an early working version and asks for a changed report. What should happen next in an iterative process?

Answer all questions to submit.

Next step personalized recommendations

Open another topic next

Official resources

Verify the details with the official sources

Use these links for eligibility, scheduling, handbook rules, and issuer updates. Our guide helps you study; official sources tell you what the testing partner currently requires.

FAQ

Common National 5 Computing Science questions

Is this an official Qualifications Scotland resource?

No. It is an independent study resource aligned to the current public course specification. Qualifications Scotland documents, the secure annual assignment task and your centre’s instructions remain authoritative.

Is the May 2023 specification still current?

Yes. The Qualifications Scotland National 5 Computing Science page continues to list the May 2023 version 3.0 course specification. It also states that documents still carrying SQA branding remain current after Qualifications Scotland replaced SQA.

How is the current question paper structured?

The 90-minute paper has 80 marks. Section 1 is mandatory and combines Software Design and Development with Computer Systems for 55 marks. Candidates then answer either Section 2 Database Design and Development or Section 3 Web Design and Development for 25 marks.

How is the mandatory 55-mark paper section divided?

The course specification’s question-paper brief gives a range of 41–45 marks for Software Design and Development and 10–14 marks for Computer Systems. The chosen Database or Web section has 25 marks.

What response styles appear in the paper?

Each section starts with short stand-alone questions and then moves to more challenging context-based, multi-part questions. Responses can include restricted and extended answers, solution designs and code. The paper emphasises application, with very few direct-recall questions.

Must code answers use the official reference language?

No. Questions can express programming logic in the standard reference language, but candidates who are asked to write code may use any programming language. Marks reward demonstrated understanding rather than exact reference-language syntax.

What proportion of A-type and C-type marks is expected?

The specification states that approximately 30% of question-paper marks are A-type, mainly in context-based questions, and approximately 50% are C-type. Both optional routes are balanced for comparable demand.

How does the assignment work?

The assignment has 40 marks and a six-hour limit. Every candidate completes the 25-mark Software Design and Development task, then either the 15-mark Database task or the 15-mark Web task. It is externally marked and conducted under a high degree of supervision and control.

Is the assignment open book?

Yes, within the controlled centre environment. Permitted resources include programming manuals, class notes, textbooks and programs written during the course. Candidates must work independently, cannot access email or mobile phones, and cannot receive task-specific teaching during the assessment.

Can a centre provide code templates for the assignment?

Only generic starter code used during learning and teaching may be provided. A template must not be tailored to the current year’s task. Any online development environment must prevent access to candidate files and tasks outside the supervised classroom.

Is the public specimen the live assignment?

No. The September 2024 version 2.0 specimen is valid as an illustration from session 2024–25 until further notice. Qualifications Scotland publishes a new secure live task for each academic year, and that task is valid for that year only.

Why does this guide cover both Database and Web?

Both are official course areas, but a candidate attempts only one option in the question paper and assignment. Equal future-authoring allocations keep both routes complete; they are not cumulative assessment weights.

Are the 601 planned questions already included?

No. The number is a future-authoring allocation only. This module contains non-question study assets and no question bank or page registration.

Why is there no full mock mode?

Authentic assessment includes extended responses, solution design, written code and a controlled six-hour practical assignment with alternative routes. Use current official papers and centre materials for exact response, timing and submission practice.

What is Pass Harbor?

Completely free exam prep for 247 UK exams.

  • Practice questions
  • Flashcards
  • Study guides
  • Mock exams
  • No registration
  • No paywall
  • Start instantly
No more expensive exam prep. Quality study tools should be accessible to everyone.