📚 Year 11 CIE Computer Science: Winter Intensive Revision Plan | Year 11 CIE 计算机科学：寒假强化复习计划
The winter holiday is a crucial window for Year 11 students to consolidate their understanding of the CIE IGCSE Computer Science syllabus. A structured, topic‑focused revision plan during this break can transform scattered knowledge into exam‑ready confidence. This guide breaks down a fifteen‑day intensive programme covering the core theory of Paper 1, essential problem‑solving skills for Paper 2, and effective study techniques to maximise your grade.
寒假是 Year 11 学生系统巩固 CIE IGCSE 计算机科学知识的黄金窗口期。一份结构清晰、紧扣考纲的假期复习计划能把零散的知识点转化为应试的底气。本文提供一份为期十五天的强化方案，覆盖试卷一的核心理论、试卷二所必需的算法与编程思维，以及帮助你高效提分的复习策略。
1. Build Your 15‑Day Battle Plan | 制定你的十五天作战计划
Start by printing the CIE 0478/0984 syllabus and highlight the topics you find most challenging. Divide the holiday into three phases: Days 1–5 for data representation, hardware, software, and networks; Days 6–10 for databases, Boolean logic, security, and ethics; Days 11–15 for algorithm tracing, pseudocode, and programming practice. Each day, allocate 2–3 hours to focused theory revision and 1 hour to past paper questions.
先将 CIE 0478/0984 的考纲打印出来，用荧光笔标出自己最薄弱的知识点。把假期划分为三个阶段：第 1–5 天专攻数据表示、硬件、软件和网络；第 6–10 天攻克数据库、布尔逻辑、安全与道德伦理；第 11–15 天重点训练算法跟踪、伪代码和编程实践。每天安排 2–3 小时专注理论复习，再用 1 小时刷真题。
Create a weekly overview table on your wall. Tick off each subtopic as you master it. Keep a “mistake log” where you record errors from past papers and the corrected reasoning. This visual progress tracker reduces anxiety and keeps motivation high.
在墙上贴一张周计划总表，每掌握一个子主题就打勾。准备一个“错题本”，记录以往真题中的错误和正确的分析过程。这种可视化的进度追踪既能缓解焦虑，又能保持复习动力。
2. Master Data Representation | 吃透数据表示
n of Paper 1. Focus on converting between binary, denary, and hexadecimal using both place‑ u can mentally convert numbers up to 2⁸ without hesitation. Remember that hexadecimal is a shorthand for binary; group bits in fours from the right.
数据表示在试卷一中占比较大，务必熟练掌握二进制、十进制和十六进制之间的转换。使用位值法和重复除以基数法双向练习，比如 1101₂ = 1×2³ + 1×2² + 0×2¹ + 1×2⁰ = 13₁₀ = D₁₆。一直练到能心算 2⁸ 以内的数值。始终记住十六进制是二进制的简写：每四位二进制位合成一个十六进制数字。
Two’s complement representation for negative numbers is a common exam pitfall. Practise both the “flip‑the‑bits‑and‑add‑one” rule and the alternative method of writing −N as 2ⁿ − N. Also review binary addition, overflow conditions, and logical shifts. Spend one afternoon solving all the two’s complement problems from 2019–2023 past papers.
补码表示负数是最常见的失分点。既要练熟“按位取反加一”的口诀，也要会用 2ⁿ − N 构造补码。还需复习二进制加法、溢出条件和逻辑移位运算。专门抽一个下午把 2019–2023 年真题中所有补码问题重做一遍。
| Denary | 8‑bit two’s complement | Hexadecimal |
| −32 | 1110 0000 | E0₁₆ |
| −1 | 1111 1111 | FF₁₆ |
| +127 | 0111 1111 | 7F₁₆ |
3. Tackle Hardware and Storage Like an Engineer | 像工程师一样攻克硬件与存储
Your revision must move beyond simple definitions. Draw and label the von Neumann architecture, explaining how the program counter, MAR, MDR, CIR, and accumulator interact during the fetch‑decode‑execute cycle. Write a short narrative for each step — for instance, the address in the PC is copied to the MAR, the instruction is fetched from RAM into the MDR, and so on. Tests often ask you to describe the cycle in words.
复习硬件绝不能停留在背定义。亲手画出并标注冯·诺依曼体系结构，解释程序计数器、MAR、MDR、CIR 和累加器在取指‑解码‑执行周期中如何协同工作。为每一步写出叙事性描述，例如 PC 中的地址被复制到 MAR，指令从 RAM 取出放入 MDR 等。考试常常要求你用文字描述该周期。
Storage devices appear in exam questions that compare magnetic, optical, and solid‑state technologies. Create a table listing capacity, access speed, portability, durability, and cost per gigabyte. Relate each device to a real‑world scenario: why a data centre uses magnetic HDDs for archiving while tablets use NAND flash storage. Practise “describe three differences” style questions until your answers are concise and use precise technical vocabulary.
存储设备常以对比题出现。自制表格整理磁、光、固态存储的容量、存取速度、便携性、耐久度和每 GB 成本。给每种设备配一个真实使用场景：为什么数据中心用机械硬盘归档，而平板电脑采用 NAND 闪存。反复练习“请描述三点差异”类题型，使答案简洁且术语精准。
4. Connect the Concepts: Networks and Cyber Security | 串联概念：网络与网络安全
Draw a full network topology diagram every day, labelling switch, router, NIC, WAP, and transmission media. Use your diagram to explain packet switching: how data is broken into packets, how each packet carries a header with source and destination IP addresses, and how routers use routing tables to forward packets independently. Link this to the structure of an IPv4 address and the need for MAC addresses on a local segment.
每天默画一次完整的网络拓扑图，标注交换机、路由器、网卡、无线接入点和传输介质。借助图示讲解分组交换：数据如何拆成数据包，每个包如何携带含有源与目标 IP 地址的首部，以及路由器如何利用路由表独立转发数据包。把这一切与 IPv4 地址结构、局域网段内 MAC 地址的作用串联起来。
Security is not just a list of threats; it is a cause‑and‑effect map. For each threat (malware, phishing, brute‑force attack, SQL injection, DDoS), explain the mechanism, the vulnerability it exploits, and a specific prevention strategy. Use the exam‑friendly format: “A DDoS attack floods a server with traffic, preventing legitimate access; this can be mitigated by a firewall with rate‑limiting rules.” Practise writing such sentences until they become automatic.
安全不是一张威胁清单，而是一张因果图。针对每种威胁（恶意软件、钓鱼、暴力破解、SQL 注入、DDoS），解释其作用机理、利用的漏洞以及一种具体的防范策略。采用考试青睐的句式：“DDoS 攻击通过大量流量淹没服务器，阻止合法访问；可通过配置限速规则的防火墙来缓解。”反复书写这类句子，直到形成肌肉记忆。
5. Dream in Databases and SQL | 在数据库与 SQL 的世界里做梦
Database questions reward precision. Practise defining flat‑file vs. relational databases, primary keys, foreign keys, and the purpose of normalisation. For SQL, train yourself to write SELECT … FROM … WHERE … ORDER BY … queries from a scenario description. Use the correct wildcard (%) and logical operators (AND, OR, NOT). A typical exam task: “List the names of students born after 2009 whose grade is A.” Your response: SELECT StudentName FROM Students WHERE BirthYear > 2009 AND Grade = 'A';
数据库题目奖励精确。练习定义平面文件与关系数据库、主键、外键以及规范化的目的。对于 SQL，训练自己根据场景描述写出 SELECT … FROM … WHERE … ORDER BY … 语句，正确使用通配符 (%) 和逻辑运算符 (AND, OR, NOT)。一道典型考题：“列出 2009 年后出生且成绩为 A 的学生姓名。”你的答案应为：SELECT StudentName FROM Students WHERE BirthYear > 2009 AND Grade = 'A';
Don’t forget data types (INTEGER, VARCHAR, DATE, BOOLEAN) and the validation/verification distinction. Design a small table on paper and test at least four types of validation rules: length check, range check, format check, and presence check. Explain why two different input operators entering the same email is a verification step, not validation.
别忘了字段数据类型（INTEGER, VARCHAR, DATE, BOOLEAN）以及验证与校验的区别。在纸上设计一张小表，实测至少四种验证规则：长度检查、范围检查、格式检查和存在检查。清楚解释为什么两位录入员输入同一邮箱属于校验而非验证。
6. Boolean Logic and Truth Tables Without Fear | 无惧布尔逻辑与真值表
Logic gates appear in both Paper 1 and the pre‑ onal circuits: given a logic expression such as Q = (A AND B) OR (NOT C), build the truth table column by column. Create a workbook page where you solve ten increasingly complex circuits in one sitting.
逻辑门既出现在试卷一也出现在考前资料任务中。必须能够瞬间画出门 AND, OR, NOT, NAND, NOR, XOR 的符号，并默写其真值表。进而挑战组合逻辑电路：给定表达式如 Q = (A AND B) OR (NOT C)，逐列构建真值表。专门整理一页练习册，一次性攻克十道由简至繁的电路题。
Link logic statements to real sensors: a car’s engine warning light activates when (temperature > 100 °C) AND (oil pressure < 1.5 bar). Write this as a logic expression, draw the circuit, and list the truth table. CIE examiners love these context‑based questions. Discuss how NAND gates can be used to build any other gate — a concept often probed in essay‑type questions.
把逻辑语句与真实传感器联系起来：当（温度 > 100 °C）且（油压 < 1.5 bar）时，汽车发动机告警灯点亮。把这句话写成逻辑表达式、画出电路并列出真值表。CIE 考官非常偏爱这种情境题。同时讨论怎样用 NAND 门构建其他所有门——这是论述题常考的深层概念。
7. Algorithm Design: Trace Tables and Pseudocode as a Second Language | 算法设计：把跟踪表和伪代码变成第二语言
Paper 2 demands that you think algorithmically. Print a set of pseudocode scripts containing loops (FOR, WHILE, REPEAT…UNTIL), selection (IF…THEN…ELSE…ENDIF), and array operations. Practice completing trace tables for scripts with nested loops. For each iteration, update every variable’s value; examiners penalise partial or incomplete traces. Use a clean grid layout: one row per pass, columns for each variable and output.
试卷二要求你用算法思维去思考。打印一组包含循环（FOR, WHILE, REPEAT…UNTIL）、选择（IF…THEN…ELSE…ENDIF）和数组操作的伪代码脚本。反复练习为嵌套循环脚本填写跟踪表。在每一次迭代中，更新所有变量的值；考官会扣罚不完整或遗漏的跟踪。用整洁的网格布局：每次循环一行，每列一个变量和输出。
Beyond tracing, you must write your own pseudocode. Solve five past paper tasks where you are given a problem statement and must design an algorithm. Use consistent indentation and CIE‑preferred syntax: INPUT, OUTPUT, CASE OF. Test your pseudocode by stepping through it mentally with three data sets: normal, boundary, and erroneous. This mirrors the validation process you revised earlier.
除了跟踪，你必须亲自写伪代码。挑选五道真题任务，根据问题陈述设计算法。务必保持缩进一致，使用 CIE 推荐的语法：INPUT, OUTPUT, CASE OF。通过用正常、边界和错误三组数据在脑中逐步运行来测试你的伪代码，这与你前面复习的验证流程一脉相承。
8. Programming: Turn Theory into Code | 编程：把理论变成代码
Whether you are preparing with Python, Java, or Visual Basic, the holiday is the time to polish your coding fluency. Re‑implement all the standard algorithms: linear search, binary search, bubble sort, and counting occurrences. Focus on the boundary conditions — what happens when the list is empty? When the target is at the very first or last position? Write each algorithm without referring to notes, then test it on a computer.
无论你选的是 Python、Java 还是 Visual Basic，寒假正是打磨编程流畅度的良机。重新实现所有标准算法：线性搜索、二分查找、冒泡排序和计数出现次数。关注边界条件——列表为空时怎么办？目标元素恰好在首端或尾端时如何处理？先脱稿写出每个算法，再上机测试。
CIE pre‑release materials demand that you read and modify code. Take last year’s pre‑release task and extend it: add a new function, alter the menu, or introduce file handling. Comment every block to explain your logic. This not only prepares you for the real pre‑release but also trains you to read unfamiliar code — a skill tested directly in Paper 2.
CIE 考前任务材料要求你能阅读并修改代码。找出去年的考前任务，试着扩展它：新增一个函数，改动菜单，或引入文件处理。给每一块代码添加注释来解释你的逻辑。这不仅直接对接真正的考前材料，更训练你阅读陌生代码的能力——这对试卷二而言是一项核心技能。
9. Mock Exams Under Pressure | 在压力下进行模拟考试
Set aside two full mornings to complete a Paper 1 and Paper 2 under exam conditions. Use a timer, silence your phone, and sit at a desk with only permitted materials. Afterwards, mark your answers against the official mark scheme, paying close attention to how marks are awarded — CIE often requires a specific keyword or a step‑by‑step description. Adjust your revision plan based on the topics where you lost the most marks.
抽出两个完整的上午，在严格的考试条件下完成一份试卷一和试卷二。计时、关手机、只携带允许的材料。考后对照官方评分标准批改，格外留意分值是如何授予的——CIE 常常要求出现特定的关键词或分步描述。根据失分最多的主题调整后续复习计划。
After the mock, build a “top‑ten mistakes” list and recite it every morning. For example: “I forgot to invert the bits before adding 1 for two’s complement subtraction; I confused validation with verification; I omitted semicolons in my SQL statements.” This ritualistic reinforcement transforms fragile understanding into permanent memory.
模拟考后制作一份“十大常犯错误”清单，每天清晨朗诵一遍。例如：“我忘记了做减法补码时先取反再加一；我把验证与校验搞混了；我在 SQL 语句里遗漏了分号。”这种仪式化的强化能把脆弱的知识点变成永久记忆。
10. Revision Techniques That Boost Long‑Term Retention | 提升长期记忆的复习技巧
Active recall beats passive reading every time. After studying a topic, close the book and write down everything you remember on a blank sheet — definitions, diagrams, and example questions. Then check for accuracy. This “brain‑dump” method creates stronger neural pathways. Combine it with spaced repetition: revisit the same topic after one day, three days, and seven days.
主动回忆永远比被动阅读有效。每复习完一个主题，合上书，在一张白纸上写下你记住的所有内容——定义、图表和例题。然后再核对准确性。这种“大脑倾倒”法能建立更强的神经通路。结合间隔重复：在 1 天、3 天和 7 天后再次回顾同一主题。
Teach a topic to a peer or record yourself explaining a concept like the fetch‑execute cycle on your phone. If you stumble, that’s a signal to re‑study. Use mnemonics for slippery details: “George’s Two’s Complement: Invert and Add One.” For the OSI or TCP/IP layers, create a silly sentence. The winter break gives you the time to embed these strategies deeply.
把某个主题教给同伴，或者用手机录一段自己讲解取指‑执行周期的视频。如果有卡顿，那就说明需要重新学习。为易混淆的细节设计口诀：“补码转换——先反后加一”。对于 TCP/IP 协议栈，编一句荒唐的顺口溜。寒假给了你足够的时间把这些策略内化。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图