📚 Year 10 SQA Computing Science: High-Frequency Topics & Common Mistake Analysis | Year 10 SQA 计算机科学：高频考点与易错题分析
Mastering SQA Computing Science at Year 10 level (typically National 5) requires not only understanding key concepts but also knowing precisely where students lose marks. This article breaks down the most frequently examined topics across data representation, programming, databases, and web design, while highlighting the specific mistakes that examiners report year after year. By studying these patterns, you can turn common pitfalls into guaranteed marks.
要在 Year 10 水平（通常对应苏格兰 National 5）的 SQA 计算机科学考试中取得成功，不仅需要理解核心概念，还必须准确知道学生在何处丢分。本文梳理了数据表示、程序设计、数据库和网页设计等最高频的考点，并重点分析考官年复一年报告中指出的典型错误。把握这些规律，就能把常见的易错点转化为确定能拿到的分数。
1. Data Representation: Binary, Hexadecimal & Conversions | 数据表示：二进制、十六进制及其转换
A core area tested in every exam series is the conversion between denary (base-10), binary (base-2), and hexadecimal (base-16). Students must be able to convert numbers up to 255 (8-bit binary) and understand why hex is used as a shorthand. The most frequent error is forgetting to pad binary numbers to 8 bits, so that, for example, the binary for decimal 29 is written as '11101' instead of '00011101'. Examiners expect full 8‑bit representations unless stated otherwise.
每次考试必考的核心领域是十进制（以10为底）、二进制（以2为底）和十六进制（以16为底）之间的转换。学生必须能够转换最大为 255（8 位二进制）的数，并理解为什么使用十六进制作为简写形式。最常见的错误是忘记将二进制数填充到 8 位，例如，十进制 29 的二进制被写成 '11101' 而不是 '00011101'。考官期望看到完整的 8 位表示，除非题目另有说明。
Another classic trap occurs when converting hexadecimal containing letters A‑F. Many candidates treat A as 11 instead of 10, or confuse the values of B (11) and D (13). A typical mistake in hex-to-binary conversion is writing the nibble for B as '1100' rather than the correct '1011'. Use the table below and always double-check each nibble.
另一个经典陷阱出现在转换含有字母 A‑F 的十六进制数时。许多考生将 A 当作 11 而不是 10，或者混淆 B（11）和 D（13）的值。十六进制转二进制中的一个典型错误是把 B 的半字节写成 '1100'，而不是正确的 '1011'。请使用下表，并务必仔细检查每个半字节。
| Hex | Decimal | Binary Nibble |
|---|---|---|
| A | 10 | 1010 |
| B | 11 | 1011 |
| C | 12 | 1100 |
| D | 13 | 1101 |
| E | 14 | 1110 |
| F | 15 | 1111 |
0, 0+1=1, 1+0=1, 1+1=0 carry 1, and 1+1+carry=1 carry 1. Practice with numbers like 01011001 + 00100111 to build confidence.
最后，在进行二进制加法时，考生常常处理不好进位，尤其是当进位溢出到新的一列时。关键规则是：0+0=0，0+1=1，1+0=1，1+1=0 进位 1，以及 1+1+进位=1 进位 1。多练习像 01011001 + 00100111 这样的题目可以建立信心。
2. Computer Architecture: CPU, Memory & Fetch-Execute Cycle | 计算机体系结构：CPU、内存与取指执行周期
The processor, main memory (RAM), and the fetch-execute cycle form the backbone of understanding how a computer works. A high-frequency question asks candidates to describe the steps of the fetch-execute cycle. The common error is omitting the role of the Program Counter (PC) or stating that the instruction is executed before it is decoded. The correct sequence is: PC holds address -> address sent via address bus -> instruction fetched from RAM into Current Instruction Register (CIR) -> PC incremented -> instruction decoded by Control Unit -> executed.
处理器、主存储器（RAM）以及取指执行周期构成了理解计算机如何工作的基础。高频考题常常要求考生描述取指执行周期的步骤。常见的错误是遗漏程序计数器（PC）的作用，或者声称指令在解码之前就被执行。正确的顺序是：PC 保存地址 → 地址通过地址总线发送 → 指令从 RAM 提取到当前指令寄存器（CIR） → PC 递增 → 指令由控制单元解码 → 执行。
Another typical pitfall is confusing the functions of the Control Unit (CU) and the Arithmetic Logic Unit (ALU). The CU does not perform calculations; it manages the flow of data and decodes instructions. The ALU carries out arithmetic (+, -) and logical operations (AND, OR, NOT). Matching answers must be precise: saying 'the ALU controls the computer' will lose marks.
另一个典型陷阱是混淆控制单元（CU）和算术逻辑单元（ALU）的功能。CU 不执行计算；它管理数据流并解码指令。ALU 执行算术（+、-）和逻辑运算（AND、OR、NOT）。答题必须精确：如果说 'ALU 控制计算机' 就会丢分。
Memory questions often probe the difference between RAM and ROM. A frequent mistake is claiming that ROM stores the operating system or that RAM is non-volatile. ROM is non-volatile and holds the bootstrap loader (BIOS), while RAM is volatile and holds currently running programs and data. Ensure you use ‘volatile’ and ‘non-volatile’ correctly.
关于内存的问题常常考察 RAM 和 ROM 的区别。频繁出现的错误是声称 ROM 存储操作系统，或者 RAM 是非易失性的。ROM 是非易失性的，保存引导加载程序（BIOS），而 RAM 是易失性的，存放当前正在运行的程序和数据。要确保正确使用'易失性'和'非易失性'这两个术语。
3. Logic Gates and Truth Tables | 逻辑门与真值表
At National 5, you are expected to draw and interpret truth tables for AND, OR, and NOT gates, and to combine them into simple logic circuits. The most frequent error is constructing a truth table that misses one or more input combinations. For a circuit with two inputs, you need four rows. For three inputs, eight rows are required. A single missing row can make the whole answer incorrect.
在 National 5 水平，你需要会绘制 AND、OR 和 NOT 门的真值表并能解读，还要能将它们组合成简单的逻辑电路。最常见的错误是构建的真值表遗漏了一个或多个输入组合。对于有两个输入的电路，需要四行；三个输入则需要八行。漏掉一行就可能导致整个答案错误。
Another common mistake arises when evaluating a logic expression such as (A AND B) OR C. Students sometimes evaluate right to left instead of following the brackets. Remember: brackets first, then AND, then OR. Also, the NOT gate is often overlooked, so that NOT A OR B is incorrectly treated as A OR B. Practice tracing each path carefully before writing the output column.
另一个常见错误出现在计算逻辑表达式（例如 (A AND B) OR C）时。学生有时从右向左计算，而不是遵循括号优先。记住：先算括号，然后 AND，最后 OR。此外，NOT 门经常被忽视，导致 NOT A OR B 被错误地当作 A OR B 处理。在填写输出列之前，要练习仔细追踪每条路径。
In design questions, candidates may be asked to name a real-world application of a logic gate. A typical weak answer is 'an AND gate is used in a car'. A strong answer specifies the context, such as 'an AND gate is used in a car's ignition system so that the engine only starts when the key is turned AND the clutch is depressed'. Always link the gate's truth table behaviour to the scenario.
在设计题中，考生可能被要求说出逻辑门在现实中的应用。一个典型的薄弱答案是'AND 门用在汽车里'。好的答案应明确场景，例如'AND 门用在汽车点火系统中，这样只有当钥匙转动且离合器被踩下时发动机才会启动'。始终将门电路的真值表行为与情境联系起来。
4. Software Design: Pseudocode and Flowcharts | 软件设计：伪代码与流程图
Pseudocode and flowcharts are examined both in theory and practical programming tasks. One highly tested skill is tracing the value of a variable through a loop structure. A common mistake is failing to update the variable correctly when the loop condition is checked at the top or bottom. For example, in a REPEAT...UNTIL loop, the loop body is always executed at least once; many students treat it identically to a WHILE loop and make the first iteration conditional, which is wrong.
伪代码和流程图在理论题和实际编程任务中都会考查。一个高度考查的技能是追踪变量在循环结构中的值。常见的错误是当循环条件在顶部或底部检查时，未能正确更新变量。例如，在 REPEAT...UNTIL 循环中，循环体至少会被执行一次；许多学生将其与 WHILE 循环完全等同看待，将第一次迭代视为有条件的，这是错误的。
Flowchart symbols are another source of easy marks lost. The diamond shape represents a decision (yes/no), the rectangle a process, and the parallelogram indicates input/output. Using a rectangle for input or a diamond for a process will result in an invalid design. Examiners expect strict adherence to the standard symbols.
流程图符号是另一个容易丢分的地方。菱形表示判断（是/否），矩形表示处理过程，平行四边形表示输入/输出。用矩形表示输入或用菱形表示处理过程会导致无效的设计。考官期望严格遵循标准符号。
SET, RECEIVE, SEND, WHILE...END WHILE, and IF...THEN...ELSE...END IF. A typical error is using '=' d comparison: assignment should be written as SET x TO 5, and comparison as IF x = 5 THEN.
在编写伪代码时，缩进不一致或遗漏 END IF / END WHILE 语句会导致逻辑错误。SQA 伪代码使用 SET、RECEIVE、SEND、WHILE...END WHILE 和 IF...THEN...ELSE...END IF 等关键词。一个典型错误是将 '=' 同时用于赋值和比较：赋值应写作 SET x TO 5，而比较写作 IF x = 5 THEN。
5. Programming Concepts: Variables, Input/Output & Conditional Statements | 编程概念：变量、输入输出与条件语句
Understanding how to declare and use variables is fundamental. A common error in written questions is confusing the data type with the variable name, or attempting to store a string in an integer variable. In National 5, the expected data types are Integer, Real, String, and Boolean. When given a program trace, many candidates forget that a string input like '123' is not the same as the integer 123, and arithmetic operations on it will fail.
理解如何声明和使用变量是基础。书面题中常见的错误是混淆数据类型和变量名，或者试图将一个字符串存储到整型变量中。在 National 5 阶段，预期的数据类型有 Integer、Real、String 和 Boolean。在给出程序追踪时，许多考生忘记字符串输入 '123' 不同于整数 123，对它进行算术运算会失败。
ion for ensuring a number is between 1 and 100 must include a loop that repeats until the number is >=1 AND <=100. Simply using an IF statement without a loop will not re-prompt the user.
输入验证频繁出现，最常见的错误是只检查数据是否存在，而不是检查范围或类型。例如，确保一个数介于 1 到 100 之间的有效解决方案必须包含一个循环，重复提示直到输入的数 >=1 且 <=100。仅仅使用一条 IF 语句而没有循环，并不能再次提示用户。
In conditional logic, missing the ELSE part can cause marks to be deducted when all scenarios are expected to be handled. Furthermore, using multiple IFs instead of IF...ELSE IF can lead to overlapping conditions and unexpected output. Structure your conditions carefully and test boundary values such as 0, 1, and the maximum allowed.
在条件逻辑中，当题目期望处理所有情况时，遗漏 ELSE 部分会导致扣分。此外，使用多个 IF 而不是 IF...ELSE IF 可能导致条件重叠和意外的输出。请仔细组织你的条件，并测试边界值，如 0、1 和允许的最大值。
6. Loops and Arrays: Iteration and Data Structures | 循环与数组：迭代与数据结构
Arrays (lists) are a high-frequency topic. SQA expects candidates to be able to read and write pseudocode that processes array elements using a FOR loop. The classic mistake is an off-by-one error: using an index that starts at 1 and goes to the length of the array, but the array indices run from 0 to length-1. In SQA pseudocode, arrays may start at index 0 or 1 depending on the question; always read the given data structure carefully.
数组（列表）是高频考点。SQA 期望考生能够读写使用 FOR 循环处理数组元素的伪代码。经典错误是计数偏差：使用从 1 开始到数组长度的索引，但数组索引是从 0 到 length-1。在 SQA 伪代码中，数组可能从索引 0 或 1 开始，取决于题目；请务必仔细阅读给出的数据结构。
Another frequent error is attempting to access an array element without a valid index inside a loop, especially after the loop has terminated. A typical question asks to find the maximum value in an array. Candidates often set the initial maximum to 0 (or the first element correctly) but then forget to update the comparison logic, or they update the maximum but forget to store the index position if required.
另一个常见错误是试图在循环中访问没有有效索引的数组元素，尤其是循环已经终止之后。典型的题目要求找出数组中的最大值。考生常常将初始最大值设为 0（或正确地设为第一个元素），但随后忘记更新比较逻辑，或者更新了最大值但题目要求存储索引位置时又忘记了。
Pre-defined functions like LEN(arr) are often misunderstood. Some students incorrectly use LEN(arr) as the last index, rather than the number of elements. If a FOR loop is written as FOR i FROM 0 TO LEN(scores) - 1, missing the '-1' is a very common slip that causes an 'index out of bounds' error in a dry run.
预定义函数如 LEN(arr) 经常被误解。一些学生错误地将 LEN(arr) 用作最后一个索引，而不是元素的个数。如果将 FOR 循环写成 FOR i FROM 0 TO LEN(scores) - 1，遗漏 '-1' 是一个很常见的疏忽，会在纸上运行时导致'索引越界'错误。
7. Database Design: Entities, Relationships & SQL Queries | 数据库设计：实体、关系与 SQL 查询
On the database side, candidates must be able to identify entities, attributes, and relationships from a scenario, and write basic SQL. A recurring error is confusing a primary key with a foreign key: a primary key uniquely identifies a record in its own table, while a foreign key creates a link to a primary key in another table. Labelling the wrong attribute as the foreign key will break the entire relationship diagram.
在数据库部分，考生必须能从场景中识别实体、属性和关系，并能编写基本的 SQL 语句。一个反复出现的错误是混淆主键和外键：主键唯一标识自身表中的一条记录，而外键创建到另一个表中主键的链接。将错误的属性标记为外键会破坏整个关系图。
ues. For example, SELECT * FROM Students WHERE Town = Edinburgh will fail; it must be WHERE Town = 'Edinburgh' E for wildcard searches will cause a mismatch. Wildcards are * for multiple characters and ? for a single character in SQA SQL.
SQL 查询是容易拿分的地方，但也是主要的丢分点。最常见的错误是忘记给文本值加引号。例如，SELECT * FROM Students WHERE Town = Edinburgh 会失败；必须是 WHERE Town = 'Edinburgh'。类似地，在通配符搜索中使用 = 而不是 LIKE 会导致不匹配。SQA SQL 中通配符 * 代表多个字符，? 代表单个字符。
uirement. A query to show pupils who are either in Year 10 or have a grade above 80 requires WHERE Year = 'Y10' de > 80. If you accidentally write AND, you will retrieve no records unless both are true.
在编写带有多个条件的复杂查询时，学生经常错放括号，或者遗漏与给定需求匹配的 AND/OR 逻辑。要显示 Year 10 或成绩高于 80 的学生，需要使用 WHERE Year = 'Y10' OR Grade > 80。如果不小心写成 AND，除非两者同时成立，否则将检索不到任何记录。
8. Web Design: HTML, CSS and Usability | 网页设计：HTML、CSS 与可用性
National 5 web design questions expect you to write valid HTML and CSS to style elements. The biggest single error is forgetting to close tags: every
needs a
, everyand
National 5 网页设计题目要求你编写有效的 HTML 和 CSS 来为元素添加样式。最大的单项错误是忘记闭合标签：每个
都需要一个
，每个和
CSS questions often ask to change font colour, background, or alignment. The typical mistake is mixing up the spelling of colour (in SQA HTML/CSS, American spelling 'color' is accepted, but external CSS uses 'color: red;'). More critically, students forget to link the CSS rule to the correct selector. For example, to style all paragraphs, the rule p {color: blue;} is correct, but writing .p {color: blue;} targets a class named p, not the element.
CSS 题目经常要求更改字体颜色、背景或对齐方式。典型的错误是混淆颜色属性的拼写（在 SQA HTML/CSS 中，美式拼写 'color' 被接受，外部 CSS 使用 'color: red;'）。更关键的是，学生忘记将 CSS 规则与正确的选择器关联。例如，要为所有段落设置样式，规则 p {color: blue;} 是正确的，但写成 .p {color: blue;} 则针对一个名为 p 的类，而不是元素本身。
Usability and accessibility considerations are also examined. Weak answers simply state 'the website should be easy to use' without explaining how. Strong answers mention high contrast colours for visually impaired users, alt text for images, consistent navigation, and readable font sizes. Relate every point to a specific user need to gain full marks.
可用性和可访问性的考量也会考查。薄弱的答案仅仅陈述'网站应该易于使用'，却没有解释如何实现。好的答案会提及为视障用户提供高对比度颜色、为图像添加替代文本、一致的导航以及可读的字号。每一点都要关联到具体的用户需求，才能拿到满分。
9. Security and Legal Implications | 安全与法律影响
Topics like computer viruses, malware, phishing, and the Data Protection Act 2018 are tested regularly. A common error is describing a virus as 'stealing data' without reference to its replicating nature. A virus is a self-replicating piece of code that attaches to other programs; a worm spreads across networks without user action. Mixing these up costs marks.
计算机病毒、恶意软件、网络钓鱼以及《2018 年数据保护法》等主题经常受到考查。一个常见的错误是在描述病毒时只说它'窃取数据'，而没有提及它的复制特性。病毒是一段能自我复制的代码，会附加到其他程序上；蠕虫则无需用户操作就能通过网络传播。混淆这些概念就会丢分。
Under legal implications, students often struggle to name the eight principles of the Data Protection Act and apply them to a scenario. The most commonly forgotten principle is 'not kept longer than necessary'. When a question asks 'how has the company breached the Act?', you must quote the exact principle and explain how the scenario violates it. For example, storing customer details from 10 years ago without a current purpose is a breach of the 'not kept longer than necessary' principle.
在法律影响方面，学生们常常难以说出《数据保护法》的八项原则并将其应用于情境。最容易被遗忘的原则是'保存时间不得超过必要期限'。当题目问'该公司如何违反了该法案？'时，你必须准确引用该原则并解释情景如何违反了它。例如，存储 10 年前的客户详细信息而没有当前目的，就违反了'保存时间不得超过必要期限'的原则。
10. Common Exam Mistakes & How to Avoid Them | 常见考试错误及如何避免
Beyond content errors, a significant number of marks are lost through poor exam technique. One of the most prevalent is failing to read exactly what the question is instructing. For example, a question that says 'State two reasons...' requires two distinct points in the answer space. Writing three or four will not gain extra marks, and if the first two are weak, you may still lose them. Read the command words: State, Describe, Explain, Compare all demand different levels of detail.
除了内容错误之外，大量分数是因答题技巧不佳而丢失的。最普遍的问题之一是未能准确读懂题目要求。例如，一道题目要求'说出两个原因……'，就需要在答题区域中写出两个不同的要点。写三个或四个不会得到额外分数，而且如果前两个理由本身较弱，仍可能丢分。请仔细阅读指令词：State、Describe、Explain、Compare 要求不同程度的细节。
Another critical technique is showing all working in calculation questions, especially for binary conversions and logic circuits. A final answer alone, even if correct, may not receive full marks if the working is absent. Use the working space to demonstrate the conversion steps, intermediate binary additions, or truth table evaluations. This also allows you to gain partial marks even if a careless slip leads to a wrong final number.
另一个关键技巧是在计算题中展示所有的解题步骤，特别是二进制转换和逻辑电路。即使最终答案正确，如果没有过程，也可能拿不到满分。利用演算区域展示转换步骤、中间的二进制加法或真值表计算过程。这样即使因粗心导致最后数字出错，也能获得部分分数。
Time management is frequently mentioned by examiners as a reason for incomplete papers. Mark allocation is a guide: a 4‑mark question typically expects around four distinct points or a brief paragraph with two developed points. Do not spend 20 minutes on a 2‑mark question at the expense of a 6‑mark database or programming task. A quick scan of the entire paper before writing helps you allocate time proportionally.
考官经常提到时间管理是导致试卷未能答完的原因。分值分配是一个指南：一道 4 分题通常要求大约四个不同的要点，或者一个简短段落包含两个展开的要点。不要在一道 2 分题上花费 20 分钟，而耽误了一道 6 分的数据库或编程题。在动笔前快速浏览整张试卷有助于按比例分配时间。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图