Experimental Operation Guide for A-Level WJEC Computer Science | A-Level WJEC 计算机：实验操作指南

📚 Experimental Operation Guide for A-Level WJEC Computer Science | A-Level WJEC 计算机：实验操作指南

This guide provides a structured approach to conducting practical experiments for the WJEC A-Level Computer Science specification. Whether you are implementing algorithms, exploring data structures, querying databases, or preparing for the Non-Exam Assessment (NEA) programming project, systematic experimental practice is essential. You will learn how to set up your environment, carry out typical experiments, debug effectively, and document your findings. Following these steps will help you develop both technical proficiency and the analytical skills needed for the final assessment.

本指南为 WJEC A-Level 计算机科学课程的实验操作提供了一套系统的方法。无论是在实现算法、探索数据结构、进行数据库查询，还是准备非考试评估（NEA）编程项目，系统的实验实践都至关重要。你将学习如何设置实验环境、完成典型的实验任务、高效调试，并记录你的发现。遵循这些步骤将有助于你提升技术能力，并培养终期评估所需的分析技能。

1. Understanding the Experimental Environment | 了解实验环境

Before diving into code, familiarize yourself with the software and hardware resources available on your school network or personal machine. WJEC expects candidates to be competent in an Integrated Development Environment (IDE) such as IDLE, PyCharm, or Visual Studio. Check that your IDE supports Python 3.x or VB.NET, as these are the recommended languages for the specification. Ensure that the necessary libraries for handling files, databases, and networking are installed and accessible.

在动手编写代码之前，请先熟悉学校网络或个人电脑上可用的软硬件资源。WJEC 期望考生能够熟练使用集成开发环境（IDE），例如 IDLE、PyCharm 或 Visual Studio。请确认你的 IDE 支持 Python 3.x 或 VB.NET，因为它们是课程大纲推荐的编程语言。同时，确保处理文件、数据库和网络连接所需的库已安装并可用。

Create a dedicated folder structure for your experiments. For example, maintain separate subfolders for ‘Algorithms’, ‘DataStructures’, ‘Database’, and ‘Networking’. This organization will mirror the way you are expected to manage evidence in the NEA project. Set up version control using Git or at least keep dated backup copies of your work to avoid losing progress during experimentation.

为你的实验创建一个专用的文件夹结构。例如，分别建立“算法”、“数据结构”、“数据库”和“网络”子文件夹。这种组织方式将与你管理 NEA 项目证据的预期方式一致。可以使用 Git 进行版本控制，或者至少保留带日期的备份副本，以免在实验过程中丢失工作进度。

2. Setting Up Your Programming Environment | 设置编程环境

Install the required interpreter or compiler and verify that it runs correctly from the command line. For Python, type python --version in the terminal; for VB.NET, ensure you have the .NET SDK installed and test with a simple console application. Configure your IDE with appropriate linting and code completion plugins to reduce syntax errors early.

安装所需的解释器或编译器，并在命令行中验证其能否正常运行。对于 Python，在终端中输入 python --version；对于 VB.NET，请确保安装了 .NET SDK，并通过一个简单的控制台应用程序进行测试。为你的 IDE 配置适当的代码检查与自动补全插件，以便尽早减少语法错误。

If your experiments involve database connectivity, install a lightweight database server such as SQLite (built into Python) or set up a remote MySQL connection. For network experiments, configure a packet sniffer like Wireshark with the appropriate permissions, or use loopback addresses to simulate client-server interactions locally. Always work within a sandboxed environment when testing code that accesses the file system or network resources.

如果你的实验涉及数据库连接，请安装一个轻量级数据库服务器，例如 SQLite（Python 内置），或设置远程 MySQL 连接。对于网络实验，请配置具有适当权限的数据包嗅探器（如 Wireshark），或使用回环地址在本地模拟客户端-服务器交互。在测试访问文件系统或网络资源的代码时，务必在沙盒环境中操作。

3. Implementing Algorithms: Step-by-Step | 算法实现：分步指导

Begin by translating an algorithm described in pseudocode into your chosen programming language. For instance, implement a linear search on a list of integers. Write a function that accepts a target value and an array, then returns the index or -1 if not found. Test the function with boundary cases such as an empty list, a single-element list, and a list where the target appears at the start, middle, and end.

首先，将一段用伪代码描述的算法转换成你所选的编程语言。例如，在一个整数列表上实现线性搜索。编写一个函数，接受目标值和数组作为参数，然后返回索引，若未找到则返回 -1。用边界情况测试该函数，如空列表、单元素列表，以及目标值出现在开头、中间和末尾的列表。

