📚 Year 11 SQA Computing: Unit Test Mock Paper Analysis | SQA计算机科学单元测试模拟卷解析
In this article we walk through a typical SQA Computing Science unit test, breaking down each question type and explaining the key concepts you need to master. From systems analysis to data representation, every answer is explained in detail so you can boost your exam performance.
本文带你逐题分析一套典型的SQA计算机科学单元测试，详细讲解每类题型背后的核心概念。从系统分析到数据表示，每个解答都讲透，助你提升应试能力。
1. Systems Analysis and Design | 系统分析与设计
A common question asks you to identify and describe the main stages of the system life cycle. For six marks you might need to name the stages and provide a short explanation for each: analysis, design, implementation, testing, documentation, evaluation, and maintenance.
常见考题要求你识别并描述系统生命周期的主要阶段。对于一个6分的题目，你可能需要列出阶段并简要说明：分析、设计、实施、测试、文档编写、评估和维护。
During the analysis stage, an analyst investigates the current system, identifies user requirements and defines the scope of the new system. Feasibility studies are often conducted to check if a project is technically and economically viable.
在分析阶段，分析师调查现有系统，确定用户需求并定义新系统的范围。通常会进行可行性研究，检查项目在技术上和经济上是否可行。
In the design stage, the team creates plans for the user interface, data structures and processing logic. Documentation like entity-relationship diagrams may be produced. The implementation stage involves writing and integrating code, often in phases with iterative prototyping.
在设计阶段，团队规划用户界面、数据结构和处理逻辑。可能产出实体关系图等文档。实施阶段涉及编写和整合代码，通常分阶段进行，并采用迭代原型开发。
Testing ensures the software meets requirements; it includes normal, boundary and erroneous test data. Evaluation asks whether the solution is fit for purpose. Maintenance covers corrective, adaptive and perfective changes after delivery.
测试确保软件满足需求；包括正常、边界和错误测试数据。评估检查解决方案是否适合目的。维护涵盖交付后的纠正性、适应性和完善性修改。
2. Programming Constructs | 编程结构
In the programming section you are likely to see pseudocode questions that test your understanding of variables, sequence, selection and iteration. A typical task is to trace a short algorithm and write down its output.
编程部分很可能出现伪代码题，考查你对变量、顺序、选择和循环的理解。典型任务是追踪一段短算法并写出输出。
Consider this pseudocode: SET total TO 0; FOR index FROM 1 TO 5 DO SET total TO total + index; END FOR; SEND total TO DISPLAY. The loop adds 1+2+3+4+5, so the final output is 15. You need to show each step clearly in your trace table.
考虑这段伪代码：SET total TO 0; FOR index FROM 1 TO 5 DO SET total TO total + index; END FOR; SEND total TO DISPLAY。循环计算1+2+3+4+5，最终输出为15。你需要在追踪表中清晰展示每一步。
Another question may ask you to rewrite a conditional using an alternative structure, such as converting a REPEAT…UNTIL loop into a WHILE loop. Remember that a WHILE loop checks the condition before entering, whereas a REPEAT…UNTIL loop always runs at least once.
另一题可能要求你用另一种结构重写条件，例如将REPEAT…UNTIL循环转换为WHILE循环。记住WHILE循环先检查条件再进入，而REPEAT…UNTIL循环至少执行一次。
For scoring marks, always initialise variables appropriately and use correct indentation. The SQA reference language uses SET for assignment, RECEIVE for input and SEND for output.
为了拿分，务必正确初始化变量并使用合适的缩进。SQA参考语言用SET表示赋值，RECEIVE表示输入，SEND表示输出。
3. Testing and Debugging | 测试与调试
A testing question may give you a program specification and ask you to design test data to exercise different paths. You must include normal data, extreme boundary values, and erroneous inputs.
测试题可能给出一个程序规范，要求设计测试数据以覆盖不同路径。你必须包含正常数据、极端边界值和错误输入。
For a program that accepts exam scores between 0 and 100, normal test values could be 45 and 78. Boundary values are 0, 1, 99 and 100 – just inside and outside the allowed range. Erroneous data includes negative numbers, letters or 101.
对于一个接受0到100之间考试分数的程序，正常测试值可以是45和78。边界值为0、1、99和100，即刚好在范围内和刚好超出范围。错误数据包括负数、字母或101。
You might also be asked to describe syntactic, execution and logic errors. Syntax errors prevent the code from compiling; execution errors cause the program to crash (e.g. division by zero); logic errors produce wrong results without crashing.
还可能会要求你描述语法错误、运行错误和逻辑错误。语法错误阻止代码编译；运行错误导致程序崩溃（例如除以零）；逻辑错误在不崩溃的情况下产生错误结果。
Dry‑running a program with a trace table helps you track variable changes step by step, making it easier to spot the source of a logic mistake.
用追踪表进行人工运行可以逐步跟踪变量变化，更容易找出逻辑错误的来源。
4. Database Queries (SQL) | 数据库查询 (SQL)
SQL questions ask you to write queries that retrieve specific data from given tables. You must be confident with SELECT, FROM, WHERE, ORDER BY and simple aggregation functions.
SQL题要求你编写查询从给定表中检索特定数据。你必须熟练掌握SELECT、FROM、WHERE、ORDER BY和简单的聚合函数。
Given a table Student(id, name, grade), a question might ask: ‘List the names of all students with a grade above 70, sorted alphabetically.’ The answer is SELECT name FROM Student WHERE grade > 70 ORDER BY name ASC.
给定表Student(id, name, grade)，题目可能问：“列出所有成绩超过70的学生姓名，并按字母顺序排列。”答案是SELECT name FROM Student WHERE grade > 70 ORDER BY name ASC。
The WHERE clause filters rows; AND and OR can combine conditions. Always place single quotes around text values, e.g. WHERE subject = ‘Computing’. If you need to avoid duplicate rows, use SELECT DISTINCT.
WHERE子句过滤行；AND和OR可以组合条件。文本值要用单引号括起来，例如WHERE subject = ‘Computing’。如果需要避免重复行，使用SELECT DISTINCT。
For higher marks you may need to join two tables. For example, given Student and Course tables linked by a foreign key, you would write SELECT Student.name, Course.title FROM Student INNER JOIN Course ON Student.courseID = Course.id WHERE Course.level = ‘Higher’.
为了获得更高分数，你可能需要连接两个表。例如，给定通过外键关联的Student和Course表，你可以写SELECT Student.name, Course.title FROM Student INNER JOIN Course ON Student.courseID = Course.id WHERE Course.level = ‘Higher’。
5. Web Development (HTML and CSS) | 网页开发 (HTML和CSS)
Typical web development questions ask you to write HTML code that creates headings, hyperlinks, images or tables. You must use correct tag syntax and understand attributes.
典型的网页开发题会要求你编写HTML代码创建标题、超链接、图像或表格。你必须使用正确的标签语法并理解属性。
To create a link to an external site, write: <a href=’https://www.example.com’>Visit Example</a>. The href attribute holds the URL, and the text between the tags is the clickable part.
要创建指向外部站点的链接，编写：<a href=’https://www.example.com’>Visit Example</a>。href属性保存URL，标签之间的文本是可点击部分。
For displaying an image, use the <img> tag with the src attribute to specify the image file location and the alt attribute for accessibility. Example: <img src=’logo.png’ alt=’School logo’>.
要显示图像，使用<img>标签，通过src属性指定图像文件位置，并使用alt属性增强可访问性。示例：<img src=’logo.png’ alt=’School logo’>。
CSS is used to style elements. An inline style applies directly to a tag, e.g. <p style=’color: blue;’>. Internal styles are placed inside <style> tags in the head, while external stylesheets are linked with <link rel=’stylesheet’ href=’styles.css’>.
CSS用于美化元素。内联样式直接应用于标签，例如<p style=’color: blue;’>。内部样式放在<style>标签内，位于头部；外部样式表通过<link rel=’stylesheet’ href=’styles.css’>链接。
When asked to create a table, use <table>, <tr> (row), <th> (header cell) and <td> (data cell). Border and spacing can be controlled through attributes or CSS.
当被要求创建表格时，使用<table>、<tr>（行）、<th>（表头单元格）和<td>（数据单元格）。边框和间距可以通过属性或CSS控制。
6. Computer Hardware and Software | 计算机硬件与软件
Questions in this area test your knowledge of the processor, memory types and operating system functions. You should be able to describe the fetch‑execute cycle and compare RAM with ROM.
这部分问题考查你对处理器、内存类型和操作系统功能的理解。你应该能描述取指‑执行周期并比较RAM和ROM。
The central processing unit (CPU) fetches an instruction from memory, decodes it to determine what action to perform, and then executes the instruction. This cycle repeats billions of times per second, driven by a clock chip.
中央处理器(CPU)从内存中取出指令，解码以确定要执行的操作，然后执行指令。该循环由时钟芯片驱动，每秒重复数十亿次。
RAM (Random Access Memory) is volatile and holds data and programs currently in use. Its contents are lost when power is switched off. ROM (Read Only Memory) is non‑volatile and stores the boot firmware, such as the BIOS, that starts the computer.
RAM（随机存取存储器）是易失性的，保存当前正在使用的数据和程序，断电后内容丢失。ROM（只读存储器）是非易失性的，存储引导固件，如启动计算机的BIOS。
You may also be asked to list functions of an operating system: managing hardware resources (processor, memory, I/O devices), providing a user interface, handling file management and enforcing security policies. A modern OS also supports multitasking through time‑slicing.
你还可能被要求列出操作系统的功能：管理硬件资源（处理器、内存、输入输出设备），提供用户界面，处理文件管理和执行安全策略。现代操作系统还通过时间片轮转支持多任务。
7. Data Representation | 数据表示
Data representation questions often involve converting between binary and decimal, explaining ASCII and Unicode, and calculating file sizes for images and sound.
数据表示题常涉及二进制与十进制转换、解释ASCII与Unicode，以及计算图像和声音文件大小。
To convert the decimal number 150₁₀ to binary, subtract the largest powers of two: 150 = 128 + 16 + 4 + 2, which corresponds to 1×2⁷ + 0×2⁶ + 0×2⁵ + 1×2⁴ + 0×2³ + 1×2² + 1×2¹ + 0×2⁰. The binary representation is therefore 10010110₂.
要将十进制数150₁₀转换为二进制，依次减去最大的2的幂：150 = 128 + 16 + 4 + 2，对应1×2⁷ + 0×2⁶ + 0×2⁵ + 1×2⁴ + 0×2³ + 1×2² + 1×2¹ + 0×2⁰。因此二进制表示为10010110₂。
ASCII uses 7 bits to encode 128 characters, covering English letters, digits and symbols. Extended ASCII adds an extra bit to support 256 characters. Unicode is a superset that uses multiple bytes to represent characters from almost all writing systems, including emojis.
ASCII使用7位编码128个字符，包含英文字母、数字和符号。扩展ASCII增加一位以支持256个字符。Unicode是一个超集，使用多字节表示几乎所有书写系统的字符，包括表情符号。
For an image file size calculation, if an image has a resolution of 800 × 600 pixels and uses 24 bits per pixel for colour, the uncompressed size in bytes is (800 × 600 × 24) ÷ 8 = 1,440,000 bytes, or approximately 1.37 MiB.
图像文件大小计算：如果一张图像分辨率为800×600像素，每像素使用24位表示颜色，未压缩的字节数为(800 × 600 × 24) ÷ 8 = 1,440,000字节，约1.37 MiB。
8. Networks, Security and Legislation | 网络、安全与法律
The final section covers network types, network security measures and the key laws that affect computing. You need to be precise with terminology and give real‑world examples.
最后一部分涵盖网络类型、网络安全措施以及影响计算机的关键法律。你需要准确使用术语并给出实际例子。
A LAN (Local Area Network) covers a small geographical area and is usually owned and managed by a single organisation. A WAN (Wide Area Network) connects LANs over larger distances, often using public infrastructure like telephone lines or satellite links.
LAN（局域网）覆盖小范围地理区域，通常由单个组织拥有和管理。WAN（广域网）通过更长距离连接多个LAN，常使用公共基础设施，如电话线或卫星链路。
IP addresses uniquely identify devices on a network. IPv4 addresses are 32‑bit numbers written in dotted decimal (e.g. 192.168.1.10), while IPv6 uses 128 bits to support vast address space. DNS translates human‑readable domain names into IP addresses.
IP地址唯一标识网络上的设备。IPv4地址是32位数字，写成点分十进制形式（如192.168.1.10），而IPv6使用128位以支持巨大的地址空间。DNS将人类可读的域名转换为IP地址。
Firewalls monitor incoming and outgoing network traffic, blocking unauthorised access. Encryption scrambles data so that only authorised parties with a decryption key can read it. Symmetric encryption uses the same key for both encryption and decryption, while asymmetric encryption uses a public‑private key pair.
防火墙监控进出网络流量，阻止未授权访问。加密将数据加扰，只有持有解密密钥的授权方才能读取。对称加密使用相同的密钥进行加密和解密，而非对称加密使用公钥‑私钥对。
The Computer Misuse Act 1990 makes it illegal to gain unauthorised access to computer material, to commit further offences (such as fraud) after gaining access, or to impair the operation of a computer (e.g. through viruses). You should be able to name and describe these offences with scenarios.
《1990年计算机滥用法》规定未经授权访问计算机资料、在获取访问后实施进一步犯罪（如欺诈）或损害计算机操作（如通过病毒）是非法的。你应能结合情景描述这些罪行。
Strong password policies, two‑factor authentication and regular software updates are essential measures to protect data and systems from threats.
强密码策略、双因素认证和定期软件更新是保护数据和系统免受威胁的基本措施。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导