Year 12 SQA Computing Science: Summer Preparation and Bridging Course | Year 12 SQA 计算机：暑期预习与衔接课程

📚 Year 12 SQA Computing Science: Summer Preparation and Bridging Course | Year 12 SQA 计算机：暑期预习与衔接课程

Transitioning from National 5 to Higher Computing Science is a significant step. This summer bridging course is designed to help you consolidate key concepts, preview new topics, and develop the problem-solving mindset required for the SQA Higher. By working through this guide, you will build a strong foundation in software design, computer systems, databases, and web development – all essential components of the Higher course.

从 National 5 过渡到 Higher 计算机科学是一个重要的跨越。本暑期衔接课程旨在帮助你巩固关键概念、预览新课题，并培养 SQA Higher 所需的解决问题的思维方式。通过跟随本指南学习，你将在软件设计、计算机系统、数据库和网页开发等 Higher 课程的核心模块上打下坚实基础。

---

1. Course Overview and Learning Objectives | 课程概览与学习目标

The SQA Higher Computing Science course consists of two mandatory units: Software Design and Development, and Information System Design and Development. The final assessment includes a question paper (110 marks) and a coursework assignment (60 marks). In this course you will learn to apply computational thinking, analyse problems, design modular solutions, and implement them using a high-level language such as Python or Java. A deeper understanding of computer architecture, networking, data representation, and the impact of computing is also required.

SQA Higher 计算机科学课程包含两个必修单元：软件设计与开发，以及信息系统设计与开发。最终评估包括一份试卷（110 分）和一份课程作业（60 分）。在这门课程中，你将学习运用计算思维、分析问题、设计模块化解决方案，并使用 Python 或 Java 等高级语言实现这些方案。同时，你还需要深入理解计算机体系结构、网络、数据表示以及计算对社会的影响。

The main difference from National 5 is the level of depth and independence expected. You will be required to design and evaluate solutions rather than just implement them. In the summer, it is wise to familiarise yourself with the specification and set clear learning goals for each week.

与 National 5 的主要区别在于所要求的深度和独立性。你将被要求设计并评估解决方案，而不仅仅是实现它们。暑假期间，明智的做法是熟悉课程规范，并为每周设定清晰的学习目标。

---

2. Key Prerequisites: Refreshing National 5 Computing | 关键前置知识：重温 National 5 计算机

Before diving into Higher topics, it is essential to ensure your National 5 knowledge is secure. Pay special attention to fundamental programming constructs (sequence, selection, iteration), data types (integer, real, string, Boolean), and basic file handling. You should be comfortable reading and tracing code, identifying errors, and explaining what a short segment of code does.

在深入学习 Higher 课题之前，必须确保你的 National 5 知识牢固掌握。请特别关注基本的编程结构（顺序、选择、迭代）、数据类型（整数、实数、字符串、布尔型）以及基本的文件处理。你应该能轻松地阅读和追踪代码、识别错误，并解释一小段代码的功能。

• Revise the use of standard algorithms: input validation, running total, linear search, and counting occurrences.

  复习标准算法的使用：输入验证、累加总和、线性搜索和统计出现次数。

• Practise translating a problem description into pseudocode or a flowchart.

  练习将问题描述转换为伪代码或流程图。

• Make sure you understand the fetch-execute cycle, the purpose of CPU components, and the difference between RAM and ROM.

  确保你理解取指-执行周期、CPU 各部件的作用以及 RAM 和 ROM 的区别。

If any of these areas feel weak, spend the first week of summer reviewing your National 5 notes or using online platforms such as BBC Bitesize for Computing Science.

如果上述任何方面感觉薄弱，请在暑假的第一周复习你的 National 5 笔记或使用 BBC Bitesize 等平台的计算机科学内容进行回顾。

---

3. Software Development Process Models | 软件开发过程模型

In Higher Computing Science, you will study formal software development methodologies. The two main models are the waterfall model and the iterative (agile) model. The waterfall model is a linear, sequential approach where each phase (analysis, design, implementation, testing, documentation, evaluation, maintenance) must be completed before moving to the next. It is suitable for projects with well-defined requirements that are unlikely to change.

