Scotland Β· SQASyllabus
Computer Science syllabus, dot point by dot point
Every dot point in the Scotland Computer Sciencesyllabus, with a focused answer for each one. Click any dot point for a worked explainer, past exam questions, and links to related dot points. Written by Claude Opus 4.8, Anthropic's latest AI.
Area 2: Computer Systems
Module overview β- What are the main parts of a processor and how do they work together to run a program?The structure of a computer: the processor (ALU, control unit and registers), the buses (data and address) used to read from and write to memory, and the difference between an interpreter and a compiler.11 min answer β
- How are text characters and program instructions stored as binary?Representing characters using ASCII, extended ASCII and Unicode, and the principle that program instructions and all real-world data are ultimately stored as binary.10 min answer β
- How does a computer store positive and negative whole numbers and very large or very small real numbers in binary?Representing positive and negative integers using two's complement, and representing real numbers using floating-point with a mantissa and exponent.12 min answer β
- What is the environmental cost of computer systems, and how can it be reduced?The environmental impact of computer systems: their energy consumption, ways to reduce that impact, and the environmental considerations of intelligent systems.10 min answer β
Area 3: Database Design and Development
Module overview β- How do you model the data for a real problem as linked tables before building a database?Analysing a database problem and designing the data model: entity-relationship diagrams, entities and attributes, relationships and cardinality, the data dictionary, and primary, foreign and compound keys.12 min answer β
- How does a database keep its linked data consistent and reject bad input?Referential integrity and entity integrity between linked tables, and validation of data entered into a database (presence, restricted choice and field length checks).11 min answer β
- How do you add, change and remove records in a relational database, and what are the consequences?Changing the data in a relational database with SQL INSERT, UPDATE and DELETE on prepopulated linked tables, and the implications of these operations.11 min answer β
- How do you ask a relational database questions across linked tables using SQL?Querying a relational database with SQL SELECT, including WHERE, joining multiple tables, ORDER BY, aliases, wildcards, computed values, aggregate functions and GROUP BY.13 min answer β
Area 1: Software Design and Development
Module overview β- How do you turn a vague problem into a precise statement of what a program must do?The analysis stage: identifying the purpose, scope, boundaries and functional requirements of a problem to produce a requirements specification.10 min answer β
- What are the building blocks of program logic, and how do sub-programs share data?Computational constructs: assignment and arithmetic, selection with logical operators, fixed and conditional iteration, pre-defined functions, and sub-programs with parameter passing (by value and by reference) and variable scope.12 min answer β
- How does a program store single values and whole collections of data?Data types and structures: variables of simple types, 1-D arrays, records, and parallel arrays or arrays of records, with string operations.11 min answer β
- How do you plan the structure and logic of a program before writing any code?Design notations used to describe a solution: structure diagrams, flowcharts and pseudocode, and the design of the user interface (wireframes).11 min answer β
- How is software developed in stages, and how do iterative and agile approaches differ from the traditional waterfall process?The iterative software development process (analysis, design, implementation, testing, documentation and evaluation) and the difference between the traditional waterfall approach and agile methodologies.11 min answer β
- What standard patterns solve the most common data-processing problems?Standard algorithms: input validation, running total within a loop, traversing a 1-D array, linear search, counting occurrences, and finding the minimum or maximum.12 min answer β
- How do you find errors in a program and judge whether it is any good?Testing with normal, extreme and exceptional test data; syntax, execution and logic errors; debugging techniques; and evaluating software for fitness for purpose, efficiency, robustness and readability.11 min answer β
- What does the Higher Computing Science assignment require, and how is it marked?The course assignment: practical tasks worth 40 marks that apply the analysis, design, implementation, testing and evaluation skills to software and to either a database or a website.9 min answer β
Area 4: Web Design and Development
Module overview β- How do you plan a website's purpose, structure and layout before building it?Analysing a website's purpose and functional requirements, and designing its structure and interface using a site structure diagram, wireframes and a low-fidelity prototype.10 min answer β
- How do you control the appearance and layout of a web page with CSS?Styling a web page with CSS: element, class and id selectors; controlling appearance and positioning; internal, external and inline styles; and a horizontal navigation bar.11 min answer β
- How do you mark up the structure and content of a web page with HTML?Building a web page with HTML: the page-layout structural elements (header, nav, section, footer), links, images, lists and tables, and forms for user input.11 min answer β
- How do you make a web page respond to the user and change its content?Adding interactivity with JavaScript: responding to events (such as onclick and onmouseover), writing functions, and changing page elements through the DOM (for example getElementById and innerHTML).11 min answer β
- How do you test a website and judge whether it meets its requirements?Testing a website against its requirements (links, forms and scripts), checking usability and browser compatibility, and evaluating it for fitness for purpose.10 min answer β