📚 Year 7 CCEA Computing: Cross-Curricular Exam-Style Practice | Year 7 CCEA 计算机：跨学科综合题型训练
Computing does not exist in a vacuum – it connects with every subject you study in Year 7. From using formulas in spreadsheets for Science data to writing blogs in English, cross-curricular exam questions test your ability to apply digital skills in real-world contexts. This article provides a structured revision guide packed with example questions, step‑by‑step breakdowns and smart strategies to help you master these integrated challenges.
计算机不是一门孤立的学科——它与你 Year 7 学习的每一门课程都息息相关。从在电子表格中用公式处理科学数据，到在英语课上撰写博客，跨学科考题测试的是你在真实情境中应用数字技能的能力。本文提供了一份结构化的复习指南，包含大量例题、逐步拆解和聪明的策略，帮助你攻克这些综合性的挑战。
1. Understanding Cross-Curricular Questions | 理解跨学科题型
Cross-curricular questions in CCEA Computing often blend subject knowledge with digital skills. For example, you might be asked to create a poster about the Romans using word processing tools, or analyse temperature data from a Geography investigation in a spreadsheet. The key is to identify the subject content, then select the correct computing tool to present or solve the problem.
CCEA 计算机的跨学科题型往往将学科知识与数字技能结合在一起。例如，你可能要用文字处理工具制作一张关于罗马人的海报，或在电子表格中分析地理调查中的温度数据。关键在于识别学科内容，然后选择合适的计算机工具来呈现或解决问题。
These questions usually appear in end‑of‑unit tests, project tasks or even as part of the practical exam. Marks are awarded for both accurate subject knowledge and correct use of the software feature, such as inserting a table, applying a formula, or using an appropriate chart type.
这些题目通常出现在单元测验、项目任务甚至实践考试中。得分点既包括准确的学科知识，也包括正确使用软件功能，例如插入表格、应用公式或选用合适的图表类型。
2. Computing Meets Maths: Binary and Logic | 计算机遇上数学：二进制与逻辑
Year 7 Maths often involves number systems and problem solving. In Computing, you extend this by learning binary numbers and Boolean logic. A typical cross‑curricular question might ask you to convert a decimal age or score into binary, or to complete a truth table for a simple logic gate combination.
Year 7 数学经常涉及数制和问题求解。在计算机课程中，你可以进一步学习二进制数和布尔逻辑。一道典型的跨学科题目可能要求你将一个十进制的年龄或分数转换为二进制，或补全一个简单逻辑门组合的真值表。
Example: “A Maths quiz has 4 questions. Each correct answer is represented by 1 and a wrong answer by 0. Student A got Q1 and Q3 correct. Write the binary sequence and convert it to decimal.” Here you must apply binary place values (8, 4, 2, 1). Q1 (1), Q2 (0), Q3 (1), Q4 (0) gives 1010₂ = 8+0+2+0 = 10₁₀.
例题：“一次数学测验有 4 道题，每道题答对用 1 表示，答错用 0 表示。学生 A 答对了第 1 题和第 3 题。写出二进制序列并将其转换为十进制。” 这里你要运用二进制位权（8、4、2、1）。第1题1、第2题0、第3题1、第4题0 得到 1010₂ = 8+0+2+0 = 10₁₀。
Boolean logic appears in puzzles: “If it is raining AND you have an umbrella, then you stay dry.” You may be asked to draw a truth table for AND, OR and NOT gates linking to everyday scenarios, reinforcing logical reasoning used in Maths.
布尔逻辑会出现在谜题中：“如果下雨并且你有伞，那么你就不会淋湿。”你可能会被要求为与、或、非门绘制真值表，并联系日常情景，强化数学中使用的逻辑推理。
3. Data Handling with Spreadsheets and Graphs | 使用电子表格和图表处理数据
Data handling is a skill shared by Science, Geography and Computing. In an exam‑style question, you may receive a small dataset – e.g., the heights of plants over four weeks in a Science experiment. The task could be to enter the data into a spreadsheet, calculate the average growth using a formula, and create a suitable chart.
数据处理是科学、地理和计算机共享的技能。在模拟考题中，你可能会收到一个小型数据集——例如科学实验中四周内植物的高度。任务可能包括将数据录入电子表格，用公式计算平均增长量，并创建合适的图表。
Always remember: a spreadsheet formula begins with ‘=’. To find the average, use =AVERAGE(B2:B5). For a line graph showing growth over time, select the ‘Week’ column as the X‑axis and the ‘Height’ column as the Y‑axis. The question might also test your ability to interpret the chart – “In which week did the plant grow the most?” – linking back to Science observations.
请始终记住：电子表格公式以“=”开头。求平均值使用 =AVERAGE(B2:B5)。要制作显示生长变化的折线图，选择“周”列作为 X 轴，“高度”列作为 Y 轴。题目也可能考查你解读图表的能力——“哪一周植物生长最快？”——这又联系到科学观察。
Practice: Recreate a small table in a spreadsheet tool and practise formatting cells (bold headers, borders) and changing chart colours to match subject context. These small details can earn marks in the exam.
练习：在电子表格工具中重新创建一个小表格，并练习设置单元格格式（标题加粗、添加边框），以及根据学科情境调整图表颜色。这些小细节能在考试中为你赢得分数。
4. Algorithmic Thinking in Science Experiments | 科学实验中的算法思维
Algorithms are step‑by‑step instructions, much like the method section in a Science lab report. Cross‑curricular questions often present a simple experiment – for example, filtering a mixture – and ask you to write an algorithm or draw a flowchart for the procedure.
算法就是分步骤的指令，很像科学实验报告中的方法部分。跨学科题目常常给出一个简单的实验——例如过滤混合物——并要求你写出算法或绘制流程图。
A good answer uses clear, numbered steps and includes decision points: “If the water is still cloudy, repeat the filtration.” Flowcharts must use the correct shapes: oval for Start/End, rectangle for a process, diamond for a decision. This mirrors the precision required in Science.
好的答案会使用清晰的编号步骤，并包含决策点：“如果水仍浑浊，则重复过滤。”流程图必须使用正确的形状：椭圆表示开始/结束，矩形表示过程，菱形表示决策。这与科学要求的精确性是一致的。
Example task: “Design an algorithm for measuring the temperature of water every 2 minutes after heating begins.” Your algorithm needs initialisation (set timer, record start temperature), a loop (every 2 minutes, record temperature), and a stopping condition (when 10 minutes have passed).
示例任务：“设计一个算法，用于在开始加热后每 2 分钟测量一次水温。”你的算法需要初始化（设置计时器、记录起始温度）、一个循环（每 2 分钟记录温度）和一个停止条件（当 10 分钟过去时）。
5. Writing and Formatting with Word Processing | 使用文字处理进行写作和排版
English and History teachers love well‑structured documents. In Computing, you learn how to use headings, bullet points, page numbers and images to improve a piece of writing. A cross‑curricular question might provide a plain text and ask you to format it as a newspaper article or a formal letter.
英语和历史老师都喜爱结构清晰的文档。在计算机课上，你学习如何使用标题、项目符号、页码和图片来润色一篇文章。跨学科题目可能提供一份纯文本，要求你将其排版为报纸文章或正式信函。
Key skills tested include: selecting appropriate font style and size, aligning text (left, centre, justify), inserting a header/footer with name and date, and using spell check to correct errors. Often you must also insert a relevant image and wrap text around it.
考查的关键技能包括：选择合适的字体样式和大小，对齐文本（左对齐、居中、两端对齐），插入包含姓名和日期的页眉/页脚，以及使用拼写检查来更正错误。通常你还必须插入一张相关的图片并实现文字环绕。
Top tip: Always read the question to see if there is a specific word count, heading style or image requirement. In a History context, you may need to format a timeline using tabs or a table – merging cells for time spans. This type of task combines subject accuracy with technical formatting.
重要提示：务必仔细读题，看清是否有字数、标题样式或图片要求。在历史情境中，你可能需要用制表符或表格来排版时间轴——合并单元格来表示时间段。这类任务将学科准确性和技术排版合二为一。
6. Creating Presentations for Any Subject | 为任何学科制作演示文稿
Presentations are a powerful way to communicate ideas in Geography, Science, or even Music. CCEA questions frequently ask you to plan a slide deck for a given topic, explaining the layout, multimedia choices and transitions.
演示文稿是在地理、科学甚至音乐课上传达想法的有力方式。CCEA 的题目经常会要求你为一个特定主题规划一套幻灯片，说明版面布局、多媒体选择和切换效果。
You might be asked: “Design three slides about renewable energy. Include a title slide, a slide with a diagram, and a conclusion slide with bullet points.” The answer must demonstrate an understanding of slide structure, consistent design, and the use of images or videos without distracting the audience.
你可能会被问到：“设计三张关于可再生能源的幻灯片。包括标题页、一张带图表的幻灯片，以及一张带项目符号的总结页。”答案必须体现出对幻灯片结构、统一设计以及图片或视频使用（但不会分散观众注意力）的理解。
Marks are usually given for selecting appropriate content, not just the technical steps. For instance, choosing a video of a wind turbine for the second slide adds subject value. Also remember to mention accessibility – using alt text for images and high‑contrast colours helps all viewers and often earns extra marks.
得分通常取决于所选内容的适宜性，而不仅仅是技术步骤。例如，为第二张幻灯片选择一段风力涡轮机的视频，就能增加学科价值。此外，要记得提及无障碍设计——为图片添加替代文本，使用高对比度颜色，这能帮助所有观众，也常常能赢得额外分数。
7. Online Research and Digital Literacy | 在线研究与数字素养
In subjects like Geography or History, you are often asked to research a topic online. Cross‑curricular Computing questions test whether you can search effectively, evaluate sources, and avoid plagiarism.
在地理或历史等科目中，经常要求你在线研究一个主题。跨学科的计算机题目会考查你是否能有效搜索信息、评估来源并避免抄袭。
Example: “Find three facts about the River Nile using a search engine. For each fact, write down the website name and explain why the source is reliable.” This requires searching with precise keywords (‘Nile length primary source’), scanning results, and checking for authority (e.g. .edu or .gov domains).
例题：“使用搜索引擎查找三条关于尼罗河的事实。每一条都要写下网站名称，并解释为什么该来源是可靠的。”这要求你使用精确的关键词搜索（“尼罗河 长度 原始资料”），浏览搜索结果，并检查权威性（例如 .edu 或 .gov 域名）。
You also need to show you can summarise information in your own words, not just copy and paste. Using a simple table to organise Research Source, Fact & Your Own Summary helps structure your answer. This skill is at the heart of digital literacy and is tested across the curriculum.
你还需要展示你能用自己的话总结信息，而不仅仅是复制粘贴。使用一个简单表格来组织“研究来源”、“事实”和“你的总结”有助于构建答案。这项技能是数字素养的核心，也在整个课程中受到考查。
8. Safe and Responsible Internet Use | 安全负责任地使用互联网
Internet safety is a standalone topic but also appears in cross‑subject scenarios. For example, an English task on writing a blog may be combined with questions about acceptable online behaviour and keeping personal information private.
互联网安全是一个独立的话题，但也出现在跨学科的情境中。例如，一项关于撰写博客的英语任务可能会与有关可接受的网络行为和保持个人信息私密的题目相结合。
A typical exam question: “You are going to post a comment on a school forum about your Geography field trip. Give two rules you should follow to stay safe online.” Acceptable answers include: never share your full name or address, be polite, and do not post photos of others without permission.
一道典型的考题：“你将在学校论坛上就地理实地考察发表评论。请给出两条应遵守的网络安全规则。”可接受的答案包括：绝不要透露全名或地址，保持礼貌，未经许可不要发布他人的照片。
Sometimes you must recognise phishing emails or fake profiles. A question may show a screen‑shot of a suspicious message and ask you to identify three signs it is a scam. Linking this to PSHE or Citizenship lessons makes the learning stick.
有时你必须识别钓鱼邮件或虚假个人资料。题目可能展示一条可疑信息的截图，要求你找出三个表明它是骗局的迹象。将这点与 PSHE 或公民教育课联系起来，能让学习更加牢固。
9. Creative Design and Digital Art | 创意设计与数字艺术
Art and Design Technology projects can be supported by Computing skills. You might be asked to create a logo for a school club using vector graphics tools, combining shapes, fill colours and text. Cross‑curricular questions assess both design principles (contrast, balance) and the ability to use the software.
美术和设计技术项目都可以借助计算机技能。你可能会被要求用矢量图形工具为学校社团设计一个标志，结合形状、填充颜色和文字。跨学科题目既评估设计原理（对比、平衡），也评估软件操作能力。
Example: “Design a simple poster for a Music concert. Include the event name, date, venue, and use appropriate colours to reflect the mood.” You would need to choose a colour scheme (e.g., dark blue and gold for a classical concert), align text elements neatly, and perhaps import a musical note icon. The rationale behind your choices can also be part of the question.
例题：“为一场音乐会设计一张简易海报。包含活动名称、日期、地点，并运用恰当的色彩来反映情绪。”你将需要选择配色方案（例如古典音乐会使用深蓝和金色），整齐地对齐文本元素，或许还要导入一个音符图标。你的选择理由也可能成为题目的一部分。
This type of task often appears in project‑based assessments, but can also be simplified into an exam question: “List three tools you would use in a graphics editor to create the poster and explain why.” Be prepared to discuss layers, alignment grids, and image formats.
这类任务常出现在项目评估中，但也可以简化为一道考试题：“列举三种你会在图形编辑器中用来制作海报的工具，并解释原因。”准备好讨论图层、对齐网格和图像格式。
10. Programming and Problem Solving | 编程与问题解决
Programming underpins much of working scientifically and mathematically. Scratch‑style block‑based code is often used in Year 7 to create simulations or solve puzzles. Cross‑curricular questions may ask you to debug a program that counts the number of times a dice rolls a six, or to modify a script to draw a mathematical shape.
编程是很多科学和数学工作的基础。Year 7 经常使用类似 Scratch 的积木式代码来创建模拟或解决谜题。跨学科题目可能会要求你调试一个统计骰子掷出六点次数的程序，或修改脚本来绘制一个数学图形。
Example: “Here is a program that calculates the area of a rectangle. However, it always gives the wrong answer. Identify the error and correct it.” The script might use ‘length + width’ instead of ‘length * width’. This tests your understanding of both the formula (maths) and the programming operator (computing).
例题：“这里有一个计算矩形面积的程序，但它总是得出错误的答案。找出错误并改正。”脚本可能用了“长度 + 宽度”而不是“长度 * 宽度”。这同时考查你对公式（数学）和编程运算符（计算机）的理解。
Another common task is to translate a story or historical event into a simple animation using ‘say’ blocks, loops and wait commands. You might be marked on the logical sequence of events, much like sequencing a narrative in English.
另一个常见任务是将一个故事或历史事件用“说”积木、循环和等待命令转化为简单的动画。评分时会看你的事件逻辑顺序，很像英语课上对叙事排序的要求。
11. Exam‑Style Integrated Practice Questions | 综合模拟题目练习
Let’s put your skills to the test with a few exam‑style questions that mix subject knowledge and computing tools.
我们来用几道融合了学科知识和计算机工具的模拟考题检验一下你的技能。
Question 1 (Maths & Spreadsheet): The table shows the number of books read by four students: Anna 5, Ben 3, Chloe 8, Dan 4. (a) Enter the data into a spreadsheet. (b) Write a formula to calculate the total number of books. (c) Create a bar chart. (d) Which student read the most?
第 1 题（数学与电子表格）：表格显示了四位学生读过的书本数：Anna 5, Ben 3, Chloe 8, Dan 4。(a) 将数据录入电子表格。(b) 写出计算书本总数的公式。(c) 创建条形图。(d) 哪位学生读的书最多？
Question 2 (Science & Flowchart): Draw a flowchart for the process of testing whether a substance is an acid or alkali using litmus paper. Include start, dip paper, check colour change, and output result.
第 2 题（科学与流程图）：绘制一个流程图，描述使用石蕊试纸测试某物质是酸还是碱的过程。包含开始、浸入试纸、检查颜色变化和输出结果。
Question 3 (English & Presentation): Prepare a three‑slide presentation about your favourite book. Slide 1: Title and author. Slide 2: Main characters with a bullet list. Slide 3: Why you recommend it. Describe the slide layouts, font choices and one image per slide.
第 3 题（英语与演示文稿）：准备一份关于你最爱的一本书的三张幻灯片演示。幻灯片 1：标题和作者。幻灯片 2：主要人物，使用项目符号列表。幻灯片 3：推荐理由。描述每张幻灯片的版式、字体选择以及每张上一张图片。
Question 4 (Citizenship & Internet Safety): You receive a message from a stranger on a school project forum saying ‘Click here to see your prize!’ List two things you would do and two things you would not do, explaining each.
第 4 题（公民教育与网络安全）：你在学校项目论坛上收到陌生人的消息，说“点击这里领取你的奖品！”列出两件你会做的事和两件你不会做的事，并逐一解释。
12. Tips for Tackling Mixed‑Skill Tasks | 应对混合技能任务的技巧
When facing a cross‑curricular computing question, first identify which subjects are involved and what digital tool is required. Underline the key command words: ‘create’, ‘explain’, ‘format’, ‘calculate’. These tell you exactly what to produce.
在遇到跨学科计算机题时，首先识别涉及哪些科目以及需要什么数字工具。在关键指令词下划线：“创建”、“解释”、“排版”、“计算”。这些词会准确地告诉你需要产出什么。
Plan before you start. For a spreadsheet question, sketch the table structure; for a flowchart, draft the steps on scrap paper. This planning step saves time and prevents errors. Always check that your solution actually answers the subject part – for instance, does the chart show the correct scientific relationship?
开始之前先做规划。对于电子表格题，草拟表格结构；对于流程图，在草稿纸上写出步骤。这一步规划能节省时间并防止错误。始终核对你的解答是否确实回答了学科部分——例如，图表是否展示了正确的科学关系？
Use subject vocabulary precisely. Saying ‘put the numbers in boxes’ might not earn the mark for ‘entering data into cells’. In the same way, ‘use a diamond shape to show a question’ is better phrased as ‘use a diamond symbol for a decision in the flowchart’. This precision shows you can connect the two disciplines fluently.
准确使用学科词汇。说“把数字放进方框里”可能得不到“将数据录入单元格”的分数。同样，“用菱形表示一个问题”最好表述为“在流程图中用菱形符号表示决策”。这种精确性表明你能流畅地连接两个学科。
Finally, review your work against the mark scheme if available. In many CCEA tasks, half the marks are for the computing skill and half for the subject correctness, so you cannot afford to neglect either side.
最后，如果有评分标准，依据它来检查你的作业。在 CCEA 的许多任务中，一半分数给计算机技能，一半给学科正确性，因此你哪一边都不能忽视。
Published by TutorHao | Computing Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导