在 Higher 计算机科学中，你将学习正式的软件开发方法。两种主要模型是瀑布模型和迭代（敏捷）模型。瀑布模型是一种线性的顺序方法，每个阶段（分析、设计、实现、测试、文档编制、评估、维护）必须在进入下一阶段之前完成。它适用于需求明确且不太可能变更的项目。

The iterative model, in contrast, develops the software through repeated cycles. Each iteration produces a working version of the software, which is refined based on user feedback. This model is more flexible and suits projects where requirements may evolve. You must be able to compare these models in terms of advantages, disadvantages, and suitable scenarios.

相比之下，迭代模型通过重复的周期来开发软件。每次迭代都会产生一个可工作的软件版本，并根据用户反馈进行完善。该模型更加灵活，适合需求可能演变的项目。你必须能够从优点、缺点和适用场景的角度比较这些模型。

Feature	Waterfall	Iterative
Flexibility	Low – hard to change requirements	High – embraces change
User involvement	Mainly at start and end	Continuous feedback
Documentation	Comprehensive upfront	Lightweight, evolves

比较瀑布模型与迭代模型的关键特征

---

4. Advanced Programming Concepts: Arrays, Files and Modularity | 高级编程概念：数组、文件与模块化

Higher programming extends National 5 by introducing 1-D arrays (lists), file reading/writing, and modular programming using procedures and functions with parameter passing. Array operations include traversing, searching, inserting, and deleting elements. In SQA questions, you will often be asked to write code to find the maximum, minimum, or average of an array, or to count elements matching a condition.

Higher 编程在 National 5 的基础上引入了 1 维数组（列表）、文件读取/写入，以及使用带参数传递的过程和函数进行模块化编程。数组操作包括遍历、搜索、插入和删除元素。在 SQA 试题中，你经常会被要求编写代码来查找数组的最大值、最小值或平均值，或者统计满足某个条件的元素个数。

File handling typically involves reading from a text file line by line, processing the data, and writing results to a new file. Modularity is about breaking a large problem into smaller, reusable subprograms. Key concepts include formal and actual parameters, local and global variables, and the advantages of modularity (ease of testing, reusability, teamwork).

文件处理通常涉及逐行读取文本文件、处理数据并将结果写入新文件。模块化是指将大问题分解为更小的、可重用的子程序。关键概念包括形式参数和实际参数、局部变量和全局变量，以及模块化的优点（易于测试、可重用性、团队合作）。

• Practise writing a procedure that sorts an array using bubble sort or selection sort; trace the algorithm step-by-step.

  练习编写一个使用冒泡排序或选择排序对数组进行排序的过程；逐步追踪算法。

• Write a function that takes an array and a search key as parameters and returns the index if found, or -1 otherwise.

  编写一个函数，以数组和搜索键作为参数，如果找到则返回索引，否则返回 -1。

---

5. Computer Systems: Data Representation and Algorithm Efficiency | 计算机系统：数据表示与算法效率

At Higher level, data representation is explored in more depth. You need to know how numbers, text, and instructions are stored in binary. Learn about two’s complement representation for negative integers, floating-point representation (mantissa and exponent), and how Unicode represents characters. You should also understand the implications of bit-depth on colour and sound quality.

在 Higher 层次，数据表示被更深入地探讨。你需要了解数字、文本和指令如何以二进制形式存储。学习负整数的二进制补码表示、浮点数表示（尾数和指数）以及 Unicode 如何表示字符。你还需要理解位深度对颜色和音频质量的影响。

Algorithm efficiency is measured using Big-O notation. You are expected to describe the time complexity of standard algorithms like linear search O(n) and binary search O(log n). Be able to explain why a binary search requires a sorted array and why its efficiency is logarithmic. A simple comparison table helps:

算法效率使用大 O 表示法来衡量。你需要描述标准算法的时间复杂度，例如线性搜索 O(n) 和二分搜索 O(log n)。要能够解释为什么二分搜索要求数组有序，以及为什么它的效率是对数级的。一个简单的对照表很有帮助：

Algorithm	Best case	Average/Worst case
Linear search	O(1)	O(n)
Binary search	O(1)	O(log n)

Practise converting between binary, denary, and hexadecimal, and calculating file sizes for images and sound.

练习在二进制、十进制和十六进制之间进行转换，并计算图像和声音的文件大小。

---

6. Computer Systems: Hardware Architecture and Performance | 计算机系统：硬件架构与性能

