Math for Business Operations

Applied Accounting with Excel

UNIT01 - Lesson 7

Exercises: Independent Ledger Construction

45 minutes
Lesson Overview

Lesson Focus

Students independently build complete self-auditing ledger for their TechStart focus area

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: Independent Challenge Setup
5 minutes

Clear expectations for today's independent work

Details:

  • Review success criteria: Working Excel Table, SUMIF functions, error-checking, trial balance
  • Teams choose their specific TechStart client scenario (bakery, pet grooming, or dental)
  • Access provided transaction data for their chosen client type
Activity 2: Independent Ledger Construction
30 minutes

Students apply all learned skills to build complete system

Details:

  • Create Excel Table structure appropriate for their chosen client type
  • Build SUMIF functions for relevant account categories
  • Implement conditional formatting rules for error detection
  • Create trial balance auto-check formula
  • Test system with provided transaction dataset
Milestone 1 Assessment Criteria

Students must demonstrate mastery of all core skills

  • Excel Table: Proper structure with appropriate headers and formatting
  • SUMIF Functions: Accurate account total calculations that update automatically
  • Error Detection: Conditional formatting catches common mistakes
  • Trial Balance: Auto-check formula correctly identifies balanced/unbalanced entries
  • Professional Appearance: Formatted for business presentation
Activity 3: Peer Review & Feedback
8 minutes

Structured peer feedback using assessment criteria

Details:

  • Teams exchange completed ledgers with another team
  • Use rubric checklist to provide specific feedback
  • Test each other's systems with additional transactions
  • Provide constructive suggestions for improvement
Activity 4: Reflection & Preview
2 minutes

Self-assessment and preparation for summary phase

Details:

  • Students self-assess their ledger against success criteria
  • Identify areas needing refinement before final presentation
  • Preview Days 8-10: Integration, refinement, and investor presentation preparation
Required Materials
  • Unit01 advanced practice CSV (resources/unit01-ledger-advanced-practice.csv)
  • Validator reference examples
  • Assessment rubric checklist
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