📚 KS3 Cambridge Computing: Core Knowledge Review | KS3剑桥计算机：核心知识点梳理
This article provides a comprehensive overview of the core topics covered in the Cambridge KS3 Computing curriculum. It is designed to help students consolidate key concepts in digital literacy, computational thinking, programming, data representation, computer systems, networking, and online safety. Each section introduces essential ideas in both English and Chinese, making it ideal for bilingual revision and classroom support.
本文全面梳理了剑桥KS3计算机课程的核心知识点，旨在帮助学生巩固数字素养、计算思维、编程、数据表示、计算机系统、网络和在线安全等方面的关键概念。每个小节都以中英双语介绍核心要点，非常适合双语复习和课堂教学辅助。
1. What is Computational Thinking? | 什么是计算思维？
Computational thinking is the problem-solving process that involves breaking down complex problems into smaller, manageable parts. The four key techniques are decomposition, pattern recognition, abstraction, and algorithm design. These skills are not only used in computer science but are transferable to many other subjects and real-life situations.
计算思维是一种将复杂问题分解为更小、可管理部分的解决问题过程。它的四个关键技术是分解、模式识别、抽象和算法设计。这些技能不仅用于计算机科学，还可以迁移到许多其他学科和现实生活情境中。
Decomposition means splitting a large task into smaller sub-tasks that are easier to understand and solve. For example, planning a school trip can be broken down into transport, meals, activities, and supervision. In programming, a large project is divided into functions or modules.
分解是指将一个大型任务拆分成更小、更容易理解和解决的子任务。例如，策划一次学校旅行可以分解为交通、餐饮、活动和监督。在编程中，一个大型项目被划分为函数或模块。
Pattern recognition involves spotting similarities and trends in data or problems. By identifying patterns, we can reuse solutions that have worked before, saving time and effort. In coding, recognising that a loop is needed when a block of instructions repeats is a classic example.
模式识别涉及发现数据或问题中的相似点和趋势。通过识别模式，我们可以重复使用以往有效的解决方案，节省时间和精力。在编程中，当一段指令重复出现时，识别出需要使用循环就是一个典型的例子。
Abstraction is about filtering out unnecessary details and focusing only on what is important. A map of the London Underground is a great example – it does not show exact distances or landmarks, only the stations and their connections, making the route planning process much simpler.
抽象是关于过滤掉不必要的细节，只关注重要的部分。伦敦地铁图就是一个很好的例子——它不显示确切的距离或地标，只显示车站及其连接，这使路线规划过程变得简单得多。
Algorithm design is the process of creating a step-by-step set of instructions to solve a problem. Algorithms can be expressed using flowcharts or pseudocode. They must be precise and cover all possible inputs to be effective.
算法设计是创建逐步指令集以解决问题的过程。算法可以使用流程图或伪代码表示。它们必须精确，并涵盖所有可能的输入，才能有效。
2. Sequence, Selection, and Iteration | 顺序、选择和迭代
The three fundamental control structures in programming are sequence, selection, and iteration. Any program, no matter how complex, can be built using these three building blocks. Understanding them is essential for writing effective code in languages such as Python, which is commonly used at KS3.
编程中的三种基本控制结构是顺序、选择和迭代。任何程序，无论多复杂，都可以用这三个构建模块来编写。理解它们对于使用KS3阶段常用的Python等语言编写有效代码至关重要。
Sequence means executing instructions one after another, in the order they appear. This is the simplest form of program flow. In Python, writing a series of print statements or assignment statements demonstrates sequence.
顺序意味着按照指令出现的顺序逐一执行。这是最简单的程序流程形式。在Python中，编写一系列print语句或赋值语句就是顺序的体现。
Selection allows the program to make decisions based on conditions. This is typically implemented using if, elif, and else statements. For example, a program can check whether a user’s age is greater than or equal to 13 before granting access to a website, directing different paths for different inputs.
选择允许程序根据条件做出决策。这通常使用if、elif和else语句来实现。例如，一个程序可以检查用户的年龄是否大于或等于13岁，然后决定是否授予网站访问权限，为不同的输入指引不同的路径。
Iteration means repeating a block of code multiple times. There are two main types: count-controlled loops (for loops) and condition-controlled loops (while loops). A for loop is useful when you know in advance how many times to repeat, such as printing the 7 times table up to 12. A while loop continues as long as a condition remains true, such as asking for a password until the correct one is entered.
迭代意味着多次重复一个代码块。主要有两种类型：计数控制循环（for循环）和条件控制循环（while循环）。当你事先知道需要重复多少次时，for循环非常有用，例如打印7的乘法表直到12。while循环则只要条件保持为真就会继续，例如反复要求输入密码直到输入正确为止。
3. Variables and Data Types | 变量与数据类型
Variables are named storage locations in a program that hold values which can change during execution. When you assign a value to a variable, you are telling the computer to reserve a space in memory. In Python, assigning a variable is as simple as writing score = 0.
变量是程序中命名的存储位置，用于存放可以在执行过程中改变的值。当你给变量赋值时，就是告诉计算机在内存中预留一个空间。在Python中，赋值变量很简单，只需写score = 0。
Data types define the kind of data a variable can hold. The basic data types in most KS3 languages are integer (whole numbers), float (decimal numbers), string (text), and Boolean (True or False). Choosing the correct data type is important because operations behave differently; adding two integers gives a sum, while adding two strings concatenates them.
数据类型定义了变量可以持有的数据种类。大多数KS3语言中的基本数据类型包括整型（整数）、浮点型（小数）、字符串（文本）和布尔型（True或False）。选择正确的数据类型很重要，因为操作的行为不同；将两个整数相加得到和，而将两个字符串相加则会将它们拼接起来。
Type casting or conversion is often needed when input is received from the user. The input() function in Python always returns a string, so if you want a number you must convert it using int() or float(). Understanding this prevents common errors like trying to perform arithmetic on a string.
当从用户那里接收输入时，常常需要进行类型转换。Python中的input()函数总是返回字符串，因此如果你想要一个数字，必须使用int()或float()进行转换。理解这一点可以避免诸如试图对字符串进行算术运算的常见错误。
4. Data Representation: Binary and Beyond | 数据表示：二进制及其他
All data inside a computer is stored and processed as binary digits – 0s and 1s. Each binary digit is called a bit. Eight bits form a byte, which can represent one character or a small number. Understanding binary is fundamental to understanding how computers work at the hardware level.
计算机内部的所有数据都以二进制数字（0和1）的形式存储和处理。每个二进制数字称为一位。八位组成一个字节，可以表示一个字符或一个小数字。理解二进制是理解计算机在硬件层面如何工作的基础。
To convert a binary number like 1011₂ to decimal, we use place values that are powers of 2 (from right to left: 1, 2, 4, 8, …). Thus, 1011₂ = 1×8 + 0×4 + 1×2 + 1×1 = 11. To convert decimal to binary, repeatedly divide by 2 and note the remainders.
要将像1011₂这样的二进制数转换为十进制，我们使用2的幂作为位值（从右向左：1、2、4、8……）。因此，1011₂ = 1×8 + 0×4 + 1×2 + 1×1 = 11。要将十进制转换为二进制，反复除以2并记录余数。
Characters are represented using standard codes such as ASCII and Unicode. ASCII uses 7 bits to represent 128 characters including English letters, digits, and symbols. Unicode extends this to represent characters from virtually all writing systems, using up to 32 bits per character. Images can be stored as bitmaps where each pixel’s colour is encoded in binary; sound is sampled and each sample’s amplitude is stored as a binary number.
字符使用ASCII和Unicode等标准码表示。ASCII使用7位表示128个字符，包括英文字母、数字和符号。Unicode对此进行了扩展，几乎可以表示所有书写系统的字符，每个字符最多使用32位。图像可以存储为位图，其中每个像素的颜色用二进制编码；声音通过采样，每个样本的振幅存储为二进制数。
5. Computer Hardware and Software | 计算机硬件与软件
Computer systems consist of physical components called hardware and the programs that run on them called software. Hardware includes input devices such as keyboards and mice, output devices such as monitors and speakers, and processing and storage components inside the system unit.
计算机系统由称为硬件的物理组件和在其上运行的称为软件的程序组成。硬件包括输入设备（如键盘和鼠标）、输出设备（如显示器和扬声器）以及系统单元内部的处理和存储组件。
The central processing unit (CPU) is the brain of the computer. It follows the fetch–decode–execute cycle: it fetches an instruction from memory, decodes it to understand what to do, and then executes it. Modern CPUs contain multiple cores, allowing them to process several instructions simultaneously.
中央处理器（CPU）是计算机的大脑。它遵循取指令、解码、执行的循环：从内存中取出一条指令，解码以理解要做什么，然后执行该指令。现代CPU包含多个核心，使它们能够同时处理多条指令。
Memory is divided into volatile primary memory (RAM) and non-volatile secondary storage. RAM holds data and programs currently in use and loses its contents when power is off. Secondary storage, such as hard disk drives (HDD) and solid-state drives (SSD), retains data permanently. The speed, capacity, and cost of these storage types vary, influencing which one is chosen for a particular task.
存储器分为易失性主存储器（RAM）和非易失性辅助存储器。RAM保存当前正在使用的数据和程序，断电后内容丢失。辅助存储器，如硬盘驱动器（HDD）和固态驱动器（SSD），则永久保留数据。这些存储类型在速度、容量和成本上各不相同，这影响了针对特定任务的选择。
Software is split into system software and application software. The operating system (OS) is system software that manages hardware resources, provides a user interface, and enables applications to run. Examples include Microsoft Windows, macOS, and Linux. Application software helps users perform specific tasks, such as word processors, spreadsheets, and games.
软件分为系统软件和应用软件。操作系统（OS）是管理硬件资源、提供用户界面并允许应用程序运行的系统软件。例如Microsoft Windows、macOS和Linux。应用软件帮助用户执行特定任务，如文字处理器、电子表格和游戏。
6. Networks and the Internet | 网络与互联网
A network is a collection of computers and devices connected together to share resources and communicate. Networks can be classified by size: a Local Area Network (LAN) covers a small geographical area like a school or office; a Wide Area Network (WAN) connects LANs over large distances, with the Internet being the largest WAN.
网络是一组连接在一起的计算机和设备，用于共享资源和通信。网络可以按规模分类：局域网（LAN）覆盖像学校或办公室这样的小地理区域；广域网（WAN）将远距离的局域网连接起来，互联网是最大的广域网。
Networks use various hardware such as switches, routers, and wireless access points. A switch connects devices within a LAN and forwards data based on MAC addresses. A router connects different networks and forwards data based on IP addresses, enabling communication across the Internet.
网络使用各种硬件，如交换机、路由器和无线接入点。交换机在局域网内连接设备，并根据MAC地址转发数据。路由器连接不同的网络，并根据IP地址转发数据，实现跨互联网的通信。
The Internet is a global system of interconnected networks that uses the TCP/IP protocol suite. Data is broken into packets, each with a source and destination address. Packets may travel different routes and are reassembled at the destination. The World Wide Web (WWW) is a service that runs on the Internet, using HTTP/HTTPS to transfer web pages.
互联网是一个使用TCP/IP协议套件的全球互联网络系统。数据被分割成数据包，每个数据包都有源地址和目的地址。数据包可能经过不同的路由，并在目的地重新组装。万维网（WWW）是运行在互联网上的一种服务，使用HTTP/HTTPS传输网页。
7. E-Safety and Digital Citizenship | 网络安全与数字公民
Staying safe online is a critical part of the KS3 computing curriculum. Students learn about potential risks such as cyberbullying, phishing, malware, and identity theft. They also explore strategies to protect themselves and behave responsibly in digital environments.
保持网络安全是KS3计算机课程的重要组成部分。学生学习潜在的风险，如网络欺凌、网络钓鱼、恶意软件和身份盗窃。他们还探索保护自己并在数字环境中负责任地行为的策略。
Strong passwords and two-factor authentication are the first line of defence. A strong password is long, contains a mix of letters, numbers, and symbols, and is not shared with others. Phishing emails try to trick users into revealing personal information; students should always check the sender’s address and avoid clicking suspicious links.
强密码和双重认证是第一道防线。强密码应该足够长，包含字母、数字和符号的混合，并且不与他人共享。网络钓鱼邮件试图诱骗用户透露个人信息；学生应始终检查发件人地址，避免点击可疑链接。
Digital citizenship means using technology ethically and respectfully. This includes respecting copyright, acknowledging sources, and not sharing inappropriate content. Students must also understand the permanence of their online actions; posts and comments can exist forever and affect future opportunities.
数字公民意味着以合乎道德和尊重的方式使用技术。这包括尊重版权、注明来源，以及不分享不当内容。学生还必须理解其在线行为的永久性；帖子和评论可能永远存在，并影响未来的机会。
8. Introduction to Programming in Python | Python编程入门
Python is a popular high-level programming language used widely at KS3. It emphasises code readability and has a simple syntax that makes it an excellent choice for beginners. Students learn to write programs that handle input, perform calculations, use variables, and display output.
Python是一种流行的高级编程语言，在KS3阶段被广泛使用。它强调代码可读性，语法简单，是初学者的绝佳选择。学生学习编写处理输入、执行计算、使用变量和显示输出的程序。
Key syntax elements include print() for output, input() for reading user input, and assignment with the equals sign. Arithmetic operators like +, -, *, /, and % (modulo) are used for calculations. The modulo operator gives the remainder after division and is often used to check if a number is odd or even.
关键语法元素包括用于输出的print()、用于读取用户输入的input()，以及使用等号进行赋值。算术运算符如+、-、*、/和%（取模）用于计算。取模运算符给出除法后的余数，常用于检查一个数是奇数还是偶数。
Indentation is used instead of braces to define blocks of code, especially within selection and iteration structures. For example, all lines inside a while loop must be indented consistently. A common beginner mistake is forgetting the colon at the end of the while or if line, which leads to a syntax error.
Python使用缩进而不是花括号来定义代码块，特别是在选择和迭代结构中。例如，while循环内部的所有行必须一致缩进。初学者常犯的一个错误是忘记在while或if行末尾加上冒号，这会导致语法错误。
9. Searching and Sorting Algorithms | 搜索与排序算法
Algorithms for searching and sorting are core topics in computational thinking. Two basic searching algorithms are linear search and binary search. Linear search checks each item in a list one by one until the target is found or the list ends. Binary search requires the list to be sorted first and repeatedly checks the middle item, discarding half the list each time, making it much faster for large datasets.
搜索和排序算法是计算思维的核心主题。两种基本的搜索算法是线性搜索和二分搜索。线性搜索逐个检查列表中的每一项，直到找到目标或列表结束。二分搜索要求列表先排序，然后反复检查中间项，每次丢弃一半列表，对于大数据集来说要快得多。
Sorting algorithms include bubble sort, insertion sort, and merge sort. Bubble sort compares adjacent items and swaps them if they are in the wrong order, passing through the list repeatedly until no swaps are needed. Although easy to understand, it is inefficient for large lists. Merge sort uses a divide-and-conquer approach, splitting the list into smaller parts, sorting them, and merging back together; it is much more efficient.
排序算法包括冒泡排序、插入排序和归并排序。冒泡排序比较相邻项，如果顺序错误则交换它们，反复遍历列表直到不需要交换为止。虽然易于理解，但对于大型列表效率低下。归并排序采用分而治之的方法，将列表分成更小的部分，排序后再合并回来；效率要高得多。
10. Logical Reasoning and Truth Tables | 逻辑推理与真值表
Logical operators AND, OR, and NOT are used to combine or invert conditions in programming and database queries. AND returns true only if both conditions are true. OR returns true if at least one condition is true. NOT reverses the Boolean value.
逻辑运算符AND、OR和NOT用于在编程和数据库查询中组合或反转条件。只有当两个条件都为真时，AND才返回真。如果至少有一个条件为真，OR就返回真。NOT反转布尔值。
Truth tables show all possible input combinations and the resulting output for a logical expression. For example, for A AND B, the output column is True only when both A and B are True. Truth tables help programmers verify the behaviour of complex conditions and are used in designing digital circuits.
真值表显示了所有可能的输入组合以及逻辑表达式的结果输出。例如，对于A AND B，仅当A和B都为True时，输出列才为True。真值表帮助程序员验证复杂条件的行为，并用于数字电路的设计。
Simple Boolean expressions can be simplified using rules like De Morgan’s laws. Understanding these laws enables students to write more efficient code and better understand search engine queries that use operators such as AND and OR.
可以使用德摩根定律等规则简化简单的布尔表达式。理解这些定律使学生能够编写更高效的代码，并更好地理解使用AND和OR等运算符的搜索引擎查询。
11. Creating and Using Databases | 数据库的创建与使用
A database is an organised collection of data that can be easily accessed, managed, and updated. At KS3, students typically work with flat-file databases (a single table) and understand key concepts such as fields, records, and primary keys.
数据库是有组织的数据集合，可以方便地访问、管理和更新。在KS3阶段，学生通常使用平面文件数据库（单表），并理解字段、记录和主键等关键概念。
Fields define the categories of data, each with a specific data type such as text, number, or date. Records are rows in the table, each containing a complete set of information about one item. The primary key is a unique identifier for each record, such as a student ID, ensuring no two records are identical.
字段定义了数据的类别，每个字段都有特定的数据类型，如文本、数字或日期。记录是表中的行，每行包含关于一个项目的完整信息集。主键是每条记录的唯一标识符，例如学生ID，确保没有两条记录完全相同。
Queries are used to search and filter data according to specific criteria. In a database program, students learn to use simple query languages or graphical tools to find, for instance, all students born after 2010 or all books by a certain author. Sorting and generating reports are common follow-up tasks.
查询用于根据特定条件搜索和过滤数据。在数据库程序中，学生学习使用简单的查询语言或图形工具来查找，例如，所有2010年后出生的学生或某个作者的所有书籍。排序和生成报告是常见的后续任务。
12. The System Development Life Cycle | 系统开发生命周期
The system development life cycle is a structured approach to creating information systems. It includes stages such as analysis, design, implementation, testing, deployment, and maintenance. Although not always implemented in full at KS3, understanding the cycle helps students approach larger programming projects systematically.
系统开发生命周期是一种创建信息系统的结构化方法。它包括分析、设计、实施、测试、部署和维护等阶段。虽然在KS3阶段并不总是完整实施，但理解这个生命周期有助于学生系统地处理更大的编程项目。
During analysis, the problem is defined and requirements are gathered. Design involves planning the solution, often using flowcharts, pseudocode, or wireframes. Implementation is the actual coding. Testing checks that the program works with normal, boundary, and erroneous data. Evaluating a solution against the original requirements is an important final step.
在分析阶段，定义问题并收集需求。设计涉及规划解决方案，通常使用流程图、伪代码或线框图。实施是实际编码。测试检查程序在正常数据、边界数据和错误数据下是否正常工作。根据原始需求评估解决方案是重要的最后一步。
Good documentation and commenting in code are emphasised at this stage. Comments help others (and yourself) understand the logic later. Meaningful variable names and clear structure also make the code more maintainable over time.
在这个阶段，强调良好的文档和代码注释。注释有助于他人（以及你自己）以后理解逻辑。有意义的变量名和清晰的结构也使得代码随着时间的推移更易于维护。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导