Year 11 SQA Computing: Winter Intensive Revision Plan | SQA 计算机：寒假强化复习计划

📚 Year 11 SQA Computing: Winter Intensive Revision Plan | SQA 计算机：寒假强化复习计划

Winter break offers a golden window to consolidate your knowledge and sharpen exam skills for SQA National 5 Computing Science. A well-structured intensive revision plan can transform passive holiday time into an active learning sprint, ensuring you return to school confident and ready to tackle any exam question. This plan is designed to cover all four key areas—Computer Systems, Software Design and Development, Database Design and Development, and Web Design and Development—while building the problem-solving mindset required for the assignment and the final paper.

寒假是巩固 SQA National 5 计算机科学知识、打磨考试技能的黄金窗口期。一份结构清晰的强化复习计划能把被动的假期时间转变为主动的学习冲刺，让你返校时充满信心，从容应对任何考题。本计划覆盖四大知识模块——计算机系统、软件设计与开发、数据库设计与开发、网页设计与开发，同时培养完成课程作业和期末考试所需的解题思维。

1. Setting Your Revision Timetable | 制定你的复习时间表

Begin by blocking out 2–3 hours of focused revision each weekday, leaving weekends for light review and rest. Divide each session into three 40-minute slots with short breaks in between, and assign a specific topic to each slot. For example, Monday could be Computer Systems theory, Tuesday software design and pseudocode, Wednesday database normalisation and SQL, Thursday HTML/CSS and Friday practice questions. Rotate topics to keep your brain engaged and avoid burnout.

首先，把每个工作日 2–3 小时的专注复习时间固定下来，周末留给轻松回顾和休息。把每次学习分成三个 40 分钟的时间段，中间穿插短暂休息，并为每个时段指定一个具体主题。例如，周一复习计算机系统理论，周二软件设计和伪代码，周三数据库规范化与 SQL，周四 HTML/CSS，周五做真题。交替安排主题，让大脑保持投入，避免疲劳。

2. Computer Systems: Data Representation | 计算机系统：数据表示

Start with the binary number system, denary-to-binary conversion, and binary addition. You must be able to describe floating-point representation (mantissa and exponent) at National 5 level, though calculations are more conceptual. Practise converting positive and negative integers using two’s complement. Also revise ASCII, extended ASCII, and Unicode, focusing on the relationship between character sets and storage bits.

从二进制数系统、十进制与二进制的转换和二进制加法开始。National 5 要求能够描述浮点表示法（尾数和指数），不过计算更偏概念。练习使用补码（two’s complement）转换正负整数。同时复习 ASCII、扩展 ASCII 和 Unicode，重点掌握字符集与存储位数之间的关系。

Example: 8-bit two’s complement of -13: invert 00001101 → 11110010, add 1 → 11110011

示例：-13 的 8 位补码：将 00001101 取反 → 11110010，加 1 → 11110011

3. Computer Systems: Hardware and Processor | 计算机系统：硬件与处理器

Draw and label the basic structure of a computer system: input, output, backing storage, and the processor. Inside the processor, be able to explain the roles of the control unit, ALU, and registers such as the program counter, instruction register, and accumulator. Understand the fetch-execute cycle in clear steps and be prepared to describe how clock speed, number of cores, and cache memory affect performance.

绘制并标注计算机系统的基本结构：输入、输出、后备存储器和处理器。处理器内部要能解释控制单元、ALU 以及程序计数器、指令寄存器和累加器等寄存器的作用。理解取指-执行周期的清晰步骤，并准备好说明时钟速度、核心数量和缓存内存如何影响性能。

Component	Function
Control Unit	Directs the operation of the processor
ALU	Carries out arithmetic and logical operations
Cache	High-speed memory inside the processor

部件 / 功能：控制单元——指挥处理器运行；ALU——执行算术和逻辑运算；缓存——处理器内部的高速存储器。

4. Computer Systems: Software and Security | 计算机系统：软件与安全

Classify software into system software (operating system, utility programs) and application software (word processor, web browser). Explain file management, memory management, and the role of the OS in providing a user interface. For security, cover threats such as malware, phishing, and brute-force attacks, alongside defences like firewalls, encryption, and strong password policies. Be able to discuss the principles of the Data Protection Act and computer misuse legislation.

将软件分为系统软件（操作系统、实用程序）和应用软件（文字处理、网页浏览器）。说明文件管理、内存管理以及操作系统在提供用户界面方面的作用。安全方面覆盖恶意软件、钓鱼攻击和暴力破解等威胁，以及防火墙、加密和强密码策略等防御措施。要能讨论《数据保护法》和计算机滥用的立法原则。

5. Software Design: Pseudocode and Flowcharts | 软件设计：伪代码与流程图