Next, implement a binary search. Note that this algorithm requires a sorted list. Record the number of comparisons made in each test case and compare it with the theoretical time complexity O(log n). Use a counter variable to verify your experimental results align with the asymptotic analysis. Repeat the process for sorting algorithms like bubble sort and merge sort, observing how their running times scale with input size.

接下来，实现二分搜索。注意，该算法要求列表已排序。记录每个测试用例中比较的次数，并将其与理论时间复杂度 O(log n) 进行比较。使用一个计数器变量来验证你的实验结果是否与渐近分析一致。对冒泡排序和归并排序等排序算法重复此过程，观察它们的运行时间如何随输入规模的增大而增长。

A common experiment involves timing how long each algorithm takes for different data sizes. Use the time module in Python or Stopwatch in VB.NET to measure execution time. Plot the results on a simple graph to visualize linear vs. logarithmic vs. quadratic growth.

常见的实验还包括测量每种算法在不同数据规模下所需的时间。使用 Python 的 time 模块或 VB.NET 的 Stopwatch 来测量执行时间。将结果绘制在简单的图表上，以便直观地观察线性、对数和二次增长的区别。

4. Data Structures in Practice | 数据结构实践

Dynamic data structures such as stacks, queues, and linked lists can be explored by building custom classes. Create a stack class with push and pop methods that operate on a Python list. Ensure that pop raises an appropriate error (or returns None) when the stack is empty. Document how the stack pointer changes with each operation.

动态数据结构（如栈、队列和链表）可以通过构建自定义类来进行探索。创建一个栈类，其 push 和 pop 方法作用于 Python 列表。确保当栈空时，pop 会引发适当的错误（或返回 None）。记录每次操作时栈指针的变化情况。

For a queue, implement a circular buffer using a fixed-size array and two pointers: front and rear. This exercise will prepare you for the internal representation of data structures covered in the specification. Write a test harness that enqueues items until the buffer is full, then dequeues some items, and finally enqueues again to demonstrate wraparound behaviour.

对于队列，使用固定大小的数组以及 front 和 rear 两个指针来实现一个循环缓冲区。这个练习将帮助你掌握课程大纲中数据结构的内部表示。编写一个测试套件：入队元素直至缓冲区满，然后出队部分元素，最后再次入队，以展示回绕行为。

Linked lists require manual memory management awareness. In Python, you can simulate nodes with objects holding data and a reference to the next node. Implement insertion and deletion at a specified position, and draw memory diagrams to accompany your code. This visual documentation will be valuable for revision and for the NEA write-up.

链表需要对内存管理有清晰的认识。在 Python 中，你可以使用包含数据和对下一个节点引用的对象来模拟节点。实现指定位置的插入与删除操作，并绘制内存示意图与代码配套。这种可视化文档对复习以及 NEA 的撰写都非常有价值。

5. Database Query Experiments | 数据库查询实验

WJEC requires understanding of relational databases and SQL. Set up a practice database with at least two tables, such as Student and Course, linked by a foreign key. Populate the tables with sample data. Write SQL queries to perform SELECT, INSERT, UPDATE, and DELETE operations. Test queries with WHERE clauses, LIKE, and BETWEEN to filter data effectively.

WJEC 要求掌握关系数据库和 SQL。建立一个至少包含两个表的练习数据库，例如通过外键关联的 Student 和 Course 表。向表中填充示例数据。编写 SQL 查询以执行 SELECT、INSERT、UPDATE 和 DELETE 操作。测试包含 WHERE 子句、LIKE 和 BETWEEN 的查询，以便有效地筛选数据。

Experiment with joining tables using INNER JOIN and LEFT JOIN. Write queries that answer real-world questions, like “Which students are enrolled in more than one course?” or “What is the average score for each course?” Use aggregate functions (COUNT, AVG, MAX, MIN) and GROUP BY clauses. Save each query in a text file with comments explaining its purpose.

使用 INNER JOIN 和 LEFT JOIN 进行表连接实验。编写能够回答现实问题的查询，例如“有哪些学生选修了多门课程？”或“每门课程的平均分是多少？”。使用聚合函数（COUNT、AVG、MAX、MIN）和 GROUP BY 子句。将每个查询保存到文本文件中，并添加注释解释其用途。

To link SQL with your programming code, use the sqlite3 module in Python to execute queries from within a script. This integration demonstrates how back-end systems retrieve data dynamically. Be sure to handle exceptions such as connection failures or malformed SQL, and log them appropriately.

为了将 SQL 与编程代码结合起来，使用 Python 的 sqlite3 模块从脚本中执行查询。这种集成演示了后端系统如何动态地检索数据。务必处理连接失败或 SQL 语法错误等异常，并适当记录日志。

6. Networking Simulations | 网络模拟实验

