Math for Business Operations

Applied Accounting with Excel

UNIT01 - Lesson 1

Introduction: Sarah's Challenge

45 minutes
Lesson Overview

Lesson Focus

Sarah's story, why clean books matter, and transaction categorization warm‑up

Key Unit Objectives

Enduring Understandings:

  • Accurate financial records are the foundation of business credibility and investor confidence
  • The accounting equation (Assets = Liabilities + Equity) governs all business transactions
  • Self-auditing systems prevent errors and build stakeholder trust through automation
  • Professional presentation of financial data communicates business competence

Lesson Activities

Activity 1: Meet Sarah Chen & TechStart Solutions
10 minutes

Watch introduction video about Sarah's digital marketing consultancy and current challenge

Details:

  • Students watch 3-minute video introducing Sarah Chen and TechStart Solutions
  • Video covers: Sarah's background, business services, current clients, record-keeping challenge
  • Students take notes on key business details and challenges mentioned
TechStart Solutions Context

Sarah is 2 months into running her digital marketing consultancy

  • Current clients: Local bakery website ($2,200), Pet grooming social media ($650), Dental office SEO ($1,100)
  • Monthly revenue: $1,300-$1,950 (irregular project-based income)
  • Challenge: Manual notebook tracking is unsustainable for tax preparation
Video: Sarah's Story: The Record-Keeping Challenge (3 minutes)

Meet Sarah Chen, founder of TechStart Solutions, as she explains her growing digital marketing business and the chaos of tracking everything in notebooks. Learn about her three current clients and why she needs a better system before tax season.

Activity 2: Comprehension Activities
15 minutes

Interactive activities to check understanding of Sarah's business situation

Details:

  • Multiple choice questions about Sarah's business model and services
  • Drag and drop activity matching Sarah's clients to their project types
  • Quick quiz on TechStart Solutions' revenue and expense patterns
Activity 3: Turn and Talk: Business Challenge Analysis
12 minutes

Students discuss Sarah's situation and predict what she needs to succeed

Details:

  • Think-Pair-Share: What problems do you see with Sarah's current record-keeping?
  • Partner discussion: What could happen if Sarah doesn't fix her tracking system?
  • Class sharing: What would convince an investor that Sarah has 'clean books'?
Activity 4: Challenge Introduction & Team Formation
8 minutes

Introduce the unit project and form collaborative teams

Details:

  • Present the essential question: How can we design a self-auditing ledger for Sarah?
  • Form teams of 2-3 students to help Sarah solve her record-keeping challenge
  • Teams choose specific TechStart client to focus on for their ledger prototype
  • Quick team planning: What does Sarah need most urgently?
Required Materials
  • Sarah's TechStart Solutions introduction video (3 minutes)
  • Interactive comprehension activities (digital or printable)
  • TechStart client data sheets (bakery, pet grooming, dental office)
  • Think-Pair-Share discussion prompts
  • Team formation materials and project overview
Differentiation Strategies

For Struggling Students

  • • Scaffolded Formulas: Provide partial SUMIF syntax templates
  • • Step-by-Step Guides: Visual walkthroughs for each Excel skill
  • • Peer Tutoring: Pair with students strong in Excel
  • • Alternative Assessment: Oral explanation option for presentations

For Advanced Students

  • • Extension Challenges: Dynamic dropdowns for account selection
  • • Peer Teaching: Support struggling classmates
  • • Advanced Features: Explore pivot tables or basic VBA
  • • Leadership Roles: Facilitate team discussions and planning

For English Language Learners

  • • Vocabulary Support: Business terms glossary with visuals
  • • Translation Tools: Key concepts in home language
  • • Visual Aids: Infographics and flowcharts for processes
  • • Collaborative Support: Mixed-language team structures