📚 Year 8 SQA Computing: Interdisciplinary Practice Questions | Year 8 SQA 计算机：跨学科综合题型训练
Computing is not just about coding on a screen; it connects with every subject you study, from maths and science to art and music. In Year 8 SQA Computing, you will often meet questions that blend programming, data handling, or digital design with other disciplines. These cross-curricular tasks test your ability to apply computer science skills in real-world contexts and build a deeper understanding of both subjects. This article provides a set of carefully crafted interdisciplinary practice questions, along with explanations, that follow the SQA Computing Science experiences and outcomes.
计算机不只是对着屏幕写代码，它与你所学的每一门学科都有联系——从数学、科学到艺术和音乐。在八年级 SQA 计算机课程中，你经常会遇到将编程、数据处理或数字设计与其它学科相融合的题目。这些跨学科任务考查你在真实情境中应用计算机科学技能的能力，同时加深你对两门学科的理解。本文提供了一组精心设计的跨学科练习题及其解析，符合 SQA 计算机科学的体验与成果要求。
1. Computing and Mathematics: Binary Number Puzzles | 计算机与数学：二进制数字谜题
Mathematics and computing share a common language: numbers. Understanding binary (base‑2) is key to thinking like a computer. In this exercise, you will solve puzzles that combine binary conversion with simple arithmetic, helping you recognise patterns and practise logical reasoning.
数学和计算机使用同一种语言：数字。理解二进制（基数为2）是像计算机一样思考的关键。在这个练习中，你将解决结合了二进制转换和简单算术的谜题，帮助你识别模式并练习逻辑推理。
Exercise: Convert the denary number 145 into an 8‑bit binary number. Now imagine each 1 in that binary pattern represents a light that is ON, and each 0 represents a light that is OFF. How many lights would be ON? Express your answer as a fraction of the total number of bits, and simplify it.
练习：将十进制数 145 转换为一个 8 位二进制数。现在想象这个二进制模式中的每个 1 代表一盏亮着的灯，每个 0 代表一盏灭着的灯。有多少盏灯是亮的？把你的答案表示为总位数的分数，并化简。
Solution approach: 145 = 128 + 16 + 1, so in binary it is 10010001. That gives three 1s. Out of 8 bits, the fraction is 3/8. This task connects binary representation (Computing) with fraction work (Mathematics).
解题思路：145 = 128 + 16 + 1，所以二进制是 10010001。这样就有 3 个 1。在 8 位中，分数是 3/8。这个任务将二进制表示（计算机）与分数运算（数学）联系起来。
2. Computing and Science: Analysing Sensor Data | 计算机与科学：分析传感器数据
Science experiments often involve recording temperature, light level, or motion. With a micro:bit or Raspberry Pi, you can program a device to collect data automatically. Here, you will interpret data stored in a CSV file and link it to your knowledge of heat transfer.
科学实验经常涉及记录温度、光照水平或运动。借助 micro:bit 或树莓派，你可以编写程序让设备自动收集数据。这里你要解读一个 CSV 文件中存储的数据，并联系热传递知识。
A micro:bit recorded temperature every minute in a classroom with a radiator turned on. The first ten readings (in °C): 19.2, 19.5, 20.1, 20.8, 21.6, 22.3, 23.0, 23.6, 24.1, 24.5. Using a spreadsheet formula, calculate the average temperature for this period. Then, explain why the temperature increased more slowly after the 6th minute, using the concept of thermal equilibrium.
一个 micro:bit 在开着暖气的教室里每分钟记录一次温度。前十次读数（单位℃）：19.2, 19.5, 20.1, 20.8, 21.6, 22.3, 23.0, 23.6, 24.1, 24.5。使用电子表格公式计算这段时间的平均温度。然后，用热平衡的概念解释为什么第 6 分钟后温度上升变慢。
Computing skill: average =SUM(A1:A10)/10 or =AVERAGE(A1:A10). The result is 21.87°C. Science link: as the room temperature approaches the radiator temperature, the rate of heat transfer decreases, so the rise slows. This question practises spreadsheet formulas and scientific reasoning simultaneously.
计算机技能：平均值 =SUM(A1:A10)/10 或 =AVERAGE(A1:A10)。结果是 21.87℃。科学联系：随着教室温度接近散热器温度，热传递速率下降，因此升温变慢。这个问题同时练习了电子表格公式和科学推理。
3. Computing and English: Digital Storytelling with Hyperlinks | 计算机与英语：超链接数字故事
Creating a choose‑your‑own‑adventure story is an excellent way to blend narrative writing with computing logic. You will plan a branching story and use hyperlinks in presentation software to connect the pages, just like a website.
创作一个“选择你自己的冒险”故事，是将叙事写作与计算逻辑融合的绝佳方式。你需要规划一个分支故事，并在演示文稿软件中用超链接将页面连接起来，就像网站一样。
Design a short story with at least four decision points. At each decision, the reader clicks a link to go to a different slide. Write a flowchart of the story paths before you build it. Then explain how this structure is similar to a website’s navigation.
设计一个至少有四个决策点的短故事。在每个决策点，读者点击链接跳转到不同的幻灯片。在动手制作之前，先画出故事路径的流程图。然后解释这种结构为何类似于网站的导航。
English: you must write engaging prose and consistent dialogue. Computing: you implement hyperlinks and understand non‑linear user pathways. This task also introduces the idea of hypertext, which underpins the World Wide Web.
英语：你必须写出引人入胜的文字和连贯的对话。计算机：你实现超链接并理解非线性的用户路径。这个任务也引入了超文本的概念，这是万维网的基础。
4. Computing and Art & Design: Pixel Graphics and Vector Drawing | 计算机与艺术设计：像素图形与矢量绘图
Digital art relies on two fundamental techniques: raster (pixel) and vector graphics. When you create a logo for a school club, you need to choose the appropriate format and understand how resolution affects quality.
数字艺术依赖于两种基础技术：栅格（像素）图形和矢量图形。当你为学校社团设计标志时，需要选择合适的格式，并理解分辨率如何影响质量。
Using a drawing app, design a simple logo containing three coloured circles and a text label. Create one version as a bitmap (e.g. PNG) at 100×100 pixels, and zoom in until you can see individual squares. Then recreate the same design using vector tools (e.g. Inkscape or PowerPoint shapes). Write a paragraph comparing how the two types of graphics behave when scaled up.
使用绘图应用程序，设计一个包含三个彩色圆圈和文字标签的简单标志。创建一个 100×100 像素的位图版本（如 PNG），然后放大直到你能看见一个个方块。接着使用矢量工具（如 Inkscape 或 PowerPoint 形状）重新制作相同的设计。写一段话，比较两种图形在放大时的表现。
Art insight: pixelation occurs when bitmaps are enlarged because each pixel becomes larger; vector graphics remain smooth because they are defined by mathematical coordinates. Computing: you learn about file formats, resolution, and the difference between raster and vector images – essential for media production.
艺术见解：位图放大时会出现像素化，因为每个像素都变大了；矢量图形保持平滑，因为它们是由数学坐标定义的。计算机：你学习文件格式、分辨率以及栅格与矢量图像的区别——这对媒体制作至关重要。
5. Computing and Geography: Visualising Population Data | 计算机与地理：人口数据可视化
Geographers often use graphs and maps to spot trends. Computing lets you create dynamic charts from raw data. In this task, you will work with population figures of four Scottish cities and produce a chart, then explain what it shows.
地理学家经常使用图表和地图来发现趋势。计算机让你能够从原始数据创建动态图表。在这个任务中，你将处理四个苏格兰城市的人口数据并生成图表，然后解释图表所显示的信息。
Data (approximate): Glasgow 630,000; Edinburgh 540,000; Aberdeen 200,000; Dundee 150,000. Enter these into a spreadsheet, then insert a bar chart with city names on the x‑axis and population on the y‑axis. Add a title and data labels. Identify which city is the second most populous, and calculate the percentage of Scotland’s total urban population living in Glasgow (assume the four cities together represent 85% of the total urban population).
数据（近似值）：格拉斯哥 630,000；爱丁堡 540,000；阿伯丁 200,000；邓迪 150,000。将这些数据输入电子表格，然后插入一个柱状图，x 轴为城市名称，y 轴为人口。添加标题和数据标签。找出人口第二多的城市，并计算格拉斯哥人口占苏格兰城市总人口的百分比（假设这四个城市合计占总城市人口的 85%）。
Geography: interpreting urban hierarchy and distribution. Computing: spreadsheet skills – data entry, chart creation, simple formula for percentage. The combined population of the four cities is 1,520,000. Glasgow’s share = 630,000 / 1,520,000 ≈ 41.4% of the four, but as a share of total urban population it is 41.4% × 0.85 ≈ 35.2%. This task reinforces proportional reasoning across subjects.
地理：解读城市等级和分布。计算机：电子表格技能——数据录入、图表创建、简单的百分比公式。四个城市的人口总和是 1,520,000。格拉斯哥的占比 = 630,000 / 1,520,000 ≈ 41.4%（占四个城市），但占城市总人口的比例为 41.4% × 0.85 ≈ 35.2%。这个任务在学科间强化了比例推理。
6. Computing and History: Encoding Messages Like a WWII Cipher | 计算机与历史：像二战密码一样编码信息
During World War II, cipher machines like Enigma used complex substitution to encrypt messages. Today, computing introduces you to encryption basics using Caesar ciphers and binary shifts. This exercise lets you encode a historical message and think like a codebreaker.
二战期间，像恩尼格玛这样的密码机使用复杂的替换来加密信息。今天，计算机通过凯撒密码和二进制移位向你介绍加密基础。这个练习让你编码一条历史信息，并像破译员一样思考。
Imagine it is 1943. Your mission is to send the word ‘INVASION’ using a Caesar cipher with a shift of +3 (A→D, B→E …). Write the encrypted word. Then, in computing terms, explain why simple substitution is insecure by describing how frequency analysis works.
想象现在是 1943 年。你的任务是用移位 +3 的凯撒密码（A→D, B→E……）发送单词 ‘INVASION’。写出加密后的单词。然后，从计算机角度解释为什么简单的替换密码不安全，描述频率分析是如何工作的。
Encryption result: INVASION → LQYDVLRQ. History & Computing: Bletchley Park codebreakers exploited letter frequency (E, T, A are common in English) to crack ciphers. In modern computing, stronger algorithms like AES use many rounds of substitution and permutation to defeat such patterns. This connects historical events with cybersecurity concepts.
加密结果：INVASION → LQYDVLRQ。历史与计算机：布莱切利园的密码破译员利用字母频率（英语中 E、T、A 常见）来破解密码。在现代计算机中，更强大的算法（如 AES）使用多轮替换和置换来消除这些模式。这将历史事件与网络安全概念联系起来。
7. Computing and Music: Composing with Loops and Samples | 计算机与音乐：用循环和采样作曲
Music technology relies heavily on computing. In this activity, you will use a block‑based coding environment (such as Scratch Music Extension or Sonic Pi) to create a repeating rhythm track, then use a music graphic score to plan your composition.
音乐技术高度依赖计算机。在这个活动中，你将使用基于积木的编程环境（如 Scratch 音乐扩展或 Sonic Pi）创建一个重复的节奏轨道，然后利用音乐图形谱来规划你的作曲。
Create a repeating 4‑bar drum pattern using code blocks that play different sounds (kick, snare, hi‑hat). Write down a simple graphic score using symbols for each drum sound. Then experiment with changing the tempo (beats per minute) and observe how it affects the feel of the track. Explain the relationship between tempo in music and the ‘wait’ time in your code.
使用代码积木创建一个重复的 4 小节鼓点模式，演奏不同的音效（底鼓、军鼓、踩镲）。用符号为每种鼓音写下一个简单的图形谱。然后尝试改变速度（每分钟节拍数），观察它如何影响曲子的感觉。解释音乐中的速度和你代码中的“等待”时间之间的关系。
Music: understanding rhythm, tempo, and notation. Computing: sequencing, time delays, loops (repeat blocks). If your tempo is 120 BPM, one beat lasts 0.5 seconds. The code wait time must match this duration. This cross‑curricular link reveals how programming can be a tool for creative expression.
音乐：理解节奏、速度和记谱。计算机：序列、时间延迟、循环（重复积木）。如果速度是 120 BPM，每拍持续 0.5 秒。代码中的等待时间必须与这个时长相匹配。这种跨学科联系揭示了编程如何成为创意表达的工具。
8. Computing and Business: Break‑Even Analysis with a Spreadsheet Model | 计算机与商业：用电子表格模型进行盈亏平衡分析
Business studies pupils learn about break‑even points – the number of items a company must sell to cover costs. Using formulas and absolute cell references, you can build a dynamic model that updates instantly when inputs change.
商科学生要学习盈亏平衡点——公司为覆盖成本而必须销售的产品数量。使用公式和绝对单元格引用，你可以构建一个动态模型，当输入改变时模型会即时更新。
You run a small badge‑making business. Fixed costs are £20 per week. Variable cost per badge is £1.50. Selling price is £2.50. Build a spreadsheet with a column for number of badges sold (from 0 to 50). Use formulas to calculate total cost, total revenue, and profit/loss for each quantity. Identify the break‑even point, and add conditional formatting to highlight the row where profit first becomes positive.
你经营一个小型徽章制作生意。每周固定成本为 20 英镑，每个徽章的可变成本为 1.50 英镑，售价为 2.50 英镑。建立一个电子表格，其中一列是已售徽章数量（从 0 到 50）。使用公式计算每个数量下的总成本、总收入和利润/亏损。找出盈亏平衡点，并添加条件格式来突出显示利润首次变为正数的那一行。
Business formula: Break‑even = Fixed cost / (Price – Variable cost) = 20 / (2.50 – 1.50) = 20 badges. Computing: total cost = $B$1 + A2*$B$2, revenue = A2*$B$3, profit = revenue – total cost. Use absolute references for the fixed cost and unit values so the formula can be dragged down. This task merges financial literacy with advanced spreadsheet modelling.
商业公式：盈亏平衡点 = 固定成本 /（售价 – 可变成本）= 20 / (2.50 – 1.50) = 20 个徽章。计算机：总成本 = $B$1 + A2*$B$2，收入 = A2*$B$3，利润 = 收入 – 总成本。对固定成本和单位数值使用绝对引用，这样公式就可以向下拖动。这个任务将财务知识与高级电子表格建模融合在一起。
9. Computing and Modern Languages: Creating a Multilingual Quiz | 计算机与外语：创建多语言问答
Language learning is about practice and repetition – exactly what a computer can help with. You will program a simple vocabulary quiz in Python or Scratch, storing words in two languages and checking the user’s answers.
语言学习关乎练习和重复——这正是计算机可以帮忙的地方。你将用 Python 或 Scratch 编写一个简单的词汇问答程序，存储两种语言的单词并检查用户的答案。
Write a program that holds five French–English word pairs in a list. The program displays a French word and asks the user to type the English translation. If correct, it adds one point; otherwise, it shows the right answer. After all five words, display the score out of 5. For an extension, use a text file to load the word pairs so a teacher can change the vocabulary list without altering the code.
编写一个程序，将五对法语-英语单词保存在列表中。程序显示一个法语单词，并要求用户输入英语翻译。如果正确，加一分；否则显示正确答案。完成全部五个单词后，显示得分（满分 5 分）。作为拓展练习，使用一个文本文件来加载单词对，这样老师无需修改代码就能更换词汇表。
Languages: reinforcing spelling and recall. Computing: lists/arrays, loops, conditional statements, file input. The task naturally introduces the concept of separation of data and code, an important programming principle. It also personalises learning, a key theme in modern education.
语言：强化拼写和记忆。计算机：列表/数组、循环、条件语句、文件输入。这个任务自然地引入了数据与代码分离的概念，这是一条重要的编程原则。它还实现了个性化学习，这是现代教育的一个关键主题。
10. Interdisciplinary Project: Designing a Sustainable Smart Home | 跨学科项目：设计可持续的智能家居
This capstone task brings together science, geography, computing, and design. You will propose a smart home system that uses sensors and automation to reduce energy consumption, and present your ideas as a structured report with diagrams.
这项总结性任务汇集了科学、地理、计算机和设计。你需要提出一个使用传感器和自动化来降低能耗的智能家居系统，并以带示意图的结构化报告形式展示你的想法。
Requirements: choose a location (e.g. Scottish Highlands) and research its average winter temperature (Geography). Design a system using micro:bit, including a temperature sensor, motion sensor, and automatic light control (Computing). Explain how double glazing and insulation work (Science). Sketch a floor plan showing sensor placement (Design & Technology). Calculate potential electricity savings if lights are off for an extra 4 hours per day, assuming a 12W LED bulb and electricity cost of 22p per kWh. Present the savings over a 30‑day winter month.
要求：选择一个地点（如苏格兰高地）并研究其冬季平均气温（地理）。设计一个使用 micro:bit 的系统，包括温度传感器、运动传感器和自动灯光控制（计算机）。解释双层玻璃和隔热的工作原理（科学）。绘制一个标明传感器位置的平面图（设计与技术）。假设一盏 12W 的 LED 灯每天额外关闭 4 小时，电费为每千瓦时 22 便士，计算潜在的节电量。展示一个 30 天冬季月份的节省情况。
Calculations: daily saving = 12W × 4h = 48 Wh = 0.048 kWh. Over 30 days = 1.44 kWh. Cost saving = 1.44 × 0.22 ≈ £0.32. While the amount seems small, scaling this to a whole house makes a significant difference. Cross‑curricular skills: data analysis, report writing, diagram production, and applying scientific principles. This project mirrors real‑world engineering challenges.
计算：每日节省 = 12W × 4 小时 = 48 Wh = 0.048 kWh。30 天 = 1.44 kWh。节省费用 = 1.44 × 0.22 ≈ 0.32 英镑。虽然数额看起来很小，但扩大到整个房子就会有显著差别。跨学科技能：数据分析、报告撰写、示意图绘制以及科学原理的应用。这个项目反映了真实的工程挑战。
11. Computing and Physical Education: Analysing Performance Data | 计算机与体育：分析运动表现数据
Wearable technology in sport collects vast amounts of data. Here, you will interpret heart rate figures from a PE lesson and use a spreadsheet to identify when a student was working in their target training zone.
体育中的可穿戴技术能收集大量数据。在这里，你将解读一节体育课中的心率数据，并使用电子表格来确定学生何时处于目标训练区间。
A pupil aged 13 has a maximum heart rate estimated as 207 BPM. Their target zone for cardiovascular fitness is 70–85% of maximum. During a 12‑minute run, heart rate readings (every minute) were: 110, 130, 145, 155, 162, 168, 172, 175, 178, 176, 174, 170. Calculate the target zone range (lower and upper bounds). In a spreadsheet, use an IF function to label each minute as ‘Zone’ if the heart rate is within the target range, otherwise ‘Below’ or ‘Above’. Determine the total minutes spent in the zone.
一名 13 岁学生的最大心率估计为 207 BPM。其心血管健康的目标区间是最大心率的 70%–85%。在一次 12 分钟跑步中，每分钟的心率读数为：110, 130, 145, 155, 162, 168, 172, 175, 178, 176, 174, 170。计算目标区间的范围（下限和上限）。在电子表格中，使用 IF 函数，如果心率在目标范围内则标注为 ‘Zone’，否则标注为 ‘Below’ 或 ‘Above’。确定在区间内的总分钟数。
PE calculation: lower = 207 × 0.70 = 144.9 ≈ 145 BPM; upper = 207 × 0.85 = 175.95 ≈ 176 BPM. Computing: formula =IF(B2>=145, IF(B2<=176, "Zone", "Above"), "Below"). Applying this, minutes 3 to 9 (7 minutes) are within the zone, with minute 10 just above 176. This task uses nested IFs and links to health and wellbeing.
体育计算：下限 = 207 × 0.70 = 144.9 ≈ 145 BPM；上限 = 207 × 0.85 = 175.95 ≈ 176 BPM。计算机：公式 =IF(B2>=145, IF(B2<=176, "Zone", "Above"), "Below")。应用这个公式，第 3 到第 9 分钟（共 7 分钟）在区间内，第 10 分钟略高于 176。这个任务使用了嵌套 IF 函数，并与健康和幸福主题关联。
12. Tips for Tackling Interdisciplinary Questions | 应对跨学科题目的技巧
When you see a question that mixes computing with another subject, do not panic. Start by identifying what each part of the question is really asking – there will be a computing skill (e.g. create a chart, write a formula, explain a security concept) and a subject‑specific skill (e.g. interpret a graph, recall a fact, solve an equation).
当你看到一个混合了计算机与另一学科的题目时，不要慌张。首先识别问题的每个部分实际在问什么——其中会有一项计算机技能（如创建图表、编写公式、解释安全概念）和一项特定学科的技能（如解读图表、回忆事实、解方程）。
Always show your working, whether it is a spreadsheet formula, a code snippet, or a calculation. Use the correct terminology from both domains to show your understanding. Finally, practise with data that you collect from your own life – your step count, your study timetable, your favourite music playlist – because personal connections make interdisciplinary learning more memorable.
无论是一个电子表格公式、一段代码还是一个计算，始终展示你的解题过程。使用两个领域的正确术语来展示你的理解。最后，用你从自己生活中收集到的数据来练习——你的步数、你的学习时间表、你最喜欢的音乐播放列表——因为个人联系会让跨学科学习更加难忘。
Examiner’s advice: marks are often awarded for applying computing tools to real data, not just for the final answer. So even if your chart doesn’t look perfect, the process you document matters. Keep a digital portfolio of your cross‑curricular projects; it will serve as useful revision and evidence of your skills.
考官建议：分数往往颁发给将计算机工具应用于真实数据的过程，而不仅仅是最终答案。因此，即使你的图表看起来不完美，你记录的过程也很重要。保留一个跨学科项目的数字作品集；它将作为有用的复习资料和你技能的证据。
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课程辅导，国外大学本科硕士研究生博士课程论文辅导