📚 Common Misconceptions and Correction Methods in Year 12 SQA Computer Science | Year 12 SQA 计算机科学常见误区与纠正方法
In the SQA Higher Computing Science course, learners often develop persistent misunderstandings that can cost marks in assessments and limit deeper appreciation of the subject. These misconceptions arise from oversimplified explanations, analogies that are taken too literally, or gaps in connecting theoretical concepts to practical implementation. This article identifies eleven of the most widespread errors and provides clear, syllabus-aligned correction methods. Each pair of paragraphs presents the misconception and its remedy in both English and Chinese, helping bilingual learners reinforce their understanding. By addressing these pitfalls systematically, students can build a more accurate mental model of computing systems and improve their performance in examinations.
在 SQA Higher 计算机科学课程中，学生经常形成一些顽固的误解，这些误解不仅会在考试中失分，还会阻碍他们深入理解学科。这些误区往往源于过度简化的解释、从字面上理解的类比，或是理论概念与实际应用脱节。本文指出了十一个最常见的错误，并提供了清晰、符合大纲要求的纠正方法。每一对中英文段落都呈现了误区和纠正，帮助双语学习者巩固理解。通过系统地排除这些陷阱，学生可以建立更精确的计算系统思维模型，并在考试中提高成绩。
1. Binary and Two's Complement Representation | 二进制和补码表示
Many students believe that the leftmost bit of a signed binary number acts simply as a flag: 0 means positive and 1 means negative, while the remaining bits store the magnitude directly. This leads to errors when performing arithmetic or interpreting negative values in two's complement, which is the standard representation used in modern computers.
许多学生认为带符号二进制数最左边的位只是一个标志：0 表示正数，1 表示负数，其余位直接存放数值大小。当进行算术运算或解释补码表示的负值时，这种理解会导致错误，而补码正是现代计算机使用的标准表示方式。
The correct model is that in two's complement, the most significant bit has a negative place value. For an 8‑ s representation ensures that addition circuitry works identically for signed and unsigned numbers. For example, 11111110 is not -126 but -2 because the place values sum to -128 + 64 + 32 + 16 + 8 + 4 + 2 = -2. Teaching the place-value approach eliminates the 'sign-and-magnitude' misconception.
正确的模型是：在补码中，最高有效位具有负的位权值。以一个 8 位数字为例，第 7 位的权值是 -128，其他各位照常贡献正值。要对一个数求负，需将所有位取反后再加 1。这种表示法使得加法电路对有符号数和无符号数都能同样工作。例如，11111110 并非 -126，而是 -2，因为位权之和为 -128 + 64 + 32 + 16 + 8 + 4 + 2 = -2。讲解位权法可以消除“符号-数值”的误解。
2. RAM and ROM: Purposes and Properties | 随机存取存储器（RAM）与只读存储器（ROM）
A common mistake is to equate RAM with 'temporary memory' and ROM with 'permanent memory' without understanding their distinct functions in a computer system. Students often describe ROM as hard disk‑like storage, not realising it is directly accessible by the CPU and holds firmware or boot code.
一个常见的错误是将 RAM 等同于“临时存储器”，将 ROM 等同于“永久存储器”，却不理解它们在计算机系统中各不相同的作用。学生们常把 ROM 描述成类似硬盘的存储设备，而没有意识到它可由 CPU 直接访问，并存放固件或启动代码。
RAM (Random Access Memory) is volatile, used for holding the operating system, running programs and data currently being processed. It is read‑write and loses its contents when power is removed. ROM (Read‑Only Memory) is non‑volatile, typically programmed during manufacture and contains the bootstrap loader or BIOS. Modern systems use variants such as EPROM and flash ROM. The key distinction is not merely volatility but the read‑write versus read‑only access patterns and their roles in the fetch‑execute cycle.
RAM（随机存取存储器）是易失性的，用于存放操作系统、正在运行的程序和当前处理的数据。它是可读可写的，断电后内容会丢失。ROM（只读存储器）是非易失性的，通常在制造时编程，存放引导加载程序或 BIOS。现代系统使用 EPROM 和闪存 ROM 等变体。关键的区别不仅仅在于易失性，更在于读写权限和它们在取指执行周期中的角色。
3. Clock Speed and Processor Performance | 时钟速度与处理器性能
Learners frequently assume that a processor with a higher clock speed will always outperform one with a lower clock speed. This simplistic view ignores other critical factors such as the number of cores, cache memory, instruction set architecture and the efficiency of the pipeline.
学生经常假设时钟速度更高的处理器一定会胜过时钟速度较低的处理器。这种简单的看法忽略了其他关键因素，如核心数量、高速缓存、指令集架构以及流水线的效率。
Clock speed, measured in hertz, indicates how many cycles per second the CPU can execute, but modern processors execute varying numbers of instructions per cycle (IPC) due to hyper‑threading, out‑of‑order execution and superscalar design. A 3.0 GHz dual‑core CPU with a small cache may underperform a 2.5 GHz octa‑core CPU with large L2/L3 caches for multi‑threaded tasks. The SQA curriculum emphasises that performance is a product of clock speed, number of cores, cache size and architecture. Benchmarking rather than raw GHz is the true measure.
时钟速度以赫兹为单位，表明 CPU 每秒可执行多少个周期，但由于超线程、乱序执行和超标量设计，现代处理器每个周期执行的指令数（IPC）各不相同。在多线程任务中，一块 3.0 GHz 的双核小缓存 CPU 可能不如 2.5 GHz 的八核大容量 L2/L3 缓存 CPU。SQA 课程强调，性能是时钟速度、核心数量、缓存大小和架构共同作用的结果。真实的衡量标准是基准测试，而非单纯的 GHz 数值。
4. Database Normalisation | 数据库规范化
Students often think that normalisation is just about removing repeating groups or splitting tables until they 'look tidy'. This shallow understanding leads to designs that may be in 1NF but full of update anomalies, or that mistake 2NF for 3NF.
学生常认为规范化仅仅是去除重复组或拆分表格直到“看上去整洁”。这种肤浅的理解会导致设计只满足第一范式（1NF），却充满更新异常，或者将第二范式（2NF）与第三范式（3NF）混淆。
Normalisation is a formal process to reduce data redundancy and improve integrity. 1NF ensures atomic values and no repeating groups. 2NF demands that all non‑key attributes are fully functionally dependent on the whole primary key (no partial dependencies) — crucial when a composite key is present. 3NF removes transitive dependencies, where a non‑key attribute depends on another non‑key attribute. A common practical error is leaving a column like 'customer phone' inside an 'orders' table rather than in a separate 'customers' table. Exercises requiring identification of partial and transitive dependencies help solidify these rules.
规范化是一种减少数据冗余、提升完整性的规范过程。1NF 确保原子值且无重复组。2NF 要求所有非主键属性完全函数依赖于整个主键（无部分依赖）——当存在复合主键时尤为重要。3NF 则消除传递依赖，即非主键属性依赖于另一个非主键属性。一个常见的实际错误是将“客户电话”列留在“订单”表中，而不是将其放入单独的“客户”表。通过识别部分依赖和传递依赖的练习，可以巩固这些规则。
5. Networking Protocol Layers | 网络协议层
Many candidates blur the boundaries between the OSI and TCP/IP models, or assign protocols to the wrong layer. For instance, HTTP is incorrectly placed in the transport layer, and the distinction between switching and routing is misunderstood.
许多考生混淆了 OSI 模型和 TCP/IP 模型的层次界限，或者将协议归入错误的层。例如，HTTP 被错误地放在传输层，而交换与路由之间的区别也被误解。
The TCP/IP model — the basis of the internet — has four layers: Application, Transport, Internet, and Link (or Network Access). Application layer protocols include HTTP, HTTPS, FTP, SMTP; the Transport layer contains TCP and UDP; the Internet layer uses IP; and the Link layer covers Ethernet and Wi‑Fi. A common misconception is that a switch operates at layer 3; in reality, a switch forwards frames based on MAC addresses (layer 2), while a router forwards packets based on IP addresses (layer 3). Correct layering helps when explaining encapsulation and data flow.
TCP/IP 模型是互联网的基础，具有四层：应用层、传输层、网际层和链路层（或网络接入层）。应用层协议包括 HTTP、HTTPS、FTP、SMTP；传输层包含 TCP 和 UDP；网际层使用 IP；链路层则涵盖以太网和 Wi‑Fi。一个常见的误解是交换机工作在第三层；实际上，交换机基于 MAC 地址转发帧（第二层），而路由器基于 IP 地址转发数据包（第三层）。正确的分层有助于解释封装和数据流。
6. Algorithm Efficiency and Big O Notation | 算法效率与大O符号
A typical student error is reading O(1) as 'instant' or thinking that an O(n) algorithm will always be slower than an O(log n) algorithm regardless of input size. There is also confusion about ignoring constants and low‑order terms in Big O approximations.
学生一个典型的错误是将 O(1) 解读为“瞬间完成”，或者认为无论输入规模如何，O(n) 算法总比 O(log n) 算法慢。同时，他们对大O近似中忽略常数和低阶项也存在困惑。
Big O notation describes how time or space requirement grows relative to input size; it does not give actual execution time. O(1) means constant time — the same regardless of input — but that constant could be large. O(n) means linear growth; for very small n, an O(n) algorithm may be faster than a more complex algorithm with large setup costs. Constants are ignored because they become less significant as n grows, but they can matter in tight loops. SQA students should be able to compare algorithms by growth rate (e.g., O(1) < O(log n) < O(n) < O(n log n) < O(n²)) and apply this to searching and sorting examples.
大O符号描述的是时间或空间需求相对于输入规模的增长情况，并不给出实际执行时间。O(1) 表示常数时间——无论输入多大时间都相同——但这个常数可能很大。O(n) 表示线性增长；对于很小的 n，一个 O(n) 算法可能比一个设置成本较高的复杂算法更快。忽略常数是因为随着 n 的增长它们变得不那么重要，但在紧凑循环中它们仍可能产生影响。SQA 学生应能按增长率比较算法（例如 O(1) < O(log n) < O(n) < O(n log n) < O(n²)），并将其应用于搜索和排序的实例中。
7. Classes and Objects in OOP | 面向对象编程中的类与对象
Students regularly mix up the terms 'class' and 'object', or think that a class is merely a container for code. They also confuse a method with a function, and believe that inheritance copies code physically into subclasses.
学生经常混淆“类”和“对象”这两个术语，或认为类仅仅是代码的容器。他们还会将方法与方法函数混淆，并认为继承会将代码物理地复制到子类中。
A class is a blueprint or template that defines attributes and behaviours. An object is an instance of a class, occupying memory with actual attribute values. A method is a subroutine defined inside a class that operates on object data; a function is a standalone subroutine. Inheritance establishes an 'is‑a' relationship through the class hierarchy; a subclass inherits attributes and methods from a superclass without duplicating code. Polymorphism allows objects of different classes to be treated through a common interface. Focusing on concrete examples — such as a 'Vehicle' superclass with 'Car' and 'Bicycle' subclasses — makes these distinctions clear.
类是定义属性和行为的蓝图或模板。对象是类的实例，其属性拥有实际值，并占用内存。方法是定义在类内部的子程序，操作对象数据；函数则是独立的子程序。继承通过类层次结构建立“是一种”关系；子类从超类继承属性和方法，而不复制代码。多态性允许将不同类的对象通过公共接口对待。关注具体示例——例如“Vehicle”超类和“Car”、“Bicycle”子类——可以使这些区别变得清晰。
8. ASCII versus Unicode | ASCII 与 Unicode
Many learners think ASCII can represent characters from all world languages, or that Unicode is just an 'extended ASCII' with more bits. This misses the fundamental difference in design philosophy and character repertoire.
许多学习者认为 ASCII 可以表示世界上所有语言的字符，或者认为 Unicode 只是“扩展 ASCII”，只是增加了更多位。这种看法忽略了设计理念和字符库的根本区别。
ASCII is a 7‑bit character set encoding 128 characters, sufficient for basic English and control codes. Extended ASCII uses 8 bits but remains limited to 256 symbols, incapable of handling Arabic, Chinese or Devanagari scripts. Unicode is a universal character set that assigns a unique code point to every character across modern and historical scripts — over 140,000 characters — with encodings such as UTF‑8, UTF‑16 and UTF‑32. UTF‑8 is backward‑compatible with ASCII for the first 128 characters. In SQA exams, explaining the importance of Unicode for global multilingual software is key.
ASCII 是一个 7 位字符集，编码 128 个字符，足以满足基本英语和控制码的需求。扩展 ASCII 使用 8 位，但仍然限于 256 个符号，无法涵盖阿拉伯文、中文或天城文等文字。Unicode 是一个通用字符集，为现代和历史文字中的每一个字符分配一个唯一的码点——超过 14 万个字符——并提供 UTF‑8、UTF‑16 和 UTF‑32 等编码。UTF‑8 在其前 128 个字符上与 ASCII 兼容。在 SQA 考试中，解释 Unicode 对于全球多语言软件的重要性是关键。
9. Register Roles in the Fetch-Execute Cycle | 取指执行周期中的寄存器角色
Candidates often incorrectly state that the Program Counter (PC) stores the current instruction, or that the Memory Address Register (MAR) holds data being processed. These slips indicate a fragile understanding of the control unit's operation.
考生经常错误地声称程序计数器（PC）存放当前指令，或者认为内存地址寄存器（MAR）存放正在处理的数据。这些差错表明他们对控制器操作的理解不牢固。
The correct sequence: The PC holds the address of the next instruction to be fetched. This address is copied to the MAR, which is connected to the address bus. The instruction at that address is fetched and placed in the Memory Data Register (MDR). The instruction is then copied to the Current Instruction Register (CIR) where it is decoded. The PC is incremented to point to the next instruction. The data address part, if present, is loaded into the MAR for data access. Visualising this cycle step‑by‑step with diagrams solidifies the distinct roles of each register.
正确的顺序是：PC 保存下一条将要取出的指令的地址。该地址被复制到 MAR，MAR 与地址总线相连。该地址处的指令被取出并放入内存数据寄存器（MDR）中。然后指令被复制到当前指令寄存器（CIR）中进行译码。PC 递增，指向下一条指令。如果存在数据地址部分，则将其加载到 MAR 中以进行数据存取。通过图示逐步可视化这一周期，可以巩固每个寄存器各自不同的角色。
10. HTML and CSS Misunderstandings | HTML与CSS的误解
A persistent myth is that HTML is a programming language and that CSS is only about colours and fonts. Students also struggle with CSS specificity and the cascading nature of styles, often applying inline styles excessively without understanding inheritance.
一个持久流传的错误是认为 HTML 是一种编程语言，而 CSS 仅涉及颜色和字体。学生也常对 CSS 的优先级和样式的层叠特性感到困难，经常过度使用内联样式，却不理解继承。
HTML is a markup language used to structure content with elements such as headings, paragraphs and links; it lacks computational logic (no loops, conditions or variables). CSS controls presentation — layout, typography, colours and responsive design — using selectors that target HTML elements. Specificity determines which style rule is applied when there are conflicts: inline styles override class selectors, which override element selectors. Understanding the cascade, inheritance and the box model enables cleaner, more efficient web pages and is required for SQA coursework.
HTML 是一种标记语言，用于使用标题、段落和链接等元素来构建内容；它缺乏计算逻辑（没有循环、条件或变量）。CSS 控制表现——布局、排版、颜色和响应式设计——通过选择器定位 HTML 元素。当存在冲突时，优先级决定了应用哪条样式规则：内联样式覆盖类选择器，类选择器覆盖元素选择器。理解层叠、继承和盒子模型可以构建更清晰、更高效的网页，这也是 SQA 课程作业的要求。
11. Encryption versus Hashing | 加密与哈希的区别
Many students use the terms 'encryption' and 'hashing' interchangeably, writing that passwords are encrypted and can be decrypted if needed. This reveals a fundamental misunderstanding of cryptology and secure data handling.
许多学生交替使用“加密”和“哈希”这两个术语，写道密码是加密的，必要时可以解密。这暴露了他们对密码学和安全数据处理基本理解上的不足。
Encryption is a reversible process that transforms plaintext into ciphertext using a key; decryption with the correct key recovers the original data. Hashing is a one‑way function that produces a fixed‑size digest from any input; it is designed to be irreversible. Storing password hashes (e.g., using SHA‑256 with salt) means even the system administrator cannot recover the original password. Other differences: the same plaintext always produces the same hash, but different ciphertext with an encryption IV (initialisation vector). SQA students must be able to distinguish these concepts and identify appropriate use cases, such as encrypting transmitted data but storing hashed credentials.
加密是一个可逆过程，使用密钥将明文转换为密文；使用正确密钥解密可恢复原始数据。哈希是一种单向函数，从任意输入生成固定长度的摘要；其设计初衷是不可逆的。存储密码哈希（例如，使用加盐的 SHA‑256）意味着即使是系统管理员也无法恢复原始密码。其他区别：相同的明文总是产生相同的哈希值，而使用加密初始化向量（IV）时相同的明文会产生不同的密文。SQA 学生必须能够区分这些概念，并识别适当的使用场景，例如加密传输中的数据和存储哈希后的凭证。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图