Year 9 CCEA Computer Science: Cross-curricular Integrated Question Practice | Year 9 CCEA 计算机：跨学科综合题型训练

📚 Year 9 CCEA Computer Science: Cross-curricular Integrated Question Practice | Year 9 CCEA 计算机：跨学科综合题型训练

Computer science is not an isolated subject; it connects naturally with mathematics, science, geography, art, and even languages. For Year 9 students following the CCEA curriculum, practising questions that blend computing concepts with other disciplines strengthens both problem-solving skills and real-world understanding. This article provides a set of cross-curricular integrated questions, each designed to highlight how computational thinking applies beyond the computer lab. Work through these examples to deepen your knowledge and prepare for assessments that test your ability to transfer ideas across subjects.

计算机科学不是一门孤立的学科；它自然与数学、科学、地理、艺术甚至语言联系在一起。对于学习 CCEA 课程的 Year 9 学生来说，练习将计算思维与其他学科知识融合的题目，既能强化解决问题的能力，也能加深对现实世界的理解。本文提供了一组跨学科综合题型，每道题都突显了计算思维在计算机实验室之外的应用。通过完成这些练习，你可以深化知识，并准备好应对那些考验知识迁移能力的不同科目的综合评估。

1. Binary Representation in Music | 音乐中的二进制表示

A digital keyboard can record which notes are pressed during a performance. Each note is stored as a series of bits. A simplified system uses 1 to represent a key pressed and 0 to represent a key not pressed. The keyboard has 8 white keys. The binary pattern 10101010 means that every other key was pressed. This pattern can be translated into a rhythm or melody. Explain how the binary system helps musicians edit recordings and why understanding patterns in binary is useful for composing electronic music.

数字键盘可以记录演奏时按下了哪些音符。每个音符被存储为一系列二进制位。一个简化的系统用 1 表示按键按下，0 表示按键未按下。键盘有 8 个白键。二进制模式 10101010 意味着每隔一个键被按下。这个模式可以转换成节奏或旋律。请解释二进制系统如何帮助音乐家编辑录音，并说明理解二进制模式对创作电子音乐有何用处。

• In digital audio workstations, sound is often manipulated by editing binary data. Smooth changes in bit patterns can create gradual volume changes or tonal shifts.
• 在数字音频工作站中，声音通常通过编辑二进制数据来处理。比特模式的平滑变化可以产生渐进的音量变化或音调转换。
• Composers can use logical operations (AND, OR, NOT) on binary sequences to create variations of a musical phrase quickly.
• 作曲家可以对二进制序列应用逻辑运算（与、或、非），快速生成乐句的变奏。
• Understanding that any sound can be represented as numbers helps students see the link between computing and the creative arts.
• 理解任何声音都可以用数字表示，有助于学生看到计算与创意艺术之间的联系。

---

2. Algorithms and Recipe Sequencing | 算法与食谱排序

In food technology, a recipe is like an algorithm. It contains a sequence of steps that must be followed to produce the desired dish. Consider a recipe for chocolate chip cookies: preheat oven, mix butter and sugar, add eggs, add flour and chocolate chips, shape dough, and bake. A student tried to parallelize some steps by preheating the oven while mixing ingredients. Explain why the order of instructions matters and what computational concepts (like sequence, selection, and iteration) apply to improving a recipe's instructions.

在食品科技中，食谱就像一种算法。它包含一系列必须遵循的步骤，以制作出期望的菜肴。考虑一份巧克力曲奇的食谱：预热烤箱、混合黄油和糖、加入鸡蛋、加入面粉和巧克力碎、塑形、烘烤。一名学生尝试通过边预热烤箱边混合配料来并行执行一些步骤。解释为什么指令的顺序很重要，以及哪些计算概念（如顺序、选择和迭代）适用于改进食谱的说明。

