Spreadsheet Accounting Skills

Overview

Today students use an Excel spreadsheet to organise accounting data and evaluate simple decisions using cost–benefit thinking (e.g. which option provides better value for money). This builds on students’ ability to interpret data and use criteria to make a justified recommendation.

Learning intentions

Students will:

• understand how Excel can store, organise and calculate accounting information
• enter and format accounting data accurately using tables and formulas
• use criteria (and simple cost–benefit logic) to evaluate a business option
• communicate a clear conclusion supported by spreadsheet calculations

Success criteria

Students can:

• create an Excel sheet with correct headings, number formatting and formulas
• use at least two formulas (e.g. SUM, IF, percentage/margin calculations)
• identify key costs and benefits from the spreadsheet results
• write a short recommendation using evidence from calculations

Curriculum links

• VC2HE10S02: locate, select, organise and analyse relevant information and data from sources
• VC2HE10S03: evaluate and use data to address economic/business or financial issues through trends and cause-and-effect
• VC2HE10S05: develop and evaluate a response to an economic/business issue using cost–benefit analysis or criteria
• (Content link) VC2HE10K04: understand costs and benefits related to economic participation and value decisions (applied today to business options)

Lesson structure (60 minutes)

1. 0–5 min · Hook. Teacher displays a partially completed spreadsheet (missing totals and one wrong formula) and asks: “What is the business problem here and how would you fix it?”

• Students think-pair-share the likely errors and what calculations should be happening.

2. 5–12 min · Mini direct teach: spreadsheet basics. Teacher demonstrates: creating columns/rows, using a header row, applying number formats, and entering one correct formula (e.g. total cost).

• Students follow along on their devices and type the same structure into a blank sheet.

3. 12–25 min · Guided practice: build the accounting model. Teacher provides a scenario: a small shop choosing between two suppliers/plans (Option A vs Option B) with a cost table (e.g. unit price, expected weekly units, delivery fee) and a benefit estimate (e.g. expected weekly sales impact or profit margin).

• Students, in pairs, enter the given numbers, then calculate totals and profit using formulas (at least one SUM and one calculated field such as “Weekly Profit” or “Margin %”).

4. 25–35 min · Add decision logic (criteria). Teacher introduces a simple decision rule using Excel:

• Example criteria: “Choose the option with higher weekly profit if profit is at least $X, otherwise choose the lower total cost.”
• Students add an IF statement or conditional logic to produce a “Decision” cell and a clear “Meets criteria: Yes/No” result.

5. 35–45 min · Evaluate with cost–benefit lens. Teacher prompts: “Which numbers are costs? Which are benefits? What trade-off is happening?”

• Students highlight costs and benefits in their sheet (colour fill or borders) and write two bullet points explaining the trade-off supported by the calculated outputs.

6. 45–55 min · Interactive check: gallery walk and quick feedback. Each pair joins another pair’s desk or rotates using a teacher signal; they compare one formula and one conclusion sentence.

• Students use a short feedback protocol: “I notice… / I wonder… / One suggestion is…”

7. 55–60 min · Exit ticket (individual). Teacher collects a single-page response (or digital form) with:

• (a) one correct formula name used
• (b) the final recommendation (Option A or B)
• (c) one reason using spreadsheet evidence (e.g. “Weekly Profit is $… which meets the criteria.”)
• Students submit independently to ensure individual accountability.

Resources

• Laptop/tablet devices with Microsoft Excel (or school-compatible spreadsheet tool)
• Scenario handout with Option A and Option B data (prices, fees, expected volumes, benefit/profit figures)
• Printed/emailed checklist of required spreadsheet elements (headers, totals, decision cell, highlight costs/benefits)
• Student device login cards and saved template (optional)
• Projector/interactive display for teacher modelling
• Timer visible to the class
• Exit ticket sheet or form

Assessment

• Formative: observe guided practice and check for common formula errors during teacher circulation
• Formative: gallery walk feedback quality (can students justify using calculated results?)
• Summative-in-class: exit ticket recommendation supported by at least one spreadsheet figure and the correct use of a formula

Differentiation

• Support:
• Provide a partially completed template for students who need scaffolding (missing only formulas)
• Offer sentence starters for the conclusion: “I recommend… because… The cost is… The benefit is…”
• Display a formula cheat sheet (e.g. SUM, IF, percentage calculation guidance)
• Extension:
• Challenge students to test “what if” values (e.g. delivery fee increases) and update the decision automatically
• Ask students to add a second criterion (e.g. risk: if profit drop below threshold)
• EAL/SEN considerations:
• Use clear scenario language and consistent labels for columns
• Allow verbal explanation during the gallery walk before writing
• Provide colour-coded categories for costs vs benefits in the sheet structure