Winter Intensive Revision Plan for SQA Computing | SQA 计算机寒假强化复习计划

📚 Winter Intensive Revision Plan for SQA Computing | SQA 计算机寒假强化复习计划

The winter break is the ideal time to consolidate your Computing Science knowledge and sharpen your skills ahead of the SQA assessments. A structured, five‑week plan ensures that every topic — from programming to databases — receives focused attention. This guide provides a day‑by‑day strategy tailored for Year 10 students working towards National 5 Computing Science.

寒假是巩固计算机科学知识、提升技能、为 SQA 评估做准备的黄金时期。一份结构清晰的五周复习计划能让你有条不紊地覆盖从编程到数据库的所有主题。本文为备战 National 5 Computing Science 的 Year 10 学生量身定制了每日强化复习策略。

---

1. Setting the Foundation: Review and Self‑Assessment | 夯实基础：回顾与自我评估

Before diving into intensive revision, spend two days reviewing your class notes and identifying your weak areas. Use the SQA course specification as a checklist to rate your confidence level for each topic on a scale of 1–5.

在进入强化复习之前，先花两天时间回顾课堂笔记，找出薄弱环节。以 SQA 课程大纲为清单，按 1–5 分对每个主题的自信心进行评分。

• Gather all materials: textbook, class jotters, past paper booklets, and online resources like Scholar or BBC Bitesize.
• 整理所有材料：教材、课堂笔记本、历年真题册以及 Scholar 或 BBC Bitesize 等在线资源。
• Create a simple tracker with columns for Topic, Confidence Level, and Action Needed.
• 制作一个简单的追踪表，包含主题、自信心等级和待办事项三列。

---

2. Programming Fundamentals with Python | 用 Python 打好编程基础

Programming underpins the entire course. Dedicate the first full week to writing, tracing, and debugging Python code. Focus on input/output, variables, data types, arithmetic operations, and conditional statements.

编程是整个课程的核心。第一周要专注于编写、追踪和调试 Python 代码，重点掌握输入输出、变量、数据类型、算术运算和条件语句。

• Practice converting between pseudocode and Python. The SQA uses a specific reference language — make sure you can read it fluently.
• 练习伪代码与 Python 之间的转换。SQA 使用特定的参考语言，务必确保能流利阅读。
• Work through small challenges: calculate the area of a circle, determine if a year is a leap year, or simulate a simple ATM menu.
• 完成小型编程挑战：计算圆面积、判断闰年、模拟简易 ATM 菜单。

Area = π × radius²

面积 = π × 半径²

---

3. Loops, Lists, and String Handling | 循环、列表与字符串处理

Move on to iterative structures: fixed loops (for) and conditional loops (while). Combine them with one‑dimensional arrays (lists) to store and manipulate multiple values.

接下来学习迭代结构：固定循环（for）和条件循环（while）。结合一维数组（列表）存储和操作多个值。

• Write programs that find the maximum, minimum, and average of a list of numbers.
• 编写程序，找出数字列表中的最大值、最小值和平均值。
• Use string methods to validate input — for example, checking that a postcode matches the pattern LLN NLL.
• 运用字符串方法验证输入——例如，检查邮政编码是否符合 LLN NLL 格式。
• Always desk‑check your code with a trace table before running it.
• 运行前务必用追踪表进行桌面检查。

---

4. Functions, Procedures, and Scope | 函数、过程与作用域

Modular programming is a key concept. Learn to design and call subprograms (functions and procedures) with parameters, and understand the difference between local and global variables.

模块化编程是核心概念。学会设计并调用带有参数的子程序（函数和过程），理解局部变量与全局变量的区别。

Subprogram Type	Returns a Value?	SQA Keyword
Function	Yes	FUNCTION
Procedure	No	PROCEDURE

Create a library of reusable functions — e.g., one that converts Celsius to Fahrenheit — and integrate them into larger programs.

建立可复用函数库，例如摄氏度转华氏度的函数，并将其集成到更大的程序中。

---

5. Computer System Architecture | 计算机系统结构

Shift your focus to hardware and software theory. Revise the fetch‑execute cycle, the role of the processor (ALU, Control Unit, registers), and the function of buses (data, address, control).

将注意力转向软硬件理论。复习取指–执行周期、处理器（ALU、控制单元、寄存器）的角色，以及总线（数据总线、地址总线、控制总线）的功能。

• Draw a labelled diagram of the CPU and explain how instructions are processed.
• 绘制带标签的 CPU 示意图，并解释指令的处理过程。
• Compare embedded, desktop, and server systems in terms of performance, power consumption, and cost.
• 从性能、功耗和成本角度比较嵌入式系统、桌面系统和服务器系统。

---

6. Data Representation and Storage | 数据表示与存储

Confidence with binary, hexadecimal, and character encoding is essential. Practice conversions between denary, binary (up to 16‑bit), and hex, and review how ASCII and Unicode represent text.

掌握二进制、十六进制和字符编码至关重要。练习十进制、二进制（最高 16 位）和十六进制之间的转换，并复习 ASCII 与 Unicode 如何表示文本。

Denary 210₁₀ → Binary 11010010₂ → Hex D2₁₆

十进制 210₁₀ → 二进制 11010010₂ → 十六进制 D2₁₆