• Sequence is vital: the butter and sugar must be creamed before adding eggs, otherwise the mixture may curdle. This is like a program where one function must complete before another begins.
• 顺序至关重要：黄油和糖必须在加入鸡蛋之前打发，否则混合物可能结块。这就像一个程序中，一个函数必须在另一个函数开始之前完成。
• Selection occurs when a recipe says, "if the dough is too sticky, add more flour." This is a conditional branch, similar to IF...THEN...ELSE in coding.
• 当食谱说“如果面团太粘，就加更多面粉”时，就出现了选择。这是一个条件分支，类似于编程中的 IF...THEN...ELSE。
• Iteration appears in repeated actions such as beating the mixture until light and fluffy, or checking every 2 minutes while baking. These are loops (WHILE or REPEAT UNTIL).
• 迭代出现在重复操作中，例如搅拌混合物直到颜色变浅且蓬松，或在烘烤时每 2 分钟检查一次。这些都是循环（WHILE 或 REPEAT UNTIL）。

---

3. Spreadsheets for Scientific Data Analysis | 科学数据分析中的电子表格

In science lessons, students often collect experiment data, such as the temperature change of a cooling liquid over time. A spreadsheet can be used to record results and create charts. Suppose a student recorded the temperature of water every 30 seconds for 5 minutes. The data is in two columns: Time (s) and Temperature (°C). The student wants to predict when the temperature will reach 25 °C using a trend line. Describe how a spreadsheet uses formulas, cell references, and graph features to perform this scientific analysis. Also, identify an error that might occur if the data is entered incorrectly and how to fix it using spreadsheet tools.

在科学课上，学生们经常收集实验数据，例如液体冷却过程中的温度变化。电子表格可以用来记录结果并创建图表。假设一名学生每隔 30 秒记录了水的温度，持续了 5 分钟。数据分为两列：时间（秒）和温度（℃）。学生想用趋势线预测温度何时会达到 25 ℃。描述电子表格如何使用公式、单元格引用和图表功能来完成这一科学分析。同时，指出如果数据输入错误可能出现的错误，以及如何借助电子表格工具来修正。

• ure is in column B) can be used to create a new column of predicted values based on a linear trend line equation given by the spreadsheet.
• 可以使用如 =B2 这样的公式（假设温度在 B 列）来创建一个基于电子表格给出的线性趋势线方程的新预测值列。
• Cell references (e.g., A2:A11) allow the trend line to update automatically when new data is added. If an absolute reference like $B$2 is used, it stays fixed when copying formulas, which is useful for constants.
• 单元格引用（如 A2:A11）允许趋势线在新增数据时自动更新。如果使用如 $B$2 这样的绝对引用，在复制公式时它会保持不变，这对常量很有用。
• An input error might be a temperature typed as 21.5 instead of 2.15 due to a misplaced decimal. This could skew the trend line. The student can use data validation to restrict input ranges (e.g., 0–100) and conditional formatting to highlight outliers.
• 输入错误可能是由于小数点错位将温度键入为 21.5 而非 2.15。这可能会歪曲趋势线。学生可以使用数据验证来限制输入范围（如 0–100），并使用条件格式高亮显示异常值。

---

4. Databases and Geography: Mapping Population Patterns | 数据库与地理：绘制人口模式

A geography project requires students to analyse population data for different countries. A database table contains fields: Country, Population, Area, Continent, and Capital. The teacher asks students to find all countries in Europe with a population greater than 50 million and then calculate their population density (Population/Area). Explain how to design a query (using SQL-like logic) to retrieve this information, and discuss why a relational database is better than storing data on separate pieces of paper for collaborative geographical research.

一个地理项目要求学生分析不同国家的人口数据。数据库表包含字段：国家、人口、面积、所在洲和首都。老师要求学生找出欧洲所有人口超过 5000 万的国家，然后计算其人口密度（人口/面积）。解释如何设计一个查询（使用类似 SQL 的逻辑）来检索这一信息，并讨论为什么在协作地理研究中，关系数据库比将数据存储在不同纸张上更好。

• ECT Country, Population, Area, Population/Area AS Density FROM Countries WHERE Continent = 'Europe' AND Population > 50000000;
• 类似 SQL 的查询如下：ECT Country, Population, Area, Population/Area AS Density FROM Countries WHERE Continent = 'Europe' AND Population > 50000000;
• A relational database allows multiple users to access and update data simultaneously without conflicts, unlike paper records which can become out of date or damaged.
• 关系数据库允许多个用户同时访问和更新数据而不会冲突，而不像纸质记录会过时或损坏。
• Using queries, students can quickly compare densities and sort results (ORDER BY Density DESC). This encourages data-driven geographic reasoning.
• 使用查询，学生可以快速比较密度并排序结果（ORDER BY Density DESC）。这有助于进行数据驱动的地理推理。

