📚 SQA Computing Practical Assessment Essentials | SQA 计算机实践考核要点
The SQA National 5 Computing Science course includes a practical assessment (the assignment) that requires you to apply your knowledge and skills to a realistic problem. You will be expected to analyse a scenario, design and implement a solution using appropriate software, test it thoroughly, and evaluate your work. This article breaks down the key points you need to master in order to succeed.
SQA 国家 5 计算机科学课程包含一项实践考核（作业），要求你将知识和技能应用于一个现实问题。你需要分析一个情景，使用合适的软件设计并实现解决方案，进行充分测试，并评估你的工作。本文分解了你必须掌握的关键要点，助你取得成功。
1. Overview of the Practical Assessment | 实践考核概述
The practical assignment is carried out under controlled conditions, usually over several hours. It is marked internally by your teacher and externally moderated by SQA. The task typically involves a combination of programming, database queries, and/or web page creation. You are allowed access to online resources and course materials, but you must work independently.
实践作业在受控条件下进行，通常为时数小时。作业由你的老师内部评分，并由 SQA 外部审核。任务通常涉及编程、数据库查询和/或网页创建的组合。你可以访问在线资源和课程材料，但必须独立完成。
The assignment is worth a significant portion of your final grade, so understanding the structure and expectations is essential. You will be provided with a brief that describes a scenario and a set of requirements. Your job is to produce a working digital solution and supporting documentation.
该作业占你最终成绩的很大一部分，因此理解其结构和期望至关重要。你将获得一份描述情景和一系列要求的任务简述。你的工作是产出一个可行的数字解决方案和相应的支持文档。
2. Understanding the Task Brief | 理解任务简述
Begin by reading the entire brief carefully. Identify the user requirements: what does the solution need to do? Separate functional requirements (e.g. ‘the program must calculate total cost’) from non‑functional requirements (e.g. ‘the interface should be easy to navigate’). Highlight keywords such as input, process, output, store, retrieve, and display.
首先仔细阅读整个任务简述。确定用户需求：解决方案需要做什么？将功能性需求（如“程序必须计算总成本”）与非功能性需求（如“界面应易于导航”）区分开来。高亮关键词，如输入、处理、输出、存储、检索和显示。
Make a checklist from the requirements. This will help you track progress and ensure you do not miss any marks. If the brief mentions specific data formats, file names, or validation rules, note them immediately. Clarity at this stage prevents costly rework later.
根据需求制作一份检查清单。这将帮助你跟踪进度，确保不会遗漏任何得分点。如果任务简述提到特定的数据格式、文件名或验证规则，请立即记下。此阶段的清晰理解可避免后期代价高昂的返工。
3. Software Development (Programming) | 软件开发（编程）
The programming section often asks you to write code in a language such as Python or Scratch (depending on your centre’s choice). You must demonstrate sequence, selection (if/else), and iteration (loops). Use meaningful variable names and include internal commentary (comments) to explain your logic.
编程部分通常要求你用 Python 或 Scratch 等语言（取决于你中心的选择）编写代码。你必须展示顺序、选择（if/else）和迭代（循环）。使用有意义的变量名，并包含内部注释来解释你的逻辑。
Input validation is critical. If a user is expected to enter a number between 1 and 100, your code should check this and display an appropriate error message. Use pre‑defined functions where possible to make your code modular. For example:
输入验证至关重要。如果期望用户输入1到100之间的数字，你的代码应检查这一点并显示适当的错误消息。尽可能使用预定义函数，使代码模块化。例如：
def get_valid_age():
while True:
age = input(‘Enter age (1-120): ‘)
if age.isdigit() and 1 <= int(age) <= 120:
return int(age)
else:
print(‘Invalid. Try again.’)
Remember to handle file operations if the task requires reading from or writing to a text file. Use standard patterns such as with open(‘data.txt’,’r’) as f: and ensure you close files properly. Testing your code with normal, boundary, and erroneous data is expected.
如果任务要求读取或写入文本文件，请记得处理文件操作。使用标准模式，如 with open(‘data.txt’,’r’) as f:，并确保正确关闭文件。要求你用正常数据、边界数据和错误数据测试代码。
4. Database Design and SQL Queries | 数据库设计与 SQL 查询
You may be asked to design a relational database with at least two linked tables. Identify entities and their attributes, then define primary keys and foreign keys. Normalisation to 3NF is not always mandatory at National 5, but you should avoid data redundancy. A typical design includes a one‑to‑many relationship, such as a Customer table linked to an Orders table.
你可能需要设计一个至少包含两个关联表的关系数据库。识别实体及其属性，然后定义主键和外键。国家5级并不总是强制要求达到第三范式，但你应避免数据冗余。典型的设计包含一对多关系，例如 Customer 表与 Orders 表关联。
For SQL, you must be able to write valid SELECT, INSERT, UPDATE, and DELETE statements. Queries often involve WHERE clauses with comparison operators (=, <, >, <=, >=, <>) and logical operators (AND, OR, NOT). You should also know how to sort results with ORDER BY and use aggregate functions like COUNT, SUM, AVG, MIN, and MAX.
对于 SQL，你必须能够编写有效的 SELECT、INSERT、UPDATE 和 DELETE 语句。查询通常涉及带有比较运算符（=, <, >, <=, >=, <>）和逻辑运算符（AND, OR, NOT）的 WHERE 子句。你还应知道如何使用 ORDER BY 对结果排序，并使用聚合函数，如 COUNT、SUM、AVG、MIN 和 MAX。
For example, to find the average order value per customer from two tables:
例如，从两个表中查找每位客户的平均订单价值：
SELECT Customer.Name, AVG(Orders.Amount) AS AvgOrder
FROM Customer INNER JOIN Orders ON Customer.CustID = Orders.CustID
GROUP BY Customer.Name;
Always test your SQL on sample data before finalising your answer. A common mistake is forgetting to link tables, resulting in a Cartesian product.
在最终确定答案之前，务必对示例数据测试你的 SQL。一个常见错误是忘记关联表，导致笛卡尔积。
5. Web Design and Implementation | 网页设计与实现
If your assignment includes web development, you will use HTML and CSS. You are expected to create a multi‑page website or a single page with clear structure. Use semantic tags such as <header>, <nav>, <main>, <section>, and <footer>. External CSS is preferred; keep style separate from content.
如果你的作业包含网页开发，你将使用 HTML 和 CSS。你需要创建一个多页面网站，或一个结构清晰的单页面。使用语义标签，如 <header>、<nav>、<main>、<section> 和 <footer>。推荐使用外部 CSS；将样式与内容分离。
Ensure your pages are visually consistent. Use a unified colour scheme, readable fonts, and appropriate images. Responsive design principles (e.g. using percentages or viewport units) are good practice. You must also show that you can create hyperlinks between pages and include multimedia elements like images or videos.
确保页面视觉一致。使用统一的配色方案、可读性强的字体和合适的图片。响应式设计原则（如使用百分比或视口单位）是良好实践。你还必须展示你能够在页面之间创建超链接，并包含图像或视频等多媒体元素。
Accessibility is a key assessment criterion. Add alt text to all images, use sufficient colour contrast, and ensure the site can be navigated with a keyboard. Validate your HTML and CSS using the W3C validators and fix any errors.
无障碍性是关键的评估标准。为所有图像添加替代文本，使用足够的色彩对比，并确保网站可通过键盘导航。使用 W3C 验证器验证你的 HTML 和 CSS，并修正任何错误。
6. Testing and Debugging | 测试与调试
Systematic testing is a major component of the marks. You need to produce a test plan that covers normal, boundary, and exceptional (erroneous) inputs. Record the expected result, actual result, and whether the test passed or failed. If a test fails, explain the corrective action taken.
系统化测试是评分的重要组成部分。你需要制定一个测试计划，涵盖正常、边界和异常（错误）输入。记录预期结果、实际结果以及测试是否通过。如果测试失败，需说明所采取的纠正措施。
For programming, use diagnostic techniques such as print statements or debuggers to trace errors. For databases, check that your SQL returns the correct number of rows and accurate calculations. For websites, test on different browsers and screen sizes.
对于编程，使用诊断技术，如 print 语句或调试器来追踪错误。对于数据库，检查 SQL 返回的行数是否正确，计算结果是否准确。对于网站，在不同浏览器和屏幕尺寸上测试。
A well‑written test table is a persuasive piece of evidence. For example:
一张书写良好的测试表是有说服力的证据。例如：
| Test Case | Input | Expected | Actual | Pass/Fail |
|---|---|---|---|---|
| 1 | Age = 25 | Accepted | Accepted | Pass |
| 2 | Age = 0 | Error message | Error shown | Pass |
| 3 | Age = ‘hello’ | Error message | Error shown | Pass |
7. Evaluation and Reflective Report | 评价与反思报告
You must write a short evaluation that reviews the success of your solution against the original requirements. Be honest about any limitations. If a feature was not fully implemented, explain why and suggest how it could be improved if given more time.
你必须撰写一份简短的评价，对照最初的需求审查你的解决方案是否成功。对任何局限要诚实。如果某个功能没有完全实现，解释原因，并提出如果有更多时间将如何改进。
Discuss the development process: what went well, what challenges you faced, and what you learned. Reference your test results to back up your claims. The evaluation shows your ability to think critically about your own work, which is a higher‑order skill valued by examiners.
讨论开发过程：哪些方面做得好，你遇到了哪些挑战，以及你学到了什么。引用你的测试结果来支持你的论述。评价展现了你批判性思考自己工作的能力，这是考官看重的高阶技能。
Use the following structure: (1) Summary of how requirements were met; (2) Analysis of testing outcomes; (3) Strengths and weaknesses; (4) Future enhancements. Keep it concise but specific. Avoid vague statements like ‘I think it went well’ without evidence.
使用以下结构：(1) 概述需求如何得到满足；(2) 分析测试结果；(3) 优势与不足；(4) 未来的改进。保持简洁但具体。避免在没有证据的情况下使用“我觉得做得不错”这类模糊的表述。
8. Documentation and Presentation | 文档与呈现
Your assignment submission should be well‑organised. Include a contents page, clear headings, page numbers, and consistent formatting. SQA does not prescribe a specific layout, but a structured report makes it easier for the marker to find the evidence for each criterion.
你的作业提交应组织良好。包含目录页、清晰的标题、页码和一致的格式。SQA 没有规定特定版式，但结构清晰的报告能让评分员更容易找到每个标准的证据。
Embed screenshots of your code, database tables, or web pages. Annotate these screenshots with arrows or text boxes to highlight key features. For programming, paste your final code (or well‑chosen excerpts) into the report, along with explanations.
嵌入代码、数据库表或网页的屏幕截图。用箭头或文本框标注这些截图，突出关键特征。对于编程，将最终代码（或精心挑选的片段）粘贴到报告中，并附上解释。
Proofread carefully. Spelling and grammar errors in your report can detract from the professionalism of your submission. Technical terminology must be used accurately; for instance, ‘function’ and ‘procedure’ mean different things in some contexts.
仔细校对。报告中的拼写和语法错误会降低你提交成果的专业性。技术术语必须准确使用；例如，在某些语境下，“函数”和“过程”含义不同。
9. Time Management in the Assessment | 考核中的时间管理
Practical assessments are time‑constrained, often 8 to 12 hours in total, split into sessions. Allocate your time strategically: spend about 20% on analysis and design, 50% on implementation, 20% on testing, and 10% on evaluation and report polishing.
实践考核有时间限制，通常总计 8 到 12 小时，分成几个阶段。战略性地分配时间：约 20% 用于分析和设计，50% 用于实现，20% 用于测试，10% 用于评价和报告润色。
Start by creating a simple working prototype before adding complexity. It is better to have a fully functional basic solution than a broken ambitious one. Use a timer to keep track and move on when a section is taking too long.
先创建一个简单的可运行原型，再增加复杂性。拥有一个功能完整的基础解决方案，远胜于一个崩溃的宏大方案。使用计时器记录时间，当某个部分耗时过长时转向下一项。
Save versions of your work regularly with clear file names (e.g. ‘assignment_v1’, ‘assignment_v2_final’). This protects you from data loss and allows you to revert if a new idea causes errors.
定期保存你的工作版本，并使用清晰的文件名（如“assignment_v1”、“assignment_v2_final”）。这可以防止数据丢失，并且如果新想法引发错误，你可以回退。
10. Common Pitfalls and How to Avoid Them | 常见问题及避免方法
One frequent mistake is ignoring the input/output requirements in the brief. If the task states that output must be displayed in a certain format, follow it exactly. Another is hard‑coding values that should be variables or calculated, which shows poor maintainability.
一个常见错误是忽视任务简述中的输入/输出要求。如果任务规定输出必须以某种格式显示，请严格遵守。另一错误是将本应是变量或计算值的数值硬编码，这显示出可维护性差。
Neglecting to comment code is also a mark‑loser. Comments must explain the ‘why’ behind a block of code, not just the ‘what’. Do your testing as you go rather than leaving it all for the end; incremental testing catches bugs earlier.
忽视代码注释也会导致失分。注释必须解释代码块背后的“为什么”，而不仅仅是“是什么”。边做边测试，不要把测试全部留到最后；增量测试能更早地捕获错误。
Finally, do not plagiarise. Even though you can use online resources, the work you submit must be your own. Copying entire code snippets without adaptation or attribution is an assessment offence. Understand and adapt any code you incorporate.
最后，不要抄袭。尽管你可以使用在线资源，但提交的必须是自己的作品。不经修改或注明出处就照搬整段代码是考核违规行为。理解并调整你融入的任何代码。
11. Marking Criteria Breakdown | 评分标准解析
Understanding how marks are allocated helps you focus your efforts. The assignment is assessed against three broad areas: Analysis and Design (around 20%), Implementation (around 50%), and Testing and Evaluation (around 30%). The exact weighting can vary, so always refer to the latest SQA course specification.
理解评分分配有助于你集中精力。作业根据三大方面评估：分析与设计（约20%）、实现（约50%）、测试与评价（约30%）。具体权重可能不同，因此务必参考最新的 SQA 课程规范。
Marks are awarded for demonstrated competence rather than for a perfect product. Even if your program does not run perfectly, you can still gain marks for a logical design, clear code structure, and thorough testing. Do not leave any section blank; partial evidence is always better than none.
分数奖励的是你展现出来的能力，而非完美无缺的产品。即使你的程序运行不完美，你仍可因逻辑清晰的设计、清晰的代码结构和充分的测试而得分。不要留下任何空白部分；部分证据总比没有好。
Your teacher will provide detailed feedback on a draft if time permits. Use this feedback constructively. If you are unsure about a requirement, ask for clarification before the final submission.
如果时间允许，你的老师会对草稿提供详细反馈。请建设性地利用这些反馈。如果你对某项要求不确定，在最终提交前请求澄清。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导