Course Overview
Everything you need to know about Higher Computing Science 2026–27 — in one place.
Welcome & introduction
Welcome to Higher Computing Science. This page is your starting point — read it properly at the beginning of the year, then come back to it whenever you need a reminder of the bigger picture. It covers exactly what we'll learn, when, how you'll be assessed, and what you need to do to succeed.
Higher Computing Science is one of the most practical and transferable qualifications you can take at school. This isn't just about learning to code (though you'll do a lot of that). Over the course of the year you'll learn how computers work at a hardware level — how data is stored in binary, how the processor fetches and executes instructions. You'll learn how professional software developers design and build systems, using Python as your working language. You'll learn how databases store and retrieve millions of records efficiently, and how to query them with SQL. And you'll learn how websites are built from scratch using HTML, CSS, and JavaScript.
These are real, in-demand skills. Computing Science graduates go into software engineering, data science, web development, cybersecurity, AI research, and dozens of other fields. The specific content of this course — Python, SQL, web development, algorithms — maps directly onto what employers and universities are looking for.
The course is genuinely challenging — there's no point pretending otherwise. You'll need to learn precise technical vocabulary, practise converting numbers between representations until it's fast and reliable, write and debug code, design databases, and create working websites from scratch. Some topics will click straight away; others will need repeated practice before they feel natural. That's completely normal and it's part of what makes the qualification meaningful.
What makes it very achievable is this: the SQA exam is highly predictable. The same types of questions come up year after year. The pupils who succeed at Higher Computing Science are rarely the most "naturally gifted" — they're the ones who turn up, practise consistently, keep their notes organised, and ask questions when they're stuck. If you do those four things, you'll do well.
The four units
The course is divided into four units, taught in sequence across the year. Each unit has its own character — CS is analytical, SDD is practical, DDD is structural, WDD is creative — but they share an underlying logic about how good systems are designed, built, and tested.
- Data representation: positive integers, two's complement, floating-point, Unicode
- Bitmap vs vector graphics — storage, quality, and appropriate use
- Fetch-execute cycle and CPU performance factors (clock speed, cores, cache)
- Environmental impact of intelligent systems
- Security: Computer Misuse Act, cookies, denial of service attacks
- Encryption: public-key and private-key cryptography
- Development methodologies: iterative and agile
- Analysis: purpose, scope, and functional requirements
- Design: structure diagrams, pseudocode, wireframes
- Data structures: parallel arrays, records, arrays of records
- Parameter passing (by value/reference) and variable scope
- Pre-defined functions and file handling (CSV and plain text)
- Standard algorithms: linear search, find min/max, count occurrences
- Testing: test plans, error types, dry runs, trace tables, breakpoints
- Evaluation: fitness for purpose, efficiency, maintainability
- Analysis: end-user requirements and functional requirements
- Entity-relationship diagrams with 3+ entities; entity-occurrence diagrams
- Data dictionaries and compound primary keys
- Validation: presence check, restricted choice, field length, range
- Query design: tables, fields, criteria, sort order, calculations, grouping
- SQL: SELECT, WHERE, GROUP BY, ORDER BY, aggregate functions, computed values, aliases, INSERT, UPDATE, DELETE
- Testing and evaluation
- Analysis: end-user requirements and functional requirements
- Multi-level site structure and wireframe design
- HTML: semantic elements, forms, form inputs and validation
- CSS: display, float, clear, margins, padding, sizes and horizontal navigation
- JavaScript: functions using onclick, onmouseover and onmouseout
- Testing and evaluation
Your timetable
You have five Computing Science lessons per week across three days, giving approximately 160 hours of taught time across the year. The new timetable starts 1 June 2026.
What each lesson type is good for
Double lessons (Monday and Thursday, 120 minutes) are where most of the practical work happens. 120 minutes is enough time to introduce a concept, work through examples together, and have a proper go at tasks — without the bell interrupting you mid-problem. These are the lessons for writing Python, building databases, coding websites, and doing multi-step worked examples. Use the full time: if you finish the set tasks early, start the extension or revisit something you're not confident on.
Single lessons (Tuesday, 60 minutes) work well for theory, discussion, and consolidation. We'll review what happened in the previous double, look at exam-style questions, check understanding of tricky concepts, and occasionally do pair activities. Don't make the mistake of thinking "no coding today" means a lighter session — theory questions are where many marks are lost in the final exam.
Year at a glance
Below is an overview of when each unit runs. CS is woven through Term 1 doubles rather than taught as a single block, so you'll see it alongside SDD throughout autumn.
Assessment
Your final grade comes from two components: a question paper (80 marks) sat in the SQA exam diet, and an assignment (40 marks) completed under supervised conditions in school. Together they give a total of 120 marks.
The Prelim
The prelim is an internal school exam that historically runs across the first three weeks of January 2027. It uses the same format as the SQA question paper — both sections, same structure, same timing — and gives you a realistic trial run of the real exam with time to act on the feedback.
Take the prelim seriously. The feedback you get from it — specifically, the questions you dropped marks on — is one of the most valuable things in the entire course. Pupils who carefully review their prelim paper and fix their gaps before May consistently perform better in the real exam. Pupils who file it away and move on do not.
You don't formally decide between DDD and WDD until you sit the exam. Using the prelim to try one option is a useful way to get feedback and test your preparedness — but you can change your choice between the prelim and May. Your task choice in the assignment (Task 2 vs Task 3) is a separate decision and doesn't have to match your exam choice.
What this course expects of you
The following aren't generic "work hard" advice. They're specific habits that separate pupils who find Higher Computing Science manageable from those who struggle. Read them honestly.
-
1Keep up with lesson notesLesson pages go live the morning of each lesson. If you miss a lesson, read the page and catch up before the next one. The notes from September become the revision material in January. A gap in October is much harder to fill in December than it would have been in October.
-
2Practise conversions and algorithms until they're automaticBinary conversion, two's complement, and the three standard algorithms (linear search, find min/max, count occurrences) come up every single year. They require no notes in the exam — just instant, reliable recall. The only way to get there is repeated practice, not re-reading. Do a conversion every day for a week; it'll stick in a way that passive understanding won't.
-
3Write code regularly outside of lessonsTwenty minutes of Python a couple of times a week compounds enormously over a year. You don't need a project — open VS Code and try something. Redo a worked example from scratch without looking at the solution. Attempt a past-paper algorithm question. The act of typing code (not just reading it) is what builds the muscle memory that gets you through the assignment under timed conditions.
-
4Read exam questions carefullyMore marks are lost to misreading questions than to not knowing the content. Pay attention to command words: "describe" wants a description, "explain" requires a reason, "identify" just needs a name. Check the mark allocation — a 3-mark question needs three distinct points. Practise annotating questions before writing your answer; it takes 30 seconds and consistently leads to better responses.
-
5Ask questions — don't hope it'll clickIf something doesn't make sense, ask. In class is always best — other people probably have the same question. If the lesson moves on before you get the chance, come to supported study or send a Teams message. There are no silly questions in Computing Science. The alternative — hoping confusion will resolve itself — rarely works, and the topics build on each other.
-
6Attempt past paper questions from early in the courseYou don't need to wait until April to use past papers. Once you've covered a topic, find the relevant questions from previous years and attempt them under exam conditions — no notes, timed. This tells you immediately whether you understood what you think you understood. Papers from 2023, 2024, and 2025 are freely available on the SQA website (see Resources).
-
7Use worked examples as revision tools, not just reading materialEvery lesson page has worked examples. The most effective way to revise from them is to cover the solution, attempt the problem yourself, then check. When you get something wrong, work out exactly where and why — not just "I got it wrong". Understanding your errors is most of what revision actually is.
How this course is organised
Lesson pages
Every lesson has a dedicated page on this website. Each page follows exactly the same structure, so once you're used to it, you'll always know where to find things:
- Learning intentions — what we're aiming to learn in this lesson
- Success criteria — specific, checkable things you should be able to do by the end
- Notes and explanations — the lesson content, with concepts explained and examples worked through step by step
- Worked examples — full solutions showing method, not just answers
- Tiered tasks — three levels of questions (see below)
When pages are released
Lesson pages go live on the morning of the lesson — not before. Pages are updated right up to the lesson and may change based on what was covered in the previous one. If you miss a lesson, the page will still be there — use it to catch up before the next class.
The three task tiers
Every lesson includes three levels of tasks. They're not labelled by ability — they're labelled by depth:
Past papers and marking instructions
SQA past papers for Higher Computing Science are freely available on the SQA website. The Resources section below has the links you need. Marking instructions (the official mark schemes) are published alongside each paper. Use both. Get into the habit of marking your own work against the official criteria — it is one of the most effective revision techniques available to you, and it's completely free.
Organising your files and notes
You will use three different places to store your work this year. Each has a specific job. Getting this right from the start saves a lot of confusion — especially when the assignment comes around and you need to find everything quickly.
H drive (this computer only)
Your working files — code, database files, and web projects you are actively editing during a lesson. These only exist on this machine.
OneDrive (cloud, any device)
Your completed lesson PDFs — exported at the end of every lesson. Backed up automatically, accessible from home.
OneNote Class Notebook (your revision resource)
Your annotated lesson notes — each PDF inserted as a printout, with your own annotations on top. This is what you revise from and refer to during the assignment.
Files saved to the H drive cannot be accessed from any other machine — not from home, not from a different school computer. Never save your only copy of important work there. Documents and PDFs belong on OneDrive.
Set up your H drive — working files
The H drive is for files you are actively editing during class: Python code, database files, and web project files. Set up this structure once, at the start of the year.
Higher Computing Science.Computer Systems has no H drive folder — CS lessons don't involve files you edit. All CS work is PDF exports straight to OneDrive.
Set up your OneDrive — documents and PDFs
OneDrive is linked to your school Microsoft 365 account. Create a mirrored structure here — but include all four units, since every lesson generates a PDF.
Make sure it says City of Edinburgh Council — not "OneDrive — Personal". The personal account is not for school work.
Set up your OneNote Class Notebook
Your teacher has already created the Class Notebook — you don't need to make it. You just need to find it and open it in the desktop app.
You only need to do this once. After the first time, the Class Notebook stays in your OneNote app permanently.
Computer SystemsSoftware Design and DevelopmentDatabasesWeb Design and Development
Your workflow — every lesson
Follow these five steps at the end of every lesson. It takes about two minutes and builds your entire revision resource automatically.
That's it. Repeat for every lesson. By the time the assignment comes around you'll have a complete, searchable set of annotated notes covering the whole course — and it's open-book.
Detailed export steps
CS1 Binary Positive Integers) and click Save.CS1 — Binary Positive Integers.Use "File Printout", not "File Attachment". Attachment embeds a clickable icon — it doesn't display the lesson on the page. Printout renders every page visibly so you can read and annotate it directly.
CS1 Binary Positive Integers) and tap Save.Can't see OneDrive in Files? Open the Files app → tap Browse → tap ··· → Edit → enable OneDrive. Sign in with your school Microsoft 365 account.
Shortcut: In the Files app, long-press the PDF → Share → Copy to OneNote. OneNote asks which section to add it to.
Naming convention — quick reference
| What | Name it like this | Saved where |
|---|---|---|
| PDF of a completed lesson | CS1 Binary Positive Integers.pdf | OneDrive › Higher Computing Science › Computer Systems |
| OneNote page title | CS1 — Binary Positive Integers | Computer Systems section of Class Notebook |
| Python code file | SDD5 variables.py | H drive › Higher Computing Science › Software Design and Development |
| Database file (.db) | films.db | H drive › Higher Computing Science › Databases |
| Web project folder | WDD3 My Website | H drive › Higher Computing Science › Web Design and Development |
Python setup
We use Python 3 throughout the Software Design & Development unit. Python should be available on school computers, but setting up your own machine lets you practise at home. Here's a step-by-step guide that assumes you've never installed Python before.
python3 --version. If it prints a version number, you're done. If it says "command not found", download from python.org.Ctrl+Shift+X on Windows or Cmd+Shift+X on Mac. Search for Python and install the extension published by Microsoft. This gives you syntax highlighting, error detection while you type, and the ability to run Python files directly inside VS Code.hello.py. The .py extension tells VS Code (and your computer) that this is a Python file. Type the following on line 1:print("Hello, Higher Computing!")
python hello.py # Windows python3 hello.py # Mac or Linux
Hello, Higher Computing! printed in the terminal. If you do — you're set up and ready for the SDD unit.Using Python on an iPad
VS Code and the standard Python install don't run on iPadOS. Two alternatives that work well:
- Replit (replit.com) — free, entirely browser-based, no install needed. Create a free account, start a new Python Repl, and you have a working Python editor and runner in your browser. Works well on iPad and any device.
- Pythonista — a paid app (approximately £10) on the App Store. A full Python 3 environment with a good code editor, built for iOS. Worth it if you plan to code regularly on iPad.
Python and a code editor should be available on school machines. If something isn't working, tell the teacher at the start of the lesson — don't spend lesson time troubleshooting an installation problem on your own.
SQL setup
For the Database Design & Development unit, you'll be writing SQL queries against a relational database. The easiest setup — and the one we'll use in lessons — needs no installation at all.
Recommended: SQLite Online (browser-based, no install)
Go to sqliteonline.com in any browser. You can create tables, import data, and run SQL queries entirely in the browser — no account required, no download, no configuration. It works on iPad, any laptop, and any school computer. This is what we'll use in class.
SQLite is a real, production-grade database engine used in millions of applications — many of the apps on your phone use it. The difference from "server" databases like MySQL or PostgreSQL is that SQLite stores everything in a single file rather than running as a separate background service. For learning SQL, this is an advantage: nothing to install, no server to start, and the SQL syntax you learn here transfers directly to any other database system.
Alternative: DB Browser for SQLite (free desktop app)
If you prefer a desktop application, DB Browser for SQLite is a free, open-source tool available from sqlitebrowser.org. It gives you a visual interface for building and viewing tables alongside a SQL editor. Works on Windows, macOS, and Linux. Not available on iPad.
Useful resources
SQA and official materials
Python
Web development (for the WDD unit, starting November)
The SQA past papers and marking instructions are the single most valuable revision resource for this course. They're free, they're accurate, and they show you exactly how the exam works — including the precise wording that earns marks. Don't save them for April. After each topic is taught, find the relevant questions from previous years and attempt them.
Supported study & getting help
Supported study sessions
Supported study sessions run throughout the year. They're a chance to ask questions, work through past papers, get help with code in a relaxed environment, or just use the time to catch up. Sessions are most productive if you come with a specific question or a past paper attempt to review.
Working with other people
One of the most underrated revision strategies in Computing Science is working with a classmate. Explaining a concept forces you to understand it properly — much more than re-reading does. Pair programming (one person writes, one talks through the logic) is a genuine technique used by professional software teams and works well for exam prep too.
Quiz each other on binary conversions. Talk through algorithm trace tables together. Review each other's SQL queries. This kind of collaborative practice is encouraged — just make sure your assignment submission is your own independent work.
A note for parents and carers
What the course covers
Higher Computing Science is a full-year course covering four areas: how computers work at a hardware level (data representation, processing, security), Python programming (analysis, design, implementation, testing), relational databases (ER diagrams, SQL), and web development (HTML, CSS, and JavaScript). It's a practical and intellectually demanding course that carries real weight for applications to computing, engineering, data science, and related fields at university and college.
Assessment
There are two assessed components:
- Question paper (80 marks, 2 hours) — sat during the SQA exam diet in May 2027. Covers all four units. Section 1 (55 marks) is mandatory; Section 2 (25 marks) is a choice between two optional topics.
- Assignment (40 marks, 6 hours total) — completed under supervised conditions in school across the window of February to March 2027. It is open-book and sent to SQA for marking.
There is also an internal prelim exam in January 2027 which mirrors the SQA question paper and provides formal feedback before the exam diet.
How to support at home
- Encourage regular, short practice sessions. Computing Science rewards consistent habit over last-minute revision. Even 20–30 minutes a few times a week — reviewing notes, attempting past paper questions, or writing a small Python program — makes a significant difference compounded over a year.
- Check that lesson notes are being reviewed. Every lesson has a page on this website. If your young person can explain what they learned in a recent lesson, that's a good sign. If they can't, encourage them to re-read the page rather than waiting for it to come up again in class.
- Encourage early requests for help. Topics in this course build on each other. A gap in understanding from September can become a significant problem by January if it isn't addressed. The teacher is available via Teams and runs supported study sessions throughout the year.