📚 SQA Computing Science: High-Frequency Topics and Common Mistakes for Year 10 | SQA 计算机科学：十年级高频考点与易错题分析
As Year 10 students prepare for the SQA Computing Science examination, certain topics repeatedly appear in assessments and often lead to the same predictable mistakes. This article highlights the most frequently tested concepts at National 5 level and provides a careful analysis of the common errors candidates make. We cover software design and development, information system design, computer systems, networking, security, and the legal and environmental implications of technology, all framed through typical exam questions. Reading these paired explanations will help you avoid losing marks on the topics that catch so many students out every year.
对于正在备战SQA计算机科学考试的十年级同学来说，有些知识点在历年的考卷中反复出现，而且考生总是在同样的地方犯错。这篇文章梳理了国家五级考试中最高频出现的概念，并对常见的错误进行深入分析。内容涵盖软件设计与开发、信息系统设计、计算机系统、网络、安全以及技术的法律与环境影响，全部围绕典型的考题展开。阅读这些中英对照的解析，可以帮助你避开那些每年都让无数考生丢分的陷阱。
1. Variables and Data Types | 变量与数据类型
A variable is a named storage location in memory that holds a value which can change during program execution. In SQA pseudocode, variables are declared with a data type such as INTEGER, REAL, STRING, or BOOLEAN. A very common exam mistake is forgetting to declare a variable or using the wrong data type in expressions. For example, trying to add an integer to a string (‘Hello’ + 5) will cause a type mismatch error. Students also confuse assignment (=) with the comparison operator (==), writing IF age = 18 instead of IF age == 18. Another frequent slip is using undeclared variables inside loops, leading to scope errors. When asked to trace a program, always check that every variable has been given an initial value before it is used; otherwise the output will be unpredictable.
变量是内存中一个有名称的存储位置，其值可以在程序运行过程中改变。在SQA的伪代码中，变量要用INTEGER、REAL、STRING或BOOLEAN数据类型来声明。考试中一个极其常见的错误是忘记声明变量，或者在表达式中使用了错误的数据类型。例如试图把整数和字符串相加（’Hello’ + 5）就会引发类型不匹配错误。很多学生还会混淆赋值号（=）和比较运算符（==），写出 IF age = 18 而不是 IF age == 18。另一个常犯的疏忽是在循环内部使用未声明的变量，导致作用域错误。当题目要求你追踪程序时，务必检查每个变量在使用前是否已经被赋了初值，否则输出将是不可预测的。
2. Conditional Statements and Logical Errors | 条件语句与逻辑错误
IF statements and CASE statements form the backbone of decision-making in programs. A classic mistake occurs when students place the conditions in the wrong order inside a nested IF‑ELSE structure. For instance, if the program must first check whether a number is positive and then whether it is even, but the student writes the even check first, zero or negative even numbers might be classified incorrectly. Another high-frequency error involves compound conditions using AND and OR. Many candidates write IF score > 50 AND < 70, which is syntactically incorrect because the variable must be repeated: IF score > 50 AND score < 70. With complex Boolean expressions, missing parentheses can completely alter the logic, so paying attention to operator precedence is essential. Exam questions often ask you to identify the logical error in a given snippet; always test boundary values like 0, 100, or empty string to see if the condition works as intended.
IF 语句和 CASE 语句是程序决策的核心。一个典型的错误是学生在嵌套的 IF‑ELSE 结构里把条件的顺序写反了。例如程序需要先判断一个数是否为正数，再判断它是否为偶数，但学生先检查了偶数，就可能把零或负的偶数分到错误的类别里。另一个高频错误涉及 AND 和 OR 构成的复合条件。许多考生会写成 IF score > 50 AND < 70，这在语法上是错误的，因为必须重复变量名：IF score > 50 AND score < 70。在使用复杂的布尔表达式时，缺少括号会完全改变逻辑，所以运算符优先级至关重要。考试题常常要求你找出一段代码中的逻辑错误；记住永远要用边界值（例如 0、100 或空字符串）去测试，看看条件是否符合预期。
3. Loops and Infinite Loops | 循环与无限循环错误
Loops let a program repeat a block of code, but they are a minefield for errors. The most common exam pitfall is the infinite loop, where the termination condition is never met. For a WHILE loop, this usually happens because the variable controlling the condition is not updated inside the loop body. For a FOR loop, students sometimes accidentally modify the loop counter, which leads to undefined behaviour. Another subtle mistake is off‑by‑one errors: setting the initial value or the end condition incorrectly so that the loop runs one time too many or too few. When tracing nested loops, many candidates fail to reset inner variables, causing the outer loop to produce accumulating incorrect results. In SQA questions that ask you to write a pseudocode solution, always write the exit condition clearly and test it with a small counter to verify the number of iterations.
循环能让程序重复执行一段代码，却也是错误的“雷区”。考试中最常见的陷阱是无限循环，即终止条件永远不会被满足。对 WHILE 循环来说，这通常是因为控制条件的变量在循环体内没有被更新。对 FOR 循环而言，学生有时会不小心修改循环计数器，导致行为不确定。另一个隐蔽的错误是“差一错误”：把初始值或终止条件写错，使得循环多运行一次或少运行一次。在追踪嵌套循环时，许多考生忘记重置内部变量，导致外层循环产生不断累积的错误结果。在 SQA 要求你编写伪代码的题目中，务必清晰地写出退出条件，并用一个较小的计数器测试，以检验循环次数是否正确。
4. Arrays and Index Out of Bounds | 数组与索引越界
Arrays store multiple values under a single name and are accessed using an index. In SQA pseudocode, the first index is 0. One of the most damaging errors is an index out of bounds: trying to read or write outside the declared range. For example, an array declared as scores[0:9] has valid indices 0 to 9 (10 elements), but students often loop from 1 to 10, missing the first element and attempting to access a non‑existent element at index 10. Similarly, when using a loop to fill an array, off‑by‑one conditions can leave the last element uninitialised. Also watch out for confusion between an array’s length and its highest index – the highest index is always length minus 1. Exam questions may present a trace table where you must follow array values through a sequence of assignments; making a manual table of the array state after each step prevents simple copying mistakes.
数组用一个名字存储多个值，并通过索引来访问。在 SQA 伪代码中，第一个索引是 0。危害最大的错误之一就是索引越界：试图在声明的范围之外读取或写入数据。例如一个数组被声明为 scores[0:9]，合法的索引是 0 到 9（共10个元素），但学生经常写一个从 1 到 10 的循环，这样既错过了第一个元素，又试图访问索引 10 处并不存在的元素。类似地，在用循环填充数组时，差一条件可能导致最后一个元素没有初始化。还要注意不要把数组的长度和它的最大索引搞混 – 最大索引永远是长度减 1。考试题可能会给出一个追踪表，要求你跟随一系列赋值操作去记录数组值；在每一步之后手工画一个小表格记录数组当前状态，可以防止简单的抄写错误。
5. Database Queries and SQL Syntax | 数据库查询与 SQL 语法错误
Databases appear frequently in the information system design section. The SELECT statement is the most tested command, and the majority of marks are lost through small syntax oversights. Missing single quotation marks around a text value is the number one mistake: WHERE town = Edinburgh will fail, whereas WHERE town = ‘Edinburgh’ is correct. Wildcards also cause confusion; the % symbol used with LIKE represents any sequence of characters, but students use it as a simple placeholder without the LIKE keyword. Forgetting to include the table name in a multi‑table query or omitting the semi‑colon at the end of the SQL statement can also lead to penalties. When sorting results, many students write ORDER BY DESC without specifying the column, or they try to use SORT instead of ORDER BY. Always remember that SQL running in SQA papers is treated as case‑insensitive for keywords, but the data values are case‑sensitive unless stated otherwise.
数据库在信息系统设计部分中经常出现。SELECT 语句是考得最多的命令，而丢分绝大部分来自微小的语法疏忽。文本值前后忘记加单引号是头号错误：WHERE town = Edinburgh 会失败，而 WHERE town = ‘Edinburgh’ 才是正确的。通配符也容易引起混淆；与 LIKE 搭配使用的 % 表示任意长度的字符序列，但学生常在没有 LIKE 关键字的情况下把它当成简单的占位符使用。在多表查询中忘记加上表名，或者在 SQL 语句末尾漏掉分号，也是常被扣分的地方。在排序结果时，很多学生写出 ORDER BY DESC 却没有指定列名，或者试图用 SORT 代替 ORDER BY。要记住：SQA 试卷中的 SQL 关键字通常不区分大小写，但数据值是区分大小写的，除非题目另有说明。
6. HTML and CSS Structure Errors | HTML 与 CSS 结构错误
Web page implementation is a core skill in National 5 Computing Science. Common mistakes include forgetting to close tags such as
or