Higher candidates must explain how a processor functions, including the roles of the control unit, ALU, and registers (program counter, MAR, MDR, accumulator). The concept of pipelining is introduced to show how multiple instructions can be processed simultaneously to improve performance. Clock speed, number of cores, and cache memory size directly impact system performance.

Higher 考生必须解释处理器如何工作，包括控制单元、ALU 和寄存器（程序计数器、MAR、MDR、累加器）的作用。流水线的概念被引入，以展示如何同时处理多条指令来提高性能。时钟速度、核心数量和缓存大小直接影响系统性能。

You will also study memory management: virtual memory, paging, and how the operating system allocates RAM to processes. An understanding of buses (address bus, data bus, control bus) and their widths completes the picture. A typical exam question might ask: ‘Explain why increasing the number of cores does not always double the performance.’ This links to the idea of parallelizable tasks and Amdahl’s law, though you only need a qualitative description.

你还将学习内存管理：虚拟内存、分页以及操作系统如何为进程分配 RAM。对总线（地址总线、数据总线、控制总线）及其宽度的理解将使整个知识体系更完整。一个典型的考题可能会问：”解释为什么增加核心数量并不总能使性能翻倍。”这与任务的可并行性和 Amdahl 定律有关，不过你只需要定性描述。

For summer preparation, create flashcards for CPU components and performance factors. Watch animations of the fetch-execute cycle to solidify your mental model.

对于暑期预习，制作关于 CPU 组件和性能因素的闪卡。观看取指-执行周期的动画以巩固你的心智模型。

---

7. Database Design and SQL Queries | 数据库设计与 SQL 查询

The Information System Design and Development unit covers relational databases. You need to understand entities, attributes, primary keys, foreign keys, and the different types of relationships (one-to-one, one-to-many, many-to-many). Normalisation is a new topic at Higher: you must be able to take a flat file and normalise it to third normal form (3NF) by identifying partial and transitive dependencies.

信息系统设计与开发单元涵盖关系数据库。你需要理解实体、属性、主键、外键以及不同类型的关系（一对一、一对多、多对多）。规范化是 Higher 阶段的新课题：你必须能够识别部分依赖和传递依赖，将平面文件规范化为第三范式（3NF）。

Structured Query Language (SQL) becomes more complex. Besides SELECT, FROM, WHERE, and ORDER BY, you will use aggregate functions (COUNT, SUM, AVG, MAX, MIN), GROUP BY with HAVING, and joins (INNER JOIN, LEFT JOIN) to combine data from multiple tables. Ensure you can write SQL for subqueries and use alias (AS) for readability.

结构化查询语言（SQL）变得更加复杂。除了 SELECT、FROM、WHERE 和 ORDER BY，你还要使用聚合函数（COUNT、SUM、AVG、MAX、MIN）、带 HAVING 的 GROUP BY 以及连接（INNER JOIN、LEFT JOIN）来组合多个表的数据。确保你能编写子查询，并使用别名（AS）以提高可读性。

SELECT department, COUNT(*) AS staff_count
FROM Staff
GROUP BY department
HAVING COUNT(*) > 5
ORDER BY staff_count DESC;

Set up a practice environment using SQLite or MySQL online sandbox and work through past paper queries. Drawing entity-relationship diagrams will also strengthen your design skills.

使用 SQLite 或 MySQL 在线沙盒搭建练习环境，完成往年试题中的查询。绘制实体关系图也将加强你的设计能力。

---

8. Web Design and Development with HTML, CSS and JavaScript | 使用 HTML、CSS 和 JavaScript 的网页设计与开发

Web development at Higher involves a combination of HTML for structure, CSS for presentation, and JavaScript for client-side scripting. You are expected to write well-structured HTML5, use external style sheets, and implement interactive features such as form validation, image galleries, and simple animations.

Higher 阶段的网页开发涉及综合运用 HTML 构建结构、CSS 负责表现、JavaScript 处理客户端脚本。你需要能够编写结构良好的 HTML5，使用外部样式表，并实现表单验证、图片画廊和简单动画等交互功能。

CSS concepts include box model, selectors (class, ID, descendant), positioning, responsive design using media queries, and the use of flexbox or grid for layout. JavaScript topics cover variables, functions, events (onclick, onmouseover), DOM manipulation, and conditional statements to control webpage behaviour.

