aleveler.com

Year 10 SQA Computing: Transition and Bridging Guide | 升学衔接指南

Written by

in

📚 Year 10 SQA Computing: Transition and Bridging Guide | 升学衔接指南

Embarking on the SQA Computing Science course in Year 10 is an exciting step towards mastering digital skills and computational thinking. This guide will help you understand what to expect, how to prepare, and the key concepts you need to bridge into advanced studies. Whether you are transitioning from a different curriculum or continuing your computing journey, this article provides a comprehensive overview to ensure a smooth and successful start.

在Year 10开始SQA计算机科学课程是掌握数字技能和计算思维的激动人心的一步。本指南将帮助你了解课程期待、如何准备，以及需要衔接的关键概念，以便顺利进阶。无论你从不同课程过渡，还是继续计算机学习，本文均提供全面概览，确保平稳并成功的开端。

1. Understanding the SQA Computing Science Course | 了解SQA计算机科学课程

The SQA Computing Science course at National 5 level is divided into four main areas: Software Design and Development, Computer Systems, Database Design and Development, and Web Design and Development. Each area builds foundational knowledge that is essential for progression to Higher Computing Science.

SQA国家级5等计算机科学课程分为四个主要领域：软件设计与开发、计算机系统、数据库设计与开发、网页设计与开发。每个领域都奠定必要的基础知识，为进阶到高级计算机科学做好准备。

Assessment includes a question paper exam (worth 60% of the final grade) and a practical assignment (worth 40%). The assignment tests your ability to apply computational thinking to solve real-world problems using a combination of the four units.

考核包括试卷考试（占最终成绩的60%）和实践作业（占40%）。作业测试你运用计算思维解决实际问题的能力，需综合运用四个单元的知识。

2. Computational Thinking: The Core Skill | 计算思维：核心技能

Computational thinking underpins everything you do in computing. It involves four pillars: decomposition (breaking down a large problem into smaller, manageable parts), pattern recognition (identifying similarities or trends), abstraction (filtering out unnecessary details), and algorithm design (creating step-by-step instructions to solve a problem).

计算思维是你进行一切计算机活动的基础。它包括四大支柱：分解（将大问题拆解为更小、可管理的部分）、模式识别（识别相似性或趋势）、抽象化（过滤掉不必要的细节）和算法设计（创建逐步解决问题的指令）。

For example, when building a web page, you decompose the layout into header, navigation, and content sections. You recognise patterns in colour schemes or styles. You abstract away the actual text to focus on structure, and you design an algorithmic approach to your code.

例如，构建网页时，你将布局分解为页眉、导航和内容部分。你识别配色方案或样式中的模式。你抽象出实际文本，专注于结构，并为代码设计算法方法。

3. Programming Fundamentals: From Scratch to Python | 编程基础：从Scratch到Python

In Year 10, you will typically transition from block-based environments like Scratch to a text-based language, most commonly Python. This shift requires you to pay close attention to syntax – where a misplaced colon or indent can break your program.

在Year 10，你通常会从Scratch这类积木式环境过渡到文本语言，最常见的是Python。这一转变要求你高度关注语法——一个错位的冒号或缩进都可能导致程序崩溃。

Key programming concepts you must master: variables (storing data), data types (integers, floats, strings, Booleans), input/output statements, conditional statements (if, elif, else), loops (for and while), and basic data structures like lists.

你必须掌握的关键编程概念：变量（存储数据）、数据类型（整型、浮点型、字符串、布尔型）、输入/输出语句、条件语句（if、elif、else）、循环（for和while）以及列表等基本数据结构。

A well-rehearsed skill is using indentation to define code blocks, and testing your programs with a range of normal, boundary, and erroneous data. Always aim to write readable code with meaningful variable names.

一项应熟练掌握的技能是使用缩进定义代码块，并用正常值、边界值和错误数据测试程序。始终力求编写可读性强、变量名称有意义的代码。

4. Computer Systems: Hardware and Software | 计算机系统：硬件与软件

A solid grasp of computer architecture is required. You will study the central processing unit (CPU) and its fetch-decode-execute cycle, where instructions are fetched from memory, decoded to determine what action is needed, and executed.

