📚 KS3 CIE Computing: Core Knowledge Overview | KS3 CIE 计算机核心知识点梳理
Welcome to your complete revision guide covering the key topics in the KS3 Cambridge Computing curriculum. This article breaks down fundamental concepts in computational thinking, programming, computer systems, data representation, networks, safety, and databases. Each section provides clear explanations in both English and Chinese to support bilingual learners as they build a strong foundation for further studies in computer science.
欢迎阅读这份 KS3 剑桥计算机课程核心知识点梳理指南。本文逐一拆解计算思维、编程、计算机系统、数据表示、网络、安全及数据库等主题的基础概念。每个部分均提供中英双语讲解，帮助双语学习者搭建扎实的知识框架，为进阶学习做好准备。
1. Computational Thinking | 计算思维
Computational thinking is the problem-solving approach that underpins all computer science. It involves breaking down complex problems into smaller, manageable parts (decomposition), spotting similarities and patterns (pattern recognition), filtering out unnecessary details to focus on what is important (abstraction), and devising step-by-step solutions (algorithms). These four techniques help us think like a computer scientist when tackling both digital and real-world challenges.
计算思维是支撑整个计算机科学的问题解决方法。它包括将复杂问题拆解成更小、更易处理的部分（分解），发现相似之处和规律（模式识别），滤除无关细节以聚焦关键（抽象），以及设计逐步求解的方案（算法）。这四种技巧能帮助我们像计算机科学家一样去思考，无论面对数字问题还是现实难题都行之有效。
2. Algorithms and Flowcharts | 算法与流程图
An algorithm is a precise sequence of instructions designed to complete a task or solve a problem. Algorithms can be expressed in plain English, as pseudocode, or through flowcharts. A flowchart uses standard symbols such as ovals for start/end, parallelograms for input/output, rectangles for processes, and diamonds for decisions. Drawing a flowchart before coding helps programmers clarify their logic and spot mistakes early.
算法是为完成某项任务或解决某个问题而设计的一组精确指令序列。算法可以用自然语言、伪代码或流程图表示。流程图使用标准符号：椭圆表示开始/结束，平行四边形表示输入/输出，矩形表示处理步骤，菱形表示判断。在编程之前绘制流程图有助于理清思路、及早发现逻辑错误。
3. Programming Fundamentals | 编程基础要素
At KS3 level, programming introduces three core control structures: sequence, selection, and iteration. Sequence means executing instructions one after another in the order they are written. Selection uses conditions (if-else statements) to make decisions, allowing a program to branch. Iteration involves loops — either repeating a fixed number of times (count-controlled loop, such as FOR) or repeating while a condition is true (condition-controlled loop, such as WHILE). Variables are used to store data values that can change as the program runs.
在 KS3 阶段，编程主要涉及三种核心控制结构：顺序、选择和迭代。顺序结构指按照书写顺序一条接一条地执行指令。选择结构使用条件（if-else 语句）进行判断，让程序产生分支。迭代结构通过循环实现重复——要么重复固定的次数（计数控制循环，如 FOR），要么当某一条件为真时重复执行（条件控制循环，如 WHILE）。变量用于存储程序运行期间可以改变的数据值。
4. Data Representation | 数据表示
Computers process and store all data as binary numbers — sequences of 1s and 0s. Each 1 or 0 is a binary digit, or bit. A group of 8 bits forms a byte. Denary numbers (base 10) can be converted to binary using place values (128, 64, 32, 16, 8, 4, 2, 1). Text is represented by character codes such as ASCII, where each character is assigned a unique binary number. Images are stored as grids of pixels, with each pixel represented by a binary value for its colour. Sound is sampled at intervals and each sample is stored as a binary number.
计算机将所有数据处理和存储为二进制数——即由 1 和 0 组成的序列。每一个 1 或 0 称为一个二进制位，也称比特。8 个比特构成一个字节。十进制（基数 10）数可以使用位权值（128、64、32、16、8、4、2、1）转换为二进制。文本通过字符编码（如 ASCII）表示，每个字符都有唯一的二进制编码。图像以像素网格的形式存储，每个像素的颜色用二进制值表示。声音则在间隔点采样，每个样本转换为二进制数进行存储。
Binary to Denary Example: 1101₂ = (1 × 8) + (1 × 4) + (0 × 2) + (1 × 1) = 13₁₀
二进制转十进制示例：1101₂ = (1 × 8) + (1 × 4) + (0 × 2) + (1 × 1) = 13₁₀
5. Computer Hardware | 计算机硬件
Hardware refers to the physical components of a computer system. The central processing unit (CPU) is the brain of the computer, executing instructions through the fetch-decode-execute cycle. Primary memory (RAM and ROM) holds data and instructions currently in use; RAM is volatile and loses its content when power is off, while ROM is non-volatile and stores essential boot instructions. Input devices (keyboard, mouse, sensor) send data to the computer, and output devices (monitor, printer, speaker) present results to the user. Storage devices such as hard disk drives (HDD) and solid-state drives (SSD) provide long-term data storage.
硬件指计算机系统的物理部件。中央处理器（CPU）是计算机的大脑，通过取指-译码-执行周期来处理指令。主存储器（RAM 和 ROM）保存正在使用的数据和指令；RAM 是易失性存储器，断电后内容会丢失，而 ROM 是非易失性存储器，保存着必要的启动指令。输入设备（键盘、鼠标、传感器）将数据送入计算机，输出设备（显示器、打印机、扬声器）向用户呈现结果。存储设备如硬盘（HDD）和固态硬盘（SSD）则提供长期的数据保存。
6. Software | 软件
Software is the set of instructions that tells the hardware what to do. System software manages the computer’s resources and includes the operating system (e.g., Windows, macOS, Linux) and utility programs (antivirus, file management, disk defragmentation). Application software enables users to perform specific tasks, such as word processing, creating spreadsheets, browsing the web, or editing images. Software can be developed using different programming languages and can be either open source or proprietary.
软件是指挥硬件如何工作的一系列指令。系统软件负责管理计算机的资源，包括操作系统（如 Windows、macOS、Linux）和实用程序（杀毒软件、文件管理、磁盘整理）。应用软件则帮助用户完成特定任务，例如文字处理、电子表格制作、网页浏览或图像编辑。软件可以使用不同的编程语言开发，并可分为开源软件或专有软件。
7. Computer Networks | 计算机网络
A network connects two or more computers so they can share resources and data. In a Local Area Network (LAN), computers are connected over a small geographical area, such as a school or office, often using switches and Ethernet cables or Wi-Fi. A Wide Area Network (WAN) spans large distances and may connect multiple LANs, with the internet being the largest WAN. Common network topologies include star, bus, and mesh. Protocols such as TCP/IP define the rules for communication, and devices like routers direct data traffic between networks.
计算机网络将两台或多台计算机连接起来，使它们能够共享资源和数据。在局域网（LAN）中，计算机在较小地理范围内（如学校或办公室）连接，通常使用交换机、以太网线或 Wi-Fi。广域网（WAN）覆盖远距离，可连接多个局域网，互联网就是最大的广域网。常见的网络拓扑结构包括星形、总线形和网状。TCP/IP 等协议定义了通信规则，路由器等设备则负责在网络之间引导数据流量。
8. The Internet and the World Wide Web | 互联网与万维网
The internet is a global network infrastructure connecting millions of private, public, academic, and business networks. The World Wide Web (WWW) is a collection of web pages and resources accessible via the internet, using the HTTP/HTTPS protocol. Every web page has a unique URL (Uniform Resource Locator) that includes the protocol, domain name, and path. The Domain Name System (DNS) translates human-friendly domain names into IP addresses. HTML (HyperText Markup Language) is the standard language used to create web pages, and browsers render this code into the visual pages we see.
互联网是连接无数私用、公用、学术和商业网络的全球性网络基础设施。万维网（WWW）则是通过互联网访问的网页和资源的集合，使用 HTTP/HTTPS 协议。每个网页都有一个唯一的 URL（统一资源定位符），包含协议、域名和路径。域名系统（DNS）将人类易记的域名转换为 IP 地址。HTML（超文本标记语言）是创建网页的标准语言，浏览器将这些代码渲染成我们看到的可视化页面。
9. Digital Safety and Ethics | 数字安全与伦理
Staying safe online is a vital part of digital literacy. Key practices include using strong, unique passwords, not sharing personal information publicly, recognising phishing attempts, and keeping software up to date. Cyberbullying, grooming, and malware are serious threats that can be reduced through awareness and reporting. Ethical considerations include respecting copyright and intellectual property when using or sharing content, understanding creative commons licences, and acting responsibly when communicating online. Always think before you post, and treat others with respect in all digital spaces.
安全上网是数字素养的重要部分。关键做法包括使用强密码且不重复使用、不公开分享个人信息、识别网络钓鱼，以及保持软件更新。网络欺凌、诱骗和恶意软件是严重的威胁，通过提高警惕和及时举报能够降低风险。数字伦理方面，使用或分享内容时应尊重版权和知识产权，了解知识共享许可，并在网络交流中负责任地行事。发布前请三思，尊重数字空间中的每一个人。
10. Databases | 数据库
A database is an organised collection of data stored electronically. Data is kept in tables made up of records (rows) and fields (columns). Each field holds a specific type of data and is given a descriptive field name. A primary key is a unique identifier for each record, ensuring no two rows are identical. Queries allow users to search for and retrieve specific information, for example 'find all students older than 12'. At KS3, learners practise creating simple flat-file databases, entering data, and constructing search queries using logical operators such as AND, OR, and NOT.
数据库是以电子方式存储的有组织的数据集合。数据保存在由记录（行）和字段（列）构成的表格中。每个字段保存一种特定类型的数据，并具有描述性的字段名。主键是每条记录的唯一标识符，确保没有两行完全相同。查询功能让用户能够搜索并提取特定信息，例如“找出所有年龄超过 12 岁的学生”。在 KS3 阶段，学习者将练习创建简单的平面文件数据库，录入数据，并使用 AND、OR、NOT 等逻辑运算符构建搜索查询。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图