📚 Key Skills for Cambridge Year 9 Computing Practical Assessments | 剑桥九年级计算机实践考核核心要点
Practical assessments in Year 9 Cambridge Computing test your ability to apply computational thinking in real tasks. You need to show proficiency in coding, data handling, web design, and safe practices. This article breaks down the essential skills to help you prepare.
九年级剑桥计算机实践考核考查你在真实任务中运用计算思维的能力。你需要展示在编程、数据处理、网页设计和安全实践方面的熟练程度。本文将梳理必备技能，帮助你做好准备。
1. Understanding the Assessment Objectives | 理解考核目标
Cambridge practical tasks focus on problem-solving, logical reasoning, and effective use of digital tools. You are assessed not just on the final product, but also on your process, efficiency, and ability to explain your work.
剑桥实践任务注重问题解决、逻辑推理和数字工具的有效使用。考核不仅关注最终成果，还关注你的过程、效率以及解释工作的能力。
Always read the rubric carefully to know what is expected, including marks for planning, implementation, testing, and evaluation. Breaking down the mark scheme helps you allocate time wisely during the assessment.
务必仔细阅读评分标准，了解预期要求，包括计划、实现、测试和评估各部分的评分。剖析评分方案有助于你在考核期间合理分配时间。
Past papers and specimen tasks reveal common patterns: you may be asked to create a program, design a database, or build a simple website. Familiarise yourself with the command words such as 'create', 'modify', 'test' and 'evaluate'.
历年真题和样题揭示了常见模式：你可能会被要求编写程序、设计数据库或构建简单网站。要熟悉“创建”“修改”“测试”“评估”等指令词。
2. Programming Basics: Variables and Loops | 编程基础：变量与循环
Variables store data that can change as a program runs. In Python, you can assign a value to a variable using score = 0. It is essential to name variables clearly, such as player_name or total_count.
变量用来存储程序运行过程中可以改变的数据。在 Python 中，你可以用 score = 0 为变量赋值。清晰的命名至关重要，例如 player_name 或 total_count。
Loops let you repeat instructions without writing the same code many times. A for loop is useful when you know how many repetitions are needed: for i in range(5): print(i). A while loop, on the other hand, runs as long as a condition is true.
循环使你无需多次编写相同代码就能重复执行指令。当你知道需要重复多少次时，for 循环很有用：for i in range(5): print(i)。而 while 循环在条件为真时持续运行。
In practical tasks, you might need to calculate a running total or validate user input with a loop. Make sure your loop has a clear exit condition to avoid infinite loops that crash your program.
在实际任务中，你可能需要用循环计算累加总和或验证用户输入。确保循环有明确的退出条件，以免发生无限循环导致程序崩溃。
3. Conditionals and Logical Operations | 条件判断与逻辑运算
Conditionals allow a program to make decisions. The if, elif, and else statements control which block of code runs. For example, if temperature > 30: print("Hot") checks a comparison and acts on it.
条件判断使程序能够做出决定。if、elif 和 else 语句控制执行哪个代码块。例如 if temperature > 30: print("Hot") 会检查比较结果并据此行动。
You can combine conditions using logical operators: and, or, and not. A practical exam might ask you to check if a user's age is between 13 and 19 using if age >= 13 and age <= 19:.
你可以使用逻辑运算符组合多个条件：and、or 和 not。实践考查可能要求你检查用户年龄是否在13到19岁之间，使用 if age >= 13 and age <= 19:。
Always test your conditions with boundary values. If a condition is mark >= 50, test exactly 50, 49, and 51 to make sure the program behaves correctly.
务必使用边界值测试你的条件。若条件为 mark >= 50，要分别测试 50、49 和 51，以确保程序行为正确。
4. Working with Lists and Arrays | 列表与数组操作
Lists (or arrays) hold multiple items under a single name. In Python, you create a list using square brackets: scores = [12, 8, 15, 10]. You can access an element by its index, e.g. scores[0] gives 12.
列表（或数组）可以在一个名称下存放多个项目。在 Python 中，用方括号创建列表：scores = [12, 8, 15, 10]。你可以通过索引访问元素，如 scores[0] 得到 12。
Practical tasks often involve iterating through a list to find the largest value, compute an average, or filter data. Use a for loop: for s in scores: total = total + s.
实践任务通常涉及遍历列表以查找最大值、计算平均值或筛选数据。使用 for 循环：for s in scores: total = total + s。
You may also need to add items (append()), remove items (remove()), or sort a list. Remember that list indexes start at 0, a common source of off-by-one errors in exams.
你可能还需要添加项目（append()）、移除项目（remove()）或对列表进行排序。请记住列表索引从 0 开始，这是考查中常见的差一错误来源。
5. Debugging Techniques | 调试技巧
Debugging is a vital skill. When your code doesn't work, read the error message carefully; it often tells you the line number and type of mistake, such as SyntaxError or NameError.
调试是一项至关重要的技能。当代码无法运行时，仔细阅读错误信息；它通常会告诉你行号和错误类型，例如 SyntaxError 或 NameError。
Use print statements to check the values of variables at different stages. For example, inserting print("Current total:", total) helps you see if the calculation is correct as the program runs.
使用打印语句在不同阶段检查变量的值。例如插入 print("Current total:", total) 可帮助你观察程序运行时计算是否正确。
In practical assessments, you may be given faulty code to fix. Trace through the program manually, write down variable values, and identify where the logic fails. Comment out sections temporarily to isolate the problem.
在实际考核中，你可能需要修复有缺陷的代码。手动跟踪程序，记录变量值，找出逻辑出错的位置。临时注释掉部分代码可以隔离问题。
6. Spreadsheet Skills for Data Analysis | 电子表格数据分析技能
You might be asked to use a spreadsheet application to organise and analyse data. Know how to enter labels, numeric data, and apply formatting such as currency or percentage. Use cell references correctly in formulas.
你可能需要使用电子表格应用程序来整理和分析数据。要懂得输入标签、数值数据，并应用货币或百分比等格式。在公式中正确使用单元格引用。
Common functions tested include SUM, AVERAGE, MAX, MIN, and COUNT. A formula like =SUM(B2:B8) adds all values in that range. Absolute references, such as $B$2, are needed when copying a formula across cells.
常考的函数包括 SUM、AVERAGE、MAX、MIN 和 COUNT。像 =SUM(B2:B8) 这样的公式会将该区域中的所有数值相加。在跨单元格复制公式时，需要使用绝对引用，如 $B$2。
You should be able to create charts (bar, line, pie) to visualise data. Select the correct data range, add a title and axis labels, and choose a suitable chart type. Conditional formatting can highlight values above a threshold.
你应该能够创建图表（条形图、折线图、饼图）来可视化数据。选择正确的数据区域，添加标题和坐标轴标签，并选取合适的图表类型。条件格式可以突出显示超过阈值的值。
7. Database Querying with SQL | 使用SQL进行数据库查询
For database tasks, you need to understand the structure of a table: fields, records, and primary keys. Use SQL to retrieve specific information. The basic command is SELECT * FROM table_name;.
对于数据库任务，你需要理解表的结构：字段、记录和主键。使用 SQL 来检索特定信息。基本命令是 SELECT * FROM table_name;。
To filter records, add a WHERE clause: SELECT name, grade FROM students WHERE grade > 75;. You can also sort results using ORDER BY, for example ORDER BY surname ASC.
要过滤记录，添加 WHERE 子句：SELECT name, grade FROM students WHERE grade > 75;。你还可以用 ORDER BY 对结果排序，例如 ORDER BY surname ASC。
In practical exams, you may be asked to perform queries that join two tables or use aggregate functions like COUNT and AVG. Practice using wildcard characters such as % with the LIKE operator for pattern matching.
在实践考查中，可能要求你执行连接两个表的查询，或者使用 COUNT 和 AVG 等聚合函数。练习在 LIKE 运算符中使用 % 等通配符进行模式匹配。
8. Web Page Design using HTML and CSS | 使用HTML和CSS设计网页
You may be required to create a simple web page. Know the basic structure of an HTML document: <html>, <head>, and <body> tags. The <title> inside <head> sets the page's title shown in the browser tab.
你可能会被要求创建一个简单的网页。要了解 HTML 文档的基本结构：<html>、<head> 和 <body> 标签。<head> 内的 <title> 用于设置显示在浏览器标签页中的页面标题。
Use heading tags (<h1> to <h6>), paragraphs (<p>), images (<img src="url">), and hyperlinks (<a href="url">) to build content. CSS can style these elements: for example, h1 {color: blue; font-family: Arial;}.
使用标题标签（<h1> 到 <h6>）、段落（<p>）、图像（<img src="url">）和超链接（<a href="url">）来构建内容。CSS 可以为这些元素设置样式，例如 h1 {color: blue; font-family: Arial;}。
Practical assessments often ask you to embed a table, use an external stylesheet, or ensure responsive design. Always test your page in a browser to check that all links and images display correctly.
实践考核通常会要求嵌入表格、使用外部样式表或确保响应式设计。务必在浏览器中测试你的页面，检查所有链接和图像是否正确显示。
9. Safe and Ethical Computing Practices | 计算机安全与道德实践
Digital literacy includes keeping data secure. You should know how to create strong passwords—using a mix of uppercase, lowercase, numbers, and symbols—and never share them. Recognise phishing attempts and avoid clicking suspicious links.
数字素养包括确保数据安全。你应该知道如何创建强密码——混合使用大小写字母、数字和符号——并且绝不分享密码。识别网络钓鱼行为，避免点击可疑链接。
Respect copyright and privacy. Use Creative Commons images and cite sources. Never share personal information of others without permission, and understand the consequences of cyberbullying.
尊重版权和隐私。使用知识共享（Creative Commons）图片并注明出处。未经许可绝不要分享他人的个人信息，并了解网络欺凌的后果。
In practical tasks, you may be asked to add data validation to protect a database from incorrect entries, or to discuss why keeping software updated is important for security. Ethics questions expect you to justify a balanced viewpoint.
在实践任务中，你可能需要添加数据验证以保护数据库免受错误输入影响，或者讨论为何保持软件更新对安全很重要。道德类问题期望你能论证一个平衡的观点。
10. Understanding Algorithms and Flowcharts | 理解算法与流程图
An algorithm is a step-by-step solution to a problem. You might be asked to write pseudocode or draw a flowchart before coding. Standard flowchart symbols include oval for start/end, parallelogram for input/output, rectangle for process, and diamond for decision.
算法是解决问题的分步方案。你可能需要先编写伪代码或绘制流程图再编写程序。标准流程图符号包括：椭圆形表示开始/结束，平行四边形表示输入/输出，矩形表示处理过程，菱形表示判断。
Trace tables help you verify an algorithm manually. For example, with a loop that sums numbers from 1 to 5, you would track the loop counter and total at each iteration to ensure accuracy.
跟踪表有助于你手动验证算法。例如，对于一个求 1 到 5 之和的循环，你需要在每次迭代中跟踪循环计数器和总和，以确保准确性。
When designing your own algorithm, break the problem into smaller parts (decomposition). Identify patterns and repeated steps; this often leads to a more efficient solution that scores higher marks.
在设计自己的算法时，将问题分解为更小的部分（分解）。找出模式和重复步骤；这通常会带来更高效的解决方案，从而获得更高分数。
11. Testing and Evaluating Solutions | 测试与评估解决方案
Testing proves your solution works correctly. Plan test cases that include normal data, boundary data, and erroneous data. For each test, state the expected outcome before running it.
测试可以证明解决方案是否正确。规划涵盖正常数据、边界数据和错误数据的测试用例。对每一项测试，在运行前声明预期结果。
Document your tests in a table like the one below. This demonstrates systematic testing and is expected in practical exams.
如下表所示记录你的测试。这展示了系统化的测试方法，也是实践考查中的预期做法。
| Test ID | 测试编号 | Description | 描述 | Input Data | 输入数据 | Expected Result | 预期结果 | Actual Result | 实际结果 | Status | 状态 |
|---|---|---|---|---|---|
| 1 | Normal mark 正常分数 |
65 | Pass 通过 |
Pass 通过 |
Pass 通过 |
| 2 | Boundary mark (just pass) 边界分数（刚及格） |
50 | Pass 通过 |
Pass 通过 |
Pass 通过 |
| 3 | Invalid input (negative) 无效输入（负数） |
-5 | Error message 错误信息 |
Error message 错误信息 |
Pass 通过 |
After testing, evaluate your solution: does it meet all requirements? Could it be more user-friendly or efficient? Suggest realistic improvements; this is a key part of the evaluation criteria.
测试之后，评估你的解决方案：它是否满足所有需求？能否更人性化或更高效？提出切实可行的改进建议；这是评估标准的关键部分。
12. Time Management and Documentation | 时间管理与文档记录
Practical exams are timed, so you must manage each stage carefully. Spend a few minutes planning before you start, and leave time for testing and writing your evaluation. Check the mark weight of each section.
实践考查有时间限制，因此你必须仔细管理每个阶段。开始前花几分钟进行规划，并留出时间进行测试和撰写评估。查看各部分的分数权重。
Keep a clear record of your work. In a programming task, add helpful comments: # This loop calculates the average score. Save your work frequently, and use version numbers (v1, v2) if allowed.
清晰记录你的工作过程。在编程任务中，添加有用的注释：# 此循环计算平均分。经常保存你的工作，若允许，可使用版本号（v1、v2）。
If you get stuck, move on to a different part and come back later. A partially completed solution with good evidence of testing and evaluation can still earn strong marks. Never leave a section completely empty.
如果遇到困难，先跳过做其他部分，稍后再回来。一个部分完成的解决方案，若有良好的测试和评估证据，仍能获得高分。绝不要让任何部分完全空白。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图