📚 SQA Computing Science Year 10 Syllabus: A Complete Breakdown | Year 10 SQA 计算机：课程大纲全面解析
The SQA Computing Science course at Year 10 (typically National 5 level in Scotland) gives students a robust foundation in computational thinking, programming, and information system design. This article provides a complete breakdown of every topic, assessment method, and key skill required to succeed. Whether you are starting the course or preparing for the final assignment and exam, understanding the full syllabus structure will help you stay on track.
SQA 在 Year 10（通常对应苏格兰 National 5 水平）开设的计算机科学课程，为学生奠定了计算思维、程序设计和信息系统设计方面的扎实基础。本文将全面解析课程大纲中每一个主题、评估方式和必备技能。无论你是刚开始学习这门课，还是正在为期末作业和考试做准备，掌握完整的课程框架都能帮助你稳步前进。
1. Course Overview and Structure | 课程概览与结构
The SQA National 5 Computing Science syllabus is divided into four key units: Software Design and Development, Information System Design and Development, the Assignment, and the Question Paper exam. Together they cover both practical programming and theoretical knowledge about how computers and information systems work. The course aims to develop problem-solving skills, logical thinking, and an understanding of the impact of computing on society.
SQA National 5 计算机科学课程大纲分为四个主要部分：软件设计与开发、信息系统设计与开发、课程作业（Assignment）以及笔试（Question Paper）。它们共同涵盖了实际编程技能和关于计算机及信息系统工作原理的理论知识。该课程旨在培养解决问题能力、逻辑思维，并让学生理解计算技术对社会的影响。
- Software Design and Development (SDD): focuses on programming, algorithms, testing
- Information System Design and Development (ISDD): covers databases, web design, computer systems
- Assignment: a practical project where you apply skills from both SDD and ISDD
- Question Paper: a final written exam on theory from all units
- 软件设计与开发（SDD）：聚焦于编程、算法、测试
- 信息系统设计与开发（ISDD）：涵盖数据库、网页设计、计算机系统
- 课程作业（Assignment）：一个运用 SDD 和 ISDD 技能的实际项目
- 笔试（Question Paper）：涵盖所有单元理论知识的最终书面考试
2. Software Design and Development Unit | 软件设计与开发单元
This unit forms the core of your programming journey. You will learn to analyse problems, design solutions with pseudocode or flowcharts, and implement them in a high-level language such as Python or LiveCode. The emphasis is on modular programming, using procedures and functions, and applying data types and structures effectively. Understanding the software development process is just as important as writing code.
这一单元是你编程学习之旅的核心。你将学会分析问题、用伪代码或流程图设计解决方案，并用像 Python 或 LiveCode 这样的高级语言来实现。重点在于模块化编程、使用过程和函数，以及有效应用数据类型和结构。理解软件开发过程和写代码本身同样重要。
You must be comfortable with sequence, selection (if statements), and iteration (loops). You will also work with arrays (lists), string handling, file input/output, and simple algorithms such as linear search and counting occurrences. Testing and debugging using normal, extreme, and exceptional test data is a required skill.
你必须熟练掌握顺序结构、选择结构（if 语句）和循环结构（迭代）。你还将学习使用数组（列表）、字符串处理、文件输入/输出，以及线性查找和计数等简单算法。使用正常数据、边界数据和异常数据进行测试和调试是一项必备技能。
3. Programming Paradigms and Language Features | 编程范式与语言特性
les, constants, arithmetic operations (+, -, *, /, ^), and relational operators (>, <, ==, ! parameters by value and by reference, and distinguish between local and global variables.
在 National 5 级别，你通常会使用过程式编程语言。你需要正确使用变量、常量、算术运算（+, -, *, /, ^）和关系运算符（>, <, ==, !=, >=, <=）。在条件中会使用 AND、OR、NOT 构成的布尔表达式。你将学习按值传递参数和按引用传递参数，并区分局部变量和全局变量。
A key concept is top-down design with stepwise refinement. You will break a problem into sub-problems and then implement each part as a separate module. Understanding the difference between a function (which returns a value) and a procedure (which does something without returning a value) is essential. Standard algorithms like input validation and running total must be memorised.
一个关键概念是通过逐步细化的自顶向下设计方法。你将问题分解为子问题，然后将每个部分作为一个独立模块实现。理解函数（返回值）和过程（不返回值但执行操作）之间的区别至关重要。像输入验证、累加求和这样的标准算法必须熟记。
4. Design Notations: Pseudocode and Flowcharts | 设计表示法：伪代码与流程图
Before writing any code, you are expected to produce a design using either pseudocode or a flowchart. Pseudocode uses structured English keywords like INPUT, OUTPUT, SET, IF...THEN...ELSE, REPEAT...UNTIL, and WHILE...DO. Flowcharts use standard symbols: oval for start/end, parallelogram for input/output, rectangle for process, diamond for decision, and arrows for flow of control.
在编写任何代码之前，你需要使用伪代码或流程图完成设计。伪代码使用结构化的英文关键词，如 INPUT、OUTPUT、SET、IF...THEN...ELSE、REPEAT...UNTIL 和 WHILE...DO。流程图使用标准符号：椭圆形表示开始/结束，平行四边形表示输入/输出，矩形表示处理过程，菱形表示判断，箭头表示控制流向。
Your design must clearly show the logic of the solution, including loops and decisions. Teacher-assessed coursework often requires you to hand in design documents before implementation. A good design reduces errors and makes coding much faster. You should practise reading and interpreting both notations, as exam questions can ask you to trace or complete them.
你的设计必须清晰展示解决方案的逻辑，包括循环和判断结构。教师评分的作业通常要求在实现之前提交设计文档。良好的设计能减少错误并使编码更快。你应该练习阅读和解释这两种表示法，因为考试题目可能会要求你跟踪执行或补全它们。
5. Information System Design and Development: Databases | 信息系统设计与开发：数据库
The ISDD unit introduces you to relational database concepts. You will learn to design flat-file and relational databases using tables, fields, records, primary keys, and foreign keys. Understanding the difference between a flat-file database and a relational database is fundamental. You must be able to identify entities and the relationships between them (one-to-one, one-to-many, many-to-many).
ISDD 单元向你介绍关系数据库的概念。你将学习使用表、字段、记录、主键和外键来设计平面文件数据库和关系数据库。理解平面文件数据库与关系数据库之间的区别是基础。你必须能够识别实体及其之间的关系（一对一、一对多、多对多）。
Practical skills include creating tables, data types (text, number, date, Boolean), field validation (presence check, range check, restricted choice), and simple SQL queries using SELECT, FROM, WHERE, ORDER BY, and logical operators. You will also learn about data integrity and the importance of avoiding data redundancy through normalisation.
实践技能包括创建表、定义数据类型（文本、数字、日期、布尔型）、字段验证（存在性检查、范围检查、限制性选择），以及使用 SELECT、FROM、WHERE、ORDER BY 和逻辑运算符编写简单的 SQL 查询。你还会学习数据完整性知识，以及通过规范化避免数据冗余的重要性。
6. Web Design and Development | 网页设计与开发
Web design within the SQA syllabus focuses on creating multi-page websites using HTML and CSS (inline, internal, and external). You must understand tags for structuring content: headings, paragraphs, lists, images, hyperlinks, and tables. Semantic elements like header, nav, main, and footer are encouraged to improve accessibility and structure.
SQA 课程大纲中的网页设计侧重使用 HTML 和 CSS（行内样式、内部样式和外部样式表）来创建多页面网站。你必须理解用于构建内容的标签：标题、段落、列表、图片、超链接和表格。像 header、nav、main 和 footer 这样的语义化元素被鼓励使用，以改善可访问性和结构。
CSS is used to control layout, colour, font, and spacing. You should know how to use class and ID selectors, and understand the cascade and inheritance. Responsive design principles are introduced at this level, though not in deep detail. You will also learn to evaluate website usability, navigation, and fitness for purpose.
CSS 用于控制布局、颜色、字体和间距。你应该知道如何使用类选择器和 ID 选择器，并理解层叠和继承。响应式设计原则在本级别被引入，但不会深入细节。你还会学习评估网站的可用性、导航和目的的适合性。
7. Computer Systems: Hardware and Software | 计算机系统：硬件与软件
This part of the ISDD unit explains the function of a computer system in terms of input, process, output, and storage. You will be able to describe the central processing unit (CPU) and its components: control unit, arithmetic logic unit (ALU), and registers. The fetch-execute cycle is a core concept. Memory types such as RAM, ROM, cache, and virtual memory must be understood, alongside their relative speeds and purposes.
ISDD 单元的这一部分从输入、处理、输出和存储的角度解释计算机系统的功能。你将能够描述中央处理器（CPU）及其组成部分：控制单元、算术逻辑单元（ALU）和寄存器。取指-执行周期是一个核心概念。必须理解 RAM、ROM、高速缓存和虚拟内存等存储器类型，以及它们的相对速度和用途。
You will also compare system software (operating systems, utility programs) with application software. Factors affecting system performance — such as clock speed, number of processor cores, and amount of RAM — are common exam topics. Binary representation of integers and characters (ASCII, Unicode) is included, with simple binary-to-decimal conversions and the use of bits, bytes, kilobytes, etc.
你还将比较系统软件（操作系统、实用程序）与应用软件。影响系统性能的因素——如时钟速度、处理器核心数和 RAM 容量——是常见的考试主题。整数的二进制表示和字符的编码（ASCII、Unicode）也被包含在内，并进行简单的二进制与十进制转换，以及比特、字节、千字节等单位的运用。
8. Networks and Security | 网络与安全
Basic networking concepts are covered: types of networks (LAN, WAN, the Internet), client-server and peer-to-peer models, network hardware (switches, routers, NICs), and transmission media (wired, wireless). You should understand the benefits and risks of cloud storage, and identify ways to protect data through encryption, firewalls, access rights, and password policies.
基础网络概念被涵盖其中：网络类型（LAN、WAN、互联网）、客户机-服务器模型和对等网络模型、网络硬件（交换机、路由器、网卡），以及传输介质（有线、无线）。你应该理解云存储的好处和风险，并识别通过加密、防火墙、访问权限和密码策略来保护数据的方法。
Legal and environmental issues related to the use of computers are important. You need to discuss the Computer Misuse Act, Data Protection Act (GDPR context), Copyright Designs and Patents Act, and the environmental impact of technology including e-waste and energy consumption. These often appear in extended-answer questions.
与计算机使用相关的法律和环境问题也非常重要。你需要讨论《计算机滥用法》、《数据保护法》（在 GDPR 背景下）、《版权、设计和专利法》，以及技术对环境的影响，包括电子废弃物和能源消耗。这些通常会在扩展性答题中出现。
9. The Assignment: Applying Your Skills | 课程作业：综合运用技能
The National 5 Computing Science assignment is worth 31% of your final grade (50 marks scaled to 60). It is a practical task carried out in school under supervised conditions, typically lasting 8 hours. You will be given a brief that requires you to analyse a problem, design a solution using both software development and an information system (database or website), implement, test, and evaluate.
National 5 计算机科学的课程作业占最终成绩的31%（原始分50分，折合为60分）。它是在校内监督条件下完成的实际任务，通常持续8小时。你会收到一个任务简介，要求你分析问题、使用软件开发技术设计一个解决方案以及一个信息系统（数据库或网站），然后实现、测试并进行评估。
The assignment integration is key: you might create a program that reads from a database or generate a website that displays data from a back-end system. It is vital to manage your time well, keep an organised development log, and provide clear evidence of each stage. The evaluation should reflect on the success of your solution and suggest possible enhancements.
课程作业的综合性是关键：你可能要创建一个从数据库读取数据的程序，或者生成一个显示后端系统数据的网站。合理安排时间、记录有序的开发日志，并为每个阶段提供清晰证据至关重要。评估部分应反思解决方案的成败，并提出可能的改进方向。
10. The Question Paper: Exam Tips | 笔试：应试技巧
The final question paper accounts for 69% of your grade (110 marks scaled to 100). It lasts 2 hours and contains both short-answer and extended-response questions drawn from all units. Questions assessing computational thinking may ask you to trace pseudocode, identify errors in code snippets, or explain database queries and web code. Practical-based theory features heavily.
最终的笔试卷占总成绩的69%（原始分110分，折合为100分）。考试时长为2小时，包含来自所有单元的短答题和扩展性答题。评估计算思维的问题可能会要求你跟踪伪代码执行、找出代码片段中的错误，或解释数据库查询和网页代码。与实际操作紧密相关的理论占很大比重。
To prepare, practise past papers and pay careful attention to mark allocations. A question worth 4 marks expects four distinct points. Use technical vocabulary accurately. Revision should balance theory (definitions, hardware, networking, legal) with practical trace and explain-style tasks. Being able to describe a process clearly, such as the fetch-execute cycle or how a firewall works, is essential for higher marks.
为了备考，应练习历年试卷并密切关注分值分配。一个4分的题目理应给出四个独立得分点。准确使用专业术语。复习时应兼顾理论知识（定义、硬件、网络、法律）与实际跟踪和解释型任务。能够清晰描述过程，例如取指-执行周期或防火墙的工作原理，是获得高分的关键。
11. Study Strategies for Success | 获得成功的学习策略
Consistent practice is the most effective way to master the skills in this course. Set aside time each week to write small programs, experiment with SQL queries on a sample database, and build mini-websites. Use the SQA Command Words guide to understand what examiners mean by "describe," "explain," "identify," and "evaluate." This can lift your answer quality significantly.
持续练习是掌握本课程技能最有效的方式。每周安排时间编写小段程序、在示例数据库上试验 SQL 查询，并构建迷你网站。使用 SQA 的指令词指南，理解考官所说的“描述”“解释”“识别”和“评估”的真正含义，这可以显著提升你的答题质量。
Join study groups to discuss concepts, because explaining something to others reinforces your own understanding. Create flashcards for key terminology such as "primary key," "firewall," "cache memory," and "high-level language." For the assignment, keep a detailed logbook from the start — this makes writing the final evaluation much easier and ensures you do not lose marks for process evidence.
加入学习小组讨论概念，因为向他人解释知识能够加深你自己的理解。为关键术语制作抽认卡，如“主键”“防火墙”“高速缓存”和“高级语言”。对于课程作业，从一开始就保持详细的日志记录——这会让撰写最终评估变得更加容易，并确保你不会因缺少过程证据而丢分。
12. Conclusion and Next Steps | 总结与下一步
The SQA Year 10 Computing Science course is a well-rounded introduction to the digital world, blending programming, data, and systems thinking. By fully understanding the syllabus breakdown, you can plan your study effectively and track your progress across both practical and theoretical components. The skills you gain here also form an excellent foundation for progression to Higher Computing Science and beyond.
SQA Year 10 计算机科学课程是对数字世界的全面介绍，融合了编程、数据和系统思维。通过充分理解课程大纲解析，你可以有效规划学习，并追踪自己在实践和理论两个方面的进展。你在这里获得的技能，也为进阶到 Higher Computing Science 及后续学习打下了良好基础。
Now that you have the complete map of what to expect, you can dive into each topic with confidence. Set your learning goals, practise regularly, and make use of available past papers and online revision materials from aleveler.com. Good luck on your computing science journey!
现在你已经掌握了完整的课程蓝图，可以自信地深入每个主题。设定学习目标，定期练习，并善用 aleveler.com 上的历年试卷和在线复习资料。祝你在计算机科学的学习之旅上一帆风顺！
Published by TutorHao | Computing Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图