📚 Pre-U Edexcel Computer Science: Full Syllabus Breakdown | Pre-U Edexcel 计算机：课程大纲全面解析
The Pre-U Edexcel Computer Science course provides a systematic and rigorous foundation in computing, designed to equip students with both theoretical understanding and practical skills necessary for university-level study. It explores the inner workings of computer systems, the principles of programming and algorithms, and the societal impact of digital technology. This comprehensive syllabus breakdown walks you through every major topic, offering bilingual insights to support your revision and deeper learning.
Pre-U Edexcel 计算机课程为学生提供系统且严格的计算基础，旨在培养学生进入大学学习所需的理论理解和实践技能。课程深入探索计算机系统的内部运作、编程与算法原理以及数字技术的社会影响。这篇大纲全面解析将带你梳理每一个主要主题，以双语解读帮助复习与深入学习。
1. Overview and Structure | 课程概览与结构
The Pre-U Edexcel Computer Science qualification typically comprises examined components and a non-exam assessment (NEA) in the form of a practical programming project. The written examinations assess theoretical knowledge, problem-solving, and algorithmic thinking, while the project evaluates your ability to apply the complete software development lifecycle.
Pre-U Edexcel 计算机科学资格通常由笔试部分和非考试评估（NEA，即实践编程项目）组成。笔试考查理论知识、问题解决和算法思维，而项目则评价你应用完整软件开发周期的能力。
Key areas covered across the syllabus include fundamentals of computer systems, data representation, hardware, software, networking, databases, cybersecurity, and computational thinking. A high-level programming language such as Python, Java, or C# is used throughout the course. The project documentation must include analysis, design, implementation, testing, and evaluation.
课程大纲涵盖的核心领域包括计算机系统基础、数据表示、硬件、软件、网络、数据库、网络安全和计算思维。全程使用如Python、Java或C#等高级编程语言。项目文档须包含分析、设计、实现、测试和评估。
Assessment formula: Total mark = Written Paper 1 + Written Paper 2 + NEA Project
评估公式：总分 = 笔试1 + 笔试2 + NEA项目
2. Fundamentals of Computer Systems | 计算机系统基础
This topic introduces the core hardware architecture: the central processing unit (CPU), main memory (RAM, ROM), secondary storage, and input/output (I/O) devices. Central concepts are the fetch-decode-execute cycle and the Von Neumann architecture, where both instructions and data share the same memory. The system bus is composed of data, address, and control lines.
本主题介绍核心硬件体系结构：中央处理器（CPU）、主存（RAM、ROM）、辅助存储和输入/输出（I/O）设备。核心概念是取指-译码-执行周期以及指令与数据共享同一内存的冯·诺依曼体系结构。系统总线由数据线、地址线和控制线构成。
Factors affecting CPU performance — clock speed, number of cores, and cache size — are examined quantitatively. Students learn to compare embedded systems (such as microcontrollers in IoT devices) with general-purpose computers, recognising their dedicated function, low power consumption, and real-time constraints.
影响CPU性能的因素——时钟速度、核心数量和缓存大小——被量化考查。学生需学会比较嵌入式系统（如物联网设备中的微控制器）与通用计算机，认识其专用功能、低功耗和实时约束。
3. Data Representation | 数据表示
The syllabus covers binary, denary, and hexadecimal number systems and conversions between them. Binary arithmetic (addition, subtraction), overflow errors, and the representation of negative integers using two's complement are essential. A typical conversion example:
大纲涵盖二进制、十进制和十六进制数制及其相互转换。二进制算术（加法、减法）、溢出错误以及使用补码表示负整数是基础。一个典型转换示例：
1101₂ = 1×2³ + 1×2² + 0×2¹ + 1×2⁰ = 8 + 4 + 0 + 1 = 13₁₀
Characters are encoded using ASCII and Unicode; students must explain why Unicode provides a comprehensive solution for global text. Sound is sampled at a rate determined by the Nyquist theorem, and image representation relies on pixels, colour depth, and resolution. Compression methods such as run-length encoding, Huffman coding, and lossy/lossless techniques for images and audio complete this unit.
字符使用ASCII和Unicode编码；学生须解释为何Unicode能为全球文本提供全面的解决方案。声音根据奈奎斯特定理以一定采样率采样，图像表示依赖于像素、色彩深度和分辨率。压缩方法如行程编码、哈夫曼编码以及用于图像和音频的有损/无损技术完善了本单元。
4. Computer Hardware | 计算机硬件
Going deeper into hardware, the CPU's internal components — arithmetic logic unit (ALU), control unit (CU), and dedicated registers (PC, MAR, MDR, CIR) — are studied in the context of instruction execution. Pipelining and the concept of parallel processing (multi-core, GPGPU) illustrate performance enhancement.
深入硬件层面，CPU内部组件——算术逻辑单元（ALU）、控制单元（CU）和专用寄存器（PC、MAR、MDR、CIR）——在指令执行背景下被研究。流水线和并行处理（多核、GPGPU）概念展示了性能提升。
Storage devices are compared by speed, capacity, durability, and cost: magnetic (HDD), solid-state (SSD), and optical (CD/DVD). Logic gates (AND, OR, NOT, NAND, NOR, XOR) form combinational circuits; Boolean expressions are simplified using truth tables and Karnaugh maps. The boot process involves firmware (BIOS/UEFI) loading the operating system, and the CPU handles interrupts via an interrupt service routine.
存储设备按速度、容量、耐用性和成本进行比较：磁性（HDD）、固态（SSD）和光学（CD/DVD）。逻辑门（与、或、非、与非、或非、异或）构成组合电路；使用真值表和卡诺图简化布尔表达式。启动过程涉及固件（BIOS/UEFI）加载操作系统，而CPU通过中断服务例程处理中断。
5. Software and Programming | 软件与编程
System software encompasses operating systems, utility programs (antivirus, defragmentation), and translators — assembler, compiler, and interpreter. The OS manages hardware resources: process scheduling, memory allocation, file management, and security. Students must distinguish between low-level (machine code, assembly) and high-level languages.
系统软件包括操作系统、实用程序（防病毒、碎片整理）和翻译器——汇编器、编译器和解释器。操作系统管理硬件资源：进程调度、内存分配、文件管理和安全性。学生须区分低级语言（机器码、汇编）和高级语言。
Programming fundamentals cover variables, data types (integer, float, string, Boolean), operators, and control structures: sequence, selection (if-else, switch), and iteration (for, while). Subroutines — both procedures and functions — use parameter passing by value or reference. Object-oriented programming (OOP) concepts like encapsulation, inheritance, and polymorphism are often introduced at Pre-U level, along with basic UML class diagrams.
编程基础涵盖变量、数据类型（整型、浮点、字符串、布尔）、运算符和控制结构：顺序、选择（if-else、switch）和迭代（for、while）。子程序——过程和函数——通过值传递或引用传递参数。面向对象编程（OOP）概念如封装、继承和多态通常在Pre-U阶段引入，同时还有基本UML类图。
6. Algorithms and Problem-Solving | 算法与问题求解
Computational thinking forms the backbone: abstraction, decomposition, and pattern recognition. Standard algorithms for searching (linear, binary) and sorting (bubble, insertion, merge, quicksort) are compared using time and space complexity, expressed in Big O notation:
计算思维构成核心：抽象、分解和模式识别。标准搜索（线性、二分）和排序（冒泡、插入、归并、快速排序）算法通过大O符号表示的时间和空间复杂度进行比较：
Linear search O(n), Binary search O(log n), Bubble sort O(n²), Merge sort O(n log n)
Students design algorithms using flowcharts and pseudocode, trace execution with trace tables, and implement recursive solutions (e.g., factorial, Fibonacci, tree traversal). Graph algorithms such as Dijkstra's shortest path and tree traversals (pre-order, in-order, post-order) are also covered. Data structures like stacks, queues, and binary search trees support efficient problem-solving.
学生使用流程图和伪代码设计算法，用跟踪表追踪执行过程，并实现递归解决方案（如阶乘、斐波那契、树遍历）。图算法如迪杰斯特拉最短路径以及树遍历（前序、中序、后序）也被涵盖。栈、队列和二叉搜索树等数据结构支持高效问题求解。
7. Networking and Internet | 网络与互联网
Network types (LAN, WAN, PAN), topologies (star, mesh, bus), and media (UTP, fibre optic, Wi-Fi) are introduced. The TCP/IP protocol stack — application, transport, internet, network access — is compared with the OSI model. Protocols at various layers (HTTP, HTTPS, FTP, SMTP, POP3, IMAP, DNS) are essential knowledge.
网络类型（局域网、广域网、个域网）、拓扑（星形、网状、总线）和介质（非屏蔽双绞线、光纤、Wi-Fi）被介绍。TCP/IP协议栈——应用层、传输层、网际层、网络访问层——与OSI模型进行比较。各层协议（HTTP、HTTPS、FTP、SMTP、POP3、IMAP、DNS）是必备知识。
Packet switching and circuit switching are contrasted; routers, switches, and gateways operate at different layers. IP addressing (IPv4, IPv6) and subnetting are covered, along with how DNS resolves domain names. Network security basics — firewalls, symmetric (AES) and asymmetric (RSA) encryption, digital signatures and certificates — are often integrated here.
包交换与电路交换形成对比；路由器、交换机和网关在不同层运行。涵盖IP寻址（IPv4、IPv6）和子网划分，以及DNS如何解析域名。网络安全基础——防火墙、对称加密（AES）和非对称加密（RSA）、数字签名与证书——常整合于此。
8. Databases | 数据库
The relational database model uses tables with primary keys and foreign keys to enforce integrity. Students design databases by normalising to third normal form (3NF), eliminating partial and transitive dependencies. Entity-relationship diagrams (ERDs) show cardinalities: one-to-one, one-to-many, many-to-many.
关系数据库模型使用带有主键和外键的表来强化完整性。学生通过规范化至第三范式（3NF）设计数据库，消除部分依赖和传递依赖。实体关系图（ERD）显示基数：一对一、一对多、多对多。
SQL commands for data definition (CREATE TABLE, ALTER) and data manipulation (SELECT, INSERT, UPDATE, DELETE) are practised. Queries often involve filtering with WHERE, ordering with ORDER BY, and joining tables using INNER JOIN or LEFT JOIN. ACID properties (Atomicity, Consistency, Isolation, Durability) ensure reliable transaction processing.
实践数据定义语言（CREATE TABLE、ALTER）和数据操作语言（SELECT、INSERT、UPDATE、DELETE）的SQL命令。查询常涉及WHERE过滤、ORDER BY排序以及使用INNER JOIN或LEFT JOIN连接表。ACID特性（原子性、一致性、隔离性、持久性）确保可靠的事务处理。
9. Operating Systems | 操作系统
Beyond the basic OS role, this section delves into process management: process states (ready, running, blocked) and scheduling algorithms (First-Come First-Served, Round Robin, priority, shortest job first). Concurrency issues like race conditions and the need for mutual exclusion (semaphores, locks) are discussed.
除基本OS角色外，本节深入进程管理：进程状态（就绪、运行、阻塞）和调度算法（先来先服务、轮转、优先级、最短作业优先）。并发问题如竞争条件以及互斥的需要（信号量、锁）被讨论。
Memory management includes paging, segmentation, and virtual memory, which allows execution of programs larger than physical RAM. The OS uses device drivers to standardise I/O communication. Security features — user authentication, access control, and anti-malware integration — are highlighted as part of the OS's responsibility.
内存管理包括分页、分段和虚拟内存，后者允许执行大于物理RAM的程序。操作系统使用设备驱动程序标准化I/O通信。安全特性——用户身份验证、访问控制以及反恶意软件集成——被强调为OS职责的一部分。
10. Cybersecurity and Ethical Issues | 网络安全与道德问题
Modern computing must address threats: malware (viruses, worms, trojans, ransomware), social engineering (phishing), DoS/DDoS attacks, and SQL injection. Defensive strategies include penetration testing, encryption, biometrics, CAPTCHA, two-factor authentication, and regular software patches.
现代计算必须应对威胁：恶意软件（病毒、蠕虫、木马、勒索软件）、社会工程（网络钓鱼）、DoS/DDoS攻击和SQL注入。防御策略包括渗透测试、加密、生物识别、验证码、双因素认证和定期软件补丁。
Ethical and legal considerations cover data privacy, intellectual property, AI accountability, and the digital divide. UK legislation like the Data Protection Act 2018, Computer Misuse Act 1990, and GDPR principles are referenced. Environmental concerns — energy usage of data centres, e-waste disposal, and sustainable IT practices — also appear in the syllabus.
伦理和法律考量涵盖数据隐私、知识产权、人工智能问责和数字鸿沟。引用英国法律如2018年《数据保护法》、1990年《计算机滥用法》以及GDPR原则。环境问题——
Published by TutorHao | Pre-U Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图