CIE A-Level Information Technology: Core Knowledge Points & Study Plan | CIE A-Level 信息技术：核心知识点与学习规划

📚 CIE A-Level Information Technology: Core Knowledge Points & Study Plan | CIE A-Level 信息技术：核心知识点与学习规划

Welcome to this comprehensive guide to CIE A-Level Information Technology. This article is designed to help you understand the core knowledge points, exam structure, and effective study strategies for both AS and A2 levels. Whether you are just starting your course or revising before the final exams, this guide will break down the subject into clear, manageable sections.

欢迎阅读这份 CIE A-Level 信息技术全面指南。本文旨在帮助你理解 AS 和 A2 阶段的核心知识点、考试结构以及高效的学习策略。无论你是刚开始学习这门课程，还是在期末考试前复习，这份指南都将把该学科拆解为清晰、可管理的模块。

1. Overview of the Syllabus | 考纲概览

The CIE A-Level Information Technology syllabus (9626) is divided into two main components: AS Level and A2 Level. The AS Level covers fundamental topics such as hardware, software, networks, and everyday use of IT. The A2 Level builds on this foundation and introduces more advanced topics like systems life cycle, file organisation, and emerging technologies. Assessment is conducted through two written papers for AS and two written papers for A2, with no coursework component.

CIE A-Level 信息技术考纲（代码 9626）分为两个主要部分：AS 阶段和 A2 阶段。AS 阶段涵盖硬件、软件、网络和 IT 日常应用等基础主题。A2 阶段在此基础上深入，引入系统生命周期、文件组织和新兴技术等更高级的主题。评估方式为 AS 两场笔试和 A2 两场笔试，不包含课程作业。

Paper 1 (AS): Written examination, 1 hour 30 minutes, 50 marks. Focuses on hardware, software, and networks.
Paper 2 (AS): Practical test, 2 hours, 60 marks. Assesses spreadsheet, database, and web authoring skills.
Paper 3 (A2): Written examination, 1 hour 30 minutes, 50 marks. Covers advanced theory topics.
Paper 4 (A2): Practical test, 2 hours 30 minutes, 60 marks. Involves complex spreadsheet, database, and web tasks.

试卷一（AS）：笔试，1小时30分钟，满分50分。重点考察硬件、软件和网络。试卷二（AS）：实践测试，2小时，满分60分。评估电子表格、数据库和网页制作技能。试卷三（A2）：笔试，1小时30分钟，满分50分。涵盖高级理论主题。试卷四（A2）：实践测试，2小时30分钟，满分60分。涉及复杂的电子表格、数据库和网页任务。

2. Hardware and Software Fundamentals | 硬件与软件基础

Understanding the distinction between hardware and software is the first essential step. Hardware refers to the physical components of a computer system, while software refers to the programs and instructions that tell the hardware what to do. You need to be familiar with input devices, output devices, storage devices, and the internal components of a computer such as the CPU, RAM, and motherboard.

理解硬件与软件的区别是第一步关键。硬件指计算机系统的物理组件，而软件指告诉硬件该做什么的程序和指令。你需要熟悉输入设备、输出设备、存储设备以及计算机内部组件，如 CPU、RAM 和主板。

CPU (Central Processing Unit): The brain of the computer that executes instructions. Key components include the ALU (Arithmetic Logic Unit), control unit, and registers.
RAM (Random Access Memory): Volatile memory that temporarily stores data and instructions currently in use.
ROM (Read-Only Memory): Non-volatile memory that stores the boot instructions (BIOS/UEFI).
Storage devices: HDD, SSD, optical discs, and solid-state drives. Compare capacity, speed, portability, and durability.

CPU（中央处理器）：计算机执行指令的大脑。关键组件包括 ALU（算术逻辑单元）、控制单元和寄存器。RAM（随机存取存储器）：易失性存储器，临时存储当前正在使用的数据和指令。ROM（只读存储器）：非易失性存储器，存储启动指令（BIOS/UEFI）。存储设备：HDD、SSD、光盘和固态驱动器。从容量、速度、便携性和耐用性等方面进行比较。

