Math for Business Operations

Applied Accounting with Excel

UNIT02 - Lesson 3

Guided Practice: Four Scenarios into Ledger

45 minutes
Lesson Overview

Lesson Focus

Application of adjusting entry knowledge to systematic ledger recording

Key Unit Objectives

Enduring Understandings:

  • Automation reduces human error and increases efficiency in financial processes
  • GAAP compliance requires systematic tracking of accruals, deferrals, and adjusting entries
  • User interface design determines the usability and adoption of financial tools
  • Time savings through automation creates competitive advantage for businesses

Lesson Activities

Activity 1: Scenario Mapping Challenge Setup
5 minutes

Clear instructions for Milestone 1 assessment activity

Details:

  • Review four adjusting entry types: accrual, deferral, depreciation, closing
  • Explain mapping requirement: identify, calculate, and record each type
  • Teams focus on their specialization but must handle all four types
Activity 2: Scenario Analysis & Recording
30 minutes

Independent team work with instructor support on four required scenarios

Details:

  • Scenario 1: Accrued revenue (consulting work completed, invoice pending)
  • Scenario 2: Deferred revenue (annual software license received in advance)
  • Scenario 3: Depreciation (office equipment monthly depreciation)
  • Scenario 4: Closing entries (revenue and expense accounts to retained earnings)
  • Teams must correctly identify, calculate, and record all four types
Milestone 1 Assessment Criteria

All scenarios must demonstrate GAAP compliance and mathematical accuracy

  • Correct identification of each adjusting entry type
  • Accurate calculations showing work and formulas
  • Proper debit/credit application following accounting rules
  • Clear documentation explaining the business rationale
Activity 3: Instructor Support & Verification
8 minutes

Individual team conferences to verify understanding and accuracy

Details:

  • Instructor visits each team to check progress and provide guidance
  • Focus on common errors: wrong account types, calculation mistakes, GAAP violations
  • Provide specific feedback for improvement before peer review
  • Ensure teams are ready for Day 4 gallery walk
Activity 4: Self-Assessment & Preview
2 minutes

Teams evaluate their work and prepare for peer feedback

Details:

  • Teams self-assess against Milestone 1 criteria
  • Identify areas where they need additional practice or clarification
  • Preview Day 4: Peer critique using structured feedback protocol
Required Materials
  • Four adjusting entry scenario packets
  • Ledger templates for recording entries
  • Calculation worksheets and reference materials
  • Milestone 1 assessment rubric
Differentiation Strategies

For Struggling Students

  • • Step-by-Step Macro Guides: Visual walkthroughs for macro recorder usage
  • • Pre-built Templates: Partial VBA code with clear modification instructions
  • • Simplified Scenarios: Focus on one adjusting entry type before expanding
  • • Peer Support: Pair with students strong in Excel automation skills

For Advanced Students

  • • Advanced VBA Functions: Error handling routines and user input validation
  • • Cross-Sheet Integration: Link multiple workbooks for comprehensive systems
  • • Custom Functions: Write UDF (User Defined Functions) for complex calculations
  • • Mentoring Role: Support other teams with technical troubleshooting

For English Language Learners

  • • Visual Interface Design: Use icons and graphics to supplement text instructions
  • • Technical Vocabulary Support: Accounting and Excel terms with visual definitions
  • • Collaborative Documentation: Partner with native speakers for user instruction writing
  • • Multiple Demonstration Formats: Video tutorials with visual emphasis over verbal explanation