📚 GCSE CCEA Computer Science Final Revision Checklist | GCSE CCEA 计算机科学期末复习提纲
This comprehensive revision checklist covers every key topic you need to master for the CCEA GCSE Computer Science examinations. Use it to track your progress and identify areas that need more attention. Each section pairs essential English explanations with Chinese translations, making it perfect for bilingual learners preparing for Unit 1 (Computer Systems) and Unit 2 (Computational Thinking, Algorithms and Programming).
本全面复习提纲涵盖 CCEA GCSE 计算机科学考试中你需要掌握的每个关键主题。用它来追踪你的进步，并找出需要更多关注的领域。每个部分都将核心英文解释与中文翻译配对，非常适合准备第一单元（计算机系统）和第二单元（计算思维、算法与编程）的双语学习者。
1. Computer Hardware Fundamentals | 计算机硬件基础
Understand the role of the central processing unit (CPU), which consists of the control unit (CU), arithmetic logic unit (ALU), and registers such as the program counter (PC), memory address register (MAR), memory data register (MDR), and accumulator.
理解中央处理器 (CPU) 的作用，它由控制单元 (CU)、算术逻辑单元 (ALU) 以及程序计数器 (PC)、存储器地址寄存器 (MAR)、存储器数据寄存器 (MDR) 和累加器等寄存器组成。
Explain the fetch-decode-execute cycle: the processor fetches an instruction from memory (address in PC → MAR, instruction → MDR), decodes it in the CU, and then executes it using the ALU or other components.
解释取指-译码-执行周期：处理器从内存中取出指令（PC 中的地址 → MAR，指令 → MDR），在 CU 中译码，然后使用 ALU 或其他组件执行它。
Identify factors that affect CPU performance: clock speed (number of cycles per second, measured in GHz), number of cores (parallel processing of instructions), and cache size (high-speed onboard memory reducing access time to main memory).
识别影响 CPU 性能的因素：时钟速度（每秒周期数，以 GHz 为单位）、内核数量（指令的并行处理）以及缓存大小（高速片上存储器，减少对主存的访问时间）。
Describe embedded systems as specialised computers built into larger devices (e.g., washing machines, microwaves) with a dedicated function, often using a microcontroller and limited resources for efficiency and reliability.
描述嵌入式系统，即嵌入到较大设备（如洗衣机、微波炉）中的专用计算机，具有专用功能，通常使用微控制器，资源有限但高效可靠。
Recall von Neumann architecture: a stored-program concept where both instructions and data are held in the same memory, allowing programs to be easily modified or loaded.
回顾冯·诺依曼架构：一种存储程序概念，指令和数据保存在同一个内存中，使得程序可以轻松修改或加载。
2. Memory and Storage | 存储器与存储
Distinguish between RAM (random access memory) and ROM (read only memory): RAM is volatile, holds data and instructions currently in use, can be read from and written to; ROM is non-volatile, stores the boot program (BIOS) and cannot be changed by normal operations.
区分 RAM（随机存取存储器）和 ROM（只读存储器）：RAM 是易失性的，保存当前正在使用的数据和指令，可读写；ROM 是非易失性的，存储引导程序 (BIOS)，正常操作下无法更改。
Explain virtual memory as a technique that uses part of the hard disk as temporary RAM when main memory is full, allowing larger programs to run but at slower speeds due to disk transfer rates.
解释虚拟内存，当主存已满时，将硬盘的一部分用作临时 RAM 的技术，允许运行更大的程序，但由于磁盘传输速率较慢，速度会下降。
Compare secondary storage types: magnetic (HDD: high capacity, low cost per GB, moving parts), optical (CD/DVD/Blu-ray: low capacity, portable, easily scratched), and solid state (SSD, USB flash: fast, durable, no moving parts, more expensive per GB).
比较辅助存储类型：磁性（HDD：高容量、每 GB 成本低、有活动部件）、光学（CD/DVD/蓝光：容量低、便携、易划伤）和固态（SSD、USB 闪存：快速、耐用、无活动部件、每 GB 成本较高）。
Know data storage units: bit, nybble (4 bits), byte (B), kilobyte (KB), megabyte (MB), gigabyte (GB), terabyte (TB); be aware that 1 KB = 10³ B in decimal systems but 2¹⁰ B in binary contexts, though exam may ask about either.
了解数据存储单位：位、半字节（4 位）、字节 (B)、千字节 (KB)、兆字节 (MB)、吉字节 (GB)、太字节 (TB)；注意在十进制系统中 1 KB = 10³ B，但在二进制语境中为 2¹⁰ B，考试可能涉及二者。
Evaluate storage devices based on capacity, speed, portability, durability, and cost to choose suitable media for given scenarios such as backup, media distribution, or program installation.
基于容量、速度、便携性、耐用性和成本评估存储设备，为备份、媒体分发或程序安装等给定场景选择合适的介质。
3. Data Representation | 数据表示
Convert between binary (base-2), denary (base-10), and hexadecimal (base-16) numbers, understanding that hexadecimal uses digits 0-9 and letters A-F to represent values 10-15, and is used as a compact way to represent binary.
在二进制（基数为 2）、十进制（基数为 10）和十六进制（基数为 16）之间进行转换，理解十六进制使用数字 0-9 和字母 A-F 表示 10-15 的值，并作为二进制的紧凑表示。
Perform binary addition and understand overflow: when the result of a calculation exceeds the number of bits available, an overflow error occurs, which can cause incorrect results if not managed.
执行二进制加法并理解溢出：当计算结果超过可用位数时，会发生溢出错误，如果不加以管理，可能导致错误结果。
Analyze character encoding: ASCII uses 7 bits for 128 standard characters (extended ASCII uses 8 bits for 256), while Unicode uses up to 32 bits to represent characters from all major languages, supporting global communication but requiring more storage.
分析字符编码：ASCII 用 7 位表示 128 个标准字符（扩展 ASCII 用 8 位表示 256 个），而 Unicode 使用多达 32 位来表示所有主要语言的字符，支持全球交流但需要更多存储空间。
Describe how bitmap images are represented: an image is broken into a grid of pixels, each assigned a binary value; colour depth (bits per pixel) determines number of colours, and resolution (pixel dimensions) affects quality and file size.
描述位图图像的表示方式：图像被分解为像素网格，每个像素赋予一个二进制值；颜色深度（每像素位数）决定颜色数量，分辨率（像素尺寸）影响质量和文件大小。
Explain sound sampling: analog sound waves are measured at regular intervals (sample rate, e.g., 44.1 kHz) and each sample quantised with a bit depth; higher sample rate and bit depth yield better quality but larger files.
解释声音采样：以固定间隔测量模拟声波（采样率，如 44.1 kHz），每个样本用位深度进行量化；更高的采样率和位深度带来更好质量，但文件更大。
Calculate file size for images (width × height × colour depth) and sound (sample rate × bit depth × duration × number of channels), giving results in bits, bytes, or appropriate multiples.
计算图像（宽 × 高 × 颜色深度）和声音（采样率 × 位深度 × 时长 × 声道数）的文件大小，结果以位、字节或适当的倍数给出。
4. Computer Networks and Topologies | 计算机网络与拓扑
Define LAN (Local Area Network) covering a small geographical area with dedicated infrastructure, and WAN (Wide Area Network) connecting computers over large distances, often using public communication lines; Internet is a global WAN.
定义 LAN（局域网）覆盖小地理区域并使用专用基础设施，WAN（广域网）连接远距离计算机，通常使用公共通信线路；互联网是一个全球性的 WAN。
Compare client-server and peer-to-peer (P2P) models: in client-server, a central server provides services and resources, offering better security and management; in P2P, each device acts as both client and server, sharing resources directly, common in file sharing.
比较客户-服务器和对等 (P2P) 模型：在客户-服务器中，中央服务器提供服务与资源，安全性和管理更好；在 P2P 中，每台设备既是客户又是服务器，直接共享资源，常见于文件共享。
Identify network hardware: switch (intelligent device that forwards data to specific destination within a LAN), router (connects networks, directs data packets using IP addresses), NIC (network interface card for physical connection), WAP (wireless access point).
识别网络硬件：交换机（智能设备，在局域网内将数据转发到特定目的地）、路由器（连接网络，使用 IP 地址定向数据包）、NIC（网络接口卡，用于物理连接）、WAP（无线接入点）。
Examine star topology where all nodes connect to a central switch; it is robust as one cable failure doesn’t affect others, but if the central switch fails, the whole network goes down. Mesh topology provides multiple redundant paths, making it reliable but expensive.
剖析星型拓扑，所有节点连接到中央交换机；它很健壮，因为一条电缆故障不影响其他节点，但如果中央交换机故障，整个网络瘫痪。网状拓扑提供多条冗余路径，可靠但昂贵。
Explain common networking protocols: TCP/IP (foundation of Internet, ensuring reliable packet delivery), HTTP/HTTPS (web page transfer, HTTPS adds encryption), FTP (file transfer), SMTP (sending email), POP3/IMAP (retrieving email) and the four-layer TCP/IP model (application, transport, internet, network access).
解释常见网络协议：TCP/IP（互联网基础，确保可靠数据包传递）、HTTP/HTTPS（网页传输，HTTPS 增加加密）、FTP（文件传输）、SMTP（发送电子邮件）、POP3/IMAP（检索电子邮件）以及四层 TCP/IP 模型（应用层、传输层、互联网层、网络接入层）。
5. Network Security and Cyber Threats | 网络安全与网络威胁
Recognise malware types: virus (attaches to files and replicates), worm (self-replicates across networks), trojan (disguised as legitimate software), ransomware (encrypts data and demands payment), spyware (covertly collects information).
识别恶意软件类型：病毒（附着在文件上并复制）、蠕虫（通过网络自我复制）、特洛伊木马（伪装成合法软件）、勒索软件（加密数据并要求赎金）、间谍软件（秘密收集信息）。
Understand social engineering attacks: phishing (deceptive emails/websites to steal credentials), blagging (pretexting, using a fake story to obtain information), and shoulder surfing (observing someone’s screen or keyboard).
理解社会工程攻击：网络钓鱼（欺骗性电子邮件/网站窃取凭证）、假冒（借口，使用虚构故事获取信息）和肩窥（观察他人的屏幕或键盘）。
Describe brute-force attacks that try every possible password combination; denial of service (DoS) floods a system to make it unavailable; SQL injection inserts malicious SQL code into a database query to steal or corrupt data.
描述暴力破解攻击，尝试所有可能的密码组合；拒绝服务 (DoS) 攻击使系统过载而不可用；SQL 注入将恶意 SQL 代码插入数据库查询中以窃取或破坏数据。
Explain prevention methods: firewalls (filter incoming/outgoing traffic based on rules), encryption (ciphertext unreadable without key), anti-malware software, penetration testing (simulated attacks to find vulnerabilities), user access levels, and physical security measures.
解释防护方法：防火墙（基于规则过滤进出流量）、加密（无密钥无法读取密文）、反恶意软件、渗透测试（模拟攻击以发现漏洞）、用户访问级别和物理安全措施。
Evaluate the importance of regular software updates and patches in fixing security loopholes, and of strong password policies (length, complexity, multi-factor authentication) in reducing successful breaches.
评估定期软件更新和补丁修复安全漏洞的重要性，以及强密码策略（长度、复杂性、多因素认证）在减少成功入侵方面的作用。
6. System Software and Utilities | 系统软件与实用工具
Describe the functions of an operating system (OS): providing a user interface (GUI/CLI), managing memory (allocating RAM to processes), handling multitasking (CPU scheduling), controlling peripherals via drivers, managing files and folders, and enforcing security (user accounts, permissions).
描述操作系统 (OS) 的功能：提供用户界面（GUI/CLI）、管理内存（将 RAM 分配给进程）、处理多任务（CPU 调度）、通过驱动程序控制外设、管理文件和文件夹以及强制安全（用户账户、权限）。
Explain how utility software helps maintain the system: disk defragmentation reorganises fragmented files to improve read speed (mainly for HDDs), backup software creates copies of data, compression utilities reduce file size for storage or transmission, and encryption tools protect data confidentiality.
解释实用工具软件如何维护系统：磁盘碎片整理重新组织碎片文件以提高读取速度（主要针对 HDD）、备份软件创建数据副本、压缩实用工具减小文件大小以便存储或传输、加密工具保护数据机密性。
Distinguish between lossy and lossless compression: lossy permanently removes some data (e.g., JPEG, MP3) to achieve smaller sizes but with quality reduction; lossless preserves all original data (e.g., PNG, ZIP, FLAC), allowing exact reconstruction.
区分有损压缩和无损压缩：有损永久性地删除某些数据（如 JPEG、MP3）以实现更小体积但质量降低；无损保留所有原始数据（如 PNG、ZIP、FLAC），允许精确重建。
Understand the role of disk formatting (preparing a storage device for use by setting up a file system), and the need for device drivers that act as translators between the OS and specific hardware.
理解磁盘格式化（通过建立文件系统来准备存储设备以供使用）的作用，以及设备驱动程序的必要性，它作为 OS 与特定硬件之间的转换器。
7. Ethical, Legal, and Environmental Issues | 伦理、法律与环境问题
Summarise key legislation: the Data Protection Act 2018 (UK GDPR) governs how personal data must be collected, used, and stored fairly and lawfully; the Computer Misuse Act 1990 criminalizes unauthorised access, modification, and hacking; the Copyright, Designs and Patents Act 1988 protects intellectual property.
总结关键立法：2018 年数据保护法（英国 GDPR）规定了个人数据必须如何公平合法地收集、使用和存储；1990 年计算机滥用法将未经授权的访问、修改和黑客行为定为刑事犯罪；1988 年版权、设计和专利法保护知识产权。
Discuss ethical dilemmas: artificial intelligence decisions (bias, accountability), widespread surveillance versus privacy, data harvesting by social media companies, and the digital divide that isolates those without access to technology.
讨论伦理困境：人工智能决策（偏见、问责）、普遍监控与隐私、社交媒体公司的数据收集，以及数字鸿沟使无法接触技术的人被孤立。
Evaluate the environmental impact: manufacturing computers consumes resources and produces toxic e-waste; data centres consume huge amounts of electricity for operation and cooling; positive contributions include smart grids, telecommuting, and precision agriculture.
评估环境影响：制造计算机消耗资源并产生有毒电子垃圾；数据中心运行和冷却消耗大量电力；积极贡献包括智能电网、远程办公和精准农业。
Explain the importance of open source vs proprietary software licensing: open source allows users to view, modify, and distribute code, fostering collaboration; proprietary software restricts access to source code for commercial advantage.
解释开源与专有软件许可的重要性：开源允许用户查看、修改和分发代码，促进合作；专有软件限制对源代码的访问以获得商业优势。
8. Algorithms and Computational Thinking | 算法与计算思维
Define computational thinking components: abstraction (filtering out unnecessary detail to focus on key features), decomposition (breaking a complex problem into smaller, manageable parts), and algorithmic thinking (devising step-by-step solutions).
定义计算思维的组成部分：抽象（过滤掉不必要的细节，专注于关键特征）、分解（将复杂问题分解为更小、可管理的部分）和算法思维（设计逐步解决方案）。
Read and write algorithms using pseudocode (structured, language-independent descriptions) and flowcharts (diagrammatic representation with standard symbols like oval for start/end, rectangle for process, diamond for decision).
使用伪代码（结构化、独立于语言的描述）和流程图（用标准符号绘制，如椭圆形表示开始/结束、矩形表示处理、菱形表示判断）阅读和编写算法。
Describe linear search: sequentially checking each element in a list until the target is found; inefficent for large ordered lists but works on unsorted data; time complexity O(n).
描述线性查找：顺序检查列表中每个元素，直到找到目标；对大型有序列表效率低，但适用于未排序数据；时间复杂度 O(n)。
Describe binary search: repeatedly dividing a sorted list in half, comparing the middle element with the target, discarding the half where the target cannot lie; requires sorted data; time complexity O(log n).
描述二分查找：反复将有序列表对半分，比较中间元素与目标，丢弃目标不可能存在的一半；要求数据已排序；时间复杂度 O(log n)。
Compare bubble sort (repeatedly swapping adjacent out-of-order elements; O(n²), simple but slow) and merge sort (divide the list into sublists, sort and merge; O(n log n), more efficient for large datasets).
比较冒泡排序（反复交换相邻顺序错误的元素；O(n²)，简单但慢）和归并排序（将列表分成子列表，排序并合并；O(n log n)，对大数据集更高效）。
Trace algorithms using trace tables to follow variable changes step by step, identifying logic errors and verifying correctness.
使用跟踪表逐步追踪变量变化，识别逻辑错误并验证算法的正确性。
9. Programming Fundamentals | 编程基础
Understand variables (named memory locations whose value can change during execution) and constants (values fixed throughout the program, improving readability and maintenance).
理解变量（命名的内存位置，其值在执行过程中可以改变）和常量（在整个程序中固定的值，提高可读性和可维护性）。
Identify common data types: integer, real/float, Boolean (true/false), character, and string; be aware of type casting and the need to declare types in strongly typed languages.
识别常见数据类型：整型、实型/浮点型、布尔型（真/假）、字符型和字符串；了解类型转换以及在强类型语言中声明类型的需要。
Use arithmetic operators (+, -, *, /, MOD, DIV), comparison operators (==, !=, <, >, <=, >=), and logical operators (AND, OR, NOT) to build expressions that produce a value.
使用算术运算符（+、-、*、/、MOD、DIV）、比较运算符（==、!=、<、>、<=、>=）和逻辑运算符（AND、OR、NOT）构建产生值的表达式。
Implement the three basic programming constructs: sequence (executing instructions in order), selection (if-else, elif, switch/case), and iteration – both definite (for loop, counting a fixed number of times) and indefinite (while, repeat-until loops based on a condition).
实现三种基本编程结构：顺序（按顺序执行指令）、选择（if-else、elif、switch/case）和迭代——包括计数循环（for 循环，固定次数）和条件循环（while、repeat-until 基于条件）。
Apply nesting, where one control structure is placed inside another, e.g., nested if statements or nested loops for multi-dimensional data.
应用嵌套，将一个控制结构放在另一个内部，例如嵌套 if 语句或用于多维数据的嵌套循环。
10. Advanced Programming Concepts | 高级编程概念
Create subprograms: procedures (perform actions, do not return a value) and functions (return a value, can be used in expressions), using parameters to pass data into them.
创建子程序：过程（执行操作，不返回值）和函数（返回一个值，可用于表达式中），使用参数将数据传入其中。
Distinguish between passing by value (a copy of the data is used, original unchanged) and by reference (the subprogram accesses the original variable, so changes persist).
区分按值传递（使用数据的副本，原值不变）和按引用传递（子程序访问原始变量，因此更改会保留）。
Manage variable scope: local variables are declared inside a subprogram and can only be accessed there; global variables are declared outside and accessible everywhere, but overuse can lead to hard-to-trace bugs.
管理变量作用域：局部变量在子程序内部声明，只能在那里访问；全局变量在外部声明且可随处访问，但过度使用可能导致难以追踪的错误。
Work with data structures: one-dimensional and two-dimensional arrays (list and table structures) for storing multiple data items under one identifier, using index notation (index starting from 0); records (custom data types combining fields of different types) to represent real-world objects.
使用数据结构：一维和二维数组（列表和表格结构）在一个标识符下存储多个数据项，使用索引表示法（索引从 0 开始）；记录（组合不同类型字段的自定义数据类型）来表示现实世界对象。
Perform file handling: opening files for reading, writing, or appending; reading lines or records; and closing files to ensure data is saved and resources are freed. Use string manipulation functions such as length, substring, concatenation, and case conversion.
执行文件处理：打开文件进行读取、写入或追加；读取行或记录；关闭文件以确保数据保存并释放资源。使用字符串操作函数，如求长度、取子串、拼接和大小写转换。
11. Databases and SQL | 数据库与SQL
Understand database terminology: field (a single unit of data), record (a complete set of fields), table (a collection of records), primary key (unique identifier for each record), foreign key (field in one table that refers to primary key in another, linking tables).
理解数据库术语：字段（单个数据单元）、记录（一组完整的字段）、表（记录的集合）、主键（每条记录的唯一标识符）、外键（一个表中引用另一个表主键的字段，用于链接表）。
Explain benefits of relational databases over flat files: reduced data redundancy, improved data integrity through normalisation, efficient querying, and easier updates; DBMS (Database Management System) provides an interface to manage the database.
解释关系数据库相对于平面文件的优势：减少数据冗余、通过规范化提高数据完整性、高效查询、更易更新；DBMS（数据库管理系统）提供管理数据库的接口。
Write SQL queries to retrieve data: SELECT field1, field2 FROM table WHERE condition ORDER BY field ASC/DESC; use operators like LIKE, BETWEEN, and AND/OR in WHERE clause for filtering.
编写 SQL 查询检索数据：SELECT 字段1, 字段2 FROM 表 WHERE 条件 ORDER BY 字段 ASC/DESC；在 WHERE 子句中使用 LIKE、BETWEEN 和 AND/OR 进行筛选。
Use SQL for data manipulation: INSERT INTO table (fields) VALUES (values) to add new records, UPDATE table SET field = value WHERE condition to modify existing records, and DELETE FROM table WHERE condition to remove records.
使用 SQL 进行数据操作：INSERT INTO 表 (字段) VALUES (值) 添加新记录，UPDATE 表 SET 字段 = 值 WHERE 条件 修改现有记录，DELETE FROM 表 WHERE 条件 删除记录。
Recognise the need for data validation and verification: validation checks whether data is reasonable (range check, presence check, format check, etc.), while verification ensures data entered matches the original source (double entry, proofreading).
认识数据验证和校验的必要性：验证检查数据是否合理（范围检查、存在性检查、格式检查等），校验确保输入的数据与原始来源一致（双重录入、校对）。
12. Testing, Evaluation, and System Life Cycle | 测试、评估与系统生命周期
Understand the phases of the system development life cycle: analysis, design, implementation (coding), testing, evaluation, and maintenance; an iterative approach allows revisiting earlier phases
Published by TutorHao | GCSE Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导