📚 Year 8 CCEA Computer Science: Cross-curricular Integrated Practice | 跨学科综合题型训练
In Year 8, computing is not an isolated subject; it constantly interacts with mathematics, science, geography, history and even personal, social and health education. This cross‑curricular integrated practice series will help you develop computational thinking while tackling real‑world problems from other subjects. You will convert binary numbers, design flowcharts for geographical decisions, model a pocket money budget in a spreadsheet, evaluate historical sources online and much more. Each section presents a concept, a linked question and a worked solution, always keeping the CCEA curriculum in mind.
在八年级，计算机并不是一门孤立的学科；它不断与数学、科学、地理、历史甚至个人、社会与健康教育互动。这套跨学科综合题型训练将帮助你在解决其他学科的真实问题时发展计算思维。你将转换二进制数、为地理决策设计流程图、在电子表格中建立零花钱预算模型、在线评估历史资料等等。每一节都围绕一个概念、一道关联题目和详细解答展开，始终紧扣 CCEA 课程要求。
1. Number Systems: Binary and Decimal Conversion | 数制：二进制与十进制转换
tanding how to convert between binary and decimal reinforces place value and powers of two – ing 2⁸ = 256 possible levels per channel. The total number of colours is 256 × 256 × 256 = 256³.
计算机将所有内容存储为二进制位。理解二进制与十进制之间的转换可以强化位值和 2 的幂的概念，这与数学直接相关。一个实际应用是数字图像的色彩深度：红色、绿色和蓝色通道通常各使用 8 位，因此每个通道有 2⁸ = 256 种可能等级。总色彩数为 256 × 256 × 256 = 256³。
Integrated Question 1 | 综合题 1
Convert the binary number 10110₂ to decimal. Show your working using a place value table, then calculate how many different colours are possible if each RGB channel uses 4 bits instead of 8.
将二进制数 10110₂ 转换为十进制。请使用位值表展示计算过程，并计算如果每个 RGB 通道使用 4 位而不是 8 位，总共有多少种不同颜色。
Solution (English) | 解答
So the value is (1×16) + (0×8) + (1×4) + (1×2) + (0×1) = 16 + 0 + 4 + 2 + 0 = 22. For a 4‑ ree channels (red, green, blue), the total number of colours is 16 × 16 × 16 = 16³ = 4096.
写出二进制数，并在每位上方标注位值：16（2⁴）、8（2³）、4（2²）、2（2¹）、1（2⁰）。数字为 1、0、1、1、0。因此数值为 (1×16) + (0×8) + (1×4) + (1×2) + (0×1) = 16 + 0 + 4 + 2 + 0 = 22。对于 4 位通道，每个通道可存储 2⁴ = 16 种级别。对于三个通道（红、绿、蓝），总色彩数为 16 × 16 × 16 = 16³ = 4096。
2. Data Handling: Representing Scientific Data | 数据处理：表示科学数据
In science experiments, we often collect numerical data and need to present it clearly. Spreadsheets can turn raw numbers into bar charts, line graphs or scatter plots. Choosing the correct chart type is a key computing skill that also helps in analysing results. For example, a line graph is perfect for showing how temperature changes over time, while a bar chart is better for comparing discrete categories such as the heart rate of different animals.
在科学实验里，我们经常收集数值数据并需要清晰地呈现。电子表格可以将原始数字转换为柱状图、折线图或散点图。选择合适的图表类型既是一项关键的计算机技能，也有助于分析结果。例如，折线图非常适合展示温度随时间的变化，而柱状图更适合比较离散的类别，比如不同动物的心率。
Integrated Question 2 | 综合题 2
A student recorded the temperature of a cooling cup of water every minute for 10 minutes in a spreadsheet (columns: Time (min) and Temperature (°C)). The teacher asks: 'What trend can you see, and which chart type would best display this data?' Explain your choice and describe how you would create the chart.
一名学生在电子表格中记录了每 1 分钟冷却水的温度，持续 10 分钟（列：时间（分）和温度（°C））。老师问：‘你能看出什么趋势？哪种图表类型最适合展示这些数据？’请解释你的选择，并描述如何创建该图表。
Solution | 解答
The trend is that temperature decreases over time, approaching room temperature. A line graph is the best choice because it connects data points and clearly shows the continuous change. To create it, highlight both columns, click the 'Insert' menu, choose 'Line chart' and label the axes. The x‑axis will be Time (min) and the y‑axis Temperature (°C).
趋势是温度随时间下降，趋近室温。折线图是最佳选择，因为它连接数据点，清楚地显示连续变化。要创建图表，选中两列数据，点击‘插入’菜单，选择‘折线图’，并标注坐标轴。x 轴为时间（分），y 轴为温度（°C）。
3. Flowcharts: Decision-Making in Geography | 流程图：地理中的决策
Flowcharts use standard symbols – oval for start/stop, rectangle for a process, diamond for a decision – to represent algorithms visually. They are excellent for modelling geographical decisions, such as what crop to plant based on climate. This links computing to human geography and logical thinking.
流程图使用标准符号——椭圆形表示开始/结束，矩形表示处理步骤，菱形表示决策——来直观地呈现算法。它们非常适合建立地理决策模型，比如根据气候决定种植什么作物。这将计算机与人文地理和逻辑思维联系起来。
Integrated Question 3 | 综合题 3
Design a flowchart for a farmer. The input is the average annual rainfall (in mm). If the rainfall is above 1000 mm, the farmer plants rice; if it is between 500 mm and 1000 mm, the farmer plants wheat; otherwise, the farmer plants drought‑resistant millet. Draw or describe the flowchart, using the correct symbols.
为一位农民设计一个流程图。输入是年平均降雨量（毫米）。如果降雨量高于 1000 毫米，农民种植水稻；如果在 500 毫米到 1000 毫米之间，则种植小麦；否则，种植耐旱的小米。使用正确的符号画出或描述该流程图。
Solution | 解答
The flowchart starts with an oval 'Start', followed by a parallelogram 'Input rainfall'. A diamond 'Rainfall > 1000?' – if true, a process box 'Plant rice' leads to 'End'. If false, another diamond 'Rainfall ≥ 500?' – if true, 'Plant wheat'; if false, 'Plant millet'. Both paths converge to 'End'.
流程图以椭圆形‘开始’为起点，接着是平行四边形‘输入降雨量’。菱形判断‘降雨量 > 1000？’——如果为真，处理框‘种植水稻’并指向‘结束’。如果为假，另一个菱形‘降雨量 ≥ 500？’——如果为真，‘种植小麦’；如果为假，‘种植小米’。两条路径最终都汇聚到‘结束’。
4. Algorithms: Drawing Shapes with Code | 算法：用代码绘制形状
Writing algorithms to draw shapes reinforces geometry, angles and sequences. A simple turtle graphics program can use commands like FORWARD 100, RIGHT 90, repeated four times, to draw a square. This connects computing with mathematics: the total turning angle for a polygon is 360°, so each exterior angle for a regular n‑sided polygon is 360° ÷ n.
编写绘制形状的算法可以巩固几何、角度和序列知识。一个简单的海龟图形程序可以使用命令如 FORWARD 100，RIGHT 90，重复四次，来画一个正方形。这连接了计算机与数学：多边形的总外角和为 360°，因此正 n 边形的每个外角为 360° ÷ n。
Integrated Question 4 | 综合题 4
Write a pseudocode algorithm to draw an equilateral triangle with sides of length 80 units. State the turning angle needed and explain why.
编写一个伪代码算法来绘制边长为 80 个单位的等边三角形。说明所需的旋转角度并解释原因。
Solution | 解答
÷ 3 = 120°. The turtle needs to turn by the exterior angle to stay on the correct heading.
伪代码：REPEAT 3 [FORWARD 80, RIGHT 120]。旋转角度是 120°，因为等边三角形的外角为 360° ÷ 3 = 120°。海龟需要按外角度数转向才能保持正确的航向。
5. Spreadsheet Modelling: Personal Finance | 电子表格建模：个人理财
Spreadsheets are powerful tools for financial planning. Using formulas with cell references, you can build a pocket money budget where changing one value automatically updates totals. This is an authentic application of mathematics and computing, covering addition, subtraction and percentage calculations.
电子表格是财务规划的有力工具。使用带有单元格引用的公式，你可以建立一个零花钱预算，修改一个数值就能自动更新合计。这是数学和计算机的真实应用，涵盖加法、减法和百分比计算。
Integrated Question 5 | 综合题 5
Create a spreadsheet model to track weekly pocket money. Cell A1 contains 'Income' (e.g. £5), B1 'Spending', C1 'Savings' (the remainder). Write the formula for C1. Then, if you decide to save 20% of your income regardless of spending, write a formula for a new cell D1 that shows the savings amount.
创建一个电子表格模型来跟踪每周零花钱。单元格 A1 包含‘收入’（例如 5 英镑），B1‘支出’，C1‘储蓄’（剩余部分）。写出 C1 的公式。然后，如果你决定不管支出都储蓄收入的 20%，请为新的单元格 D1 写出显示储蓄金额的公式。
Solution | 解答
C1 formula: =A1-B1. This subtracts spending from income. For D1, to calculate 20% savings: =A1*0.2. You can also use =A1*20% in most spreadsheet software.
C1 公式：=A1-B1。它从收入中减去支出。对于 D1，计算 20% 储蓄：=A1*0.2。在大多数电子表格软件中也可以使用 =A1*20%。
6. Boolean Logic: Everyday and Scientific Rules | 布尔逻辑：日常与科学规则
Boolean operators AND, OR and NOT allow computers to make decisions. They are used in search engines, access control and modelling scientific conditions. For instance, a chemical reaction might only occur if 'temperature > 50°C AND pH < 4'. This links computing to chemistry and critical thinking.
布尔运算符 AND、OR 和 NOT 使计算机能够做决策。它们用于搜索引擎、访问控制和模拟科学条件。例如，一个化学反应可能只在“温度 > 50°C 且 pH < 4”时发生。这将计算机与化学和批判性思维联系起来。
Integrated Question 6 | 综合题 6
A website requires a user to be over 13 AND to have parental consent to register. Write this condition as a logical expression. Then, a science club accepts members if they are in Year 8 OR have already completed a coding course. Express this second rule. For each, state when a person would be rejected.
某网站要求用户年龄超过 13 岁且获得家长同意才能注册。写出这个条件作为逻辑表达式。接着，一个科学社团接收会员的条件是：8 年级在读或已经完成编程课程。写出第二条规则。针对每条规则，说明何时一个人会被拒绝。
Solution | 解答
jected only if both conditions are false (not in Year 8 and has not completed the course).
规则 1：年龄 > 13 且 同意 = 是。若年龄 ≤ 13 或缺少同意则拒绝。规则 2：年级 = 8 或 完成编程 = 真。只有当两个条件都为假（不是 8 年级且未完成课程）时才被拒绝。
7. Programming: Variables for a Science Experiment | 编程：科学实验中的变量
Variables store data that can change during a program. In a science context, you might record multiple temperature readings and then calculate the average. This teaches data handling and reinforces the concept of a fair test, as variables must be clearly identified.
变量存储程序运行中可能变化的数据。在科学情境里，你可能会记录多次温度读数，然后计算平均值。这既训练了数据处理能力，又强化了公平测试的概念，因为变量必须被明确标识。
Integrated Question 7 | 综合题 7
Write pseudocode that declares three variables to store temperature readings from a physics experiment (temp1, temp2, temp3). Then calculate the mean temperature and display it. Extend the code to display a warning if the mean temperature exceeds 80°C.
编写伪代码，声明三个变量来存储物理实验的温度读数（temp1、temp2、temp3）。然后计算平均温度并显示。扩展代码，如果平均温度超过 80°C 则显示警告。
Solution | 解答
Pseudocode: SET temp1 = 72 SET temp2 = 78 SET temp3 = 83 SET mean = (temp1 + temp2 + temp3) / 3 OUTPUT mean IF mean > 80 THEN OUTPUT 'Warning: High temperature!' ENDIF
伪代码： SET temp1 = 72 SET temp2 = 78 SET temp3 = 83 SET mean = (temp1 + temp2 + temp3) / 3 OUTPUT mean IF mean > 80 THEN OUTPUT '警告：高温!' ENDIF
8. Internet Research: Evaluating Historical Sources | 互联网调研：评估历史资料
When researching history online, it is vital to evaluate the reliability of websites. Computing skills such as checking the domain (.ac.uk, .gov), looking for references and comparing multiple sources are part of digital literacy. This cross‑curricular task connects computing with history and critical thinking.
在线研究历史时，评估网站的可靠性至关重要。检查域名（.ac.uk、.gov）、查找参考文献以及比较多方信息源等计算机技能是数字素养的一部分。这项跨学科任务将计算机与历史和批判性思维联系起来。
Integrated Question 8 | 综合题 8
You are researching the Viking invasion of Ireland for a history project. You find three websites: a personal blog, a university archaeology department's page, and a commercial site selling replica weapons. Explain which source is most reliable and why. What checks would you perform?
你正在为一个历史项目研究维京人对爱尔兰的入侵。你找到了三个网站：一个个人博客、一所大学考古系的页面，以及一个出售武器复制品的商业网站。解释哪一个来源最可靠及其原因。你会进行哪些检查？
Solution | 解答
The university archaeology department page is the most reliable because universities are academic institutions that cite evidence and are peer‑reviewed. Checks include: verifying the domain (.ac.uk), looking for the author's credentials, checking the last update date and cross‑referencing with another trusted source. Personal blogs may contain opinions, and commercial sites may be biased to sell products.
大学考古系页面最可靠，因为大学是引证证据并经过同行评审的学术机构。检查包括：验证域名（.ac.uk）、查看作者资质、检查最后更新日期，并与另一可信来源进行交叉比对。个人博客可能包含观点，商业网站可能为销售产品而带有偏见。
9. E‑safety: Protecting Personal Data Online | 网络安全：在线保护个人数据
E‑safety is an essential part of computing and is closely tied to personal, social and health education. Understanding how to set privacy controls, recognise phishing emails and create strong passwords helps protect your digital identity.
网络安全是计算机教育的重要组成部分，并与个人、社会与健康教育紧密关联。了解如何设置隐私控制、识别钓鱼邮件和创建强密码有助于保护你的数字身份。
Integrated Question 9 | 综合题 9
A friend receives an email that appears to be from a gaming platform, asking them to click a link and confirm their password. List three signs that this might be a phishing attempt. Then write three rules for creating a strong password.
一位朋友收到一封看似来自游戏平台的电子邮件，要求点击链接并确认密码。列出三个迹象表明这可能是网络钓鱼尝试。然后写出创建强密码的三条规则。
Solution | 解答
Phishing signs: 1) The sender's email address looks slightly wrong or contains random characters. 2) The message creates urgency, such as 'Your account will be closed!'. 3) The link does not lead to the official website when hovered over. Strong password rules: 1) Use at least 12 characters mixing upper and lower case letters, numbers and symbols. 2) Avoid personal information like names or birthdays. 3) Use a unique password for every account – a password manager can help.
钓鱼迹象：1) 发件人的电子邮件地址看起来略有错误或包含随机字符。2) 消息制造紧迫感，如‘您的账户将被关闭！’。3) 当鼠标悬停时，链接并未指向官方网站。强密码规则：1) 使用至少 12 个字符，混合大小写字母、数字和符号。2) 避免使用姓名或生日等个人信息。3) 每个账户使用唯一密码——密码管理器可以提供帮助。
10. Computational Thinking: Grid References and Shortest Path | 计算思维：网格参考与最短路径
Ordnance Survey maps use grid references that combine letters and numbers, much like a coordinate system in programming. Finding the shortest path between two points on a grid introduces algorithmic thinking and basic graph theory, which links computing with geography and mathematics.
英国地形测量地图使用结合字母和数字的网格参考，很像编程中的坐标系。在网格上寻找两点之间的最短路径引入了算法思维和基础图论，将计算机与地理和数学联系起来。
Integrated Question 10 | 综合题 10
On a 6‑by‑6 grid, start at cell (1,1) and end at (4,5). You can only move up or right.
Published by TutorHao | Year 8 Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图