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

SQA Higher Computing Science is a one-year course at SCQF level 6, building on National 5 Computing Science and preparing learners for Advanced Higher or university study. It is graded A to D from two assessment components: a question paper and an assignment. 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 Higher Computing Science

The course specification organises the content into four areas. Software Design and Development and Computer Systems form the mandatory core; Database Design and Development and Web Design and Development complete the course.

Software Design and Development

The core of the course: the development process and methodologies (iterative, waterfall and agile); analysis (purpose, scope, boundaries and functional requirements); design notations (structure diagrams, flowcharts, pseudocode and wireframes); data types and structures (arrays, records and arrays of records); computational constructs (selection, iteration, sub-programs and parameter passing); the standard algorithms; and testing and evaluation.

Computer Systems

How data and machines work at a low level: representing positive and negative integers in two's complement and real numbers in floating-point; representing characters with ASCII, extended ASCII and Unicode; the structure of a computer (the processor, buses and memory, and interpreters versus compilers); and the environmental impact of computing including intelligent systems.

Database Design and Development

Modelling and querying relational data: analysis and design with entity-relationship diagrams, cardinality and primary, foreign and compound keys; the data dictionary; entity and referential integrity and validation; and writing SQL to query (SELECT, joins, aggregates and GROUP BY) and to change data (INSERT, UPDATE, DELETE).

Web Design and Development

Designing and building websites: analysis and design with site structure diagrams, wireframes and prototypes; HTML structure and forms; CSS selectors, styling and a navigation bar; JavaScript events and changing the page through the DOM; and testing and evaluation.

Course assessment

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

• Question paper - 80 marks, sat under exam conditions. It has a mandatory section on Software Design and Development and Computer Systems (55 marks), and further sections on Database Design and Development (25 marks) and Web Design and Development (25 marks). It assesses both knowledge and the application of development skills to unfamiliar problems.
• Assignment - 40 marks, practical coursework under controlled conditions. A mandatory Software Design and Development task plus a further database or web task, each evidencing analysis, design, implementation, testing and evaluation.

The two components combine to a total of 120 marks. There is no separate unit assessment in the graded award.

The development and inquiry skills

Across both components, the SQA tests the development process, not just recall:

1. Analysis. Identifying the purpose and functional requirements of a problem.
2. Design. Planning a solution with pseudocode, structure diagrams, ER diagrams or wireframes.
3. Implementation. Writing program code, SQL, or HTML, CSS and JavaScript.
4. Testing. Designing test data (normal, extreme and exceptional) and checking the result against the requirements.
5. Evaluation. Judging the solution for fitness for purpose, efficiency, robustness and readability.

How to study SQA Higher Computing Science

Higher Computing Science rewards practical fluency and precise terms.

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 writing code by hand. Pseudocode for the standard algorithms, two's complement conversions, SQL queries and HTML, CSS and JavaScript must be automatic, because the paper asks you to write them.
3. Practise reading and tracing code. Many marks come from tracing given code or finding errors, not only writing your own.
4. Learn definitions precisely. Higher marks reward correct named terms (referential integrity, parameter passing, the DOM) used accurately.
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, and a module overview guide and quiz. Browse the full set from this hub.

The assignment

The 40-mark assignment applies these skills in practical tasks. See the assignment overview for how it is structured (a mandatory software task plus a database or web task) and how it is marked.

For the official course specification

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