📚 IGCSE CCEA Computer Science: Past Paper Analysis & Revision Guide | IGCSE CCEA 计算机：历年真题深度解析与复习指南
Welcome to this comprehensive analysis of past paper questions for the CCEA IGCSE Computer Science specification. By examining real exam questions from previous years, this guide highlights recurring themes, common pitfalls, and effective strategies to boost your exam performance. Whether you are preparing for Paper 1 (Computer Systems) or Paper 2 (Programming and Logic), a focused review of past papers is essential for success.
欢迎阅读这篇针对 CCEA IGCSE 计算机科学历年真题的全面解析。通过分析往年真实考题，本指南提炼了高频考点、常见失分点和高效备考策略，帮助你提升考试成绩。无论你正在准备试卷一（计算机系统）还是试卷二（编程与逻辑），深入剖析历年真题都是取得成功的关键。
1. Understanding the Exam Paper Structure | 了解试卷结构
CCEA IGCSE Computer Science consists of two written papers. Paper 1 (Computer Systems) lasts 1 hour 30 minutes and assesses theory topics such as data representation, hardware, networks, and database concepts. Paper 2 (Programming and Logic) also lasts 1 hour 30 minutes and focuses on problem‑solving, algorithms, pseudocode, and logic circuits. Both papers include a mix of multiple‑choice, short‑answer, and extended‑response questions.
CCEA IGCSE 计算机科学包含两份笔试。试卷一（计算机系统）考试时间为1小时30分钟，考查数据表示、硬件、网络和数据库等理论知识。试卷二（编程与逻辑）同样时长1小时30分钟，重点考察问题解决、算法、伪代码和逻辑电路。两份试卷均包含选择题、简答题和拓展回答题。
Analysing past papers reveals that marks are often allocated for showing working steps, especially in calculations and SQL queries. The examiners reward structured answers that demonstrate intermediate steps rather than just the final answer. Practice using the exact command words such as ‘State’, ‘Describe’, ‘Explain’, and ‘Compare’ to tailor your response length and depth.
分析历年真题可以发现，分数往往分配给解题步骤，尤其是在计算和 SQL 查询中。考官更青睐能展示中间过程的结构化答案，而不仅仅是最终结果。练习时请准确使用’State’、’Describe’、’Explain’和’Compare’等指令词，以调整回答的篇幅和深度。
2. Data Representation & Number Bases | 数据表示与进制转换
Conversion between binary, denary, and hexadecimal is a guaranteed topic in Paper 1. A typical past paper question might ask you to convert the binary number 11010110 to hexadecimal. You need to split it into nibbles: 1101 (D) and 0110 (6), giving the answer D6. Always draw a conversion table if you find it helpful.
二进制、十进制与十六进制之间的转换是试卷一的必考内容。一道典型的真题可能要求你将二进制数 11010110 转换为十六进制。你需要将其拆分为半字节：1101（D）与 0110（6），得到答案 D6。若觉得有帮助，可以自行绘制转换表辅助。
Another frequent question involves calculating file sizes. For example, an image is 800 × 600 pixels with a colour depth of 24 bits. The raw file size in bytes = (800 × 600 × 24) ÷ 8. Remember that division by 8 converts bits to bytes, and you might need to express the result in KiB or MiB by further dividing by 1024.
另一种常见题型是计算文件大小。例如，一张分辨率为800×600像素、色深为24位的图像，其原始文件大小（字节）= (800 × 600 × 24) ÷ 8。务必记住除以8是将位转换为字节，若需要以 KiB 或 MiB 表示，应进一步除以 1024。
CCEA also asks about binary addition and overflow. Perform column addition just like in denary, carrying 1 to the next column when you add 1 + 1. Overflow occurs when the result exceeds the available bit width, and examiners expect you to identify the overflow flag.
CCEA 同样会考查二进制加法与溢出。与十进制加法类似，逐列相加，遇到 1 + 1 时向下一位进 1。当结果超出可用位宽时会发生溢出，考官希望你能够识别溢出标志。
3. Computer Hardware & System Architecture | 计算机硬件与系统架构
Past papers frequently test the fetch‑decode‑execute cycle. You should be able to describe the role of the Program Counter (PC), Memory Address Register (MAR), Memory Data Register (MDR), and Accumulator. For a ‘Describe’ question, outline each step clearly, mentioning how data moves between the CPU and main memory via the address bus and data bus.
历年真题经常考查取指−译码−执行周期。你需要能够描述程序计数器（PC）、存储器地址寄存器（MAR）、存储器数据寄存器（MDR）和累加器的作用。对于’Describe’类问题，需清晰概述每一步，并说明数据如何通过地址总线和数据总线在 CPU 与主存之间移动。
Questions on embedded systems ask you to compare general‑purpose computers with dedicated devices like washing machine controllers. Emphasise that embedded systems have firmware stored in ROM, limited resources, and real‑time constraints. Use specific examples from past papers, such as anti‑lock braking systems (ABS) in cars, to earn full marks.
关于嵌入式系统的题目要求你比较通用计算机与洗衣机控制器等专用设备。要强调嵌入式系统的固件存储在 ROM 中，资源有限，且具有实时性约束。使用真题中的具体实例，例如汽车的防抱死制动系统（ABS），能帮助你获得满分。
Solid‑state storage (SSD) versus magnetic hard disk drives (HDD) is another recurring theme. Prepare to explain advantages like faster data access and lower power consumption for SSDs, while noting that SSDs can have a limited number of write cycles.
固态存储（SSD）与磁性硬盘驱动器（HDD）的对比也是常考主题。请准备好解释 SSD 的优势，如更快的数据访问速度和更低功耗，同时也要指出 SSD 的写入次数有限。
4. Networks & Communication | 网络与通信
CCEA examiners love questions about network topologies. You might be given a scenario and asked to justify choosing a star topology over a bus topology. Explain that in a star network, each node has its own cable to a central switch, meaning a single cable failure only affects one node, whereas in a bus topology a backbone break can disable the whole network.
CCEA 考官偏爱网络拓扑的题目。你可能会遇到给定场景要求论证为何选择星型拓扑而非总线型拓扑。需要说明在星型网络中，每个节点有独立网线连接至中央交换机，单条线缆故障仅影响一个节点；而在总线型拓扑中，主干断裂会导致整个网络瘫痪。
Protocol knowledge is vital: understand the roles of HTTP, HTTPS, FTP, SMTP, and IMAP. Past questions often ask why HTTPS uses encryption (SSL/TLS) to protect data during online transactions. Use the term ‘encryption’ and mention that it prevents eavesdropping and data tampering.
协议知识至关重要：理解 HTTP、HTTPS、FTP、SMTP 和 IMAP 的作用。历年真题常问及为何 HTTPS 使用加密（SSL/TLS）来保护在线交易中的数据。回答时使用’加密’一词，并说明它可防止窃听和数据篡改。
Error detection methods like parity checks and checksums are also examined. Be able to calculate even and odd parity bits for 7‑bit data, and explain that a checksum is a calculated value sent with data; the receiver recalculates it to detect errors.
奇偶校验与校验和等错误检测方法同样会考查。你需要能够计算7位数据的偶校验位和奇校验位，并解释校验和是随数据一同发送的计算值，接收方重新计算以检测错误。
5. Databases & SQL Queries | 数据库与 SQL 查询
SQL questions are a staple of CCEA past papers. You will typically see a small table (e.g., Students with fields ID, Name, Year, Grade) and be asked to write queries using SELECT, FROM, WHERE, ORDER BY, and sometimes GROUP BY. For example: SELECT Name, Grade FROM Students WHERE Year = 11 ORDER BY Grade DESC;
SQL 查询题是 CCEA 真题的常客。你通常会看到一个小型表（例如包含字段 ID、Name、Year、Grade 的 Students 表），并被要求使用 SELECT、FROM、WHERE、ORDER BY 以及有时 GROUP BY 编写查询。例如：SELECT Name, Grade FROM Students WHERE Year = 11 ORDER BY Grade DESC;
Examiners expect you to handle wildcards with LIKE and use logical operators (AND, OR). A common trick is to ask for data from two criteria, e.g., ‘students in year 11 with a grade above 70’. Always check the table structure before writing your query to avoid mismatched field names.
考官希望你能够使用 LIKE 配合通配符，并运用逻辑运算符（AND、OR）。常见的陷阱是要求根据两个条件筛选数据，例如’年级11且成绩高于70的学生’。编写查询前务必检查表结构，避免字段名不匹配。
Beyond queries, you may need to describe the benefits of a relational database over a flat file. Focus on reduced data redundancy, data integrity enforced by primary/foreign keys, and easier data modification thanks to normalisation.
除查询外，你还可能需要描述关系数据库相较于平面文件的优势。重点强调数据冗余低、由主键/外键强制实施的数据完整性，以及规范化带来的更便捷的数据修改。
6. Programming Concepts & Algorithms | 编程概念与算法
Paper 2 heavily features pseudocode and trace tables. Past questions often give a fragment of pseudocode with a loop and an array, asking you to complete a trace table to show how variable values change at each iteration. Practice tracing line by line and updating the table systematically.
试卷二大量涉及伪代码和跟踪表。历年真题常给出一段带有循环和数组的伪代码，要求你补全跟踪表以展示每次迭代中变量值的变化。请练习逐行跟踪并系统地更新表格。
Sorting and searching algorithms appear regularly. You must be able to demonstrate a bubble sort on a small list, showing each pass and swap. For a binary search, explain that the list must be sorted first, then repeatedly divide the search interval in half.
排序与搜索算法定期出现。你必须能够对一个小型列表演示冒泡排序，展示每一趟和每一次交换。对于二分查找，需说明列表必须先排序，然后反复将查找区间减半。
Data type and validation questions are common. For instance, identify that a postcode should be stored as a string, not an integer, because it may contain letters and leading zeros. Length checks and range checks need to be linked to real‑world contexts in your answers.
数据类型与验证类的题目很常见。例如，要认识到邮政编码应存储为字符串而非整数，因为它可能包含字母和前导零。回答时需要将长度检查和范围检查与现实场景联系起来。
7. Software Development Life Cycle | 软件开发生命周期
CCEA expects you to recall the stages of the software development life cycle: analysis, design, implementation, testing, and maintenance. In a typical past paper, you might be given a scenario and asked to suggest what activities happen during the analysis phase, such as interviewing users and documenting requirements.
CCEA 要求你记住软件开发生命周期的各阶段：分析、设计、实现、测试和维护。在典型真题中，你可能会得到一个场景，并被要求提出分析阶段应开展哪些活动，例如用户访谈和需求文档化。
Testing strategies are a favorite topic. You need to differentiate between normal, boundary, and erroneous test data. For example, if a system accepts numbers 1–100, normal data would be 50, boundary data would be 1 and 100, and erroneous data would be 0 or 101. Always label your test cases clearly.
测试策略是热门主题。你需要区分正常、边界和异常测试数据。例如，若某系统接受数字1–100，正常数据可为50，边界数据为1和100，异常数据为0或101。务必清晰标注测试用例。
Be ready to evaluate the choice of a waterfall model versus an agile approach. A past paper might ask for one advantage of the waterfall model: it provides clear documentation at each stage, making it easier to manage in projects with fixed requirements.
准备好评价瀑布模型与敏捷方法的选择。真题可能会问瀑布模型的一个优点：它在每个阶段都提供清晰文档，便于在需求固定的项目中进行管理。
8. Computer Ethics & Legislation | 计算机伦理与法律
Ethical and legal questions appear in almost every Paper 1. You must know the key principles of the Data Protection Act (2018) and the Computer Misuse Act. A typical question asks what constitutes ‘unauthorised access’ under the Computer Misuse Act – accessing a system without permission, even if you do not alter data.
伦理与法律问题几乎出现在每份试卷一中。你必须掌握《数据保护法》（2018年）和《计算机滥用法》的关键原则。典型题目会问，《计算机滥用法》中何谓’未经授权访问’——即便未更改数据，只要未经许可访问系统即构成此行为。
Plagiarism and copyright are also tested. Explain that copying software without a licence is copyright infringement, and using someone else’s code in your project without attribution is plagiarism. Use the term ‘proprietary software’ and contrast it with open‑source licences such as MIT or GPL.
抄袭与版权同样会考查。要解释无许可证复制软件属于侵犯版权，而在项目中未注明出处使用他人代码即构成抄袭。使用’专有软件’这一术语，并与 MIT 或 GPL 等开源许可证进行对比。
Environmental impact questions link computing to e‑waste and energy consumption. Past papers may ask how data centres can reduce their carbon footprint, e.g., by using renewable energy or virtualisation to run multiple servers on one physical machine.
环境影响方面的题目将计算与电子垃圾和能耗联系起来。真题可能问及数据中心如何减少碳足迹，例如通过使用可再生能源或使用虚拟化在一台物理机上运行多个服务器。
9. Common Mistakes & Examiner Advice | 常见错误与考官建议
One of the most common mistakes is giving vague answers to ‘Explain’ questions. If asked to explain why ROM is used for bootstrapping, don’t just write ‘because it is non‑volatile’. Add that the instructions stored in ROM remain intact when power is off, so the computer can load the operating system on start‑up.
最常见的错误之一是在’Explain’类题目中给出模糊回答。若问及为何 ROM 用于启动引导，不要只写’因为它是非易失性的’。应补充说明 ROM 中存储的指令在断电后仍能保留，因此计算机在启动时可加载操作系统。
Another pitfall is ignoring command words: ‘State’ requires a brief, factual answer while ‘Compare’ needs both similarities and differences. A table is a great way to structure a compare answer and quickly show the examiner you have covered both sides.
另一个误区是忽略指令词：’State’要求简洁的事实性答案，而’Compare’则需要相似点与不同点。使用表格来组织比较类答案是一种极佳方式，能迅速向考官展示你已涵盖两个方面。
In programming questions, forgetting to initialise variables or not updating a counter inside a loop leads to incorrect trace tables. Always read the pseudocode carefully and assume no automatic initialisation unless explicitly given.
在编程题中，忘记初始化变量或未在循环内更新计数器会导致跟踪表错误。请始终仔细阅读伪代码，除非明确给出，否则不要假定存在自动初始化。
10. Revision Tips & Exam Strategy | 复习技巧与考试策略
Build a bank of past paper flashcards. For each topic, create a card with a question on one side and a bullet‑point answer on the other, directly referencing markscheme vocabulary. This habit will train you to use precise technical language that examiners expect.
建立一个历年真题闪卡库。每个主题准备一张闪卡，正面写问题，反面写项目符号式答案，并直接引用评分标准中的词汇。这个习惯将训练你使用考官所期望的精准技术语言。
Under exam conditions, allocate time based on marks: approximately one minute per mark. If a 6‑mark question on database design seems daunting, spend no more than six minutes. Outline your answer with key points first, then expand.
在考试条件下，根据分值分配时间：大约每分钟完成1分值的题目。若一道6分的数据库设计题看似困难，不要花超过6分钟。先列出答案要点提纲，再进行扩展。
Finally, practise writing SQL and pseudocode by hand, not just on a computer. Exam scripts show many candidates lose marks because of small syntax errors that they are used to having an IDE correct for them. Review past paper mark schemes to see exactly where partial marks are awarded.
最后，练习手写 SQL 和伪代码，而不仅仅是在计算机上编写。阅卷显示许多考生因微小语法错误而失分，而这些错误平日有 IDE 自动纠正。复习历年真题评分方案，弄清楚哪些地方会给分。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导Cancel reply