Math for Business Operations

Applied Accounting with Excel

UNIT06 - Lesson 6

Peer Critique & Model Refinement

45 minutes
Lesson Overview

Lesson Focus

Structured peer feedback on CVP automation and collaborative improvement

Key Unit Objectives

Enduring Understandings:

  • Pricing decisions require balancing profitability with market competitiveness
  • Cost-Volume-Profit relationships govern business viability and strategic planning
  • Data-driven analysis provides objective foundation for subjective business decisions
  • Sensitivity analysis reveals business vulnerabilities and opportunities

Lesson Activities

Activity 1: Gallery Walk
25 minutes

Teams review scenario runners and CVP models using an evaluation checklist

Details:

  • Rotate to 3–4 teams and review their models
  • Use checklist to evaluate automation, clarity, and validation
  • Leave one specific praise and one actionable suggestion per team
Activity 2: Revision Sprint
15 minutes

Teams implement high-impact fixes based on peer feedback

Details:

  • Prioritize top two issues identified in feedback
  • Implement fixes and re‑test Goal Seek and Data Tables
  • Update documentation and checklist items
Activity 3: Reflection
5 minutes

Record key improvements and open questions for instructor feedback

Details:

  • Note one improvement made today and its impact
  • List any remaining blockers to discuss with instructor
Required Materials
  • Peer critique forms with evaluation criteria
  • Investor-ready checklist
  • Revision planning template
Differentiation Strategies

For Struggling Students

  • • CVP Templates: Pre-built model structures with guided formula entry
  • • Visual Calculators: Step-by-step markup vs. margin calculation guides
  • • Peer Partnerships: Pair with students strong in Excel or business analysis
  • • Alternative Assessment: Focus presentation on business insights rather than technical details

For Advanced Students

  • • Advanced Modeling: Incorporate seasonality and demand elasticity into CVP models
  • • Leadership Roles: Facilitate peer critique sessions and support struggling teams
  • • Extended Analysis: Research actual competitor financial statements for deeper insights
  • • Presentation Enhancement: Create interactive Excel dashboards for town hall debate

For English Language Learners

  • • Business Vocabulary: Glossary of CVP and pricing terms with visual definitions
  • • Formula Explanations: Mathematical concepts explained with universal symbols
  • • Cultural Context: Discussion of pricing practices in different economic systems
  • • Collaborative Support: Mixed-language teams with peer translation assistance