📚 SQA Higher Computing Science: Summer Prep and Bridging Course | SQA 高等计算机科学：暑期预习与衔接课程
Welcome to your summer bridging programme for SQA Higher Computing Science. This guide is designed to help Year 12 students consolidate their National 5 knowledge and build the foundational skills required to excel in the Higher course. Over the holidays, you will explore key concepts such as software design and development, database systems, web technologies, and computer architecture. The aim is not to pre-teach the entire syllabus but to give you a confident start by reinforcing computational thinking and practical programming ability.
欢迎参加这门为 SQA 高等计算机科学量身打造的暑期衔接课程。本指南旨在帮助 Year 12 学生巩固 National 5 阶段的知识，并建立在 Higher 课程中脱颖而出所需的基础技能。暑期里，你将探索软件开发、数据库系统、网页技术和计算机体系结构等关键概念。目标并非提前讲授全部大纲，而是通过强化计算思维和实际编程能力，让你自信起跑。
1. Understanding the SQA Higher Computing Science Course | 理解 SQA 高等计算机科学课程
The SQA Higher Computing Science qualification assesses your ability to apply computational thinking in practical and theoretical contexts. The course is divided into four key units: Software Design and Development, Computer Systems, Database Design and Development, and Web Design and Development. The final grade comes from a question paper (worth 110 marks) and a coursework assignment (worth 60 marks). During the summer, familiarising yourself with this structure will help you plan your revision and project work effectively.
SQA 高等计算机科学资格证书评估你在实践和理论背景下应用计算思维的能力。课程分为四个关键单元：软件设计与开发、计算机系统、数据库设计与开发，以及网页设计与开发。最终成绩由一份试卷（110 分）和一份课程作业（60 分）构成。暑期里熟悉这一结构将有助于你有效规划复习和项目工作。
Higher Computing builds directly on the programming, information systems, and computer hardware topics you studied at National 5. However, the depth and complexity increase significantly. You will be expected to write more complex programs, understand low-level architecture, design relational databases involving multiple tables, and implement websites that use CSS and JavaScript. Use the summer to close any gaps from National 5, especially in programming logic and binary arithmetic.
高等计算机科学直接建立在你在 National 5 阶段所学的编程、信息系统和计算机硬件主题之上。但深度和复杂性显著增加。你将需要编写更复杂的程序，理解底层体系结构，设计涉及多个表的关系数据库，并实现使用 CSS 和 JavaScript 的网站。利用暑期弥补 National 5 中的任何漏洞，尤其是在编程逻辑和二进制算术方面。
2. Computational Thinking Refresher | 计算思维回顾
Computational thinking lies at the heart of all four units. The core skills are abstraction, decomposition, pattern recognition, and algorithm design. Abstraction means ignoring unnecessary detail to focus on what is important, while decomposition is breaking a complex problem into smaller, manageable parts. During the summer, practise these skills by tackling simple puzzle games or by writing out the steps needed to sort a list of numbers.
计算思维是所有四个单元的核心。核心技能包括抽象、分解、模式识别和算法设计。抽象意味着忽略不必要的细节以专注于重要内容，分解则是将复杂问题拆分为更小、更易管理的部分。暑期里，可以通过玩简单的益智游戏或写出对数字列表排序所需的步骤，来练习这些技能。
A solid algorithm can be expressed in pseudocode or a flowchart. At Higher level, you need to be comfortable with both. Pseudocode should use clear, consistent conventions such as IF … THEN … ELSE … END IF, FOR EACH … FROM … TO … DO … END FOR. Flowcharts must use correct symbols: oval for start/stop, parallelogram for input/output, rectangle for process, and diamond for decision. Redrawing some National 5 algorithms from memory is an excellent preparation task.
一个可靠的算法可以用伪代码或流程图来表达。在高等阶段，你需要熟练运用两者。伪代码应使用清晰一致的约定，如 IF … THEN … ELSE … END IF、FOR EACH … FROM … TO … DO … END FOR。流程图必须使用正确的符号：椭圆形表示开始/结束，平行四边形表示输入/输出，矩形表示处理，菱形表示判断。凭记忆重画一些 National 5 算法是一项极好的准备练习。
3. Setting Up Your Programming Environment | 搭建你的编程环境
Most Scottish schools use Python for the software development unit, though some use Java or Visual Basic. Confirm with your teacher which language you will be using, but if in doubt, set up Python 3.x on your home computer. Python is widely recommended because its syntax is clean and it supports the advanced data structures (arrays of records, sequential files) required for Higher. Install Python from the official website and a suitable editor such as Thonny or VS Code.
大多数苏格兰学校在软件开发单元中使用 Python，但有些学校使用 Java 或 Visual Basic。向你的老师确认将使用哪种语言，但如果不确定，请在家用电脑上安装 Python 3.x。Python 被广泛推荐，因为它语法简洁，并且支持高等课程所需的高级数据结构（记录数组、顺序文件）。从官方网站安装 Python 和一个合适的编辑器，如 Thonny 或 VS Code。
Once installed, write a few small programs to refresh your skills. Start with input, output, and simple arithmetic. Then move on to if-elif-else selection and while loops. Experiment with 1D arrays (lists) by storing student names and searching for a specific value using a linear search. The summer is an ideal time to become fluent in using subroutines (procedures and functions) with parameters. Create a program that calculates the area of a circle using a function area(radius) that returns the result.
安装完成后，编写几个小程序来温习技能。从输入、输出和简单算术开始。然后转向 if-elif-else 选择和 while 循环。尝试使用一维数组（列表）存储学生姓名，并使用线性搜索来查找某个特定值。暑期是熟练运用带参数的子程序（过程与函数）的理想时机。创建一个程序，使用函数 area(radius) 计算圆的面积并返回结果。
4. Working with Data Structures and File Handling | 使用数据结构与文件处理
At Higher, you must be able to handle parallel 1D arrays and arrays of records. An array of records stores multiple data items of different types for each element. For example, a record for a book might store the title, author, and stock count. In Python, you can implement this using a list of dictionaries or a class. Summer practice: design a structure to hold five pieces of data for a football player (name, age, position, goals, club) and write functions to find the player with the most goals.
在高等阶段，你必须能够处理并行一维数组和记录数组。记录数组为每个元素存储多个不同类型的数据项。例如，一本图书的记录可以存储书名、作者和库存数量。在 Python 中，你可以使用由字典组成的列表或类来实现。暑期练习：设计一个结构来保存一名足球运动员的五个数据（姓名、年龄、位置、进球数、俱乐部），并编写函数找出进球最多的球员。
Sequential file reading and writing is another key Higher skill. You need to open a text file, read its contents line by line, process the data, and write results to a new file. Practise with a CSV file that contains mock student grades. Read the file into a suitable data structure, calculate the average grade, and output a summary report. Always use try…except when handling files to manage errors such as missing files.
顺序文件的读取和写入是高等阶段的另一项关键技能。你需要打开文本文件，逐行读取内容，处理数据，并将结果写入新文件。使用包含模拟学生成绩的 CSV 文件进行练习。将文件读入适当的数据结构，计算平均成绩，并输出一份摘要报告。处理文件时始终使用 try…except 来管理诸如文件丢失之类的错误。
5. Introduction to Database Design | 数据库设计入门
The database unit requires you to understand relational databases, entity-relationship diagrams, and SQL. Start by reviewing key terms: entity (a thing about which data is stored, like a student), attribute (a piece of information about an entity, like student name), primary key (a unique identifier), and foreign key (a primary key from another table used to create a relationship). Draw simple diagrams for a library system: a Member entity and a Book entity, linked by a Loan table.
数据库单元要求你理解关系数据库、实体关系图和 SQL。首先复习关键术语：实体（存储数据的对象，如学生）、属性（关于实体的一条信息，如学生姓名）、主键（唯一标识符）和外键（来自另一张表、用于创建关系的主键）。为图书馆系统绘制简单图表：一个会员实体和一个图书实体，通过借阅表关联起来。
You should also be comfortable writing SQL queries using SELECT, FROM, WHERE, ORDER BY, and performing joins across two or more tables. Set up a free account on a platform like SQLiteonline.com or install DB Browser for SQLite. Create two tables: Patient (patientID, name, postcode) and Appointment (apptID, patientID*, date, time). Insert sample data and write queries to list all appointments for a given patient, or count appointments per date. This hands-on work will make the taught course much easier.
你还应能轻松编写使用 SELECT、FROM、WHERE、ORDER BY 的 SQL 查询，并在两个或多个表之间执行联接。在 SQLiteonline.com 等平台上注册一个免费账户，或安装 DB Browser for SQLite。创建两个表：Patient (patientID, name, postcode) 和 Appointment (apptID, patientID*, date, time)。插入示例数据并编写查询，列出某位患者的所有预约，或者统计每个日期的预约数量。这种动手操作将使后续课程学习变得轻松很多。
6. Web Design and Development Essentials | 网页设计与开发要领
The Web unit combines HTML, CSS, and an introduction to JavaScript. You will need to create a multi-page website that is responsive and accessible. Summer is perfect for practising semantic HTML5 elements: <header>, <nav>, <main>, <section>, <article>, and <footer>. Build a simple three-page site about a hobby. Ensure each page has a consistent navigation menu and uses relative hyperlinks.
网页单元综合了 HTML、CSS 和 JavaScript 入门。你需要创建一个响应式且可访问的多页面网站。暑期非常适合练习语义化 HTML5 元素：<header>、<nav>、<main>、<section>、<article> 和 <footer>。搭建一个关于某项爱好的简单三页网站。确保每页有一致的导航菜单，并使用相对超链接。
External CSS should be used to control presentation. Selectors such as class (.) and ID (#) are expected at Higher. Practise layout using Flexbox or, if you are more advanced, CSS Grid. Write a stylesheet that changes the background colour of every second table row (use a class or :nth-child pseudo-class). You will also need to embed simple JavaScript to validate form inputs or respond to user events. Start with an onclick event that displays the current date or toggles the visibility of a paragraph. The summer is about becoming confident in reading and debugging small scripts.
应使用外部 CSS 来控制呈现效果。高等阶段要求使用类（.）和 ID（#）等选择器。练习使用 Flexbox 或更高级的 CSS Grid 进行布局。编写一个样式表，更改每个偶数表格行的背景颜色（使用类或 :nth-child 伪类）。你还需要嵌入简单的 JavaScript 来验证表单输入或响应用户事件。从一个 onclick 事件开始，该事件显示当前日期或切换段落的可见性。暑期的目标是变得自信，能够阅读和调试小脚本。
7. Computer Systems: The Inside View | 计算机系统：内部原理
The Computer Systems unit covers data representation, computer architecture, networking, and operating systems. A key Higher topic is the fetch-execute cycle. You should be able to describe the roles of the processor, main memory, and buses (address, data, control). Draw a simple diagram showing the flow of data and control signals. Revise National 5 binary conversions, then extend your skills to floating-point representation using a mantissa and exponent model. For example, represent the number 12.75 in binary using a 16-bit word with an 8-bit mantissa and 8-bit exponent.
计算机系统单元涵盖数据表示、计算机体系结构、网络和操作系统。高等阶段的一个关键主题是取指-执行周期。你应该能够描述处理器、主存和总线（地址、数据、控制）的作用。绘制一幅简单示意图，显示数据和控制信号的流向。复习 National 5 的二进制转换，然后将技能扩展到使用尾数和阶码模型的浮点数表示。例如，使用 16 位字长（8 位尾数、8 位阶码）以二进制表示数字 12.75。
Understand how to calculate the memory required for a bitmap image and a digital audio file. For a 1024 by 768 pixel image with a colour depth of 24 bits, the uncompressed size is 1024 × 768 × 24 bits. Practise converting this into megabytes. Also explore the concept of the stored program concept and how an operating system manages memory, processes, and file systems. Write short paragraphs in your own words to consolidate these abstract ideas.
理解如何计算位图图像和数字音频文件所需的内存。对于一幅 1024×768 像素、24 位色深的图像，未压缩大小为 1024 × 768 × 24 位。练习将其转换为兆字节。还要探索存储程序概念，以及操作系统如何管理内存、进程和文件系统。用自己的话写一些简短的段落来巩固这些抽象概念。
8. Networking and Security Fundamentals | 网络与安全基础
You will learn about LANs, WANs, client-server and peer-to-peer models, and the TCP/IP protocol stack. During summer, get comfortable with the four layers: application, transport, internet, and network access. Know what each layer is responsible for and give examples of protocols (HTTP, TCP, IP, Ethernet). Draw a simple diagram of a home network showing devices, a switch, a router, and the ISP. Explain the purpose of an IP address and a MAC address.
你将学习局域网、广域网、客户端-服务器与对等模型，以及 TCP/IP 协议栈。暑期里，请熟悉这四个层次：应用层、传输层、互联网层和网络接入层。了解每一层负责什么，并给出协议示例（HTTP、TCP、IP、以太网）。绘制一幅家庭网络简图，展示设备、交换机、路由器和 ISP。解释 IP 地址和 MAC 地址的用途。
Computer security is integrated throughout the course. Revise the need for encryption, firewalls, and user authentication. Consider the differences between a plaintext and a ciphertext. Try a simple shift cipher (Caesar cipher) by hand: encrypt the word ‘COMPUTER’ with a shift of 3 to get ‘FRPSXWHU’. Understanding these foundations now will help you evaluate security risks in the Higher assignment scenario.
计算机安全贯穿整个课程。复习加密、防火墙和用户身份验证的必要性。思考明文与密文的区别。手动尝试一种简单的移位密码（凯撒密码）：将单词 ‘COMPUTER’ 移位 3 位得到 ‘FRPSXWHU’。现在打好这些基础将有助于你在高等课程作业情境中评估安全风险。
9. Algebraic Logic and Truth Tables | 逻辑代数与真值表
A small but important part of Computer Systems involves Boolean algebra and logic gates. You should recognise AND, OR, NOT, NAND, and NOR gates and their truth tables. At Higher, you will combine gates into logic circuits and derive a Boolean expression from a given circuit or a truth table. Use the summer to practise the standard notation: A AND B is written as A.B; A OR B is written as A+B; and NOT A is written as Ā or ¬A. Create truth tables for 2- and 3-input circuits and verify your results using online simulators.
计算机系统单元中一个小而重要的部分涉及布尔代数和逻辑门。你应该认识与门、或门、非门、与非门和或非门及其真值表。在高等阶段，你将把门电路组合成逻辑电路，并从给定电路或真值表推导出布尔表达式。利用暑期练习标准表示法：A AND B 写作 A.B；A OR B 写作 A+B；NOT A 写作 Ā 或 ¬A。为 2 输入和 3 输入电路创建真值表，并使用在线模拟器验证结果。
A common Higher task is to simplify a Boolean expression using laws such as commutativity, distributivity, and De Morgan’s laws. For example, apply De Morgan’s law to ¬(A+B) to obtain ¬A . ¬B. While formal simplification may be new, you can start by recognising equivalent expressions. Write a short program that prints the truth table for a given Boolean expression—this merges your programming and logic skills.
高等课程中常见的任务是使用交换律、分配律和德摩根定律等规则来简化布尔表达式。例如，对 ¬(A+B) 应用德摩根定律得到 ¬A . ¬B。虽然正式简化可能是新内容，但你可以从识别等价表达式开始。编写一个简短的程序，打印给定布尔表达式的真值表——这将融合你的编程和逻辑技能。
10. Summer Project: Design a Mini Information System | 暑期项目：设计一个迷你信息系统
The best way to bridge into Higher Computing is to complete a small integrated project that combines several units. Design a system for a school library database that links members to loans, and build a simple website front-end to view available books. The database should have three tables: Members, Books, and Loans. Use SQLite to implement the schema and populate with sample records. Write Python or JavaScript to query the database and display results on a webpage.
过渡到高等计算机科学的最佳方式是完成一个小型综合项目，将几个单元内容结合起来。为学校图书馆数据库设计一个系统，将会员与借阅记录关联起来，并构建一个简单的网页前端来查看可借阅的图书。数据库应包含三个表：Members、Books 和 Loans。使用 SQLite 来实现该模式并填充示例记录。编写 Python 或 JavaScript 代码查询数据库并在网页上显示结果。
Aim to spend 6–8 hours on this over the summer. Break the work into chunks: week 1 design the database schema and draw the ER diagram; week 2 build the database and write SQL queries; week 3 create the HTML/CSS interface; week 4 add basic JavaScript or Python to link the front-end and back-end. This project mirrors the type of thinking required for the coursework assignment and will give you tangible evidence of your readiness for Year 12.
目标是暑期里用 6 到 8 小时完成它。将工作分成几个部分：第一周设计数据库模式并绘制 ER 图；第二周构建数据库并编写 SQL 查询；第三周创建 HTML/CSS 界面；第四周添加基本的 JavaScript 或 Python 来连接前端和后端。这个项目反映了课程作业所需的思维方式，并将为你的 Year 12 准备状态提供切实的证据。
11. Time Management and Study Tips for Higher Computing | 高等计算机的时间管理与学习技巧
Higher Computing Science demands consistent practical work. Unlike some subjects, you cannot leave programming or database design until the last minute. Create a weekly schedule that dedicates 2–3 hours outside class for coding practice. Use a logbook or digital notebook to record errors you encountered and how you solved them. This reflection habit will be invaluable when revising for the exam and writing your coursework evaluation.
高等计算机科学需要持续的实践工作。与某些科目不同，你不能把编程或数据库设计留到最后一刻。制定一个每周计划，在课外专门安排 2 到 3 小时进行编码练习。使用日志本或数字笔记本，记录你遇到的错误以及你是如何解决它们的。在复习备考和撰写课程作业评价时，这种反思习惯将无比宝贵。
Collaborate with peers, but ensure you understand every line of code you submit. Use the SQA course specification and past papers to guide your learning. Throughout the summer, bookmark a few reputable tutorials (such as W3Schools for web, and the official Python documentation). Remember that the assignment requires you to analyse, design, implement, test, and evaluate a solution—so practising these stages in your mini project is direct preparation.
可以与同学合作，但要确保你理解所提交的每一行代码。使用 SQA 课程规范和往年试卷来指导学习。整个暑期，收藏一些可靠教程（例如网站方面可参考 W3Schools，以及 Python 官方文档）。请记住，课程作业要求你分析、设计、实现、测试和评估一个解决方案——因此，在迷你项目中练习这些阶段正是直接的备考。
12. Ready for the Year Ahead | 为未来一年做好准备
By working through this bridging course, you have revisited key National 5 content, set up your development tools, and explored the four main Higher units at an introductory level. You have strengthened your computational thinking, written SQL queries, built a simple responsive website, and even tackled a mini information system. These activities have given you a head start, reducing the anxiety common at the beginning of Year 12 SQA studies.
通过修读这门衔接课程，你重温了关键的 National 5 内容，设置好了开发工具，并入门探索了高等课程的四个主要单元。你增强了计算思维，编写了 SQL 查询，搭建了一个简单的响应式网站，甚至还处理了一个迷你信息系统。这些活动让你领先一步，减少了 Year 12 SQA 学习之初常见的焦虑。
Keep the resources you created—code files, database schemas, website templates, and logic diagrams—in an organised folder. As your teacher introduces new theory, you will be able to connect it back to the practical work you did over the summer. Approach the year with curiosity and the discipline to write a little code every day. You are now well prepared to succeed in SQA Higher Computing Science.
将你创建的资源——代码文件、数据库模式、网站模板和逻辑图——保存在一个井井有条的文件夹中。当你的老师介绍新理论时，你就能将其与你在暑期完成的实践工作联系起来。带着好奇心和每天写一点代码的自律开启这一年。你现在已经为在 SQA 高等计算机科学中取得成功做好了充分准备。
Published by TutorHao | Computing Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导