📚 Year 8 AQA Computing: Interdisciplinary Integrated Problem-Solving Practice | AQA Year 8 计算机：跨学科综合题型训练
In Year 8 Computing, you will often encounter problems that combine skills from other subjects such as Science, Mathematics, and Design Technology. These interdisciplinary challenges test your ability to apply computational thinking in real-world contexts. This revision guide will walk you through essential strategies and provide plenty of practice examples.
在 Year 8 计算机课程中，你经常会遇到结合科学、数学和设计技术等其他学科技能的问题。这些跨学科挑战考查你在真实情境中应用计算思维的能力。本复习指南将带你了解基本策略，并提供大量练习示例。
1. Understanding Interdisciplinary Problems | 理解跨学科问题
Interdisciplinary problems require you to transfer knowledge across subjects. For example, you might need to use a spreadsheet to analyse scientific data collected from a sensor.
跨学科问题要求你跨学科地迁移知识。例如，你可能需要用电子表格来分析从传感器收集的科学数据。
The key is to break down the task into computing skills (like writing a formula) and domain knowledge (like understanding what temperature means).
关键是将任务分解为计算机技能（如编写公式）和领域知识（如理解温度的含义）。
Always start by identifying the data, the process needed, and the expected output. This is the foundation of computational thinking.
始终从识别数据、所需过程和预期输出开始。这是计算思维的基础。
When reading a question, underline the computing terms (e.g. ‘algorithm’, ‘variable’, ‘condition’) and the subject-specific terms (e.g. ‘velocity’, ‘ecosystem’, ‘budget’).
审题时，在计算机术语（如“算法”、“变量”、“条件”）和学科特定术语（如“速度”、“生态系统”、“预算”）下面划线。
2. Binary and Data in Science | 二进制与科学中的数据
Many science experiments produce measurements that are stored as binary values in a computer. Understanding how to convert between denary and binary is essential.
许多科学实验会产生测量值，这些值以二进制形式存储在计算机中。理解十进制与二进制之间的转换至关重要。
An 8-bit register can represent integers from 0 to 255. For a temperature sensor reading of 25°C, the binary equivalent is 00011001₂.
一个 8 位寄存器可以表示 0 到 255 的整数。对于温度传感器读数 25°C，其二进制等价形式为 00011001₂。
| Denary (decimal) | Binary (8‑bit) | Sensor reading |
| 0 | 00000000₂ | 0°C |
| 25 | 00011001₂ | 25°C |
| 100 | 01100100₂ | 100°C |
When a science teacher stores light-level readings in an array, each element is a binary number. Sorting these readings requires comparing binary values.
当科学老师将光照强度读数存储在数组中时，每个元素都是一个二进制数。对这些读数进行排序需要比较二进制值。
Explain how the number 175 is represented in an 8-bit byte: 128 + 32 + 8 + 4 + 2 + 1 gives 10101111₂.
解释数字 175 如何用 8 位字节表示：128 + 32 + 8 + 4 + 2 + 1 得到 10101111₂。
Interdisciplinary question: A humidity sensor returns 10010011₂. What is the denary value? (Answer: 128 + 16 + 2 + 1 = 147).
跨学科问题：一个湿度传感器返回 10010011₂。十进制值是多少？（答案：128 + 16 + 2 + 1 = 147）。
3. Algorithms for Mathematical Investigations | 数学探究中的算法
Algorithms are step-by-step instructions. In mathematics, you often calculate the mean, median, or range of a data set. Those procedures can be expressed as algorithms.
算法是分步指令。在数学中，你经常要计算数据集的平均数、中位数或极差。这些过程可以表示为算法。
For example, an algorithm to find the average of a list of numbers:
例如，求一组数字平均值的算法：
Average = (x₁ + x₂ + … + xₙ) ÷ n
You can refine this into pseudocode:
你可以将其细化为伪代码：
SET total TO 0
FOR EACH number IN list
ADD number TO total
END FOR
SET average TO total / LENGTH(list)
This algorithm uses iteration and a variable. When linked to a science experiment, the list might contain temperature readings taken every minute.
这个算法使用了迭代和一个变量。当与科学实验关联时，列表可能包含每分钟记录的温度读数。
Another common task is finding outliers. You might write an algorithm that checks if any value is greater than the mean + 10. This requires a condition.
另一个常见任务是寻找异常值。你可以编写一个算法，检查是否有任何值大于平均值加 10。这需要使用一个条件。
Practice: Write an algorithm to determine the range (maximum – minimum) of light sensor values stored in a list.
练习：编写一个算法，确定存储在列表中的光传感器数值的极差（最大值减去最小值）。
4. Sensors and Data Logging | 传感器与数据记录
Interdisciplinary problems frequently involve collecting real‑world data using sensors. A typical micro:bit project might monitor soil moisture for a biology investigation.
跨学科问题经常涉及使用传感器收集真实世界的数据。一个典型的 micro:bit 项目可能为生物学研究监测土壤湿度。
The data logging process follows this cycle:
数据记录过程遵循以下循环：
-
Read the sensor (e.g. analog pin) and store the value.
读取传感器（例如模拟引脚）并存储数值。
-
Convert the analog reading to a meaningful unit using a calibration formula.
使用校准公式将模拟读数转换为有意义的单位。
-
Save data into memory, often as a list or array.
将数据保存到内存中，通常以列表或数组的形式。
-
Transmit or display the data (e.g. send to a spreadsheet).
传输或显示数据（例如发送到电子表格）。
In a geography‑computing crossover, you might log wind speed over a week. The algorithm must handle repeated readings and avoid memory overflow.
在地理与计算机的交叉项目中，你可能会记录一周内的风速。算法必须处理重复读数，并避免内存溢出。
Designing a data structure is also important. A dictionary (or map) can pair a timestamp with each reading, like {“time”:”09:00″, “temp”:18}.
设计数据结构也很重要。字典（或映射）可以将时间戳与每个读数配对，例如 {“time”:”09:00″, “temp”:18}。
Question: Explain why a conditional loop is better than a fixed loop when you do not know how many readings will be taken.
问题：解释当你不知道要进行多少次读数时，为什么条件循环比固定次数循环更好。
5. Spreadsheet Modelling for Real-World Scenarios | 电子表格建模现实场景
Spreadsheets are powerful tools for creating models in business studies, science, and design. A Year 8 task might ask you to simulate population growth of rabbits or calculate costs for a school event.
电子表格是在商业研究、科学和设计中创建模型的强大工具。Year 8 的任务可能要求你模拟兔子种群的增长或计算学校活动的成本。
Key spreadsheet functions you need to know:
你需要了解的关键电子表格函数：
| Function | Example | 跨学科用途 |
| SUM | =SUM(B2:B10) | 计算总花费/总测量值 |
| AVERAGE | =AVERAGE(C2:C10) | 科学实验平均值 |
| IF | =IF(D2>100, “High”, “Normal”) | 分类数据（如高/低风险） |
| COUNTIF | =COUNTIF(E2:E20, “>30”) | 统计超过阈值的次数 |
When modelling a phone contract cost, you can use cell references and formulas to compare plans. This links computing with financial literacy.
在模拟手机合约费用时，你可以使用单元格引用和公式来比较不同的套餐。这将计算机与金融素养联系起来。
Always check your model with test data. For instance, if the formula =A2*1.2 gives an unexpected result, debugging is a vital computing skill.
务必用测试数据检查你的模型。例如，如果公式 =A2*1.2 产生意外结果，调试就是一项至关重要的计算机技能。
6. Logic Gates in Control Systems | 控制系统中的逻辑门
In Design Technology and Physics, control systems often rely on logic gates. You may be asked to design a circuit or program that uses AND, OR, and NOT conditions.
在设计技术和物理中，控制系统通常依赖于逻辑门。你可能会被要求设计一个使用 AND、OR 和 NOT 条件的电路或程序。
Example: A greenhouse fan should turn on if the temperature is above 28°C AND the humidity is above 70%.
示例：如果温度高于 28°C 且湿度高于 70%，温室风扇应打开。
| Input A (Temp > 28) | Input B (Humidity > 70) | Output (Fan = ON) |
| 0 | 0 | 0 |
| 0 | 1 | 0 |
| 1 | 0 | 0 |
| 1 | 1 | 1 |
This is an AND gate. In a flowchart, you would represent it as a decision diamond with combined conditions.
这是一个 AND 门。在流程图中，你可以将其表示为一个带有组合条件的决策菱形框。
An OR gate might be used for a burglar alarm: trigger if a window contact is broken OR a motion sensor detects movement.
OR 门可用于防盗报警器：如果窗户触点断开或运动传感器检测到移动，则触发报警。
Understanding truth tables helps you test all possible scenarios before coding. This is part of thorough evaluation.
理解真值表有助于你在编码前测试所有可能的情景。这是全面评估的一部分。
7. Flowchart Design for Design Technology Projects | 设计技术项目中的流程图设计
Flowcharts bridge the gap between a design brief and a working program. When building a product like an automatic pet feeder, a clear flowchart ensures the logic is correct.
流程图弥合了设计简报与可运行程序之间的差距。在构建自动宠物喂食器等产品时，清晰的流程图可以确保逻辑正确。
Standard symbols include:
-
Rounded rectangle for Start/End.
圆角矩形表示开始/结束。
-
Rectangle for processes (e.g. ‘Dispense food’).
矩形表示处理过程（如“分配食物”）。
-
Diamond for decisions (e.g. ‘Is it mealtime?’).
菱形表示决策（如“是进餐时间吗？”）。
-
Parallelogram for input/output (e.g. ‘Read clock’).
平行四边形表示输入/输出（如“读取时钟”）。
When combining computing with Design Technology, your flowchart might control a stepper motor. You must consider timing, safety, and feedback loops.
当计算机与设计技术结合时，你的流程图可能控制步进电机。你必须考虑时序、安全和反馈循环。
A task could ask: ‘Draw a flowchart for a lighting system that switches on at dusk and off at dawn, with a manual override button.’ The solution requires OR logic and a continuous loop.
题目可能会要求：“为一个照明系统绘制流程图，该系统在黄昏时开启、黎明时关闭，并带有手动超控按钮。”解答需要 OR 逻辑和一个持续运行的循环。
Trace your flowchart with sample data to find logic errors before implementation.
在实现之前，用示例数据跟踪你的流程图，以找出逻辑错误。
8. Debugging and Evaluating Integrated Solutions | 调试与评估综合方案
Interdisciplinary projects rarely work perfectly on the first try. Debugging is finding and fixing errors, whether in code, wiring, or formulas.
跨学科项目很少在第一次尝试时就完美运行。调试就是查找并修复错误，无论是代码、接线还是公式中的错误。
Common errors include:
-
Syntax errors: misspelling a variable name.
语法错误：拼错变量名。
-
Logic errors: using ‘<' instead of '>‘ in a condition.
逻辑错误：在条件中使用了“<”而不是“>”。
-
Data errors: a sensor returning out‑of‑range values because of incorrect calibration.
数据错误：由于校准不正确，传感器返回超出范围的值。
Evaluation must answer: does the solution meet the original design criteria? For a science data logger, check accuracy, sampling rate, and battery life.
评估必须回答：解决方案是否满足最初的设计标准？对于科学数据记录器，需检查准确性、采样率和电池寿命。
Self‑evaluation prompts: ‘If I were to improve this, I would add a display screen to show live readings. That links back to usability criteria.’
自我评估提示：“如果我要改进它，我会添加一个显示屏来显示实时读数。这又回到了易用性标准。”
Testing with boundary values (e.g. temperature = 0, maximum, and one above maximum) ensures robustness.
使用边界值进行测试（例如温度 = 0、最大值以及超过最大值的一个值）可确保程序的健壮性。
9. Practice Questions: From Context to Code | 练习题：从情境到代码
These practice questions simulate the kind of interdisciplinary tasks you might meet in an AQA‑style assessment. Work through them step by step.
这些练习题目模拟了你可能在 AQA 风格评估中遇到的跨学科任务类型。请逐步完成。
Question 1 – Science & Data: A biology student measures the growth of a plant every day for 7 days and records the height in cm: 2, 3, 5, 6, 8, 10, 12. Write an algorithm in pseudocode that calculates and outputs the mean growth rate per day (assume growth is uniform between days).
问题 1 – 科学与数据： 一个生物专业的学生连续 7 天测量一株植物的生长情况，并记录了高度（厘米）：2, 3, 5, 6, 8, 10, 12。用伪代码编写一个算法，计算并输出平均每日生长速率（假设每天之间生长均匀）。
Hints: Total growth = final height – initial height. Divide by number of intervals (6).
提示：总生长量 = 最终高度 – 初始高度。除以间隔天数（6）。
Question 2 – Design & Flowcharts: A classroom door lock opens only when a correct PIN is entered AND it is between 8:00 and 16:00. Draw a flowchart that shows this process, including an ‘Access Denied’ output.
问题 2 – 设计与流程图： 一个教室门锁只有在输入正确的 PIN 码且时间在 8:00 到 16:00 之间时才会打开。绘制一个显示此过程的流程图，并包括“拒绝访问”的输出。
Question 3 – Spreadsheets & Budgeting: Create a spreadsheet model for a school charity bake sale. Column A lists items, Column B lists cost to make, Column C lists selling price. Write a formula for Column D that calculates profit. Then write a formula in E1 that counts how many items have a profit greater than £2.
问题 3 – 电子表格与预算： 为学校慈善烘焙义卖创建一个电子表格模型。A 列列出物品，B 列列出制作成本，C 列列出售价。为 D 列编写一个计算利润的公式。然后在 E1 中编写一个公式，计算利润大于 2 英镑的物品数量。
Answers should be clearly laid out and tested with your own sample data.
答案应清晰呈现，并用你自己的样本数据进行检验。
10. Reflecting on Connections | 反思联系
After solving an interdisciplinary problem, take a moment to reflect on what you have learned about both subjects. This builds deeper understanding and prepares you for future challenges.
在解决一个跨学科问题之后，花点时间反思一下你对两个学科都学到了什么。这有助于加深理解，并为未来的挑战做好准备。
Ask yourself: ‘What computing concept made the science experiment easier?’ or ‘How did mathematical reasoning improve my algorithm?’
问自己：“哪个计算机概念使科学实验更简单了？”或者“数学推理如何改进了我的算法？”。
Keep a revision journal noting the links you discover. For instance, binary place values are just powers of 2, which you learn in maths.
准备一本复习日志，记下你发现的联系。例如，二进制位权只是 2 的幂，这是你在数学中学到的。
The ability to combine computing with other subjects is not just for exams – it is a real‑world skill used by engineers, scientists, and game designers every day.
将计算机与其他学科结合的能力不仅仅是为了考试——它也是工程师、科学家和游戏设计师每天使用的现实世界技能。
As you continue with AQA Computing, always look for opportunities to bring in knowledge from your other lessons. Your solutions will be richer and more creative.
在你继续学习 AQA 计算机课程时，要始终寻找机会将其他科目所学的知识引入进来。你的解决方案会更加丰富、更有创意。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导