KS3 CCEA Computer Science: Cross-curricular Integrated Question Practice | KS3 CCEA 计算机：跨学科综合题型训练

📚 KS3 CCEA Computer Science: Cross-curricular Integrated Question Practice | KS3 CCEA 计算机：跨学科综合题型训练

Computer science does not exist in a vacuum – it connects naturally with mathematics, science, geography, music, art and design, and many other subjects. At KS3, CCEA encourages pupils to see these links through integrated question practice that blends computational thinking with real-world scenarios. This article provides a structured set of cross-curricular challenges designed to build confidence in applying computing concepts while reinforcing knowledge from other disciplines.

计算机科学并非孤立存在——它与数学、科学、地理、音乐、艺术与设计等许多学科天然相连。在 KS3 阶段，CCEA 鼓励学生通过将计算思维与现实情境相结合的综合题型训练来认识这些联系。本文提供了一套结构化的跨学科挑战，旨在增强应用计算机概念的信心，同时巩固其他学科的知识。

---

1. Binary Encoding and Music | 二进制编码与音乐

Digital audio often uses integers to represent musical pitches. In the MIDI standard, each note is assigned a number from 0 to 127. Middle C is note 60. A piano piece may require you to transpose a melody up by one octave, which means adding 12 to each note number. For a given note number 75, represent it as an 8-bit binary number, then calculate the note one octave higher and give its binary representation. Explain why a single byte can hold all MIDI note values.

数字音频常使用整数表示音高。在 MIDI 标准中，每个音符被分配一个 0 到 127 的编号。中央 C 是 60 号。一首钢琴曲可能需要将旋律升高一个八度，这意味着每个音符编号加 12。对于给定的音符编号 75，用 8 位二进制表示它，然后计算高一个八度的音符并给出其二进制表示。解释为什么一个字节可以容纳所有 MIDI 音符值。

To solve, convert 75 to binary: 75 = 64 + 8 + 2 + 1 → 01001011 (8-bit). Adding 12 gives 87; 87 in binary is 64 + 16 + 4 + 2 + 1 → 01010111. MIDI values range from 0 to 127, and an 8-bit number ranges from 0 to 255, so one byte is sufficient. This exercise links binary number skills from computing with musical intervals.

求解：将 75 转换为二进制：75 = 64+8+2+1 → 01001011（8 位）。加 12 得到 87；87 的二进制是 64+16+4+2+1 → 01010111。MIDI 值范围在 0–127 之间，而 8 位二进制可表示 0–255，因此一个字节足够。该练习将计算机的二进制数字技能与音乐音程联系起来。

---

2. Algorithmic Thinking and Map Reading | 算法思维与地图阅读

Navigation apps compute the shortest path using algorithms. Imagine you are given a simplified map of a town with four landmarks connected by roads with distances in metres. Use an algorithm to find the quickest route from the school to the library. Can you describe your step-by-step procedure in pseudocode? What cross-curricular skills from geography are used when interpreting the map?

导航应用使用算法计算最短路径。假设你得到一张简化的小镇地图，四个地标由标注了距离（米）的道路连接。请使用一种算法找到从学校到图书馆的最快路线。你能用伪代码描述你的一步一步过程吗？在解读地图时用到了地理学科的哪些跨学科技能？

A possible approach is Dijkstra’s algorithm, but at KS3 a check of all routes might suffice. Pseudocode: 1. List all possible paths from school to library. 2. For each path, sum distances. 3. Select the path with the smallest total. Geography skills include using scale, direction, and symbols. This question reinforces logical sequencing and evaluation, core to computational thinking.

一种可行的方法是使用迪杰斯特拉算法，但在 KS3 层次检查所有路线即可。伪代码：1. 列出从学校到图书馆的所有可能路径。2. 对每条路径，求距离总和。3. 选择总距离最小的路径。地理技能包括使用比例尺、方向和符号。这个问题强化了逻辑排序与评估，这是计算思维的核心。

---

3. Data Representation in Science Experiments | 科学实验中的数据表示

During a physics experiment, a temperature sensor records values every second for a minute. The data is stored as a sequence of 8-bit numbers. If one reading is 23 °C, how is that stored in binary? The experiment also records negative temperatures; how can we store −5 °C using two’s complement? Why might a scientist choose to average readings before storage, and what impact does that have on file size?

在一次物理实验中，一个温度传感器每秒记录一次值，持续一分钟。数据存储为 8 位数字序列。如果某个读数是 23 °C，其二进制如何存储？实验也记录零下温度；如何使用二进制补码存储 −5 °C？为什么科学家可能选择在存储前对读数取平均值，这对文件大小有何影响？

