📚 Year 11 Edexcel Computer Science Unit Test Mock Paper Walkthrough | 爱德思计算机科学单元测试模拟卷解析
This article walks you through a carefully constructed Edexcel-style unit test mock paper for Year 11 Computer Science. We will break down typical questions covering data representation, logic, algorithms, networking, cybersecurity, SQL, and ethical issues. Each section provides an example question, a clear explanation, and common pitfalls to avoid, helping you consolidate key knowledge and refine your exam technique.
本文将带你深入解析一份精心设计的爱德思风格 Year 11 计算机科学单元测试模拟卷。我们将逐一拆解涵盖数据表示、逻辑、算法、网络、网络安全、SQL以及伦理问题等典型题目。每个部分都会给出示例问题、清晰的解释以及需要避开的常见陷阱，帮助你巩固核心知识并优化应试技巧。
1. Binary to Decimal and Hexadecimal Conversion | 二进制与十进制、十六进制转换
Sample Question 1: The binary number 11010110 is stored in a register. (a) Calculate its decimal value. (b) Represent the same value in hexadecimal.
示例题目1：二进制数 11010110 存储在某个寄存器中。(a) 计算它的十进制值。(b) 用十六进制表示该值。
1. So we have 128 + 64 + 0 + 16 + 0 + 4 + 2 + 0 = 214. Therefore the decimal value is 214.
二进制转十进制，将出现 1 的位对应的权值相加。从左到右的权值分别是 128, 64, 32, 16, 8, 4, 2, 1。因此我们得到 128 + 64 + 0 + 16 + 0 + 4 + 2 + 0 = 214。十进制值为 214。
To obtain the hexadecimal equivalent, split the binary number into nibbles (groups of 4 bits): 1101 0110. 1101₂ is 13 in decimal, which is D in hex; 0110₂ is 6. Hence the hexadecimal representation is D6.
要得到十六进制，将二进制数拆分为半字节（4位一组）：1101 0110。1101₂ 是十进制 13，即十六进制 D；0110₂ 是 6。所以十六进制表示为 D6。
11010110₂ = 214₁₀ = D6₁₆
A common mistake is forgetting to pad the leftmost group with zeros when the bits do not form a complete nibble. Always ensure groups of four starting from the right.
一个常见错误是当最左边的一组不足4位时忘记补零。务必从右侧开始每四位一组，不足的补零。
2. Logic Gates and Truth Tables | 逻辑门与真值表
Sample Question 2: sion Q = A AND (NOT B). Then identify a single logic gate that could replace this circuit.
示例题目2：画出逻辑表达式 Q = A AND (NOT B) 的真值表，然后指出可以用哪种单一逻辑门替代该电路。
=0, B=1: NOT B=0, so 0 AND 0 = 0. When A=1, B=0: NOT B=1, so 1 AND 1 = 1. When A=1, B=1: NOT B=0, so 1 AND 0 = 0. Thus Q = 1 only when A=1 and B=0.
该表达式使用了一个与门，其中一个输入经过反相。我们评估 A 和 B 的四种组合。A=0, B=0：NOT B=1，0 AND 1 = 0。A=0, B=1：NOT B=0，0 AND 0 = 0。A=1, B=0：NOT B=1，1 AND 1 = 1。A=1, B=1：NOT B=0，1 AND 0 = 0。因此只有当 A=1 且 B=0 时 Q=1。
| A | B | NOT B | Q |
|---|---|---|---|
| 0 | 0 | 1 | 0 |
| 0 | 1 | 0 | 0 |
| 1 | 0 | 1 | 1 |
| 1 | 1 | 0 | 0 |
f a single AND gate with one inverted input, which cannot be reduced further. However, if we consider the pattern A·¬ A=1,B=0) and also for (A=0,B=1). So the correct single replacement is still an AND gate, provided we keep the inverter or interpret it as a 2-input gate with one inverting input.
这个真值表与带有反相输入的与门一致，输出仅在 A=1 且 B=0 时为 1。这其实就是一路输入反相后接与门的行为，无法进一步简化。如果从逻辑功能看，很多同学会误以为是异或门；但异或门在 (A=1,B=0) 和 (A=0,B=1) 时都输出 1。因此正确的单一门替代仍然是 AND 门，只要保留非门，或者将其视为一个输入端带反相的与门。
3. Tracing Algorithms | 算法跟踪
Sample Question 3: Trace the following pseudocode and state the final value of total.
x ← 3
total ← 0
WHILE x < 10
total ← total + x
x ← x + 2
ENDWHILE
示例题目3：跟踪下列伪代码，写出变量 total 的最终值。
nd iteration: x=5 < 10 true; total=3+5=8, x=7. Third iteration: x=7 < 10 true; total=8+7=15, x=9. Fourth iteration: x=9 < 10 true; total=15+9=24, x=11. Now x=11, loop condition 11 < 10 is false, exit. Final total = 24.
我们建立一个跟踪表。初始 x=3, total=0。条件 x < 10 为真，进入循环。第一次迭代：total 变为 0+3=3，x 变为 3+2=5。第二次：x=5 < 10 真；total=3+5=8，x=7。第三次：x=7 < 10 真；total=8+7=15，x=9。第四次：x=9 < 10 真；total=15+9=24，x=11。此时 x=11，循环条件 11 < 10 为假，退出。最终 total = 24。
A common pitfall is to miss updating the loop counter correctly or to assume the loop runs while x is less than or equal to 10. Always check the exact condition and execute step by step. In exams, using a trace table prevents careless errors.
一个常见错误是忘记正确更新循环变量，或误以为当 x 小于等于 10 时循环运行。务必检查确切的条件，并逐步执行。在考试中使用跟踪表可以避免粗心导致的错误。
4. Interpreting Flowcharts | 流程图解析
Sample Question 4: A flowchart asks the user to enter a number repeatedly until they enter 0, then outputs the count of numbers entered (excluding 0). Identify the flowchart symbols needed and describe the purpose of the decision diamond.
示例题目4：某流程图要求用户反复输入数字，直到输入 0 为止，然后输出输入数字的个数（不包括 0）。指出所需的流程图符号，并描述判断菱形的用途。
A typical solution uses an input/output parallelogram for reading the number, a process rectangle for incrementing the counter, and a decision diamond for testing whether the number is equal to 0. The diamond has two exits: 'Yes' leads to the output step and 'No' loops back to the input. The decision symbol is crucial because it controls the iteration; without it, the program would not know when to stop.
典型的解决方案使用输入/输出平行四边形读取数字，使用过程矩形递增计数器，以及一个判断菱形来测试数字是否等于 0。该菱形有两个出口：“是”流向输出步骤，“否”循环回到输入。判断符号至关重要，因为它控制了循环；没有它，程序将不知道何时停止。
When drawing flowcharts, always make sure the flow lines are clearly labelled and the decision boxes contain a precise Boolean expression. For Edexcel exams, you may be asked to complete a partially drawn flowchart; practise tracing and filling in missing symbols.
绘制流程图时，务必确保流线标示清晰，判断框内包含精确的布尔表达式。在爱德思考试中，你可能需要补全部分绘制的流程图；建议多练习跟踪和填写缺失的符号。
5. Data Types and Variables | 数据类型与变量
Sample Question 5: A program stores student records containing a unique ID, name, average score, and whether an award has been granted. Suggest an appropriate data type for each field and justify your choices.
示例题目5：一个程序存储学生记录，包含唯一 ID、姓名、平均分以及是否已授予奖项。为每个字段建议合适的数据类型并说明理由。
Unique ID: Although it looks numeric, it is never used in arithmetic, so a string (or text) is best to preserve leading zeros. Name: definitely a string. Average score: likely a real/float because scores may involve decimals (e.g. 78.5). Award granted: boolean (True/False) as there are only two possible states. Some students incorrectly assign integer to ID; this could cause loss of leading zeros and should be avoided.
唯一 ID：虽然看起来是数字，但从不用于算术运算，因此最好使用字符串（或文本）以保留前导零。姓名：显然是字符串。平均分：由于可能包含小数（如 78.5），应用实数/浮点型。是否授予奖项：布尔型（True/False），因为只有两种状态。有些同学错误地将 ID 设为整型，这可能导致前导零丢失，应当避免。
In Edexcel, you are expected to know the common data types: integer, real/float, Boolean, character, and string. Be ready to match each to a scenario and explain why a particular type is suitable or unsuitable.
在爱德思考试中，你需要了解常见的数据类型：整型、实型/浮点型、布尔型、字符和字符串。准备好根据场景匹配数据类型，并解释某种类型为何合适或不合适。
6. Network Topologies | 网络拓扑结构
Sample Question 6: Compare a star network topology and a mesh network topology in terms of fault tolerance and cabling cost. Give one scenario where each would be preferred.
示例题目6：比较星形拓扑和网状拓扑在容错能力和布线成本方面的差异，并分别给出两者更适合的应用场景。
In a star topology, all nodes connect to a central switch. If one cable fails, only that node is affected, but if the central switch fails, the whole network goes down. Cabling cost is relatively low because each device has a single link to the centre. Mesh topology (especially full mesh) connects every node to every other node; it offers high fault tolerance because multiple paths exist, but cabling is extremely expensive and complex. Star is preferred in schools or offices where simplicity and cost matter; mesh is used in critical systems such as financial trading networks or military communications where uptime is paramount.
在星形拓扑中，所有节点都连接到中央交换机。如果一根线缆故障，仅影响该节点，但如果中央交换机故障，整个网络则瘫痪。布线成本相对较低，因为每台设备只需一条到中心的链路。网状拓扑（尤其是全互联）使得每个节点都与其他所有节点相连；由于存在多条路径，容错性很高，但布线极其昂贵且复杂。星形适合需要简单和低成本的学校或办公室；网状则用于金融交易网络或军事通信等对正常运行时间要求极高的关键系统。
When writing comparison answers, always use connectives such as 'whereas' or 'on the other hand'. Explicitly mention both sides and provide concrete examples; generic answers without examples tend to lose marks.
在写比较型答案时，务必使用“而”、“另一方面”等连接词。明确提及两面并提供具体例子；没有例子的泛泛而谈往往会被扣分。
7. Network Security Threats | 网络安全威胁
Sample Question 7: Describe how an SQL injection attack is carried out and explain two ways a developer can protect against it.
示例题目7：描述 SQL 注入攻击是如何实施的，并解释开发人员可以采取的两种防护方法。
SQL injection occurs when malicious SQL code is inserted into a web form input field, which is then passed directly to the database. For example, entering ' OR 1=1 -- in a username field could bypass authentication. The database executes the unintended command, potentially revealing or damage data. To prevent it, developers should use parameterised queries (prepared statements), which separate SQL logic from user input, and validate all input to reject suspicious characters such as hyphens and quotes.
SQL 注入发生在恶意 SQL 代码被插入网页表单的输入字段，并直接传递给数据库时。例如，在用户名字段输入 ' OR 1=1 -- 可能绕过身份验证。数据库执行了非预期的命令，可能泄露或损毁数据。为防范此攻击，开发人员应使用参数化查询（预处理语句），将 SQL 逻辑与用户输入分离开；并且要验证所有输入，拒绝可疑字符，如连字符和引号。
Penetration testing is also a good practice to identify vulnerabilities before attackers do. In Edexcel questions, you might be asked to interpret a snippet of code and spot the injection risk; always consider whether user input is being trusted without sanitisation.
渗透测试也是一个好做法，可以在攻击者之前发现漏洞。在爱德思考题中，你可能需要解读一段代码并找出注入风险；始终考虑用户输入是否未经净化就被直接信任。
8. SQL Queries | SQL 查询
Sample Question 8: A table Students has fields StudentID, FirstName, LastName, YearGroup, and TutorGroup. Write an SQL statement to retrieve the first and last names of all students in year group 11 whose tutor group is '11B'.
示例题目8：表 Students 包含字段 StudentID, FirstName, LastName, YearGroup, TutorGroup。编写一条 SQL 语句，检索所有年级为 11 且导师组为 '11B' 的学生的名字和姓氏。
ed SQL uses SELECT FirstName, LastName FROM Students WHERE YearGroup = 11 AND TutorGroup = '11B' and numeric fields should not be quoted. The AND operator ensures both conditions are met.
所需 SQL 为：SELECT FirstName, LastName FROM Students WHERE YearGroup = 11 AND TutorGroup = '11B'; 注意文本数据必须用单引号包裹，数值字段则不加引号。AND 操作符确保两个条件同时满足。
A typical mistake is forgetting the quotes around the tutor group value or using double equals. Edexcel expects straightforward SELECT-FROM-WHERE syntax. You may also be asked to use ORDER BY or wildcards like % for pattern matching; practise the basic clauses thoroughly.
常见错误是忘记导师组值上的引号，或使用双等号。爱德思期望的是简单的 SELECT-FROM-WHERE 语法。你还可能被要求使用 ORDER BY 或用于模式匹配的通配符 %；请务必熟练练习基本子句。
9. Ethical, Legal, and Environmental Issues | 伦理、法律与环境问题
Sample Question 9: A social media company collects vast amounts of personal data to target advertisements. Discuss one ethical concern and one legal requirement they must comply with under the UK Data Protection Act 2018 / GDPR.
示例题目9：某社交媒体公司收集大量个人数据用于精准广告投放。讨论一个伦理问题以及根据英国《2018 年数据保护法》/GDPR 规定必须遵守的一项法律要求。
Ethically, using personal data to manipulate user behaviour or exploit vulnerable individuals raises concerns about informed consent. Users may not fully understand how their data is used. Legally, the company must ensure that data is processed fairly, lawfully, and transparently; it must have a valid lawful basis such as explicit consent, and users have the right to access, rectify, or erase their data. Failure to comply can result in heavy fines.
在伦理方面，利用个人数据操纵用户行为或剥削弱势群体引发了知情同意的问题。用户可能不完全了解自己的数据被如何利用。法律上，公司必须确保数据以公平、合法和透明的方式处理；必须有有效的法律依据，如明确同意，并且用户有权访问、更正或删除其数据。违反规定可能导致巨额罚款。
When answering such questions, always distinguish between ethical (what is morally right) and legal (what is required by law). Using the terminology from the act (e.g. 'data subject', 'data controller') will demonstrate strong subject knowledge.
在回答此类问题时，始终要区分伦理（道德上正确的事）与法律（法律要求的事）。使用法案中的术语（如“数据主体”、“数据控制者”）将展现扎实的学科知识。
10. Common Exam Pitfalls and Final Tips | 常见失分点与应试建议
To maximise marks, always read the question command words carefully: 'state' requires a brief answer, whereas 'explain' awarded for methodology. For programming-related questions, pay close attention to indentation and the difference between assignment (= or ←) and comparison (== or =).
为了拿到最高分，务必仔细阅读题目中的指令词：“state” 只需要简短回答，而 “explain” 则要求给出推理和例子。在跟踪题目中，把你的草稿跟踪表写在试卷上；即便最终答案错误，方法正确也可能得分。对于编程相关题目，要特别留意缩进以及赋值（= 或 ←）与比较（== 或 =）之间的区别。
Time management is crucial. Allocate roughly one minute per mark. If you are stuck on a question, move on and return later. Always leave a few minutes to check for careless errors such as missing units or incorrect SQL quotes. Finally, practise with real Edexcel past papers under timed conditions to build confidence.
时间管理至关重要。大致按一分一分钟分配时间。如果某道题卡住了，先跳过去，之后再回来。务必留出几分钟检查粗心错误，比如漏掉单位或 SQL 引号错误。最后，请在限时条件下练习真实的爱德思历年真题，以建立信心。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图