你需要牢固掌握计算机体系结构。你将学习中央处理器（CPU）及其取指-译码-执行循环：从内存中取出指令，译码以确定所需操作，然后执行。

The performance of a processor is influenced by its clock speed (measured in GHz), the number of cores, and the size of cache memory. You should be able to compare specifications and explain the impact on multitasking and speed.

处理器的性能受其时钟速度（以GHz为单位）、核心数量和缓存大小的影响。你应能够比较规格，并解释对多任务处理和速度的影响。

Other vital components include RAM (temporary, volatile memory that holds data and programs currently in use), ROM (non-volatile memory storing boot instructions), and various storage devices like SSDs and HDDs.

其他重要组件包括RAM（临时、易失性存储器，保存当前使用的数据和程序）、ROM（存储启动指令的非易失性存储器）以及SSD和HDD等各种存储设备。

5. Data Representation: The Language of Computers | 数据表示：计算机的语言

All data inside a computer is represented as binary digits (bits), 0 or 1. You must be confident converting between binary and denary (base-10), and calculating the maximum decimal value for a given number of bits.

计算机内部所有数据都表示为二进制数字（比特），即0或1。你必须能自信地在二进制和十进制（基数为10）之间转换，并计算给定位数所对应的最大十进制值。

For example, an 8‑bit binary number such as 11001010 can be converted to decimal by placing it under column headings:

例如，8位二进制数11001010可通过将其置于列标题下转换为十进制：

11001010₂ = 1×2⁷ + 1×2⁶ + 0×2⁵ + 0×2⁴ + 1×2³ + 0×2² + 1×2¹ + 0×2⁰ = 202₁₀

You will also learn how negative integers are stored using two’s complement, and how floating-point representation works for real numbers. Text is represented using ASCII or Unicode, with extended ASCII using 8 bits per character.

你还将学习如何使用二进制补码存储负整数，以及浮点数表示法如何处理实数。文本使用ASCII或Unicode表示，扩展ASCII每个字符使用8个比特。

6. Networks and the Internet | 网络与互联网

Networking enables communication between computing devices. You will encounter local area networks (LANs) and wide area networks (WANs), and be able to describe network topologies such as star and bus.

网络实现了计算设备之间的通信。你将遇到局域网（LAN）和广域网（WAN），并能够描述星型和总线型等网络拓扑结构。

Protocols are the rules that govern data transmission. TCP/IP is the suite responsible for sending data packets reliably across the Internet, HTTP governs web page requests, and FTP transfers files.

协议是管理数据传输的规则。TCP/IP协议族负责在Internet上可靠地发送数据包，HTTP管理网页请求，FTP用于文件传输。

Devices on a network are identified by IP addresses and MAC addresses. You should understand how a client-server model differs from a peer-to-peer model, and the advantages of each.

网络上的设备由IP地址和MAC地址标识。你应理解客户端-服务器模型与对等网络模型的不同之处，以及各自的优势。

7. Database Design and Development | 数据库设计与开发

Databases organise data into tables made up of fields (columns) and records (rows). Relational database concepts such as primary keys (unique identifiers) and foreign keys (links between tables) are central to this unit.

数据库将数据组织成由字段（列）和记录（行）构成的表。关系数据库概念，如主键（唯一标识符）和外键（表之间的链接），是本单元的核心。

You’ll practise using SQL to query databases. A typical retrieval query might be:

你将练习使用SQL查询数据库。一个典型的检索查询可能如下：

SELECT name, grade FROM Students WHERE grade >= 70 ORDER BY name ASC;

Data validation techniques help ensure accuracy: presence checks, length checks, range checks, and restricted choice (dropdown lists) are commonly tested.

数据验证技术有助于确保准确性：存在检查、长度检查、范围检查和限制性选择（下拉列表）是常考内容。

8. Web Design and Development | 网页设计与开发

You will create multimedia web pages using HTML for structure and CSS for presentation. Tags for headings (

–

), paragraphs (

), images (), hyperlinks (), and lists (