For software, you must distinguish between system software (operating systems, utility programs, device drivers) and application software (word processors, spreadsheets, databases, web browsers). The operating system manages hardware resources, provides a user interface, and facilitates file and memory management.

对于软件，你必须区分系统软件（操作系统、实用程序、设备驱动程序）和应用软件（文字处理器、电子表格、数据库、网页浏览器）。操作系统管理硬件资源，提供用户界面，并促进文件和内存管理。

3. Networks and Communication | 网络与通信

Networking is a major topic in CIE A-Level IT. You need to understand the differences between LAN (Local Area Network) and WAN (Wide Area Network), and the various topologies such as star, mesh, and bus. You should also know the roles of network hardware including routers, switches, hubs, and network interface cards (NICs).

网络是 CIE A-Level IT 的重要主题。你需要理解局域网（LAN）和广域网（WAN）之间的区别，以及星型、网状和总线等各种拓扑结构。你还应了解网络硬件的作用，包括路由器、交换机、集线器和网络接口卡（NIC）。

Bandwidth = Maximum data transfer rate (bits per second, bps)

带宽 = 最大数据传输速率（比特每秒，bps）

Key protocols you must know include TCP/IP, HTTP/HTTPS, FTP, SMTP, POP3, and IMAP. You should understand the difference between the Internet and the World Wide Web, and how data is transmitted using packets. Additionally, the concept of IP addressing (IPv4 vs IPv6) and DNS (Domain Name System) is essential for Paper 1.

你必须了解的关键协议包括 TCP/IP、HTTP/HTTPS、FTP、SMTP、POP3 和 IMAP。你应该理解互联网与万维网之间的区别，以及数据如何通过数据包传输。此外，IP 寻址（IPv4 与 IPv6）和 DNS（域名系统）的概念对试卷一至关重要。

Client-server model: A central server provides services to multiple clients. Examples include web servers, file servers, and database servers.
Peer-to-peer model: Each device on the network can act as both client and server, sharing resources directly.
Network security: Firewalls, encryption, authentication, and VPNs (Virtual Private Networks).

客户端-服务器模型：中央服务器向多个客户端提供服务。示例包括 Web 服务器、文件服务器和数据库服务器。对等网络模型：网络上的每台设备既可以充当客户端也可以充当服务器，直接共享资源。网络安全：防火墙、加密、身份验证和 VPN（虚拟专用网络）。

4. Spreadsheets and Data Manipulation | 电子表格与数据处理

Spreadsheet skills are heavily tested in both Paper 2 (AS) and Paper 4 (A2). You need to be comfortable with formulas, functions, cell references (absolute, relative, mixed), and data visualisation using charts and graphs. Common functions include SUM, AVERAGE, COUNT, MAX, MIN, IF, VLOOKUP, and SUMIF.

电子表格技能在试卷二（AS）和试卷四（A2）中均有大量考察。你需要熟练使用公式、函数、单元格引用（绝对、相对、混合）以及使用图表进行数据可视化。常见函数包括 SUM、AVERAGE、COUNT、MAX、MIN、IF、VLOOKUP 和 SUMIF。

=IF(A2 > 50, “Pass”, “Fail”)

=IF(A2 > 50, “通过”, “不及格”)

At A2 level, you are expected to handle more complex tasks such as using nested functions, managing large datasets, creating pivot tables, and using advanced logic such as AND, OR, and NOT. You should also know how to protect worksheets, validate data, and use what-if analysis tools like Goal Seek or Scenario Manager.

在 A2 阶段，你应能处理更复杂的任务，例如使用嵌套函数、管理大型数据集、创建数据透视表，以及使用 AND、OR 和 NOT 等高级逻辑。你还应知道如何保护工作表、验证数据，并使用假设分析工具，如单变量求解或方案管理器。

Absolute reference ($A$1), relative reference (A1), and mixed reference ($A1 or A$1).
Chart types: line, bar, pie, scatter, and their appropriate usage scenarios.
Data validation rules: whole number, decimal, list, date, time, and custom formulas.

绝对引用（$A$1）、相对引用（A1）和混合引用（$A1 或 A$1）。图表类型：折线图、柱状图、饼图、散点图及其适用场景。数据验证规则：整数、小数、列表、日期、时间和自定义公式。