23 in 8-bit binary is 00010111. For −5, using two’s complement: +5 is 00000101; invert to 11111010, add 1 → 11111011. Averaging reduces the number of data points, so file size shrinks. This integrates computing data types with scientific measurement and data handling, encouraging discussion about precision vs storage.

23 的 8 位二进制是 00010111。对于 −5，使用补码：+5 是 00000101，取反得 11111010，加 1 得 11111011。平均化减少了数据点数量，因此文件大小缩小。这融合了计算机数据类型与科学测量和数据处理，促使讨论精度与存储之间的权衡。

---

4. Spreadsheets and Financial Planning | 电子表格与财务规划

In Business Studies, pupils learn about budgeting. A spreadsheet can model a simple budget for a school event. Write a formula that calculates the total cost column as quantity × unit price, then a conditional formula that displays ‘Over Budget’ if total cost exceeds £200. How does absolute cell referencing help when copying formulas? This links to digital literacy and the ‘Using ICT’ strand of CCEA Computing.

在商业学习中，学生了解预算。电子表格可以为一个学校活动建立简单预算模型。写出一个公式，将总成本列计算为数量 × 单价，然后写出一个条件公式，如果总成本超过 £200 则显示“Over Budget”。绝对单元格引用在复制公式时有什么帮助？这关联到 CCEA 计算课程中的数字素养和“使用 ICT”领域。

Example formula: =B2*C2 for total; conditional: =IF(D2>200,”Over Budget”,”Within Budget”). Absolute referencing (e.g., $B$1) keeps a fixed cell reference when filling cells. It combines mathematical modelling with spreadsheet skills, showing how computers automate financial checks.

示例公式：总成本 =B2*C2；条件：=IF(D2>200,”Over Budget”,”Within Budget”)。绝对引用（如 $B$1）在填充单元格时保持引用固定。它结合了数学建模与电子表格技能，展示了计算机如何自动化财务检查。

---

5. Logic Gates and Simple Circuits in Design Technology | 逻辑门与设计技术中的简单电路

A design project uses an alarm that sounds when a door is open AND a motion sensor is triggered. Draw the logic gate diagram and write the truth table. Label the inputs and output clearly. How would the circuit change if we wanted the alarm to sound when EITHER sensor is activated? This merges Boolean logic from computing with practical electronics in DT.

一个设计项目使用报警器，当门打开且运动传感器被触发时发出声响。画出逻辑门图并写出真值表。清楚地标出输入和输出。如果我们希望任一传感器激活时报警器响，电路应如何改变？这融合了计算机中的布尔逻辑与设计技术中的实用电子学。

For AND: Inputs A (door open), B (motion); Output Q = A AND B. Truth table: 0,0→0; 0,1→0; 1,0→0; 1,1→1. For OR, use an OR gate: Q = A OR B; truth table gives alarm when any input is 1. Students see abstract gates translate into physical switches and buzzers.

对于与门：输入 A（门打开）、B（运动）；输出 Q=A AND B。真值表：0,0→0；0,1→0；1,0→0；1,1→1。换成或门后，Q=A OR B，真值表在任何输入为 1 时输出报警。学生看到抽象的门电路转化为物理开关和蜂鸣器。

---

6. Cryptography and History | 密码学与历史

Historical ciphers like the Caesar cipher were used to protect messages. Encode the word ‘SCHOOL’ with a shift of +3. Decode ‘VHFUHW’ using the same shift. Discuss why symmetric encryption was vulnerable in history, and how a simple algorithm might be broken by frequency analysis – a technique linked to statistics in mathematics.

历史上的密码如凯撒密码被用于保护信息。用偏移 +3 对单词 ‘SCHOOL’ 进行编码。用相同偏移解码 ‘VHFUHW’。讨论对称加密在历史上为何易受攻击，以及一个简单算法如何被频率分析破解——这一技术与数学中的统计学相关联。

Encoding: S→V, C→F, H→K, O→R, L→O: ‘VFKRRO’. Decoding ‘VHFUHW’ → ‘SECRET’. Frequency analysis counts letter occurrences; in English ‘E’ is most frequent. This interdisciplinary task connects computing encryption with historical context and statistical reasoning.

编码：S→V, C→F, H→K, O→R, L→O：’VFKRRO’。解码 ‘VHFUHW’→’SECRET’。频率分析统计字母出现频率；英语中 ‘E’ 最常见。这个跨学科任务将计算机加密与历史背景和统计推理联系起来。

---

7. Image Representation in Art and Media | 艺术与媒体中的图像表示

A digital art project involves creating a black-and-white icon using a grid of pixels. Each pixel is represented by one bit (0 for white, 1 for black). Given a 5×5 grid, work out the binary run-length encoding for a simple shape. How does colour depth affect file size? What art principle is used when dithering creates the illusion of shade with only two colours?

