Year 11 AQA Computer Science: Unit Test Mock Paper Analysis | Year 11 AQA 计算机：单元测试模拟卷解析

📚 Year 11 AQA Computer Science: Unit Test Mock Paper Analysis | Year 11 AQA 计算机：单元测试模拟卷解析

Unit tests and mock papers are essential tools for Year 11 students following the AQA GCSE Computer Science specification. They not only help to identify gaps in knowledge but also build confidence in applying concepts under timed conditions. This analysis breaks down a typical unit test, covering key areas such as data representation, programming, algorithms, hardware, networking, cyber security, databases, ethical issues, and software testing. Each section provides detailed worked solutions, marking insights, and common pitfalls to avoid, ensuring you are fully prepared for both internal assessments and the final examinations.

单元测试和模拟试卷是遵循 AQA GCSE 计算机科学课程大纲的 Year 11 学生不可或缺的工具。它们不仅能帮助找出知识漏洞，还能培养在限时条件下应用概念的信心。本文解析一份典型的单元测试卷，涵盖数据表示、编程、算法、硬件、网络、网络安全、数据库、伦理问题以及软件测试等关键领域。每个部分都提供详细的解题步骤、评分要点和需避免的常见错误，确保你为校内测评和最终大考做好充分准备。

1. Question 1: Number Representation – Binary and Hexadecimal | 问题1：数字表示——二进制与十六进制

Question: Convert the decimal (denary) number 179 into an 8-bit binary number. Then convert your binary result into hexadecimal. Show all your working clearly.

题目：将十进制数 179 转换为 8 位二进制数，然后将该二进制结果转换为十六进制。请清晰展示所有步骤。

Step 1: Write down the place values for an 8-bit binary number from left to right. These are powers of two: 128, 64, 32, 16, 8, 4, 2, 1.

步骤 1：从左到右写出 8 位二进制数的位值。这些是 2 的幂：128、64、32、16、8、4、2、1。

Step 2: Starting with the largest place value (128), determine whether it can be subtracted from 179. 179 − 128 = 51, so we place a 1 under 128. Next, 64 cannot be subtracted from 51, so a 0 under 64. 51 − 32 = 19, so 1 under 32. 19 − 16 = 3, so 1 under 16. 8 cannot go into 3, so 0 under 8. 4 cannot, so 0 under 4. 3 − 2 = 1, so 1 under 2. Finally, 1 − 1 = 0, so 1 under 1. This gives the binary number: 10110011₂.

步骤 2：从最大的位值（128）开始，判断它能否从 179 中减去。179 − 128 = 51，因此在 128 下放置 1。接着，64 无法从 51 中减去，故在 64 下放 0。51 − 32 = 19，32 下放 1。19 − 16 = 3，16 下放 1。8 不能从 3 中减，放 0。4 也不能，放 0。3 − 2 = 1，2 下放 1。最后 1 − 1 = 0，1 下放 1。得到二进制数：10110011₂。

Step 3: To convert binary to hexadecimal, split the 8-bit binary number into two nibbles (groups of 4 bits): 1011 and 0011. Convert each nibble independently. The left nibble 1011₂ equals 8+0+2+1 = 11 in decimal, which corresponds to B in hexadecimal. The right nibble 0011₂ equals 0+0+2+1 = 3, corresponding to 3. Thus the hexadecimal representation is B3.

步骤 3：将二进制数转换为十六进制时，把 8 位二进制数分成两个半字节（每组 4 位）：1011 和 0011。分别转换每个半字节。左半字节 1011₂ 等于 8+0+2+1 = 11（十进制），对应十六进制的 B。右半字节 0011₂ 等于 0+0+2+1 = 3，对应 3。因此十六进制表示为 B3。

179₁₀ = 10110011₂ = B3₁₆

Always check your working: in an exam, even a small misplacement of a 0 or 1 can cost marks. Practice with numbers at the boundaries, such as 255 and 0.

务必检查你的解题过程：在考试中，哪怕一个 0 或 1 放错位置都会丢分。多用边界值练习，例如 255 和 0。

2. Question 2: Programming Concepts – Variables, Data Types and Casting | 问题2：编程概念——变量、数据类型与类型转换