5. Database Concepts | 数据库概念

Databases are another core component of the IT curriculum. You need to understand relational database design, including tables, records, fields, primary keys, foreign keys, and relationships (one-to-one, one-to-many, many-to-many). You should also be able to construct queries using SQL or query-by-example (QBE) interfaces in applications like Microsoft Access.

数据库是 IT 课程的另一个核心组成部分。你需要理解关系数据库设计，包括表、记录、字段、主键、外键和关系（一对一、一对多、多对多）。你还应能使用 SQL 或应用程序（如 Microsoft Access）中的查询设计视图（QBE）构建查询。

Primary key: A unique identifier for each record in a table.
Foreign key: A field in one table that refers to the primary key in another table, used to establish relationships.
Normalisation: The process of organising data to reduce redundancy and improve integrity. At A2, you need to understand first, second, and third normal forms (1NF, 2NF, 3NF).

主键：表中每条记录的唯一定标识。外键：一个表中的字段，引用另一个表中的主键，用于建立关系。规范化：组织数据以减少冗余并提高完整性的过程。在 A2 阶段，你需要理解第一、第二和第三范式（1NF、2NF、3NF）。

Query techniques you must master include filtering, sorting, grouping, calculating totals, and joining multiple tables. For example, you might need to display only students who scored above 80, grouped by class, with an average score calculation for each group.

你必须掌握的查询技术包括筛选、排序、分组、计算总计和多表连接。例如，你可能需要仅显示成绩高于 80 的学生，按班级分组，并计算每组的平均分。

6. Systems Life Cycle | 系统生命周期

The systems life cycle is a key theory topic at A2 Level. It describes the stages involved in creating and maintaining an information system. The stages include: analysis, design, development, testing, implementation, and maintenance. You need to be able to describe the purpose of each stage and the specific activities that take place.

系统生命周期是 A2 阶段的关键理论主题。它描述了创建和维护信息系统所涉及的各个阶段。这些阶段包括：分析、设计、开发、测试、实施和维护。你需要能够描述每个阶段的目的以及所发生的具体活动。

Analysis: Gathering requirements via interviews, questionnaires, observation, and document analysis. Output: feasibility study and requirements specification.
Design: Designing inputs, outputs, user interfaces, and data structures. Prototypes may be created.
Development: Writing the actual code, creating databases, and building the system.
Testing: Test strategies include unit testing, integration testing, system testing, and user acceptance testing.
Implementation: Four methods: direct changeover, parallel running, phased implementation, and pilot running.
Maintenance: Corrective, adaptive, perfective, and preventive maintenance.

分析：通过访谈、问卷、观察和文档分析收集需求。输出：可行性研究和需求规格说明书。设计：设计输入、输出、用户界面和数据结构。可能会创建原型。开发：编写实际代码、创建数据库和构建系统。测试：测试策略包括单元测试、集成测试、系统测试和用户验收测试。实施：四种方法：直接切换、并行运行、分阶段实施和试点运行。维护：修正性、适应性、完善性和预防性维护。

7. File and Data Organisation | 文件与数据组织

At A2 Level, you are expected to understand different file organisation methods and access methods. The main types are serial, sequential, and random (direct) file organisation. You also need to understand fixed-length and variable-length records, and how hashing algorithms are used for random access.

在 A2 阶段，你需要理解不同的文件组织方式和访问方式。主要类型包括串行、顺序和随机（直接）文件组织。你还需要理解定长和变长记录，以及哈希算法如何用于随机访问。

Hashing: record key → hashing algorithm → file address

哈希：记录键 → 哈希算法 → 文件地址

You should also understand the concept of master files and transaction files. A master file contains permanent data about a business or system, while transaction files hold temporary data that updates the master file. For example, in a payroll system, employee details are in the master file, and hours worked each week are in the transaction file.

你还应理解主文件和事务文件的概念。主文件包含关于业务或系统的永久数据，而事务文件保存更新主文件的临时数据。例如，在工资系统中，员工详细信息在主文件中，而每周工作小时数在事务文件中。

8. Web Authoring and Multimedia | 网页制作与多媒体

