📚 Year 11 CCEA Computer Science: Core Knowledge Review | Year 11 CCEA 计算机：核心知识点梳理
This article provides a comprehensive review of the core topics covered in Year 11 of the CCEA GCSE Computer Science course. It covers computer systems, data representation, networks, security, algorithms, programming fundamentals, Boolean logic, databases and more. Each section is carefully aligned with the official CCEA specification to help you consolidate knowledge and prepare effectively for assessments.
本文全面梳理了 CCEA GCSE 计算机科学 Year 11 课程的核心主题，涵盖计算机系统、数据表示、网络、网络安全、算法、编程基础、布尔逻辑与数据库等内容。每个小节均严格依据 CCEA 官方大纲编写，旨在帮助你巩固知识，高效备考。
1. Computer System Architecture | 计算机系统架构
The von Neumann architecture is the foundation of most modern computers, storing both data and instructions in the same memory. The central processing unit (CPU) consists of the control unit (CU), arithmetic logic unit (ALU), and registers such as the program counter (PC) and accumulator (ACC).
冯·诺依曼架构是大多数现代计算机的基础，它将数据和指令存储在同一内存中。中央处理器（CPU）由控制单元（CU）、算术逻辑单元（ALU）以及程序计数器（PC）和累加器（ACC）等寄存器组成。
The fetch-decode-execute cycle is the process by which the CPU reads an instruction from memory (fetch), interprets it (decode), and carries out the required operation (execute). Clock speed, measured in Hertz, determines how many cycles per second the CPU can perform; more cores allow parallel processing; cache memory provides high-speed data access to reduce average access time.
取指–解码–执行周期是指 CPU 从内存读取指令（取指）、解释指令（解码）并执行所需操作（执行）的过程。时钟速度以赫兹为单位，决定 CPU 每秒可执行的周期数；更多的核心支持并行处理；缓存内存提供高速数据存取，从而降低平均访问时间。
Embedded systems are dedicated computer systems within larger devices, such as washing machines or engine control units. They typically have limited memory and processing power but are optimised for a specific task, making them efficient and reliable.
嵌入式系统是内置于大型设备（如洗衣机或发动机控制单元）中的专用计算机系统。它们通常内存和计算能力有限，但针对特定任务进行了优化，因此高效且可靠。
2. Data Representation | 数据表示
Computers represent all data in binary (base 2) using only the digits 0 and 1. A single binary digit is a bit; 8 bits form a byte. Larger units are kilobytes (kB), megabytes (MB), gigabytes (GB) and so on. Converting between binary and denary (base 10) is an essential skill, as is converting between binary and hexadecimal (base 16), where the digits 0–9 and letters A–F are used.
计算机用二进制（基数为 2）表示所有数据，仅使用数字 0 和 1。一个二进制位称为比特（bit）；8 个比特构成一个字节（byte）。更大的单位包括千字节（kB）、兆字节（MB）、千兆字节（GB）等。二进制与十进制（基数为 10）之间的转换，以及二进制与十六进制（基数为 16）之间的转换是必备技能，十六进制使用数字 0–9 和字母 A–F。
| Denary | Binary | Hex |
| 10 | 1010₂ | A₁₆ |
| 15 | 1111₂ | F₁₆ |
| 255 | 11111111₂ | FF₁₆ |
Binary addition follows simple rules: 0+0=0, 0+1=1, 1+1=0 carry 1. An overflow error occurs when the result exceeds the available number of bits. Binary shifts move bits left or right to perform multiplication or division by powers of two.
二进制加法遵循简单规则：0+0=0，0+1=1，1+1=0 并向高位进 1。当结果超出可用的位数时会产生溢出错误。二进制移位将位左移或右移，实现 2 的幂次乘除运算。
Text is encoded using character sets: ASCII uses 7 bits to represent 128 characters, while Unicode can represent thousands of characters from many writing systems. Images are represented as bitmaps made of pixels; colour depth (e.g., 8-bit, 24-bit) determines the number of colours; resolution is the number of pixels in width × height. Sound is sampled by measuring amplitude at regular intervals; sample rate (e.g., 44.1 kHz) and bit depth affect quality. File size calculations use the formulas: image size = width × height × colour depth (bits); sound size = sample rate × bit depth × duration (seconds).
文本使用字符集编码：ASCII 使用 7 位表示 128 个字符，而 Unicode 可以表示数千种书写系统的字符。图像以位图形式表示，由像素构成；颜色深度（如 8 位、24 位）决定颜色数量；分辨率是宽度 × 高度的像素数。声音通过定期测量幅度进行采样；采样率（如 44.1 kHz）和位深度影响音质。文件大小计算公式：图像大小 = 宽度 × 高度 × 颜色深度（位）；声音大小 = 采样率 × 位深度 × 时长（秒）。
3. Computer Networks | 计算机网络
A local area network (LAN) connects computers over a small geographical area, while a wide area network (WAN) spans larger distances, often using leased telecommunications lines. Networks can be structured as client-server, where one or more servers provide resources, or peer-to-peer (P2P), where all machines share resources directly.
局域网（LAN）连接小地理范围内的计算机，而广域网（WAN）跨越更大距离，通常使用租用的通信线路。网络可以构建为客户端–服务器模式，由一台或多台服务器提供资源；或对等网络（P2P）模式，所有机器直接共享资源。
Essential network hardware includes switches (connect devices within a LAN), routers (connect networks and direct data packets), network interface cards (NICs) and transmission media such as copper Ethernet cables and fibre optic cables. Common topologies are the star topology, where all nodes connect to a central switch, and the bus topology, where nodes share a single communication line.
重要的网络硬件包括交换机（在 LAN 内连接设备）、路由器（连接不同网络并引导数据包）、网络接口卡（NIC）以及铜质以太网电缆和光纤等传输介质。常见拓扑结构有星型拓扑（所有节点连接至中央交换机）和总线拓扑（节点共享一条通信线路）。
Protocols are sets of rules for communication: TCP/IP governs reliable data transfer across the internet; HTTP/HTTPS handles web page transfer; FTP transfers files; SMTP sends emails and POP3/IMAP retrieves them. IP addresses (like 192.168.1.1) identify devices on a network, and MAC addresses are unique hardware identifiers. DNS translates domain names into IP addresses.
协议是一套通信规则：TCP/IP 管理互联网上的可靠数据传输；HTTP/HTTPS 处理网页传输；FTP 传输文件；SMTP 发送电子邮件，而 POP3/IMAP 负责接收。IP 地址（如 192.168.1.1）标识网络上的设备，MAC 地址是唯一的硬件标识符。DNS 将域名转换为 IP 地址。
4. Network Security | 网络安全
Common threats include malware (viruses, worms, trojans, ransomware), social engineering (phishing, blagging), brute-force attacks, denial-of-service (DoS) attacks and SQL injection. These can lead to data theft, identity fraud or loss of service.
常见威胁包括恶意软件（病毒、蠕虫、特洛伊木马、勒索软件）、社会工程（网络钓鱼、诈骗）、暴力攻击、拒绝服务（DoS）攻击以及 SQL 注入。这些可能导致数据盗窃、身份欺诈或服务中断。
To protect systems, organisations use firewalls to filter incoming/outgoing traffic, anti-malware software to detect and remove threats, encryption to scramble data, and two-factor authentication to verify user identity. Access control lists and regular penetration testing further strengthen security. Users should also be trained to recognise suspicious communications.
为保护系统，组织使用防火墙过滤进出流量、反恶意软件检测并清除威胁、加密技术对数据进行加扰，以及双因素认证来核实用户身份。访问控制列表和定期渗透测试进一步增强安全性。还应培训用户识别可疑通信。
5. System Software | 系统软件
System software, specifically the operating system (OS), manages hardware resources and provides a user interface. Key OS functions include memory management (allocating RAM to processes), multitasking (sharing CPU time), peripheral management (drivers), file management and security through user accounts.
系统软件，特别是操作系统（OS），管理硬件资源并提供用户界面。操作系统的核心功能包括内存管理（将 RAM 分配给进程）、多任务处理（共享 CPU 时间）、外设管理（驱动程序）、文件管理和通过用户账户实现的安全控制。
Utility software performs maintenance tasks: disk defragmentation reorganises file fragments to improve access speed; backup utilities create data copies; compression tools reduce file size; encryption utilities protect data. Application software, such as word processors and games, helps users perform specific tasks, and it differs from system software which runs the computer itself.
实用工具软件执行维护任务：磁盘碎片整理重组文件碎片以提高存取速度；备份工具创建数据副本；压缩工具减小文件体积；加密工具保护数据。应用软件（如文字处理器和游戏）帮助用户执行特定任务，与运行计算机本身的系统软件不同。
6. Ethical, Legal and Environmental Impacts | 伦理、法律与环境影响
The use of computers raises ethical concerns around privacy, surveillance, automation replacing jobs, and access to technology (the digital divide). Laws regulate data use: the Data Protection Act (GDPR in the EU) governs how personal data is collected, stored and processed; the Computer Misuse Act criminalises hacking and malware creation; copyright law protects intellectual property in software and digital media.
计算机使用引发了隐私、监控、自动化取代工作岗位以及技术接入（数字鸿沟）等伦理问题。法律对数据使用进行规范：数据保护法（欧盟的 GDPR）管控个人数据的收集、存储和处理；计算机滥用法将黑客行为和恶意软件创作定为犯罪；版权法保护软件和数字媒体的知识产权。
Environmental impacts include the energy consumption of data centres and the disposal of electronic waste (e-waste). Sustainable practices involve using energy-efficient hardware and responsible recycling. The ethical debates around artificial intelligence, such as bias in algorithms, are also increasingly relevant.
环境影响包括数据中心的能耗以及电子垃圾（电子废弃物）的处理。可持续实践包括使用节能硬件和负责任地进行回收。围绕人工智能的伦理讨论，例如算法中的偏见，也日益受到重视。
7. Algorithms | 算法
Algorithms can be expressed using flowcharts (diagrammatic) or pseudocode (structured English-like notation). Two classic sorting algorithms are bubble sort, which repeatedly compares and swaps adjacent elements, and merge sort, which recursively divides the list and merges sorted halves. Linear search scans each element sequentially, while binary search repeatedly divides a sorted list to halve the search space.
算法可以用流程图（图示方式）或伪代码（类似英语的结构化符号）表示。两种经典的排序算法是冒泡排序（反复比较并交换相邻元素）和归并排序（递归地划分列表并合并已排序的半部分）。线性搜索逐个扫描元素，而二分搜索通过反复对半划分已排序列表来缩小搜索范围。
Comparing efficiency: bubble sort and linear search have O(n²) and O(n) worst-case time complexity respectively; merge sort and binary search are far more efficient at O(n log n) and O(log n). Choosing the right algorithm can dramatically affect performance, especially with large data sets.
效率比较：冒泡排序的最坏情况时间复杂度为 O(n²)，线性搜索为 O(n)；归并排序为 O(n log n)，二分搜索为 O(log n)，效率高得多。选择正确的算法可以极大地影响性能，尤其在处理大数据集时。
8. Programming Fundamentals | 编程基础
Programming involves declaring variables (memory locations that store values) and constants (values that do not change). Data types include integer, real (float), string, and Boolean. Assignment uses the = operator. Input and output typically use commands like INPUT and PRINT.
编程涉及声明变量（存储值的内存位置）和常量（不改变的值）。数据类型包括整型、实型（浮点数）、字符串和布尔型。赋值使用 = 运算符。输入和输出通常使用类似 INPUT 和 PRINT 的命令。
Control structures determine program flow: selection (if-else, switch/case) and iteration (for loops for a set number of times, while loops while a condition is true, and do-while loops that execute at least once). Logical operators (AND, OR, NOT) and relational operators (==, !=, <, >, <=, >=) are used in conditions.
控制结构决定程序流程：选择（if-else、switch/case）和迭代（for 循环执行固定次数，while 循环在条件为真时执行，do-while 循环至少执行一次）。条件中会使用逻辑运算符（AND、OR、NOT）和关系运算符（==、!=、<、>、<=、>=）。
Modular programming techniques include functions and procedures (subroutines), which promote code reuse. Parameters can be passed by value or by reference. Local variables exist only inside a subroutine; global variables can be accessed throughout the program, but overuse can make debugging difficult. Arrays store multiple values under a single identifier.
模块化编程技术包括函数和过程（子程序），可以促进代码重用。参数可以按值传递或按引用传递。局部变量仅存在于子程序内部；全局变量可在整个程序中访问，但过度使用会增加调试难度。数组在单个标识符下存储多个值。
9. Boolean Logic | 布尔逻辑
Boolean logic uses TRUE and FALSE values and is fundamental to digital circuits. Basic logic gates include AND (output is TRUE only if all inputs are TRUE), OR (TRUE if at least one input is TRUE), and NOT (inverts the input). NAND and NOR gates are combinations of AND/NOT and OR/NOT; XOR (exclusive OR) gives TRUE when inputs differ.
布尔逻辑使用 TRUE 和 FALSE 值，是数字电路的基础。基本逻辑门包括 AND（仅当所有输入均为 TRUE 时输出为 TRUE）、OR（至少一个输入为 TRUE 时输出为 TRUE）和 NOT（取反）。NAND 和 NOR 是与门/非门和或门/非门的组合；XOR（异或）在输入不同时输出 TRUE。
Truth tables list all possible input combinations and their outputs. Logic circuits can be represented by Boolean expressions; for example, Q = (A AND B) OR (NOT C). Simplifying expressions or designing circuits for a given truth table is a core skill.
真值表列出所有可能的输入组合及其输出。逻辑电路可以用布尔表达式表示，例如 Q = (A AND B) OR (NOT C)。简化表达式或针对给定真值表设计电路是一项核心技能。
10. Database Concepts | 数据库概念
A relational database stores data in tables (relations) composed of rows (records) and columns (fields). Each field has a defined data type, such as INTEGER, VARCHAR, DATE. A primary key uniquely identifies each record, and a foreign key creates a link between tables.
关系型数据库将数据存储在表（关系）中，表由行（记录）和列（字段）组成。每个字段都有一个定义好的数据类型，例如 INTEGER、VARCHAR、DATE。主键唯一标识每条记录，外键建立表之间的连接。
SQL (Structured Query Language) is used to query and manipulate data. A basic SELECT statement retrieves data: SELECT name, score FROM students WHERE score > 80 ORDER BY score DESC;. This selects the name and score fields from the students table where the score exceeds 80, sorted in descending order. INSERT, UPDATE, and DELETE commands modify data.
SQL（结构化查询语言）用于查询和操作数据。基本的 SELECT 语句检索数据：SELECT name, score FROM students WHERE score > 80 ORDER BY score DESC;。它从 students 表中选择 name 和 score 字段，条件是 score 大于 80，并按降序排列。INSERT、UPDATE 和 DELETE 命令用于修改数据。
11. Data Storage and Compression | 数据存储与压缩
Primary storage includes RAM (volatile, holds current data and instructions) and ROM (non-volatile, stores firmware such as BIOS). Virtual memory uses part of the hard disk as an overflow for RAM, but it is much slower. Secondary storage technologies include magnetic hard disks (high capacity, low cost per GB), optical discs (CD, DVD) and solid-state drives (SSDs), which are faster and more robust but more expensive per GB. Cloud storage offers remote access via the internet, with advantages of scalability and disaster recovery, but depends on network connectivity.
主存储器包括 RAM（易失性，保存当前数据和指令）和 ROM（非易失性，存储固件，如 BIOS）。虚拟内存将部分硬盘用作 RAM 的溢出区，但速度慢得多。辅助存储技术包括磁性硬盘（容量大、每 GB 成本低）、光盘（CD、DVD）以及固态硬盘（SSD），后者速度更快、更坚固，但每 GB 成本更高。云存储通过互联网提供远程访问，具有可扩展性和灾难恢复等优点，但依赖于网络连接。
Compression reduces file size for efficient storage and transfer. Lossless compression retains all original data, using techniques like run-length encoding (RLE), where repeated values are encoded as value and count. Lossy compression permanently removes some data, acceptable for images (JPEG), audio (MP3) and video (MPEG), where a small loss in quality is invisible to most users. The compression ratio is calculated as compressed size ÷ original size.
压缩减小文件大小，以提高存储和传输效率。无损压缩保留所有原始数据，使用诸如行程编码（RLE）的技术，将重复值编码为值和计数。有损压缩永久移除部分数据，适用于图像（JPEG）、音频（MP3）和视频（MPEG），对于多数用户而言微小的质量损失不可察觉。压缩率计算公式为：已压缩大小 ÷ 原始大小。
Published by TutorHao | CCEA 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课程辅导，国外大学本科硕士研究生博士课程论文辅导