📚 Year 9 SQA Computing: Bridging Guide for Senior Phase | Year 9 SQA 计算机：升学衔接指南
Moving from the Broad General Education (BGE) into the Senior Phase is a pivotal moment for Year 9 students in Scotland. This guide unpacks what to expect in SQA Computing Science, how to build on your existing digital skills, and how to prepare confidently for National 5 and beyond.
从广泛通识教育（BGE）过渡到高年级阶段是苏格兰Year 9学生的重要转折点。本指南将详细解读SQA计算机科学课程的要求，如何巩固你已有的数字技能，并自信地为National 5以及更高阶段的课程做好准备。
1. Understanding the Scottish Computing Curriculum Pathway | 理解苏格兰计算机课程路径
In S1 to S3, you follow the Broad General Education, covering digital literacy, basic programming and computational thinking across a range of contexts. From S4 onwards, you move into Senior Phase qualifications, typically starting with National 5 Computing Science.
在S1到S3阶段，你学习的是广泛通识教育，内容涵盖数字素养、基础编程以及在不同情境下的计算思维。从S4开始，你将进入高年级阶段的资格考试，通常从National 5计算机科学起步。
The SQA Computing Science progression is designed so that National 5 lays the groundwork for Higher and Advanced Higher. Understanding this pathway helps you see the bigger picture and set clear goals.
SQA计算机科学的课程进阶设计是让National 5为Higher和Advanced Higher打下基础。理解这一路径能帮助你看到整体的学习蓝图并设定清晰的目标。
2. Key Differences Between BGE and National 5 | 从BGE到National 5的关键变化
In BGE, learning is often topic-based and assessed through teacher-observed outcomes. National 5 introduces a formal exam and an externally moderated coursework assignment, requiring much more independence and depth of understanding.
在BGE阶段，学习通常是基于主题的，并通过教师观察来评估。National 5则引入了正式考试和外部审核的课程作业，要求更强的独立性和更深层次的理解。
You will also be expected to use more precise technical vocabulary, read code and diagrams with confidence, and explain the reasons behind your design choices — not just describe what you did.
你还需要使用更精确的技术词汇，自信地阅读代码和图表，并解释你设计决策背后的原因——而不仅仅是描述你做了什么。
3. Core Units Overview: Software Design and Development | 核心单元概览：软件设计与开发
This unit focuses on the process of creating software, from analysing a problem to designing, implementing, testing and evaluating a solution. You will learn to write programs in a text-based language such as Python or LiveCode.
本单元关注软件开发的全过程，从分析问题到设计、实现、测试和评估解决方案。你将学习使用Python或LiveCode等文本式编程语言编写程序。
Expect to work with variables, assignment, selection constructs (if statements), iteration (loops), and data structures like arrays. You will also learn about standard algorithms such as linear search and bubble sort.
你需要掌握变量、赋值、选择结构（if语句）、循环（迭代）以及数组等数据结构。你还将学习线性查找和冒泡排序等标准算法。
- Design notations: pseudocode, structure diagrams, flowcharts.
- 设计符号：伪代码、结构图、流程图。
- Testing: normal, boundary and exceptional test data.
- 测试：正常、边界和异常测试数据。
- Evaluation: fitness for purpose, efficiency, readability.
- 评估：适用性、效率、可读性。
4. Core Units Overview: Information System Design and Development | 核心单元概览：信息系统设计与开发
Here you explore how to design and build databases and websites that meet user needs. The focus is on practical skills: writing SQL queries, creating relational databases, and using HTML/CSS to construct web pages.
本单元你将探索如何设计和构建满足用户需求的数据库与网站。重点在于实践技能：编写SQL查询、创建关系型数据库，以及使用HTML和CSS构建网页。
Key database concepts include tables, primary keys, foreign keys, and the importance of reducing data redundancy through normalisation. You do not need to perform full normalisation, but understanding its purpose is essential.
关键的数据库概念包括表、主键、外键，以及通过规范化减少数据冗余的重要性。你不需要进行完整的规范化操作，但理解其目的是必不可少的。
- SQL statements: SELECT, FROM, WHERE, ORDER BY, JOIN.
- SQL语句：SELECT、FROM、WHERE、ORDER BY、JOIN。
- Web development: head and body sections, CSS styling, hyperlinks.
- 网页开发：头部和主体部分、CSS样式、超链接。
- User interface design: consistency, navigation, readability.
- 用户界面设计：一致性、导航、可读性。
5. Core Units Overview: Computer Systems | 核心单元概览：计算机系统
This unit covers the hardware and software that make up a computer, how data is represented in binary, and fundamental networking concepts. It is the part of the course that ties the abstract to the physical machine.
本单元涵盖了组成计算机的硬件和软件、数据如何用二进制表示，以及基础的网络概念。这是将抽象概念与物理机器联系起来的课程部分。
You will need to be able to describe the function of the processor (ALU, control unit, registers), explain the fetch-execute cycle, and distinguish between RAM and ROM. You will also compare different types of storage according to speed, capacity and cost.
你需要能描述处理器（ALU、控制单元、寄存器）的功能，解释取指-执行周期，并区分RAM和ROM。你还需要根据速度、容量和成本比较不同类型的存储设备。
- Binary and floating point representation of numbers.
- 数字的二进制和浮点数表示。
- ASCII and Unicode for text.
- 字符的ASCII和Unicode编码。
- Bitmap graphics: resolution, colour depth.
- 位图图像：分辨率、颜色深度。
- Networks: LAN, WAN, client-server, cloud services.
- 网络：局域网、广域网、客户端-服务器、云服务。
6. Building Programming Confidence: Moving from Blocks to Text | 培养编程信心：从积木式编程转向文本编程
Many of you will have used Scratch or similar block-based tools. The transition to Python is a big step, but the underlying logic remains the same. Start by writing small programs that solve a single problem, then gradually increase complexity.
你们中的许多人可能使用过Scratch或类似的积木式工具。转向Python是一个大跨步，但底层的逻辑是相同的。从编写解决单个问题的小程序开始，然后逐渐增加复杂性。
Practice reading code aloud to explain what each line does. This builds your mental model of how the computer executes instructions. Use comments and meaningful variable names from the very beginning — it is a habit that will pay off in the assignment.
练习大声读代码并解释每一行的作用。这有助于建立你对计算机如何执行指令的心智模型。从一开始就使用注释和有意义的变量名——这个习惯在课程作业中会带来回报。
Don’t be afraid of syntax errors. They are your best learning tool. Every error message tells you something; learn to read them carefully and trace the problem back to its cause.
不要害怕语法错误。它们是你最好的学习工具。每一条错误信息都告诉你一点信息；学会仔细阅读它们并追溯到问题的根源。
7. Mastering Databases and SQL Foundations | 掌握数据库和SQL基础
Databases underpin almost every modern information system. At National 5 level, you need to create a relational database with at least two linked tables and write queries to extract meaningful information.
数据库支撑着几乎每一个现代信息系统。在National 5阶段，你需要创建一个至少包含两个关联表的关系型数据库，并编写查询来提取有意义的信息。
Focus on understanding the different data types (text, number, date), setting primary and foreign keys correctly, and constructing simple SELECT queries. Remember that a foreign key creates the link between tables.
重点在于理解不同的数据类型（文本、数字、日期），正确设置主键和外键，以及构建简单的SELECT查询。记住，外键创建了表之间的链接。
Use the school’s database software (usually Microsoft Access or a web-based tool) to practise building queries in design view and then viewing the generated SQL. This demystifies the language and helps you spot logical errors.
使用学校的数据库软件（通常是Microsoft Access或基于网页的工具）在设计视图中练习构建查询，然后查看生成的SQL。这将揭开SQL语言的神秘面纱，并帮助你发现逻辑错误。
8. Web Design and HTML/CSS Essentials | 网页设计与HTML/CSS必备知识
The web unit asks you to create a multi-page website with a consistent layout and navigation. You are assessed on both the code and the final user experience. Clean, semantic HTML and a separate CSS file are best practice.
网页单元要求你创建一个具有一致布局和导航的多页面网站。评估既关注代码也关注最终的用户体验。简洁、语义化的HTML和单独的CSS文件是最佳实践。
Learn to use common tags like <h1> to <h6>, <p>, <img>, <a>, <ul> and <div>. In CSS, master selectors, the box model, fonts, colours and simple layout techniques. Avoid using deprecated tags such as <center> or inline styling.
学习使用常见的标签，如<h1>到<h6>、<p>、<img>、<a>、<ul>和<div>。在CSS中，掌握选择器、盒模型、字体、颜色和简单的布局技巧。避免使用已废弃的标签，如<center>或内联样式。
Remember that good design is about communication, not decoration. Your navigation should be intuitive, text readable, and images properly optimised. Write a brief evaluation detailing how your site meets the identified user needs.
请记住，好的设计是关于沟通，而不是装饰。你的导航应该直观，文本易读，图像经过适当优化。撰写一份简短的评估，详细说明你的网站如何满足已识别出的用户需求。
9. Diving into Computer Architecture and Data Representation | 深入计算机体系结构与数据表示
To do well in the Computer Systems unit, you must be able to describe the internal parts of a processor and how they work together. The classic model has the processor, memory, input/output controllers and address/data buses.
要在计算机系统单元取得好成绩，你必须能够描述处理器的内部部件以及它们如何协同工作。经典模型包括处理器、存储器、输入/输出控制器以及地址和数据总线。
Understand how instructions are fetched from memory and executed. The fetch-execute cycle involves the memory address register (MAR), memory data register (MDR), instruction register (IR) and program counter (PC).
理解指令如何从内存取出并执行。取指-执行周期涉及内存地址寄存器（MAR）、内存数据寄存器（MDR）、指令寄存器（IR）和程序计数器（PC）。
For data representation, practise converting between denary, binary and hexadecimal. Know how to calculate the size of a bitmap image (width × height × colour depth) and how text is stored using ASCII or Unicode.
在数据表示方面，练习在十进制、二进制和十六进制之间转换。知道如何计算位图图像的大小（宽度 × 高度 × 颜色深度）以及如何使用ASCII或Unicode存储文本。
Text size (in bytes) = number of characters × bits per character ÷ 8
文本大小（字节）= 字符数 × 每字符比特数 ÷ 8
10. Security, Legislation and Environmental Impact | 安全、立法与环境影响
Modern computing carries ethical and legal responsibilities. The SQA course expects you to discuss the Computer Misuse Act, Data Protection Act and Copyright, Designs and Patents Act, among others.
现代计算领域伴随着道德和法律责任。SQA课程期望你能够讨论《计算机滥用法》、《数据保护法》和《版权、设计和专利法》等法律。
You should also be aware of security threats such as malware, phishing, denial-of-service attacks, and encryption techniques like symmetric and asymmetric keys. Describe how firewalls and anti-malware software protect systems in a networked world.
你还应该了解恶意软件、钓鱼攻击、拒绝服务攻击等安全威胁，以及对称密钥和非对称密钥等加密技术。描述防火墙和反恶意软件如何在网络世界中保护系统。
From an environmental perspective, be prepared to explain the energy consumption of data centres, e-waste disposal, and the potential of smart technologies to reduce carbon footprints.
从环境的角度，准备好解释数据中心的能源消耗、电子废弃物处理，以及智能技术在减少碳足迹方面的潜力。
11. Study Strategies and Resources for Success | 学习策略与成功资源
Active revision is essential. Instead of simply rereading notes, create your own summary tables, flashcards for key definitions, and mind maps linking the three course units. Explain concepts to a friend — teaching someone else is one of the most effective ways to learn.
主动复习至关重要。不要只是重读笔记，而是要创建自己的总结表格、关键定义闪卡，以及连接三个课程单元的思维导图。向朋友解释概念——教别人的过程是最有效的学习方式之一。
Use past papers available on the SQA website. Start with the specimen papers, then move on to previous years. Time yourself strictly and review the marking schemes to understand exactly what examiners are looking for.
使用SQA网站上的历年真题。从样卷开始，然后逐步过渡到往年的试卷。严格计时，并仔细研究评分方案，确切理解考官期望的答案。
- SQA Computing Science National 5 page: official documents and past papers.
- SQA计算机科学National 5页面：官方文件和历年真题。
- BBC Bitesize: concise revision materials aligned to the Scottish curriculum.
- BBC Bitesize：与苏格兰课程对齐的简洁复习资料。
- Online coding platforms: repl.it or Python’s official tutorial for extra coding practice.
- 在线编程平台：repl.it或Python官方教程进行额外编程练习。
12. Preparing for the Assignment and Final Exam | 准备课程作业与期末考试
The coursework assignment is worth 31% of your final grade. You will be given a brief describing a problem, and you must produce a software solution along with supporting documentation. Plan your time meticulously — analysis, design, implementation, testing and evaluation all need attention.
课程作业占最终成绩的31%。你将收到一份描述问题的任务概要，需要提交软件解决方案及支持文档。精细地规划你的时间——分析、设计、实现、测试和评估都需要顾及。
For the exam, practise reading questions very carefully. Command words like ‘describe’, ‘explain’, ‘compare’ and ‘evaluate’ require different depths of response. A ‘describe’ answer can be straightforward, but an ‘explain’ requires the reasoning behind the fact.
对于考试，练习仔细阅读题目。诸如’描述’、’解释’、’比较’和’评估’等指令词要求不同的作答深度。’描述’类的答案可以直截了当，但’解释’需要事实背后的推理。
Exam success = technical accuracy + clarity + application to context
考试成功 = 技术准确性 + 清晰度 + 结合情境的应用
Build a revision timetable that revisits each unit at least three times before the exam. Mix short, focused sessions with longer problem-solving blocks. Make sure you are comfortable with the command words and the structure of the paper before exam day.
制定一个复习时间表，确保在考试前每个单元至少复习三次。将短时间的高专注度学习与较长时间的解决问题模块相结合。确保在考试之前你对指令词和试卷结构都了然于胸。
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课程辅导，国外大学本科硕士研究生博士课程论文辅导