📚 Year 10 SQA Computing Science: In-Depth Past Paper Analysis | Year 10 SQA 计算机科学历年真题深度解析
Success in the SQA National 5 Computing Science exam hinges not just on knowing the content, but on understanding how that content is tested. This in-depth analysis dissects past paper trends, recurrent question styles, and examiner expectations across all key topic areas. By the end, you will have a clear map of where marks are won and lost, and a strategic approach to revision that targets the most heavily weighted concepts.
在 SQA National 5 计算机科学考试中取得好成绩，不仅取决于对知识点的掌握，更在于理解这些知识点是如何被考查的。本文深度解析历年真题的命题趋势、常见题型以及评分标准，涵盖所有核心主题。学完后，你将清晰地看到得分点和失分点在哪里，并掌握一套针对高频考点的高效复习策略。
1. Overview of Past Papers: Structure and Marking | 历年真题概览：题型分布与评分
The National 5 Computing Science question paper lasts 1 hour and 30 minutes and contributes 60 marks to the final award, alongside the 40-mark assignment. Exam questions are a mix of short-answer responses, extended descriptions, and structured problem-solving tasks. Understanding the balance across topics is critical: Software Design & Development and Computer Systems typically account for roughly half the marks each year.
National 5 计算机科学笔试试卷时长 1 小时 30 分钟，占总成绩 60 分（另外 40 分来自课程作业）。题目类型包括简答题、描述性扩展题以及结构化问题解决任务。了解各主题的分数分布至关重要——软件设计与开发、计算机系统两部分通常每年合计占据约一半分值。
A glance at recent papers reveals that approximately 15–20 marks are dedicated to database/SQL and web design combined, while around 10–12 marks test data representation and binary. The remaining marks cover hardware, networking, and security. Command words like ‘Describe’, ‘Explain’, ‘State’, and ‘Give an example’ each carry different depth requirements – ‘Explain’ often rewards causal links and technical justification.
回顾近年真题，数据库与 SQL、网页设计合计约 15–20 分，数据表示与二进制约 10–12 分。剩余分值分布在硬件、网络和安全等模块。题目中的指令词如 “Describe”（描述）、”Explain”（解释）、”State”（陈述）和 “Give an example”（举例）对回答深度的要求各不相同——”Explain” 通常需要说明因果关系并提供技术性论证。
2. Data Representation and Binary Arithmetic | 数据表示与二进制运算
One of the most formulaic but trick-prone areas involves converting between binary, denary, and hexadecimal. Past papers consistently feature questions that ask candidates to: convert 8-bit binary to denary; convert denary to hexadecimal; explain why binary is used by computers. A typical 3-mark question might present a binary number like 10110110₂ and ask for its denary equivalent.
这是最公式化但也最容易失分的模块之一，涉及二进制、十进制和十六进制之间的转换。历年真题常考：8 位二进制转十进制、十进制转十六进制、解释计算机为什么使用二进制。一个典型的 3 分题可能给出二进制数 10110110₂，要求写出对应的十进制值。
Binary addition and overflow errors also appear regularly. Be prepared to add two 8-bit numbers and state whether an overflow flag would be set. For example, adding 01101010₂ and 01111011₂ yields 11100101₂, and because the most significant bits are both 0, no overflow occurs. Understanding two’s complement for negative numbers, though less frequently tested, can differentiate a Grade A candidate.
二进制加法与溢出错误也经常出现。要准备好计算两个 8 位二进制数的和并判断溢出标志是否置位。例如，01101010₂ 加 01111011₂ 得到 11100101₂，由于两个最高位都是 0，不发生溢出。虽然补码（two’s complement）表示负数考查频率较低，但掌握它往往是 A 等考生的区分点。
A common pitfall is misinterpreting hexadecimal digits. In the 2022 paper, many students incorrectly treated A3₁₆ as a denary 103 instead of 163. Remember: A = 10, B = 11, …, F = 15. Place value multipliers are 16 and 1, so A×16 + 3×1 = 160 + 3 = 163.
一个常见的陷阱是错误解释十六进制数字。在 2022 年试卷中，许多学生错误地将 A3₁₆ 当作十进制 103 而非 163。记住：A=10, B=11, …, F=15。位权分别为 16 和 1，因此 A×16 + 3×1 = 160 + 3 = 163。
3. Logic Gates and Boolean Expressions | 逻辑门与布尔表达式
SQA regularly sets questions that require completing truth tables for circuits containing AND, OR, and NOT gates, or analysing a given logic diagram. For instance, a circuit with two inputs A and B, where A is NOTed and then ANDed with B, requires systematic column building. In a 2023 question, candidates had to draw the output Q for inputs shown in a timing diagram.
SQA 经常设置需要补全真值表或分析给定逻辑电路图的题目，电路通常包含与门、或门和非门。例如，一个电路有两个输入 A 和 B，A 先经过非门再与 B 相与，作答时需要逐步建立真值表各列。在 2023 年的一道题中，考生需要根据时序图画出输出 Q 的波形。
The examiner looks for correct use of Boolean notation and the ability to simplify expressions using laws like A.1 = A and A+A’ = 1. While simplification is rarely a standalone question, it helps when identifying equivalent gates. In 2021, a question asked for the Boolean expression of a circuit containing a NAND gate followed by a NOT – simplifying to AND gained an extra mark.
阅卷人期望看到正确使用布尔表达式，并能运用基本定律如 A·1 = A 和 A+A’ = 1 进行化简。尽管很少单独出化简题，但它在识别等效门电路时非常有用。2021 年有一题要求写出一个含与非门后接非门的电路的布尔表达式——化简为与门即可获得额外加分。
To excel here, practise drawing circuits from expressions like Q = (A AND B) OR NOT C. A quick table-building strategy can help you avoid errors:
| A | B | A AND B | NOT C | Q |
|---|---|---|---|---|
| 0 | 0 | 0 | 1 | 1 |
想在这一部分拿到高分，要多练习根据表达式（如 Q = (A AND B) OR NOT C）绘制电路图。下面这种快速建表策略能帮你避免错误。
4. Computer Hardware and Memory | 计算机硬件与内存
Questions in this area fall into three main categories: describing the function of the processor components (ALU, Control Unit, Registers), explaining RAM and ROM differences, and interpreting benchmarks. A classic 4-mark question from 2019 asked to describe the fetch-execute cycle. Marks were awarded for mentioning the Program Counter, MAR, MDR, and the role of the Control Unit.
这部分题目主要分为三类：描述处理器组件（算术逻辑单元、控制单元、寄存器）的功能；解释 RAM 与 ROM 的区别；解读性能基准数据。2019 年一道经典的 4 分题要求描述“取指-执行”周期，得分点包括提及程序计数器、MAR、MDR 以及控制单元的作用。
When discussing memory, examiners favour precise comparisons. For example: ‘ROM retains data when power is off (non-volatile), whereas RAM is volatile and loses its content. ROM stores the BIOS/bootstrap loader, while RAM holds the currently running programs and data.’ Using technical terms like volatile and non-volatile is essential for full marks.
在讨论内存时，阅卷人青睐精确的对比。比如：“ROM 在断电后仍能保留数据（非易失性），而 RAM 是易失性的，数据会丢失。ROM 存储 BIOS/引导程序，RAM 则存放当前运行的程序和数据。” 使用“volatile”和“non-volatile”等专业术语对于拿到满分至关重要。
Hardware questions also often include a diagram of a system on the motherboard, asking to identify the data, address, and control buses. Knowing that the address bus is unidirectional (from CPU to memory) while the data bus is bidirectional earns easy marks.
硬件题目还常给出主板上的系统示意图，要求标识数据总线、地址总线和控制总线。知道地址总线是单向的（从 CPU 到内存），而数据总线是双向的，就能轻松得分。
5. Networking and Security | 网络与安全
Networking appears both in the context of describing client-server vs. peer-to-peer networks, and in identifying MAC/IP addresses and their roles. A 2022 5-mark question asked: ‘Explain why a switch is preferred over a hub in a modern LAN.’ The answer required detailing that a switch sends packets only to the destination MAC address (reducing collisions), while a hub broadcasts to all ports.
网络部分既会考察客户-服务器网络与对等网络的描述对比，也会涉及 MAC 地址和 IP 地址的识别及其作用。2022 年一道 5 分题问：“解释为什么在现代局域网中交换机优于集线器。” 答案需要详细说明交换机仅将数据包发送至目标 MAC 地址（减少冲突），而集线器会向所有端口广播。
Security questions demand knowledge of threats and countermeasures. Past papers have asked about DDoS attacks, phishing, and ransomware. When describing a firewall, simply stating ‘it blocks unauthorised access’ earns 1 mark; explaining that it examines incoming and outgoing packets against a set of security rules and can be hardware- or software-based secures the second mark.
安全类题目要求掌握威胁及应对措施。真题已考过 DDoS 攻击、网络钓鱼和勒索软件。描述防火墙时，仅说“阻止未授权访问”只得 1 分；若能解释它根据一组安全规则检查进出数据包，且可以是硬件或软件实现，方能获得第二分。
A common high-mark question asks to evaluate the use of encryption. Mentioning symmetric encryption (same key for encrypt/decrypt) and public key encryption (public and private key pair) with an example like HTTPS shows deeper understanding.
常见的高分题要求评价加密技术的使用。提及对称加密（同一密钥加解密）和公钥加密（公私钥对）并结合 HTTPS 示例，能展示更深入的理解。
6. Software Design & Development: Pseudocode and Flowcharts | 软件设计与开发：伪代码与流程图
This section is the heart of computational thinking. Past papers heavily test the ability to read, debug, and write pseudocode using SQA’s Reference Language. In 2023, candidates were given a pseudocode snippet containing a logic error in a WHILE loop condition and asked to correct it. Pay attention to off-by-one errors and incorrect boolean operator usage (e.g., using OR instead of AND in a range check).
这部分是计算思维的核心。历年真题大量考查使用 SQA 参考语言阅读、调试和编写伪代码的能力。2023 年，考生拿到一段伪代码，其中 WHILE 循环条件存在逻辑错误，需要纠正。要特别注意边界值错误（off-by-one）以及布尔运算符误用（如在范围检查中用 OR 代替 AND）。
SQA also often provides a flowchart and requires translation into pseudocode or vice versa. A structured approach: identify the start and end terminals, then follow input/output parallelograms, process rectangles, and decision diamonds. The diamond’s ‘Yes’/’No’ flow must map precisely to IF…THEN…ELSE…END IF blocks.
SQA 还经常给出流程图，要求转换成伪代码，或反之。有条理的解题方法是：识别开始和结束端子，然后跟踪输入/输出平行四边形、处理矩形和判断菱形。判断菱形的“是”/“否”分支必须严格映射到 IF…THEN…ELSE…END IF 结构。
Variables and data types are tested via trace tables. A typical trace table question provides pseudocode with repeated assignments and asks for the final values of variables. Ensure you update values step by step in the correct order.
变量与数据类型通过追踪表（trace table）进行考查。典型的追踪表题目给出含重复赋值的伪代码，要求填写变量的最终值。务必按正确的顺序逐步更新数值。
7. Databases and SQL | 数据库与 SQL
Database questions typically present a relational database schema with two or three tables and ask for SQL queries. The most frequent commands are SELECT, FROM, WHERE, and ORDER BY. A standard 3-mark question from 2021: ‘Write an SQL statement to display the name and price of all products in the Sports category, sorted by price descending.’ The expected answer: SELECT name, price FROM Products WHERE category = ‘Sports’ ORDER BY price DESC;
数据库题目通常给出包含两到三张表的关系数据库模式，要求编写 SQL 查询。最常见的命令是 SELECT、FROM、WHERE 和 ORDER BY。2021 年一道标准 3 分题：“编写 SQL 语句，显示 Sports 类别中所有产品的名称和价格，按价格降序排列。” 期望答案为：SELECT name, price FROM Products WHERE category = ‘Sports’ ORDER BY price DESC;
Often a follow‑up question asks to explain why a query returns a particular row or why an error occurs. Being able to justify the result by referencing the schema and the logical operators (AND, OR, NOT) is crucial. In 2022, a WHERE clause using OR incorrectly fetched extra rows, testing the understanding of operator precedence.
通常后续会问为什么某个查询返回特定行或为何出错。能够通过引用模式结构和逻辑运算符（AND, OR, NOT）来论证结果是至关重要的。2022 年，一道题中 WHERE 子句错误使用 OR 导致多取了行，考查了对运算符优先级的理解。
Design questions may ask to identify a primary key or foreign key, or to explain why a field should be set as a primary key (uniqueness, no nulls). A standard answer: ‘CustomerID uniquely identifies each record in the Customer table, ensuring entity integrity.’
设计类问题可能要求识别主键或外键，或者解释为什么某个字段应设为主键（唯一性、非空）。标准答案是：“CustomerID 唯一标识 Customer 表中的每条记录，保证了实体完整性。”
8. Web Design and Development: HTML & CSS | 网页设计与开发：HTML 与 CSS
Since the 2022 specification refresh, web technology questions have become more prevalent. Candidates are expected to write valid HTML elements and explain their purpose. Common tags include: <html>, <head>, <title>, <body>, <h1> to <h6>, <p>, <a href=’…’>, <img src=’…’ alt=’…’>, and list elements <ul>/<ol> with <li>.
自 2022 年课程更新后，网页技术题目的比重有所增加。考生需要编写有效的 HTML 元素并解释其用途。常见标签包括：<html>、<head>、<title>、<body>、<h1> 至 <h6>、<p>、<a href=’…’>、<img src=’…’ alt=’…’> 以及列表元素 <ul>/<ol> 搭配 <li>。
CSS questions ask to apply inline, internal, or external styles. A recent 4-mark question provided a screenshot of a web page and asked to write the CSS rule to set the background colour of all <h2> elements to blue and text centred. The correct answer: h2 { background-color: blue; text-align: center; }. The examiner penalises missing curly braces or semicolons.
CSS 题目要求应用内联、内部或外部样式。最近一道 4 分题给出网页截图，要求编写 CSS 规则，将所有 <h2> 元素的背景色设为蓝色并居中文本。正确答案为：h2 { background-color: blue; text-align: center; }。阅卷人会因漏掉花括号或分号而扣分。
Explain questions often delve into the separation of content and presentation. Mention that HTML provides structure/content while CSS handles appearance/layout, making site-wide changes easier and improving consistency. This point repeatedly scores 2 marks.
解释类题目经常深入探究内容与表现的分离。要指出 HTML 提供结构/内容，而 CSS 处理外观/布局，这样易于实现站点级更改并增强一致性。这一要点反复帮助考生拿下 2 分。
9. Algorithm Efficiency and Testing | 算法效率与测试
Examiners increasingly emphasise evaluation. You may be asked to compare two algorithms in terms of efficiency using concepts like number of comparisons or memory usage. For instance, a linear search vs. binary search question: ‘Linear search checks each element sequentially; binary search works on a sorted array, halving the search space each time.’ The words ‘halving’ and ‘requires sorted data’ are key.
阅卷人越来越重视算法的评估。可能要求从比较次数或内存占用的角度比较两种算法的效率。例如，线性搜索与二分搜索的对比题：“线性搜索逐个检查元素；二分搜索基于已排序数组，每次将搜索范围减半。” “减半”和“要求已排序”是关键得分词。
Testing is often assessed through a practical scenario. A question might provide a system specification and ask to design test cases including normal, extreme, and exceptional data. For a program that accepts ages 1–120, normal: 25, extreme: 1 and 120, exceptional: 0, 121, ‘cat’. Being explicit about why each test case is chosen earns full marks.
测试通常结合实际场景考查。题目可能给出系统规格，要求设计测试用例，包括正常、边界和异常数据。对于一个接受年龄 1–120 的程序，正常值：25，边界值：1 和 120，异常值：0、121、“cat”。明确说出每个测试用例的选择理由可获得满分。
Traceability between requirement and test is a subtle examiner focus. Stating ‘Test case TC01 verifies that Requirement R3 – age validation – rejects values outside the range’ shows systematic thinking.
需求与测试之间的可追溯性是阅卷人暗含的关注点。指出“测试用例 TC01 验证需求 R3（年龄验证）能拒绝范围外的值”，可以体现出系统化思维。
10. Common Mistakes and High-Marking Strategies | 常见错误与高分策略
Across past papers, four error patterns recur. First, incomplete explanations: a one‑sentence answer is rarely enough for 3‑mark explain questions. Use the ‘Point‑Evidence‑Link’ structure: state the concept, give a technical example from the scenario, link back to the question. Second, missing brackets or semicolons in code – a completely correct algorithm can lose marks for syntax errors in pseudocode or CSS.
翻阅历年真题，有四类错误反复出现。第一，解释不完整：对于 3 分的解释题，一句话的回答几乎不可能拿满分。请采用“观点-证据-联系”的结构：陈述概念，结合题目场景给出技术实例，再联系回问题本身。第二，代码中缺少括号或分号——一个完全正确的算法可能因伪代码或 CSS 中的语法错误而丢分。
Third, misreading command words: ‘State’ requires a brief factual answer, while ‘Describe’ requires a sequence of actions or features. Fourth, time management: students often over‑write on early short‑answer questions and run out of time for SQL or pseudocode which carry heavy marks. Allocate 1 minute per mark as a rough guide.
第三，误读指令词：“State”只需简要陈述事实，“Describe”则需要描述一系列操作或特征。第四，时间管理：学生常在前面简答题上过度发挥，导致耗时长且分值高的 SQL 或伪代码题没时间做。建议大致按 1 分钟 1 分来分配时间。
To achieve 80%+, structure your revision around topic-specific past paper chunks rather than whole papers initially. Once confident, attempt a full timed paper, then rigorously mark it using SQA marking instructions. Note the exact phrasing that earns marks – often it is specific technical terminology.
要获得 80% 以上的分数，复习时先按主题分块刷真题，而不是一上来就做完整的试卷。熟练之后，再进行限时的整套模拟，并严格按照 SQA 评分标准批改。注意那些得分点所使用的确切措辞——往往就是特定的技术术语。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导