📚 Cross-Disciplinary Integrated Problem-Solving Training for CIE IGCSE Computer Science | CIE IGCSE 计算机科学跨学科综合题型训练
In the Cambridge IGCSE Computer Science (0478) syllabus, learners are not only expected to master computing concepts in isolation but also to apply them across various disciplines. This integrated approach reflects real-world scenarios where computer science intersects with mathematics, physics, biology, business, and geography. The ability to recognise these connections deepens understanding and prepares students for both examinations and future studies. This article presents a series of cross-disciplinary problems designed to challenge Year 10 learners, reinforcing core topics such as data representation, algorithms, logic circuits, networking, and programming, while seamlessly blending knowledge from other subjects.
在剑桥 IGCSE 计算机科学（0478）课程中，学生不仅需要孤立地掌握计算概念，还要能够跨学科应用这些知识。这种综合性方法反映了现实世界中计算机科学与数学、物理、生物、商业和地理等学科相互交织的情况。识别这些联系的能力能加深理解，并使学生在考试和未来的学习中做好准备。本文提供了一系列跨学科问题，旨在挑战十年级学生，巩固数据表示、算法、逻辑电路、网络和编程等核心主题，同时无缝融合其他学科知识。
1. Binary Arithmetic and Mathematical Modelling | 二进制算术与数学建模
Binary numbers form the foundation of all digital systems. In mathematical modelling, we often need to convert continuous data into discrete binary forms. Consider a simple weather model that stores temperature as an 8-bit unsigned integer, where 0 represents -20°C and 255 represents +35.5°C. Calculate the binary value that corresponds to a temperature of 10°C, and express the resolution (step size) of this digital thermometer.
二进制数是所有数字系统的基础。在数学建模中，我们通常需要将连续数据转换为离散的二进制形式。设想一个简单的天气模型，它将温度存储为8位无符号整数，其中0代表-20°C，255代表+35.5°C。请计算对应10°C的二进制值，并表达该数字温度计的分辨率（步长）。
- Temperature range = 35.5 - (-20) = 55.5°C. Step size = 55.5 / 255 ≈ 0.2176°C.
- lised value = 30 / 0.2176 ≈ 137.84, rounded to 138. Convert 138 to 8-bit binary: 10001010.
- 温度范围 = 35.5 - (-20) = 55.5°C。步长 = 55.5 / 255 ≈ 0.2176°C。
- 10°C 对应值：偏移 = 10 - (-20) = 30。归一化值 = 30 / 0.2176 ≈ 137.84，四舍五入为138。138转为8位二进制：10001010。
This problem integrates linear mapping, a common mathematical concept, with binary representation and precision limits. It demonstrates how computers approximate real-world continuous quantities using discrete bits.
这道题整合了数学中常见的线性映射概念，以及二进制表示和精度限制。它展示了计算机如何使用离散的比特来近似现实世界中的连续量。
2. Logic Gates and Physics Circuits | 逻辑门与物理电路
Logic gates are the building blocks of digital electronics, often taught alongside electricity in physics. A security alarm system uses two sensors: a door sensor (A) and a motion sensor (B). The alarm should trigger if the door is opened while the system is armed, or if motion is detected regardless of the door state. However, if a physical override switch (C) is pressed, the alarm must not sound. Express this logic using a Boolean equation, draw the circuit using AND/OR/NOT gates, and show how a transistor-based realisation of the AND gate can be built from two NPN transistors in series.
逻辑门是数字电子学的基本构件，在物理课中常与电学一同教授。一个安全警报系统使用两个传感器：门传感器（A）和运动传感器（B）。如果系统布防且门被打开，或者检测到运动（无论门状态如何），警报就会触发。但是，如果物理超控开关（C）被按下，警报绝对不能响。请用布尔方程表达此逻辑，用与门/或门/非门画出电路，并说明如何用两个串联的NPN晶体管构建一个晶体管级的与门。
- Boolean equation: Alarm = (A + B) AND NOT C, or Alarm = (A ∨ B) ∧ ¬C.
- Circuit: A and B inputs into an OR gate, output of OR and C through a NOT gate then into an AND gate. Final output drives the alarm.
- Transistor AND: two NPN transistors in series; both base inputs must be high for current to flow from collector to emitter.
- 布尔方程：警报 = (A + B) 与 非C，即 Alarm = (A ∨ B) ∧ ¬C。
- 电路：A和B输入到或门，或门输出与C经非门后的信号一起进入与门，最终输出驱动警报。
- 晶体管与门：两个NPN晶体管串联；两个基极输入必须都为高电平，电流才能从集电极流向发射极。
This question links computer logic with physical circuit design, reinforcing the understanding that digital systems are ultimately built from analogue components like transistors, which obey Kirchhoff's laws.
此问题将计算机逻辑与物理电路设计联系起来，强化了数字系统最终由模拟元件（如晶体管）构建且遵循基尔霍夫定律的理解。
3. Algorithms and Mathematical Sequences | 算法与数学数列
ones, appears in nature, art, and financial models. Write pseudocode to output the first N Fibonacci numbers using iteration. Then, analyse the time complexity in terms of Big O notation, and discuss how the golden ratio φ = (1+√5)/2 emerges from the ratio of consecutive terms. How could a computer use this ratio to approximate large Fibonacci numbers without computing all preceding terms?
算法通常用于高效生成数学数列。斐波那契数列（每一项是前两项之和）出现在自然、艺术和金融模型中。请编写伪代码，使用迭代输出前N个斐波那契数。然后，用大O符号分析时间复杂度，并讨论黄金比例 φ = (1+√5)/2 如何从连续项的比值中产生。计算机如何利用这一比例近似计算大的斐波那契数，而无需计算所有前项？
Pseudocode:
a ← 0, b ← 1
FOR i FROM 1 TO N
OUTPUT a
temp ← b
b ← a + b
a ← temp
ENDFOR
Time complexity is O(N) – linear. The closed-form Binet's formula uses φ: F(n) = (φⁿ - (-φ)⁻ⁿ) / √5. A computer can directly compute this for huge n using floating-point arithmetic, trading off some precision for speed.
时间复杂度为 O(N)——线性。闭式比内公式使用 φ：F(n) = (φⁿ - (-φ)⁻ⁿ) / √5。计算机可以用浮点运算直接计算巨大的n，用精度换取速度。
4. Data Storage and Scientific Measurement | 数据存储与科学测量
In science experiments, data loggers collect measurements and store them in binary. A pH sensor records values from pH 0 to 14 with a precision of 0.01. The data is stored as 16-bit unsigned integers, mapping the full range linearly. Calculate the actual pH value represented by the binary 0110010101001110, and determine how many days of continuous readings (one reading per second) can be stored on a 32 GB SD card, assuming no compression and ignoring metadata.
在科学实验中，数据记录器收集测量值并以二进制形式存储。一个pH传感器记录0到14的pH值，精度为0.01。数据以16位无符号整数存储，线性映射整个范围。请计算二进制数 0110010101001110 代表的实际pH值，并确定一张32 GB SD卡可以存储多少天的连续读数（每秒读数一次），假设没有压缩且忽略元数据。
- Range = 14 - 0 = 14. Total steps = 216 ≈ 0.0002136. Binary to decimal: 0110010101001110₂ = 25934. pH = 25934 × 0.0002136 ≈ 5.54.
- B = 32 × 10⁹ bytes (assuming 1 GB = 10⁹ for storage). Days = 32e9 / 172800 ≈ 185,185 days.
- 范围 = 14 - 0 = 14。总步数 = 216 - 1 = 65535。步长 = 14 / 65535 ≈ 0.0002136。二进制转十进制：0110010101001110₂ = 25934。pH = 25934 × 0.0002136 ≈ 5.54。
- 每次读取：16位 = 2字节。每天 = 86400秒 → 172,800字节。卡容量32 GB = 32 × 10⁹字节（存储设备通常1 GB=10⁹字节）。天数 = 32e9 / 172800 ≈ 185,185天。
This problem merges binary conversion, storage calculations, and experimental science, highlighting the interplay between digital resolution and physical measurement.
这道题融合了二进制转换、存储计算和实验科学，突显了数字分辨率与物理测量之间的相互作用。
5. Encryption and Cryptography in History | 加密与历史密码学
The Caesar cipher, a simple substitution cipher, is often studied in both computer science and history lessons about ancient Rome. Julius Caesar is said to have used a shift of 3 to protect military messages. Write an algorithm in pseudocode to decrypt a given ciphertext string by trying all 25 possible shifts (brute force). For the ciphertext 'WKLV LV VHFUHW', what is the plaintext? Extend the problem by explaining how frequency analysis (knowledge of letter frequencies in English) can speed up the attack, drawing on statistical techniques used in mathematics.
凯撒密码是一种简单的替换密码，常在计算机科学和历史课上关于古罗马的内容中学习。据说尤利乌斯·凯撒使用位移3来保护军事信息。请编写伪代码算法，通过尝试所有25种可能的位移（暴力破解）来解密给定的密文字符串。对于密文 'WKLV LV VHFUHW'，明文是什么？延伸问题：解释频率分析（利用英语中字母频率的知识）如何加速破解，这需要运用数学中的统计技术。
Pseudocode:
FOR shift FROM 1 TO 25
output shift, ":", decrypt(ciphertext, shift)
ENDFOR
decrypt(text, k):
result ← ""
FOR each character c in text
IF c is a letter THEN
newChar ← (c - 'A' - k) MOD 26 + 'A'
ELSE newChar ← c
result ← result + newChar
RETURN result
Decryption of 'WKLV LV VHFUHW' with shift 3 gives 'THIS IS SECRET'. For frequency analysis: in English, 'E' is most common. An attacker counts letter occurrences in ciphertext and matches the most frequent to 'E', deducing the shift. This combines programming with statistical inference and historical context.
密文 'WKLV LV VHFUHW' 使用位移3解密得到 'THIS IS SECRET'。对于频率分析：英语中字母 'E' 最常见。攻击者统计密文中字母出现频率，并将最高频字母匹配为 'E'，从而推断出位移量。这结合了编程、统计推断和历史背景。
6. Programming Data Analysis with Geography | 编程数据分析与地理
Climate datasets often come as CSV files containing city names, countries, and average monthly temperatures. A student is asked to write a Python program that reads such a file and calculates the average temperature across all cities in a given country. Then, the program should identify the city with the highest temperature in that country. This requires file handling, iteration, and conditional logic. How does this relate to geographical information systems (GIS), and why is data normalisation important before cross-country comparisons (e.g., adjusting for altitude, latitude)?
气候数据集通常以CSV文件形式提供，包含城市名称、国家和月平均气温。要求学生编写一个Python程序，读取这样的文件，并计算指定国家内所有城市的平均温度。然后，程序应找出该国中温度最高的城市。这需要文件处理、迭代和条件逻辑。这如何与地理信息系统（GIS）关联？为什么在跨国比较之前进行数据归一化很重要（例如，根据海拔、纬度进行调整）？
A simple Python segment: for row in reader: if row[country_index]==target: total+=float(row[temp_index]); count+=1. This activity mimics how GIS tools process vector data. Raw temperature data may be misleading because cities at higher altitudes are naturally cooler; normalisation (e.g., temperature anomaly relative to latitudinal average) is a geographical pre-processing step.
一段简单的Python代码：for row in reader: if row[country_index]==target: total+=float(row[temp_index]); count+=1。该活动模拟了GIS工具如何处理矢量数据。原始温度数据可能具有误导性，因为高海拔城市自然更冷；归一化（例如，相对于纬度平均值的温度距平）是地理预处理步骤。
7. Network Transmission and Physics of Signals | 网络传输与信号物理
ferred from London to New York, an undersea cable distance of about 5,600 km. Calculate the theoretical minimum transmission delay (latency) ignoring processing and queuing. Then, using a link bandwidth of 100 Mbps, compute the total transmission time. Discuss why the physical speed of light in the fibre medium imposes a lower bound on latency, a concept rooted in Einstein's relativity, and how this affects real-time applications like online gaming.
当数据通过光纤电缆发送时，信号以大约 2.0 × 10⁸ 米/秒的速度传播。一个大小为15兆比字节（1 MiB = 2²⁰ 字节）的文件需要从伦敦传输到纽约，海底电缆距离约为5,600公里。请计算忽略处理和排队的理论最小传输延迟（时延）。然后，使用链路带宽100 Mbps，计算总传输时间。讨论为什么光纤介质中的光速物理极限为时延设定了下限，这一概念植根于爱因斯坦的相对论，以及它如何影响在线游戏等实时应用。
- Propagation delay = distance / speed = 5,600,000 m / 2.0×10⁸ m/s = 0.028 s = 28 ms.
- 100,000,000 bps. Transmission time = 125,829,120 / 100,000,000 ≈ 1.258 s. Total ≈ 1.286 s.
- 传播延迟 = 距离 / 速度 = 5,600,000 m / 2.0×10⁸ m/s = 0.028 秒 = 28 毫秒。
- 文件大小 = 15 × 2²⁰ 字节 = 15 × 1,048,576 B = 15,728,640 字节 = 125,829,120 比特。带宽 100 Mbps = 100,000,000 bps。传输时间 = 125,829,120 / 100,000,000 ≈ 1.258 秒。总计约 1.286 秒。
This problem merges computer networks with physics (speed of light in media), demonstrating that even infinite bandwidth cannot eliminate propagation latency.
这个问题将计算机网络与物理（介质中的光速）融合，说明即使带宽无限大，也无法消除传播延迟。
8. Databases and Business Decision-Making | 数据库与商业决策
A retail company maintains a relational database with tables CUSTOMERS(CustID, Name, City, JoinDate) and ORDERS(OrderID, CustID, Product, Amount, Date). Write an SQL query to find the total amount spent by customers who joined after 1st January 2022, grouped by city. Explain how such a query helps the marketing department identify high-value regions for targeted advertising. Furthermore, relate the concept of database normalisation to reducing data redundancy and avoiding update anomalies in business systems.
一家零售公司维护着一个关系数据库，包含表 CUSTOMERS(CustID, Name, City, JoinDate) 和 ORDERS(OrderID, CustID, Product, Amount, Date)。请编写一条SQL查询，查找在2022年1月1日之后加入的客户按城市分组的总消费金额。解释此类查询如何帮助市场部门识别高价值区域以进行定向广告投放。此外，将数据库规范化的概念与减少数据冗余及避免业务系统中的更新异常联系起来。
SELECT c.City, SUM(o.Amount) AS TotalSpent
FROM CUSTOMERS c JOIN ORDERS o ON c.CustID = o.CustID
WHERE c.JoinDate > '2022-01-01'
GROUP BY c.City
ORDER BY TotalSpent DESC;
This aggregates data to reveal business insights. Normalisation, up to 3NF, splits tables to ensure each non-key attribute depends fully on the primary key, which is crucial in accounting to prevent inconsistent data across departments.
该查询聚合数据以揭示商业洞察。规范化达第三范式（3NF）通过拆分表格确保每个非键属性完全依赖于主键，这在会计中至关重要，可防止部门间数据不一致。
9. Artificial Neural Networks and Biology | 人工神经网络与生物学
and passing through an activation function (e.g., step function). In a biological neuron, dendrites receive signals, the soma processes them, and if a threshold is exceeded, an action potential travels down the axon. Given a perceptron with two inputs x₁, x₂, weights w₁ = 0.6, w₂ = 0.4, and bias b = -0.5, determine the output for input (1, 1) using a step function where output = 1 if sum ≥ 0, else 0. Draw the biological analogy, and discuss the limitations of a single perceptron in solving linearly inseparable problems like XOR, referencing the mathematical geometry of decision boundaries.
感知器是人工神经元的一种简单模型，它通过接收多个输入、应用权重、求和并经过激活函数（如阶跃函数）来模拟生物神经元。在生物神经元中，树突接收信号，细胞体处理信号，如果超过阈值，动作电位沿轴突传导。给定一个感知器，具有两个输入 x₂、x₂，权重 w₁ = 0.6，w₂ = 0.4，偏置 b = -0.5，使用阶跃函数（若总和 ≥ 0，则输出=1，否则为0），求输入(1, 1)时的输出。画出生物学类比，并讨论单个感知器在解决线性不可分问题（如异或XOR）时的局限性，引用决策边界的数学几何。
Sum = (0.6×1) + (0.4×1) + (-0.5) = 0.5. Since 0.5 ≥ 0, output = 1.
The biological parallel: inputs like dendrites, weights like synaptic strengths, bias like resting membrane potential, step function like threshold activation. XOR requires a non-linear decision boundary; a single perceptron can only create a straight line, so it cannot separate XOR points. Multi-layer networks (with hidden layers) overcome this. This ties computer science to neuroscience and linear algebra.
生物学对应：输入如树突，权重如突触强度，偏置如静息膜电位，阶跃函数如阈值激活。异或问题需要非线性决策边界；单个感知器只能创建一条直线，因此无法分离异或点。多层网络（具有隐藏层）克服了这一点。这将计算机科学与神经科学和线性代数联系起来。
10. Ethical Computing and Environmental Science | 计算伦理与环境科学
Data centres consume vast amounts of electricity, contributing to carbon emissions. A typical large data centre may use 100 MW of power. If the electricity comes from a coal-fired plant emitting 0.9 kg CO₂ per kWh, calculate the annual carbon footprint in metric tonnes. Discuss how computer scientists can mitigate this through algorithm efficiency improvements (e.g., reducing time complexity from O(2ⁿ) to O(n log n)), and how virtualisation and cloud computing reduce hardware waste. Tie this to environmental studies on climate change and the concept of sustainable computing, as emphasised in the Cambridge CIE syllabus's ethical considerations.
数据中心消耗大量电力，造成碳排放。一个典型的大型数据中心可能使用100兆瓦的电力。如果电力来自一座每千瓦时排放0.9千克二氧化碳的燃煤电厂，请计算其年碳足迹（以公吨为单位）。讨论计算机科学家如何通过改进算法效率（例如将时间复杂度从 O(2ⁿ) 降低到 O(n log n)）来减轻这一问题，以及虚拟化和云计算如何减少硬件浪费。将此与气候变化环境研究和可持续计算概念联系起来，正如剑桥CIE大纲的伦理考量部分所强调的那样。
- Wh = 876,000,000 kWh. CO₂ = 876,000,000 × 0.9 kg = 788,400,000 kg = 788,400 metric tonnes.
- 年能耗：100 MW × 24 小时 × 365 = 876,000 MWh = 876,000,000 kWh。CO₂ = 876,000,000 × 0.9 kg = 788,400,000 kg = 788,400 公吨。
Efficient algorithms reduce CPU cycles, directly saving energy. Virtualisation allows multiple servers to run on a single physical machine, cutting idle power. These practices align with global sustainability goals.
高效的算法减少CPU周期，直接节省能源。虚拟化允许多台服务器在单台物理机上运行，削减空闲功耗。这些做法与全球可持续发展目标一致。
11. Conclusion | 结语
Cross-disciplinary problem-solving is at the heart of modern computing. By integrating computer science with mathematics, physics, biology, geography, business, and environmental ethics, learners not only prepare for exam questions that span multiple domains but also develop a holistic mindset essential for innovation. Each problem in this training set encourages students to think beyond the textbook, forging connections that mirror the collaborative nature of real-world technology. Practice these problems regularly, and you will see both your computing skills and your appreciation for other subjects grow hand in hand.
跨学科解决问题是现代计算的核心。通过将计算机科学与数学、物理、生物学、地理、商业和环境伦理相结合，学习者不仅能应对跨多个领域的考试题目，还能培养创新所必需的整体思维。本训练集中的每个问题都鼓励学生跳出课本思考，建立联系，反映现实世界技术的协作本质。定期练习这些问题，你会发现自己的计算机技能以及对其他学科的理解将携手并进。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图