Year 12 SQA Computing Science: Core Knowledge Review | SQA 计算机 Year 12:核心知识点梳理

📚 Year 12 SQA Computing Science: Core Knowledge Review | SQA 计算机 Year 12:核心知识点梳理

As students approach Year 12 in the Scottish Qualifications Authority (SQA) curriculum, Computing Science becomes increasingly rigorous, demanding a solid grasp of theoretical concepts and practical skills. This article provides a structured review of the core knowledge areas crucial for success in assessments and examinations. By understanding these fundamentals, learners can build confidence and deepen their computational thinking.

随着学生进入苏格兰资格认证局(SQA)的 Year 12 阶段,计算机科学的要求越来越高,需要牢固掌握理论概念和实践技能。本文系统地梳理了核心知识点,这些知识点对于在评估和考试中取得成功至关重要。通过理解这些基础内容,学生可以建立信心,深化计算思维。


1. Software Design and Development Process | 软件设计与开发过程

The software development lifecycle (SDLC) typically follows an iterative model comprising analysis, design, implementation, testing, documentation, and evaluation. During analysis, developers gather user requirements through techniques such as interviews, observation, and document inspection. Design translates these requirements into structure diagrams, flowcharts, and pseudocode, ensuring a clear blueprint before coding begins.

软件开发生命周期(SDLC)通常遵循一个迭代模型,包括分析、设计、实现、测试、文档和评估。在分析阶段,开发人员通过访谈、观察和文档检查等技术收集用户需求。设计将这些需求转化为结构图、流程图和伪代码,确保在开始编码前有一个清晰的蓝图。

Top-down design and stepwise refinement break complex problems into manageable modules. Each module should have a single well-defined purpose, promoting reusability and easier maintenance. Parameter passing mechanisms – by value or by reference – control how data flows between procedures. Pass by value sends a copy, leaving the original unchanged; pass by reference allows the procedure to modify the actual argument directly.

自顶向下设计和逐步细化将复杂问题分解为可管理的模块。每个模块应具有单一明确的目的,从而提高可重用性并易于维护。参数传递机制——传值或传引用——控制数据如何在过程之间流动。传值发送一个副本,原始值保持不变;传引用允许过程直接修改实参。

The implementation phase involves writing and compiling code. Developers must choose appropriate data types (integer, real, string, Boolean) and control structures (sequence, selection, iteration). Well-structured code uses meaningful identifiers and internal commentary to enhance readability, which is critical for collaborative development and future maintenance.

实现阶段涉及编写和编译代码。开发人员必须选择合适的数据类型(整数、实数、字符串、布尔型)和控制结构(顺序、选择、迭代)。结构良好的代码使用有意义的标识符和内部注释来提高可读性,这对于协作开发和未来的维护至关重要。


2. Low-Level Operations and Computer Architecture | 低级操作与计算机体系结构

Understanding how a computer executes instructions involves exploring the processor, memory, and buses. The central processing unit (CPU) contains the control unit (CU), arithmetic logic unit (ALU), and registers. The CU decodes instructions and coordinates execution cycles (fetch-decode-execute). The ALU performs arithmetic and logical operations using data temporarily held in registers such as the accumulator, program counter, and memory address register.

要理解计算机如何执行指令,需要探索处理器、存储器和总线。中央处理器(CPU)包含控制单元(CU)、算术逻辑单元(ALU)和寄存器。CU 对指令进行解码并协调查询周期(取指-译码-执行)。ALU 使用临时存放在寄存器(如累加器、程序计数器和内存地址寄存器)中的数据执行算术和逻辑运算。

Buses – data, address, and control – transport information between components. The width of the data bus determines how many bits can be moved simultaneously, while the address bus width dictates the maximum addressable memory. Binary representation underpins all processing; signed integers can be stored using two’s complement, and floating-point numbers use mantissa and exponent formats.

总线——数据总线、地址总线和控制总线——在组件之间传输信息。数据总线的宽度决定了同一时间可以移动多少位,地址总线的宽度决定了可寻址的最大内存。二进制表示是所有处理的基础;有符号整数可以使用二进制补码存储,浮点数使用尾数和指数格式存储。

Machine code is the only language directly executed by the processor. Assembly language uses mnemonics (like LDR, ADD, STR) that are translated by an assembler. High-level languages are more accessible but require compilers or interpreters. A compiler translates the entire source code into machine code before execution; an interpreter translates and executes line by line, which aids debugging but typically runs slower.

机器码是处理器唯一直接执行的语言。汇编语言使用助记符(如 LDR、ADD、STR),由汇编器翻译。高级语言更易于使用,但需要编译器或解释器。编译器在执行前将整个源代码翻译成机器码;解释器逐行翻译并执行,这有助于调试,但通常运行较慢。


3. Data Structures and Storage | 数据结构与存储

Efficient data handling relies on selecting appropriate data structures. One-dimensional arrays (1D arrays) store elements of the same type contiguously in memory, enabling direct access via an index. Two-dimensional arrays extend this concept to rows and columns, ideal for tables or grids. Arrays have a fixed size at declaration, whereas records (or structures) group related data of differing types under a single identifier.

高效的数据处理依赖于选择合适的数据结构。一维数组在内存中连续存储相同类型的元素,支持通过索引直接访问。二维数组将此概念扩展到行和列,非常适合表格或网格。数组在声明时大小固定,而记录(或结构)将不同类型相关数据组合在一个标识符下。

Dynamic data structures such as linked lists, stacks, and queues allow memory to be allocated at runtime. A stack follows Last In First Out (LIFO) and is used for backtracking or managing subroutine calls. A queue implements First In First Out (FIFO), common in print spooling. Implementing these structures requires pointers to connect nodes, and careful handling to avoid memory leaks.