---

5. Networks and Language Learning: A Virtual Classroom | 网络与语言学习：虚拟课堂

Language exchange programmes often use video conferencing tools that operate over computer networks. Students in a French class connect with a partner school in Paris. The video and audio data must travel between two locations. Describe how packet switching works to send a spoken phrase across the network. Also, explain why latency (delay) might affect a conversation, and suggest a computing solution to reduce the effect of latency, using techniques like buffering or compression.

语言交流项目通常使用通过计算机网络运行的视频会议工具。法语课上的学生与巴黎的一所合作学校连线。视频和音频数据必须在两个地点之间传输。描述分组交换如何将一段口语句子通过网络发送。同时，解释为什么延迟可能会影响对话，并提出一种计算方案来减少延迟的影响，例如使用缓冲或压缩技术。

• When a student speaks, the sound is sampled and converted to binary data. This data is split into small packets, each with a header containing source and destination IP addresses and a packet number.
• 当学生说话时，声音被采样并转换为二进制数据。这些数据被分割成小的数据包，每个包都有一个包含源目 IP 地址和包序号的首部。
• Routers read the destination address and forward packets along the best available path. Packets may arrive out of order; the receiving computer uses the packet numbers to reassemble the audio correctly.
• 路由器读取目的地址，并沿最佳可用路径转发数据包。数据包可能乱序到达；接收端计算机使用包序号正确地重组音频。
• High latency can cause unnatural pauses. To reduce its impact, applications use buffering (storing a small amount of audio before playing to absorb jitter) and compression (reducing file size so packets transmit faster).
• 高延迟可能导致不自然的停顿。为了减少其影响，应用程序使用缓冲（在播放前存储少量音频以吸收抖动）和压缩（减小文件大小使数据包传输更快）。

---

6. Problem-Solving with Flowcharts in Mathematics | 数学中的流程图解题

tiply by 3 and add 1; if x is even, divide by 2. This is the Collatz conjecture process. Trace the flowchart for x = 6, writing down the sequence until you reach 1. Then, redesign the flowchart to include a counter that tracks the number of steps taken. Explain how a flowchart helps detect infinite loops and why mathematicians might use a computer program to test this conjecture for very large numbers.

涉及序列或函数的数学问题可以用流程图来建模。一个流程图可以表示这样的函数：如果 x 是奇数，乘 3 再加 1；如果 x 是偶数，则除以 2。这就是考拉兹猜想的过程。对 x = 6 跟踪流程图，写下序列直到达到 1。然后，重新设计流程图，使其包含一个计数器来记录所经历的操作步数。解释流程图如何帮助检测无限循环，以及为什么数学家可能使用计算机程序来对非常大的数字测试这一猜想。

• 8, 4, 2, 1. A counter variable would increment each loop until the condition x = 1 is met.
• 对于 x = 6：6（偶数）→ 3，3（奇数）→ 10，10 → 5，5 → 16，16 → 8，8 → 4，4 → 2，2 → 1。序列：6, 3, 10, 5, 16, 8, 4, 2, 1。一个计数器变量会在每次循环时递增，直到满足 x = 1 的条件。
• A flowchart uses decision symbols (diamonds) to check conditions. If a loop lacks a proper exit condition, it may run forever. Mathematicians use computers to run the Collatz process for billions of numbers because manual tracing is impractical.
• 流程图使用决策符号（菱形）来检查条件。如果循环缺少合适的退出条件，它可能永远运行。数学家使用计算机对数以十亿计的数字运行考拉兹过程，因为手动追踪是不切实际的。
• By implementing the counter in a flowchart, we can also study the efficiency of the algorithm—how many steps are needed on average.
• 通过在流程图中实现计数器，我们还可以研究算法的效率——平均需要多少步。

---

广告 / Sponsored

7. Game Design and Narrative Writing | 游戏设计与叙事写作

In English class, you are asked to write an interactive story where the reader makes choices that affect the ending. This is similar to branching narratives in computer games. Design a simple story with three decision points, each using a binary choice (e.g., left or right, fight or flee). Draw a storyboard showing the flow of decisions as a tree diagram. Explain how variables can be used in a program to remember the reader's previous choices and influence later events. How does this relate to computer science concepts like state and conditional branching?

