📚 Year 10 SQA Computing: Summer Preparation and Bridging Course | Year 10 SQA 计算机：暑期预习与衔接课程
This summer bridging course is designed specifically for Year 10 students preparing to tackle the SQA National 5 Computing Science qualification. It covers the essential foundations you will need before term starts, including computational thinking, programming, databases, web development, and exam readiness. The content is structured to fill any gaps from earlier study and to build confidence for the year ahead.
本次暑期衔接课程专为即将学习 SQA National 5 计算科学课程的 Year 10 学生设计。它覆盖了开学前你需要掌握的核心基础，包括计算思维、编程、数据库、网页开发以及考试准备。内容旨在填补之前学习中的知识空白，帮助你建立信心，从容应对新学年。
1. Understanding the SQA Computing Course | 了解 SQA 计算机课程
The SQA National 5 Computing Science course consists of four key units: Software Design and Development, Computer Systems, Database Design and Development, and Web Design and Development. You will also complete a practical assignment that contributes 31% of your final grade, while the question paper makes up 69%. Getting a clear picture of the assessment structure early on will help you plan your study time effectively.
SQA National 5 计算科学课程包含四个核心单元：软件设计与开发、计算机系统、数据库设计与开发以及网页设计与开发。你还需要完成一个实践作业，占最终成绩的 31%，而笔试占 69%。尽早了解评估结构能帮助你有效规划学习时间。
In Scotland, Year 10 often aligns with S4, meaning many learners take National 5 qualifications during this year. The computing course expects you to not only learn facts but also to apply skills in problem-solving, design, and evaluation. Therefore, this bridging course will focus on the big ideas that link all four units.
在苏格兰，Year 10 通常对应 S4，许多学生在这一年参加 National 5 资格考试。计算机课程不仅要求记忆事实，更注重将技能应用于问题解决、设计和评估。因此，这一衔接课程将聚焦于贯通四个单元的核心思想。
2. Computational Thinking | 计算思维
Computational thinking is the backbone of the entire course. It involves decomposing problems, recognising patterns, abstracting away unnecessary details, and designing algorithms. You will be expected to use these techniques when planning software, designing databases, or structuring a website. The earlier you make computational thinking a habit, the smoother your year will be.
计算思维是整个课程的基石。它涉及问题分解、模式识别、抽象化不必要的信息以及设计算法。在规划软件、设计数据库或构建网站时，都需要运用这些技巧。越早养成计算思维的习惯，整个学年的学习便会越顺畅。
A simple example: suppose you need to write a program that finds the largest number in a list. You would decompose the task into steps (initialise a variable, loop through items, compare, update), recognise the pattern of iteration and comparison, and design an algorithm in pseudocode. This process is identical to the approach required in the assignment.
一个简单的例子：假设你需要编写一个程序，找出列表中的最大数。你会将任务分解为若干步骤（初始化变量、遍历元素、比较、更新），识别出迭代与比较的模式，并用伪代码设计算法。这一过程与实践作业要求的方法完全一致。
3. Software Design and Development | 软件设计与开发
The Software Design and Development unit introduces the software development lifecycle: analysis, design, implementation, testing, and evaluation. You must be able to write code in a high-level language – Python is the most common choice in Scottish schools. Before diving into syntax, focus on understanding input, process, output, and the use of variables, data types, and control structures.
软件设计与开发单元介绍了软件开发生命周期：分析、设计、实现、测试和评估。你必须能用一种高级语言编写代码——Python 是苏格兰学校中最常见的选择。在深入学习语法之前，请先理解输入、处理、输出以及变量、数据类型和控制结构的使用。
ee numbers can be expressed as: input num1, num2, num3 → total = num1 + num2 + num3 → average = total / 3 → output average. Translating such designs into Python will reinforce your understanding.
尝试用流程图符号或伪代码阅读和编写简单算法。例如，计算三个数平均值的算法可以表示为：输入 num1、num2、num3 → total = num1 + num2 + num3 → average = total / 3 → 输出 average。将这类设计转化为 Python 代码将加深你的理解。
4. Computer Systems | 计算机系统
This unit covers the inner workings of computers: von Neumann architecture, the fetch-execute cycle, memory types, and data representation. You will need to convert between binary and denary, understand how text, graphics, and sound are stored, and explain the roles of CPU components like the ALU and Control Unit.
本单元涵盖计算机的内部工作原理：冯·诺依曼体系结构、取指-执行周期、存储器类型以及数据表示。你需要掌握二进制与十进制之间的转换，理解文本、图形和声音是如何存储的，并能解释算术逻辑单元（ALU）、控制单元等 CPU 组件的角色。
e conversions until they become second nature. Also familiarise yourself with units of storage: 1 byte = 8 bits, 1 kilobyte = 1024 bytes, and so on.
二进制转换是一项基本技能。例如，十进制数 45 对应的二进制形式是 101101，因为它等于 32 + 8 + 4 + 1。利用这个暑假反复练习转换，直到成为本能。同时，要熟悉存储单位：1 byte = 8 bits，1 kilobyte = 1024 bytes 等等。
5. Database Design | 数据库设计
Databases are used to organise and manage data efficiently. You will learn about flat-file and relational databases, entity-relationship diagrams, keys (primary, foreign), and the concept of referential integrity. SQL is introduced at National 5 level, so you should be able to write simple SELECT, FROM, WHERE, and ORDER BY statements.
数据库用于高效地组织和管理数据。你将学习平面文件与关系型数据库、实体关系图、键（主键、外键）以及参照完整性的概念。在 National 5 级别会介绍 SQL，因此你需要能够编写简单的 SELECT、FROM、WHERE 和 ORDER BY 语句。
Create a small example database on paper: a library system with tables for Books and Members. Identify fields, data types, and a primary key for each table. Then think about how to link them using a foreign key. This kind of exercise builds the design thinking required for the assignment.
在纸上建立一个简单数据库示例：一个包含 Books 表和 Members 表的图书馆系统。为每张表确定字段、数据类型和主键。然后思考如何使用外键将它们关联起来。这类练习能培养作业所需的设计思维。
6. Web Development Fundamentals | 网页开发基础
Web design at National 5 focuses on HTML and CSS. You will need to structure content with tags like < code ><html>, <head>, <body>, <h1>, <p>, <img>, <a> and style pages with CSS selectors, properties, and values. Understanding the separation of content (HTML) and presentation (CSS) is a key design principle.
National 5 级别的网页设计主要关注 HTML 和 CSS。你需要使用诸如 <html>、<head>、<body>、<h1>、<p>、<img>、<a> 等标签来组织内容，并用 CSS 选择器、属性和值为页面添加样式。理解内容（HTML）与表现（CSS）的分离是一个重要的设计原则。
Start by building a simple personal homepage. Use at least three different HTML tags and apply a small embedded stylesheet. Practise the box model concept – margin, border, padding, content – as this is frequently examined. Even a few hours of hands-on coding will make the classroom lessons much easier to follow.
从构建一个简单的个人主页开始。至少使用三种不同的 HTML 标签，并应用一份小型嵌入式样式表。练习盒模型的概念——外边距、边框、内边距、内容——因为这是常考内容。即使只花几个小时动手编码，也能让课堂学习变得轻松许多。
7. Programming Skills in Python | Python 编程技能
Programming is at the heart of Computing Science. Python is recommended because it has a gentle learning curve and clear syntax. You should feel confident with variables, data types (integer, real/float, string, Boolean), arithmetic operations, and how to get input from the user with input() and display output with print().
编程是计算科学的核心。推荐使用 Python，因为它的学习曲线平缓且语法清晰。你应当熟练掌握变量、数据类型（整型、实型/浮点型、字符串、布尔型）、算术运算，以及如何使用 input() 获取用户输入，用 print() 显示输出。
Move on to selection (if, elif, else) and iteration – both fixed loops (for) and conditional loops (while). Write a program that asks for a password and keeps asking until it matches a preset string. This small project uses a while loop and an if statement, and it closely mirrors the style of tasks in the final exam.
接着学习选择结构（if、elif、else）和迭代——计数循环（for）与条件循环（while）。编写一个程序，询问密码，直到输入内容与预设字符串匹配为止。这个小项目用到 while 循环和 if 语句，非常贴近期末考试中的任务风格。
8. Cybersecurity and Ethical Issues | 网络安全与伦理问题
Modern computing also requires you to understand safety and legality. The course addresses threats such as malware, phishing, and social engineering, as well as protective measures like firewalls, encryption, and strong password policies. You must also discuss the ethical implications of technology, including privacy, copyright, and the digital divide.
现代计算还要求你理解安全与合法性。课程内容包括恶意软件、网络钓鱼、社交工程等威胁，以及防火墙、加密和强密码策略等防护措施。你还必须讨论技术的伦理影响，包括隐私、版权和数字鸿沟。
Read tech news articles over the summer and ask yourself: what security flaw was exploited? What could have prevented it? Relate these real-world cases to the theory you will study. For instance, a ransomware attack often targets poor backup practices and weak passwords – exactly the topics listed in the Computer Systems unit.
暑假期间阅读科技新闻，并问问自己：利用了哪个安全漏洞？本可以如何防范？将这些真实案例与将要学习的理论联系起来。例如，勒索软件攻击往往针对备份不足和弱密码——这些正是计算机系统单元中列出的主题。
9. Exam Technique and Revision Strategies | 考试技巧与复习策略
The SQA question paper includes multiple-choice, short-answer, and extended-response questions. Many learners lose marks because they do not read the command words: 'describe', 'explain', 'identify', and 'compare' each require a different depth of answer. Practice past paper questions under timed conditions during the holidays to get familiar with this style.
SQA 笔试卷包含选择题、简答题和扩展回答题。许多学生因为不注意指令词而失分：'describe'、'explain'、'identify' 和 'compare' 对回答的深度要求各不相同。假期里进行限时真题练习，可以帮助你熟悉这种出题风格。
Create a revision timetable that spreads topics across several weeks. Use colour-coded summary notes for each unit, and regularly test yourself on definitions like 'algorithm', 'iteration', 'database', and 'referential integrity'. The summer is the best time to build these habits without the pressure of impending deadlines.
制定一份将各主题分散到数周的复习时间表。为每个单元制作彩色编码的摘要笔记，并经常自测诸如'algorithm'（算法）、'iteration'（迭代）、'database'（数据库）、'referential integrity'（参照完整性）等定义。暑假是培养这些习惯的最佳时机，因为没有迫在眉睫的期限压力。
10. Summer Study Plan and Resources | 暑期学习计划与资源
A structured plan can transform your summer. Aim for three 45-minute computing sessions per week. Alternate between theory (binary, systems, databases) and practical coding. Use free platforms like Replit or Thonny for Python, and for theory, the SQA website provides specimen papers and course specifications that you can download.
一份结构化的计划能改变你的暑假。目标是每周安排三次 45 分钟的计算机学习。交替进行理论学习（二进制、系统、数据库）和实践编程。使用 Replit 或 Thonny 等免费平台练习 Python；对于理论部分，SQA 官网提供了可下载的样卷和课程规范。
Keep a digital or paper journal where you write down new vocabulary, snags you encountered while coding, and reflections. At the start of term, you will have a personalised revision guide that tracks your progress. Most importantly, approach every coding bug as a learning opportunity – resilience is a key skill in computing.
准备一份数字或纸质日志，记录遇到的新词汇、编程时碰到的障碍以及反思。学期开始时，你将拥有一份追踪个人进度的个性化复习指南。最重要的是，把每个代码错误都当作学习的机会——韧性是计算科学中的一项关键技能。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图