📚 Summer Bridging Course for Year 13 SQA Computing Science | Year 13 SQA 计算机：暑期预习与衔接课程
Moving from SQA Higher Computing Science to Advanced Higher is a significant step up in both depth and independence. This summer bridging guide will help you identify the key skills, core knowledge areas, and study habits that will ease your transition into Year 13. You will be expected to apply computational thinking to more open-ended problems, manage a substantial practical project, and deepen your understanding of software development, database systems, and web technologies.
从 SQA 高级计算机科学升入高级进阶课程，无论在深度还是自主学习方面都是一个重要的飞跃。这份暑期衔接指南将帮助你明确关键技能、核心知识领域和学习习惯，让你更顺畅地过渡到 13 年级。你将需要运用计算思维解决更开放的问题、管理一个重要的实践项目，并加深对软件开发、数据库系统和网络技术的理解。
1. Understanding Advanced Higher Computing Science | 了解高级进阶计算机科学
The Advanced Higher Computing Science course is designed to develop deeper analytical and evaluative skills. You are expected to justify design decisions, compare algorithms, and critically assess the effectiveness of solutions. Unlike Higher, the course places a strong emphasis on independent learning and project management.
高级进阶计算机科学课程旨在培养更深层次的分析和评价能力。你需要论证设计决策、比较算法，并批判性地评估解决方案的有效性。与高级课程不同，该课程非常强调自主学习和项目管理。
- Focus on four key areas: Software Design and Development, Database Design and Development, Web Design and Development, and the mandatory coursework project.
聚焦四个关键领域： 软件设计与开发、数据库设计与开发、网站设计与开发以及必须完成的课程作业项目。 - The course builds on Higher concepts such as modular programming, SQL, and HTML/CSS, but introduces advanced topics like object-oriented design, normalisation up to third normal form (3NF), and client-side scripting with JavaScript.
该课程以高级阶段的概念（如模块化编程、SQL 和 HTML/CSS）为基础，但引入了面向对象设计、第三范式规范化以及 JavaScript 客户端脚本等进阶内容。
2. Key Differences Between Higher and Advanced Higher | 高级与高级进阶的主要区别
At Higher level, you were often guided through well-defined problems. At Advanced Higher, problems are more open-ended, and you are expected to break them down independently. The project, worth 40% of the final mark, requires you to plan, develop, test, and evaluate a software or information system over several months.
在高级阶段，你通常会在明确的问题引导下进行学习。在高级进阶阶段，问题更具开放性，你需要独立将它们分解。占总成绩 40% 的项目要求你在数月内规划、开发、测试并评估一个软件或信息系统。
- Assessment consists of a question paper (worth 60%) and the project (40%), compared to Higher where the project was worth 31%.
考核由一份笔试试卷（占 60%）和项目（占 40%）组成，而高级阶段的项目仅占 31%。 - You will need to produce detailed documentation, including analysis, design, implementation, testing, and evaluation, much closer to real-world software engineering practices.
你需要生成详细的文档，包括分析、设计、实施、测试和评估，这更接近真实的软件工程实践。
3. Strengthening Your Programming Foundation | 夯实编程基础
Whether you are working with Python, Java, or another language, your coding skills need to be robust. The Advanced Higher course expects you to demonstrate proficiency in structured data types, standard algorithms (searching, sorting, file handling), and good coding style.
无论你使用 Python、Java 还是其他语言，编码能力都必须扎实。高级进阶课程要求你熟练运用结构化数据类型、标准算法（搜索、排序、文件处理）以及良好的编码风格。
- Revise the use of arrays, lists, records, and sequential files. Practice passing parameters by value and by reference where your language supports it.
复习数组、列表、记录和顺序文件的使用。练习按值传递和按引用传递（若所用语言支持）。 - Implement the standard algorithms from scratch: linear search, count occurrences, find minimum/maximum, bubble sort, and insertion sort. Be able to trace and compare their efficiencies in terms of time complexity.
从头编写标准算法：线性查找、出现次数计数、查找最小值/最大值、冒泡排序和插入排序。能够追溯并比较它们的时间复杂度效率。 - Start using debugging tools and version control such as Git to manage your code, as you will need to demonstrate professional development practices.
开始使用调试工具和版本控制（如 Git）管理你的代码，因为你需要展示专业的开发实践。
4. Deepening Database Design Skills | 深化数据库设计技能
At Higher, you learned to create simple relational databases with primary and foreign keys. Advanced Higher extends this to more complex data modelling, normalisation, and SQL data manipulation and definition languages.
在高级阶段，你学习了创建带有主键和外键的简单关系数据库。高级进阶课程则将其扩展到更复杂的数据建模、规范化，以及 SQL 数据操纵语言和定义语言。
- Master entity-relationship (ER) diagrams and the ability to resolve many-to-many relationships.
掌握实体关系图以及解决多对多关系的能力。 - Normalisation to 3NF: understand partial and transitive dependencies. Practice taking unnormalised data through 1NF, 2NF, and 3NF.
掌握第三范式（3NF）的规范化：理解部分依赖和传递依赖。练习将未规范化的数据逐步转化为 1NF、2NF 和 3NF。 - Write more complex SQL queries using JOINs (INNER, LEFT, RIGHT), aggregate functions (COUNT, SUM, AVG, MAX, MIN), GROUP BY, and HAVING clauses. Also, practice data definition statements like CREATE TABLE, ALTER, and DROP.
编写更复杂的 SQL 查询，包括 JOIN（内连接、左连接、右连接）、聚合函数（COUNT, SUM, AVG, MAX, MIN）、GROUP BY 和 HAVING 子句。同时，练习 CREATE TABLE、ALTER 和 DROP 等数据定义语句。
5. Front-End and Back-End Web Development | 前端与后端 Web 开发
Advanced Higher web development includes both client-side scripting (usually JavaScript) and server-side scripting (often PHP). You should understand how the client-server model works, including HTTP requests and responses.
高级进阶阶段的 Web 开发涵盖客户端脚本（通常是 JavaScript）和服务器端脚本（通常是 PHP）。你应当理解客户端-服务器模型如何工作，包括 HTTP 请求和响应。
- HTML5 and CSS: go beyond basic tags to create responsive layouts using CSS Flexbox or Grid. Understanding accessibility standards (WCAG) is also important.
HTML5 和 CSS：超越基础标签，学会使用 CSS Flexbox 或 Grid 创建响应式布局。理解无障碍标准（WCAG）也很重要。 - JavaScript fundamentals: event handling, DOM manipulation, form validation, and simple dynamic content updates.
JavaScript 基础：事件处理、DOM 操作、表单验证和简单的动态内容更新。 - Server-side basics: understand how PHP connects to a database via MySQLi or PDO to retrieve and display data. Practice handling form data securely, avoiding SQL injection through prepared statements.
服务器端基础：了解 PHP 如何通过 MySQLi 或 PDO 连接数据库以检索和展示数据。练习安全地处理表单数据，通过预编译语句避免 SQL 注入。
6. Computer Architecture and Data Representation | 计算机体系结构与数据表示
This unit covers low-level concepts that are fundamental to understanding how software executes. You will explore the fetch-execute cycle in more detail, including pipelining, and compare RISC and CISC architectures.
本单元涵盖了对理解软件如何执行至关重要的底层概念。你将更详细地探索取指-执行周期，包括流水线技术，并比较 RISC 和 CISC 架构。
- Binary, hexadecimal, floating-point representation (mantissa and exponent), and two's complement for negative integers.
二进制、十六进制、浮点数表示（尾数和指数）以及用于负整数的二进制补码。 - Understand bit-map graphics, vector graphics, and common compression techniques (lossy and lossless).
理解位图图形、矢量图形以及常见的压缩技术（有损和无损）。 - Processor components: ALU, control unit, registers (MAR, MDR, PC, etc.), buses, and how cache memory improves performance.
处理器组件：算术逻辑单元、控制单元、寄存器（MAR、MDR、PC 等）、总线，以及缓存如何提升性能。
7. Software Development Process and Project Planning | 软件开发过程与项目规划
Your Advanced Higher project must follow a systematic development process. You need to demonstrate your ability to apply analysis, design, implementation, testing, and evaluation phases iteratively, and to use appropriate tools such as Gantt charts or a project diary.
你的高级进阶项目必须遵循系统的开发过程。你需要展示出迭代地应用分析、设计、实施、测试和评估各阶段的能力，并使用合适的工具，如甘特图或项目日志。
- Start thinking about potential project ideas now. Choose a realistic problem that will allow you to integrate a database with a user interface (desktop, web, or mobile).
从现在开始思考潜在的项目选题。选择一个现实的问题，使你能够将数据库与用户界面（桌面端、网页端或移动端）集成起来。 - Familiarise yourself with the SQA project assessment criteria. Marks are awarded for planning, analysis, design, implementation, testing, evaluation, and the quality of your report.
熟悉 SQA 的项目评估标准。分数分布在规划、分析、设计、实施、测试、评价以及报告质量上。 - Practice writing clear user requirements, functional specifications, and design documents (wireframes, structure diagrams, ER diagrams).
练习撰写清晰的用户需求、功能规格说明和设计文档（线框图、结构图、实体关系图）。
8. Logical and Computational Thinking | 逻辑与计算思维
The course expects you to think algorithmically and logically about problems. You will encounter pseudocode and need to translate it into working code, as well as trace given algorithms to predict their output.
该课程要求你对问题进行算法和逻辑层面的思考。你将遇到伪代码，并需要将其转化为可运行代码，同时也要能跟踪给定的算法以预测其输出。
- Work through logic puzzles and algorithmic challenges on platforms like Project Euler or Codewars to sharpen your skills.
通过 Project Euler 或 Codewars 等平台上的逻辑谜题和算法挑战来打磨你的技能。 - Understand top-down design, stepwise refinement, and the use of modules, functions, and procedures to manage complexity.
理解自顶向下设计、逐步求精，以及使用模块、函数和过程来管理复杂性。
9. Effective Note-Taking and Revision Techniques | 高效的笔记与复习技巧
With the increased volume of theoretical content, you need a systematic approach to note-taking. Create clear, concise notes for each topic area as you go, and use active recall and spaced repetition to solidify your knowledge.
随着理论内容的增加，你需要系统性的笔记方法。随时为每个主题领域创建清晰、简洁的笔记，并使用主动回忆和间隔重复来巩固知识。
- Draw diagrams for architectures, ER models, and sorting algorithms. Visual aids improve memory retention.
为体系结构、ER 模型和排序算法绘制图表。视觉辅助能提高记忆保持率。 - Summarise SQL syntax and common PHP functions on flashcards. Practice writing code by hand, as the question paper may include handwritten code questions.
将 SQL 语法和常用 PHP 函数总结在抽认卡上。练习手写代码，因为笔试试卷可能包含手写代码题目。
10. Resources and Self-Study Materials | 资源与自学材料
While your teacher will provide the core materials, building a personal library of resources can greatly enhance your understanding. Use the SQA website to download past papers, coursework specification, and exemplar projects.
虽然你的老师会提供核心材料，但建立个人资源库可以大大加深你的理解。使用 SQA 网站下载历年真题、课程作业规范和范例项目。
- Websites: W3Schools for web development basics, SQLZoo for interactive SQL practice, and BBC Bitesize Higher Computing Science for quick refreshers on pre-requisite topics.
网站资源：W3Schools 用于 Web 开发基础，SQLZoo 用于交互式 SQL 练习，BBC Bitesize 高级计算机科学用于预修主题的快速回顾。 - Books: look for 'How to Pass Advanced Higher Computing Science' and 'SQA Advanced Higher Computing Science' textbooks for structured content and sample answers.
书籍：查找 How to Pass Advanced Higher Computing Science 和 SQA Advanced Higher Computing Science 等教材，以获取结构化内容和示例答案。
11. Summer Bridging Tasks to Complete | 建议完成的暑期衔接任务
To hit the ground running in August, set yourself a few practical tasks. These will refresh your Higher knowledge and introduce you to Advanced Higher expectations.
为了在八月份顺利开始，给自己设定几个实践任务。这些任务将刷新你的高级阶段知识，并让你初步了解高级进阶阶段的要求。
- Build a simple web application that connects to a database. For example, a book review site where users can add and rate books. Use HTML, CSS, JavaScript for the front-end, and PHP/MySQL for the back-end.
构建一个连接数据库的简单 Web 应用程序。例如，一个图书评论网站，用户可以添加书籍并评分。前端使用 HTML、CSS、JavaScript，后端使用 PHP/MySQL。 - Create a detailed analysis and design for that application, including ER diagram, data dictionary, wireframes, and pseudocode for core functionality.
为该应用程序创建详细的分析和设计，包括 ER 图、数据字典、线框图以及核心功能的伪代码。 - Solve 5-10 programming problems that involve arrays, sorting, and file handling. Write your solutions in Python or Java and add comments explaining your logic.
解决 5-10 个涉及数组、排序和文件处理的编程问题。用 Python 或 Java 编写解决方案，并添加注释解释您的逻辑。 - Review normalisation by taking a sample dataset (e.g., an invoice or student enrolment form) and transforming it to 3NF.
通过选取一个样本数据集（例如发票或学生注册表）并将其转化为 3NF，复习规范化的概念。
12. Mindset and Study Routine | 心态与学习日常
Advanced Higher requires consistent effort over the full academic year. Treat it like a marathon, not a sprint. Develop a weekly schedule that allocates time for reading ahead, coding practice, and project work, and stick to it.
高级进阶需要在整个学年中持续不断地努力。把它当作一场马拉松，而非短跑。制定一个每周时间表，为预习、编码练习和项目工作分配时间，并坚持下去。
- Join or form a study group with peers also taking the course. Discussing concepts with others clarifies your own understanding and can reveal new perspectives on complex topics.
加入或组建一个与同级同学的互助小组。与他人讨论概念能厘清自己的理解，并可能在复杂话题上带来新的视角。 - Don't hesitate to ask your teacher for feedback on your project ideas and early drafts of your documentation. Early guidance can prevent major rework later on.
不要犹豫，就项目选题和文档初稿向老师寻求反馈。早期的指导可以避免日后重大返工。
Published by TutorHao | Computing Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图