Network concepts can be practically explored by building simple client-server applications using sockets. Create a server that listens on a specific port and echoes back any message received. Write a client that connects to the server, sends data, and displays the response. Run both programs on the same machine using localhost (127.0.0.1) to observe the TCP handshake.

网络概念可以通过使用套接字构建简单的客户端-服务器应用程序来进行实践探索。创建一个在特定端口上侦听的服务器，并将收到的任何消息回显回去。编写一个客户端，连接到服务器、发送数据并显示响应。在同一台机器上使用 localhost (127.0.0.1) 运行这两个程序，观察 TCP 握手过程。

Use Wireshark to capture the packets exchanged during the communication. Identify the SYN, SYN-ACK, and ACK flags that establish the connection. Filter the capture by the port number or protocol to isolate the relevant traffic. This hands-on experience solidifies your understanding of the TCP/IP stack beyond textbook theory.

使用 Wireshark 捕获通信过程中交换的数据包。识别用于建立连接的 SYN、SYN-ACK 和 ACK 标志。按端口号或协议过滤捕获结果，以隔离相关的流量。这种动手实践能巩固你对 TCP/IP 协议栈的理解，而不只是停留在课本理论上。

Simulate packet loss or delays by introducing artificial latency in the client code (e.g., using time.sleep) and observe how the server handles timeouts. Modify the socket to use UDP instead and note the difference in behaviour (no handshake, no guarantee of delivery). These experiments link directly to the networking topics in Component 2.

通过在客户端代码中引入人为延迟（例如使用 time.sleep）来模拟丢包或延迟，并观察服务器如何处理超时。将套接字修改为使用 UDP，并注意行为上的差异（无握手，不保证送达）。这些实验直接与 Component 2 中的网络主题相关联。

7. Debugging and Testing | 调试与测试

Effective debugging starts with isolating a failing test case. When an algorithm produces incorrect output, reduce the input to the smallest possible size that still triggers the bug. Use print statements or a debugger to inspect variable values at key points. In Python, the pdb module allows you to step through code line by line; in VB.NET, use breakpoints and the Immediate Window.

高效调试始于隔离失败的测试用例。当算法产生错误的输出时，将输入缩减到仍能触发该错误的最小规模。使用打印语句或调试器在关键点检查变量值。在 Python 中，pdb 模块允许你逐行单步执行代码；在 VB.NET 中，则使用断点和即时窗口。

Develop a systematic testing plan covering normal, boundary, and erroneous data. For each experiment, create a table listing test ID, input, expected output, actual output, and pass/fail status. This resembles the testing log required in the NEA project. Pay special attention to off-by-one errors in loops, incorrect termination conditions in recursion, and mishandled null references in data structures.

制定一份系统的测试计划，涵盖正常数据、边界数据和错误数据。为每个实验创建一个表格，列出测试 ID、输入、预期输出、实际输出以及通过/失败状态。这与 NEA 项目所需的测试日志相似。特别注意循环中的边界错误（off-by-one）、递归中不正确的终止条件，以及数据结构中空引用的处理错误。

Automate repetitive tests where possible. Write unit tests using unittest in Python or a testing framework in VB.NET. Running all tests after each code change ensures that fixes do not introduce new bugs (regression testing). Include these tests in your experiment documentation to evidence rigorous quality control.

尽可能自动化重复性测试。使用 Python 的 unittest 或 VB.NET 的测试框架编写单元测试。在每次代码更改后运行所有测试，可确保修复不会引入新的缺陷（回归测试）。将这些测试包含在实验文档中，以证明你实施了严格的质量控制。

8. Documenting Your Experiment | 记录实验

Maintain a lab notebook or a digital log for every experiment. Start each entry with the date, objective, and a brief hypothesis. As you code, record any surprising observations or difficulties encountered. This reflective practice is not only good scientific method but also generates rich content for the evaluation section of the NEA report.

为每个实验维护一本实验笔记本或数字日志。每次记录都以日期、目标和简要假设开头。在编写代码时，记录下任何令人惊讶的观察发现或遇到的困难。这种反思性实践不仅是良好的科学方法，也能为 NEA 报告的评价部分提供丰富的内容。

Include annotated screenshots or code snippets with explanatory comments. When presenting results, use tables and charts to summarise performance data. Compare your empirical timings with theoretical expectations and discuss reasons for any discrepancies (e.g., hardware limitations, background processes, language overhead).

包含带注释的屏幕截图或代码片段，并附上解释性注释。在展示结果时，使用表格和图表汇总性能数据。将你的经验计时与理论预期进行比较，并讨论任何差异的原因（例如硬件限制、后台进程、语言开销）。

