Spreadsheet Decisions Basics

Overview

Students learn core Excel functions used in accounting to calculate totals, averages, and costs, then use those results to make a simple cost–benefit judgement about a business scenario. This builds the evaluating and decision-making skill of interpreting information to reach a logical conclusion.

Learning intentions

Students will:

• recall and apply basic Excel skills they already know (e.g. typing values, using cell references)
• use common Excel functions for accounting (SUM, AVERAGE, MIN, MAX, IF) to process financial data
• explain how calculations support a cost–benefit conclusion for a business choice
• check their work for errors using simple verification strategies

Success criteria

• I can use correct formulas with cell references to calculate accounting totals (e.g. invoices, payments).
• I can apply functions (SUM, AVERAGE, IF) to produce accurate results.
• I can interpret outputs and justify a recommended option using a simple cost–benefit comparison.
• I can check my spreadsheet logic (e.g. spot-check values, use consistent formatting).

Curriculum links

• VC2HE10S05 — Students develop and evaluate a response to an economic/business issue using cost–benefit analysis or criteria.
• VC2HE10S02 — Students locate, select, organise and analyse relevant information/data from a given source set.
• VC2HE10K03 — Students understand how indicators and measurements influence decision-making (applied here through calculated financial results).
• VC2HE10K01 — Students use policy/economic understanding as context for business decisions; today’s focus is accounting data used for decisions.

Lesson structure (50 minutes)

1. 0–10 min · Prior knowledge check. Teacher displays a simple blank spreadsheet image (no answers) and asks quick questions: “What does a formula start with?” “Why use cell references instead of typing numbers twice?” Students do a 2-minute think then contribute answers; teacher records key points. Quick check: teacher asks 3 students to read a formula like =C2-D2 aloud to class.

2. 10–30 min · Explicit teaching with videos and discussion. Teacher sets a purpose: “We’re going to calculate accounting numbers accurately and then use them for a business choice.”

• 10–16 min · Core functions demo (video). Teacher plays a short demonstration on Excel functions for beginners. Teacher models typing =SUM(B2:B6) and highlights the difference between formula and result. Students follow on their own device/spreadsheet template.
• 16–22 min · Decision function (IF) demo. Teacher demonstrates =IF(D2>=0,"Profit","Loss") using a made-up weekly profit column. Students practise on one row only, then compare with a partner.
• 22–30 min · Cost–benefit link. Teacher provides a mini business prompt: “Two suppliers charge different fees; which is better for our monthly order?” Teacher explains: cost is what you pay; benefit is what you receive (e.g. total payment and estimated savings). Students discuss: “What numbers matter most?” and “What would count as a benefit in this scenario?”

Success criteria used during teaching: teacher checks students can show one correct formula and one correct function output.

3. 30–50 min · Activity (videos and activity).

• 30–36 min · Video recap (micro). Students watch a 1–2 minute recap video showing SUM and IF in one workflow.

• 36–46 min · Spreadsheet task: “Supplier Choice” (guided). Students receive a spreadsheet with:

• quantity of items

• two supplier fee structures

• a calculated total cost column for each supplier

• a simple “budget limit” cell (e.g. $2,000) Students must add formulas using cell references:

• Use SUM to total costs for each supplier

• Use IF to label “within budget” vs “over budget”

• Produce a one-line conclusion: which supplier to choose using a simple cost–benefit statement (“If we choose X, total cost is…, which means…”)

• 46–50 min · Gallery check. Students do a quick 30-second peer check: partner verifies one formula by reading it aloud and checking a single cell result. Teacher circulates and corrects misconceptions (especially incorrect ranges and mixing up columns).

Resources

• Student devices with Excel (or a school alternative that supports Excel-style functions)
• Provided spreadsheet template: “Supplier Choice”
• Short teacher-selected videos demonstrating SUM and IF (offline or embedded in class system)
• Function formula cards (SUM, AVERAGE, MIN/MAX, IF) for visual support
• Coloured label guidance: blue for input cells, green for calculated results, orange for decision labels
• Whiteboard/slide showing formula examples (no answers hidden for discussion)

Assessment

• Formative checks during step 1: student verbal responses about formula basics and cell references.
• Formative checks during step 2: teacher scans for correct function syntax (e.g. correct brackets and ranges).
• Formative checks during step 3: peer “formula read-aloud” verification plus teacher observation of completed cost and IF outputs.

Differentiation

• Support for students needing scaffolds:
• Provide sentence starters for conclusions: “We choose supplier A because the total cost is ___, so it is/it isn’t within our budget.”
• Offer pre-highlighted cell ranges in the template for SUM (e.g. suggested ranges faintly outlined).
• Provide dyslexia-friendly reading options: students can use an audio option for the scenario brief and printed instructions in a simple, large-font format (12–14pt), plus a colour-coded layout.
• Extension for students ready for more:
• Add AVERAGE of weekly spending to compare trends across 2–3 weeks (if included in the template).
• Add MIN/MAX to identify the lowest-cost week and relate it to a benefit (e.g. more flexibility).
• Upgrade the IF to a two-condition decision using nested logic (e.g. “within budget and cheapest”) if devices/time allow.
• Language/learning considerations:
• Keep wording consistent: “cost” (payments) and “benefit” (value received, savings, meeting budget).
• Allow students to work with a partner for the first function, then individually for the second.

Exit ticket (5 minutes)

Students complete a short written response:

1. Write the function you used to add total costs (with a range or example).
2. One sentence cost–benefit judgement: “Choose supplier ___ because ___.” Teacher collects and quickly checks for correct function use and a reason linked to the calculated result.