Question: Examine the following Python code. State the final value and data type of the variable x after execution.

题目：查看以下 Python 代码。指出执行后变量 x 的最终值和数据类型。

x = 5
y = "3"
x = x + int(y)
print(x)

Explanation: The variable x is initially assigned the integer value 5. The variable y is assigned the string “3”. The built-in function int() converts the string “3” into the integer 3. The line x = x + int(y) therefore calculates 5 + 3, which equals 8, and reassigns this integer back to x. The final value is 8, and its data type is integer (int).

解析：变量 x 最初被赋予整数值 5。变量 y 被赋予字符串 “3”。内置函数 int() 将字符串 “3” 转换为整数 3。因此语句 x = x + int(y) 计算 5 + 3，结果为 8，并将该整数重新赋值给 x。最终值为 8，数据类型为整数 (int)。

Common mistake: forgetting that y is a string and attempting x + y directly would cause a TypeError. Understanding type casting is vital for error-free programming.

常见错误：忘记 y 是字符串而直接尝试 x + y 会导致 TypeError。理解类型转换对无错编程至关重要。

3. Question 3: Algorithm Design – Linear Search Pseudocode | 问题3：算法设计——线性搜索伪代码

Question: A program stores a list of student names. Write pseudocode for a linear search algorithm that searches for a target name ‘Alice’ and outputs the index if found, otherwise outputs -1.

题目：某程序存储了一个学生姓名列表。编写伪代码，实现线性搜索算法，查找目标姓名 ‘Alice’，若找到则输出其索引，否则输出 -1。

Solution approach: Use a loop to iterate through each element of the array, comparing it with the target. If a match occurs, return the current index and stop. If the loop finishes without finding a match, return -1.

解题思路：使用循环遍历数组的每个元素，将其与目标比较。如果找到匹配项，返回当前索引并停止。若循环结束仍未找到，返回 -1。

Accepted pseudocode:

procedure linearSearch(names, target)
    for i ← 0 to length(names) - 1
        if names[i] = target then
            output i
            return
        endif
    next i
    output -1
endprocedure

Mark scheme notes: The algorithm must initialise a counter, check each element, correctly output the index on a match, and handle the ‘not found’ case. Indentation and use of arrows for assignment (←) are recommended for clarity.

评分要点：算法必须初始化计数器，逐一检查每个元素，在找到匹配时正确输出索引，并处理“未找到”的情况。为保持清晰，推荐使用缩进和箭头赋值符号 (←)。

Efficiency: Linear search examines each item in turn, so in the worst case it checks all n elements, giving a time complexity of O(n). This is acceptable for small datasets but inefficient for very large lists.

效率：线性搜索逐个检查每一项，因此在最坏情况下需要检查全部 n 个元素，时间复杂度为 O(n)。对于小数据集可以接受，但对于非常大的列表则效率低下。

4. Question 4: CPU Architecture – Registers and the Fetch-Execute Cycle | 问题4：CPU 架构——寄存器与取指-执行周期

Question: Describe the role of the Program Counter (PC) and the Memory Address Register (MAR) during the fetch stage of the fetch-execute cycle.

题目：描述在取指-执行周期的取指阶段，程序计数器 (PC) 和内存地址寄存器 (MAR) 的作用。

The Program Counter (PC) holds the memory address of the next instruction to be fetched. At the start of the fetch stage, the content of the PC is copied to the MAR. The PC is then incremented so that it points to the subsequent instruction, preparing the CPU for the next cycle.

程序计数器 (PC) 存放下一条待取指令的内存地址。在取指阶段开始时，PC 的内容被复制到内存地址寄存器 (MAR) 中。随后 PC 递增，使其指向下一条指令，为下一个周期做好准备。

The Memory Address Register (MAR) holds the address of the memory location that the CPU is about to read from or write to. During fetch, the address sent to main memory via the address bus comes from the MAR. The instruction at that address is then placed onto the data bus and loaded into the Memory Data Register (MDR).

内存地址寄存器 (MAR) 存放 CPU 即将读取或写入的内存地址。在取指阶段，通过地址总线发送到主内存的地址来自 MAR。然后该地址处的指令被放到数据总线上，并加载到内存数据寄存器 (MDR) 中。

