📚 Common Misconceptions in Year 9 SQA Computing and How to Correct Them | 九年级SQA计算机常见误区与纠正方法
In Year 9 SQA Computing, students often encounter concepts that seem simple but can easily be misunderstood. Recognising and correcting these misconceptions early builds a solid foundation for more advanced studies in Computer Science.
在九年级SQA计算机课程中，学生经常会遇到一些看似简单但很容易误解的概念。及早识别并纠正这些误区，可为更高级的计算机科学学习打下坚实基础。
1. Binary and Decimal Misunderstandings | 二进制与十进制的误解
A common error is treating binary numbers like decimal numbers, assuming that '10' in binary means ten. This leads to incorrect conversions and arithmetic.
一个常见的错误是把二进制数当成十进制数，以为二进制中的“10”就是十，从而导致错误的转换和运算。
the next is 2¹ (2), and so on. Therefore, binary 10 equals 1 × 2¹ + 0 × 2⁰ = 2 in decimal.
事实上，每个二进制位（比特）代表2的幂：最右边的位是2⁰（1），下一位是2¹（2），以此类推。因此，二进制10等于1 × 2¹ + 0 × 2⁰ = 十进制中的2。
Another frequent mistake is forgetting that the highest value in an 8-bit binary number is 255 (11111111), not 256. The range is 0–255, giving 256 possible values.
另一个常见错误是忘记8位二进制数的最大值是255（11111111），而不是256。范围是0–255，共256个可能的值。
2. Confusing Data Storage Units | 数据存储单位混淆
Students often mix up bits, bytes, kilobytes, and kibibytes. They may think that 1 kilobyte (KB) is exactly 1000 bytes, but in computing, it is often 1024 bytes (a kibibyte, KiB). This ambiguity appears frequently in SQA questions.
学生常常混淆比特、字节、千字节和千比字节。他们可能觉得1千字节（KB）正好是1000字节，但在计算机中通常指1024字节（千比字节，KiB）。SQA试题中经常出现这种歧义。
1 KiB = 1024 bytes in binary memory contexts. Always check the context in exam questions.
正确的方法：1字节 = 8比特。在十进制存储场景（硬盘）中，1 KB通常定义为1000字节；而在二进制内存场景中，1 KiB = 1024字节。考试时一定要根据题目情境判断。
Also, note that uppercase 'B' means byte, while lowercase 'b' means bit. Transfer speeds are often in bits per second (bps), not bytes.
还要注意，大写“B”表示字节，小写“b”表示比特。传输速率通常以比特每秒（bps）为单位，而非字节。
3. Variables vs. Values in Programming | 编程中变量与值的误解
Many learners believe that a variable stores the expression or formula used to calculate its value, rather than the current result. For example, after score = 10 + 5, they might think score 'remembers' the calculation.
很多学习者以为变量存储的是用于计算其值的表达式或公式，而不是当前的结果。例如，执行 score = 10 + 5 后，他们可能认为 score “记住了”这个计算。
In fact, a variable holds the evaluated value. In most languages, once the statement runs, score contains 15, not the expression. If you later change another variable, score does not automatically update.
事实上，变量保存的是计算后的值。在大多数语言中，语句执行后，score 就包含15，而不是表达式。如果之后更改其他变量，score 不会自动更新。
Similarly, confusing the concept of 'constant' and 'variable' leads to bugs. A constant cannot be changed after it is assigned, while a variable can be reassigned.
同样，混淆“常量”和“变量”的概念会导致程序错误。常量在赋值后不能更改，而变量可以重新赋值。
4. The Confusion between Assignment '=' and Equality '==' | 赋值“=”与等号“==”的混淆
In programming, the single equals sign '=' is used for assignment, not for checking equality. Many Year 9 students write if (x = 5) expecting a comparison, but this assigns 5 to x, always evaluating as true in some languages.
在编程中，单个等号“=”用于赋值，而不是检查相等。许多九年级学生写出 if (x = 5) 期望进行比较，但这会将5赋给x，在某些语言中始终为真。
To test equality, the correct operator is '==' (double equals). So if (x == 5) checks whether x holds the value 5. Mixing them up is a top source of logic errors in SQA practical tasks.
要测试相等性，正确的运算符是“==”（双等号）。因此 if (x == 5) 检查x的值是否等于5。混淆它们是SQA实践任务中逻辑错误的主要来源。
Some students also misuse '=' in pseudocode flowcharts, writing conditions with '=', which should be '==' or 'equals'. Always follow the standard used in the reference language for SQA.
一些学生在伪代码流程图里也会误用“=”，应当使用“==”或“equals”。务必遵循SQA参考语言中使用的标准。
5. Misinterpreting Flowchart Symbols | 流程图符号误用
Flowcharts are essential in SQA Computing, but students frequently mix up the meanings of common symbols. For example, they use a rectangle for a decision instead of a diamond.
流程图在SQA计算机中至关重要，但学生常常混淆常用符号的含义。比如，他们用矩形表示判断，而不是菱形。
A rectangle (or process box) represents an action, like an assignment or calculation. A diamond (decision box) must be used when a condition is checked, leading to two branches (true/false).
矩形（或处理框）代表一个动作，如赋值或计算。当检查条件时，必须使用菱形（判断框），引出两个分支（真/假）。
Another mistake is forgetting the arrow direction, which can make the logic unclear. Arrows show the flow of execution and must be unidirectional.
另一个错误是忽略箭头方向，导致逻辑不清。箭头表示执行流程，必须是单向的。
6. Logic Gate Errors | 逻辑门错误
Students often think that an OR gate outputs 1 only when both inputs are 1, which is actually the behaviour of an AND gate. This fundamental confusion leads to incorrect truth tables.
学生经常以为或门（OR）只在两个输入都为1时才输出1，而这其实是与门（AND）的行为。这种根本性混淆会导致真值表错误。
Truth table for AND: output is 1 if and only if all inputs are 1. OR: output is 1 if at least one input is 1. NOT simply inverts the input.
与门真值表：当且仅当所有输入都为1时，输出为1。或门：至少一个输入为1时，输出为1。非门只是将输入取反。
When combining gates, some forget that NAND and NOR are inverted versions of AND and OR. Practice drawing and verifying circuits to avoid errors.
在组合门电路时，有人忘记与非门（NAND）和或非门（NOR）分别是与门和或门的取反。练习绘制并验证电路可以避免错误。
7. Cybersecurity Myths | 网络安全常见误解
A widespread misconception is that a firewall can protect against all cyber threats, including viruses and phishing. A firewall mainly monitors and controls incoming and outgoing network traffic based on rules, but it cannot detect malware hidden in an email attachment.
一个普遍的误解是防火墙可以防御所有网络威胁，包括病毒和网络钓鱼。防火墙主要根据规则监控和控制进出网络流量，但不能检测隐藏在电子邮件附件中的恶意软件。
Similarly, students may assume that antivirus software alone is enough to stay safe, ignoring the importance of strong passwords, updates, and user awareness. Security requires a layered approach.
同样，学生可能认为仅靠反病毒软件就足以保证安全，而忽略了强密码、系统更新和用户意识的重要性。安全需要多层防护。
Another myth: 'I have nothing important, so hackers won’t target me.' In reality, attackers often scan for vulnerable devices to build botnets or steal personal data for identity theft.
另一个误区：“我没有什么重要的东西，黑客不会攻击我。”实际上，攻击者常常扫描有漏洞的设备来组建僵尸网络或窃取个人信息用于身份盗窃。
8. Network Address Misconceptions | 网络地址误解
In SQA Computing, students often confuse IP addresses with MAC addresses. They may think both are permanent or both can be changed easily. An IP address is a logical address assigned by the network, which can change (dynamic IP), while a MAC address is a unique physical identifier burned into the network card, generally fixed.
在SQA计算机中，学生常常混淆IP地址和MAC地址。他们可能认为两者都是永久的或都可以轻易更改。IP地址是由网络分配的逻辑地址，可以改变（动态IP）；而MAC地址是烧录在网卡中的唯一物理标识符，通常是固定的。
Also, some believe that every device on the internet has a unique IP address globally. However, with Network Address Translation (NAT), many devices share a single public IP within a local network.
此外，有些人认为互联网上的每个设备都有一个全球唯一的IP地址。然而，通过网络地址转换（NAT），许多设备在本地网络内共享一个公共IP。
When working with web addresses, students must differentiate between a URL and a domain name. A URL includes the protocol (https://) and path, while the domain name is just the human-readable part (e.g., aleveler.com).
在接触网址时，学生必须区分URL和域名。URL包含协议（https://）和路径，而域名只是人类可读的部分（例如 aleveler.com）。
9. SQL Query Mistakes | SQL查询错误
Year 9 students working on databases often misuse SQL keywords. A typical error is forgetting the WHERE clause in an UPDATE or DELETE statement, which could modify or erase all records in a table.
处理数据库的九年级学生经常误用SQL关键字。一个典型的错误是在UPDATE或DELETE语句中忘记WHERE子句，这可能会修改或删除表格中的所有记录。
Another frequent mistake is using '=' instead of 'LIKE' for pattern matching, or not enclosing text values in single quotes. For example, SELECT * FROM students WHERE name = John will fail; correct syntax is WHERE name = 'John'.
另一个常见错误是在模式匹配时使用“=”而不是“LIKE”，或者没有将文本值用单引号括起来。例如，SELECT * FROM students WHERE name = John 会失败；正确的语法是 WHERE name = 'John'。
Students also confuse JOIN types, thinking that INNER JOIN and OUTER JOIN are the same. An INNER JOIN returns only matching rows, while a LEFT JOIN returns all rows from the left table. Understanding this is crucial for SQA assignments.
学生也会混淆连接类型，以为内连接（INNER JOIN）和外连接（OUTER JOIN）是一样的。内连接只返回匹配的行，而左连接（LEFT JOIN）返回左表的所有行。理解这一点对SQA作业至关重要。
10. Misunderstanding HTML and CSS Roles | HTML与CSS角色的误解
Many beginners think that HTML tags can also control the layout and colours of a webpage, confusing structure with presentation. HTML defines the structure and content, while CSS is used for styling, layout, and design.
许多初学者认为HTML标签也能控制网页的布局和颜色，混淆了结构与样式。HTML定义结构和内容，而CSS用于样式、布局和设计。
For instance, using the <b> tag for bold text is structural emphasis (though deprecated in favour of <strong>), but setting colour and font size should be done via CSS. Inline styles are discouraged in SQA projects in favour of external stylesheets.
例如，使用 <b> 标签加粗文本是结构强调（尽管已不推荐使用，建议用 <strong>），但设置颜色和字体大小应通过CSS完成。在SQA项目中，不鼓励使用内联样式，而推荐使用外部样式表。
Additionally, students may think that JavaScript is needed for all interactive elements; however, simple forms and links work without it. Knowing the separation of concerns is a key learning outcome.
此外，学生可能认为所有交互元素都需要JavaScript；但简单的表单和链接无需它也能工作。理解关注点分离是一个关键的学习目标。
Published by TutorHao | SQA Computing Revision Series | alevel
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图