A well-structured experiment document typically contains: Introduction, Materials & Methods, Results, Discussion, and Conclusion. Even for small classroom tasks, adopt this structure; it will become second nature by the time you start the NEA.

一份结构良好的实验文档通常包含：引言、材料与方法、结果、讨论和结论。即使是对小型课堂练习，也请采用这种结构；到你开始 NEA 时，它就会成为你的第二天性。

9. Common Pitfalls and Solutions | 常见陷阱与解决方案

Indentation errors in Python: Mixing tabs and spaces is a frequent mistake. Configure your IDE to convert tabs to spaces automatically. Perform a manual check if the code behaves unexpectedly. | Python 中的缩进错误：混用制表符和空格是常见错误。配置 IDE 自动将制表符转换为空格。如果代码行为异常，请手动检查。
Infinite loops: Always include a termination condition that is guaranteed to be reached. Insert a loop counter that raises an exception after a safe maximum number of iterations. | 无限循环：务必包含一个保证能够达到的终止条件。插入一个循环计数器，在安全的最高迭代次数后引发异常。
Database connection leaks: Ensure every opened connection or cursor is closed in a finally block or via a context manager (Python’s with statement). Leaked connections can lock the database. | 数据库连接泄漏：确保每个打开的连接或游标都能在 finally 块或通过上下文管理器（Python 的 with 语句）关闭。泄漏的连接可能会锁定数据库。
Index out of bounds: Validate array indices against the length of the structure before accessing. When implementing binary search or quicksort, double-check the midpoint and partition boundaries. | 索引越界：在访问之前，根据结构的长度验证数组索引。在实现二分搜索或快速排序时，仔细检查中点与分区的边界。
Type mismatches in user input: Always convert and validate input before use. Use try-except blocks to catch ValueError or FormatException. | 用户输入中的类型不匹配：在使用前务必转换并验证输入。使用 try-except 块捕获 ValueError 或 FormatException。

10. Preparing for the Project (NEA) | 为编程项目（NEA）做准备

The skills practised through these experiments directly support Component 3: the programming project. Your NEA must identify a real problem, analyse requirements, design a solution, develop and test it iteratively, and critically evaluate the outcome. Begin brainstorming ideas early and map them against the marking criteria.

通过这些实验所练习的技能直接支持 Component 3：编程项目。你的 NEA 必须识别一个真实的问题，分析需求，设计解决方案，迭代地开发和测试它，并批判性地评估成果。尽早开始构思想法，并将它们与评分标准对应起来。

Use the experimental techniques from this guide to prototype core functionality before committing to a full design. For example, if your project involves a booking system, experiment with database operations and user authentication in a separate mini-project. These prototypes reduce risk and produce evidence of technical investigation for your report.

在确定完整设计之前，运用本指南中的实验技术对核心功能进行原型设计。例如，如果你的项目涉及一个预订系统，可以在一个独立的小型项目中实验数据库操作和用户身份验证。这些原型设计可以降低风险，并为你的报告提供技术调研的证据。

Document every stage of your project development in the same structured way you practised during experiments. Maintain a clear time plan, record meeting notes if working with a client, and keep all versions of your code. The final project should demonstrate a logical journey from initial concept to a fully functional program, supported by rigorous testing and evaluation.

以你实验期间练习过的同样结构化的方式来记录项目开发的每个阶段。制定清晰的时间计划，如果与客户合作则记录会议笔记，并保留所有版本的代码。最终项目应展示从初始概念到功能完善的程序的合理旅程，并辅以严格的测试和评估。

NEA Marking Criterion	Key Activities
Analysis (10 marks)	Problem definition, stakeholder identification, requirements specification, research into existing solutions.
Design (15 marks)	Algorithms, data structures, UI mock-ups, test plans, system architecture diagrams.
Development (25 marks)	Iterative coding, debugging, version control, integration of components, evidence of progress.
Testing & Evaluation (10 marks)	Unit, integration, and system testing; user acceptance testing; evaluation against original objectives.

Table 1 – Summary of NEA marking criteria and associated activities.

表 1 – NEA 评分标准及相关活动总结。

An experimental mindset—curiosity, systematic variation, and careful observation—is your greatest asset in both the examined components and the NEA. By making experimentation a regular habit, you will deepen your understanding and be well prepared for any practical task that appears in the WJEC A-Level Computer Science assessment.

实验思维——好奇心、系统性变化与仔细观察——是你在考试模块和 NEA 中最大的财富。通过把实验变成一种常态习惯，你将加深理解，并为 WJEC A-Level 计算机科学评估中可能出现的任何实践任务做好充分准备。

Published by TutorHao | Computer Science Revision Series | aleveler.com

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

Experimental Operation Guide for A-Level WJEC Computer Science | A-Level WJEC 计算机：实验操作指南