📚 Cambridge Year 7 Computer Science: Key Points for Practical Assessments | 剑桥Year 7计算机科学：实验/实践考核要点
Practical assessments in Year 7 Cambridge Computer Science are designed to evaluate how well you can use computing tools to solve problems and communicate ideas. Instead of simply recalling facts, you must show that you can plan a task, choose the correct software, apply logical thinking, and reflect on your work. This article breaks down the core areas often tested in hands-on examinations, gives you clear success criteria, and offers tips to help you approach each task with confidence.
七年级剑桥计算机科学的实践评估旨在考查你使用计算工具解决问题和传达想法的能力。你不仅需要记住知识点，更要展示出能够规划任务、选择正确的软件、运用逻辑思维并反思自己的作品。本文拆解了动手操作考试中常考的核心领域，给出清晰的评分标准，并提供技巧，帮助你自信地应对每项任务。
1. Understanding Assessment Objectives | 理解评估目标
In every practical task, examiners look for three main strands: planning and design, efficient use of digital tools, and evaluation. The planning phase might ask you to sketch a flowchart or write a short list of steps before you touch the computer. During the task, you need to apply appropriate features of the software—such as formulas in a spreadsheet or loops in code—rather than using workarounds that show a lack of understanding.
在每一项实践任务中，考官主要考察三条主线：计划与设计、高效使用数字工具、以及评价反思。计划阶段可能要求你在打开电脑之前先画出简要流程图或列出步骤清单。在执行任务时，你需要利用软件中恰当的功能（例如电子表格中的公式或代码中的循环），而不是靠变通方法掩盖理解上的不足。
Always read the task instructions twice: first to understand the overall goal, and then to highlight the specific deliverables such as 'save the file as analysis.xlsx' or 'include at least one loop'. Marks are often lost because students skip these small but critical requirements. In your evaluation, comment on what worked well and suggest one realistic improvement you could make.
每次拿到任务说明都要读两遍：第一遍弄懂总体目标，第二遍高亮具体交付要求，比如“将文件保存为 analysis.xlsx”或“至少包含一个循环”。许多学生正是因为忽视这些细节而丢分。在评价反思环节，写出你认为做得好的地方，并提出一个可实现的改进建议。
2. Programming Basics with Scratch | Scratch 编程基础
Many Year 7 practical assessments include a programming challenge, often using a block-based environment like Scratch. You are expected to create a short interactive story, game, or animation that includes sequencing, loops (repeat blocks), and conditional logic (if-then blocks). Examiners want to see that you understand event-driven programming, so your project should start with an event block such as 'when green flag clicked' or 'when this sprite clicked'.
很多七年级实践评估都包含一个编程挑战，通常用积木式环境如 Scratch 完成。你需要创作一个简短的互动故事、游戏或动画，其中要包含顺序结构、循环（重复执行）以及条件逻辑（如果…那么）。考官希望看到你理解事件驱动编程，因此你的项目应该从诸如“当绿旗被点击”或“当这个角色被点击”的事件积木开始。
Use meaningful sprite names and clean code organisation: group related blocks together and insert short comments to explain what each section does. For example, a simple maze game should separate movement control, win-condition checking, and timer resetting into distinct scripts. Avoid creating long, messy stacks of blocks that make debugging difficult.
使用有意义的角色名称，保持代码结构清晰：把相关积木组合在一起，并插入简短的注释说明每个部分的功能。例如，一个简单的迷宫游戏应该把移动控制、胜利条件检测和计时器重置分成独立的脚本。杜绝拖出又长又乱的大串积木，以免给调试造成困难。
Common pitfalls: forgetting to reset variables when the game restarts, or using a 'forever' loop without a stop condition, causing the program to freeze. Always test your project step by step, and if something goes wrong, use the 'say' block or 'think' block to display variable values temporarily—this is a beginner-friendly way to debug.
常见陷阱：游戏重新开始时忘记重置变量，或者使用“重复执行”却没有终止条件，导致程序卡死。务必逐步测试你的项目；如果出现错误，可以临时使用“说”或“思考”积木显示变量值——这是一个适合初学者的调试办法。
3. Working with Spreadsheets | 电子表格操作
onfident with cell references (both relative and absolute), basic functions like SUM, AVERAGE, MIN, and MAX, and the IF function to make decisions. For instance, you might need to build a budget sheet that automatically flags items over a certain cost using =IF(B2>50,"Over budget","OK").
电子表格任务通常要求你整理数据、应用简单公式并创建图表。在七年级剑桥评估中，你需要熟练掌握单元格引用（相对引用和绝对引用）、SUM、AVERAGE、MIN、MAX 等基本函数，以及用于判断的 IF 函数。例如，你可能需要制作一份预算表，用 =IF(B2>50,"超预算","正常") 自动标记高价物品。
Chart creation is another common skill. Select data that is adjacent and clearly labelled, and choose the right chart type: a bar chart for comparing categories, a line chart for showing trends over time, or a pie chart for illustrating proportions. Always add a descriptive chart title, axis labels, and a legend if needed. Examiners also check whether you have formatted numbers correctly, such as displaying currency with two decimal places or using percentage format.
创建图表是另一项常见技能。选取相邻且带清晰标签的数据，选择合适的图表类型：柱形图用于比较类别，折线图显示随时间变化的趋势，饼图展示比例关系。务必添加描述性图表标题、坐标轴标签，必要时添加图例。考官还会检查你是否正确设置了数字格式，比如将货币显示为两位小数，或使用百分比格式。
| Function (函数) | Example (示例) | Meaning (含义) |
| SUM | =SUM(A1:A5) | Adds values in cells A1 to A5 (将 A1 到 A5 的数值相加) |
| AVERAGE | =AVERAGE(B2:B10) | Calculates mean of the range (计算范围内的平均值) |
| IF | =IF(C3>=60,"Pass","Fail") | Returns "Pass" if C3 >= 60, else "Fail" (条件判断) |
4. Word Processing and Document Design | 文字处理与文档设计
You may be asked to produce a leaflet, a report, or a formal letter. Beyond typing accurately, you need to demonstrate layout skills: using appropriate fonts and sizes for headings and body text, aligning paragraphs (left, justified), inserting bulleted or numbered lists, and adding headers and footers. Consistent formatting across the whole document is a key marking point.
你或许会被要求制作一份传单、一份报告或一封正式信函。除了打字准确外，你还需展示排版技能：为标题和正文选择合适的字体和字号、对齐段落（左对齐、两端对齐）、插入项目符号或编号列表，以及添加页眉和页脚。整篇文档格式的一致性是一个重要的评分点。
m. In most exam conditions, you are given a set of image files stored in a specific folder—always insert images from that folder, not from the internet. Use 'Save As' frequently, and follow the exact file naming convention requested, for example 'poster_yourname.docx'.
学会插入图片并调整其环绕方式，让文字整齐地绕排在图片周围。在大多数考试环境中，你会拿到一组存放在特定文件夹中的图片文件——务必从该文件夹插入图片，而不是从互联网上下载。经常使用“另存为”，并严格按照要求的文件命名规范执行，比如“poster_yourname.docx”。
Proofreading is part of the assessment cycle. Once you finish typing, use the built-in spelling and grammar checker, but also read through manually because auto-checkers may miss homophone errors (e.g., 'their' instead of 'there'). Small touches like page borders or consistent colour schemes may be specified in the task; if they are, you must include them to gain full marks.
校对是评估周期的一部分。完成输入后，使用内置的拼写与语法检查器，但也要手动通读，因为自动检查可能漏掉同音词错误（比如把 'their' 错打成 'there'）。任务中如果明确要求添加页面边框或采用统一的配色方案，你必须一一照做才能拿到满分。
5. Creating Effective Presentations | 制作有效演示文稿
Presentation tasks assess your ability to communicate information clearly to an audience. You will typically need to create around 4-6 slides that include a title slide, bullet-point content, and at least one image or diagram. Examiners expect you to use a consistent theme, readable fonts, and carefully chosen colours that provide good contrast.
演示文稿任务考查你向观众清晰传达信息的能力。你通常需要制作大约4–6张幻灯片，包括标题幻灯片、要点内容以及至少一幅图片或图表。考官希望你使用统一的主题、易读的字体，以及对比度良好、经过斟酌的颜色搭配。
Avoid cramming too much text onto one slide; use keywords and short phrases instead of full sentences, and expand on them verbally if a spoken presentation is required. Transitions and animations should be used sparingly and with purpose—a simple 'Appear' animation for bullet points is often enough. Overly flashy effects can distract from the content and waste time.
避免在一张幻灯片上塞入过多文字；使用关键词和简短短语而非完整句子，如果要求口头演示，再对此进行扩展。应谨慎且有目的地使用切换效果和动画——为要点设置简单的“出现”动画通常就够了。过于花哨的效果会分散观众注意力，而且浪费时间。
Always include a slide number and, where necessary, credit any sources of images or data on a final 'References' slide. Before submitting, run the slideshow to check that all links work, videos play correctly, and slide order is logical. Many students lose marks because an embedded video file is missing or a hyperlink leads to a wrong page.
一定要添加幻灯片编号，如有必要，在最后的“参考资料”幻灯片上注明图片或数据来源。提交前，运行一遍放映，检查所有链接是否有效、视频能否正常播放、幻灯片顺序是否合理。很多学生因为嵌入的视频文件丢失或超链接跳转错误而白白失分。
6. Internet Safety and Digital Citizenship | 网络安全与数字公民
Practical assessments often include a scenario where you must demonstrate safe online behaviour. This could be a task to design a poster about strong passwords, or to write a set of rules for protecting personal information. You need to understand concepts such as phishing, malware, and the importance of keeping software up to date. A strong password typically includes uppercase and lowercase letters, numbers, and symbols, and is at least 8 characters long.
实践评估常常模拟场景要求你展示安全的上网行为，例如设计一张关于强密码的海报，或编写一套保护个人信息的规则。你需要理解钓鱼攻击、恶意软件等概念，以及保持软件最新版本的重要性。强密码通常包含大写和小写字母、数字和符号，且长度至少为8位。
You should be able to identify suspicious emails or pop-up messages and explain what to do: never click unknown links, report to a trusted adult, and avoid downloading attachments from strangers. Knowing how to use privacy settings on social platforms is another assessment point—even if you do not physically adjust settings during the exam, you may be asked to write step-by-step instructions.
你需要能够识别可疑的电子邮件或弹窗消息，并说明应对方法：绝不点击未知链接、向可信任的成人报告、避免下载陌生人发送的附件。了解如何使用社交平台的隐私设置是另一个考查点——即使考试中不需要实际调整设置，你也可能被要求写出逐步操作指南。
Digital citizenship also covers respectful communication and understanding copyright. When you use images, music, or text from the web in your projects, you must either choose resources labelled for reuse or credit the creator. Failing to do so in a practical task can result in lost marks for ethical use of technology.
数字公民素养还包括尊重他人、文明沟通以及理解版权。当你在项目中使用网络上的图片、音乐或文字时，必须选择标注为可重新使用的资源，或注明创作者。在实际任务中做不到这一点，可能会因没有合乎伦理地使用技术而丢分。
7. Algorithms and Flowcharts | 算法与流程图
Even before you write code, you may be asked to design an algorithm using a flowchart or pseudocode. In Year 7, flowcharts are the most common tool. Learn the standard symbols: an oval for Start/End, a rectangle for a process, a parallelogram for input/output, and a diamond for a decision. Arrows must show the flow of control clearly.
在动手写代码之前，你可能会被要求用流程图或伪代码来设计一个算法。七年级中最常见的是流程图。你需要学习标准符号：椭圆形代表开始/结束，矩形表示处理步骤，平行四边形表示输入/输出，菱形表示判断。箭头必须清晰地指明控制流程。
Practice drawing algorithms for everyday tasks, such as making a cup of tea or logging into a school system, because the exam scenario often mimics real-life logic. Ensure every decision branch has a clear 'Yes' and 'No' path, and that loops return to an earlier point where the condition is checked again. Keep your flowchart neat—a messy diagram can confuse even a correct logic.
多练习画日常任务的算法，比如泡一杯茶或登录学校系统，因为考试场景通常模仿真实生活中的逻辑。确保每个判断分支都有明确的“是”和“否”路径，循环要返回到之前再次检查条件的地方。保持流程图整洁——杂乱无章的图即便逻辑正确也会令人困惑。
Some tasks ask you to trace a given flowchart to predict its output. Count the number of iterations carefully, and maintain a trace table that records variable values at each step. This systematic approach is what examiners look for as evidence of computational thinking.
有些任务要求你跟踪给定的流程图并预测输出。仔细数清迭代次数，并制作一个追踪表记录每一步的变量值。这种系统性的方法正是考官眼中计算思维的重要证据。
8. Data Handling and Simple Databases | 数据处理与简单数据库
Data handling goes beyond spreadsheets and may involve sorting, filtering, and querying a small flat-file database. You might be given a table of records (e.g., a list of students with fields like Name, Class, and Score) and asked to answer questions such as “Which students in Class 7A scored above 80?”. Knowing how to apply filters or sort data in ascending/descending order is essential.
数据处理超出电子表格范畴，可能涉及排序、筛选以及对小型平面文件数据库的查询。你可能会拿到一张记录表（例如包含姓名、班级和分数等字段的学生列表），并回答诸如“7A 班有哪些学生得分超过80分？”的问题。懂得如何应用筛选器或按升序/降序排序数据非常重要。
In some practical environments, you may use a simple database tool to create a table, define field types (text, number, date), and enter a few records. Examiners check whether you can set a primary key and understand why each record needs a unique identifier. Avoid leaving blank fields unless permitted; missing data can break sorting and query accuracy.
在某些实践环境中，你可能会使用简单的数据库工具创建表格、定义字段类型（文本、数字、日期）并输入几条记录。考官会检查你是否懂得设置主键，并理解为什么每条记录都需要唯一标识符。除非允许，否则不要留空字段；缺失数据会破坏排序和查询的准确性。
Data validation is also part of this topic. For example, setting a rule so that a 'Score' field only accepts numbers between 0 and 100 helps prevent errors. Although you may not be required to write complex code, understanding the concept of garbage in, garbage out (GIGO) shows mature digital thinking.
数据验证也属于该主题。例如，设置规则使得“分数”字段只接受0到100之间的数字，有助于防止错误。虽然你可能不需要编写复杂代码，但理解“输入垃圾则输出垃圾”（GIGO）的概念可以显示出成熟的数字思维。
9. Debugging and Problem Solving | 调试与问题解决
Debugging is a critical skill tested either directly—by giving you broken code or a flawed spreadsheet—or indirectly, when you must fix your own project. Approach debugging methodically: read the error message, identify the line or block causing the issue, and isolate it by testing small sections separately. In Scratch, you can disconnect a script and run it alone to see if it behaves as expected.
调试是一项关键的考查技能，要么直接给你一段有错误的代码或电子表格让你修正，要么间接要求你修复自己的项目。要有条不紊地应对调试：阅读错误信息，确定导致问题的行或积木，并通过单独测试小段逻辑来隔离故障。在 Scratch 里，你可以把某段脚本分离出来单独运行，看它是否符合预期。
Common errors include: division by zero in spreadsheets (which shows #DIV/0!), infinite loops in programs, incorrect variable initialisation, and logic errors where a condition is set the wrong way round (e.g., using 'greater than' instead of 'less than'). Practise reading test data and manually calculating the expected outcome so you can spot when a program produces wrong results.
常见错误包括：电子表格中的除以零错误（显示 #DIV/0!）、程序中的无限循环、变量初始化不正确，以及条件方向设反的逻辑错误（例如本该用“小于”却用了“大于”）。多练习阅读测试数据并手动计算期望结果，这样当程序输出有误时你就能发现。
When you successfully fix a bug, add a comment or note explaining what you changed and why. This reflective practice may count towards the evaluation marks and proves that you truly understand the problem-solving process rather than guessing randomly.
当你成功修复一个错误后，添加注释或说明解释你改了哪里以及为什么改。这种反思性练习可以作为评价分的一部分，证明你真正理解解决问题的过程，而非随意猜测。
10. Practical Exam Strategies | 实践考试策略
Before the assessment, organise your workspace and ensure you know where the required files and applications are located. Read every question completely before you start working, and allocate time based on marks—spend longer on high-mark sections such as programming or database queries. If you get stuck, move on and return later; a partially completed task still scores marks, but a blank section scores nothing.
评估开始前，整理好你的工作区，并确认所需文件和应用程序存放的位置。在动手前通读每一个问题，根据分值分配时间——在编程或数据库查询等高分区多花些时间。如果卡住了，就跳过先做别处，稍后再回来；任务即使未完全完成也能得分，但留空肯定得零分。
Use the 'Save' ely give extra time for lost work. Name your files exactly as instructed: if the task says 'save as event_form.csv' the correct folder, because examiners may only mark files found in the specified location.
每隔几分钟就点一次“保存”。实践考试几乎不会因为文件丢失而补给你额外时间。严格按照指示给文件命名：如果题目要求“另存为 event_form.csv”，就原样使用这个文件名，包括大小写和扩展名。检查你是否将文件保存在正确的文件夹，因为考官可能只批阅指定位置中的文件。
Finally, use any remaining time to review your tasks against the original instructions. Tick off each deliverable and run through your program or slideshow one more time. This final check often catches small errors that could lower an otherwise excellent piece of work.
最后，利用剩余时间对照原始说明复查所有任务。逐条划掉已完成的要求，并重新运行一遍程序或放映一遍幻灯片。这种最终检查常常能揪出某些小错误，避免它们拉低本可以非常优秀的作品成绩。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图