These two registers work in tandem to ensure the correct instruction is retrieved smoothly. Understanding their interaction is fundamental to grasping the Von Neumann architecture.

这两个寄存器协同工作，确保正确指令被顺利取出。理解它们之间的互动是掌握冯·诺依曼架构的基础。

5. Question 5: Networking – Comparing Star and Bus Topologies | 问题5：网络——星型与总线拓扑的比较

Question: Compare a star network topology with a bus network topology. Give one advantage and one disadvantage for each.

题目：比较星型网络拓扑和总线网络拓扑。分别为每种拓扑给出一个优点和一个缺点。

Star topology: All nodes are connected to a central switch or hub. Advantage – if one cable fails, only that node is affected; the rest of the network continues to operate. Disadvantage – if the central switch fails, the whole network goes down. It also requires more cabling, increasing cost.

星型拓扑：所有节点连接到一个中央交换机或集线器。优点——如果某条线缆故障，只有该节点受影响，网络其余部分仍可运行。缺点——若中央交换机故障，整个网络瘫痪。它还需要更多线缆，增加成本。

Bus topology: All nodes share a single communication line (the bus). Advantage – it is cheap and easy to install because minimal cable is required. Disadvantage – if the main bus cable breaks, the entire network fails. Also, performance degrades significantly with many nodes due to collisions.

总线拓扑：所有节点共享一条通信线路（总线）。优点——由于所需线缆极少，成本低廉且易于安装。缺点——如果主干总线线缆损坏，整个网络失效。而且由于冲突，节点数量多时性能会严重下降。

In modern networks, star topologies are far more common because of their reliability and ease of troubleshooting, even though they are slightly more expensive to set up.

在现代网络中，星型拓扑因其可靠性和易于排错而常见得多，尽管安装成本略高。

6. Question 6: Cyber Security – Firewalls and Social Engineering | 问题6：网络安全——防火墙和社会工程学

Question: Explain how a firewall helps to protect a network from unauthorised access. Name and briefly describe one form of social engineering attack.

题目：解释防火墙如何帮助保护网络免受未经授权的访问。说出一种社会工程攻击形式并简要描述。

A firewall acts as a barrier between a trusted internal network and an untrusted external network (e.g., the internet). It inspects incoming and outgoing data packets and filters them based on a set of security rules. Packets that do not meet the rules are blocked, thereby preventing malicious traffic from reaching the internal network.

防火墙充当受信任的内部网络与不受信任的外部网络（如互联网）之间的屏障。它检查传入和传出的数据包，并根据一组安全规则进行过滤。不符合规则的数据包被阻止，从而防止恶意流量抵达内部网络。

Social engineering example – Phishing: This involves sending fraudulent emails that appear to come from a trustworthy source (e.g., a bank) to trick recipients into revealing sensitive information such as passwords or credit card numbers. It exploits human psychology rather than technical weaknesses.

社会工程示例——网络钓鱼：这涉及发送看似来自可信来源（如银行）的欺诈邮件，诱骗收件人泄露密码或信用卡号等敏感信息。它利用的是人类心理而非技术漏洞。

Many high-profile security breaches begin with a social engineering attack, making user education and robust policies just as important as technological defences like firewalls.

许多重大安全事件都始于社会工程攻击，因此用户教育和健全的策略与防火墙等技术防御同等重要。

7. Question 7: Databases – SQL Queries and Data Integrity | 问题7：数据库——SQL 查询与数据完整性

Question: A database table named Student contains fields: StudentID (integer), FirstName (text), LastName (text), and YearGroup (integer). Write an SQL query to select the first name and last name of all students in Year 11, ordered alphabetically by last name.

题目：一个名为 Student 的数据库表包含字段：StudentID（整数）、FirstName（文本）、LastName（文本）和 YearGroup（整数）。编写一条 SQL 查询，选择所有 Year 11 学生的名字和姓氏，并按姓氏字母顺序排序。

The required SQL statement is:

SELECT FirstName, LastName
FROM Student
WHERE YearGroup = 11
ORDER BY LastName ASC;

Explanation: The SELECT clause specifies which columns to retrieve. The FROM clause indicates the table name. The WHERE clause filters records to only those where YearGroup equals 11. The ORDER BY clause sorts the results in ascending alphabetical order by LastName (ASC is default if omitted).

