📚 Year 7 CIE Computer Science Practical Assessment Essentials | Year 7 CIE 计算机科学实践考核要点
Practical assessments in Year 7 CIE Computer Science are designed to test your ability to use digital tools effectively. You will be expected to manage files, create documents, work with spreadsheets, design presentations, and write simple programs. This guide covers the key points you need to master for your practical exam.
Year 7 CIE 计算机科学的实践考核旨在评估你有效使用数字工具的能力。你需要管理文件、创建文档、使用电子表格、设计演示文稿以及编写简单程序。本文涵盖了你在实践考试中需要掌握的关键要点。
1. File Management and Organisation | 文件管理与组织
Always name your files clearly so they are easy to identify. For example, use ‘John_Science_Project.docx’ instead of ‘Document1.docx’.
务必清晰命名文件，以便识别。例如，使用 “John_Science_Project.docx” 而不是 “Document1.docx”。
Organise your work into folders by subject or task. A typical structure might include a main folder ‘Year 7 Computing’ with subfolders like ‘Word Processing’, ‘Spreadsheets’, and ‘Programming’.
按科目或任务将工作整理到文件夹中。典型结构可包含主文件夹 “Year 7 Computing”，下设 “Word Processing”、”Spreadsheets” 和 “Programming” 等子文件夹。
Save your work at regular intervals and always keep a backup copy on a USB drive or cloud storage.
定期保存你的工作，并始终在U盘或云存储中保留备份副本。
Follow the examiner’s instructions for file naming and folder locations exactly. Marks are often awarded for correct file handling.
严格遵循考官关于文件命名和文件夹位置的指示。正确的文件管理通常会计入分数。
2. Word Processing Essentials | 文字处理要点
Learn to format text by changing font style, size, and colour. Use bold, italics, or underline to emphasise important information.
学会通过更改字体样式、大小和颜色来设置文本格式。使用粗体、斜体或下划线强调重要信息。
Align paragraphs appropriately — left, centre, right, or justified. Use bullet points and numbered lists for clarity.
适当对齐段落——左对齐、居中对齐、右对齐或两端对齐。使用项目符号和编号列表使内容清晰。
Insert and manipulate images, shapes, and tables. Ensure images are resized without distortion and wrapped correctly.
插入并处理图像、形状和表格。确保图像调整大小而不失真，并正确设置文字环绕。
Check spelling and grammar before submitting. Use headers and footers for page numbers or document titles.
提交前检查拼写和语法。使用页眉和页脚添加页码或文档标题。
Be able to adjust page margins, orientation, and insert page breaks where needed.
能够调整页边距、页面方向，并在需要时插入分页符。
3. Spreadsheet Fundamentals | 电子表格基础
Enter data accurately into cells; distinguish between labels (text) and values (numbers).
准确地将数据输入单元格；区分标签（文本）和数值（数字）。
Use simple formulas that start with ‘=’ to perform calculations, e.g., =A1+B1, =SUM(B2:B10), =AVERAGE(C2:C10).
使用以 “=” 开头的简单公式进行计算，例如 =A1+B1，=SUM(B2:B10)，=AVERAGE(C2:C10)。
Apply cell formatting: number format (currency, percentage, decimal places), alignment, and borders.
应用单元格格式：数字格式（货币、百分比、小数位数）、对齐方式和边框。
Create charts (bar, pie, line) to visualise data. Select appropriate chart types and label axes and titles.
创建图表（条形图、饼图、折线图）使数据可视化。选择适当的图表类型并为坐标轴和标题添加标签。
Use cell references (relative and absolute) correctly. Know that $A$1 locks the reference when copied.
正确使用单元格引用（相对和绝对）。知道 $A$1 在复制时会锁定引用。
Sort and filter data to find patterns or specific information quickly.
对数据进行排序和筛选，以便快速找到模式或特定信息。
4. Creating Effective Presentations | 创建有效演示文稿
Design slides that are clear and not overloaded with text. Use bullet points and short phrases.
设计清晰的幻灯片，避免堆积过多文字。使用项目符号和简短短语。
Apply a consistent theme, font, and colour scheme. Use high-contrast text for readability.
使用统一的主题、字体和配色方案。使用高对比度文本以提高可读性。
Add multimedia elements such as images, audio, or video clips to support your message. Check that media files are embedded or linked correctly.
添加图像、音频或视频片段等多媒体元素来支持信息。检查媒体文件是否正确嵌入或链接。
Use animations and slide transitions thoughtfully; avoid excessive effects that distract the audience.
谨慎使用动画和幻灯片切换效果；避免过多效果分散观众注意力。
Practise presenting in front of a timer. Speak clearly and refer to slide notes if allowed.
在计时器前练习展示。清晰演讲，如允许可使用演讲者备注。
5. Introduction to Programming Concepts | 编程概念入门
Understand basic algorithms – step-by-step instructions to solve a problem. You may be asked to draw a flowchart using standard symbols.
理解基本算法——解决问题的分步指令。你可能会被要求使用标准符号绘制流程图。
Use a block-based programming environment like Scratch or a text-based language like Python (turtle). Be able to create sequences, loops, and conditional statements.
使用基于块的编程环境（如 Scratch）或基于文本的语言（如 Python turtle）。能够创建序列、循环和条件语句。
Declare and use variables appropriately. For example, ‘score = 0’ then update ‘score = score + 1’.
适当声明和使用变量。例如，”score = 0″，然后更新 “score = score + 1″。
Debug your code by reading error messages and testing small sections. Use comments to explain what your code does.
通过阅读错误消息和测试小段代码来调试代码。使用注释解释代码的作用。
For practical exams, you might need to complete a partially written program or create a simple game. Follow the task specification precisely.
在实践考试中，你可能需要完成部分编写的程序或创建一个简单游戏。严格遵循任务规范。
6. Data Representation and Handling | 数据表示与处理
Understand how computers represent numbers, text, and images using binary digits (0s and 1s). You may be asked to convert simple decimal numbers to binary.
理解计算机如何使用二进制数字（0和1）表示数字、文本和图像。可能会要求你将简单十进制数转换为二进制。
Know the units of data: bit, byte, kilobyte (KB), megabyte (MB), gigabyte (GB). Be able to compare file sizes.
了解数据单位：位、字节、千字节（KB）、兆字节（MB）、千兆字节（GB）。能够比较文件大小。
Create and use a simple database table with fields and records. Perform basic searches or queries.
创建并使用包含字段和记录的简单数据库表。执行基本搜索或查询。
Recognise different file types and their extensions: .docx, .xlsx, .pptx, .pdf, .jpg, .mp3, etc. Choose the right format for a given task.
识别不同文件类型及其扩展名：.docx、.xlsx、.pptx、.pdf、.jpg、.mp3等。为给定任务选择合适的格式。
7. Online Safety and Digital Citizenship | 网络安全与数字公民
Demonstrate responsible behaviour online: keep personal information private, create strong passwords, and log out of shared devices.
展示负责任的在线行为：保护个人信息隐私，创建强密码，并在共享设备上注销。
Recognise cyberbullying and know how to report it. Respect others’ work by not plagiarising.
识别网络欺凌并知道如何举报。尊重他人作品，不抄袭。
Understand the risks of downloading files from unknown sources and how viruses can spread.
了解从未知来源下载文件的风险以及病毒如何传播。
In a practical session, you might be asked to set up privacy settings on a mock social media profile or identify phishing emails.
在实践环节中，你可能会被要求设置模拟社交媒体档案的隐私设置或识别网络钓鱼邮件。
8. Problem Solving and Debugging | 问题解决与调试
When faced with an error, follow a systematic approach: identify the problem, brainstorm solutions, test one fix at a time, and review.
遇到错误时，采用系统方法：识别问题、集思广益解决方案、一次测试一个修复并进行复查。
Use ‘tracing’ to manually step through code or spreadsheet logic to find where it goes wrong. Write down intermediate values.
使用“跟踪”手动逐步执行代码或电子表格逻辑，找出出错位置。记下中间值。
Keep calm and manage time effectively. If you get stuck, move on to another part and return later.
保持冷静，有效管理时间。如果卡住了，先做其他部分，稍后返回。
Familiarise yourself with common error messages: ‘syntax error’, ‘name error’, ‘#DIV/0!’. Know what they mean.
熟悉常见错误消息：“syntax error”、“name error”、“#DIV/0!”。理解它们的含义。
9. Practical Examination Tips | 实践考核技巧
Read the entire paper before starting. Note the marks allocated for each section to prioritise your time.
开始前通读整个试卷。记录每部分的配分，以便优先分配时间。
Save your work after each task. Use version numbers (e.g., _v1, _v2) to protect against accidental loss.
每完成一个任务就保存你的工作。使用版本号（如 _v1、_v2）以防意外丢失。
Check your work against the checklist provided. Ensure all files are submitted in the correct format and named as required.
根据提供的检查表核对工作。确保所有文件按要求的格式和命名提交。
Use keyboard shortcuts to work faster: Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+S (save).
使用键盘快捷键提高工作效率：Ctrl+C（复制）、Ctrl+V（粘贴）、Ctrl+Z（撤销）、Ctrl+S（保存）。
10. Time Management in Assessments | 考核时间管理
Allocate time based on task difficulty. Don’t spend too long perfecting one slide if other sections carry more marks.
根据任务难度分配时间。如果其他部分的配分更高，不要花太多时间完善一张幻灯片。
Leave 5-10 minutes at the end for final review and saving. Check that all links, formulas, and media work.
最后留出5-10分钟进行终审和保存。检查所有链接、公式和媒体是否正常工作。
Practice under timed conditions at home. Use past papers or sample tasks to build speed and confidence.
在家里限时练习。使用历年试卷或样题来提高速度和信心。
If you finish early, double-check data entry accuracy and formatting consistency.
如果提前完成，请再次检查数据输入的准确性和格式的一致性。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导