在英语课上，你被要求写一个互动故事，读者在其中做出的选择会影响结局。这类似于电脑游戏中的分支叙事。设计一个带有三个决策点的简单故事，每个决策点使用一个二选一的选择（例如，左或右，战斗或逃跑）。画出一个故事板，将决策流程表示为树状图。解释在程序中如何使用变量来记住读者之前的选择并影响后续事件。这与计算机科学中的状态和条件分支等概念有何关联？

• A tree diagram starts with a root node (story start). Each decision creates two branches. A variable like 'courage' could increase each time the reader chooses a brave option; later scenes check if courage > 2 to unlock a heroic ending.
• 树状图从一个根节点（故事开始）开始。每个决策产生两个分支。像 'courage' 这样的变量可以在读者每次选择勇敢选项时增加；后来的场景检查 courage > 2 以解锁英雄结局。
• In programming, IF...ELSE statements handle branching. Maintaining a state (variables) allows the program to present a coherent story even when paths diverge, connecting narrative writing directly to computational logic.
• 在编程中，IF...ELSE 语句处理分支。维护状态（变量）使程序即使在路线分岔时也能呈现连贯的故事，从而将叙事写作直接与计算逻辑联系起来。
• This exercise shows that storytelling and game development share fundamental structures: story trees are essentially decision trees, and character development is state tracking.
• 这个练习表明，讲故事和游戏开发共享基本结构：故事树本质上是决策树，而角色发展就是状态追踪。

---

8. Image Representation in Art | 艺术中的图像表示

Pixel art is a form of digital art where images are created by colouring individual squares on a grid. Each square’s colour is stored as a binary number. A Year 9 art project involves creating an 8x8 pixel icon using only black and white. The image can be represented as a list of binary strings. Discuss how increasing the bit depth (e.g., from 1 bit per pixel to 8 bits per pixel) changes the file size and colour possibilities. Compare vector graphics and raster graphics, and explain which is more suitable for a logo that must be scaled to different sizes without losing quality.

像素画是一种数字艺术形式，通过在网格上为每个小方块着色来创建图像。每个方块的颜色存储为一个二进制数。一个 Year 9 美术项目要求使用纯黑色和白色创建一个 8x8 的像素图标。这幅图像可以表示为一串二进制字符串的列表。讨论增加位深（例如，从每像素 1 位增加到每像素 8 位）如何改变文件大小和颜色可能性。比较矢量图与光栅图，并解释哪种格式更适合需要按不同尺寸缩放而不损失质量的标志。

• xel, we can have 256 colours, but the file size is 8 times larger (64 bytes), assuming no compression.
• 每像素 1 位时，我们只有 2 种颜色（黑和白）。一张 8x8 的图像占用 64 位 = 8 字节。每像素 8 位时，我们可以有 256 种颜色，但文件大小变为原来的 8 倍（64 字节），假设无压缩。
• Raster images (like pixel art) store a grid of coloured dots. When enlarged, they become blocky. Vector graphics store mathematical descriptions of shapes (lines, curves) and can be scaled infinitely without losing sharpness.
• 光栅图像（如像素画）存储彩色圆点的网格。放大时会变得像素化。矢量图存储形状（线条、曲线）的数学描述，可以无限缩放而不损失清晰度。
• A logo should ideally be created as a vector graphic so it can be used on a business card or a billboard with perfect quality. The concept links art, design, and data representation.
• 标志最好创建为矢量图，这样它可以完美地用于名片或广告牌上。这一概念将美术、设计和数据表示联系起来。

---

9. Cryptography and History: Ciphers from the Past | 密码学与历史：过去的密码

During a history lesson on World War II, students learn about the Enigma machine and the Caesar cipher. The Caesar cipher shifts each letter by a fixed number of places in the alphabet. If the shift is 3, A becomes D, B becomes E, etc. A message "HELLO" becomes "KHOOR". Write a simple algorithm (pseudocode) to automate the Caesar cipher decryption given a ciphertext and a key shift. Also, discuss how modern encryption relies on computational complexity to keep data secure, and why computerised cryptography is essential for online history research or secure archiving of historical documents.

