📚 Cross-curricular Integrated Question Practice for Year 7 AQA Computing | Year 7 AQA 计算机：跨学科综合题型训练
Computing is not a subject that exists in isolation. In Year 7, you will often meet questions that connect computer science with mathematics, science, geography, history, music, art, and even sport. This article provides a carefully designed set of cross-curricular integrated practice questions, covering the core themes from the AQA KS3 Computing framework. Each section blends subject knowledge with computational thinking, helping you build confidence in applying your coding, logic, and data handling skills to real-world problems.
计算机并不是一门孤立的学科。在七年级，你会经常遇到将计算机科学与数学、科学、地理、历史、音乐、艺术甚至体育相联系的题目。本文提供了一套精心设计的跨学科综合训练题，覆盖了 AQA KS3 计算机框架的核心主题。每个小节都将学科知识与计算思维融合在一起，帮助你在应用编程、逻辑和数据处理技能解决实际问题的过程中建立信心。
1. Algorithmic Thinking & Mathematics: Flowcharts for Averages | 算法思维与数学：用流程图求平均值
Imagine you are given a list of five numbers from a maths lesson: 12, 7, 9, 14, 6. Your task is to design a flowchart that calculates the mean (average) of these numbers. A flowchart uses standard symbols: an oval for Start/End, a parallelogram for Input/Output, a rectangle for a Process, and a diamond for a Decision. First, you need a variable called total set to 0, and a variable count set to 0. Then you enter a loop that reads each number, adds it to total, increases count by 1, and checks if count has reached 5. After the loop, you compute mean = total / 5, and output the result.
假设你在数学课上拿到了五个数字：12、7、9、14、6。你的任务是设计一个计算这些数字平均值（平均数）的流程图。流程图使用标准符号：椭圆形表示开始/结束，平行四边形表示输入/输出，矩形表示处理步骤，菱形表示判断。首先，你需要一个名为 total 的变量，初始值设为 0，还有一个变量 count 初始值也设为 0。然后你进入一个循环：依次读取每个数字，将其加到 total 上，count 增加 1，再判断 count 是否达到 5。循环结束后，计算 mean = total ÷ 5，并输出结果。
This task reinforces the use of sequencing, selection, and iteration — the three building blocks of any algorithm — while also practising a mathematical concept. For an extra challenge, you can adapt the flowchart to handle any quantity of numbers by using a sentinel value such as −1 to end the input.
这个练习强化了顺序、选择和循环这三种任何算法的基本构建块的使用，同时也练习了数学概念。如果想增加挑战，可以修改流程图，使用一个标记值（例如 −1）来结束输入，从而处理任意数量的数字。
2. Programming & Science: Simulating a Predator-Prey Model | 编程与科学：模拟捕食者-猎物模型
In your science lessons you may have studied food chains and population dynamics. A classic cross-curricular programming task asks you to write a simple simulation in Scratch or Python that models the relationship between rabbits (prey) and foxes (predators). Start by setting two variables: rabbits = 100 and foxes = 20. Each "year" ts 5 rabbits. Foxes then have a chance to reproduce based on how much food they have eaten — , it produces one offspring. Finally, if a fox fails to eat enough, it may starve and die.
在科学课上你可能学习过食物链和种群动态。一个经典的跨学科编程任务是要求你用 Scratch 或 Python 编写一个简单的模拟程序，展现兔子（猎物）和狐狸（捕食者）之间的关系。首先设置两个变量：rabbits = 100，foxes = 20。模拟中的每“一年”遵循以下规则：兔子数量自然翻倍，但每只狐狸会吃掉 5 只兔子。然后狐狸根据吃掉的食物量有机会繁殖——如果一只狐狸吃得足够多，就会生下一只后代。最后，如果狐狸没能吃到足够的食物，它可能会饿死。
You can write this as a loop that runs for 20 simulated years, printing the populations each time. Here is a simplified version of the logic in pseudocode:
你可以用一个运行 20 个模拟年份的循环来实现，每次输出种群数量。以下是简化版的伪代码逻辑：
FOR year = 1 TO 20
rabbits = rabbits × 2
eaten = foxes × 5
rabbits = rabbits − eaten
IF eaten/foxes > 3 THEN foxes = foxes + (foxes × 0.3)
ELSE foxes = foxes − (foxes × 0.2)
PRINT year, rabbits, foxes
NEXT year
This type of activity develops skills in variables, mathematical operators, conditionals, and loops, while deepening understanding of scientific modelling. Students can then graph the output in a spreadsheet to see the cyclical pattern of population changes.
这类活动可以培养变量、数学运算符、条件语句和循环的使用技能，同时加深对科学建模的理解。学生还可以将输出结果放到电子表格中绘制图表，观察种群数量变化的周期性规律。
3. Data Representation & Geography: Climate Data and Charts | 数据表示与地理：气候数据与图表
Geography projects often involve collecting and presenting climate data. A cross-curricular computing task asks you to take monthly temperature and rainfall figures for a city — for example, London — and create a dual-axis chart using spreadsheet software. You will need two columns for months (as labels) and two numerical columns: average temperature in °C and total rainfall in mm. In a spreadsheet program, you create a combo chart, with temperature as a line and rainfall as bars. This requires formatting skills such as choosing appropriate chart types, adding axis titles, and applying conditional formatting to highlight the wettest month.
地理项目经常涉及收集和展示气候数据。一项跨学科的计算任务是让你获取某个城市（例如伦敦）的月平均气温和降雨量数据，然后使用电子表格软件创建一个双轴图表。你需要两列数据：一列是月份（作为标签），两列数值数据分别是平均气温（°C）和总降雨量（mm）。在电子表格程序中，创建一个组合图表，气温用折线表示，降雨量用柱状图表示。这需要图表格式化技能，例如选择合适的图表类型、添加坐标轴标题，以及应用条件格式突出显示降雨最多的月份。
To take it further, you can write a short program that calculates the mean annual temperature, finds the maximum and minimum values, and even predicts the next month's temperature using a simple rolling average formula:
进一步地，你可以编写一个简短的程序，计算年平均气温，找出最大值和最小值，甚至使用简单的移动平均公式预测下个月的气温：
predicted_temp = (temp₋₁ + temp₋₂ + temp₋₃) ÷ 3
where temp₋₁, temp₋₂, temp₋₃ are the temperatures of the three most recent months. This introduces the concept of forecasting and the use of formulas across cells in a spreadsheet or coded in Python.
其中 temp₋₁、temp₋₂、temp₋₃ 是最近三个月的温度。这引入了预测的概念，以及如何在电子表格单元格之间或 Python 中使用公式。
4. Encryption & History: Caesar Cipher and Roman Communication | 加密与历史：凯撒密码与罗马通信
Julius Caesar used a simple substitution cipher to send secret military messages. This makes a perfect link between computing and history. The Caesar cipher shifts each letter in the alphabet by a fixed number of positions. For example, with a shift of 3, 'A' becomes 'D', 'B' becomes 'E', and so on. In Year 7, you can write a program on paper or in code that takes a plaintext message and a shift value, and outputs the ciphertext. You must also handle wrapping around the end of the alphabet: 'Z' shifted by 2 becomes 'B'.
尤利乌斯·凯撒曾使用一种简单的替换密码来发送秘密军事情报。这为计算机和历史之间建立了完美的联系。凯撒密码将字母表中的每个字母向前移动固定数量的位置。例如，移位值为 3 时，'A' 变成 'D'，'B' 变成 'E'，依此类推。在七年级，你可以编写一个程序（用纸笔或代码），接收一段明文和一个移位值，然后输出密文。你还必须处理字母表末尾的环绕问题：'Z' 移动两位后变成 'B'。
To decrypt, the process is reversed. A historical investigation task: given a ciphertext found on a Roman tablet, can you work out the shift using frequency analysis? In English, the letter 'E' is the most common. Count the most frequent letter in the ciphertext and calculate the shift relative to 'E'. This embeds computational thinking (pattern recognition, decomposition) into historical inquiry.
解密时则反向操作。一个历史调查任务是：如果在一块罗马石板上发现了一段密文，你能否使用频率分析求出移位值？在英语中，字母 'E' 是最常见的。统计密文中出现频率最高的字母，并计算它与 'E' 的偏移量。这就将计算思维（模式识别、问题分解）融入到了历史探究中。
5. Text Analysis & English: Word Frequency in Poems | 文本分析与英语：诗歌中的词频
When studying poetry in English, you might explore themes by looking at repeated words. Computing provides a powerful tool for textual analysis. Write a simple program (or use a spreadsheet) that takes the text of a short poem, splits it into separate words, removes punctuation, and counts how many times each word appears. You can then display the results in a bar chart to visualise the most common words. For instance, in William Blake's 'The Tyger', the words 'Tyger', 'burning', and 'fearful' might stand out.
在英语课上学习诗歌时，你可能会通过观察重复出现的词语来探索主题。计算机为文本分析提供了强大的工具。编写一个简单的程序（或使用电子表格），读取一首短诗的文本，将其拆分为单词，去掉标点符号，然后统计每个单词出现的次数。之后你可以将结果用条形图展示出来，使最常见的单词可视化。例如，在威廉·布莱克的《老虎》中，'Tyger'、'burning' 和 'fearful' 这些词可能会特别突出。
This task covers string manipulation, list or array handling, and the use of a dictionary data structure (in Python) or a frequency table (in spreadsheets). It also opens up discussions about stop words (like 'the' and 'and') and why they often top the frequency list, which relates to English language study of vocabulary and syntax.
这项任务涵盖字符串操作、列表或数组处理，以及字典数据结构（Python 中）或频率表（电子表格中）的使用。它还可以引出关于停用词（如 'the' 和 'and'）的讨论，以及为什么这些词经常占据频率表首位，这与英语语言中对词汇和句法的学习密切相关。
6. Digital Art & Design: Pixel Art and Resolution | 数字艺术与设计：像素艺术与分辨率
ade up of pixels, and the resolution tells you how many pixels are in a given area. A cross-curricular task: design a simple 8×8 icon on graph paper, where each square is a pixel, and then encode it as a binary string. For black and white images, 1 can represent a filled square and 0 an empty square. Then calculate the file size in bits. If you use 2 bits per pixel, you can represent four colours (00, 01, 10, 11), allowing for a more colourful icon.
艺术和设计技术课常会涉及使用彩色方格网格来创作图像。在计算机课上你会学到，数字图像是由像素组成的，而分辨率告诉你给定区域内有多少像素。一个跨学科任务是：在方格纸上设计一个简单的 8×8 图标，每个方格代表一个像素，然后将其编码为二进制字符串。对于黑白图像，1 可以表示填色的方格，0 表示空白的方格。然后以位（bit）为单位计算文件大小。如果每个像素使用 2 位，你可以表示四种颜色（00、01、10、11），从而创作出更丰富的彩色图标。
This exercise connects the understanding of image representation, binary numbers, and data storage with artistic creativity. It also prepares students for more advanced concepts like colour depth and metadata.
这项练习将图像表示、二进制数和数据存储的理解与艺术创造力联系起来。同时也为学生今后学习颜色深度和元数据等更高级的概念做好了准备。
7. Music & Technology: Coding a Melody with Sonic Pi | 音乐与技术：用 Sonic Pi 编写旋律
Sonic Pi is a live coding environment that allows you to create music by writing code. In Year 7, you can combine music curriculum topics — such as rhythm, pitch, and tempo — with programming concepts like loops and parameters. A simple task: use the play command to sound the notes C, D, E, F, G, A, B, C. Then put them in a loop that repeats 4 times, and experiment with the sleep command to change the rhythm. By introducing use_synth and use_bpm, you can alter the instrument sound and the beats per minute, directly applying musical terminology.
Sonic Pi 是一个实时编码环境，可以通过编写代码来创作音乐。在七年级，你可以将音乐课程的主题——如节奏、音高和速度——与循环和参数等编程概念结合起来。一个简单的任务是：使用 play 命令依次演奏 C、D、E、F、G、A、B、C 这些音符。然后将它们放进一个重复 4 次的循环中，再通过 sleep 命令尝试改变节奏。通过引入 use_synth 和 use_bpm，你可以改变乐器的音色和每分钟的节拍数，直接应用音乐术语。
This activity teaches that code can be a creative medium. It also reinforces the idea of functions and parameters, because each play can take options like amp: for volume or pan: for stereo position. A typical cross-curricular assessment might ask: "Write a program that plays Twinkle Twinkle Little Star using only 8 lines of code inside a loop."
这项活动告诉我们，代码可以是一种创作媒介。它也强化了函数和参数的概念，因为每个 play 命令都可以附带诸如 amp:（音量）或 pan:（立体声位置）等选项。一个典型的跨学科评估题目可能是：“编写一个程序，仅使用循环内的 8 行代码演奏《小星星》。”
8. Sport Data Analysis: Tracking and Improving Performance | 体育数据分析：追踪并提升运动表现
PE lessons generate a lot of data: times for running 100 metres, scores in a basketball shooting drill, or distances thrown in javelin. In computing, you can design a spreadsheet or a database to record this data, then analyse it to find personal bests, averages, and trends. For example, record your 100m sprint times over 6 weeks in seconds: 15.2, 14.8, 14.5, 14.9, 14.3, 14.1. Create a formula to calculate the improvement from the first week to the last. Use conditional formatting to automatically colour the fastest time green and the slowest time red.
体育课上会产生大量数据：100 米跑步的时间、篮球投篮练习的得分，或者标枪投掷的距离。在计算机课上，你可以设计一个电子表格或数据库来记录这些数据，然后进行分析，找出个人最佳成绩、平均值和变化趋势。例如，记录连续 6 周的 100 米短跑时间（以秒为单位）：15.2、14.8、14.5、14.9、14.3、14.1。创建一个公式来计算从第一周到最后一周的提升幅度。使用条件格式自动将最快的成绩标为绿色，最慢的成绩标为红色。
To extend this, a Python program could read all the times from a list and output a simple training recommendation: if the last three times are all decreasing, print "You are getting faster — keep going!" This combines data analysis with giving feedback, a key aspect of data science.
进一步地，可以用 Python 程序读取列表中的所有时间数据，并输出一个简单的训练建议：如果最近三次时间都在减少，就打印“你正在变快——继续保持！”这就将数据分析与反馈建议结合起来，这也是数据科学的一个关键方面。
9. Databases & Business Studies: Managing a Pop-up Shop | 数据库与商业研究：管理一家快闪商店
Imagine you are running a pop-up shop selling school supplies. You need to keep track of your products, prices, stock levels, and sales. This is a perfect scenario for a database task that links computing with business studies. Using a single table database tool (such as Microsoft Access or a spreadsheet structured as a flat-file database), create fields for ProductID, ProductName, Price, StockQuantity, and Supplier ntory (Price × StockQuantity for each item, then sum); and identify which supplier provides the most different products.
想象你正在经营一家销售学校用品的快闪商店。你需要跟踪产品、价格、库存水平和销售情况。这是一个将计算机与商业研究联系起来的完美数据库任务场景。使用单表数据库工具（如 Microsoft Access 或构造为平面文件数据库的电子表格），创建字段：ProductID、ProductName、Price、StockQuantity 和 Supplier。至少输入 10 条记录。然后执行查询：找出库存少于 5 件的所有产品（以便补货）；计算库存的总价值（每件商品的 Price × StockQuantity，然后求和）；确定哪个供应商提供了最多不同种类的商品。
This exercise introduces data types (text, number, currency), primary keys, and simple queries — core database concepts — while also requiring business thinking about profit, loss, and supply chains. A further computational challenge is to automatically apply a 10% discount to all items from a particular supplier using an update query.
这项练习介绍了数据类型（文本、数字、货币）、主键和简单的查询等核心数据库概念，同时需要运用有关利润、亏损和供应链的商业思维。一个更进一步的计算挑战是使用更新查询自动为来自某个特定供应商的所有商品打九折。
10. Logic & Philosophy: Boolean Gates and Ethical Puzzles | 逻辑与哲学：布尔门与伦理谜题
Boolean logic (AND, OR, NOT) forms the foundation of how computers make decisions. These logical operators can also be applied to philosophical or ethical dilemmas. A cross-curricular puzzle: design a simple system that controls a self-driving car's braking decision. The brake should activate if (object_ahead = TRUE) AND (speed > 30) OR (emergency_brake_pressed = TRUE). Create a truth table to test all possible inputs and verify when the brakes engage. This bridges technology with the philosophy of ethics — how should an autonomous vehicle prioritise decisions?
布尔逻辑（AND、OR、NOT）构成了计算机决策的基础。这些逻辑运算符也可以应用于哲学或伦理困境。一个跨学科谜题：设计一个简单的系统来控制自动驾驶汽车的制动决策。制动应该在满足 （前方有障碍物 = TRUE）AND（车速 > 30）OR（紧急制动被按下 = TRUE） 时激活。创建一个真值表，测试所有可能的输入组合，验证制动在哪些情况下会触发。这就在技术和伦理哲学之间架起了桥梁——自动驾驶汽车应该如何做出决策的优先级判断？
Additionally, you can explore a logic puzzle: "A museum alarm goes off when the pressure sensor under a painting OR the infrared beam is broken AND the security system is armed." Translate this sentence into a logic diagram and expression, then discuss what happens if a security guard accidentally breaks the beam during cleaning while the system is not armed. This cultivates careful reasoning and application of Boolean principles to real-world security contexts.
此外，你还可以探讨一个逻辑谜题：“一座博物馆的警报器在画作下方的压力传感器被触发，或者红外光束被遮断且安保系统处于布防状态时响起”。将这句话翻译成逻辑图和表达式，然后讨论如果一名保安在清洁时不小心遮断了光束，但系统并未布防，会发生什么情况。这培养了严谨的推理能力，以及将布尔原则应用于现实安全情景的能力。
Published by TutorHao | AQA KS3 Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图