📚 Year 9 SQA Computing: 2026 Exam Changes and Trends | Year 9 SQA 计算机：2026年考试变化与趋势
For Year 9 students in Scotland, the SQA Computing Science course represents a critical first step towards a National 5 qualification, and the 2026 exam cycle introduces a set of refined expectations and emerging trends you need to know. This guide unpacks the key updates to the syllabus, shifts in assessment style, and the skills that will be emphasised, helping you prepare with confidence and clarity.
对于苏格兰 Year 9 阶段的学生来说，SQA 计算机科学课程是通向 National 5 资格认证的关键第一步，而 2026 年考试周期带来了一系列细化的要求与新兴趋势。本指南将拆解课程大纲的关键更新、评估方式的变化以及重点考察的技能，帮助你清晰且自信地备考。
1. Refreshed Curriculum Focus 2026 | 2026 年课程重点更新
The SQA has subtly adjusted the National 5 Computing Science curriculum, placing greater weight on computational thinking and real-world application. Pure theory recall is being reduced in favour of tasks that require you to apply concepts to unfamiliar problems, especially in software design and database scenarios.
SQA 已对 National 5 计算机科学课程进行了微调，更加注重计算思维和现实世界应用。纯理论记忆的比重正在降低，取而代之的是要求你将概念应用于陌生问题的任务，尤其是在软件设计和数据库场景中。
You will find new content threads around data ethics, cloud-based collaboration, and the societal impacts of automation. These topics will appear both in the question paper and as discussion points within the practical assignment.
你将看到围绕数据伦理、基于云的协作以及自动化社会影响的新内容线索。这些主题既会出现在笔试试题中，也会作为实践作业的讨论要点出现。
2. Assessment Structure and Weightings | 评估结构与权重变化
The 2026 exam will continue to feature a question paper worth 110 marks and a practical assignment worth 50 marks, but the nature of the assignment is evolving. SQA is moving towards more integrated tasks that combine programming, web development and database queries into a single coherent project, rather than separate mini-challenges.
2026 年考试仍将包含一份 110 分的笔试试卷和一项 50 分的实践作业，但作业的性质正在演变。SQA 正趋向于采用更综合的任务，将编程、网页开发和数据库查询整合到一个连贯的项目中，而不是分散的小挑战。
Additionally, time allocations for the assignment are expected to remain at 8 hours under supervised conditions, but schools may be permitted to split this over multiple sessions. The marking criteria will emphasise testing, evaluation and clear documentation of your design process.
此外，作业的时间分配预计仍为 8 小时（受监督），但学校可能被允许将其拆分为多个时间段。评分标准将强调测试、评估以及设计过程的清晰文档记录。
Question Paper 110 marks + Assignment 50 marks → Total 160 marks
3. Programming and Algorithmic Thinking | 编程与算法思维
Python 3 remains the official reference language, and 2026 will see a stronger focus on debugging and reading pre-written code. You must be able to trace variables, identify logic errors, and suggest corrections, rather than just writing code from scratch.
Python 3 依旧是官方参考语言，2026 年将更加侧重于调试和阅读已有代码。你必须能够追踪变量、识别逻辑错误并提出修正方案，而不仅仅是从头编写代码。
Key programming constructs such as arrays (lists), loops, conditional statements (if, elif, else) and functions will be tested at a deeper level. Expect questions that ask you to modify a given function to handle additional requirements or edge cases.
关键编程结构如数组（列表）、循环、条件语句（if、elif、else）和函数将进行更深层次的测试。预计会出现要求你修改给定函数以处理额外需求或边界情况的试题。
def calculate_grade(score):
if score >= 70:
return 'A'
elif score >= 60:
return 'B'
else:
return 'C'设计和编写高效算法（如线性搜索、计数出现次数）的能力以及理解效率的基本概念（如为何避免不必要的嵌套循环）将成为高分的关键。
4. Cybersecurity, Ethics and Legislation | 网络安全、伦理与法规
A new emphasis on cybersecurity threats and ethical computing will be evident in the 2026 exam. You will need to explain how techniques like encryption, firewalls and penetration testing protect systems, and distinguish between types of malware in greater detail.
2026 年考试中将明显体现出对网络安全威胁和伦理计算的新重视。你需要解释加密、防火墙和渗透测试等技术如何保护系统，并更详细地区分不同类型的恶意软件。
Legislation such as the Computer Misuse Act, GDPR and the Data Protection Act 2018 will appear not as stand-alone facts but within scenarios requiring you to justify legal compliance and ethical decisions. Case studies may involve social media data handling or automated decision-making.
像《计算机滥用法》、GDPR 和《2018 年数据保护法》等法规不会作为孤立事实出现，而是融入需要你证明法律合规性和伦理决策的场景中。案例研究可能涉及社交媒体数据处理或自动决策。
| Threat (威胁) | Mitigation (缓解措施) |
| Phishing (钓鱼攻击) | User education, email filters (用户教育、邮件过滤) |
| Ransomware (勒索软件) | Regular backups, endpoint protection (定期备份、端点保护) |
5. Database Design and SQL Mastery | 数据库设计与SQL掌握
Entity-relationship diagrams, data types and validation are now expected to be applied in more complex, multi-table scenarios. You may be given a partially completed database and asked to identify redundancy, normalise tables, or propose suitable primary and foreign keys.
现在要求在更复杂的多表场景中应用实体关系图、数据类型和验证。你可能会拿到一个部分完成的数据库，并被要求识别冗余、规范化表或提出合适的主键和外键。
SQL queries will go beyond simple SELECT-FROM-WHERE statements. The 2026 paper is likely to include GROUP BY, ORDER BY and aggregate functions such as COUNT, AVG and SUM, alongside joining tables using INNER JOIN. Practice writing queries that extract meaningful insights from sample datasets.
SQL 查询将超越简单的 SELECT-FROM-WHERE 语句。2026 年的试卷很可能包含 GROUP BY、ORDER BY 以及聚合函数（如 COUNT、AVG、SUM），同时还有使用 INNER JOIN 连接表。练习编写从样本数据集中提取有意义见解的查询。
SELECT Subject, COUNT(*) FROM Pupils WHERE Grade = 'A' GROUP BY Subject;
6. Web Design with Modern Practices | 现代网页设计实践
HTML and CSS are being re-framed around responsive design principles. You will need to demonstrate an understanding of relative units (%, em, vh), media queries, and flexible layouts, moving beyond fixed-width tables that were common in older curricula.
HTML 和 CSS 正在围绕响应式设计原则重新定位。你需要展示对相对单位（%、em、vh）、媒体查询和灵活布局的理解，超越旧课程中常见的固定宽度表格。
The internal CSS approach remains examinable, but questions may now include analysis of external style sheets and the benefits of separating content from presentation. Expect to be asked to write CSS rules that target specific elements using class and ID selectors.
内嵌 CSS 方式仍可考查，但问题现在可能包括对外部样式表的分析以及内容与表现分离的好处。预计会要求你编写使用类和 ID 选择器定位特定元素的 CSS 规则。
Accessibility considerations, such as alt text for images, semantic HTML tags like <nav> and <main>, and colour contrast, will also feature in evaluation-style questions.
可访问性考虑因素，如图像的替代文本、语义化 HTML 标签（如 <nav> 和 <main>）以及颜色对比度，也将出现在评估类问题中。
7. Computer Systems and Network Trends | 计算机系统与网络趋势
Binary representation, floating-point storage and vector graphics are now set alongside virtual memory and embedded systems. The trend is to ask you to compare characteristics of different storage media and justify choices for given contexts, such as cloud storage versus local SSD for a business.
二进制表示、浮点数存储和矢量图形现已与虚拟内存和嵌入式系统一同设置。趋势是要求你比较不同存储介质的特性，并为特定场景（如企业选择云存储还是本地 SSD）提供理由。
Networking topics will extend beyond basic LAN topologies to include Wi-Fi standards (e.g., 5 GHz vs 2.4 GHz), IoT connectivity, and the role of protocols like MQTT. An understanding of IP addressing, DHCP and DNS will be essential, especially in troubleshooting exercises.
网络主题将超越基本的局域网拓扑，涵盖 Wi-Fi 标准（如 5 GHz 与 2.4 GHz）、物联网连接以及 MQTT 等协议的作用。理解 IP 寻址、DHCP 和 DNS 至关重要，特别是在故障排除练习中。
- Cloud computing models: IaaS, PaaS, SaaS (云计算模型：IaaS、PaaS、SaaS)
- Network hardware: switch, router, NIC, WAP (网络硬件：交换机、路由器、网卡、无线接入点)
8. Digital Literacy and Future Skills | 数字素养与未来技能
Beyond technical knowledge, the 2026 curriculum recognises that problem solving, adaptability, and evaluation are essential. You will encounter open-ended questions that require you to propose and justify a digital solution, considering user needs, budget, and environmental impact.
除了技术知识，2026 年课程认识到解决问题、适应能力和评估能力至关重要。你将遇到开放式问题，要求你提出并证明一个数字解决方案，同时考虑用户需求、预算和环境影响。
Collaboration tools such as version control (basic Git concepts) and shared online documents are being referenced more explicitly, reflecting real-world software development practices. You may need to explain how teams can work together without overwriting each other's code.
协作工具如版本控制（基本 Git 概念）和共享在线文档正被更明确地引用，反映了现实世界的软件开发实践。你可能需要解释团队如何在不覆盖彼此代码的情况下协同工作。
9. Exam Technique and Marking Insights | 考试技巧与评分洞察
Command words like 'describe', 'explain', 'compare' and 'evaluate' have precise meanings that SQA markers look for. 'Evaluate' requires a balanced judgement with a conclusion, while 'compare' needs points of similarity and difference. Memorising definitions is not enough; you must apply them in context.
像 'describe'、'explain'、'compare' 和 'evaluate' 这样的指令词具有 SQA 评分者所寻求的精确含义。'Evaluate' 要求给出带结论的平衡判断，而 'compare' 需要列出相似点和不同点。仅仅背诵定义是不够的，你必须在语境中应用它们。
Time management is critical. The question paper is 2 hours long, and the assignment demands sustained focus. Practise past papers under timed conditions, and always review the marking schemes to understand where marks are awarded for partial answers or annotation of code.
时间管理至关重要。笔试试卷为 2 小时，实践作业需要持续专注。在计时条件下练习历年真题，并始终复习评分方案，以了解何处会因部分答案或代码注释而给分。
10. Recommended Resources and Preparation Pathways | 推荐资源与备考路径
SQA provides specimen papers and coursework assessment tasks on its official website, which are regularly updated to reflect 2026 expectations. Use these alongside the National 5 Computing Science course specification to map your revision to every mandatory topic.
SQA 在其官方网站上提供了样卷和课程作业评估任务，这些材料会定期更新以反映 2026 年的要求。结合 National 5 计算机科学课程规范使用这些材料，将你的复习重点对应到每一个必修主题。
Dynamic learning tools such as interactive Python environments (Thonny, replit) and SQL practice platforms (SQLite online) can turn theory into practical skill. For web design, building a small portfolio site that adjusts to mobile and desktop views will deepen your understanding of responsive CSS.
动态学习工具如交互式 Python 环境（Thonny、replit）和 SQL 练习平台（SQLite 在线版）可以将理论转化为实用技能。对于网页设计，构建一个能适应移动和桌面视图的小型作品集网站将加深你对响应式 CSS 的理解。
Join study groups or forums where you can discuss challenging past paper questions and share debugging tips. Explaining a concept to someone else is one of the most effective ways to reveal gaps in your own knowledge.
加入学习小组或论坛，在其中讨论富有挑战性的历年真题并分享调试技巧。向他人解释一个概念是暴露你自己知识漏洞的最有效方法之一。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图