Web technologies are assessed in both practical papers. You need to know HTML, CSS, and the principles of web design such as accessibility, usability, and consistency. You should be able to create web pages using a text editor or a WYSIWYG tool like Dreamweaver, and you must understand the structure of HTML documents including head, body, meta tags, and semantic elements.

网络技术在两个实践试卷中均有评估。你需要了解 HTML、CSS 以及网页设计的原则，如可访问性、可用性和一致性。你应该能够使用文本编辑器或所见即所得工具（如 Dreamweaver）创建网页，并且必须理解 HTML 文档的结构，包括 head、body、meta 标签和语义元素。

HTML tags: <html>, <head>, <title>, <body>, <p>, <a>, <img>, <table>, <form>.
CSS properties: font-family, color, background-color, margin, padding, border, width, height, float, and position.
Multimedia file formats: JPEG, PNG, GIF, SVG, MP3, MP4, and their appropriate use.

HTML 标签：<html>、<head>、<title>、<body>、<p>、<a>、<img>、<table>、<form>。CSS 属性：font-family、color、background-color、margin、padding、border、width、height、float 和 position。多媒体文件格式：JPEG、PNG、GIF、SVG、MP3、MP4 及其适用场景。

You should also demonstrate awareness of web development best practices, including separating content from presentation, using external style sheets, ensuring responsive design, and validating HTML and CSS.

你还应展示对网页开发最佳实践的认识，包括将内容与表现分离、使用外部样式表、确保响应式设计以及验证 HTML 和 CSS。

9. Emerging Technologies | 新兴技术

The A2 syllabus includes a unit on emerging technologies, which requires you to discuss current and future developments in IT. Topics such as artificial intelligence (AI), machine learning, cloud computing, the Internet of Things (IoT), blockchain, and quantum computing are all relevant. You should be able to evaluate the benefits and drawbacks of these technologies in real-world contexts.

A2 考纲包含新兴技术单元，要求你讨论 IT 当前和未来的发展。人工智能（AI）、机器学习、云计算、物联网（IoT）、区块链和量子计算等主题都很相关。你应该能够评估这些技术在现实世界环境中的优缺点。

Artificial Intelligence: How AI is used in voice assistants, autonomous vehicles, healthcare diagnostics, and recommendation systems.
Cloud Computing: SaaS, PaaS, IaaS models. Benefits include scalability, cost efficiency, and remote access. Drawbacks include security risks and dependency on internet connectivity.
Internet of Things: Smart homes, wearables, and smart cities. Data is collected continuously and transmitted over networks.
Blockchain: A distributed ledger technology used in cryptocurrencies, supply chain tracking, and secure voting.

人工智能：AI 如何用于语音助手、自动驾驶汽车、医疗诊断和推荐系统。云计算：SaaS、PaaS、IaaS 模型。优点包括可扩展性、成本效益和远程访问。缺点包括安全风险和对互联网连接的依赖。物联网：智能家居、可穿戴设备和智慧城市。数据被持续收集并通过网络传输。区块链：一种分布式账本技术，用于加密货币、供应链追踪和安全投票。

10. Safety and Security | 安全与防护

IT security is not just about technical measures; it also involves policies, user behaviour, and legal considerations. You need to know about threats such as malware (viruses, worms, Trojans, ransomware), phishing, social engineering, hacking, and denial-of-service (DoS) attacks. Countermeasures include antivirus software, firewalls, encryption, regular backups, strong password policies, two-factor authentication, and staff training.

IT 安全不仅仅涉及技术措施，还涉及策略、用户行为和法律规定。你需要了解各种威胁，如恶意软件（病毒、蠕虫、木马、勒索软件）、网络钓鱼、社交工程、黑客攻击和拒绝服务（DoS）攻击。应对措施包括杀毒软件、防火墙、加密、定期备份、强密码策略、双因素身份验证和员工培训。

You should also be aware of relevant legislation, such as the Data Protection Act and the Computer Misuse Act in the UK context, and discuss the ethical responsibilities of IT professionals regarding privacy and confidentiality.

你还应了解相关法律，如英国语境下的《数据保护法》和《计算机滥用法案》，并讨论 IT 专业人员在隐私和保密方面的道德责任。

