📚 KS3 OCR Computing: Interdisciplinary Practice Questions | KS3 OCR 计算机：跨学科综合题型训练
Computing does not exist in a vacuum — it connects deeply with mathematics, science, geography, art, and even music. This revision set helps KS3 students approach OCR-style questions that bridge computing concepts with other subjects, building transferable problem-solving skills. Each section presents a scenario, then challenges you with questions that mirror the format of the OCR exam, blending computational thinking with real-world applications.
计算机并不是孤立存在的——它与数学、科学、地理、艺术甚至音乐都有着深厚的联系。这套复习资料旨在帮助KS3阶段的学生应对融合了计算机概念与其他学科的OCR风格题目，培养可迁移的解决问题的能力。每个部分都会给出一个场景，然后用与OCR考试相似的题目来挑战你，将计算思维与现实世界应用融为一体。
1. Binary and Data Representation in Science | 科学中的二进制与数据表示
A weather station records temperature every hour as an 8‑bit binary integer. The sensor can measure from -128°C to 127°C using two’s complement. On a cold night, the reading is 11100100. What is the temperature in decimal? Explain why two’s complement is used instead of sign‑and‑magnitude.
一个气象站每小时用8位二进制整数记录一次温度。传感器使用二进制补码，测量范围是-128°C到127°C。在一个寒冷的夜晚，读数为11100100。它表示的十进制温度是多少？解释为什么使用补码而不是原码。
Solution Tips: Flip the bits of 11100100 → 00011011, add 1 → 00011100 (28), so the value is -28°C. Two’s complement avoids a double zero and makes arithmetic simpler for the processor.
解题提示：将11100100的各位取反得00011011，加1得00011100（28），因此数值是-28°C。补码避免了正负零的问题，并使处理器的算术运算变得更简单。
2. Spreadsheet Modelling and Finance | 电子表格建模与财务
You design a pocket‑money planner in a spreadsheet. Cell B2 holds the weekly allowance, B3 the percentage saved, and B4 calculates the saved amount with =B2*B3/100. If you save 15% of £8.50, how much is set aside? Write a formula to find the total saved after 10 weeks, assuming the allowance stays the same. Name one advantage of using absolute cell referencing for the allowance.
你在电子表格中设计了一个零花钱计划表。单元格B2存放每周零花钱金额，B3存放储蓄百分比，B4用公式 =B2*B3/100 计算储蓄金额。如果你将8.50英镑的15%存起来，能存多少？写出计算10周后总储蓄额的公式（假设零花钱金额不变）。说出对零花钱单元格使用绝对引用的一个优点。
Solution Tips: £8.50 × 0.15 = £1.275, rounded to £1.28 if using currency format. For 10 weeks: =B4*10 or =B2*B3/100*10. Absolute reference (e.g. $B$2) keeps the allowance fixed when copying formulas down a column.
解题提示：8.50 × 0.15 = 1.275英镑，若使用货币格式通常显示为1.28英镑。10周总储蓄公式：=B4*10 或 =B2*B3/100*10。绝对引用（如 $B$2）可以在向下复制公式时保持零花钱金额不变。
3. Algorithms and Geographical Data | 算法与地理数据
A GPS app stores the distances (in km) between five landmarks in a list: [2.4, 5.1, 3.8, 7.0, 1.2]. Write pseudocode for a linear search that returns the index of the first distance greater than 4.0 km. What would a binary search require that a linear search does not?
一个GPS应用将五个地标之间的距离（公里）存储在一个列表中：[2.4, 5.1, 3.8, 7.0, 1.2]。编写一段伪代码，实现线性搜索并返回第一个大于4.0公里的距离的索引。二分搜索需要什么而线性搜索不需要？
Solution Tips: Iterate through the list, compare each element > 4.0, return index. Binary search requires the list to be sorted first; linear search works on unsorted data.
解题提示：遍历列表，比较每个元素是否大于4.0，返回索引。二分搜索要求列表必须先排序；线性搜索则可在未排序的数据上工作。
4. Logic Gates and Physical Systems | 逻辑门与物理系统
A factory uses two sensors: a pressure sensor (A = 1 if pressure is safe, else 0) and a temperature sensor (B = 1 if temperature is normal, else 0). An alarm sounds (output Q = 1) if the pressure is unsafe OR the temperature is abnormal. Draw the truth table and write the Boolean expression. Then redesign the circuit using only NAND gates.
一家工厂使用两个传感器：压力传感器（A=1表示压力安全，否则为0）和温度传感器（B=1表示温度正常，否则为0）。如果压力不安全或温度异常，警报器就会响起（输出Q=1）。画出真值表并写出布尔表达式。然后只用与非门重新设计该电路。
Solution Tips: The condition is Q = NOT A OR NOT B = ¬A ∨ ¬B (alarm when pressure unsafe OR temperature abnormal). Truth table: when A=0 or B=0, Q=1. Using De Morgan’s law: ¬A ∨ ¬B = ¬(A ∧ B). So a single NAND gate with inputs A and B gives the required output.
解题提示：条件是Q = 非A 或 非B = ¬A ∨ ¬B（压力不安全或温度异常时报警）。真值表：当A=0或B=0时，Q=1。根据德摩根定律：¬A ∨ ¬B = ¬(A ∧ B)。因此用一个与非门，输入A和B，即可得到所需输出。
5. Programming and Art: Turtle Graphics | 编程与艺术：海龟绘图
Using Python’s turtle module, you draw a regular pentagon. Each exterior angle is 72°. Write a loop that repeats the forward(100) and right(72) commands five times. Then modify the code so the pen colour changes to blue for the third side only. What sequence control structures are used here?
使用Python的turtle模块，你画了一个正五边形。每个外角是72°。编写一个循环，重复forward(100)和right(72)命令五次。然后修改代码，使画笔颜色只在画第三条边时变为蓝色。这里使用了什么顺序控制结构？
Solution Tips: The loop uses iteration (a for loop). To colour only the third side, you can use an if statement inside the loop: if count == 3: pencolor("blue"). This combines iteration and selection.
解题提示：循环使用了迭代（for 循环）。要仅给第三条边上色，可以在循环内使用 if 语句：if count == 3: pencolor("blue")。这里结合了迭代和选择结构。
6. Hexadecimal in Colour Representation | 十六进制在颜色表示中的应用
In web design, colours are represented by six‑digit hex codes (e.g. #FF5733). Explain how the hex number divides into red, green, and blue components. Convert the decimal RGB values (120, 200, 15) into a hex colour code. Why is hex often preferred over binary for representing colours?
在网页设计中，颜色用六位十六进制码表示（例如 #FF5733）。解释该十六进制数如何划分为红、绿、蓝三原色分量。将十进制RGB值（120, 200, 15）转换为十六进制颜色码。为什么表示颜色时十六进制比二进制更常用？
Solution Tips: The code is #RRGGBB. 120₁₀ = 78₁₆, 200₁₀ = C8₁₆, 15₁₀ = 0F₁₆ → #78C80F. Hex is shorter and more human‑readable than a 24‑bit binary string; it also aligns with byte boundaries (two hex digits = 8 bits).
解题提示：代码格式为#RRGGBB。120₁₀ = 78₁₆，200₁₀ = C8₁₆，15₁₀ = 0F₁₆ → #78C80F。十六进制比24位二进制串更短、更易读；而且它与字节边界对齐（两个十六进制位 = 8位）。
7. Computational Thinking in Music | 计算思维与音乐
A sequencer app plays a melody stored as a list of note numbers: [60, 62, 64, 65, 67, 65, 64, 62]. Each number represents a MIDI pitch. Identify the pattern (decomposition) and write an algorithm to generate the first 16 notes of a major scale starting from 60, where the step pattern is: whole, whole, half, whole, whole, whole, half. (Half step = 1, whole step = 2 in MIDI).
一个音序器应用将一段旋律存储为音符编号列表：[60, 62, 64, 65, 67, 65, 64, 62]。每个数字代表一个MIDI音高。识别其中的模式（分解），并编写一个算法，生成从60开始的大调音阶的前16个音符，其步进模式为：全音、全音、半音、全音、全音、全音、半音（在MIDI中，半音=1，全音=2）。
Solution Tips: The pattern is a sequence that rises then falls symmetrically. For the scale algorithm: start with note = 60, then for each step in [2,2,1,2,2,2,1], add the step to the current note and output it. Repeat for two octaves (16 notes).
解题提示：模式是先上升后下降的对称序列。音阶算法：从note=60开始，对步进列表[2,2,1,2,2,2,1]中的每一步，将步进值加到当前音符上并输出。重复两次产生两个八度（16个音符）。
8. Networks and Environmental Science | 网络与环境科学
A team of climate scientists needs to transfer a 200 MB dataset from Antarctica to London. The satellite link has a bandwidth of 4 Mbps. Calculate the minimum transfer time in seconds (ignore overheads). Why might the effective time be longer? Suggest two ways the data size could be reduced before transmission.
一个气候科学家团队需要将200 MB的数据集从南极洲传输到伦敦。卫星链路的带宽为4 Mbps。计算最短传输时间（秒，忽略开销）。为什么实际时间可能更长？提出两种在传输前减小数据量的方法。
Solution Tips: 200 MB = 200 × 8 = 1600 Mb. Time = 1600 ÷ 4 = 400 seconds. Effective time is longer due to protocols overhead, latency, and possible retransmissions. Data size can be reduced by file compression and by only sending essential measurements (lossy or lossless).
解题提示：200 MB = 200 × 8 = 1600 Mb。时间 = 1600 ÷ 4 = 400秒。实际时间更长是因为协议开销、延迟以及可能的重传。可以通过文件压缩和只发送必要的测量数据（有损或无损）来减小数据量。
9. Boolean Logic in Game Design | 游戏设计中的布尔逻辑
In a platform game, a player can jump if (button A pressed) AND (player is on the ground) AND (player has energy > 0). Write this as a Boolean expression with variables J, G, E. Expand the truth table for all conditions. If the ‘jump’ action also requires that the character is not carrying a heavy object (H), how does the expression change?
在一个平台游戏中，如果（按下A键）且（玩家在地面上）且（玩家能量 > 0），玩家就可以跳跃。用变量J、G、E写出布尔表达式。列出反映所有情况的真值表。如果“跳跃”动作还要求角色没有携带重物（H），表达式会如何改变？
Solution Tips: Expression: Jump = J AND G AND E. Truth table: 8 rows, only J=1, G=1, E=1 gives output 1. With heavy object: Jump = J AND G AND E AND NOT H.
解题提示：表达式：Jump = J AND G AND E。真值表：8行，只有J=1、G=1、E=1时输出为1。加上重物条件：Jump = J AND G AND E AND NOT H。
10. Flowcharts and Biology: Photosynthesis Model | 流程图与生物：光合作用模型
Light sensor readings (lux) are recorded every minute in a greenhouse. Draw a flowchart for a system that checks if light < 500 lux for more than 30 minutes. If true, the system turns on an artificial lamp; otherwise the lamp stays off. Your diagram must include a decision, a process, and a loop.
温室中每分钟记录一次光传感器读数（勒克斯）。为一个系统绘制流程图，该系统检查光照是否在30分钟以上持续低于500勒克斯。如果是，系统开启人工光源；否则保持关闭。你的图中必须包含判定、处理和一个循环。
Solution Tips: The flowchart starts with a counter set to 0. Inside a loop: read sensor; if lux < 500, increment counter, else reset counter to 0. Then check if counter > 30: yes → turn lamp on; no → loop back. Use standard symbols: oval for start/end, parallelogram for input/output, diamond for decision, rectangle for process.
解题提示：流程图开始时将计数器设为0。在循环内：读取传感器；如果lux < 500，计数器加1，否则计数器重置为0。然后检查计数器是否大于30：是 → 开灯；否 → 返回循环。使用标准符号：椭圆形表示开始/结束，平行四边形表示输入/输出，菱形表示判断，矩形表示处理。
11. Cybersecurity and Historical Codebreaking | 网络安全与历史密码破译
During World War II, the Lorenz cipher used a binary XOR operation with a keystream. If the plaintext letter ‘A’ (binary 01000001) is XORed with a key byte 11001010, what is the ciphertext? Show your working. Explain why XOR is reversible and discuss one modern application of XOR encryption.
在二战期间，洛伦兹密码使用二进制异或操作与密钥流进行加密。如果明文字母“A”（二进制 01000001）与密钥字节 11001010 进行异或运算，得到的密文是什么？展示你的计算过程。解释为什么异或运算是可逆的，并讨论XOR加密的一个现代应用。
Solution Tips: 0⊕1=1, 1⊕1=0, etc. So 01000001 XOR 11001010 = 10001011. XOR is reversible because (plaintext XOR key) XOR key = plaintext. Modern use: one‑time pads in secure communication; also used in some stream ciphers.
解题提示：0⊕1=1，1⊕1=0，等等。因此 01000001 XOR 11001010 = 10001011。XOR可逆是因为 (明文 XOR 密钥) XOR 密钥 = 明文。现代应用：安全通信中的一次性密码本；也用于一些流密码中。
12. Database Queries and School Timetabling | 数据库查询与学校课程表
A school database has a table LESSONS with fields: Day, Period, Subject, Teacher, Room. Write a SQL query to find all Science lessons on a Monday. Then write a query to count how many different teachers take Period 1. Explain what the DISTINCT keyword does and why it is needed.
一个学校数据库有一个名为 LESSONS 的表，字段包括：Day、Period、Subject、Teacher、Room。写一条SQL查询，找出星期一所有的科学课。再写一条查询，统计有多少位不同的老师上第一节课。解释 DISTINCT 关键字的作用以及为什么需要它。
Solution Tips: Query 1: SELECT * FROM LESSONS WHERE Day = 'Monday' AND Subject = 'Science'; Query 2: SELECT COUNT(DISTINCT Teacher) FROM LESSONS WHERE Period = 1;. DISTINCT removes duplicate values so each teacher is counted once.
解题提示：查询1：SELECT * FROM LESSONS WHERE Day = 'Monday' AND Subject = 'Science'; 查询2：SELECT COUNT(DISTINCT Teacher) FROM LESSONS WHERE Period = 1;。DISTINCT 去除重复值，使每位老师只被计数一次。
Published by TutorHao | KS3 OCR Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导