📚 Year 10 CCEA Computer Science: Interdisciplinary Integrated Question Practice | CCEA 10年级计算机：跨学科综合题型训练
In Year 10 of the CCEA Computer Science course, students are expected not only to master programming and theory but also to apply computational thinking across different subject boundaries. This article presents a series of interdisciplinary question sets that blend computing with mathematics, science, geography, and design, closely mirroring the style of CCEA examination tasks. Through these examples, learners will strengthen their ability to transfer skills, recognise patterns, and construct well-reasoned solutions in unfamiliar contexts – a key requirement for top marks.
在 CCEA 10年级计算机课程中，学生不仅需要掌握编程与理论知识，还要能够将计算思维应用到不同学科领域。本文提供一系列跨学科综合题型，融合计算机与数学、科学、地理及设计等内容，贴近 CCEA 考试风格。通过这些例题，学习者将增强技能迁移、模式识别以及在陌生情境中构建合理解答的能力，这正是取得高分的关键要求。
1. Computational Thinking in Mathematics: Algorithmic Flowcharts | 数学中的计算思维：算法流程图
A common CCEA question asks students to design a flowchart or pseudocode solution for a mathematical problem, such as finding the highest common factor (HCF) of two numbers. You might be given two inputs and asked to implement Euclid's algorithm. Start by initialising variables, then use a loop that continues until the remainder is zero. Translate the logic step by step into flowchart symbols: ovals for start/end, parallelograms for input/output, rectangles for processes, and diamonds for decisions. Pay attention to the terminating condition – a common pitfall is creating an infinite loop when the second number becomes zero first. Always dry-run your solution with test data like (48, 18) to verify the output is 6.
CCEA 常见的一道题要求学生为数学问题设计流程图或伪代码解法，例如找出两个数的最大公因数（HCF）。题目可能给出两个输入值，要求实现欧几里得算法。首先要初始化变量，然后使用一个循环，直到余数为零。将逻辑逐步转换为流程图符号：椭圆表示开始/结束，平行四边形表示输入/输出，矩形表示处理过程，菱形表示判断。要特别注意终止条件——当第二个数先变为零时，常见的错误是进入无限循环。务必用测试数据如(48, 18)进行手工执行，验证输出结果为6。
2. Binary Representation and Digital Electronics | 二进制表示与数字电子学
nsor reading into 8-bit binary, then use that binary pattern to set switches (1 = on, 0 = off). For instance, if a temperature sensor outputs the value 170, its binary is 10101010. Using AND, OR, and NOT gates, construct a logic circuit that lights a warning LED when the temperature exceeds 160 (binary 10100000). Draw a truth table for the comparator logic and identify the minimal Boolean expression. Remember that A AND B compares corresponding bits; using a four-bit magnitude comparator can be simplified if you split the 8-bit number into high and low nibbles. This type of integrated question tests both your understanding of binary and basic electronics, which is typical of CCEA’s applied approach.
CCEA 试卷经常将二进制数与简单的物理概念联系起来，例如控制 LED 电路的逻辑门。你可能需要将十进制的传感器读数转换为 8 位二进制，然后使用该二进制模式来设置开关（1 = 开，0 = 关）。例如，温度传感器输出值为 170，其二进制是 10101010。利用与门、或门和非门，构建一个逻辑电路，当温度超过 160（二进制 10100000）时点亮警示 LED。为比较器逻辑绘制真值表，并找出最简布尔表达式。记住 A AND B 是比较对应位的；如果分成高低四位，可以使用四位幅度比较器简化电路。这类综合题目既测试二进制理解，也测试基础电子学，体现了 CCEA 应用导向的风格。
3. Data Compression and Multimedia File Sizes | 数据压缩与多媒体文件大小
hysics waveforms. Calculate uncompressed file size: for audio, size = sample rate (Hz) × bit depth × duration (s) × channels. For example, a 44.1 kHz, 16-bit stereo recording lasting 3 minutes takes 44,100 × 16 × 180 × 2 = 253,008,000 bits ≈ 30.2 MB. Then explore lossless compression: run-length encoding on a bitmap image. Given a row of pixels alternating black and white, encode as (N, colour) pairs. If an image has large areas of identical colour, compression ratio improves. Discuss why lossy MP3 compression removes frequencies inaudible to humans, linking to biology (human hearing range 20 Hz – 20 kHz). This cross-curricular link deepens understanding.
音频和图像文件大小的计算题在 CCEA 试卷中频频出现，融合了计算机、数学以及对物理波形的理解。计算未压缩文件大小：对于音频，大小 = 采样率（Hz）× 位深度 × 时长（秒）× 声道数。例如，44.1 kHz、16 位立体声录制 3 分钟的音频，大小为 44,100 × 16 × 180 × 2 = 253,008,000 比特 ≈ 30.2 MB。然后探索无损压缩：位图图像的游程编码。给定一行黑白交替的像素，编码为 (数量, 颜色) 对。如果图像有大面积相同颜色，压缩比就会提高。讨论为什么有损 MP3 压缩会删除人耳听不到的频率，这联系到生物学（人类听觉范围 20 Hz – 20 kHz）。这种跨学科链接有助于加深理解。
4. Databases and Geographic Information Systems | 数据库与地理信息系统
ructure: tblEarthquakes with fields EpicentreID (text), Magnitude (decimal), DepthKm (integer), Latitude, Longitude, and DateTime. Create SQL queries to retrieve all quakes of magnitude ≥ 5.0 within the last 48 hours, sorted by proximity to a given coordinate. Use calculated fields to derive distance from a seismometer to the epicentre using the Euclidean distance formula: √((lat₂−lat₁)² + (long₂−long₁)²). Normalise the data to 3NF to avoid update anomalies. Such a task blends database normalisation with spatial awareness, reinforcing both computing and geographical data analysis skills.
在 CCEA 中，数据库设计问题常常置于地理情境中，例如为地震监测构建一个 GIS 系统。定义表结构：tblEarthquakes，字段包括 EpicentreID（文本）、Magnitude（小数）、DepthKm（整数）、Latitude、Longitude 和 DateTime。编写 SQL 查询，检索过去 48 小时内震级 ≥ 5.0 的所有地震，并按与给定坐标的接近程度排序。使用计算字段，通过欧几里得距离公式推导地震仪到震中的距离：√((lat₂−lat₁)² + (long₂−long₁)²)。将数据规范化为第三范式，以避免更新异常。此类任务将数据库规范化与空间感知融合在一起，强化了计算机和地理数据分析技能。
5. Algorithmic Sorting and Biological Classification | 算法排序与生物分类学
Sorting algorithms are a core CCEA topic that can be intertwined with biology. Consider a dataset of bacterial species with attributes: growth rate at 37 °C, antibiotic resistance score, and genome length. Apply bubble sort to order organisms by resistance score in descending order, showing each pass until no swaps are needed. Then discuss why insertion sort might be preferred if data is nearly sorted – for example, a previously sorted list gets a few new entries daily. Draw parallels to phylogenetic tree construction: hierarchical clustering algorithms group species based on genetic similarity, which is essentially a sorting and comparison process. Explain how a binary search on a sorted array of species names provides O(log n) lookup, crucial for bioinformatics databases containing millions of records.
排序算法是 CCEA 的核心主题，可以与生物学结合。考虑一个细菌物种数据集，属性包括：37 °C 下的增长率、抗生素抗性评分和基因组长度。应用冒泡排序，按抗性评分降序排列，展示每一趟直到无需交换为止。然后讨论，如果数据几乎有序——例如已排序的列表每天添加少量新条目——为什么插入排序更可取。将其与系统发育树的构建进行类比：层次聚类算法根据遗传相似性对物种进行分组，本质上就是一个排序和比较的过程。解释二分查找如何在已排序的物种名称数组上提供 O(log n) 查找性能，这对于包含数百万条记录的生物信息学数据库至关重要。
6. Encryption, History, and Ethical Hacking | 加密、历史与道德黑客
CCEA values the historical and ethical dimensions of computing. Examine the Caesar cipher, dating back to Roman times, and its vulnerability to brute-force attacks due to only 25 possible shifts. Write a Python-style pseudocode to encrypt and decrypt a message with a given key. Then introduce the Vigenère cipher, which uses a keyword to modulate shifts, making frequency analysis harder. Link to World War II and the Enigma machine: explain how computing theory was used to crack codes, emphasising Alan Turing's contribution. Pose ethical questions: what are the similarities and differences between ethical hacking and cybercrime? Students must be able to discuss the Computer Misuse Act and its three offences, assessing whether a penetration tester acting with permission could ever break the law.
CCEA 看重计算机的历史和伦理维度。研究回溯到古罗马时期的凯撒密码，由于只有 25 种可能的偏移，它容易受到暴力攻击。编写类似 Python 的伪代码，用给定密钥对消息进行加密和解密。然后引入维吉尼亚密码，它使用关键词来调节偏移，让频率分析变得更困难。联系二战和恩尼格玛密码机：解释计算机理论如何被用来破解密码，着重介绍艾伦·图灵的贡献。提出伦理问题：道德黑客与网络犯罪有什么异同？学生必须能够讨论《计算机滥用法案》及其三种罪行，评估获得许可的渗透测试员是否仍可能触犯法律。
7. Networks, Graph Theory, and Transport Geography | 网络、图论与交通地理学
Computer networks can be modelled using graph theory, a mathematical concept. Represent a school network with nodes (switches, routers, servers) and edges (Ethernet cables) with weights indicating latency in milliseconds. Apply Dijkstra's shortest path algorithm to find the fastest route from a classroom PC to the file server. Use a table with columns: Node, Shortest distance from start, Previous node, and Visited. Update step by step. Extend the idea to a transport network: Google Maps uses similar algorithms to calculate driving directions, dynamically adjusting for traffic – a practical application of priority queue data structures. Cross-reference with geography: how do physical barriers like mountains or rivers affect network topology and the choice between fibre optic, microwave, or satellite links?
计算机网络可以用数学中的图论来建模。用节点（交换机、路由器、服务器）和边（以太网电缆）表示一个学校网络，权重为以毫秒为单位的延迟。应用迪杰斯特拉最短路径算法，找出从教室电脑到文件服务器的最快路径。使用一个包含列：节点、离起点的最短距离、前一节点、已访问的表，逐步更新。将这一思想扩展到交通网络：谷歌地图使用类似算法计算驾驶路线，并根据交通状况动态调整——这是优先级队列数据结构的实际应用。与地理学交叉：山脉或河流等物理障碍如何影响网络拓扑结构，以及光纤、微波或卫星链路的选择？
8. Logic Gates and Mechanical Control Systems | 逻辑门与机械控制系统
M), and light level (L). A heater switches on when temperature is low AND moisture is adequate; an irrigation pump activates when moisture is low AND it is not too hot. Express these rules using Boolean algebra: Heater = (NOT T) AND M; Pump = (NOT M) AND T. Draw the composite logic circuit using AND, OR, and NOT gates. Build a truth table for three inputs and verify the outputs. Then discuss how a microcontroller (like an Arduino) could be programmed in C or Python-style pseudocode to read analogue sensor values, convert them to digital signals using an ADC, and implement the same logic. This merges electronics, physics of environmental control, and programming.
CCEA 中一个经典的跨学科题目涉及为温室设计控制系统。传感器监测温度 (T)、土壤湿度 (M) 和光照水平 (L)。当温度低且湿度足够时，加热器开启；当湿度低且温度不高时，灌溉泵启动。用布尔代数表示这些规则：Heater = (NOT T) AND M; Pump = (NOT M) AND T。使用与门、或门和非门绘制组合逻辑电路。为三个输入建立真值表，并验证输出。然后讨论如何用 C 语言或类 Python 伪代码为微控制器（如 Arduino）编程，读取模拟传感器数值，通过 ADC 转换为数字信号，并实现相同的逻辑。这融合了电子学、环境控制的物理原理和编程。
9. Software Development Life Cycle and Product Design | 软件开发生命周期与产品设计
In CCEA, the systems lifecycle is often examined through a design project scenario. Imagine developing a mobile app to help students revise. Apply the stages: feasibility study (comparing cost, time, technical constraints), requirement analysis (gathering user stories via interviews), design (wireframes, UI mockups, algorithm design), implementation (coding in Python/Kivy), testing (unit, integration, alpha/beta), deployment, and maintenance. Link to design & technology: prototyping with iterative feedback mirrors the design-make-evaluate cycle. Discuss how choosing the right development methodology (waterfall vs agile) depends on project scope and client involvement. Use a Gantt chart to schedule tasks, emphasising dependencies – a project management tool originally from engineering.
在 CCEA 中，系统生命周期常通过一个设计项目场景来考查。设想开发一款帮助学生复习的移动应用。应用各个阶段：可行性研究（比较成本、时间和技术限制）、需求分析（通过访谈收集用户故事）、设计（线框图、UI 模型、算法设计）、实施（用 Python/Kivy 编码）、测试（单元、集成、alpha/beta）、部署和维护。联系设计与技术：通过迭代反馈进行原型设计，反映了设计-制作-评估的循环。讨论如何根据项目范围和客户参与度选择正确的开发方法（瀑布模型 vs 敏捷模型）。使用甘特图排定任务，并强调任务之间的依赖性——这是一种源自工程领域的项目管理工具。
10. Programming, Data Analysis, and Sport Science | 编程、数据分析与运动科学
Examination questions can present data from a wearable fitness tracker. Write a program that inputs an array of heart rate readings (integers) taken every second during a 5-minute run. Calculate and output the average heart rate, maximum, minimum, and the number of seconds the heart rate was above 160 bpm (anaerobic threshold). Use a loop to traverse the array, maintaining running totals. Extend the code to detect anomalies: if any reading is below 30 or above 220, flag it as a sensor error and exclude it from calculations. Incorporate basic statistics: the interquartile range could identify outliers. This task blends computer science with physiology, mirroring real-world sport analytics. Understanding data validation and cleaning is essential for reliable results.
考试题目可以给出可穿戴健身追踪器的数据。编写一个程序，输入一个存储每秒钟心率读数（整数）的数组，数据取自一次 5 分钟跑步。计算并输出平均心率、最大值、最小值以及心率超过 160 bpm（无氧阈值）的秒数。使用循环遍历数组，同时维护累加值。扩展代码以检测异常：如果某读数低于 30 或高于 220，将其标记为传感器错误并从计算中排除。融入基础统计学：四分位距可用于识别异常值。这一任务融合了计算机科学与生理学，反映了现实世界的运动分析。理解数据验证和清洗对于获得可靠结果至关重要。
11. Environmental Modelling and Simulation | 环境建模与仿真
CCEA encourages students to understand modelling. Create a simple cellular automaton to simulate the spread of a forest fire. Use a 2D grid where each cell is either tree, fire, or empty. Rules: a tree catches fire if any of its eight neighbours is on fire; a burning cell becomes empty in the next generation. Write pseudocode that iterates generations until no fire remains. Track the percentage of forest burned. Connect to geography and environmental science: discuss how wind direction and humidity (as additional parameters) could be modelled by adjusting neighbour influence. A real-world application is predicting the impact of climate change on wildfire frequency. Such simulations rely heavily on random number generation and probability, linking to statistics.
CCEA 鼓励学生理解建模。创建一个简单的元胞自动机，模拟森林火灾的蔓延。使用一个二维网格，每个单元可以是树、火或空地。规则：如果一个树的八个相邻单元中有一个着火，该树就会着火；燃烧的单元在下一代会变为空地。编写伪代码，迭代各个世代，直到没有火为止。记录被烧毁森林的百分比。联系地理和环境科学：讨论如何通过调整邻居影响力，将风向和湿度（作为额外参数）纳入模型。现实世界的一个应用是预测气候变化对野火频率的影响。这类模拟严重依赖随机数生成和概率，从而与统计学相连。
12. Review, Reflect, and Connect the Dots | 复习、反思与融会贯通
ed question, first identify the computing concept being tested (algorithm, data representation, logic, etc.) and then note which other subject context is provided. Break the problem into smaller parts, use clear annotations on diagrams, and write precise pseudocode with comments. Practice past paper questions that combine domains: a network question may require calculating file transfer time, which needs knowledge of data units and physics (time = size ÷ bandwidth). The more you practise switching lenses between subjects, the quicker you will recognise patterns. Remember that CCEA values real-world scenarios, so building a portfolio of integrated projects – like a weather station programmed in Python – will solidify understanding for both exams and coursework.
巩固你探索过的所有跨学科联系。高质量的 CCEA 答案总是展现出清晰的关联。在解答综合题目时，首先识别所考查的计算机概念（算法、数据表示、逻辑等），然后注意提供的其他学科情境。将问题分解为小部分，在图表上做清晰注释，并编写带注释的精确伪代码。练习融合多个领域的往年真题：一道网络题可能要求计算文件传输时间，这需要数据单位和物理知识（时间 = 大小 ÷ 带宽）。你越多练习在不同学科视角之间切换，就能越快识别模式。记住 CCEA 看重真实世界场景，因此建立一个综合项目作品集——例如用 Python 编程的气象站——将巩固你应对考试和课程作业的理解。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图