📚 Year 11 SQA Computing Science: High-Achiever's Revision Guide and Exam Tips | Year 11 SQA 计算机：学霸高分经验分享
Are you a Year 11 student preparing for the SQA National 5 Computing Science exam? Achieving top marks requires more than just memorising facts—it demands a strategic approach to theory, practical programming, and exam technique. In this guide, we share proven high-achiever tips to help you excel.
作为一名准备参加SQA国家5级计算机科学考试的Year 11学生，想要获得高分并不仅仅是死记硬背事实——这需要将理论学习、实践编程和考试技巧结合起来，采用一种策略性的方法。在这篇指南中，我们将分享经过验证的学霸经验，帮助你脱颖而出。
1. Understanding the SQA Computing Science Course Structure | 了解SQA计算机科学课程结构
National 5 Computing Science consists of four key areas: Software Design and Development, Computer Systems, Database Design and Development, and Web Design and Development. The final grade is based on a question paper (worth 110 marks) and an assignment (worth 50 marks). Knowing the weightings helps you allocate revision time wisely.
国家5级计算机科学包括四个关键领域：软件设计与开发、计算机系统、数据库设计与开发以及网页设计与开发。最终成绩由一份试卷（110分）和一项作业（50分）决定。了解各部分所占比重，有助于你合理分配复习时间。
High scorers begin by assessing their strengths and weaknesses across these units. They then create a revision timetable that prioritises challenging topics while maintaining a balanced overview.
高分的学霸们会首先评估自己在这些单元中的长处和短处。然后制定一个复习时间表，优先处理有挑战性的主题，同时保持对整体内容的均衡复习。
2. Mastering Software Design and Development | 掌握软件设计与开发
This unit covers data types, structures, computational constructs (sequence, selection, iteration), and standard algorithms such as input validation, finding maximum/minimum, and linear search. You must be able to write pseudocode and understand code in languages like Python or Visual Basic.
该单元涵盖数据类型、数据结构、计算结构（顺序、选择、迭代）以及标准算法，如输入验证、查找最大值/最小值和线性搜索。你必须能够编写伪代码，并理解Python或Visual Basic等语言的代码。
A top tip is to practice writing your own algorithms from scratch. For example, test yourself by coding a program that reads 10 numbers and outputs the highest. Use trace tables to dry-run your logic, as this builds exam confidence.
一个顶尖技巧是从头开始练习编写自己的算法。例如，通过编写一个读取10个数字并输出最大值的程序来测试自己。使用跟踪表来推演你的逻辑，这样可以增强考试时的信心。
Pay close attention to data types: Integer, Real, String, Boolean. Know how to declare variables and assign values correctly. In SQA exams, forgetting to initialise a counter or using the wrong data type can cost marks.
要密切关注数据类型：整型、实型、字符串、布尔型。知道如何正确声明变量并赋值。在SQA考试中，忘记初始化计数器或使用错误的数据类型都可能导致失分。
< > = ≤ ≥ ≠), and logical (AND, OR, NOT). Use precise symbols: e.g., AND can be written as ∧, OR as ∨, NOT as ¬. But you can also use words AND, OR, NOT. Stick to what your teacher uses.
记住标准运算符：算术运算符（+ − * / ^）、关系运算符（< > = ≤ ≥ ≠）和逻辑运算符（AND、OR、NOT）。可以使用精确符号：例如，AND可写为∧，OR为∨，NOT为¬。但也可以使用AND、OR、NOT字样。按照你老师使用的方式来写。
3. Database Design and SQL Mastery | 数据库设计与SQL精通
Database questions often ask you to design tables with appropriate fields, data types, and keys (primary key, foreign key). SQL queries are tested, including SELECT, FROM, WHERE, ORDER BY, and simple joins.
数据库题目通常要求你设计包含适当字段、数据类型和键（主键、外键）的表。SQL查询是考查重点，包括SELECT、FROM、WHERE、ORDER BY以及简单的连接。
a computer. Use sample databases like one for a library or a shop. Write queries such as: 'SELECT * FROM Books WHERE genre = "Fiction" ORDER BY title ASC;' Understand that ASC means ascending, DESC descending.
学霸们会在没有计算机的情况下练习编写SQL。使用示例数据库，比如图书馆或商店的数据库。编写诸如以下查询：“SELECT * FROM Books WHERE genre = 'Fiction' ORDER BY title ASC;”理解ASC表示升序，DESC表示降序。
You should also know how to update data (UPDATE ... SET) and delete records (DELETE FROM ... WHERE). Be careful with logical conditions using AND and OR; always test with sample data mentally.
你还应知道如何更新数据（UPDATE ... SET）和删除记录（DELETE FROM ... WHERE）。小心使用AND和OR的逻辑条件；总是用心算测试示例数据。
For the assignment, you might have to create a database and query it. Document your design clearly: an Entity-Relationship (ER) diagram with entities, attributes, and relationships can earn high marks.
在作业中，你可能需要创建数据库并查询它。清晰地记录你的设计：一个包含实体、属性和关系的实体-关系图可以赢得高分。
4. Web Design and Development (HTML & CSS) | 网页设计与开发（HTML和CSS）
You are expected to create web pages using HTML and CSS. Know the basic structure of an HTML document: <!DOCTYPE html>, <html>, <head>, <body>. Understand tags for headings (h1–h6), paragraphs (p), images (img), hyperlinks (a), and lists (ul, ol).
你需要使用HTML和CSS创建网页。了解HTML文档的基本结构：<!DOCTYPE html>、<html>、<head>、<body>。理解用于标题（h1–h6）、段落（p）、图像（img）、超链接（a）和列表（ul、ol）的标签。
CSS is used for presentation. Know how to change font properties, colours, backgrounds, and layout. Use inline, internal, and external styles. For exams, be able to read and interpret given CSS code and predict the appearance of a page. Practice using class and ID selectors.
CSS用于表现。知道如何更改字体属性、颜色、背景和布局。使用内联、内部和外部样式。对于考试，要能够阅读并解释给定的CSS代码，并预测页面的外观。练习使用类和ID选择器。
Top students build a small personal website during revision. This not only solidifies HTML/CSS skills but also prepares them for the assignment. Remember that good design is also about usability and accessibility: alternative text for images (alt attribute) and consistent navigation are important.
学霸在复习期间会构建一个小型个人网站。这不仅巩固了HTML/CSS技能，也为作业做好了准备。记住，好的设计也包括可用性和可访问性：图片的替代文本（alt属性）和一致的导航很重要。
5. Computer Systems: Hardware and Binary Brilliance | 计算机系统：硬件与二进制亮点
This unit explores the processor (ALU, control unit, registers), memory (RAM, ROM), storage (HDD, SSD), and binary representation. You need to be able to convert between binary, denary, and hexadecimal, and understand how floating-point representation works (IEEE 754 simplified).
本单元探讨处理器（ALU、控制单元、寄存器）、存储器（RAM、ROM）、存储设备（HDD、SSD）和二进制表示。你需要能够在二进制、十进制和十六进制之间转换，并了解浮点表示法（简化的IEEE 754）的工作原理。
100 1101 (77 in denary) + 0011 0010 (50) = 0111 1111 (127). Watch out for overflow errors.
二进制算术非常关键：两个二进制数相加，有时是减法。使用8位寄存器进行练习。例如，0100 1101（十进制为77）+ 0011 0010（50）= 0111 1111（127）。注意溢出错误。
Logic gates (AND, OR, NOT, NAND, NOR) and truth tables are frequently tested. Draw logic circuits from Boolean expressions. Remember De Morgan's laws. In exams, use standard symbols and show all workings. Even a simple mistake can lose a mark, so double-check truth table rows.
逻辑门（与、或、非、与非、或非）和真值表经常会被考到。根据布尔表达式绘制逻辑电路。记住德·摩根定律。在考试中，使用标准符号并展示所有步骤。即使是一个简单的错误也可能丢分，所以一定要仔细检查真值表的每一行。
6. Effective Programming and Algorithmic Thinking | 高效编程与算法思维
Many marks in the question paper come from reading, understanding, and writing code. Develop a problem-solving mindset. For each programming task, break it down into Input, Process, Output (IPO). Use pseudocode first, then translate into a specific language.
试卷中的很多分数都来自于阅读、理解和编写代码。培养解决问题的思维方式。对于每个编程任务，将其分解为输入、处理、输出（IPO）。首先使用伪代码，然后翻译成特定语言。
Know common programming constructs well: IF...THEN...ELSE, FOR loops, WHILE loops, REPEAT...UNTIL. Also, arrays (lists) are used to store multiple values. Understand how to search and sort; even if you don't need to code sorting, you should understand the algorithm of bubble sort or find minimum.
要熟练掌握常见编程结构：IF...THEN...ELSE、FOR循环、WHILE循环、REPEAT...UNTIL。另外，数组（列表）用于存储多个值。了解如何搜索和排序；即使你不需要编写排序代码，也应该理解冒泡排序或查找最小值的算法。
High scorers practice by doing 'code tracing'. Given a snippet of code, they predict the output. This is a skill that develops with repeated paper-based exercises. Always keep track of variable values in a trace table. This helps avoid 'off-by-one' errors, which are common in loops.
学霸通过进行“代码追踪”来练习。给定一段代码，他们预测输出结果。这是一项通过反复做书面练习来培养的技能。始终在跟踪表中记录变量值。这有助于避免循环中常见的“差一错误
Published by TutorHao | Year 11 Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图