📚 Cross-Curricular Problem-Solving in Computing | 计算机跨学科综合题型训练
Computing is no longer a standalone subject. In the OCR Year 9 curriculum, students are expected to apply computational thinking to real-world problems that span multiple disciplines. This article explores how topics like algorithms, binary, logic, and data representation intersect with mathematics, science, geography, design, and even music, providing a rich set of cross-curricular question types that sharpen both subject knowledge and problem-solving skills.
计算机不再是一门孤立的学科。在 OCR 九年级课程中,学生需要将计算思维应用于跨学科的现实问题。本文将探讨算法、二进制、逻辑、数据表示等主题如何与数学、科学、地理、设计甚至音乐交融,提供丰富的跨学科题型,以同步强化学科知识与解决问题的能力。
1. Mathematics and Computational Thinking | 数学与计算思维
Binary arithmetic forms the backbone of computing. A typical cross-curricular question might ask: "Convert the decimal number 153 into an 8‑bit binary number. Then, using binary addition, add 25 to your result and state the final binary outcome." This blends place value from mathematics with hardware-level thinking.
二进制算术是计算的基础。一个典型的跨学科题目可能要求:“将十进制数 153 转换为 8 位二进制数,然后使用二进制加法将 25 加到结果中,并给出最终的二进制结果。” 这结合了数学中的位值和硬件级思维。
Students also encounter hexadecimal representations. For instance, a colour code #FF8300 can be split into red (FF), green (83), and blue (00). In binary, this becomes 11111111 10000011 00000000. Such tasks reinforce multiplication, exponentiation, and division while exploring how screens produce colour.
学生还会接触十六进制表示。例如,颜色代码 #FF8300 可拆分为红 (FF)、绿 (83)、蓝 (00),转换为二进制即为 11111111 10000011 00000000。这类任务在探索屏幕如何呈现色彩的同时,巩固了数学中的乘法、指数和除法。
Example problem: If a pixel's alpha channel is 50%, express this as a hexadecimal value between 00 and FF. (50% of 255 = 127.5, rounded to 128, which is 80 in hex.)
例题:若某像素的透明度为 50%,用 00 到 FF 之间的十六进制数表示。(255 的 50% = 127.5,四舍五入为 128,即十六进制的 80。)
2. Sequencing, Patterns, and Algebra | 序列、模式与代数
5 and multiplies by 2 repeatedly can be expressed as a function. Students might be asked: "Write a formula for the value y after x iterations of this loop, starting from 1." This reveals the geometric progression y = 1 × 2ˣ + 5(2ˣ − 1).
流程图分析常演变为代数推理。一个重复地加 5 并乘以 2 的循环可表达为一个函数。学生可能被要求:“写出从 1 开始、经过 x 次迭代后的值 y 的公式。” 这揭示了等比数列 y = 1 × 2ˣ + 5(2ˣ − 1)。
nd implement it in pseudocode. This encourages generalisation, a key skill in programming.
模式识别是计算和代数的核心。给定序列 2、6、14、30,学生必须找出规则(×2 + 2)并用伪代码实现。这鼓励了泛化能力,是编程中的关键技能。
Question: Design an algorithm that outputs the nth term of the sequence 3, 7, 15, 31... without recursion.
题目:设计一个算法,输出序列 3、7、15、31… 的第 n 项,不使用递归。
3. Scientific Simulations and Modelling | 科学模拟与建模
Biology, chemistry, and physics provide rich scenarios for computational modelling. A predator‑prey simulation can be built using iteration and conditional statements. Students might create a simple spreadsheet or Python programme that updates rabbit and fox populations each generation based on birth rate and predation.
生物、化学和物理为计算建模提供了丰富的场景。捕食者‑猎物模拟可利用迭代和条件语句构建。学生可创建一个简单的电子表格或 Python 程序,根据出生率和捕食作用,逐代更新兔子和狐狸的数量。
, a program can verify that the number of atoms on each side is equal by parsing a string and counting element occurrences. This links to string manipulation and logic.
在化学中,可通过数据验证检查方程式是否配平。例如,给定 NaOH + HCl → NaCl + H₂O,程序可通过解析字符串并统计元素出现次数,来验证两边原子数目是否相等。这涉及字符串操作和逻辑判断。
Cross‑ e cooling of a cup of tea from 90 °C to room temperature (20 °C), with a cooling rate of 5% te until the difference is less than 1 °C. (Mathematical formula: Tₙ = 20 + (70 × 0.95ⁿ).)
跨学科任务:使用循环模拟一杯茶从 90 °C 冷却至室温 20 °C,冷却速率为每分钟 5%。打印每分钟的温度,直到温差小于 1 °C。(数学公式:Tₙ = 20 + (70 × 0.95ⁿ)。)
4. Geography and Data Handling | 地理与数据处理
GIS (Geographic Information Systems) rely heavily on computational techniques. Students can be tasked with analysing a CSV file of earthquake magnitudes and locations to find patterns. An algorithm might calculate the average magnitude or identify the nearest city to each epicentre using longitude and latitude differences.
地理信息系统 (GIS) 严重依赖计算技术。学生可被要求分析包含地震震级和位置的 CSV 文件以寻找模式。算法可计算平均震级,或利用经纬度差值确定每个震中最近的城市。
Binary search trees can be used to organise population data. For instance, constructing a BST from city populations allows quick look‑ups of whether a city’s population exceeds a given threshold, reinforcing search algorithms alongside geographical knowledge.
二叉搜索树可用于组织人口数据。例如,从城市人口数据构建 BST,可快速查找某城市人口是否超过给定阈值,在巩固搜索算法的同时联系地理知识。
versine formula: a = sin²(Δlat/2) + cos(lat1)×cos(lat2)×sin²(Δlon/2), distance = 2R×atan2(√a, √1−a). (R = 6371 km.)
题目:给定两地坐标 (lat1, lon1) 和 (lat2, lon2),编写伪代码,使用 Haversine 公式计算距离:a = sin²(Δlat/2) + cos(lat1)×cos(lat2)×sin²(Δlon/2),distance = 2R×atan2(√a, √1−a)。(R = 6371 km。)
5. Music and Audio Encoding | 音乐与音频编码
Sound waves are sampled and stored as binary sequences. A typical exam question might ask: "A music track lasts 3 minutes, sampled at 44.1 kHz with 16‑bit depth in stereo. Calculate the file size in megabytes." The calculation: 3×60×44100×16×2 = 253,344,000 bits, which is about 30.2 MB.
数字音频将计算与音乐理论联系起来。声波被采样并以二进制序列存储。一个典型的考题可能是:“一首音乐时长 3 分钟,以 44.1 kHz 采样率、16 位深度立体声录制。计算文件大小(MB)。” 计算过程:3×60×44100×16×2 = 253,344,000 比特,大约 30.2 MB。
MIDI (Musical Instrument Digital Interface) represents notes as numbers. Students could decode a MIDI message: "Note on, channel 0, note 60, velocity 100." This links frequency to musical pitch. The note number 60 corresponds to Middle C (261.63 Hz), reinforcing data representation alongside music literacy.
MIDI(乐器数字接口)将音符表示为数字。学生可解码 MIDI 消息:“音符开,通道 0,音符 60,力度 100。” 这关联了频率与音高。音符编号 60 对应中央 C (261.63 Hz),在强化数据表示的同时联系音乐素养。
Task: Write an algorithm that plays an ascending scale (notes 60, 62, 64, 65, 67, 69, 71, 72) with increasing velocity by 10 each note, starting at 50. This combines iteration, arrays, and understanding of MIDI values.
任务:编写算法,播放上行音阶(音符 60, 62, 64, 65, 67, 69, 71, 72),每个音符力度增加 10,起始力度为 50。这结合了迭代、数组和 MIDI 值的理解。
6. Design, Technology, and CAD | 设计、技术与计算机辅助设计
Computer‑aided design (CAD) uses vector graphics, which are inherently mathematical. A question might provide a list of coordinates forming a 2D shape: (0,0), (50,0), (50,20), (20,40), (0,20). Students must write an algorithm to scale the shape by a factor of 2 and translate it by (10,15), applying matrix‑like transformations in pseudocode.
计算机辅助设计 (CAD) 使用矢量图形,其本质是数学的。一道题目可能给出构成二维形状的坐标列表:(0,0)、(50,0)、(50,20)、(20,40)、(0,20)。学生需编写算法,将形状放大 2 倍并平移 (10,15),在伪代码中应用类似矩阵的变换。
3D printing designs require understanding of layers and slicing. In computing terms, slicing can be simulated by iterating through an STL file's vertices, checking which z‑heights intersect, and creating contours. This connects to loops, conditionals, and file handling.
3D 打印设计需要理解层与切片。在计算术语中,可通过遍历 STL 文件的顶点、检查与哪些 z 高度相交并创建轮廓来模拟切片。这涉及循环、条件判断和文件处理。
10), (0,10), apply a 45° rotation around the origin. Calculate the new coordinates using x' = x·cosθ − y·sinθ, y' = x·sinθ + y·cosθ. (cos45° = sin45° = √2/2 ≈ 0.707.)
题目:给定正方形顶点 (0,0)、(10,0)、(10,10)、(0,10),绕原点旋转 45°。使用公式 x' = x·cosθ − y·sinθ, y' = x·sinθ + y·cosθ 计算新坐标。(cos45° = sin45° = √2/2 ≈ 0.707。)
7. Art and Computer Graphics | 艺术与计算机图形学
Digital art creation involves pixel manipulation and colour theory. In cross‑ 26×R + 0.7152×G + 0.0722×B. This requires arithmetic operations and loops over a 2D array.
数字艺术创作涉及像素操作和色彩理论。在跨学科任务中,学生可编写函数,使用亮度法将 RGB 图像转换为灰度:灰度 = 0.2126×R + 0.7152×G + 0.0722×B。这需要对二维数组进行算术运算和循环。
Fractals like the Sierpiński triangle beautifully combine recursion and art. An algorithm that takes an equilateral triangle and repeatedly draws smaller triangles at each vertex illustrates recursion elegantly. Students refine their understanding of base cases and self‑similarity.
像谢尔宾斯基三角形这样的分形完美地结合了递归与艺术。算法取一个等边三角形,并在各顶点反复绘制更小的三角形,优雅地展示了递归。学生可深化对基准条件和自相似性的理解。
binary representation: black=0, white=1, then the first row is pattern 01010101 in binary.
活动:编写伪代码,使用嵌套循环绘制 8×8 方格棋盘图案,黑白交替。可与二进制表示联系:黑=0, 白=1,那么第一行图案即为二进制 01010101。
8. Language, Encryption, and History | 语言、加密与历史
Cryptography bridges computing and both history and linguistics. The Caesar cipher, used by Julius Caesar, shifts letters by a fixed amount. A task might ask students to write a program that brute‑force decrypts a ciphertext by trying all 25 possible shifts and looking for English words using a dictionary stored in an array.
密码学连接了计算与历史和语言学。凯撒密码曾被尤利乌斯·凯撒使用,将字母按固定值移位。一道任务可能要求学生编写程序,通过尝试全部 25 种移位,并利用存储在数组中的词典查找英语单词,来暴力破解密文。
The Enigma machine from World War II introduces rotor substitution and plugboard connections. Simplified for Year 9, a problem might involve multiple substitution layers: first a Caesar shift of +5, then a reversal of the alphabet (A↔Z, B↔Y, etc.), then another shift of +3. Such layered encryption highlights computational modularity.
二战中的恩尼格玛密码机引入了转子替换和插线板连接。为九年级简化后,一个问题可能涉及多层替换:首先凯撒移位 +5,然后字母表反转(A↔Z, B↔Y 等),再移位 +3。这种分层加密突出了计算模块化。
Challenge: Using a pre‑defined list of the 100 most common English words, write an algorithm that takes a ciphertext, tries all shift values (1–25), and returns the shift that yields the most dictionary matches. This combines iteration, string methods, and logic.
挑战:使用预定义的 100 个最常见英语单词列表,编写一个算法,接收密文,尝试所有移位值(1–25),并返回产生最多词典匹配的移位值。这结合了迭代、字符串方法和逻辑判断。
9. Physical Education and Sports Analytics | 体育与运动数据分析
Wearable technology in sport generates vast datasets. A cross‑curricular project could involve analysing a runner's lap times: [75, 72, 78, 69, 74] (seconds). The algorithm must identify the fastest lap, calculate the average, and determine if the runner achieved a negative split (second half faster than the first). This uses arrays, loops, and comparison operators.
运动领域的可穿戴技术产生海量数据集。一个跨学科项目可能涉及分析跑步者的圈速:[75, 72, 78, 69, 74](秒)。算法需识别最快圈速,计算平均值,并判断运动员是否实现了负分段(后半程比前半程快)。这涉及数组、循环和比较运算符。
he ball at (x,y), they increment the corresponding cell. This introduces 2D array accumulation and basic data visualisation concepts.
在团体运动中,位置数据可用于创建热图。学生可将足球场表示为 100×70 的网格。对于每次触球位置 (x,y),相应单元格数值加 1。这引入了二维数组累加和基本的数据可视化概念。
Problem: Given an array of shot velocities (in km/h): [82, 95, 78, 102, 88, 91], write a program to find and output those exceeding 90 km/h and their indices, using a linear search.
题目:给定射门速度数组(单位 km/h):[82, 95, 78, 102, 88, 91],编写程序,使用线性搜索找出并输出超过 90 km/h 的数值及其下标。
10. Combined Challenge: Integrated Problem Sets | 综合挑战:融合题型
The OCR exam often presents a scenario where multiple disciplines blend. For example, an ecologist tracking bee populations uses an RFID reader that records each bee’s ID and timestamp. The data logs might need to be sorted, filtered for activity during daylight hours, and correlated with temperature readings from a separate sensor. Students must design a solution that incorporates:
OCR 考试常呈现多学科融合的场景。例如,一位生态学家使用 RFID 读取器追踪蜜蜂种群,记录每只蜜蜂的 ID 和时间戳。数据日志需要排序,筛选出日照时段的活动,并与来自另一传感器的温度读数进行关联分析。学生必须设计一个包含以下内容的解决方案:
A sorting algorithm (bubble or merge) to order logs by time.
排序算法(冒泡或归并)以按时间排序日志。
File reading of CSV data from both the bee monitor and a weather station.
从蜜蜂监测器和气象站读取 CSV 文件。
Use of linear search to find all readings between certain times (e.g., 06:00‑20:00).
使用线性搜索查找特定时间段(如 06:00‑20:00)内的所有记录。
Calculation of the mean temperature during active periods using running totals.
使用滚动总和计算活动时段的平均温度。
A final report generated as a formatted text file or on‑screen display.
最终报告生成为格式化文本文件或屏幕显示。
Such integrated tasks test computational thinking holistically and mirror real‑world interdisciplinary work. They require students to decompose problems, abstract relevant details, and think algorithmically while drawing on knowledge from biology and environmental science.
此类综合任务全面考察计算思维,并反映现实世界的跨学科工作要求。它们要求学生分解问题、提取相关细节并进行算法化思考,同时运用生物学和环境科学的知识。
11. Logical Reasoning and Ethics | 逻辑推理与伦理学
. Boolean logic can be used to model ethical decisions. For example, an autonomous vehicle's decision‑making might be represented as: IF (pedestrian_crossing = True) AND (visibility > 50% an construct truth tables for such scenarios and discuss the implications of each outcome.
计算日益与哲学和公民教育中的伦理讨论相关联。布尔逻辑可用于建模伦理决策。例如,自动驾驶汽车的决策可表示为:IF (行人横穿 = True) AND (能见度 > 50%) THEN 刹车 ELSE 继续。学生可为此类场景构建真值表,并讨论每种结果的含义。
A cross‑curricular debate can be structured around data privacy: "Should schools use facial recognition for attendance?" g logical operators to structure their points (e.g., IF consent_is_valid AND accurate THEN benefit_outweighs_risk). This combines digital literacy with critical thinking.
可围绕数据隐私组织跨学科辩论:“学校应否使用人脸识别考勤?” 学生研究法律框架(GDPR),计算给定算法的错误率(假阳性/假阴性),并用逻辑运算符组织论点结构(例如,IF 同意有效 AND 准确 THEN 利大于弊)。这结合了数字素养与批判性思维。
se: Create a logic circuit with AND, OR, and NOT gates that represents the following rule: "A student can access the reward trip only if they have ≥95% attendance AND (have completed all homework OR obtained a teacher recommendation)." Draw the truth table.
练习:创建一个包含与、或、非门的逻辑电路,表示以下规则:“学生仅当出勤率 ≥95% 且(完成所有作业或获得教师推荐)时才能参加奖励旅行。” 绘制真值表。
12. Exam‑Style Cross‑Curricular Question Bank | 考试风格跨学科题库
To consolidate learning, here is a selection of mixed questions designed in the OCR style, each integrating another subject:
为巩固学习,以下是一套 OCR 风格的混合题,每题整合了另一学科:
| Question | Cross‑Curricular Link |
|---|---|
| 1. Convert the RGB value (128, 64, 32) to 8‑bit binary and hexadecimal. Which colour does it represent? | Art, Mathematics |
| 2. A robot moves according to the code: repeat 4 [forward(10) right(90)]. What shape does it draw, and what is the perimeter? | Geometry, Design |
| 3. The sound of a heartbeat lasts 0.8 s and is sampled at 8000 Hz with 8‑bit resolution. Estimate the file size in kilobits. | Biology, Physics |
| 4. Sort the following elements by atomic number using bubble sort: O (8), C (6), He (2), N (7). Show each pass. | Chemistry |
| 5. A Caesar cipher changes "HELLO" to "KHOOR". What is the shift? Decrypt "EBIIL" with the same shift. | History, Languages |
| 6. Given the geography data: London (51°N, 0°W) and New York (40°N, 74°W), write pseudocode to calculate the difference in longitude and check if they share the same hemisphere. | Geography |
Worked solutions for these questions encourage students to see computing as a thread that weaves through every other subject, reinforcing the idea that problem‑solving is a universal skill.
这些题目的详细解答鼓励学生将计算机视为贯穿每门学科的线索,强化解决问题是一种通用技能的理念。
Published by TutorHao | GCSE OCR Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022(同微信)

或截图后用「扫一扫 → 相册」选择本图