SQA National 5 Computing Science: complete guide to the four areas, the question paper and the assignment

SQA National 5 Computing Science is a one-year course at SCQF level 5, building on the Broad General Education and preparing learners for Higher Computing Science or related study. It is graded A to D from two assessment components: a question paper and an assignment (the coursework). This page is the index: below is a map of the four areas of study, the assessment structure, and how to study each one.

The four areas of SQA National 5 Computing Science

The course specification organises the content into four areas of study. Practical problem-solving skills are developed alongside knowledge and understanding throughout.

Software design and development

Writing software well: the iterative development process (analysis, design, implementation, testing, documentation, evaluation), data types and structures, computational constructs in a high-level language, the standard algorithms (input validation, running total and array traversal), testing and evaluation, and low-level data representation in binary.

Computer systems

How a computer stores data and works as hardware, and its wider impact: data representation and units of storage, the processor, memory and buses, the environmental impact of computer systems, and security risks, precautions and the Computer Misuse Act.

Database design and development

Designing and querying a relational database: analysis and design with tables, fields, field types, primary and foreign keys and validation, and implementation in SQL with SELECT, WHERE and ORDER BY and with INSERT, UPDATE and DELETE.

Web design and development

Designing and building a website: analysis and design with wireframes and a navigation structure, building pages with HTML and hyperlinks, styling with CSS selectors, and adding interactivity with event-driven JavaScript and media files.

Course assessment

The National 5 Computing Science award is graded A to D and is made up of two components, both set and marked by the SQA.

• Question paper - 110 marks, sat under exam conditions. Section 1 covers Software design and development and Computer systems for 55 marks and is taken by everyone. Candidates then attempt either Section 2 (Database design and development, 25 marks) or Section 3 (Web design and development, 25 marks). The paper assesses demonstrating and applying knowledge, and applying problem-solving skills.
• Assignment - 60 marks, the practical coursework completed under supervised conditions. It is split into a software design and development task, a database task and a web task, each rewarding a worked solution with analysis, design, implementation, testing and evaluation.

The two components combine to a total of 170 marks. There is no separate unit assessment in the graded award. (Always confirm the current marks against the SQA course specification, as totals can be revised.)

The skills the course develops

Across both components, the SQA tests practical computing skill, not just recall:

1. Designing. Planning solutions with pseudocode, wireframes, structure diagrams and a navigation structure.
2. Implementing. Writing code, SQL statements, and HTML, CSS and JavaScript.
3. Using standard patterns. Applying the standard algorithms and common constructs correctly.
4. Testing. Choosing normal, extreme and exceptional test data and finding syntax, execution and logic errors.
5. Evaluating. Judging a solution for fitness for purpose, efficiency, robustness and readability.

How to study SQA National 5 Computing Science

National 5 Computing Science rewards confident practical skill and precise vocabulary.

1. Work from the key areas. Each key area in the SQA course specification is a checklist; question-paper items are written from them.
2. Drill the practical skills. Practise writing and reading code, the three standard algorithms, binary conversions, SQL statements, and HTML, CSS and JavaScript until they are automatic.
3. Learn the terms exactly. Marks reward correct terminology such as iterative, functional requirements, fitness for purpose, primary key, foreign key, element selector and event-driven.
4. Apply to unfamiliar contexts. Many marks come from solving problems and reading code or queries you have not seen before.
5. Practise past papers. Use SQA past papers and marking instructions to learn the question style and the wording markers reward.

The four areas, key area by key area

Each area has key-area answer pages with worked questions and cross-links, plus an overview guide and a quiz. Browse the full set from this hub.

For the official course specification

The SQA publishes the full National 5 Computing Science course specification, specimen question papers and coursework tasks at sqa.org.uk. Always revise from the current specification and SQA past papers, because question style and terminology are board-specific.