动态数据结构如链表、栈和队列允许在运行时分配内存。栈遵循后进先出(LIFO),用于回溯或管理子程序调用。队列实现先进先出(FIFO),常见于打印排队。这些结构的实现需要使用指针连接节点,并小心处理以避免内存泄漏。

File handling is essential for persistent storage. Sequential files store records one after another and are simple but slow for searching; random (or direct) access files allow records to be retrieved using a calculated position, significantly improving access time. Files can be opened for reading, writing, or appending, and must be closed properly to prevent data corruption.

文件处理对于持久存储至关重要。顺序文件一条接一条地存储记录,结构简单但搜索较慢;随机(或直接)访问文件允许使用计算出的位置检索记录,显著提高访问速度。文件可以打开用于读取、写入或追加,并且必须正确关闭以防止数据损坏。


4. Networking and Communication Protocols | 网络与通信协议

Computer networks enable resource sharing and communication. The OSI and TCP/IP models structure networking into layers, with the TCP/IP model having four layers: application, transport, internet, and network access. The application layer includes protocols like HTTP, HTTPS, FTP, SMTP, and IMAP. HTTPS adds encryption via SSL/TLS, ensuring confidentiality and integrity.

计算机网络实现了资源共享和通信。OSI 和 TCP/IP 模型将网络划分为层次结构,TCP/IP 模型有四层:应用层、传输层、互联网层和网络接入层。应用层包含 HTTP、HTTPS、FTP、SMTP 和 IMAP 等协议。HTTPS 通过 SSL/TLS 增加加密功能,确保机密性和完整性。

The transport layer provides end-to-end communication, with TCP establishing reliable, connection-oriented transmission using handshaking and acknowledgments, while UDP offers faster, connectionless delivery suitable for streaming. At the internet layer, IP handles addressing and routing. IPv4 addresses are 32-bit, expressed in dotted decimal; IPv6 uses 128-bit hexadecimal to accommodate more devices.

传输层提供端到端的通信,TCP 通过握手和确认建立可靠的、面向连接的传输,而 UDP 则提供更快的、无连接的传送,适用于流媒体。在互联网层,IP 处理寻址和路由。IPv4 地址是 32 位的,用点分十进制表示;IPv6 使用 128 位的十六进制地址,以适应更多的设备。

Intermediary devices like routers, switches, and hubs facilitate data flow. A switch forwards data intelligently to the specific device using MAC addresses, whereas a hub broadcasts to all ports. A router connects different networks, using IP addresses to determine the best path. Contention on shared media is managed by protocols such as CSMA/CD (used in wired Ethernet) to detect and handle collisions.

路由器、交换机和集线器等中间设备促进数据流动。交换机使用 MAC 地址智能地将数据转发到特定设备,而集线器则向所有端口广播。路由器连接不同的网络,使用 IP 地址确定最佳路径。共享介质上的争用由 CSMA/CD(用于有线以太网)等协议管理,以检测和处理冲突。


5. Database Design and SQL | 数据库设计与 SQL

A database stores structured information, and a relational database organises data into tables linked by primary and foreign keys. The primary key uniquely identifies each record in a table; a foreign key references a primary key in another table, enforcing referential integrity. Normalisation reduces data redundancy and avoids update anomalies by progressing through first, second, and third normal forms (1NF, 2NF, 3NF).

数据库存储结构化信息,关系数据库将数据组织成由主键和外键连接的表。主键唯一标识表中的每条记录;外键引用另一个表中的主键,强制参照完整性。规范化通过逐步达到第一、第二和第三范式(1NF、2NF、3NF)来减少数据冗余并避免更新异常。

Entity-relationship diagrams (ERDs) visually model database structures, showing entities as rectangles, attributes as ovals, and relationships as diamonds, with cardinality indicating one-to-one, one-to-many, or many-to-many links. A many-to-many relationship must be resolved by introducing a link entity to maintain database integrity.

实体关系图(ERD)可视化地建模数据库结构,用矩形表示实体,椭圆表示属性,菱形表示关系,并标注基数以表明一对一、一对多或多对多的联系。多对多关系必须通过引入链接实体来解决,以维持数据库的完整性。

Structured Query Language (SQL) is used to manipulate and retrieve data. Key statements include SELECT … FROM … WHERE … ORDER BY with operators LIKE, BETWEEN, and logical AND/OR. Aggregate functions (COUNT, SUM, AVG, MAX, MIN) along with GROUP BY and HAVING enable advanced summaries. INSERT, UPDATE, and DELETE modify data, while JOIN clauses combine rows from two or more tables based on a related column.

结构化查询语言(SQL)用于操作和检索数据。关键语句包括 SELECT … FROM … WHERE … ORDER BY 以及 LIKE、BETWEEN 和逻辑 AND/OR 等运算符。聚合函数(COUNT、SUM、AVG、MAX、MIN)与 GROUP BY 和 HAVING 搭配使用可实现高级汇总。INSERT、UPDATE 和 DELETE 修改数据,而 JOIN 子句根据相关列合并两个或多个表中的行。


6. Web Technologies: HTML, CSS, and JavaScript | 网络技术:HTML、CSS 和 JavaScript

Web development comprises three core technologies: HTML for structure, CSS for presentation, and JavaScript for behaviour. HTML uses elements defined by tags (

, ,

, , ,

) to organise content. Semantic HTML5 elements (header, nav, section, article, footer) improve accessibility and search engine optimisation. Forms collect user input via ,

Comments

屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导,国外大学本科硕士研究生博士课程论文辅导Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from aleveler.com

Subscribe now to keep reading and get access to the full archive.

Continue reading