Course units
CS · Computer Systems
13 of 13 Complete 🎉
Computer Systems
Data representation, computer architecture, storage, and the environmental and security impacts of computing.
- CS1Binary & Denary Conversion
- CS1bFloating Point Representation
- CS2Data Representation: Text
- CS3Data Representation: Graphics
- CS4Data Representation: Sound
- CS5Computer Structure
- CS6Memory
- CS7Storage Devices
- CS8Translators
- CS9Environmental Impact & Security
- CS10Past Paper Practice
- CS11Assessment Review: Representation & Calculations · Double Part 1
- CS12Assessment Rectification: Technical Answers · Double Part 2
- REVCS1–9 Revision Checkpoint · 2-hour cover lesson
SDD · Software Design & Development
19 of 19 Available
Software Design & Development
Design methodologies, programming constructs, standard algorithms, and testing — the largest unit in the course.
- SetupGetting started: set up PyCharm
- SDD1Development methodologies
- SDD2Analysis and requirements
- SDD3Design: structure diagrams and flowcharts
- SDD3bDesign: wireframe UI design
- SDD4Design: pseudocode
- SDD5Variables, data types and arithmetic
- SDD6Input, output and string operations
- SDD7Selection: if/else statements
- SDD8Complex conditions: AND, OR, NOT
- EXTExtension Studio · challenges from SDD5 onwards
- PROJECTLeisure Centre Booking Adviser
- SDD9Fixed loops
- SDD10Conditional loops
- SDD11Predefined functions
- SDD12Arrays
- SDD13Standard algorithms: linear search
- SDD14Standard algorithms: min, max, count
- SDD15Standard algorithms: input validation and running total
- SDD16Testing: errors and test plans
- SDD17Evaluation and code quality
- SDD18SDD past paper practice
DDD · Database Design & Development
10 of 10 Complete 🎉
Database Design & Development
Relational database concepts, entity-relationship modelling, and SQL queries from first filters to multi-table queries.
- SetupGetting started: set up DataGrip
- DDD1Database concepts and terminology
- DDD2Entity-relationship diagrams
- DDD3Analysis and UK GDPR
- DDD4Data Dictionary and Validation
- DDD5SQL: first queries with SELECT and WHERE
- DDD6SQL: filtering with conditions
- DDD7SQL: sorting and ranges
- DDD8SQL: complex conditions and brackets
- DDD9SQL: joining tables
- DDD10SQL: updating data, testing, and evaluation
WDD · Web Design & Development
13 of 13 Complete 🎉
Web Design & Development
Site analysis, wireframing, file formats, HTML, CSS, JavaScript events, and usability testing.
- WDD1Analysis and site structure
- WDD2Wireframes and prototyping
- WDD3File formats, compression and copyright
- WDD4HTML: semantic elements and structure
- WDD5HTML: links, media and addressing
- WDD6CSS: selectors, properties, box model
- WDD7CSS: typography, colour and layout
- WDD8CSS: external stylesheets and cascade
- WDD9CSS: navigation and pseudo-classes
- WDD10JavaScript: events and mouse handling
- WDD11Testing: browsers, accessibility and usability
- WDD12Evaluation
- WDD13WDD past paper practice
Tools & resources
PyCharm Setup Guide
Activate, create projects & turn off autocomplete
Assignment Guide
Understand tasks, marks & evidence
draw.io Quick Guide
Create structure diagrams & flowcharts
Glow Access Guide
Access SCHOLAR & e-Sgoil without cookie clashes
Course Specification Checklist
See every required SQA topic
Course Glossary
Search key terms across all units
Escape Room Challenge
Python puzzles: solve the locks and get out