CSS 概念包括盒子模型、选择器（类、ID、后代）、定位、使用媒体查询的响应式设计，以及使用 flexbox 或 grid 进行布局。JavaScript 主题涵盖变量、函数、事件（onclick、onmouseover）、DOM 操作和用于控制网页行为的条件语句。

A typical task might ask you to write JavaScript that validates a password field: check length, ensure it contains at least one number, and display an appropriate error message next to the field without reloading the page. This combines input validation with DOM updating.

一个典型的任务可能会要求你编写 JavaScript 来验证密码字段：检查长度、确保包含至少一个数字，并在字段旁边显示适当的错误信息而不重新加载页面。这结合了输入验证和 DOM 更新。

Over the summer, try to build a small personal website or a revision quiz. Use browser developer tools to inspect and debug your code.

暑假期间，尝试构建一个小型个人网站或复习测验。使用浏览器开发者工具来检查和调试你的代码。

---

9. Summer Study Plan: Weekly Goals and Resources | 暑期学习计划：每周目标与资源

A structured summer plan will prevent last-minute panic. Below is a suggested 6-week schedule that balances theory and practical programming. Adjust it according to your own strengths and weaknesses.

一份结构化的暑期计划能防止最后一刻的慌乱。以下是一个建议的 6 周时间表，平衡了理论和实践编程。你可以根据自己的强项和弱项进行调整。

Week	Focus	Activities
1	National 5 Refresher	Code tracing exercises, input validation, linear search; create summary notes on CPU and memory.
2	Software Development Process	Read about waterfall and iterative models; draw diagrams; compare in a table.
3	Advanced Programming	Arrays, file I/O, modular programming; implement sorting and searching algorithms.
4	Computer Systems	Data representation, two’s complement, floating point; CPU performance factors.
5	Databases and SQL	Normalisation exercises, SQL joins and aggregates; design a sample database.
6	Web Development	Build a responsive page with CSS flexbox and JavaScript form validation.

Use resources such as SQA past papers, Scholar, BBC Bitesize, and the SQA course specification. Join online computing forums to discuss problems.

利用 SQA 历年试卷、Scholar、BBC Bitesize 和 SQA 课程规范等资源。加入在线计算机论坛讨论问题。

---

10. Common Pitfalls and Effective Revision Strategies | 常见误区与高效复习策略

Students often stumble when they treat computing as a reading-only subject. You must write code regularly – typing out algorithms, even if you have seen the solution, helps internalise logic. Another pitfall is memorising SQL syntax without understanding the data relationships; always link queries to the underlying ER diagram.

学生们常犯的错误是将计算机当作一门只需阅读的学科。你必须定期编写代码——即使你见过解法，亲手键入算法也能帮助内化逻辑。另一个误区是只背 SQL 语法而不理解数据关系；始终将查询与底层的 ER 图联系起来。

When revising for the Higher exam, use active recall: test yourself with flashcards for definitions (e.g., ‘What is a primary key?’), and practice past papers under timed conditions. After each paper, mark it strictly and note any gaps. Create a ‘mistake log’ and revisit those topics the following week.

在为 Higher 考试复习时，使用主动回忆法：用闪卡自测定义（例如”什么是主键？”），并在限时条件下练习历年试卷。每做完一套试卷，严格批改并记录任何知识漏洞。创建一份”错题日志”，并在下一周重温这些主题。

For programming tasks, adopt a design-first approach: write pseudocode or a structure chart before coding. This mirrors the SQA coursework where you must produce analysis and design documents. Finally, teach a friend or a rubber duck – explaining concepts aloud cements understanding.

对于编程任务，采用设计优先的方法：在编码之前编写伪代码或结构图。这反映了 SQA 课程作业中你必须生成分析和设计文档的要求。最后，教给一位朋友或一只橡皮鸭——大声解释概念能巩固理解。

Stay curious. Summer bridging is not about covering the entire syllabus, but about developing the skills and confidence to engage deeply when classes begin. Each small project you build or question you solve moves you closer to success in Year 12.

保持好奇心。暑期衔接并不是为了覆盖全部教学大纲，而是培养技能和信心，以便在开学时能够深入参与。你构建的每个小项目或解决的每个问题，都会让你离 Year 12 的成功更近一步。

Published by TutorHao | Computing Revision Series | aleveler.com

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