📚 Year 10 SQA Computing: Interdisciplinary Integrated Question Training | Year 10 SQA 计算机：跨学科综合题型训练
In the SQA Year 10 Computing Science curriculum, interdisciplinary questions are designed to test your ability to connect programming, databases, networks, and digital literacy with real‑world problems in mathematics, science, and business. This article equips you with targeted practice through example tasks, step‑by‑step reasoning, and model answers that mirror the integrated style you will face in assessments.
在 SQA Year 10 计算机科学课程中，跨学科题型旨在考查你将编程、数据库、网络和数字素养与数学、科学及商业中的实际问题联系起来的能力。本文通过例题、逐步推理和示范答案，为你提供有针对性的训练，这些内容完全模拟你在评估中可能遇到的一体化出题风格。
1. Algorithm Design and Mathematical Modelling | 算法设计与数学建模
Many SQA tasks ask you to write a program that solves a mathematical problem – for example, finding roots of a quadratic equation. You must be able to translate a formula into code, handle edge cases, and produce clear output.
许多 SQA 任务要求你编写一个解决数学问题的程序——例如，求一元二次方程的根。你必须能够将公式转换为代码，处理边界情况，并生成清晰的输出。
Example problem: Write a Python function solve_quadratic(a, b, c) that returns the roots of ax² + bx + c = 0, accommodating both real and complex roots. Display results to two decimal places where appropriate.
例题：编写一个 Python 函数 solve_quadratic(a, b, c)，返回方程 ax² + bx + c = 0 的根，同时涵盖实根与复根情况。适当时将结果显示为两位小数。
Solution approach: First compute the discriminant D = b² − 4ac. If D ≥ 0, calculate the real roots using x = (−b ± √D) / (2a). If D < 0, the real part is −b / (2a) and the imaginary part is √−D / (2a). Use string formatting to present the result neatly, and note that the program should handle the special case when a = 0 (not a quadratic).
解法思路：首先计算判别式 D = b² − 4ac。若 D ≥ 0，使用 x = (−b ± √D) / (2a) 计算实根。若 D < 0，实部为 −b / (2a)，虚部为 √−D / (2a)。用字符串格式化整齐地呈现结果，并注意程序应处理 a = 0 的特殊情况（非二次方程）。
An interdisciplinary twist might ask you to use these roots as input to a further scientific simulation – for instance, calculating the time when a projectile reaches a certain height, which links algorithmic thinking with kinematics from physics.
跨学科的延伸可能要求你将这些根作为进一步科学模拟的输入——例如，计算抛射体达到某一高度的时间，这就将算法思维与物理学中的运动学联系了起来。
2. Database Queries for Business Intelligence | 商业智能中的数据库查询
Database design and SQL querying are core SQA skills. Integrated questions often present a real‑life business scenario, such as tracking orders and stock, and ask you to extract meaningful insights using aggregate functions, joins, and filters.
数据库设计和 SQL 查询是 SQA 的核心技能。综合题型通常会提供一个真实的商业场景，例如跟踪订单和库存，并要求你使用聚合函数、连接和筛选来提取有意义的洞察。
Scenario: A retailer maintains two tables: Products(ProductID, Name, Category, Price) and Sales(SaleID, ProductID, Quantity, SaleDate). You are asked to find the total revenue generated by each category in the first quarter of 2025 and to list any category that has generated less than £500.
情景：一家零售商维护着两个表格：Products(ProductID, Name, Category, Price) 和 Sales(SaleID, ProductID, Quantity, SaleDate)。要求你找出 2025 年第一季度各类别的总收入，并列出任何收入低于 500 英镑的类别。
The following table summarises sample rows from the two tables (showing the typical structure you would work with):
下表总结了两个表格中的示例行（展示你通常会面对的表结构）：
| Products | Sales |
|---|---|
| P01, 'Widget', 'Gadgets', 12.99 | S101, P01, 5, '2025-01-15' |
| P02, 'Gizmo', 'Gadgets', 8.50 | S102, P02, 3, '2025-02-10' |
| P03, 'Doohickey', 'Tools', 24.00 | S103, P01, 2, '2025-03-22' |
Solution approach: Write an SQL query that joins the two tables on ProductID, groups by Category, sums the product of Price and Quantity, and filters using SaleDate between '2025-01-01' and '2025-03-31'. Then apply a HAVING clause to select those groups where the total revenue is below 500. This blends mathematics (multiplication and summation) with business logic and database skills.
解法思路：编写一条 SQL 查询，通过在 ProductID 上连接两张表，按 Category 分组，对 Price 与 Quantity 的乘积求和，并使用 SaleDate 在 '2025-01-01' 和 '2025-03-31' 之间进行筛选。然后运用 HAVING 子句选出总收入低于 500 的组。这就将数学（乘法和加法）与商业逻辑和数据库技能结合在了一起。
3. IoT Networks and Scientific Data Collection | 物联网网络与科学数据采集
Integrated questions may combine computer systems and networking with environmental science. Imagine a network of temperature sensors in a greenhouse uploading readings every 10 minutes to a cloud server. You need to explain the hardware, the transmission protocol, and how to analyse the collected data.
综合题型可能将计算机系统与网络同环境科学结合起来。设想一个温室中的温度传感器网络，每 10 分钟将读数上传到云端服务器。你需要解释硬件、传输协议以及如何分析收集到的数据。
Hardware layer: Each node consists of a microcontroller (e.g., Raspberry Pi Pico), a temperature sensor (DS18B20), and a Wi‑Fi module. You should be able to describe how the sensor converts an analogue signal to a digital reading via the microcontroller's ADC.
硬件层：每个节点包含一个微控制器（如 Raspberry Pi Pico）、一个温度传感器（DS18B20）和一个 Wi‑Fi 模块。你需要能够描述传感器如何通过微控制器的 ADC 将模拟信号转换为数字读数。
Networking aspect: Data is transmitted using MQTT, a lightweight publish‑subscribe protocol ideal for low‑power devices. The microcontroller publishes temperature values to a topic; a central broker then sends these to a database. You may be asked to justify the choice of MQTT over HTTP in terms of overhead and energy efficiency.
网络方面：数据通过 MQTT（一种适合低功耗设备的轻量级发布‑订阅协议）进行传输。微控制器将温度值发布到一个主题；中央代理随后将这些数据发送到数据库。你可能会被要求在开销和能效方面论证为何选择 MQTT 而非 HTTP。
Data analysis: Once stored in a database, you can write SQL or Python scripts to calculate the daily average, detect anomalies (e.g., values outside 15°C–30°C), and visualise trends using a chart library. This mirrors the cross‑curricular link with statistics and geography (climate studies).
数据分析：数据存入数据库后，你可以编写 SQL 或 Python 脚本来计算日平均值，检测异常（例如超出 15°C–30°C 的值），并使用图表库将趋势可视化。这反映了与统计学和地理学（气候研究）的跨学科联系。
4. Web Development for Multimedia Storytelling | 多媒体叙事网页开发
SQA assessments may require you to build a simple website that integrates text, images, and video to convey a historical or cultural topic. This tests your HTML, CSS, and responsive design skills while encouraging creative collaboration with humanities subjects.
SQA 评估可能要求你构建一个简单的网站，整合文本、图像和视频来传达一个历史或文化主题。这既考查你的 HTML、CSS 和响应式设计技能，又鼓励你与人文学科进行创造性协作。
Task example: Create a two‑page website about the Scottish Enlightenment. Page one should include an embedded YouTube video, a timeline with HTML list elements, and a responsive image. Page two should present a short CSS‑styled article with a sidebar containing key figures. Use media queries to ensure usability on mobile devices.
任务示例：创建一个关于苏格兰启蒙运动的两页网站。第一页应包含一个嵌入的 YouTube 视频、一个使用 HTML 列表元素的时间线以及一张响应式图片。第二页应展示一篇经过 CSS 美化的短文，并附有包含关键人物的侧边栏。使用媒体查询确保在移动设备上的可用性。
Interdisciplinary angle: Selecting appropriate content requires historical understanding; presenting it clearly demands digital design literacy. You might also need to justify accessibility choices, such as alt text for images or closed captions for videos. This links to ethical and social considerations – ensuring digital content is inclusive.
跨学科角度：选取适当的内容需要历史理解；清晰地呈现它则需要数字设计素养。你可能还需要论证无障碍性选择，如图片的替代文本或视频的字幕。这就联系到了伦理和社会考量——确保数字内容的包容性。
5. Ethics, Law, and Social Impact of AI | 人工智能的道德、法律与社会影响
Modern computing cannot be divorced from its societal consequences. SQA questions frequently ask you to evaluate the ethical implications of technologies such as facial recognition, recommendation algorithms, or driverless cars. These tasks draw on skills from modern studies and philosophy.
现代计算技术离不开其社会影响。SQA 考题经常要求你评价人脸识别、推荐算法或无人驾驶汽车等技术的伦理影响。这些任务借鉴了现代研究和哲学的思维方式。
Case study: A school proposes using an AI system to monitor students' online activity during class, flagging potential off‑task behaviour. Discuss the benefits (improved focus, safeguarding) against the risks (erosion of trust, data privacy, algorithmic bias). You must structure your answer using a balanced argument – presenting both sides and reaching a justified conclusion.
案例研究：一所学校计划使用 AI 系统监测学生课堂上的在线活动，以标记潜在的偏离任务行为。讨论其好处（提高专注度、保障安全）与风险（信任侵蚀、数据隐私、算法偏见）。你必须运用平衡的论证结构来组织答案——呈现双方观点，并得出有据可依的结论。
To excel, you should refer to specific legislation such as the UK Data Protection Act 2018 and the concept of algorithmic transparency. This shows you can integrate legal knowledge with technical awareness – exactly the kind of synthesis rewarded in interdisciplinary marking schemes.
要取得高分，你应引用具体法律，如《2018 年英国数据保护法》以及算法透明性的概念。这表明你能够将法律知识与技术意识融为一体——这正是跨学科评分方案中给予奖励的综合能力。
6. Binary Arithmetic and Logic Circuits | 二进制运算与逻辑电路
Understanding binary and logic gates is fundamental, but integrated questions push you to connect this with electrical engineering concepts. You might design a simple adder circuit using Boolean expressions, then show how it would be implemented with transistors – a bridge between computer science and physics.
理解二进制与逻辑门是基础，但综合题会推动你将其与电子工程概念联系起来。你可能会使用布尔表达式设计一个简单的加法器电路，然后展示如何用晶体管实现它——这是计算机科学与物理学之间的桥梁。
Example: Given two 2‑bit numbers A (A₁ A₀) and B (B₁ B₀), produce a truth table for the sum output S₀, S₁, and carry out C. Derive the simplified Boolean expression for S₀ using a Karnaugh map. Then state the logic gates needed to build this half‑adder.
示例：给定两个 2 位二进制数 A (A₁ A₀) 和 B (B₁ B₀)，为和输出 S₀、S₁ 以及进位 C 制作真值表。使用卡诺图推导 S₀ 的简化布尔表达式。然后说明构建此半加器所需的逻辑门。
ons of input bits. For each, compute binary addition. The truth table reveals that S₀ = A₀ ⊕ R gate built from NAND gates) reinforces the integration of logic design with electronics.
我们可以分步骤清晰地解决这个问题：首先，列出所有输入位组合。对每种组合进行二进制加法。真值表显示 S₀ = A₀ ⊕ B₀（异或），而 C₁（进到下一列的进位）= A₀ AND B₀。推动你将它们映射回物理元件（例如，由与非门构成的异或门），这就强化了逻辑设计与电子学的整合。
7. Game Physics: Vectors and Collision Detection | 游戏物理：向量与碰撞检测
Games programming is a popular SQA context that naturally blends computing with coordinate geometry and physics. Detecting whether two game objects collide often uses bounding‑box checks and vector mathematics.
游戏编程是 SQA 中一个颇受欢迎的情境，它自然地将计算机与坐标几何和物理融合在一起。检测两个游戏对象是否碰撞常常使用包围盒检查和向量数学。
Problem: A character with a circular collision radius r moves from point P₁(x₁, y₁) to P₂(x₂, y₂) in a single frame. A rectangular obstacle is defined by its top‑left corner (Xₒ, Yₒ), width w, and height h. You are to write pseudocode that determines whether the character hits the obstacle, taking the movement into account.
问题：一个具有圆形碰撞半径 r 的角色在一帧内从点 P₁(x₁, y₁) 移动到 P₂(x₂, y₂)。一个矩形障碍物由其左上角 (Xₒ, Yₒ)、宽度 w 和高度 h 定义。你需要编写伪代码，判断角色在此次移动中是否会撞上障碍物。
Solution approach: First, compute the vector of motion d ion to find the closest point on the trajectory to the rectangle, then compute the distance from that point to the centre of the character. If the distance is less than r at any moment, a collision occurs. This integrates vector maths from the maths curriculum and physics concepts of displacement with computational logic (loops, conditionals).
解法思路：首先，计算运动向量 d = (x₂−x₁, y₂−y₁)。利用标量投影找到轨迹上距矩形最近的点，然后计算该点到角色中心的距离。若任一时刻距离小于 r，则发生碰撞。这融合了数学课程中的向量数学、物理中的位移概念以及计算逻辑（循环、条件判断）。
8. Integrated Practice Question and Walkthrough | 综合实践题与解析
Bring everything together with a single multi‑step exercise that mimics the style of a high‑mark SQA question. This task combines database handling, Python scripting, network data retrieval, and ethical reflection on a unified theme: a school library inventory system.
用一个模拟 SQA 高分值题型的多步骤练习将一切融会贯通。此题围绕“学校图书馆库存系统”这一统一主题，结合了数据库处理、Python 脚本编写、网络数据获取以及伦理反思。
The scenario: A school library keeps a MySQL database library. Books are stored in a table Books(ISBN, Title, Author, Genre). A separate table Loans(LoanID, ISBN, BorrowerID, DateOut, DateDue) tracks borrowings. A Python script runs daily to connect to an external API that provides current book popularity ratings and sends email reminders to borrowers with overdue books. The school also wants to publish anonymised loan statistics online to promote reading, raising privacy concerns.
情景：一个学校图书馆维护着 MySQL 数据库 library。图书存储在 Books(ISBN, Title, Author, Genre) 表中。另一个 Loans(LoanID, ISBN, BorrowerID, DateOut, DateDue) 表追踪借阅情况。一个 Python 脚本每天运行，连接到提供当前图书流行度评分的外部 API，并向持有逾期图书的借阅者发送电子邮件提醒。学校还希望在线发布匿名借阅统计数据以推广阅读，这引发了隐私方面的关切。
Tasks:
(a) Write an SQL query to list all overdue books, showing the title and borrower ID, where DateDue is before today’s date and no return date has been recorded.
(b) Describe, using pseudocode or Python, how you would connect to the books API, extract the rating for a given ISBN, and update a local field PopularityScore in the Books table.
(c) Identify two privacy risks if the school publishes a “top borrowers” list without proper safeguards, and suggest technical measures (e.g., data aggregation, differential privacy concepts) to mitigate them.
任务：
(a) 编写一条 SQL 查询，列出所有逾期图书，显示书名和借阅者 ID，条件是应还日期早于今天且未记录归还日期。
(b) 使用伪代码或 Python 描述如何连接到图书 API，提取给定 ISBN 的评分，并更新 Books 表中本地字段 PopularityScore。
(c) 指出如果学校在缺乏适当保护措施的情况下发布“最佳借阅者”名单可能造成的两项隐私风险，并提出技术措施（例如数据聚合、差分隐私概念）以降低风险。
Walkthrough: For (a), use a JOIN between Books and Loans, filter by DateDue < CURDATE() and DateReturned IS NULL. For (b), import requests and mysql.connector, send a GET request to the API endpoint, parse the JSON, and run an UPDATE query. For (c), explain that publishing exact borrowing counts could re‑identify individuals if combined with other data; suggest grouping data into broad ranges and avoiding disclosure of unique behaviour. This full‑spectrum exercise demonstrates the interdisciplinary synthesis required at Year 10 SQA level.
解析：(a) 在 Books 和 Loans 之间使用 JOIN，按 DateDue < CURDATE() 及 DateReturned IS NULL 过滤。(b) 导入 requests 与 mysql.connector，向 API 端点发送 GET 请求，解析 JSON，然后执行 UPDATE 查询。(c) 解释发布精确借阅计数若与其他数据结合可能导致个人被重新识别；建议将数据分组为宽泛范围并避免披露独特行为。这一全谱练习展示了 Year 10 SQA 层次所需的跨学科综合能力。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图