Revision must focus on reading and writing pseudocode for input, output, assignment, conditional statements (IF…ELSE), and loops (fixed FOR, conditional WHILE). You should also translate short scenarios into flowcharts using standard symbols: rectangle for process, diamond for decision, parallelogram for input/output. Practise desk-check tracing to find logic errors.

复习必须集中在读写用于输入、输出、赋值、条件语句（IF…ELSE）和循环（固定 FOR 循环、条件 WHILE 循环）的伪代码。你还应使用标准符号将简短场景转化成流程图：矩形表示处理，菱形表示判断，平行四边形表示输入/输出。练习手工人格追踪，以发现逻辑错误。

Pseudocode example: IF score >= 50 THEN grade ← ‘Pass’ ELSE grade ← ‘Fail’

伪代码示例：IF score >= 50 THEN grade ← ‘Pass’ ELSE grade ← ‘Fail’

6. Software Development: Testing and Readability | 软件开发：测试与可读性

Know the difference between syntax, execution, and logic errors. Design test tables that include normal, boundary, and exceptional test data. For each case, specify expected output. Additionally, revise internal commentary, meaningful identifiers, and indentation as techniques that improve code readability and maintainability.

区分语法错误、执行错误和逻辑错误。设计包含正常、边界和异常测试数据的测试表。为每种情况指定预期输出。此外，复习内部注释、有意义的标识符和缩进，这些是提高代码可读性和可维护性的技巧。

Test Type	Example Input	Expected Output
Normal	75	Pass
Boundary	50	Pass
Exceptional	-5	Invalid

测试类型 / 示例输入 / 预期输出：正常值 75 → 通过；边界值 50 → 通过；异常值 -5 → 无效。

7. Database Design: Entities and Relationships | 数据库设计：实体与关系

Refresh your understanding of relational database terms: entity, attribute, primary key, foreign key. Draw entity-relationship diagrams using crow’s foot notation to show one-to-one, one-to-many, and many-to-many relationships. Practise describing how to resolve many-to-many links by introducing a linking table with composite keys.

重新梳理关系数据库术语：实体、属性、主键、外键。使用鱼尾纹符号绘制实体关系图，表示一对一、一对多和多对多关系。练习描述如何通过引入带有组合键的链接表来解决多对多联系。

8. Database Design: Normalisation and SQL | 数据库设计：规范化与 SQL

Work through first and second normal form (1NF and 2NF). Identify repeating groups, partial dependencies, and transform them into separate tables. For SQL, master SELECT, FROM, WHERE, ORDER BY, and the use of wildcards (LIKE ‘%…’). Write queries that search across multiple tables using EQUI-JOINs. Always test your SQL on a practice dataset.

练习第一范式和第二范式（1NF 和 2NF）。识别重复组、部分依赖并将它们转化为独立的表。对于 SQL，掌握 SELECT、FROM、WHERE、ORDER BY 以及通配符（LIKE ‘%…’）的使用。编写使用等值连接跨多表查询的语句。务必在练习数据集上测试你的 SQL。

SQL: SELECT name, grade FROM Students WHERE grade >= 70 ORDER BY name ASC;

SQL：SELECT name, grade FROM Students WHERE grade >= 70 ORDER BY name ASC;

9. Web Design: HTML and CSS | 网页设计：HTML 与 CSS

Hand-code basic HTML pages using correct structure: DOCTYPE, html, head, title, body. Use tags for paragraph (p), heading (h1-h6), image (img), hyperlink (a href), and lists (ul, ol, li). Apply CSS for styling—internal and inline styles. Know how to select by element, class, and ID. Ensure you understand the separation of content (HTML) from presentation (CSS).

手写基本 HTML 页面，使用正确结构：DOCTYPE、html、head、title、body。使用段落（p）、标题（h1-h6）、图片（img）、超链接（a href）和列表（ul、ol、li）标签。应用 CSS 进行样式设计——内部样式和行内样式。了解如何按元素、类和 ID 进行选择。确保理解内容（HTML）与呈现（CSS）的分离。

10. Revision Through Past Papers | 通过历年真题复习

From the second week, devote every third session to completing past paper questions under timed conditions. After each paper, mark your answers using the SQA marking scheme and note down command words like ‘describe’, ‘explain’, and ‘compare’ to understand what depth is needed. Build a mistake log: write the question, your error, and the correct approach. Review this log weekly.

从第二周开始，每三个时段中抽出一个用于在计时条件下完成历年真题。每张试卷完成后，使用 SQA 评分方案给自己的答案打分，并记录下诸如“描述”“解释”“比较”等指令词，以了解所需答题深度。建立一个错题本：写下题目、你的错误和正确解法。每周复习错题本。

---

Published by TutorHao | Computing Revision Series | aleveler.com

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