• Explain why vector graphics are scalable while bit‑mapped graphics become pixelated. Link this to storage calculations.
• 解释为何矢量图形可缩放而位图会像素化，并将此与存储计算联系起来。
• zes: image resolution × colour depth, sound sample rate × bit depth × duration × channels.
• 计算文件大小：图像分辨率 × 颜色深度；声音采样率 × 位深度 × 时长 × 声道数。

---

广告 / Sponsored

7. Databases and SQL | 数据库与结构化查询语言

Spend two days on database concepts: tables, records, fields, primary and foreign keys. Write SQL queries using SELECT, FROM, WHERE, ORDER BY, and aggregate functions like COUNT, SUM, and AVG.

花两天时间学习数据库概念：表、记录、字段、主键与外键。使用 SELECT、FROM、WHERE、ORDER BY 以及 COUNT、SUM、AVG 等聚合函数编写 SQL 查询。

• Given two related tables Customer and Order, write queries to find all orders placed after a certain date, or the total spent by each customer.
• 给定 Customer 和 Order 两张关联表，编写查询找出某日期之后的所有订单，或每位顾客的总消费额。
• Understand the importance of avoiding data redundancy and the benefits of a relational database.
• 理解避免数据冗余的重要性及关系数据库的优势。

---

8. Networks, Protocols, and Security | 网络、协议与安全

Cover network types (LAN, WAN, the Internet), transmission media (copper, fibre, wireless), and the client‑server model. Memorise the purpose of common protocols: HTTP, HTTPS, FTP, SMTP, POP3, and TCP/IP.

涵盖网络类型（局域网、广域网、互联网）、传输介质（铜缆、光纤、无线）以及客户–服务器模型。熟记常见协议的作用：HTTP、HTTPS、FTP、SMTP、POP3、TCP/IP。

• Compare peer‑to‑peer and client‑server networks, listing advantages and disadvantages.
• 比较对等网络与客户–服务器网络，列出各自的优缺点。
• Describe how encryption, firewalls, and two‑factor authentication protect data.
• 描述加密、防火墙和双因素认证如何保护数据。
• Explain the consequences of a data breach under UK GDPR regulations.
• 解释在 UK GDPR 法规下数据泄露的后果。

---

9. Web Design and Development | 网页设计与开发

Review HTML basics: tags for headings, paragraphs, images, hyperlinks, and lists. Know how CSS is used to separate content from presentation, and be able to read simple CSS rules.

复习 HTML 基础：标题、段落、图像、超链接和列表标签。了解如何使用 CSS 将内容与表现分离，并能阅读简单的 CSS 规则。

• Write a short HTML document that includes an external CSS file and demonstrates inline, internal, and external style application.
• 编写一份简短的 HTML 文档，引入外部 CSS 文件，并展示内联、内部和外部样式的应用。
• Understand the importance of accessibility: use of alt text, semantic tags, and responsive design principles.
• 理解无障碍访问的重要性：替代文本、语义化标签和响应式设计原则。

---

10. Software Development Process | 软件开发流程

Analysis, Design, Implementation, Testing, Documentation, Evaluation — the SQA software development cycle must be second nature. Practice applying it to a real‑world scenario, such as designing a mobile app for a school library.

分析、设计、实现、测试、文档、评估——SQA 软件开发周期必须成为你的第二本能。结合真实场景进行练习，例如为一所学校图书馆设计移动应用。

• From a given problem description, produce a requirements specification, a simple pseudocode design, and a test plan.
• 根据问题描述，撰写需求规格说明书、简单的伪代码设计和测试计划。
• Explain the difference between alpha testing (by developers) and beta testing (by end users), and the role of maintenance after release.
• 说明内部测试（由开发者进行）与公开测试（由最终用户进行）的区别，以及发布后维护的作用。

---

11. Past Paper Sprint and Time Management | 真题冲刺与时间管理

In the final week, complete at least three full past papers under timed conditions. Allocate 60 minutes for the written paper and 90 minutes for the practical assignment model, if applicable. Mark your work using the official SQA marking instructions.

在最后一周，至少限时完成三套完整的历年真题。书面试卷限时 60 分钟，实践任务模型（如适用）限时 90 分钟。使用 SQA 官方评分标准批改自己的作业。

• Identify recurring question patterns: data‑flow questions, SQL from an ER diagram, or a trace‑table question with nested loops.
• 识别反复出现的题型：数据流题、根据实体关系图写 SQL 的题、含嵌套循环的追踪表题。
• Build a “mistake log”: for each error, write the correct concept next to it and review daily.
• 建立“错误日志”：针对每个错误，在旁记录正确概念并每日回顾。

---

12. Final Review, Wellbeing, and Exam Day Strategy | 终期回顾、身心健康与考试策略

Reserve the last two days for light review, not new content. Revisit your mistake log, run through key algorithms, and organise your equipment. Prioritise sleep, nutrition, and relaxation to peak on exam day.

最后两天留给轻松回顾，而非学习新内容。重温错误日志，过一遍关键算法，整理好考试用具。保证睡眠、营养和放松，以在考试当天达到最佳状态。

• On the exam day, read every question twice. For programming questions, plan your solution in pseudocode before writing final code.
• 考试当天，每题读两遍。编程题先在伪代码中规划方案，再写最终代码。
• Manage your time: spend no longer than 1.5 minutes per mark. If stuck, move on and return later.
• 合理分配时间：每分值不超过 1.5 分钟。卡住时先行跳过，稍后再回看。

Published by TutorHao | Computing Science Revision Series | aleveler.com

更多咨询请联系16621398022（同微信）