Skip to main content

← SQA-ADVANCED-HIGHER

Scotland Β· SQA2026

SQA Advanced Higher Computing Science: complete guide to the three areas, the question paper and project, and how to study for an A

A complete guide to SQA Advanced Higher Computing Science, an SCQF level 7 qualification. Covers the three areas (Software, Database and Web Design and Development), the question paper and coursework project, and how to study each area for an A.

Browse guides β†’Syllabus dot points (15)

SQA Advanced Higher Computing Science is a one-year course at SCQF level 7, building on Higher Computing Science and preparing learners for university study in computing science and related fields. It is graded A to D from a question paper and a coursework project. This page is the index: below is a map of the three areas, the assessment structure, and how to study each one.

The three areas of SQA Advanced Higher Computing Science

The course specification organises the content into three practical areas. Analysis, design, implementation, testing and evaluation run through all three, and the project applies them to one chosen area in depth.

Software Design and Development
The programming core: iterative (agile) and structured (waterfall) development methodologies and the full development process; object-oriented programming with classes, encapsulation, inheritance and polymorphism; the data structures (arrays, records, sequential files, linked lists, stacks and queues); the standard searching and sorting algorithms with recursion and efficiency; and planning testing and evaluating software quality.
Database Design and Development
The relational-database area: analysing and designing a database with entities, relationships, entity-relationship diagrams and keys; normalising data to third normal form; implementing and querying in SQL with joins, aggregate functions, grouping, subqueries and computed columns; and testing queries and maintaining referential integrity.
Web Design and Development
The web-application area: analysing requirements and designing with site structure diagrams and wireframes; building structure and presentation with HTML and CSS; adding client-side interactivity and form validation with JavaScript; writing server-side PHP that handles forms, manages sessions and connects to a database; and testing for usability, accessibility and fitness for purpose.

Course assessment

The Advanced Higher Computing Science award is graded A to D and is assessed by two components, both set or marked by the SQA.

  • Question paper - sat under exam conditions, lasting 2 hours, testing knowledge and skills from all three areas by asking you to read, write and reason about real code, SQL and web technologies.
  • Project (coursework) - a substantial practical task in one chosen area, recommended at around 40 hours with no fixed time limit, produced by the candidate and externally assessed.

The two components combine to give the final grade. There are no separate unit assessments in the graded award.

The skills the course tests

Across the question paper and project, the SQA tests applied skill, not just recall:

  1. Designing solutions. Producing the right design notation for the problem, whether a class diagram, an entity-relationship diagram, or a wireframe.
  2. Implementing accurately. Writing correct object-oriented code, SQL queries, and web pages in real languages.
  3. Choosing efficiently. Selecting the right algorithm, data structure or query, and reasoning about efficiency.
  4. Testing and evaluating. Planning tests with normal, extreme and exceptional data and judging a solution against its requirements.

How to study SQA Advanced Higher Computing Science

Advanced Higher Computing Science rewards practical fluency and disciplined process.

  1. Work from the specification. Each content statement in the SQA course specification is a checklist; both the paper and project are written from it.
  2. Program regularly. You must read and write real code, SQL and web technologies, so practise building, not just revising notes.
  3. Drill the high-value content. The standard algorithms and data structures, normalisation to third normal form, and the client-side versus server-side distinction recur across papers.
  4. Plan and document the project. Analyse and design before coding, test against expected results, and evaluate against the requirements.
  5. Practise past papers. Use SQA past papers and marking instructions to learn the question style and where the marks fall.

The three areas, topic by topic

Each area has a study guide, topic answer pages with worked examples and cross-links, and an area quiz. The project page covers the coursework and how the course is assessed. Browse the full set from this hub.

For the official course specification

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

Computer Science guides

In-depth written guides with paired practice quizzes.

See all β†’

Computer Science practice quizzes

Multiple-choice drills with worked answer explanations. Your scores stay on this device.

The SQA-ADVANCED-HIGHER system, explained

See all β†’

Common questions about Computer Science

How is SQA Advanced Higher Computing Science structured?
Advanced Higher Computing Science is an SCQF level 7 course built from three areas: Software Design and Development, Database Design and Development, and Web Design and Development. Software covers development methodologies, object-oriented programming, data structures, standard algorithms, and testing. Database covers analysis and design, normalisation to third normal form, and SQL. Web covers analysis and design, HTML and CSS, JavaScript, and server-side PHP with databases. Analysis, design, testing and evaluation run through all three. The course builds on Higher Computing Science and prepares learners for degree-level study.
How is SQA Advanced Higher Computing Science assessed?
The course is graded A to D from two components. A question paper, sat under exam conditions and lasting 2 hours, tests knowledge and skills from all three areas. A coursework project, a substantial practical task in one chosen area recommended at around 40 hours with no fixed time limit, is produced by the candidate and externally assessed by the SQA. The marks from both components combine to give the overall grade; there are no separate unit assessments in the graded award.
What does the project involve?
You take one substantial problem through the whole development process in a single chosen area: software, database or web development. You analyse the problem into a specification, design the solution with appropriate notations, implement it as working code, a database or a website, test it against a plan using normal, extreme and exceptional data, and evaluate it against the original requirements. Each stage produces documented evidence that is marked, so analysis, design, testing and evaluation matter as much as the implementation.
What does SCQF level 7 mean for Advanced Higher Computing Science?
SCQF is the Scottish Credit and Qualifications Framework. Advanced Higher sits at level 7, one level above Higher (level 6) and broadly comparable to the first year of a Scottish degree. Advanced Higher Computing Science develops object-oriented programming, data structures and algorithms, relational databases and SQL, and web development to a depth beyond Higher, signalling readiness for a computing science, software engineering or related degree.
How should I revise for SQA Advanced Higher Computing Science?
Work from the current SQA course specification, because both the question paper and the project are written from it. Build practical fluency in your centre's programming language, in SQL, and in the web technologies, since the exam asks you to read and write real code. Drill the standard algorithms and data structures, normalisation to third normal form, and the client-side versus server-side distinction. Use SQA past papers and marking instructions for exam technique, and follow the current coursework assessment task exactly for the project.
Which programming language does Advanced Higher Computing Science use?
The SQA does not mandate one language; centres choose a high-level language that supports object-oriented programming, with Python and Java both common. The course specification and question papers are written in a language-neutral way, and the SQA publishes a reference language so that pseudocode in the exam is unambiguous. You should be fluent in reading and writing object-oriented code, the standard algorithms and the core data structures in whichever language your centre uses, as well as SQL and the web technologies.