📚 KS3 WJEC Computer Science: Interdisciplinary Integrated Question Training | KS3 WJEC 计算机：跨学科综合题型训练
In Key Stage 3 computer science, learning comes alive when we connect coding and computational thinking with other subjects like maths, art, music, and science. This integrated question training helps you practise real-world problems that mix digital skills with cross-curricular knowledge, just as you would experience in project-based assessments. Each section below presents a scenario and a set of tasks designed to strengthen your ability to analyse, design, and create solutions that span multiple disciplines. Work through the examples carefully, and you will build a flexible, creative mindset that is at the heart of the WJEC curriculum.
在KS3计算机科学中，当我们将编程和计算思维与数学、艺术、音乐和科学等其他学科联系起来时，学习才真正变得生动起来。这种跨学科综合题型训练帮助你练习将数字技能与跨课程知识融合在一起的真实问题，就像你在项目式评估中会经历的那样。下面的每个部分都呈现了一个场景和一组任务，旨在加强你分析、设计和创建跨学科技能解决方案的能力。仔细完成这些例题，你将培养出一种灵活的、创造性的思维方式，这正是WJEC课程的核心。
1. Computing and Mathematics: Binary and Number Bases | 计算机与数学：二进制与数基
Computers store all data using the binary number system, which has only two digits: 0 and 1. Understanding how to convert between decimal (base‑10) and binary (base‑2) is a fundamental skill that reinforces place value and powers of two – a clear link to KS3 mathematics. Each binary digit (bit) represents an increasing power of 2, starting from 2⁰ on the right.
计算机使用二进制数字系统存储所有数据，该系统只有两个数字：0和1。理解如何在十进制（基数为10）和二进制（基数为2）之间转换是一项基本技能，它强化了位值和2的幂的概念——这与KS3数学有明显的联系。每个二进制数字（位）代表一个递增的2的幂，从最右边的2⁰开始。
Let' s a 1, leaving 13. The next power is 8 (2³), so another 1, leaving 5. 4 (2²) gives a 1, leaving 1. 2 (2¹) is too large, so a 0. Finally, 1 (2⁰) gives a 1. Reading from the top: 11101₂. Therefore, 29₁₀ = 11101₂.
我们来看一个转换示例。将十进制数29转换为二进制，我们找到小于或等于29的最大2的幂：16（2⁴）得1，剩下13。下一个幂是8（2³），所以再得1，剩下5。4（2²）得1，剩下1。2（2¹）太大，所以得0。最后，1（2⁰）得1。从高到低读：11101₂。因此，29₁₀ = 11101₂。
Now try a cross‑curricular challenge: convert the year you were born to binary, then calculate how many bits are needed to represent it. This task blends history, maths, and computing.
现在尝试一个跨学科挑战：将你出生的年份转换为二进制，然后计算需要多少位来表示它。这个任务融合了历史、数学和计算机。
Decimal to binary: 2⁷ 2⁶ 2⁵ 2⁴ 2³ 2² 2¹ 2⁰
| Decimal | Binary (8 bits) |
|---|---|
| 45 | 00101101 |
| 100 | 01100100 |
Use the table above to check your understanding, then create your own binary conversion quiz for a classmate – they must solve it using only mental maths.
利用上表检查你的理解，然后为同学创建一个你自己的二进制转换测验——他们必须只用心算来解答。
2. Computing and Art: Pixel Graphics and Coordinate Coding | 计算机与艺术：像素图形与坐标编码
Digital images are made of tiny squares called pixels, each assigned a colour value. This concept bridges art and computing brilliantly. When you design a simple black‑and‑white icon on a grid, you are essentially writing a coordinate‑based code that a computer can interpret as an image. KS3 art projects often use this low‑resolution style to create retro game sprites.
数字图像由称为像素的微小方块组成，每个像素都被赋予一个颜色值。这个概念巧妙地将艺术和计算机连接起来。当你在网格上设计一个简单的黑白图标时，你实际上是在编写一种基于坐标的代码，计算机可以将其解读为图像。KS3艺术项目经常使用这种低分辨率风格来创作复古游戏精灵。
smiling face using only black (1) and white (0). Represent the design as a list of binary strings, one string per row. For example, a row with a black pixel at column 3 and column 8 would be 0010000100. Once you have written the binary, swap with a partner to decode their design without seeing the original drawing.
任务：在一个10×10网格上，仅使用黑色（1）和白色（0）设计一个简单的笑脸。将设计表示为一组二进制字符串，每行一个字符串。例如，一行中第3列和第8列有一个黑色像素，则为0010000100。编写完二进制后，与伙伴交换，在不看原始图形的情况下解码他们的设计。
This exercise reinforces the understanding of arrays, coordinates, and abstraction. It also shows how a spreadsheet or simple Python script could translate binary into filled squares on screen, linking back to the visual arts.
这个练习加强了对数组、坐标和抽象的理解。它还展示了电子表格或简单的Python脚本如何将二进制转换为屏幕上的填充方块，由此又回到视觉艺术。
Extension: Research how 8‑ colour codes (e.g., red = R, green = G) alongside binary to create a more complex mosaic.
拓展：研究一下8位图形如何使用有限的调色板，并尝试在二进制旁边添加颜色代码（例如红色=R，绿色=G），创作更复杂的马赛克。
3. Computing and Music: Digital Audio Sampling | 计算机与音乐：数字音频采样
When you record sound on a computer, the analogue wave is converted into digital data by sampling the wave's amplitude thousands of times per second. The sampling rate (e.g., 44.1 kHz) and bit depth determine the audio quality and file size. This process is a perfect blend of music, physics, and computing.
当你在计算机上录制声音时，模拟声波通过每秒数千次地采样振幅转换为数字数据。采样率（例如44.1 kHz）和位深度决定了音频质量和文件大小。这个过程完美融合了音乐、物理和计算机。
Calculate a simple file size: a 30‑ bits, then convert to bytes and kilobytes. (Remember: 1 byte = 8 bits, 1 kB ≈ 1000 bytes.)
计算一个简单的文件大小：一段30秒的单声道声音剪辑以每秒44,100个样本的采样率录制，每个样本使用16位。求出总位数，然后转换为字节和千字节。（记住：1字节=8位，1 kB≈1000字节。）
× duration × bit depth = 44,100 × 30 × 16 = 21,168,000 bits → 2,646,000 bytes → 2,646 kB.
ansmission. For a music composition task, code a simple melody using frequencies (e.g., middle C = 261.6 Hz) in Scratch or Python, then discuss how sampling affects the tone quality.
这种数学建模与存储设备和流媒体服务直接相关，这些主题在讨论数据传输的科学课中也会出现。对于音乐创作任务，可以在Scratch或Python中使用频率（例如中央C=261.6 Hz）编写一段简单的旋律，然后讨论采样如何影响音质。
4. Computing and Geography: Data Logging and Charting | 计算机与地理：数据记录与图表绘制
Geographical investigations often involve measuring temperature, rainfall, or population changes over time. Computer science enables us to collect, store, and visualise this data using sensors and spreadsheet software. This cross‑curricular exercise asks you to interpret a dataset and produce a digital chart that communicates patterns clearly.
地理调查通常涉及测量一段时间内的温度、降雨量或人口变化。计算机科学使我们能够使用传感器和电子表格软件收集、存储和可视化这些数据。这项跨学科练习要求你解读一个数据集，并制作一个清晰传达模式的数字图表。
Given the following average monthly temperatures (in °C) for a coastal town: Jan 5, Feb 6, Mar 8, Apr 11, May 15, Jun 18, Jul 20, Aug 19, Sep 16, Oct 12, Nov 8, Dec 6. Using spreadsheet functions, calculate the annual mean, find the maximum and minimum, and create a line graph. Then write a short formula to predict the temperature for the next January using a simple trend line.
已知某沿海城镇的月平均气温（单位°C）：1月5，2月6，3月8，4月11，5月15，6月18，7月20，8月19，9月16，10月12，11月8，12月6。使用电子表格函数计算年均值，找出最大值和最小值，并创建折线图。然后编写一个简短的公式，利用简单的趋势线预测下一年1月的温度。
This task develops geo‑numerical analysis and introduces the concept of forecasting, which is essential in climate science. It also reinforces spreadsheet skills such as AVERAGE(), MAX(), MIN(), and chart wizard tools that are part of the WJEC KS3 ICT requirement.
这个任务培养了地理数值分析能力，并引入了预测的概念，这在气候科学中至关重要。它还强化了电子表格技能，如AVERAGE()、MAX()、MIN()和图表向导工具，这些是WJEC KS3信息与通信技术要求的一部分。
5. Computing and Science: Simulation and Modelling | 计算机与科学：模拟与建模
Scientists use computer models to simulate complex systems, such as predator‑prey dynamics or the spread of a virus. These models are built using algorithms and conditions that change variables over time. In a KS3 context, you can create a simple interactive model that demonstrates a scientific principle while practising block‑based coding.
科学家使用计算机模型来模拟复杂系统，例如捕食者-猎物动态或病毒的传播。这些模型使用随时间改变变量的算法和条件来构建。在KS3背景下，你可以创建一个简单的交互式模型，演示一个科学原理，同时练习基于积木的编码。
Design a simulation of a bouncing ball in Scratch or Python. The ball should lose 10% of its bounce height each time due to energy transfer (physics concept). Set the initial height to 100 units and run the simulation until the height falls below 1 unit. Record the number of bounces. Extend the model to show how varying the energy loss percentage (e.g., 5% vs 15%) affects the result.
在Scratch或Python中设计一个弹跳球的模拟。由于能量转移（物理概念），球每次弹跳后高度降低10%。将初始高度设为100单位，运行模拟直到高度低于1单位。记录弹跳次数。扩展模型，展示改变能量损失百分比（例如5%对比15%）如何影响结果。
This activity solidifies understanding of loops, variables, and conditional statements in programming while reinforcing the scientific method: observe, hypothesise, experiment, and analyse.
这个活动巩固了对编程中循环、变量和条件语句的理解，同时强化了科学方法：观察、假设、实验和分析。
6. Computing and Languages: Codes and Ciphers | 计算机与语言：代码与密码
Cryptography connects computing with linguistic structures and historical communication. The Caesar cipher, which shifts each letter in the alphabet by a fixed number, offers a perfect starting point for combining coding with language skills. Pupils can write an encryption program and then test it on English and Welsh words, exploring how letter frequency differs between languages.
密码学将计算机与语言结构和历史交流联系起来。恺撒密码将字母表中的每个字母移动固定位数，为将编码与语言技能结合提供了完美的起点。学生可以编写一个加密程序，然后在英语和威尔士语单词上测试，探索不同语言之间字母频率的差异。
aesar) and returns the ciphertext. Remember to wrap around from Z to A. Test with the word 'CYMRU' (shift 3) → 'FBPUX'. Now decrypt a given Welsh sentence that has been shifted by 5: 'HTSLXJQQT'. Use frequency analysis to guess the most common letters in Welsh (e.g., 'y', 'w', 'a') to break the cipher without knowing the shift.
任务：用伪代码编写一个函数，接受明文字词和移位值（经典恺撒移位为3），返回密文。记得从Z回到A。用单词'CYMRU'（移位3）测试→'FBPUX'。现在解密一句已移位5的威尔士语句子：'HTSLXJQQT'。使用频率分析猜测威尔士语中最常见的字母（例如'y'，'w'，'a'），在不已知移位的情况下破译密码。
This exercise naturally integrates string manipulation, ASCII codes, and modulo arithmetic with linguistic analysis, making it a staple of cross‑curricular computing.
这个练习自然地将字符串操作、ASCII码和模运算与语言分析整合在一起，使其成为跨学科计算机的基础内容。
7. Computing and Design Technology: 3D Modelling and Printing | 计算机与设计技术：3D建模与打印
Using CAD software such as Tinkercad, pupils can design three‑dimensional objects by manipulating shapes, coordinates, and measurements. This process draws on spatial reasoning from mathematics and the iterative design cycle from D&T, all while building practical digital skills. A typical KS3 project might involve designing a sustainable phone stand that meets specific size constraints.
使用如Tinkercad这样的CAD软件，学生可以通过操作形状、坐标和测量值来设计三维物体。这个过程利用了数学中的空间推理和设计与技术中的迭代设计循环，同时培养了实用的数字技能。一个典型的KS3项目可能涉及设计一个满足特定尺寸限制的可持续手机支架。
Integrate computing by scripting the design: in Tinkercad's Codeblocks or using Python with a 3D library, write a program that automatically generates a customised name tag. The user enters their name, and the code creates extruded text with a base plate. This requires understanding of parameters, loops for duplicate letters, and union of solids (Boolean operations).
通过脚本化设计来整合计算机：在Tinkercad的Codeblocks中或使用Python结合3D库，编写一个自动生成定制名牌的程序。用户输入姓名，代码创建一个带底座的拉伸文字。这需要理解参数、重复字母的循环以及实体的合并（布尔运算）。
Evaluating the final product against the original brief mirrors the design technology evaluation process, and exporting the STL file for printing connects the digital model to a physical outcome – a powerful cross‑curricular link.
根据原始设计概要评估最终产品，反映了设计技术的评估过程，而导出STL文件进行打印则将数字模型与实物结果连接起来——这是一个强大的跨学科联系。
8. Computing and Physical Education: Analysing Fitness Data | 计算机与体育：健身数据分析
Wearable devices and fitness apps collect vast amounts of data about heart rate, steps, and calories burned. Analysing this data with spreadsheet tools or simple programs provides a meaningful intersection between PE, biology, and computing. Students can track their own physical activity and use digital tools to evaluate performance improvements.
可穿戴设备和健身应用程序收集了大量关于心率、步数和消耗卡路里的数据。使用电子表格工具或简单程序分析这些数据，在体育、生物和计算机之间形成了一个有意义的交叉点。学生可以追踪自己的身体活动，并使用数字工具评估表现的改善。
Given a dataset of weekly step counts for four weeks: Monday‑Sunday. Calculate the total, daily average, and identify the most active day. Then write a conditional formula (IF statement) that flags any day with steps below 5,000 as 'Low Activity' and above 12,000 as 'High Activity'. Create a bar chart to visualise the trend and compare with national health guidelines.
给定四周的每周步数数据集：周一至周日。计算总计、日均步数，并找出最活跃的一天。然后编写一个条件公式（IF语句），将步数低于5,000的任何一天标记为“低活动量”，高于12,000的标记为“高活动量”。创建一个条形图来可视化趋势，并与国家健康指南进行比较。
This data‑driven approach reinforces the importance of algorithms in health science and encourages pupils to make evidence‑based decisions about their lifestyle – a direct application of digital literacy and computational analysis.
这种数据驱动的方法强化了算法在健康科学中的重要性，并鼓励学生基于证据做出生活方式决策——这是数字素养和计算分析的直接应用。
9. Computing and Business: Spreadsheet Budgeting | 计算机与商业：电子表格预算
Running a small enterprise – a common KS3 enterprise project – requires careful budgeting. Spreadsheets become a vital tool for tracking income, expenses, and profit. This business‑computing task builds financial literacy alongside advanced spreadsheet formulas such as SUM, absolute references, and what‑if analysis.
经营一个小企业——一个常见的KS3企业项目——需要精心的预算。电子表格成为跟踪收入、支出和利润的重要工具。这项商业-计算机任务培养了金融素养以及高级电子表格公式，如SUM、绝对引用和假设分析。
Scenario: Your class is running a tuck shop for one week. Start‑up capital is £50. You buy snacks at wholesale prices and sell at retail. Record at least ten transactions (date, item, cost, selling price, quantity sold). Use formulas to calculate revenue, total cost, and profit. Add a column for profit margin as a percentage. Finally, use goal seek to find the selling price per item needed to achieve a target profit of £30.
情景：你班将经营一周的小吃店。启动资金为50英镑。你按批发价购买零食，按零售价出售。记录至少十笔交易（日期、商品、成本、售价、售出数量）。使用公式计算收入、总成本和利润。增加一列计算利润率百分比。最后，使用单变量求解，找出为实现30英镑目标利润所需的每件商品售价。
This task mirrors real‑world business applications and introduces the concept of digital modelling for decision‑making, a skill that spans economics and computing.
这个任务反映了真实的商业应用，并引入了用于决策的数字建模概念，这是一项横跨经济学和计算机的技能。
10. Integrated Creative Challenge: Build a Cross‑Curricular Game | 综合创意挑战：构建跨学科游戏
To pull all the threads together, design a digital game that combines elements from at least three subjects. The game could be a quiz with mathematical puzzles, a geography location‑guessing game, or a language‑learning adventure. Use Scratch or a similar block‑based environment, and focus on planning, decomposition, and iterative development.
为了将所有线索整合在一起，设计一个至少结合三门学科元素的数字游戏。这款游戏可以是一个带有数学谜题的测验、一个地理地点猜测游戏，或是一个语言学习冒险游戏。使用Scratch或类似的积木式环境，并专注于规划、分解和迭代开发。
Start by defining the core mechanics: input (keyboard, mouse), variables (score, timer), and conditional logic (win/lose). Then integrate cross‑curricular content: for example, a player must solve binary conversions to unlock doors (maths), identify flags of countries (geography), and spell words in Welsh (languages). Document your design with a flowchart and test repeatedly with peers.
首先定义核心机制：输入（键盘、鼠标）、变量（得分、计时器）和条件逻辑（赢/输）。然后整合跨学科内容：例如，玩家必须解决二进制转换来开门（数学），识别国家的国旗（地理），并用威尔士语拼写单词（语言）。用流程图记录你的设计，并与同伴反复测试。
Present your finished game to the class, explaining how each disciplinary link was coded and what you learned about debugging and user experience. This final challenge synthesises all WJEC KS3 computing strands: algorithms, data, programming, and digital literacy.
向全班展示你完成的游戏，解释每个学科联系是如何编码的，以及你在调试和用户体验方面学到了什么。这个最终挑战综合了WJEC KS3计算机的所有线索：算法、数据、编程和数字素养。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图