📚 Year 11 SQA Computing: Key Points for Practical Assessment | SQA 计算机实验/实践考核要点
Preparing for the practical assessment in SQA Computing at Year 11 (typically National 5) requires a clear understanding of how to approach a real-world problem using software development, database or web-based skills. This article outlines the essential points you need to master, from analysing the task to evaluating your final solution. Whether you are building a program, a database system or a website, these key areas will help you structure your work and meet the marking criteria.
备战 Year 11（通常相当于苏格兰 National 5 水平）SQA 计算机课程的实践考核，需要清晰理解如何运用软件开发、数据库或网页技能去解决实际问题。本文梳理了你必须掌握的核心要点，从任务分析到最终方案评估。无论你是在构建程序、数据库系统还是网站，这些关键环节都将助你理顺工作流程、满足评分标准。
1. Understanding the Assignment Task | 理解作业任务
Before writing any code or designing a database, read the assignment brief carefully at least twice. Identify the user requirements, the purpose of the system, and the functional requirements (what the solution must do). Underline key verbs like 'create', 'query', 'validate', 'display' and 'evaluate'. Then break the task down into smaller, manageable parts. A clear initial analysis will save you time and prevent you from building the wrong solution.
在编写任何代码或设计数据库之前，请至少仔细阅读作业要求两遍。找出用户需求、系统目标以及功能性需求（解决方案必须做什么）。在关键动词下划线，例如“创建”、“查询”、“验证”、“显示”和“评估”。然后将任务分解为更小、更易管理的部分。清晰的初步分析能节省时间，避免构建出错误的解决方案。
2. Designing Solutions | 设计解决方案
Design is a critical stage that shows you have planned your approach. Use appropriate design notations: for programs, pseudocode and flowcharts are recommended; for databases, draw entity-relationship diagrams (although SQA may accept simpler table plans); for websites, create wireframes or navigation maps. Make sure your design covers inputs, processes, outputs, data storage and any user interface elements. A well-documented design demonstrates organisational skills and makes implementation smoother.
设计是一个关键阶段，展示了你对解决方案的规划。使用恰当的设计表示法：对于程序，推荐使用伪代码和流程图；对于数据库，绘制实体关系图（尽管 SQA 可能接受较简单的表格规划）；对于网站，创建线框图或导航图。确保你的设计涵盖输入、处理、输出、数据存储及所有用户界面元素。清晰记录的设计能体现你的组织能力，并使实现阶段更加顺畅。
3. Programming Fundamentals | 编程基础
Your practical assessment will almost certainly involve writing code in a language such as Python, Visual Basic or LiveCode. You need to be comfortable with sequence, selection (if…else statements) and iteration (for loops, while loops). Practise using variables, data types (integer, real, string, Boolean) and user input/output. Make sure you can handle simple validation, for example checking that an entered number lies within a range, or that a string is not empty.
你的实践考核几乎肯定会涉及用 Python、Visual Basic 或 LiveCode 等语言编写代码。你需要熟练掌握顺序结构、选择结构（if…else 语句）和循环结构（for 循环、while 循环）。练习使用变量、数据类型（整型、实型、字符串、布尔型）以及用户输入/输出。确保你会处理简单的验证，例如检查输入的数字是否在某个范围内，或者字符串是否不为空。
4. Using Data Structures | 使用数据结构
Many tasks require you to store and manipulate collections of data. Understand how to use one-dimensional arrays (lists) and, at Higher level, two-dimensional arrays. You should be able to traverse an array, search for a specific value (linear search) and find the maximum or minimum. For database tasks, know how to represent related data using multiple tables with primary and foreign keys to avoid data redundancy.
许多任务要求你存储并操作一批数据。理解如何使用一维数组（列表），以及在 Higher 级别会涉及二维数组。你应能够遍历数组、查找特定值（线性搜索）并找出最大值或最小值。对于数据库类任务，了解如何用多张表、主键和外键表示相关数据，以避免数据冗余。
5. Working with Databases | 数据库操作
For the database strand, you need to demonstrate practical skills in creating a relational database with at least two tables. Design the tables with suitable field names and data types (text, number, date, currency, Boolean). Set primary keys and create relationships. Populate the tables with sample data and ensure referential integrity. Practical assessments often ask you to create and use queries, forms and reports, so practise these in your chosen DBMS (e.g. Microsoft Access, LibreOffice Base).
对于数据库方向，你需要展示创建至少包含两张表的关系型数据库的实践技能。设计表格时选用合适的字段名和数据类型（文本、数字、日期、货币、布尔型）。设置主键并创建关系。向表中添加样本数据并确保参照完整性。实践考核常要求你创建并使用查询、窗体和报表，因此请在你选择的数据库管理系统（如 Microsoft Access、LibreOffice Base）中勤加练习。
6. SQL Queries | SQL 查询
pecific field lists and using WHERE to filter records. Learn operators like =, <, >, AND, OR, BETWEEN and LIKE. You may also need to sort results with ORDER BY, or use aggregate functions (COUNT, SUM, AVG, MIN, MAX) together with GROUP BY. Be prepared to create tables using CREATE TABLE and insert data with INSERT INTO if required.
结构化查询语言（SQL）是检索和操作数据的强大工具。你应能熟练编写 SELECT 语句，指定字段列表，并使用 WHERE 筛选记录。学习 =、<、>、AND、OR、BETWEEN 和 LIKE 等运算符。你可能还需要用 ORDER BY 对结果排序，或将聚合函数（COUNT、SUM、AVG、MIN、MAX）与 GROUP BY 结合使用。如果要求，还需准备使用 CREATE TABLE 建表以及用 INSERT INTO 插入数据。
7. Web Development | 网页开发
If your assessment involves a website, you need to use HTML and CSS. Know how to structure pages with elements like headings, paragraphs, images, hyperlinks and lists. Use CSS (inline, internal or external) to control colours, fonts and layout. Include a simple navigation system and ensure all links work. Responsive design principles are a bonus, but at Year 11 level, a clean, functional multi-page site with consistent styling will score well. JavaScript may be used for interactivity, but focus on meeting the core requirements first.
如果你的评估涉及网站，你需要使用 HTML 和 CSS。了解如何用标题、段落、图片、超链接和列表等元素构建页面。使用 CSS（内联、内部或外部）来控制颜色、字体和布局。加入简单的导航系统，并确保所有链接有效。响应式设计原则是加分项，但在 Year 11 级别，一个干净、功能完善且风格一致的多页面网站就能拿到高分。JavaScript 可用于添加交互性，但应首先专注于满足核心要求。
8. Testing and Debugging | 测试与调试
Testing proves that your solution works as intended. Plan a test table with columns for test number, input, expected output, actual output and a pass/fail mark. Test normal, boundary and exceptional data. For example, if a program accepts marks 0 to 50, test with 0, 50, -1 and 51. When a test fails, use debugging techniques such as printing variable values or stepping through code. Document any errors found and how you fixed them; this shows reflective practice and is often rewarded in the evaluation.
测试能证明你的解决方案按预期运行。规划一张测试表，包含测试编号、输入、预期输出、实际输出以及通过/失败标记等列。测试正常数据、边界数据和异常数据。例如，若程序接受 0 到 50 之间的分数，则测试 0、50、-1 和 51。当测试失败时，使用打印变量值或单步执行代码等调试技巧。记录找到的任何错误以及你是如何修复的；这体现了反思性实践，通常在评估环节能获得加分。
9. Evaluation and Reflection | 评估与反思
After completing your solution, write a concise evaluation. Compare your final product against the original requirements: does it meet all functional requirements? Discuss any limitations, such as a validation check that could be improved, or a feature you did not have time to implement. Be honest about what went well and what you would do differently next time. This shows critical thinking and a mature approach to software development.
完成解决方案后，撰写一份简明的评估报告。将最终产品与原始需求进行对比：它是否满足所有功能性需求？讨论所有局限性，例如可以改进的验证检查，或者你没有时间和能力实现的功能。诚实地反思哪些做得好，以及下次会做出哪些改变。这展示了批判性思维和成熟的软件开发方法。
10. Time Management in Practical Exams | 实践考试中的时间管理
Most practical assessments are completed over several periods under controlled conditions. Plan how you will use each session: spend the first 20% on analysis and design, 50% on implementation, 15% on testing, and the final 15% on evaluation and checking documentation. Keep an eye on the clock and do not get stuck on one tricky bug. If something is not working, note it down and move on; you can return later and mention the issue in your evaluation. Practice under timed conditions beforehand to build confidence.
大多数实践考核是在受控条件下分多个课时完成的。计划好每节课的用途：前 20% 时间用于分析与设计，50% 用于实现，15% 用于测试，最后 15% 用于评估和检查文档。留意时间，不要被一个棘手的 bug 困住。如果某处无法正常工作，先记录下来并继续推进；你可以稍后回头处理，并在评估中提及该问题。提前进行限时练习，以建立信心。
11. Documentation Standards | 文档标准
Good documentation is not an afterthought; it is part of the assessment criteria. Include meaningful comments in your code, explaining the purpose of complex sections. In database work, document your table structures and relationships. For websites, maintain a site map and style guide. Keep a project log or diary if allowed, as this demonstrates your working process. The SQA values clear, professional presentation, so use consistent naming conventions for files and variables.
良好的文档并非事后补救，它是评分标准的一部分。在代码中加入有意义的注释，解释复杂部分的目的。在数据库工作中，记录你的表结构和关系。对于网站，维护一张网站地图和一份样式指南。如允许，保管一份项目日志或日记，因为这能展示你的工作过程。SQA 看重清晰、专业的呈现方式，因此请为文件和变量使用一致的命名约定。
12. Ethical and Legal Considerations | 道德与法律考量
Modern computing is governed by laws and ethical principles. Be aware of the Data Protection Act (GDPR in Europe), the Computer Misuse Act, and copyright law. When you use images, code snippets or other resources, ensure they are either original, licensed for reuse, or properly attributed. Consider accessibility in your website design (e.g. alt text for images). If your system stores user data, explain how you would keep it secure and respect privacy. Mentioning these points in your documentation boosts your marks for social and legal awareness.
现代计算受到法律和伦理原则的约束。需了解《数据保护法》（欧洲的 GDPR）、《计算机滥用法》以及版权法。当你使用图片、代码片段或其他资源时，确保它们是原创、可授权重用或已适当标注来源的。在网站设计中应考虑无障碍访问（例如图片的替代文本）。如果你的系统存储用户数据，请说明你将如何保持数据安全并尊重隐私。在文档中提及这些要点，会提升你在社会与法律意识方面的得分。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图