解释：SELECT 子句指定要检索的列。FROM 子句指明表名。WHERE 子句将记录筛选为仅限 YearGroup 等于 11 的行。ORDER BY 子句将结果按 LastName 升序字母顺序排序（若省略 ASC，默认为升序）。

Common pitfalls: forgetting the semicolon at the end, or using single equals for a condition (YearGroup = 11) is correct in SQL, not double equals. Also, using ORDER BY with a column not in SELECT generally works but is better practice to include it.

常见错误：末尾忘记分号；SQL 中使用单等号（YearGroup = 11）是正确的，不能使用双等号。另外，对不在 SELECT 中的列使用 ORDER BY 通常可行，但最佳实践是包含它。

8. Question 8: Ethical, Legal and Environmental Issues – Open Source Software | 问题8：伦理、法律与环境问题——开源软件

Question: Discuss one ethical issue associated with the use of open source software.

题目：讨论一个与使用开源软件相关的伦理问题。

One significant ethical issue is the question of proper attribution. Open source licences often require that any redistribution of the software must give credit to the original authors. Failing to provide this attribution, or claiming the work as one’s own, constitutes a form of plagiarism and disrespects the intellectual effort of the original developers. Even though the source code is freely available, ethical practice demands acknowledging contributors to maintain transparency and fairness within the software community.

一个重要的伦理问题是适当署名的问题。开源许可证通常要求软件的任何再分发都必须注明原作者。未能提供这种署名，或声称作品是自己的，构成一种抄袭，并不尊重原始开发者的智力劳动。尽管源代码可免费获取，但合乎伦理的实践要求承认贡献者，以维护软件社区内的透明度和公平性。

Another angle is the responsibility of users to contribute fixes or documentation back to the community rather than just taking code without giving back, which touches on the ethical principle of reciprocity.

另一个角度是用户有责任将修复或文档回馈给社区，而不是只获取代码而不回报，这涉及互惠互利这一伦理原则。

9. Question 9: Software Testing – Normal, Boundary and Erroneous Data | 问题9：软件测试——正常、边界和异常数据

Question: A program prompts the user to enter their age, which must be an integer between 0 and 130 inclusive. Provide examples of test data for each category: normal, boundary, and erroneous. Explain why each is chosen.

题目：一个程序提示用户输入年龄，该年龄必须是 0 到 130（含）之间的整数。为正常、边界和异常三类测试数据各提供示例，并解释为何选择这些数据。

Normal data: 25. This is a typical age well within the valid range. It tests that the program correctly processes valid input without triggering any error handling.

正常数据：25。这是一个完全在有效范围内的典型年龄。它测试程序是否能在不触发任何错误处理的情况下正确处理有效输入。

Boundary data: 0, 130, and -1, 131. The lower boundary values 0 and -1 are critical because 0 is the smallest accepted value, while -1 is just below and should be rejected. Similarly, 130 is the highest valid age, and 131 is just outside. Testing boundaries ensures the program’s logic handles the edge of the allowable range correctly.

边界数据：0、130，以及 -1、131。下边界值 0 和 -1 非常关键，因为 0 是最小的可接受值，而 -1 刚好低于这个值，应被拒绝。类似地，130 是最大有效年龄，131 则刚好超出范围。测试边界可确保程序逻辑正确处理允许范围的边缘。

Erroneous data: “seventeen”, 3.5, and an empty input. These are invalid types or formats. Testing these verifies that the program can handle unexpected input gracefully, for example by displaying an error message and asking the user to re-enter, rather than crashing.

异常数据：”seventeen”、3.5 以及空输入。这些是无效的类型或格式。测试这些数据可验证程序能否优雅地处理意外输入，例如显示错误信息并要求用户重新输入，而不是崩溃。

A robust testing strategy using all three categories is essential for producing reliable software, and this is frequently examined in the AQA Unit Test.

Published by TutorHao | Year 11 Computer Science Revision Series | aleveler.com

更多咨询请联系16621398022（同微信）

Year 11 AQA Computer Science: Unit Test Mock Paper Analysis | Year 11 AQA 计算机：单元测试模拟卷解析