11. Effective Study Plan | 高效学习规划

To succeed in CIE A-Level IT, you need a structured study plan that balances theory with practical work. Start by familiarising yourself with the syllabus and specifications from Cambridge. Then, create a weekly timetable that allocates time for each topic, regular revision, and past paper practice.

要在 CIE A-Level IT 中取得成功，你需要一个结构化学习计划来平衡理论与实践。首先熟悉剑桥官方考纲和规范。然后创建每周时间表，为每个主题、定期复习和真题练习分配时间。

Month 1–2: Cover AS core theory topics: hardware, software, networks, and safety. Work through the textbook and take notes in your own words.
Month 3–4: Focus on practical skills: spreadsheets, databases, web authoring. Practise with sample tasks from past papers.
Month 5: Begin A2 theory topics: systems life cycle, file organisation, emerging technologies.
Month 6: Advanced practical tasks for Paper 4. Explore complex functions, SQL queries, and multi-page websites.
Month 7–8: Full revision of both AS and A2 content. Use active recall, flashcards, and revision notes.
Month 9: Exam practice under timed conditions. Complete at least 5 past papers and analyse your mistakes.

第1-2个月：完成 AS 核心理论主题：硬件、软件、网络和安全。通读教材并用自己的话做笔记。第3-4个月：专注于实践技能：电子表格、数据库、网页制作。使用往年真题中的示例任务进行练习。第5个月：开始 A2 理论主题：系统生命周期、文件组织、新兴技术。第6个月：为试卷四进行高级实践任务。探索复杂函数、SQL 查询和多页网站。第7-8个月：全面复习 AS 和 A2 内容。使用主动回忆、闪卡和复习笔记。第9个月：限时考试练习。至少完成 5 套真题并分析你的错误。

Remember to join online communities, watch video tutorials, and use interactive resources such as Quizlet and Khan Academy. If you are studying with TutorHao, you can also access curated revision materials specifically aligned with the CIE syllabus.

记住加入在线社区，观看视频教程，并使用 Quizlet 和 Khan Academy 等交互式资源。如果你与 TutorHao 一起学习，你还可以访问专门与 CIE 考纲对齐的精选复习材料。

12. Common Pitfalls and Exam Tips | 常见误区与考试技巧

Students often lose marks due to vague answers, incorrect terminology, or failure to show working in practical exams. Here are some common pitfalls and how to avoid them.

学生常常因为答案含糊、术语错误或在实践考试中未展示操作步骤而丢分。以下是一些常见误区及避免方法。

Vague definitions: Always use precise technical terms. For example, do not say “a device that connects computers”; say “a switch connects devices within a LAN using MAC addresses to forward frames.”
Ignoring command words: Pay attention to keywords like “state,” “describe,” “explain,” and “evaluate.” Each requires a different level of detail.
Not practising enough: For practical papers, speed and accuracy come from repeated practice. Use the official past papers and examiner reports.
Poor exam technique: In Paper 2 and Paper 4, save your work regularly and follow all instructions exactly. Do not use advanced features that are not required, as they may cause errors.

定义含糊：始终使用精确的技术术语。例如，不要说“连接计算机的设备”；应说“交换机使用 MAC 地址在局域网内转发帧来连接设备。”忽视指令词：注意“state”、“describe”、“explain”和“evaluate”等关键词。每个词要求不同详细程度。练习不足：对于实践试卷，速度和准确性来自反复练习。使用官方真题和考官报告。考试技巧差：在试卷二和试卷四中，定期保存工作并严格遵循所有指示。不要使用不必要的高级功能，因为它们可能导致错误。

Finally, manage your time wisely. In the practical exams, allocate a few minutes at the end to double-check your work and ensure that all files are saved with the correct filename and in the correct format as instructed by the invigilator.

最后，明智地管理你的时间。在实践考试中，在最后留出几分钟检查你的工作，并确保所有文件以正确的文件名和格式保存，按照监考员的指示执行。

Published by TutorHao | Information Technology Revision Series | aleveler.com

更多咨询请联系16621398022（同微信）

CIE A-Level Information Technology: Core Knowledge Points & Study Plan | CIE A-Level 信息技术：核心知识点与学习规划