在一堂关于二战的历史课中，学生们学习了恩尼格玛密码机和凯撒密码。凯撒密码将字母表中的每个字母移动固定位数。如果位移是 3，A 变成 D，B 变成 E，等等。消息 "HELLO" 变成 "KHOOR"。编写一个简单的算法（伪代码），在给定密文和位移密钥的情况下自动解密凯撒密码。并讨论现代加密如何依赖计算复杂性来保障数据安全，以及为什么计算机化密码学对在线历史研究或历史文档的安全存档至关重要。

• Pseudocode for decryption:

  FUNCTION DecryptCaesar(ciphertext, shift)
    alphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
    plaintext = ""
    FOR each character ch IN ciphertext:
      position = POSITION of ch IN alphabet
      newPosition = (position - shift + 26) MOD 26
      plaintext = plaintext + alphabet[newPosition]
    END FOR
    RETURN plaintext
  END FUNCTION
  

• Modern encryption, such as AES, uses complex mathematical transformations and large keys (e.g., 256 bits) that would take even the fastest computers billions of years to crack by brute force. This computational complexity is a core concept in computer science and protects everything from museum archives to online communications.
• 现代加密，如 AES，使用复杂的数学变换和大密钥（如 256 位），即使最快的计算机用暴力破解也需要数十亿年。这种计算复杂性是计算机科学的核心概念，保护从博物馆档案到在线通信的一切安全。
• Computerised cryptography enables historians to securely access and share digitised primary sources from anywhere, ensuring copyright and privacy where needed.
• 计算机化密码学使历史学家能够安全地远程访问和共享数字化的原始资料，确保在需要时保护版权和隐私。

---

10. Environmental Computing: Modelling Ecosystems | 环境计算：模拟生态系统

In environmental science, students study predator-prey relationships, such as foxes and rabbits. These can be modelled using a simple program that updates the populations each year based on birth rates, death rates, and predation. Suppose the rabbit population increases by 20% per year naturally, while foxes decrease by 10% without prey. Foxes eat a fixed number of rabbits per fox per year, reducing the rabbit population. Design a spreadsheet or program to simulate 10 years of this ecosystem. Explain how simulation helps scientists predict outcomes and the role that random number generators can play in making models more realistic.

在环境科学中，学生研究捕食者-猎物关系，例如狐狸和兔子。这可以用一个简单的程序来模拟，该程序根据出生率、死亡率和捕食作用每年更新种群数量。假设兔子数量每年自然地增长 20%，而狐狸在没有猎物的情况下每年减少 10%。每只狐狸每年捕食固定数量的兔子，从而减少兔子数量。设计一个电子表格或程序以模拟该生态系统 10 年的情况。解释模拟如何帮助科学家预测结果，以及随机数生成器在使模型更现实方面可以发挥什么作用。

• ths - Predation); Foxes = (Previous Foxes - Fox Deaths + Fox Births from predation) if births depend on food.
• 电子表格可以设有年份、兔子、狐狸、兔子出生数、狐狸死亡数、捕食量等列。公式：兔子 =（前一年兔子 + 兔子出生数 - 捕食量）；狐狸 =（前一年狐狸 - 狐狸死亡数 + 捕食带来的狐狸出生数）如果出生取决于食物。
• Simulations allow scientists to test "what if" scenarios, such as introducing a disease or changing hunting rules, without real-world consequences. They can observe whether an ecosystem is stable or leads to extinction.
• 模拟使科学家能够在没有现实后果的情况下测试"如果……会怎样"的情景，例如引入疾病或改变狩猎规则。他们可以观察生态系统是稳定的还是会走向灭绝。
• Random number generators introduce variability (e.g., weather affecting birth rate). This makes simulations more lifelike and highlights the probabilistic nature of complex systems.
• 随机数生成器引入可变性（例如，天气影响出生率）。这使得模拟更逼真，并凸显了复杂系统的概率性质。

---

11. Sorting Algorithms and Physical Education | 排序算法与体育

In PE class, students are often asked to arrange themselves in order of height. This is an example of a sorting algorithm in action. Compare two methods: bubble sort (neighbours compare and swap) and insertion sort (each student finds the correct place in an already sorted line). A group of 8 students perform these methods while the teacher counts the number of comparisons and swaps. Explain which algorithm is more efficient in terms of comparisons, and why computer scientists measure the time complexity of algorithms. How does this activity help understand the importance of efficient algorithms in large-scale computing tasks, like ranking athletes' performances?

