📚 KS3 OCR Accounting: Cross-disciplinary Integrated Question Training | KS3 OCR 会计：跨学科综合题型训练
The KS3 OCR Accounting course encourages students to apply financial concepts across various disciplines. These cross-disciplinary integrated questions help build a holistic understanding of how accounting connects with mathematics, ICT, business studies, and real-world problem-solving. By tackling these exercises, learners will strengthen their analytical skills and see the bigger picture beyond simple bookkeeping.
KS3 OCR 会计课程鼓励学生将财务概念应用于不同学科。这些跨学科综合题型有助于全面理解会计如何与数学、信息通信技术、商业研究以及现实问题解决能力联系在一起。通过练习这些题目，学习者将增强分析能力，并看到超越简单记账的更广阔图景。
1. Budgeting with Spreadsheets | 电子表格预算训练
A school club is planning a fundraising event. Use spreadsheet software to create a budget. The income includes ticket sales of 120 tickets at £3.50 each and a donation of £50. Expenses are: venue hire £80, refreshments £95, and decorations £30. Enter these items into a spreadsheet and use the SUM function to calculate total income, total expenses, and net profit.
一个学校俱乐部正在筹划一次筹款活动。使用电子表格软件创建预算。收入包括120张门票，每张3.50英镑，以及一笔50英镑的捐款。支出有：场地租赁80英镑，茶点95英镑，装饰品30英镑。将这些项目输入电子表格，并使用SUM函数计算总收入、总支出和净利润。
Create a simple table in the spreadsheet with clear labels. Apply cell formatting to currency with the £ symbol and two decimal places. The net profit formula should be =SUM(Income_range)-SUM(Expense_range). This type of task integrates ICT skills with basic accounting logic.
在电子表格中创建一个清晰的表格，并添加标签。将单元格格式设置为带有£符号和两位小数的货币格式。净利润公式应写为=SUM(收入范围)-SUM(支出范围)。这类任务将信息通信技术技能与基础会计逻辑相结合。
| Item | Amount (£) |
|---|---|
| Ticket Sales | 420.00 |
| Donation | 50.00 |
| Total Income | 470.00 |
| Venue Hire | 80.00 |
| Refreshments | 95.00 |
| Decorations | 30.00 |
| Total Expenses | 205.00 |
| Net Profit | 265.00 |
Explain why formatting cells correctly is important for readability and accuracy in accounting.
解释为什么正确设置单元格格式对于会计的可读性和准确性很重要。
2. Financial Ratios and Data Analysis | 财务比率与数据分析
A small business has revenue of £24,000, cost of sales £14,400, and operating expenses £5,200. Calculate the gross profit and net profit. Then compute the gross profit margin and net profit margin as percentages. Show your working clearly.
一家小企业收入为24,000英镑，销售成本为14,400英镑，运营费用为5,200英镑。计算毛利润和净利润。然后计算毛利率和净利率（以百分比表示）。请清晰展示计算过程。
Gross Profit = Revenue − Cost of Sales = £24,000 − £14,400 = £9,600. Gross Profit Margin = (Gross Profit ÷ Revenue) × 100 = (9,600 ÷ 24,000) × 100 = 40%. Net Profit = Gross Profit − Operating Expenses = £9,600 − £5,200 = £4,400. Net Profit Margin = (4,400 ÷ 24,000) × 100 ≈ 18.33% s different periods or businesses, linking accounting to mathematical percentage analysis.
毛利润 = 收入 − 销售成本 = 24,000英镑 − 14,400英镑 = 9,600英镑。毛利率 = (毛利润 ÷ 收入) × 100 = (9,600 ÷ 24,000) × 100 = 40%。净利润 = 毛利润 − 运营费用 = 9,600英镑 − 5,200英镑 = 4,400英镑。净利率 = (4,400 ÷ 24,000) × 100 ≈ 18.33%。这些比率有助于比较不同时期或不同企业的业绩，将会计与数学百分比分析联系起来。
Using a spreadsheet or calculator, create a data table that shows these results and a simple bar chart comparing the two margins. This integrates data presentation skills with accounting interpretation.
使用电子表格或计算器创建一个数据表来显示这些结果，并制作一个简单的条形图比较这两个利润率。这整合了数据展示技能与会计解读能力。
3. Break-even Analysis using Graphs | 利用图表进行盈亏平衡分析
A student enterprise sells handmade bracelets. Fixed costs are £60 per month (for stall rental), variable cost per bracelet is £2.50, and selling price is £6.00 per bracelet. Determine the break-even point in units and sales revenue. Draw a break-even chart labelling the total cost line, total revenue line, fixed cost line, and break-even point.
一个学生企业销售手工手链。每月固定成本为60英镑（摊位租金），每条手链的变动成本为2.50英镑，售价为每条6.00英镑。确定以数量和销售收入表示的盈亏平衡点。绘制盈亏平衡图，标出总成本线、总收入线、固定成本线和盈亏平衡点。
Contribution per unit = Selling price − Variable cost = £6.00 − £2.50 = £ so 18 bracelets must be sold to break even (rounding up). Break-even sales revenue = 18 × £6.00 = £108.00. On the graph, the total cost line starts at £ tal revenue starts at 0 with a slope of 6.00. The intersection marks the break-even point.
单位边际贡献 = 售价 − 变动成本 = 6.00英镑 − 2.50英镑 = 3.50英镑。盈亏平衡点（数量）= 固定成本 ÷ 单位边际贡献 = 60 ÷ 3.50 = 17.14，因此必须售出18条手链才能保本（向上取整）。盈亏平衡销售收入 = 18 × 6.00英镑 = 108.00英镑。在图表中，总成本线从y轴上的60英镑开始，斜率为2.50，而总收入线从0开始，斜率为6.00。两者的交点就是盈亏平衡点。
This exercise blends graphical skills from mathematics with cost-volume-profit analysis in accounting. Discuss why the break-even point might change if the stall rental increases.
这项练习将数学中的图形技能与会计中的本量利分析相结合。讨论如果摊位租金上涨，盈亏平衡点会如何变化。
4. Cash Flow Forecasting and Probability | 现金流预测与概率
A school tuck shop forecasts cash inflows for next term. Based on past data, the probability of high sales (£800 per month) is 0.3, medium sales (£500) is 0.5, and low sales (£300) is 0.2. Monthly fixed outflows are £450. Calculate the expected monthly cash inflow and determine the expected net cash flow.
学校小吃店预测下学期的现金流入。根据过去数据，高销售额（每月800英镑）的概率为0.3，中等销售额（500英镑）为0.5，低销售额（300英镑）为0.2。每月固定现金流出为450英镑。计算预期每月现金流入，并确定预期净现金流量。
Expected monthly cash inflow = (800 × 0.3) + (500 × 0.5) + (300 × 0.2) = 240 + 250 + 60 = £550. Expected net cash flow = £550 − £450 = £ nts can then adjust the probabilities and create a new forecast using a simple spreadsheet 'what-if' analysis.
预期每月现金流入 = (800 × 0.3) + (500 × 0.5) + (300 × 0.2) = 240 + 250 + 60 = 550英镑。预期净现金流量 = 550英镑 − 450英镑 = 100英镑。这将数学中常见的概率概念引入会计预测。学生可以接着调整概率，并使用简单的电子表格“假设分析”创建新的预测。
Discuss the limitations of using expected values: the actual outcome could be far lower, which might cause a cash deficit. This adds a layer of business risk management.
讨论使用预期值的局限性：实际结果可能低得多，从而导致现金短缺。这增添了企业风险管理的层面。
5. Invoice Processing and Business Communication | 发票处理与商务沟通
Imagine you run a small stationery supply business. A customer orders 15 packs of printer paper at £4.20 per pack and 10 boxes of pens at £3.60 per box. VAT is charged at 20%. Create a professional invoice showing the item descriptions, quantities, unit prices, line totals, subtotal, VAT amount, and total due. Use a table to present the invoice clearly. Then write a short, polite email to the customer explaining the payment terms of 14 days.
想象你经营一家小型文具供应企业。一位客户订购了15包打印纸，每包4.20英镑，以及10盒笔，每盒3.60英镑。增值税按20%征收。创建一份专业的发票，显示商品描述、数量、单价、行合计、小计、增值税金额和应付总额。使用表格清晰地展示发票。然后写一封简短礼貌的电子邮件给客户，说明付款期限为14天。
| Description | Qty | Unit Price (£) | Line Total (£) |
|---|---|---|---|
| Printer Paper | 15 | 4.20 | 63.00 |
| Box of Pens | 10 | 3.60 | 36.00 |
| Subtotal | 99.00 | ||
| VAT (20%) | 19.80 | ||
| Total Due | 118.80 | ||
The email should include a clear subject line, a thank you, the invoice number, and terms. This task integrates business communication, ICT formatting, and basic VAT computation. It also reinforces the importance of accuracy and professionalism in financial documents.
电子邮件应包含清晰的主题行、感谢语、发票号码和付款条件。这项任务整合了商务沟通、信息通信技术格式设置和基本的增值税计算。它还强化了财务文件中准确性和专业性的重要性。
6. Stock Control and Linear Equations | 库存管理与线性方程
A shop sells an average of 25 units of a product per week. The supplier takes 2 weeks to deliver after an order is placed. The shop also wants a buffer stock of 15 units to cover unexpected demand. Write a linear equation to express the reorder level and calculate it. Then describe how stock control links to cash flow—holding too much stock ties up cash.
一家商店平均每周销售25件产品。供应商在订货后需要2周时间交货。商店还希望有15件的缓冲库存以应对意外需求。写出一个线性方程来表示再订货水平并计算该数值。然后描述库存管理如何与现金流相关联——持有过多库存会占用现金。
+ B, where U=25, L=2, B=15. This simple equation uses algebraic thinking from maths. Students can then explore how changing the lead time or buffer affects the reorder level, perhaps using a spreadsheet to generate a table of values.
再订货水平 = (平均每周使用量 × 交货期周数) + 缓冲库存 = (25 × 2) + 15 = 50 + 15 = 65件。线性方程可以写为 R = (U × L) + B，其中U=25, L=2, B=15。这个简单方程运用了数学中的代数思维。学生可以接着探究改变交货期或缓冲库存会如何影响再订货水平，或许使用电子表格生成数值表。
Additionally, explain that if the shop holds 65 units in stock, and each unit costs £8, then £520 of cash is tied up in stock. Managing stock efficiently helps free up cash for other needs.
此外，解释如果商店持有65件库存，每件成本为8英镑，则会有520英镑现金被占用在库存中。高效管理库存有助于释放现金用于其他需求。
7. Profit Calculation and Percentages | 利润计算与百分比
A retail store buys a jacket for £45 and wants to apply a mark-up of 60% on cost to determine the selling price. Later, during a sale, the store offers a 15% discount on the selling price. Calculate the original selling price, the discounted price, and the profit made at the discounted price. Show all steps.
一家零售商店以45英镑购入一件夹克，并希望在成本基础上加成60%来确定售价。之后，在促销期间，商店对售价提供15%的折扣。计算原售价、折扣价以及在折扣价下获得的利润。请展示所有步骤。
Original selling price = Cost + (Cost × Mark-up%) = £45 + (£45 × 0.60) = £45 + £27 = £72. Discounted price = Original selling price × (1 − Discount%) = £72 × 0.85 = £61.20. Profit at discounted price = Selling price − Cost = £61.20 − £45 = £16.20. The profit margin at the discounted price is (£16.20 ÷ £61.20) × 100 ≈ 26.47%. Percentage calculations like these are common in both maths and accounting.
原售价 = 成本 + (成本 × 加成百分比) = 45英镑 + (45英镑 × 0.60) = 45英镑 + 27英镑 = 72英镑。折扣价 = 原售价 × (1 − 折扣百分比) = 72英镑 × 0.85 = 61.20英镑。折扣价下的利润 = 售价 − 成本 = 61.20英镑 − 45英镑 = 16.20英镑。折扣价下的利润率 = (16.20英镑 ÷ 61.20英镑) × 100 ≈ 26.47%。像这样的百分比计算在数学和会计中都很常见。
Students can be asked to create a spreadsheet that automatically recalculates selling price and profit if the cost or mark-up changes, reinforcing ICT links.
可以要求学生创建一个电子表格，当成本或加成变化时自动重新计算售价和利润，从而强化与信息通信技术的联系。
8. Exchange Rates and Currency Conversion | 汇率与货币换算
A UK-based charity receives a donation of €1,200 from a European supporter. The exchange rate is £1 = €1.16. They also plan to send £350 to a partner in the US when £1 = $ ll be sent. Then discuss how fluctuating exchange rates affect international transactions.
一家英国慈善机构收到一位欧洲支持者捐赠的1,200欧元。汇率为1英镑 = 1.16欧元。他们还计划在1英镑 = 1.28美元时，向美国合作伙伴汇出350英镑。计算该慈善机构从欧元兑换获得的英镑金额，以及将汇出的美元金额。然后讨论汇率波动如何影响国际交易。
Amount in pounds = Amount in euros ÷ Exchange rate (€ per £) = €1,200 ÷ 1.16 ≈ £1,034.48. Amount in dollars = Amount in pounds × Exchange rate ($ per £) = £350 × 1.28 = $ rld financial context. This topic connects accounting with geography and global economics.
英镑金额 = 欧元金额 ÷ 汇率（欧元兑英镑） = 1,200欧元 ÷ 1.16 ≈ 1,034.48英镑。美元金额 = 英镑金额 × 汇率（美元兑英镑） = 350英镑 × 1.28 = 448.00美元。这些计算在实际金融情境中运用了除法和乘法。该主题将会计与地理及全球经济联系起来。
Students could research recent exchange rates online and compute the equivalent amounts, integrating digital literacy with financial numeracy.
学生可以在线查询近期汇率并计算等值金额，从而将数字素养与财务运算能力相结合。
9. Tax Computation and Citizenship | 税务计算与公民责任
An individual earns an annual salary of £28,500. The personal allowance is £12,570. The basic rate of income tax is 20% on taxable income up to £37,700 (after allowance). Calculate the taxable income and the income tax payable. Explain why collecting taxes is essential for funding public services like education and healthcare.
某人年薪为28,500英镑。个人免税额为12,570英镑。所得税基本税率为20%，适用于免税额后不超过37,700英镑的应税收入。计算应税收入和应缴所得税。解释为什么征税对于资助教育和医疗等公共服务至关重要。
Taxable income = Gross salary − Personal allowance = £28,500 − £12,570 = £15,930. Income tax = Taxable income × 20% = £15,930 × 0.20 = £ young people appreciate how society functions. It also reinforces percentage applications.
应税收入 = 总工资 − 个人免税额 = 28,500英镑 − 12,570英镑 = 15,930英镑。所得税 = 应税收入 × 20% = 15,930英镑 × 0.20 = 3,186英镑。这一简单计算与公民教育相关联：理解纳税贡献有助于年轻人认识社会的运行方式。它也强化了百分比的应用。
Extend the task by asking students to calculate National Insurance contributions (e.g., 12% on earnings between certain thresholds) to deepen the numeracy and social awareness link.
扩展任务，要求学生计算国民保险缴款（例如，在特定门槛之间的收入按12%征收），以加深计算能力与社会意识的联系。
10. Decision Making: Cost-Benefit Analysis | 决策：成本效益分析
A school must decide between two printers. Printer A costs £180 and uses ink cartridges costing £35 each, lasting for 600 pages. Printer B costs £240 but cartridges cost £28 and last for 800 pages. Over a period of printing 4,800 pages, which printer is more cost-effective? Calculate the total cost for each option.
一所学校需要在两台打印机之间做出选择。打印机A价格为180英镑，使用的墨盒每个35英镑，可打印600页。打印机B价格为240英镑，但墨盒每个28英镑，可打印800页。在打印4,800页的情况下，哪台打印机更划算？计算每种选择的总成本。
er A: Number of cartridges needed = 4,800 ÷ 600 = 8 cartridges. Total cartridge cost = 8 × £35 = £280. Total cost = £180 + £280 = £ r Printer B: Number of cartridges = 4,800 ÷ 800 = 6 cartridges. Total cartridge cost = 6 × £28 = £168. Total cost = £240 + £168 = £408. Printer B is cheaper by £52. This analysis integrates arithmetic, unit comparisons, and logical decision-making—key skills in accounting and business studies.
对于打印机A：所需墨盒数量 = 4,800 ÷ 600 = 8个。墨盒总成本 = 8 × 35英镑 = 280英镑。总成本 = 180英镑 + 280英镑 = 460英镑。对于打印机B：所需墨盒数量 = 4,800 ÷ 800 = 6个。墨盒总成本 = 6 × 28英镑 = 168英镑。总成本 = 240英镑 + 168英镑 = 408英镑。打印机B便宜52英镑。这项分析整合了算术、单位比较和逻辑决策——这些是会计和商业研究中的关键技能。
Challenge students to consider other factors, such as energy consumption or warranty length, which could affect the decision beyond pure cost. This promotes a broader critical thinking approach.
挑战学生考虑其他因素，如能耗或保修期限，这些可能影响决策而不只是纯粹的成本。这培养了更广泛的批判性思维方法。
11. Payroll Calculations and Data Handling | 工资计算与数据处理
An employee works 38 hours per week at £9.50 per hour. Overtime is paid at 1.5 times the hourly rate for any hours above 38. In one week, the employee worked 44 hours. Calculate the gross pay. Then, using a spreadsheet, create a simple payroll table that automatically computes gross pay when hours are entered. Include columns for basic hours, overtime hours, basic pay, overtime pay, and total gross pay.
一名员工每周工作38小时，时薪9.50英镑。超过38小时的部分按1.5倍时薪支付加班费。某一周该员工工作了44小时。计算总工资。然后使用电子表格创建一个简单的工资表，当输入工时后能自动计算总工资。包括基本工时、加班工时、基本工资、加班工资和总工资等列。
Basic pay = 38 × £9.50 = £361.00. Overtime hours = 44 − 38 = 6 hours. Overtime pay = 6 × (£9.50 × 1.5) = 6 × £14.25 = £85.50. Gross pay = £361.00 + £85.50 = £446.50. The spreadsheet formula for overtime pay could use an IF function: =IF(Hours>38, (Hours-38)*Rate*1.5, 0). This task merges ICT skills with payroll accounting and introduces logical functions.
基本工资 = 38 × 9.50英镑 = 361.00英镑。加班工时 = 44 − 38 = 6小时。加班工资 = 6 × (9.50英镑 × 1.5) = 6 × 14.25英镑 = 85.50英镑。总工资 = 361.00英镑 + 85.50英镑 = 446.50英镑。电子表格中加班工资的公式可使用IF函数：=IF(工时>38, (工时-38)*时薪*1.5, 0)。这项任务将信息通信技术技能与工资会计融合，并引入了逻辑函数。
Discuss why accuracy in payroll is crucial for both the employee and the employer, and the ethical responsibility of accountants.
讨论工资计算的准确性为何对员工和雇主都至关重要，以及会计师的道德责任。
12. Waste Reduction and Sustainability Accounting | 减少浪费与可持续发展会计
A cafeteria tracks food waste over one month. They record that 120 kg of food is wasted, costing £4.50 per kg. If they reduce waste by 25% through better planning, calculate the cost saving and the new waste cost. Then, prepare a short report including a bar chart comparing the original and reduced waste costs, and suggest one more sustainability initiative (e.g., composting) with its potential financial benefit.
一家食堂记录了一个月的食物浪费情况。他们记录到浪费了120公斤食物，每公斤成本4.50英镑。如果他们通过更好的规划将浪费减少25%，计算节省的成本和新的浪费成本。然后准备一份简短报告，包括一个比较原始和减少后浪费成本的条形图，并提出另一项可持续发展措施（例如堆肥）及其潜在的经济效益。
Original waste cost = 120 kg × £4.50 = £540. Waste reduction = 25% of 120 kg = 30 kg. New waste amount = 120 − 30 = 90 kg. New waste cost = 90 × £4.50 = £405. Cost saving = £540 − £405 = £ their environmental image. This connects accounting with environmental science and ethics.
原始浪费成本 = 120公斤 × 4.50英镑 = 540英镑。减少的浪费 = 120公斤的25% = 30公斤。新浪费量 = 120 − 30 = 90公斤。新浪费成本 = 90 × 4.50英镑 = 405英镑。节省的成本 = 540英镑 − 405英镑 = 135英镑。报告应讨论可持续发展会计如何帮助企业降低成本并改善其环保形象。这将会计与环境科学和道德联系起来。
Students can use ICT to create the bar chart, reinforcing the cross-disciplinary nature of modern accounting.
学生可以使用信息通信技术创建条形图，从而强化现代会计的跨学科特性。
Published by TutorHao | Accounting Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图