📚 Year 9 SQA Computing Winter Intensive Revision Plan | Year 9 SQA 计算机寒假强化复习计划
Winter break offers Year 9 students a golden opportunity to reinforce their SQA Computing knowledge before the final push towards end-of-year assessments. This intensive revision plan is designed to help you cover key topics, practice essential skills, and build confidence. By following a structured daily approach, you can turn holiday downtime into a productive revision sprint without sacrificing relaxation.
寒假为 Year 9 学生提供了一个在期末冲刺前巩固 SQA 计算机知识的黄金时机。这份强化复习计划旨在帮助你覆盖重点主题、练习核心技能并建立信心。通过遵循结构化的每日安排，你可以在不牺牲休息的前提下，将假期空档转化为高效的复习冲刺。
1. Setting Goals and Creating a Timetable | 设定目标与制定时间表
Begin by listing the SQA topics you find most challenging, such as data representation or programming. Set realistic weekly goals—for example, completing two past paper questions each day and mastering one new concept. Map out a daily schedule that balances study sessions with breaks, sport, and family time.
首先列出你感到最困难的 SQA 主题，例如数据表示或编程。设定切实可行的每周目标——比如每天完成两道真题并掌握一个新概念。规划一份每日时间表，在学习、休息、运动和家庭时间之间取得平衡。
Use the sample timetable below as a starting point. Adjust it to fit your own rhythm, but try to study at the same time each day to build a habit.
以下面的样表为起点。按自己的节奏调整，但尽量每天在同一时间段学习以养成习惯。
| Time | Activity |
|---|---|
| 09:00 – 10:00 | Topic Review (e.g. Computer Systems) |
| 10:30 – 11:30 | Hands-on Practice (coding / SQL) |
| 14:00 – 15:00 | Past Paper Questions & Self-marking |
| 16:00 – 16:30 | Flashcard Review or Mind Map |
Keep your timetable visible and tick off each completed session—it gives a real sense of progress.
把时间表贴在显眼处，每完成一次就打勾——这会带来实实在在的进步感。
2. Computer Systems and Architecture | 计算机系统与架构
Refresh your understanding of the processor, memory, and storage hierarchy. Be able to explain the fetch-decode-execute cycle and the role of components such as the ALU, control unit, and registers. Know the difference between RAM and ROM, and why virtual memory is used.
重温你对处理器、内存和存储层次的理解。要能够解释取指-解码-执行周期以及 ALU、控制单元、寄存器等部件的作用。弄清 RAM 与 ROM 的区别，以及为什么需要虚拟内存。
Draw a simple CPU diagram from memory and label all key parts. Then summarise how clock speed, cache size, and number of cores affect performance. Test yourself with comparison tables for HDD vs SSD and volatile vs non-volatile storage.
凭记忆画一张简单的 CPU 示意图并标注所有关键部件。然后总结时钟速度、缓存大小和核心数量如何影响性能。用 HDD 与 SSD、易失性与非易失性存储器的对比表自测。
3. Data Representation | 数据表示
Binary, hexadecimal, and binary arithmetic form the backbone of many exam questions. Practise converting decimal numbers to 8-bit binary and hex, and back again. Work through addition of two 8-bit binary numbers, spotting overflow when the result exceeds 11111111₂.
二进制、十六进制和二进制运算是许多考题的支柱。练习将十进制数转换为 8 位二进制和十六进制，以及反向转换。完成两个 8 位二进制数的加法，当结果超出 11111111₂ 时识别溢出。
Understand how bitmap images are stored using pixels and colour depth. Calculate file sizes: image size = width × height × colour depth. Also cover how sound is sampled, linking bit depth and sample rate to quality and file size.
理解位图图像如何通过像素和颜色深度存储。计算文件大小：图像大小 = 宽 × 高 × 颜色深度。还要掌握声音的采样方式，将位深度和采样率与音质和文件大小联系起来。
File size (bytes) = (horizontal pixels × vertical pixels × bit depth) ÷ 8
Using real examples—such as an 800 × 600 image with 24-bit colour—helps fix the formulas in memory.
用实际例子——比如一张 800×600 的 24 位彩色图像——有助于牢记公式。
4. Algorithms and Computational Thinking | 算法与计算思维
Algorithms are expressed in pseudocode, flowcharts, or structured English. Revise sequence, selection (IF…THEN…ELSE), and iteration (FOR, WHILE). Practise tracing algorithms by hand to predict outputs and to spot logic errors.
算法用伪代码、流程图或结构化英语表达。复习顺序、选择（IF…THEN…ELSE）和迭代（FOR、WHILE）。动手跟踪算法以预测输出并找出逻辑错误。
Design algorithms for common tasks: linear search, counting occurrences, finding maximum/minimum. Draw the corresponding flowcharts using standard symbols and annotate each step.
为常见任务设计算法：线性搜索、计数出现次数、寻找最大/最小值。用标准符号画出对应的流程图并标注每一步。
-
Linear search: check each item in turn until a match is found or the list ends.
线性搜索：依次检查每个项目，直到找到匹配项或列表结束。
-
Counting: initialise a counter to 0 and increment it every time a condition is met.
计数：将计数器初始化为 0，每次满足条件时将计数器加 1。
5. Programming Fundamentals (Python) | 编程基础（Python）
Brush up on Python syntax: variables, data types (int, float, string, Boolean), input/output, and arithmetic operators. Write short programs that take user input, perform calculations, and display formatted output. Use comments to explain your logic.
温习 Python 语法：变量、数据类型（整型、浮点型、字符串、布尔型）、输入/输出以及算术运算符。编写接受用户输入、执行计算并显示格式化输出的短程序。使用注释解释逻辑。
Practise selection statements and loops. Build a simple number-guessing game that uses a while loop and gives hints (higher/lower). That single exercise combines input, conditionals, loops, and random numbers.
练习选择语句和循环。构建一个简单的猜数字游戏，使用 while 循环并给出提示（高了/低了）。这一个练习就结合了输入、条件、循环和随机数。
For each program, check indentation, variable scope, and logical errors. Keep a library of code snippets—especially for string manipulation, list operations, and basic algorithms—so you can revise them quickly before the exam.
对每个程序，检查缩进、变量作用域和逻辑错误。保存一个代码片段库——尤其是字符串处理、列表操作和基础算法的代码——以便考前快速复习。
6. Computer Networks and the Internet | 计算机网络与互联网
Explain the difference between LAN and WAN, and describe common network hardware: router, switch, hub, NIC, and wireless access point. Be able to outline the client-server and peer-to-peer models, giving examples of when each is used.
解释局域网（LAN）与广域网（WAN）的区别，描述常见网络硬件：路由器、交换机、集线器、网卡和无线接入点。能够概述客户-服务器和对等网络模型，并举例说明各自的应用场景。
Understand IP addressing, MAC addresses, and the role of protocols such as TCP/IP, HTTP, HTTPS, FTP, and SMTP. Create a simple diagram showing the layers of the TCP/IP model and what each layer does.
理解 IP 地址、MAC 地址以及 TCP/IP、HTTP、HTTPS、FTP、SMTP 等协议的作用。画一张简图展示 TCP/IP 模型的各层及其功能。
Network security topics, including firewalls and encryption, will be revisited later, but it is useful to connect them now. When you revise protocols, ask yourself: how does HTTPS protect data in transit?
包括防火墙和加密在内的网络安全主题将在后面再次复习，但现在就把它们联系起来也很有益。复习协议时，问问自己：HTTPS 如何保护传输中的数据？
7. Cybersecurity and Ethical Issues | 网络安全与伦理问题
Review common threats: malware (virus, worm, Trojan), phishing, DoS attacks, and social engineering. For each threat, know its mechanism and a practical defence method—for example, antivirus software, firewalls, and user education.
复习常见威胁：恶意软件（病毒、蠕虫、特洛伊木马）、网络钓鱼、DoS 攻击和社会工程学。对每种威胁，了解其机制和实际的防御方法——例如防病毒软件、防火墙和用户教育。
Encryption is a key tool. Describe symmetric and asymmetric encryption in simple terms, and explain how it ensures confidentiality. Revision card: “Encryption scrambles data using an algorithm and a key; only someone with the correct key can decrypt it.”
加密是一项关键工具。用简单语言描述对称和非对称加密，并解释如何确保机密性。复习卡片：”加密使用算法和密钥打乱数据；只有拥有正确密钥的人才能解密。”
Legal and ethical considerations include the Data Protection Act, Computer Misuse Act, and copyright. Prepare short definitions and link them to real-world scenarios, such as a company sharing customer data without consent.
法律和伦理方面的考虑包括《数据保护法》、《计算机滥用法》和版权。准备简短的定义，并将其与真实场景联系起来，例如公司在未获同意的情况下共享客户数据。
8. Database Design and SQL Queries | 数据库设计与 SQL 查询
Start with flat-file vs relational databases. Understand fields, records, tables, primary keys, and foreign keys. Explain why a relational database reduces data redundancy by linking tables through relationships.
从平面文件与关系型数据库的对比开始。理解字段、记录、表、主键和外键。解释为什么关系型数据库通过表之间的关系来减少数据冗余。
Practise writing SQL statements. The exam will expect you to use SELECT, FROM, WHERE, ORDER BY, and simple aggregate functions like COUNT and SUM. Write queries on a sample database—perhaps a school library or student grades—and check each result.
练习编写 SQL 语句。考试要求使用 SELECT、FROM、WHERE、ORDER BY 以及 COUNT、SUM 等简单的聚合函数。在一个样本数据库上编写查询——比如学校图书馆或学生成绩——并检查每个结果。
SELECT name, grade FROM Students WHERE grade > 70 ORDER BY grade DESC;
Try modifying the query to add a JOIN if you have learned it, but focus on straightforward queries first. Many marks are won by simply being able to filter and sort data correctly.
如果学过 JOIN，可以尝试修改查询来加上它，但先专注于基础查询。只要能够正确过滤和排序数据，就能拿到很多分数。
9. Web Technologies (HTML & CSS) | 网页技术（HTML & CSS）
Even at Year 9, you are expected to read and write simple HTML tags. Revise the structure of a web page: <!DOCTYPE html>, <html>, <head>, <title>, <body>. Understand tags for headings (<h1>–<h6>), paragraphs (<p>), links (<a>), images (<img>), and lists (<ul>, <ol>, <li>).
即使是 Year 9，你也需要会阅读和编写简单的 HTML 标签。复习网页的结构：<!DOCTYPE html>、<html>、<head>、<title>、<body>。了解用于标题（<h1>–<h6>）、段落（<p>）、链接（<a>）、图片（<img>）和列表（<ul>、<ol>、<li>）的标签。
Introduce CSS for styling: inline styles, internal style sheets, and external style sheets. Practise changing colours, fonts, and alignment. Create a small personal profile page from scratch—this is both a creative and a practical revision task.
引入 CSS 进行样式设计：内联样式、内部样式表和外部样式表。练习修改颜色、字体和对齐方式。从零开始创建一个简单的个人简介页面——这既是一项创意任务，也是实用的复习。
When revising, always check for missing closing tags and correct nesting. A single misplaced </div> can break a whole page layout, so develop a careful, methodical approach.
复习时，始终检查是否有遗漏的闭合标签以及嵌套是否正确。一个放错的 </div> 就可能破坏整个页面布局，因此要养成细致、有条理的习惯。
10. Software Development Process | 软件开发流程
The SQA often asks about the stages of software development: analysis, design, implementation, testing, documentation, and evaluation. For each stage, be ready to describe the main activities and typical outputs, such as a requirements specification or a test plan.
SQA 常考软件开发的各个阶段：分析、设计、实现、测试、文档编制和评价。对每个阶段，准备好描述主要活动和典型产物，比如需求规格说明书或测试计划。
Focus especially on testing: normal, boundary, and erroneous data. Design test tables that show test data, expected results, and actual results. Try applying this to a simple program you have written, and note the types of error that can occur—syntax, logic, and runtime.
特别关注测试：正常数据、边界数据和异常数据。设计测试表格，显示测试数据、预期结果和实际结果。试着将这一方法应用到你自己编写的简单程序上，并记录可能出现的错误类型——语法错误、逻辑错误和运行时错误。
Understanding the iterative nature of development is a powerful exam point. Describe how feedback from testing might lead back to the implementation or design stage, and why maintenance is inevitable after delivery.
理解开发的迭代特性是一个有力的得分点。描述测试反馈如何可能返回到实现或设计阶段，以及为什么交付后的维护不可避免。
11. Past Paper Practice and Exam Technique | 真题练习与考试技巧
Gather SQA past papers and specimen papers from the official website. Aim to complete at least two full papers under timed conditions during the holiday. Afterwards, use the marking schemes to mark your work strictly—note where you lost marks and why.
从官方网站收集 SQA 真题和样卷。假期期间争取在限时条件下完成至少两套完整的试卷。之后，严格对照评分方案给自己打分——记录失分点及原因。
Analyse command words: “State” requires a short fact, “Describe” asks for more detail, and “Explain” expects a reason. Practice writing answers that directly address the command word with the required depth.
分析指令词：”State” 要求简短的事实，”Describe” 要求更多细节，”Explain” 则期待给出原因。练习写出直接针对指令词且深度适当的答案。
Keep a “mistakes log” where you record topics that repeatedly trip you up. Use this log to guide your final revision days, zeroing in on weak spots rather than re-reading notes you already know.
建立一个”错误日志”，记录反复出错的主题。用这份日志指导最后几天的复习，集中攻克薄弱环节，而不是重读已经掌握的笔记。
12. Self-Assessment and Reflection | 自我评估与反思
At the end of each week, spend 20 minutes reflecting on what you have learned. Rate your confidence in each topic on a scale of 1-5. This data will show you where to focus next and confirm that your revision is paying off.
每周结束时，花 20 分钟反思所学内容。在每个主题上给自己打一个 1-5 的信心评分。这些数据会告诉你下一步的重点，并证实你的复习正在见效。
Share your learning with a friend or family member—explaining concepts aloud is one of the most effective ways to cement understanding. If you can teach something clearly, you truly know it.
与朋友或家人分享你的学习成果——大声解释概念是巩固理解最有效的方法之一。如果你能清晰地教会别人，说明你真正掌握了它。
Use your self-assessment to update your timetable. As your confidence grows, you can shorten some sessions and introduce more challenging extension tasks, such as writing larger programs or tackling Higher-level SQL queries.
利用自我评估来更新时间表。随着信心的增长，你可以缩短某些环节，引入更具挑战性的拓展任务，比如编写更复杂的程序或解决更高阶的 SQL 查询。
Finally, remember that rest is part of the plan. A well-rested brain retains information better, so stick to your scheduled breaks and enjoy the holiday spirit.
最后，请记住休息也是计划的一部分。充分休息的大脑能更好地记住信息，因此要坚持按计划休息，享受假期的氛围。
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课程辅导，国外大学本科硕士研究生博士课程论文辅导