在体育课上，学生经常被要求按身高顺序排队。这是排序算法实际操作的一个例子。比较两种方法：冒泡排序（邻居比较并交换）和插入排序（每个学生在已排好的队伍中找到自己正确的位置）。一组 8 名学生执行这些方法，老师统计比较和交换的次数。解释哪种算法在比较次数上更高效，以及为什么计算机科学家要衡量算法的时间复杂度。这个活动如何帮助理解高效率算法在大规模计算任务（如对运动员表现排名）中的重要性？

• Bubble sort repeatedly passes through the list, comparing adjacent items and swapping if they are in the wrong order. The number of comparisons for n items is roughly n²/2. For 8 students, around 28 comparisons in the worst case.
• 冒泡排序反复遍历列表，比较相邻项并在顺序错误时交换。对于 n 个项目，比较次数大约为 n²/2。对于 8 个学生，最坏情况下约为 28 次比较。
• Insertion sort builds the sorted line one student at a time; each new student is compared with those already sorted from right to left. Average comparisons are about n²/4—fewer than bubble sort.
• 插入排序一次构建一个有序队列；每个新学生从右向左与已经排好的学生比较。平均比较次数约为 n²/4——少于冒泡排序。
• Computer scientists use Big O notation to describe efficiency. Bubble sort is O(n²); quicksort is O(n log n). When processing millions of data points, an O(n²) algorithm would be impractically slow, while O(n log n) runs in seconds. This connects physical activities to the reasoning behind algorithm design.
• 计算机科学家使用大 O 表示法来描述效率。冒泡排序是 O(n²)；快速排序是 O(n log n)。当处理数百万个数据点时，O(n²) 算法会慢得不切实际，而 O(n log n) 只需数秒。这将体育活动与算法设计背后的推理联系起来。

---

12. E-safety and Citizenship: Cross-curricular Discussion | 网络安全与公民教育：跨学科讨论

In citizenship class, students debate online privacy and digital footprints. One scenario: a friend posts an embarrassing photo of you without permission. You must decide how to respond using your knowledge of social media reporting tools, data protection principles, and respectful communication. Write a short guide that combines computing knowledge (how photos can be copied and spread, reporting mechanisms, terms of service) with citizenship skills (empathy, conflict resolution, and rights). Explain how understanding the technology behind social media empowers you to make better personal and ethical decisions.

在公民教育课上，学生们辩论网络隐私和数字足迹。一个情境是：一位朋友未经允许发布了一张你的尴尬照片。你必须利用对社交媒体举报工具、数据保护原则和尊重沟通的了解，来决定如何回应。编写一份简短指南，结合计算知识（照片如何被复制和传播、举报机制、服务条款）与公民技能（同理心、冲突解决方式和权利）。解释理解社交媒体背后的技术如何使你能够做出更好的个人和伦理决策。

• Computing knowledge: Once a photo is online, it can be downloaded, screenshotted, and reuploaded by anyone, even if the original post is deleted. Using social media's "report" feature triggers algorithmic review, but results are not instant. Understanding that metadata (like location) may be embedded in the photo is crucial.
• 计算知识：一旦照片上网，任何人都可以下载、截图和重新上传，即使原始帖子被删除。使用社交媒体的"举报"功能会触发算法审核，但结果不是即时的。理解照片可能嵌入了元数据（如位置）至关重要。
• Citizenship skills: Calmly talk to the friend first—they may not have realised the harm. If that fails, use platform tools to request removal and involve a trusted adult. Always respect others' privacy yourself.
• 公民技能：首先冷静地与朋友交谈——他们可能没有意识到伤害。如果不行，使用平台工具请求删除，并告知信任的成年人。自己也要始终尊重他人的隐私。
• Empowered with technical and ethical understanding, you can navigate digital spaces safely and help create a respectful online community.
• 掌握技术和伦理理解，你就能安全地驾驭数字空间，并帮助创建一个尊重他人的在线社区。

---

Published by TutorHao | CCEA Computer Science Revision Series | aleveler.com

更多咨询请联系16621398022（同微信）