Math for Business Operations

Applied Accounting with Excel

UNIT01 - Lesson 2

Core Concepts: The Accounting Equation

45 minutes
Lesson Overview

Lesson Focus

Direct instruction on foundational accounting principles using TechStart examples

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: Sarah's Transaction Challenge
5 minutes

Connect to Day 1 with Sarah's specific record-keeping problem

Details:

  • Review: Sarah has transactions but no system to organize them
  • Preview: Today we learn the foundation that makes all ledgers work
  • Connect to essential question: What makes a ledger trustworthy?
Activity 2: The Accounting Equation Foundation
20 minutes

Direct instruction on Assets = Liabilities + Equity using TechStart examples

Details:

  • Introduce the accounting equation with Sarah's TechStart business
  • Show how Sarah's laptop (asset) was purchased with personal funds (equity)
  • Demonstrate how client payments increase both assets (cash) and equity (retained earnings)
  • Use TechStart client projects to show equation in action
The Universal Business Language

Assets = Liabilities + Equity governs ALL business transactions

  • Assets: What Sarah's business owns (cash, equipment, client payments owed)
  • Liabilities: What Sarah's business owes (software subscriptions, contractor payments)
  • Equity: Sarah's ownership stake in the business (initial investment + profits)
Activity 3: TechStart Transaction Analysis
15 minutes

Guided practice using Sarah's actual business transactions

Details:

  • Analyze the bakery website project: How does the $2,200 payment affect the equation?
  • Break down the dental office SEO project into its accounting equation impact
  • Show how Sarah's business expense (software subscription) affects the equation
  • Partner check: Students verify equation balance after each transaction
Activity 4: Check for Understanding
5 minutes

Quick assessment of equation comprehension

Details:

  • Exit ticket: Given a TechStart transaction, identify the equation impact
  • Students predict how Sarah's next client payment will affect her business equation
  • Preview Day 3: How do we track these equation changes systematically?
Required Materials
  • TechStart business transaction examples
  • Accounting equation visual aids
  • Sarah's client project details (from narrative context)
  • Interactive equation balance worksheets
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