📚 Cambridge IGCSE Computer Science Coursebook: A Comprehensive Guide | 剑桥 IGCSE 计算机科学教材：全面指南
The Cambridge IGCSE Computer Science coursebook is designed to equip students with a solid foundation in the principles of computing, practical programming skills, and an understanding of how computer systems operate. This article walks you through the core topics covered in the syllabus, from data representation to cybersecurity, helping you navigate the coursebook effectively for both theoretical and practical components.
剑桥 IGCSE 计算机科学教材旨在为学生打下坚实的计算原理基础，培养实用的编程技能，并理解计算机系统是如何运作的。本文将带你逐一梳理课程涵盖的核心主题，从数据表示到网络安全，帮助你高效使用教材，应对理论和实践两个部分。
1. Understanding the IGCSE Computer Science Curriculum | 了解 IGCSE 计算机科学课程大纲
The Cambridge IGCSE Computer Science syllabus (0478) splits into two papers: Paper 1 focuses on theory of computer science, while Paper 2 tests programming and problem-solving. The coursebook encourages learners to think logically, apply algorithms, and develop a deep appreciation of how technology shapes the modern world.
剑桥 IGCSE 计算机科学课程（0478）分为两份试卷：试卷一侧重计算机科学理论，试卷二考查编程与问题解决能力。教材鼓励学生进行逻辑思考、应用算法，并深刻理解技术如何塑造现代世界。
Key topics include data representation, computer architecture, software, networks, databases, and the ethical implications of digital technology. Practical problem-solving using a high-level language such as Python is integrated throughout the course, with plenty of pseudocode examples to reinforce algorithmic thinking.
关键主题包括数据表示、计算机体系结构、软件、网络、数据库以及数字技术的伦理影响。整个课程贯穿使用 Python 等高级语言进行实际的问题解决，并提供大量伪代码示例以强化算法思维。
2. Data Representation: Binary and Hexadecimal | 数据表示：二进制与十六进制
All data inside a computer is stored as binary digits (bits): 0s and 1s. The coursebook explains how numbers, text, images and sound are encoded using binary. You will learn to convert between denary (base 10), binary (base 2) and hexadecimal (base 16). For example, the binary number 1101₂ equals 13 in denary and D in hexadecimal.
计算机内部的所有数据都以二进制数字（比特）存储：0 和 1。教材解释了如何使用二进制对数字、文本、图像和声音进行编码。你将学习如何在十进制（基数 10）、二进制（基数 2）和十六进制（基数 16）之间进行转换。例如，二进制数 1101₂ 等于十进制 13，也等于十六进制 D。
- Denary (base 10) uses digits 0–9.
- 十进制使用 0–9 的数字。
- Binary (base 2) uses 0 and 1; each bit represents a power of 2.
- 二进制使用 0 和 1；每一位代表 2 的幂。
- Hexadecimal (base 16) uses 0–9 and A–F, making it compact for large binary values.
- 十六进制使用 0–9 和 A–F，能够紧凑地表示较长的二进制串。
Binary addition and overflow, two’s complement for negative numbers, and character sets like ASCII and Unicode are also covered. Understanding how a pixel’s colour can be stored as a binary number for each red, green and blue component deepens your grasp of digital images.
此外，还涵盖二进制加法与溢出、用二进制补码表示负数，以及 ASCII 和 Unicode 等字符集。理解每个像素的红、绿、蓝分量如何用二进制数存储，将加深你对数字图像的理解。
3. Computer Architecture: CPU and Memory | 计算机体系结构：中央处理器与存储器
The central processing unit (CPU) is the brain of the computer. The coursebook explains the fetch-decode-execute cycle, the role of the arithmetic logic unit (ALU), the control unit (CU), and registers such as the program counter, accumulator, and memory address register.
中央处理器（CPU）是计算机的大脑。教材解释了取指–译码–执行周期，算术逻辑单元（ALU）和控制单元（CU）的作用，以及程序计数器、累加器和存储器地址寄存器等寄存器。
The von Neumann architecture stores both data and instructions in the same memory, which is a core concept. Factors affecting CPU performance – clock speed, number of cores, and cache size – are examined. You will also explore embedded systems found in devices like microwaves and washing machines.
冯·诺依曼体系结构将数据和指令存储在同一内存中，这是一个核心概念。影响 CPU 性能的因素——时钟速度、核心数和缓存大小——也会得到分析。你还将探究在微波炉、洗衣机等设备中常见的嵌入式系统。
Memory types are classified into primary memory (RAM, ROM) and secondary storage (HDD, SSD, optical, solid-state). RAM is volatile and holds data currently in use; ROM is non-volatile and stores firmware such as BIOS. The coursebook compares storage devices based on capacity, speed, portability, durability and cost.
存储器类型分为主存储器（RAM、ROM）和辅助存储器（HDD、SSD、光盘、固态存储）。RAM 是易失性的，存储当前使用的数据；ROM 是非易失性的，存储 BIOS 等固件。教材从容量、速度、便携性、耐用性和成本几个方面对各种存储设备进行了对比。
4. Input and Output Devices | 输入与输出设备
Input devices allow users to enter data into a computer system. Typical examples include keyboards, mice, touchscreens, microphones, and sensors (temperature, light, pressure). The coursebook discusses how each device works and where it is used – such as barcode scanners in retail or infrared sensors in security systems.
输入设备使用户能够将数据输入计算机系统。常见例子包括键盘、鼠标、触摸屏、麦克风以及传感器（温度、光线、压力）。教材讨论了每种设备的工作原理和应用场景，例如零售业的条形码扫描器或安防系统中的红外传感器。
Output devices present processed data to the user. Monitors (LCD/LED), printers (inkjet, laser, 3D), speakers and actuators are all explored. Emphasis is placed on matching the right device to a specific real-world application, such as using large-format inkjet printers for banners or actuators in automated factory machinery.
输出设备将处理后的数据展现给用户。显示器（LCD/LED）、打印机（喷墨、激光、3D）、扬声器和执行器都有所涉及。重点在于根据特定的实际应用选择合适的设备，例如使用大幅面喷墨打印机打印横幅，或在自动化工厂机械中使用执行器。
5. Software: Operating Systems and Applications | 软件：操作系统与应用
Software is divided into system software and application software. The operating system (OS) is the most important system software, managing hardware resources, providing a user interface, handling file management, and ensuring security through user accounts. Multitasking and memory management are key OS functions.
软件分为系统软件和应用软件。操作系统（OS）是最重要的系统软件，它管理硬件资源、提供用户界面、处理文件管理，并通过用户账户保证安全。多任务处理和内存管理是操作系统的关键功能。
Application software fulfils user needs, including word processors, spreadsheets, web browsers and database management systems. The coursebook also contrasts high-level languages with low-level languages; high-level languages like Python are closer to human language, while assembly language and machine code are directly executed by the CPU. Compilers and interpreters translate high-level code into machine code.
应用软件满足用户需求，包括文字处理软件、电子表格、网页浏览器和数据库管理系统。教材还对比了高级语言与低级语言；Python 等高级语言更接近人类语言，而汇编语言和机器码则直接由 CPU 执行。编译器和解释器能将高级代码翻译成机器码。
6. Networks and the Internet | 网络与互联网
Computer networks enable devices to share resources and communicate. The coursebook covers LANs and WANs, network topologies (star, bus, mesh), and the hardware required such as routers, switches, hubs and network interface cards. Transmission media like copper cable, fibre optic and wireless are compared in terms of bandwidth, latency and interference.
计算机网络使设备能够共享资源和通信。教材涵盖了局域网和广域网、网络拓扑（星形、总线、网状），以及所需硬件，如路由器、交换机、集线器和网络接口卡。铜缆、光纤和无线等传输介质在带宽、延迟和抗干扰方面进行了比较。
The Internet is a global WAN relying on protocols like TCP/IP. IP addresses (IPv4 and IPv6) uniquely identify devices, while the domain name system (DNS) translates human-friendly names to IP addresses. HTTP/HTTPS, FTP, SMTP and other protocols are explored, along with the client-server model and the role of the cloud in modern computing.
互联网是一个依赖 TCP/IP 等协议的全球广域网。IP 地址（IPv4 和 IPv6）能唯一标识设备，而域名系统（DNS）则把便于记忆的名称转换成 IP 地址。教材还探讨了 HTTP/HTTPS、FTP、SMTP 等协议，以及客户端–服务器模型和云计算在现代计算中的角色。
7. Programming Fundamentals | 编程基础
Programming is the heart of Paper 2. The coursebook uses both pseudocode and Python examples to teach sequencing, selection (IF statements) and iteration (FOR, WHILE loops). Variables, data types (integer, string, Boolean, real/float) and basic arithmetic operations (+, -, *, /, MOD, DIV) form the building blocks.
编程是试卷二的核心。教材使用伪代码和 Python 示例来教授顺序、选择（IF 语句）和迭代（FOR、WHILE 循环）。变量、数据类型（整数、字符串、布尔型、实数/浮点数）以及基本算术运算（+、-、*、/、MOD、DIV）构成了基础模块。
Arrays (one-dimensional and two-dimensional) are used to store multiple data items. The coursebook emphasises algorithm design: writing structured solutions to problems using flowcharts or pseudocode. Common algorithms like linear search, bubble sort, and counting occurrences are covered in detail. You will also practise validation and verification to ensure robust code.
数组（一维和二维）用于存储多个数据项。教材强调算法设计：使用流程图或伪代码为问题编写结构化的解决方案。线性搜索、冒泡排序和计数出现次数等常见算法都有详细介绍。你还将练习确认和验证以确保代码的健壮性。
Example pseudocode: Total ← 0, FOR i ← 1 TO 10, Total ← Total + i, NEXT i
伪代码示例：Total ← 0，FOR i ← 1 TO 10，Total ← Total + i，NEXT i
8. Databases and SQL | 数据库与 SQL
Databases store structured data in tables composed of records (rows) and fields (columns). The coursebook explains key concepts such as primary keys, foreign keys, data types and relationships. You learn to design flat-file and relational databases, understanding how normalisation reduces data redundancy.
数据库将结构化数据存储在由记录（行）和字段（列）组成的表中。教材解释了主键、外键、数据类型和关系等关键概念。你将学习设计平面文件和关系数据库，并理解规范化如何减少数据冗余。
Structured Query Language (SQL) is used to query and manipulate data. Essential commands include SELECT, FROM, WHERE, ORDER BY, INSERT INTO, UPDATE and DELETE. For instance:
结构化查询语言（SQL）用于查询和操作数据。基本命令包括 SELECT、FROM、WHERE、ORDER BY、INSERT INTO、UPDATE 和 DELETE。例如：
SELECT Name, Grade FROM Students WHERE Grade > 80 ORDER BY Name ASC;
SELECT Name, Grade FROM Students WHERE Grade > 80 ORDER BY Name ASC;
Students also explore how databases are used in real-life contexts such as banking systems, school management software, and online shopping carts. The ethical considerations around data privacy and security are introduced here.
学生还会探索数据库在银行系统、学校管理软件和在线购物车等真实场景中的使用。这里还介绍了数据隐私和安全方面的伦理考量。
9. Cybersecurity and Ethical Issues | 网络安全与伦理问题
With increasing reliance on digital systems, cybersecurity is a vital topic. The coursebook examines threats such as malware (viruses, worms, trojans), phishing, denial-of-service attacks, and brute-force attacks. Prevention strategies include firewalls, encryption, two-factor authentication, and regular software updates.
随着对数字系统依赖的加深，网络安全成为一个至关重要的主题。教材分析了恶意软件（病毒、蠕虫、木马）、网络钓鱼、拒绝服务攻击和暴力破解等威胁。预防策略包括防火墙、加密、双因素认证和定期更新软件。
Ethical and legal issues surrounding computing are woven throughout the syllabus. Topics include the digital divide, acceptable use policies, copyright and plagiarism, and the environmental impact of technology. The coursebook fosters responsible digital citizenship by encouraging students to evaluate the consequences of their own online behaviour and the broader societal effects of automation and artificial intelligence.
围绕计算的伦理和法律问题贯穿整个大纲。主题包括数字鸿沟、可接受使用政策、版权与剽窃，以及技术的环境影响。教材鼓励学生评估自身在线行为的后果，以及自动化和人工智能带来的更广泛社会影响，从而培养负责任的数字公民意识。
10. Exam Tips and Revision Strategies | 考试技巧与复习策略
Success in Cambridge IGCSE Computer Science requires both theoretical understanding and strong practical programming skills. The coursebook provides end-of-chapter questions and practice examinations. Paper 1 consists of multiple-choice and short-answer questions; careful reading of command words like ‘describe’, ‘explain’ and ‘compare’ is essential.
想在剑桥 IGCSE 计算机科学中取得成功，需要扎实的理论理解和过硬的实践编程技能。教材提供了章末习题和模拟考试。试卷一包含选择题和简答题；仔细辨别“描述”“解释”和“比较”等指令词至关重要。
For Paper 2, practise writing code by hand under timed conditions, and become fluent in both pseudocode and your chosen programming language. Time management and the ability to debug simple syntax errors will give you an edge. Revision checklists and mind maps can help consolidate the wide range of topics into a coherent mental framework.
对于试卷二，要练习在限时条件下手写代码，并熟练运用伪代码以及所选的编程语言。时间管理和调试简单语法错误的能力会让你更有优势。复习清单和思维导图有助于将广泛的主题整合成一个连贯的知识框架。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导