📚 Year 9 WJEC Computer Science Cross-Curricular Integrated Question Training | Year 9 WJEC 计算机：跨学科综合题型训练
In the WJEC Year 9 Computer Science curriculum, students often encounter questions that combine concepts from computing with other subjects such as mathematics, science, geography, and even the arts. These cross-curricular integrated questions are designed to test not only your programming or hardware knowledge, but also your ability to apply computational thinking in real-world, interdisciplinary contexts. This article provides a structured training approach, complete with example scenarios, step-by-step problem-solving strategies, and practice tasks to help you excel in this unique question style.
在 WJEC Year 9 计算机科学课程中，学生经常会遇到将计算概念与数学、科学、地理甚至艺术等其他学科相结合的题目。这些跨学科综合题型不仅考察你的编程或硬件知识，还测试你在真实世界、跨学科情境中运用计算思维的能力。本文提供结构化的训练方法，包括示例情境、逐步解题策略和练习任务，帮助你在这类独特题型中脱颖而出。
1. Understanding Cross-Curricular Integrated Questions | 理解跨学科综合题型
Cross-curricular questions in WJEC Computer Science are not separate from the core syllabus; they embed computing skills within scenarios drawn from other disciplines. For instance, a question may ask you to write a simple algorithm to calculate the average temperature from a science experiment, or to design a logic circuit that mimics a decision-making process in a business context. The key is to recognise the computing concept required (e.g., variables, loops, logic gates) and then apply it accurately to the given subject matter. These questions assess your ‘transferable skills’, a major focus in modern education systems.
WJEC 计算机科学中的跨学科题目并非脱离核心大纲；它们将计算技能嵌入到其他学科的情境中。例如，一道题可能要求你编写一个简单算法来计算科学实验中的平均温度，或者设计一个逻辑电路来模拟商业决策过程。关键在于识别所需的计算概念（如变量、循环、逻辑门），然后准确地将其应用到给定的主题中。这类题目考查你的“可迁移技能”，这是现代教育体系的重要焦点。
2. Computer Science Meets Mathematics: Binary and Boolean Logic | 计算机科学遇见数学：二进制与布尔逻辑
Mathematics is the most natural partner of computer science. Binary number conversions, binary addition, and boolean algebra are frequently tested through mathematical problems. For example, you might be given two decimal numbers from a financial calculation and asked to convert them to 8-bit binary, then add them together to detect an overflow error. Alternatively, a question could present a logic statement like ‘If the temperature is above 30°C AND the humidity is less than 40%, activate the cooling system’, and you need to draw the corresponding AND gate truth table. Practice by solving equations where you represent variables as binary values and apply logical operations.
数学是计算机科学最天然的伙伴。二进制转换、二进制加法以及布尔代数经常通过数学问题来考查。例如，你可能会从财务计算中得到两个十进制数，要求你将其转换为8位二进制数，然后将它们相加以检测溢出错误。或者，一道题可能给出一个逻辑陈述，如“如果温度高于30°C 且 湿度低于40%，则激活冷却系统”，你需要画出相应的与门真值表。通过将变量表示为二进制值并应用逻辑运算来解方程进行练习。
Example task: Convert 45 and 27 into binary, then perform binary addition. Verify the result in decimal. Identify if an overflow occurs in an 8-bit system. 示例任务： 将45和27转换为二进制，然后进行二进制加法。用十进制验证结果。判断在8位系统中是否发生溢出。
3. Computer Science Meets Science: Sensors and Data Logging | 计算机科学遇见科学：传感器与数据采集
Science experiments rely heavily on data collection. In WJEC questions, you might encounter a scenario where a microcontroller (like a BBC micro:bit or Arduino) uses a temperature sensor and a light sensor to monitor a plant’s environment. The question could ask you to write pseudocode that reads the sensor values at regular intervals and stores them in an array for later analysis. Understanding analog-to-digital conversion, sampling rates, and data types (integer, float) is crucial here. You may also need to explain how computing enhances scientific accuracy and repeatability.
科学实验严重依赖数据收集。在 WJEC 的题目中，你可能会遇到一个场景：一个微控制器（如 BBC micro:bit 或 Arduino）使用温度传感器和光线传感器来监测植物环境。问题可能要求你编写伪代码，定期读取传感器数值并将其存储在数组中供后续分析。理解模数转换、采样率以及数据类型（整数、浮点数）在这里至关重要。你可能还需要解释计算如何提高科学的准确性和可重复性。
Key vocabulary: analog signal, digital signal, resolution, polling, data logger. 关键词汇： 模拟信号、数字信号、分辨率、轮询、数据记录器。
4. Computer Science Meets Geography: GIS and Data Analysis | 计算机科学遇见地理：GIS 与数据分析
Geographic Information Systems (GIS) combine maps with databases. A typical Year 9 task might involve plotting the locations of renewable energy sources on a digital map using given coordinates. From a computational perspective, you would need to handle latitude/longitude values in a 2D array or a list of tuples, then write a sorting algorithm to find the nearest site to a given point. This introduces distance calculation formulas (such as the Haversine formula, though simplified versions use Euclidean distance). These problems build geographical awareness alongside algorithmic thinking.
地理信息系统（GIS）将地图与数据库结合起来。一个典型的 Year 9 任务可能涉及使用给定坐标在数字地图上绘制可再生能源站点的位置。从计算角度来看，你需要处理二维数组或元组列表中的经纬度值，然后编写排序算法来找到距离给定点最近的站点。这引入了距离计算公式（如Haversine公式，尽管简化版使用欧几里得距离）。这些问题在培养算法思维的同时，也建立了地理意识。
Practice question: Given a dataset of city names and their coordinates (x, y), write a program that asks the user for a target coordinate and outputs the nearest city. 练习题： 给定一个城市名称及其坐标 (x, y) 的数据集，编写一个程序，要求用户输入目标坐标并输出最近的城市。
5. Computer Science Meets Business: Spreadsheet Modelling | 计算机科学遇见商业：电子表格建模
WJEC often includes questions about modelling using spreadsheets, which is a core business application. You might be asked to design a spreadsheet to calculate profit margins based on sales data, applying conditional formatting to highlight high-profit products. The computing side involves understanding cell references (absolute vs. relative), basic functions (SUM, AVERAGE, IF), and perhaps simple macros or scripts to automate repetitive tasks. This links directly to the computational thinking pillar of ‘abstraction’ — building a simplified model of a real business process.
WJEC 经常包括使用电子表格建模的题目，这是个核心商业应用。你可能会被要求设计一个电子表格，根据销售数据计算利润率，并应用条件格式突出高利润产品。计算机部分涉及理解单元格引用（绝对引用与相对引用）、基本函数（SUM, AVERAGE, IF），或许还有简单的宏或脚本来自动化重复任务。这直接联系到计算思维中的“抽象”支柱——构建真实商业流程的简化模型。
Formula example: =IF(B2−C2>D2, “High”, “Low”) where B2 is revenue, C2 is cost, D2 is threshold. 公式示例： =IF(B2−C2>D2, “高”, “低”)，其中B2为收入，C2为成本，D2为阈值。
6. Computer Science Meets English: Technical Documentation | 计算机科学遇见英语：技术文档写作
Being able to explain your code clearly is a vital skill. Cross-curricular tasks with English involve writing user guides, comments within code, or describing an algorithm in plain language. You must structure your writing logically, use precise terminology, and consider your audience. For instance, after designing a program, you might be asked to ‘write a paragraph explaining how your program uses a linear search to find a name in a list, targeting a non-technical reader’. This tests both your understanding of the algorithm and your communication skills.
能够清晰地解释你的代码是一项至关重要的技能。与英语结合的跨学科任务涉及编写用户指南、代码注释，或者用通俗语言描述算法。你必须逻辑清晰地组织你的写作，使用精准的术语，并考虑读者对象。例如，在完成一个程序设计后，你可能会被要求“写一段话，解释你的程序如何利用线性搜索在列表中查找一个姓名，面向非技术读者”。这既考察你对算法的理解，也考察你的沟通技巧。
Tip: Always use the STAR technique (Situation, Task, Action, Result) to structure your technical descriptions. 技巧： 始终使用 STAR 技巧（情境、任务、行动、结果）来组织你的技术描述。
7. Computer Science Meets Art: Pixel Art and Image Representation | 计算机科学遇见艺术：像素艺术与图像表示
Image representation is a crossover with art and design. A question might show a small black-and-white pixel grid and ask you to encode it as a binary bitmap, or to decode a given run-length encoding (RLE) string back into an image pattern. You may also explore how colour depth affects file size and visual quality, linking to digital art projects. This creative angle helps visual learners grasp data storage concepts. Working with pixel coordinates reinforces matrix (2D array) manipulation in programming.
图像表示是与艺术和设计交叉的领域。一道题可能展示一个小的黑白像素网格，要求你将其编码为二进制位图，或者将给定的游程编码（RLE）字符串解码回图像图案。你还可能探索色彩深度如何影响文件大小和视觉质量，与数字艺术项目相联系。这个创造性的角度帮助视觉型学习者理解数据存储概念。处理像素坐标也强化了编程中的矩阵（二维数组）操作。
Activity: Create a 5×5 grid pattern of a simple shape (e.g., heart) and represent it using run-length encoding. Then swap with a partner to decode. 活动： 创建一个简单形状（如心形）的5×5网格图案，并用游程编码表示。然后与同伴交换进行解码。
8. Integrated Problem-Solving Strategy | 综合问题解决策略
When faced with an integrated question, follow these steps: Step 1 – Read the scenario carefully and underline the subject context (science, business, etc.). Step 2 – Identify the computing concept being assessed (e.g., selection statement, data structure). Step 3 – Extract the relevant data from the text and convert it into a usable format (e.g., variables, truth values). Step 4 – Build the solution step by step, applying the correct syntax or diagram conventions. Step 5 – Review your answer against the original scenario to ensure it fits the real-world constraints. This systematic approach reduces anxiety and improves accuracy.
面对综合题型时，请遵循以下步骤：第1步 – 仔细阅读情境，划出学科背景（科学、商业等）。第2步 – 识别所考查的计算概念（如选择语句、数据结构）。第3步 – 从文本中提取相关数据，并将其转换为可用的格式（如变量、真值）。第4步 – 逐步构建解决方案，应用正确的语法或图表规范。第5步 – 对照原始情境检查你的答案，确保其符合真实世界的约束条件。这种系统性的方法可减少焦虑并提高准确性。
9. Practice Integrated Question 1: Science & Binary Logic | 综合练习题一：科学与二进制逻辑
Scenario: A greenhouse has two sensors: Sensor A (light level) outputs a digital 1 if light is sufficient, and Sensor B (soil moisture) outputs a digital 1 if soil is dry. An automatic irrigation system should activate (output 1) only when light is sufficient AND soil is dry. (a) Draw the logic gate diagram for this system. (b) Write the truth table. (c) Write a Python if-statement that implements this logic assuming ‘light’ and ‘moisture’ are Boolean variables.
场景： 一个温室有两个传感器：传感器A（光照水平）如果光照充足则输出数字1，传感器B（土壤湿度）如果土壤干燥则输出数字1。自动灌溉系统应仅在光照充足且土壤干燥时激活（输出1）。(a) 绘制此系统的逻辑门图。(b) 写出真值表。(c) 假设 ‘light’ 和 ‘moisture’ 是布尔变量，编写一个 Python if 语句来实现此逻辑。
Model answer (c): if light and moisture: activate_pump(). Even in pseudocode, the AND relationship is clearly expressed. This question blends environmental science with digital logic.
参考答案 (c)： if light and moisture: activate_pump()。即使在伪代码中，AND 关系也被清晰表达。该题将环境科学与数字逻辑融合在一起。
10. Practice Integrated Question 2: Business & Spreadsheet Functions | 综合练习题二：商业与电子表格函数
Scenario: A mobile shop records daily sales in a spreadsheet. Column A contains product names, Column B contains the number of units sold, and Column C contains the unit price. (a) Write a formula for cell D2 to calculate the revenue for the first product (=B2*C2). (b) Using an appropriate function, write a formula to calculate the total revenue if there are 20 products listed in rows 2 to 21. (c) Suggest how a nested IF could be used in Column E to assign a ‘Restock’ flag if units sold are 0, ‘Low’ if sold between 1 and 5, and ‘Good’ otherwise. (d) Name one computational thinking technique applied in this model.
场景： 一家手机店在电子表格中记录每日销售数据。A列包含产品名称，B列包含销售数量，C列包含单价。(a) 为单元格D2编写公式，以计算第一个产品的收入（=B2*C2）。(b) 使用适当的函数，编写一个公式来计算总营收，假设第2行到第21行有20个产品。(c) 建议如何在E列中使用嵌套 IF 来分配一个标志：如果销售数量为0则显示“补货”，如果在1到5之间则显示“低”，否则显示“良好”。(d) 指出在这个模型中应用的一种计算思维技巧。
Answers: (b) =SUM(D2:D21) or =SUMPRODUCT(B2:B21, C2:C21). (c) =IF(B2=0, “Restock”, IF(B2<=5, "Low", "Good")). (d) Abstraction (modelling a real business) or decomposition (breaking the revenue calculation into parts). Such questions show how spreadsheets extend into real commerce.
答案： (b) =SUM(D2:D21) 或 =SUMPRODUCT(B2:B21, C2:C21)。(c) =IF(B2=0, “补货”, IF(B2<=5, "低", "良好"))。(d) 抽象（对真实业务建模）或分解（将营收计算拆分为部分）。这类题目展示了电子表格如何延伸到真实商业中。
11. Developing Your Own Cross-Curricular Projects | 开发你自己的跨学科项目
To truly master these question types, create mini-projects that mix subjects. For example, use your computer science skills to plot the growth of a plant you measure in biology class, with a program that calculates weekly averages and draws a simple text-based graph using asterisks. Or build a budget calculator that links to your personal finance unit in PSHE. The WJEC examiners value creativity and the ability to see connections. Document each project with a short report explaining the computing concepts applied and the subject knowledge used.
要真正掌握这类题型，可以创建混搭学科的迷你项目。例如，利用你的计算机科学技能来绘制你在生物课上测量的植物生长图，编写一个程序计算每周平均值，并用星号画出简单的文本图表。或者构建一个预算计算器，与你 PSHE 课上的个人理财单元相联系。WJEC 考官看重创造力和看到联系的能力。为每个项目撰写一份简短报告，说明所应用的计算概念和所运用的学科知识。
12. Common Pitfalls and How to Avoid Them | 常见误区及如何避免
Students often lose marks by ignoring the subject context. For example, writing a program that works mathematically but uses unrealistic values for a science experiment (like negative time). Another pitfall is confusing data units: using millimetres instead of metres in a geography task. Always check your units, the plausibility of your outputs, and whether you have answered the specific question rather than providing a generic computing solution. Practice reading mark schemes to see how context marks are awarded.
学生常因忽略学科背景而失分。例如，编写的程序在数学上成立，但用于科学实验时却使用了不切实际的数值（如负时间）。另一个误区是混淆数据单位：在地理任务中使用了毫米而非米。务必检查单位、输出的合理性，以及你是否回答了特定问题而非给出了一个通用的计算解决方案。通过练习阅读评分方案，了解背景分是如何给出的。
Published by TutorHao | WJEC Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导