📚 Winter Intensive Revision Plan for SQA Computing Science | SQA计算机科学寒假强化复习计划
This four-week winter revision plan is designed to help Year 9 students consolidate their understanding of SQA Computing Science and build confidence ahead of the National 5 course. By focusing on key topics, practical programming, and past-paper techniques, you will transform holiday downtime into a powerful revision sprint.
这份为期四周的寒假复习计划旨在帮助九年级学生巩固 SQA 计算机科学知识，为进入 National 5 课程建立信心。通过聚焦核心专题、动手编程和真题演练，你将把假期碎片时间转化为高效复习冲刺。
1. Understanding the SQA Assessment Structure | 了解SQA评估结构
The National 5 Computing Science course is assessed through a question paper (110 marks, 2 hours) and a practical assignment (60 marks, 8 hours). The question paper covers Computer Systems, Software Design & Development, Database Design & Development, and Web Design & Development.
National 5 计算机科学课程通过笔试（110分，2小时）和课程作业（60分，8小时）进行评估。笔试卷涵盖计算机系统、软件设计与开发、数据库设计与开发以及网页设计与开发四大板块。
Understanding the weight of each area helps you allocate revision time wisely. For example, Software Design & Development often makes up around 40% of the paper, so it deserves a larger chunk of your schedule.
了解各部分的分值比重有助于合理分配复习时间。例如，软件设计与开发通常占卷面约40%，因此应该给予更多时间。
You should also become familiar with the command words used in exams, such as 'describe', 'explain', 'compare' and 'evaluate', as they determine the depth of answer required.
你还应熟悉考试中的指令词，如“描述”、“解释”、“比较”和“评价”，它们决定了答题所需深度。
2. Week 1: Revising Computer Systems | 第一周：复习计算机系统
Begin with a thorough review of the processor, memory and buses. Be able to describe the fetch-execute cycle in detail, including the roles of the program counter, memory address register, memory data register and accumulator.
首先要彻底复习处理器、存储器和总线。能够详细描述取指-执行周期，包括程序计数器、存储器地址寄存器、存储器数据寄存器和累加器的作用。
er that each hex digit represents four bits, which simplifies reading large binary strings.
接着复习数据表示：练习二进制、十进制和十六进制之间的转换。使用实例，如 1101₂ = 13₁₀ = D₁₆。记住每个十六进制数字代表四个位，简化大段二进制串的阅读。
Spend time on units of storage – bit, byte, kilobyte, megabyte, gigabyte, terabyte – and understand why a kilobyte is technically 1024 bytes in many contexts. Draw diagrams to illustrate addressability.
花时间学习存储单位——位、字节、千字节、兆字节、吉字节、太字节——并理解为什么在许多情况下1千字节实际上是1024字节。绘制示意图来说明寻址能力。
3. Week 1: Key Concepts – Data Representation & Computer Architecture | 第一周：关键概念——数据表示与计算机体系结构
Extend your data representation skills to include floating-point representation using mantissa and exponent. Practise calculating the range of numbers that can be stored given a certain number of bits for each component.
将你的数据表示能力拓展到使用尾数和指数的浮点表示法。练习计算在给定各组成部分的位数后所能存储的数字范围。
Study the differences between RISC and CISC processors, and learn about the graphics processing unit (GPU) and its parallel processing capabilities. Be ready to compare them in terms of cost, energy use and performance.
学习 RISC 与 CISC 处理器的区别，并了解图形处理器（GPU）及其并行处理能力。准备好从成本、能耗和性能方面进行比较。
Strengthen your knowledge of factors affecting system performance: clock speed, number of cores, cache size and memory bandwidth. Create a summary table to link each factor with its real-world effect.
巩固影响系统性能因素的知识：时钟频率、核心数量、缓存大小和内存带宽。制作总结表格，将每个因素与其现实影响联系起来。
4. Week 2: Software Design & Development Fundamentals | 第二周：软件设计与开发基础
Start by revisiting the software development process – analysis, design, implementation, testing, documentation and evaluation. Be able to apply these stages to a simple scenario, such as creating a calculator app.
首先回顾软件开发过程——分析、设计、实施、测试、文档编写和评估。能够将这些阶段应用于简单情境，例如创建一个计算器应用。
Focus on design notations: structure diagrams, flowcharts and pseudocode. Practise drawing a structure diagram for a program with at least three levels of hierarchy, and write pseudocode that includes detailed data flow.
重点学习设计符号：结构图、流程图和伪代码。练习为至少具有三层结构的程序绘制结构图，并编写包含详细数据流的伪代码。
Understand the importance of data types (integer, real, string, Boolean) and how to select the right one for a given variable. This will help you avoid logical errors in your practical assignment.
理解数据类型（整数、实数、字符串、布尔）的重要性以及如何为给定变量选择合适的类型。这将帮助你避免实践作业中的逻辑错误。
5. Week 2: Programming Constructs & Debugging | 第二周：编程结构与调试
Consolidate your ability to read and write code that uses sequence, selection (IF...THEN...ELSE) and iteration (FOR loops, WHILE loops). Pick a language you are comfortable with, such as Python or Visual Basic, and code short drills.
巩固你阅读和编写顺序、选择（IF...THEN...ELSE）和迭代（FOR 循环、WHILE 循环）代码的能力。选择你熟悉的语言，如 Python 或 Visual Basic，编写短小的练习程序。
Work with one-dimensional arrays: declare, initialise and traverse arrays to find maximum, minimum, total and average. Write traces to explain how an algorithm manipulates array elements line by line.
使用一维数组：声明、初始化和遍历数组以查找最大值、最小值、总和和平均值。编写追踪表，逐行解释算法如何操作数组元素。
Develop a debugging routine: read error messages carefully, use dry runs and add temporary output statements. The more bugs you deliberately fix during revision, the faster you will spot them under exam conditions.
培养调试习惯：仔细阅读错误信息，使用干运行并添加临时输出语句。复习过程中刻意修复的 bug 越多，考试时你就能越快发现它们。
6. Week 3: Database Design & SQL | 第三周：数据库设计与SQL
Begin database revision by understanding the principles of a relational database: tables, records, fields, primary keys and foreign keys. Draw entity-relationship diagrams to model simple situations, such as a library loan system.
开始数据库复习，理解关系型数据库的原理：表、记录、字段、主键和外键。绘制实体关系图来建模简单情境，如图书馆借阅系统。
Practise writing SQL queries that retrieve data using SELECT, FROM, WHERE, ORDER BY and aggregate functions such as COUNT, SUM and AVG. Always test your queries on sample data to confirm they return the expected results.
练习编写使用 SELECT、FROM、WHERE、ORDER BY 以及聚合函数（如 COUNT、SUM 和 AVG）检索数据的 SQL 查询。始终在样本数据上测试查询，以确认返回预期结果。
Learn how to insert, update and delete records, and understand the impact of referential integrity. When you delete a record that is referenced by a foreign key, the database behaviour depends on the defined rules, so this often appears in exam questions.
学习如何插入、更新和删除记录，并理解引用完整性的影响。当你删除一条被外键引用的记录时，数据库的行为取决于定义的规则，这常出现在考题中。
7. Week 3: Web Design & Development | 第三周：网页设计与开发
Review the basics of HTML: document structure, headings, paragraphs, lists, images and hyperlinks. Write a simple multi-page website by hand, ensuring all tags are correctly nested and closed.
复习 HTML 基础：文档结构、标题、段落、列表、图片和超链接。手写一个简单的多页面网站，确保所有标签正确嵌套和闭合。
Add internal and external CSS to control layout, colours and fonts. Understand the difference between ID and class selectors, and practise creating a consistent look across all pages using an external stylesheet.
添加内部和外部 CSS 以控制布局、颜色和字体。理解 ID 选择器与类选择器的区别，并练习使用外部样式表在所有页面创建一致的外观。
Discuss how JavaScript can be used for client-side interaction, such as form validation. Remember the key event handlers like onClick and onSubmit, and explain why user input must be validated on both client and server sides.
讨论如何使用 JavaScript 实现客户端交互，如表单验证。记住关键事件处理程序如 onClick 和 onSubmit，并解释为什么用户输入必须在客户端和服务器端都进行验证。
8. Week 4: Practice Assignments & Coursework Skills | 第四周：实践作业与课程技能
Now bring all the topics together by completing a mock assignment similar to the SQA coursework task. Choose a small problem – for example, a program that reads student marks and calculates grades – and follow the full software development cycle.
现在通过完成一个模拟 SQA 课程作业任务来整合所有主题。选择一个简单问题——例如，一个读取学生成绩并计算等级的程序——并遵循完整的软件开发周期。
Document your analysis, design, code, test plan and evaluation. Use screenshots and comments to explain your code. This habit will prepare you for the practical assignment, where clear documentation is worth significant marks.
记录你的分析、设计、代码、测试计划和评估。使用截图和注释解释代码。这一习惯将为实践作业做好准备，清晰的文件可获得可观的分数。
Ask a friend or family member to test your program and provide feedback. Iterative testing and refinement mirror real-world practice and will deepen your understanding of user-centred design.
请朋友或家人测试你的程序并提供反馈。迭代测试和优化反映了真实世界的实践，并将加深你对以用户为中心的设计的理解。
9. Week 4: Past Papers & Timed Practice | 第四周：历年真题与限时练习
Download past National 5 Computing Science question papers from the SQA website. Begin by working through them untimed, then gradually introduce a timer to simulate exam conditions.
从 SQA 网站下载历年 National 5 计算机科学真题。先不设时间完成，然后逐步引入计时，模拟考试环境。
After each paper, mark your answers using the official marking scheme. Identify areas where you lost marks and add them to a log; this helps you target weak spots in the final days of revision.
每做完一份卷子，使用官方评分方案批改。找出失分的地方并记录在日志中；这有助于你在复习的最后阶段针对薄弱环节。
Pay attention to questions that ask you to compare, evaluate or suggest improvements. These extended-response questions often differentiate between a good grade and an excellent one.
注意那些要求比较、评价或提出改进建议的题目。这些扩展回答题常常是区分好成绩与优秀成绩的关键。
10. Exam Technique & Time Management | 考试技巧与时间管理
In the question paper, read the whole question before writing. Allocate roughly one minute per mark: if a question is worth 4 marks, spend no more than 4–5 minutes on it. Move on if you get stuck and return later.
在笔试中，先完整阅读题目再作答。大约按每分钟1分的时间分配：如果一道题值4分，则用时不超过4-5分钟。若卡住就先跳过，之后再回来。
Use bullet points and diagrams where appropriate. A well-labelled diagram of a fetch-execute cycle or a network topology can express ideas quickly and often earns full marks more efficiently than paragraphs of text.
适当使用要点列表和图表。带标注的取指-执行周期图或网络拓扑图可以快速表达想法，通常比长篇文字更高效地获得满分。
For the assignment, keep a log of your progress. Decide in advance how many hours you will spend on each stage (analysis, design, implementation, testing) and stick to it so that you do not run out of time.
对于课程作业，记录进度日志。提前决定在每个阶段（分析、设计、实施、测试）花费的小时数并严格遵守，以免最后时间不够。
11. Self-Assessment & Progress Tracking | 自我评估与进度追踪
Create a revision grid with all the key topics and rate your confidence on a scale of 1 to 5 at the start and end of each week. This visual tracker keeps you motivated and highlights areas that need more attention.
制作一个复习网格，列出所有关键主题，并在每周开始和结束时用1-5分评估你的信心。这个可视化追踪器能保持你的动力并突出需要更多关注的领域。
Use active recall instead of passive re-reading: write short summaries, teach a concept to a family member, or record voice explanations. These techniques strengthen long-term memory more effectively.
使用主动回忆而非被动重读：写简短的摘要，向家人讲解某个概念，或录制语音解释。这些技巧能更有效地强化长期记忆。
After completing each topic, take a short, low-stakes quiz that you design yourself. Generating questions is itself a powerful revision tool, and your mistakes will point to gaps that can be quickly closed.
每完成一个专题，进行一次你设计的低风险小测验。出题本身就是有力的复习工具，你的错误会指出可以迅速弥补的漏洞。
12. Balancing Revision & Wellbeing | 复习与身心健康的平衡
Plan your day with clear blocks: 50 minutes of focused revision followed by a 10-minute break. Use breaks to move, hydrate and rest your eyes from screens. A well-rested brain absorbs information more efficiently.
将一天安排成清晰的块状：50分钟专注复习，接着10分钟休息。利用休息时间活动、补充水分并让眼睛从屏幕上休息。休息充分的大脑吸收信息更有效率。
Incorporate light exercise and social time into your schedule. Even a short walk outdoors can reset your concentration and reduce stress, making your revision more productive overall.
在日程中纳入轻度运动和社交时间。即使是短暂的户外散步也能重置注意力并减轻压力，使整体复习效率更高。
Keep this winter plan flexible. If you feel overwhelmed, adjust the pace – consolidation is more valuable than rushing through new material. Your goal is steady progress, not perfection.
让这个寒假计划保持灵活。如果你感到难以应对，就调整节奏——巩固比匆忙推进新内容更有价值。你的目标是稳步前进，而非追求完美。
Published by TutorHao | Computing Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图