一个数字艺术项目用一个像素网格创建黑白图标。每个像素用一位表示（0 表示白，1 表示黑）。给定一个 5×5 网格，为一个简单形状计算二进制游程编码。色彩深度如何影响文件大小？当只用两种颜色通过抖动制造出阴影的错觉时，用到了哪种艺术原理？

For a grid with a horizontal line of black pixels across the middle row: run-length for each row might be: white 5, white 2 black 1 white 2, white 5… (depending on shape). Higher colour depth means more bits per pixel, increasing file size. Dithering uses optical mixing, an art concept. This blends bitmap representation with visual arts terminology.

对于中间一行是黑色像素的网格：每行游程可能是：白 5，白 2 黑 1 白 2，白 5……（取决于形状）。更高的色彩深度意味着每像素更多位，增加文件大小。抖动使用了光学混合，这是一个艺术概念。这融合了位图表示与视觉艺术术语。

---

8. Databases and Geography: World Cities | 数据库与地理：世界城市

Create a flat-file database table called ‘Cities’ with fields: CityName, Country, Population, AreaKm2. Write a query to find all cities with population greater than 5 million. Then add a calculated field for population density (Population / AreaKm2). How does this support a geography project on urbanisation? What does the query ‘SELECT CityName FROM Cities WHERE Country = “France” ORDER BY Population DESC’ do?

创建一个名为 ‘Cities’ 的平面文件数据库表，字段包括：CityName、Country、Population、AreaKm2。写出一个查询，找出所有人口大于 500 万的城市。然后添加一个计算字段求人口密度（Population/AreaKm2）。这如何支持关于城市化的地理项目？查询 ‘SELECT CityName FROM Cities WHERE Country = “France” ORDER BY Population DESC’ 会做什么？

The query uses a condition to filter records. A density field helps analyse data for megacities. The SQL query lists French cities starting with the most populous. This task links database querying with geographical data analysis, showing how ICT supports fieldwork.

该查询使用条件筛选记录。密度字段有助于分析大城市的数据。SQL 查询按人口从大到小列出法国城市。该任务将数据库查询与地理数据分析联系起来，展示 ICT 如何支持实地考察。

---

9. Python Turtle and Mathematics of Shapes | Python 海龟绘图与形状数学

Use a Python turtle program to draw a regular polygon with 6 sides. The exterior angle of a regular hexagon is 60°. Write the code that repeats the move-and-turn sequence 6 times. How does the program demonstrate the mathematical concept of interior and exterior angles? Extend the code to draw a tessellating pattern of hexagons.

使用 Python 海龟程序绘制一个 6 条边的正多边形。正六边形的外角是 60°。写出重复移动和旋转的序列 6 次的代码。该程序如何展示内角和外角的数学概念？扩展代码以绘制六边形的镶嵌图案。

Code: for i in range(6): t.forward(100); t.right(60). Each turn corresponds to the exterior angle. Interior angle = 180 – exterior = 120°. Tessellation requires moving to new starting points. This computational geometry exercise reinforces angle theorems and algorithmic loops.

代码：for i in range(6): t.forward(100); t.right(60)。每次旋转对应外角。内角=180−外角=120°。镶嵌需要移动到新的起点。这个计算几何练习强化了角度定理和算法循环。

---

10. Networking and Collaborative Science Research | 网络与协作式科学研究

Scientists share research data over the internet. A school network uses a client-server model. Explain the roles of a server and a client in this context. How does a Domain Name System (DNS) help a researcher reach a university database? What is the difference between the World Wide Web and the internet? This integrates networking concepts with applications in science and e-safety.

科学家通过互联网共享研究数据。学校网络使用客户端-服务器模型。解释在这样的背景下服务器和客户端的角色。域名系统（DNS）如何帮助研究者访问大学数据库？万维网和互联网有什么区别？这融合了网络概念与科学应用和电子安全。

A server stores and shares resources; a client requests them. DNS translates a human-friendly address (e.g., science.university.edu) into an IP address. The internet is the physical network of cables and routers; the Web is a collection of web pages accessed via HTTP. Understanding these helps use online scientific repositories responsibly.

服务器存储并共享资源；客户端请求它们。DNS 将人类友好的地址（如 science.university.edu）翻译成 IP 地址。互联网是由线缆和路由器组成的物理网络；万维网是通过 HTTP 访问的网页集合。理解这些有助于负责任地使用在线科学资料库。

---

Published by TutorHao | Computer Science Revision Series | aleveler.com

更多咨询请联系16621398022（同微信）