Math for Business Operations

Applied Accounting with Excel

UNIT01 - Lesson 3

Core Concepts: Debit & Credit Rules

45 minutes
Lesson Overview

Lesson Focus

Direct instruction on debit/credit mechanics using Sarah's TechStart transactions

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: The Debit/Credit Mystery
5 minutes

Hook students with the fundamental business recording system

Details:

  • Why does every business transaction need exactly two entries?
  • Connect to Sarah's challenge: She tracks money coming in, but what about the complete picture?
  • Today's goal: Master the universal business recording language
Activity 2: T-Account Foundation & Rules
20 minutes

Direct instruction on debit/credit rules using TechStart account types

Details:

  • Introduce T-accounts using Sarah's TechStart chart of accounts
  • Demonstrate: Assets increase with debits (Sarah's cash account grows on the left)
  • Show: Equity increases with credits (Sarah's ownership grows on the right)
  • Practice: Revenue from client projects increases equity (credit revenue accounts)
The Debit/Credit Rules for TechStart

Every transaction has equal debits and credits

  • Assets (Cash, Equipment): Increase with DEBITS, decrease with credits
  • Liabilities (Software subscriptions, bills owed): Increase with CREDITS, decrease with debits
  • Equity & Revenue (Sarah's ownership, client payments): Increase with CREDITS, decrease with debits
  • Expenses (Software costs, supplies): Increase with DEBITS (they reduce equity)
Activity 3: TechStart Transaction Recording
15 minutes

Guided practice recording Sarah's actual business transactions

Details:

  • Model: Record the bakery website project ($2,200 cash received)
  • Guided practice: Students record the pet grooming social media project ($650)
  • Partner work: Record Sarah's Adobe Creative Suite subscription expense ($52.99/month)
  • Check work: Verify debits equal credits for each transaction
Activity 4: Journal Entry Mastery Check
5 minutes

Quick assessment of debit/credit understanding

Details:

  • Exit ticket: Record one TechStart transaction independently
  • Self-check: Do my debits equal my credits?
  • Preview Day 4: How do we build these entries into an Excel system for Sarah?
Required Materials
  • TechStart Chart of Accounts template
  • T-account practice worksheets
  • Sarah's actual transaction data (from narrative context)
  • Debit/Credit rules reference guide
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