📚 Year 11 SQA Computing Science: Full Syllabus Breakdown | 苏格兰SQA计算机科学课程大纲全面解析
This article provides a comprehensive guide to the Year 11 SQA Computing Science course, which is typically taken as National 5 in Scottish secondary schools. We break down every unit, assessment component, and key skill you need to master, offering clear explanations in both English and Chinese to support bilingual learners. Whether you are just starting the course or preparing for the final exam and assignment, this syllabus breakdown will help you stay organised and focused.
本文为 Year 11（苏格兰中学通常对应的 National 5 阶段）SQA 计算机科学课程提供全面指南。我们将逐一解析每个单元、评估组成部分以及你需要掌握的关键技能，并用中英双语提供清晰解释，以帮助双语学习者。无论你是刚开始学习本课程，还是正在准备期末考试和作业，这份大纲解析都将帮助你保持条理并集中精力。
1. Course Overview | 课程概览
The SQA National 5 Computing Science course is designed to develop computational thinking, practical programming skills, and a broad understanding of how computer systems work. The qualification consists of four main topic areas: Software Design and Development, Computer Systems, Database Design and Development, and Web Design and Development. Throughout the year, learners also complete an Added Value Unit and a practical assignment that brings together knowledge from multiple topics. The course is graded A to D, based on performance in the final question paper and the assignment.
SQA National 5 计算机科学课程旨在培养计算思维、实用编程技能以及对计算机系统工作原理的广泛理解。该资格包含四个主要主题领域：软件设计与开发、计算机系统、数据库设计与开发以及网页设计与开发。在一学年中，学生还需完成一个附加价值单元和一个综合多主题知识的实践作业。最终成绩根据期末考试和作业表现评定为 A 至 D 等级。
Unlike lower school ICT courses, the focus here is on understanding the logic behind software, designing databases, coding algorithms, and explaining how hardware, networking and web technologies function. The bilingual approach in this guide aims to make technical vocabulary accessible in both languages.
与低年级的信息通信技术课程不同，这里的重点是理解软件背后的逻辑、设计数据库、编写算法，并解释硬件、网络和网页技术如何运作。本指南的双语方法旨在让技术词汇在两种语言中都易于掌握。
2. Assessment Structure | 评估结构
The course assessment has two components: a question paper worth 80 marks (2 hours) and a practical assignment worth 60 marks (completed over approximately 8 hours of class time). The question paper covers all four topic areas through a mix of short-answer and extended-response questions. You will be asked to read and write pseudocode, interpret database structures, explain system concepts, and analyse web design scenarios. The assignment is an open-ended practical task that requires you to design, implement, test and evaluate a solution involving either a software program, a database, or a website, applying knowledge from multiple units.
课程评估由两部分组成：一份笔试试卷（80 分，2 小时）和一份实践作业（60 分，在约 8 小时课堂时间内完成）。笔试试卷以简答题和拓展回答题结合的形式覆盖所有四个主题领域。你需要阅读和编写伪代码、解释数据库结构、阐述系统概念并分析网页设计场景。作业是一项开放的实践任务，要求你设计、实现、测试和评估一个涉及软件程序、数据库或网站的解决方案，并运用多个单元的知识。
Your final grade is determined by adding the marks from both components, which are then scaled to a total of 140 marks. To achieve a grade A, you typically need to demonstrate strong performance across all areas, showing deeper understanding in extended responses and a well‑structured, functional assignment.
最终成绩由两部分分数相加后按 140 分总分换算确定。要获得 A 级，你通常需要在所有领域都有出色的表现，在拓展回答中展示更深入的理解，并提交结构良好、功能实用的作业。
3. Software Design and Development | 软件设计与开发
This unit introduces the software development process: analysis, design, implementation, testing, and evaluation. You will learn how to interpret a problem, identify inputs and outputs, and plan a solution using design notations such as pseudocode, flowcharts, and structure diagrams. Emphasis is placed on writing readable, efficient code using an appropriate high-level language (commonly Python or Visual Basic in many SQA centres).
本单元介绍软件开发过程：分析、设计、实现、测试和评价。你将学习如何解读问题、识别输入和输出，并使用伪代码、流程图和结构图等设计符号规划解决方案。重点在于使用合适的高级语言（SQA 中心常用 Python 或 Visual Basic）编写可读、高效的代码。
You will work with data types including integer, real/float, string and Boolean, and understand how variables store values during execution. Assignment of values uses the ← symbol in SQA pseudocode, for example, SET score ← 0. You must also be able to trace the value of variables through a sequence of instructions.
你需要使用整型、实型/浮点型、字符串型和布尔型等数据类型，理解变量如何在执行过程中存储数值。SQA 伪代码中使用 ← 符号进行赋值，例如 SET score ← 0。你还必须能够通过一系列指令追踪变量的值。
4. Programming Constructs and Algorithms | 编程结构与算法
Control structures form the backbone of any program: sequence, selection (IF…THEN…ELSE) and iteration (loops). You must recognise and apply fixed loops (FOR) when the number of repetitions is known, and conditional loops (WHILE) when repetition depends on a condition. Correct use of logical operators (AND, OR, NOT) and relational operators (=, <>, >, <, >=, <=) is essential for writing conditions.
控制结构是任何程序的骨架：顺序、选择（IF…THEN…ELSE）和迭代（循环）。你必须识别并应用固定循环（FOR，当重复次数已知时）和条件循环（WHILE，当重复取决于条件时）。正确使用逻辑运算符（AND, OR, NOT）和关系运算符（=, <>, >, <, >=, <=）对于编写条件至关重要。
Key standard algorithms at National 5 level include input validation (using a conditional loop to ensure data falls within a desired range or format), running total (accumulating sum within a loop), linear search (checking each element in order), finding the minimum or maximum, and counting occurrences. You should be able to explain how these work in plain English and translate simple problems into pseudocode.
National 5 级别的关键标准算法包括输入验证（使用条件循环确保数据在期望范围或格式内）、累加求和（在循环中累加总数）、线性搜索（按顺序检查每个元素）、寻找最小值或最大值，以及统计出现次数。你应能通俗地解释这些算法的工作原理，并将简单问题转化为伪代码。
Testing strategies require you to plan normal, extreme, and exceptional test data, and to compare actual outcomes against expected results. Evaluation reflects on the solution’s fitness for purpose, efficiency, and potential improvements.
测试策略要求你规划正常、边界和异常测试数据，并将实际结果与预期结果进行比较。评价则反思解决方案是否符合目标、其效率以及可能的改进之处。
5. Computer Systems: Hardware and Software | 计算机系统：硬件与软件
This part of the syllabus looks at the physical components of a computer and the software that controls them. You will learn about the processor (CPU), which contains the Arithmetic Logic Unit (ALU) for calculations and logical decisions, the Control Unit for managing the fetch-execute cycle, and registers for temporary data storage. Memory types include RAM (volatile, stores currently running programs and data) and ROM (non‑volatile, stores boot instructions). Understanding the interaction between these components via buses (address, data, control) is fundamental.
大纲的这一部分涉及计算机的物理组件以及控制它们的软件。你将学习处理器（CPU），它包含用于计算和逻辑决策的算术逻辑单元（ALU）、管理取指-执行周期的控制单元，以及用于临时数据存储的寄存器。内存类型包括 RAM（易失性，存储当前运行的程序和数据）和 ROM（非易失性，存储启动指令）。理解这些组件通过总线（地址总线、数据总线、控制总线）的交互是基础。
Storage devices are compared in terms of capacity, speed, portability and reliability: magnetic (hard disk), optical (CD/DVD) and solid state (SSD/USB flash drive). Virtual memory using the hard drive as an extension of RAM is also covered. The software section distinguishes between system software (operating system, utility programs) and application software, with particular focus on operating system functions such as memory management, file management, and providing a user interface.
存储设备根据容量、速度、便携性和可靠性进行比较：磁介质（硬盘）、光介质（CD/DVD）和固态（SSD/USB 闪存驱动器）。利用硬盘作为 RAM 扩展的虚拟内存也在大纲之内。软件部分区分了系统软件（操作系统、实用程序）和应用软件，特别关注操作系统的功能，如内存管理、文件管理和提供用户界面。
6. Data Representation | 数据表示
Numbers, text, and images are all stored as binary inside computers. You must be able to convert between whole number denary (base 10) and binary (base 2) and understand why binary is used. For example, the denary number 42 is written as 101010₂. Units of storage from bits and bytes up to terabytes are tested, and you need to know that 1 byte = 8 bits, 1 kilobyte = 1024 bytes, and so on.
数字、文本和图像在计算机内部都以二进制形式存储。你必须能够进行十进整数（基数为 10）与二进制（基数为 2）之间的转换，并理解为什么使用二进制。例如，十进制数 42 写作 101010₂。从比特、字节到太字节的存储单位也是考查内容，你需要知道 1 字节 = 8 比特，1 千字节 = 1024 字节，以此类推。
Text representation is covered through ASCII and Unicode. ASCII uses 7 or 8 bits to represent characters, sufficient for English, while Unicode supports a much wider range of characters for global languages. Bit-mapped graphics store the colour of individual pixels, so increasing resolution or colour depth increases file size; vector graphics store objects as mathematical descriptions and can be scaled without losing quality.
文本表示涵盖 ASCII 和 Unicode。ASCII 使用 7 或 8 位表示字符，足以应对英语，而 Unicode 则支持更广泛的全球语言字符集。位图图形存储每个像素的颜色，因此提高分辨率或色彩深度会增加文件大小；矢量图将对象存储为数学描述，缩放时不会损失质量。
7. Networking and Security | 网络与安全
Networking concepts include types of networks (LAN, WAN), client‑server and peer‑to‑peer architectures. You need to describe the functions of key hardware such as routers, switches, and network interface cards (NICs). IP and MAC addressing are compared: an IP address identifies a device on a network and may change, while a MAC address is a unique hardware identifier. The advantages of networking, like file sharing, centralised backups, and communication, are balanced against risks like malware spread and security breaches.
网络概念包括网络类型（LAN、WAN）、客户端‑服务器和对等网络架构。你需要描述路由器、交换机和网络接口卡等关键硬件的功能。IP 与 MAC 地址需加以比较：IP 地址标识网络上的设备且可能变化，而 MAC 地址是唯一的硬件标识符。网络的优势，如文件共享、集中备份和通信，需要与恶意软件传播和安全漏洞等风险相权衡。
Security measures include firewalls, encryption, and access rights. You should also be aware of threats such as viruses, phishing, and denial‑of‑service attacks. The legal context includes the Computer Misuse Act and Data Protection Act, which you may need to refer to when discussing the ethics of data storage and online behaviour.
安全措施包括防火墙、加密和访问权限。你还应了解病毒、网络钓鱼和拒绝服务攻击等威胁。法律背景包括《计算机滥用法》和《数据保护法》，在讨论数据存储和在线行为的伦理时可能需要引用这些法律。
8. Database Design and Development | 数据库设计与开发
A database is an organised collection of data, managed using a Database Management System (DBMS). This topic starts with flat file and relational databases, emphasising the benefits of reducing data redundancy by splitting data into linked tables. Key terms include field, record, primary key, and foreign key. You must be able to identify these in a given table structure and explain their purpose.
数据库是使用数据库管理系统（DBMS）管理的有组织的数据集合。本主题从平面文件数据库和关系数据库开始，强调通过将数据拆分到关联表中来减少数据冗余的好处。关键术语包括字段、记录、主键和外键。你必须能在给定的表结构中识别它们并解释其用途。
Field types include text, number, date, and Boolean. Validation techniques such as presence check, restricted choice, range check, and length check help maintain data integrity. Although you may create forms and reports in the assignment, the exam focuses on writing SQL queries to retrieve data. You need to be confident with the SELECT statement, including FROM, WHERE, and ORDER BY clauses. A typical exam question might ask you to write an SQL statement like: SELECT forename, surname FROM customer WHERE town = ‘Edinburgh’ ORDER BY surname ASC;
字段类型包括文本、数字、日期和布尔型。存在性检查、限定选择检查、范围检查和长度检查等验证技术有助于维护数据完整性。尽管作业中可能会创建窗体和报表，但考试侧重于编写用于检索数据的 SQL 查询。你需要熟练使用 SELECT 语句，包括 FROM、WHERE 和 ORDER BY 子句。典型的考题可能要求你写出如下 SQL 语句：SELECT forename, surname FROM customer WHERE town = ‘Edinburgh’ ORDER BY surname ASC;
9. Web Design and Development | 网页设计与开发
This unit explores how websites are built using HTML for structure and CSS for presentation. You must know the basic HTML tags: <html>, <head>, <title>, <body>, <h1>–<h6>, <p>, <a>, <img>, <ul>, <ol>, and <li>. Understanding how to link to other pages and to external stylesheets is essential. Inline, internal, and external CSS are compared, with emphasis on the advantages of external stylesheets for consistency and ease of maintenance.
本单元探讨如何使用 HTML 构建网站结构以及使用 CSS 进行呈现。你必须了解基本的 HTML 标签：<html>、<head>、<title>、<body>、<h1> 至 <h6>、<p>、<a>、<img>、<ul>、<ol> 和 <li>。理解如何链接到其他页面和外部样式表至关重要。文章会比较行内、内部和外部 CSS，并强调外部样式表在保持风格一致和易于维护方面的优势。
CSS selectors include element, class, and ID selectors, and you should be able to set properties such as font‑family, colour, background‑colour, and text‑align. Good design principles involve clear navigation, consistency, readability, and the appropriate use of multimedia. You also need to consider legal aspects, including copyright for images and text, and data protection when collecting user information.
CSS 选择器包括元素选择器、类选择器和 ID 选择器，你应能够设置 font‑family、colour、background‑colour 和 text‑align 等属性。良好的设计原则包括清晰的导航、一致性、可读性和恰当使用多媒体。你还需要考虑法律层面，包括图像和文本的版权问题，以及收集用户信息时的数据保护要求。
10. Study and Exam Tips | 学习与备考建议
Start revision early by breaking the syllabus into the four topic areas and allocating time each week. Regularly write out pseudocode by hand and trace small programs to build confidence with programming logic. Use past papers from the SQA website under timed conditions, and review the marking schemes to understand how marks are allocated. Many students lose marks by not reading questions carefully, so underline key command words such as describe, explain, state, and calculate.
尽早开始复习，把大纲分解为四个主题领域，每周分配时间。经常手写伪代码并追踪小程序，以建立对编程逻辑的信心。在限时条件下练习 SQA 官网上的历年真题，并查阅评分方案以了解分数如何分配。许多学生因未仔细审题而失分，因此要划出诸如描述、解释、陈述和计算等关键指令词。
For the assignment, plan your time carefully across analysis, design, implementation, testing, and evaluation. Keep a simple log of decisions and test results as you go, as this evidence supports your final write‑up. Practise writing SQL queries and HTML/CSS by hand, because you may need to correct or complete code snippets in the exam.
对于作业，要仔细规划分析、设计、实现、测试和评价各阶段的时间。随时记录决策和测试结果的简单日志，这些证据将支持你的最终报告。练习手写 SQL 查询和 HTML/CSS 代码，因为在考试中你可能需要纠正或补全代码片段。
Published by TutorHao | Computing Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导