Math for Business Operations

Applied Accounting with Excel

UNIT04 - Lesson 10

PBL Milestone 3: Presentations + Peer Review

45 minutes
Lesson Overview

Lesson Focus

Deliver final model and story; collect rubric‑aligned peer feedback; reflect

Key Unit Objectives

Enduring Understandings:

  • Data-driven decisions provide competitive advantages in business operations
  • Statistical analysis reveals patterns that guide inventory and staffing optimization
  • Forecasting models enable proactive business planning and risk management
  • Outlier identification prevents skewed analysis and faulty business conclusions

Lesson Activities

Activity 1: Presentation Block
40 minutes

5 min setup; 6 groups × ~5 min; 5 min wrap

Details:

  • Presentations target 4–5 minutes plus brief Q&A
  • Audience uses PeerCritiqueForm aligned to standard rubric
  • Emphasis on accuracy, clarity, and decision impact
Activity 2: Reflection & Submit
5 minutes

Submit files and reflect on learning

Details:

  • Submit final workbook, slides, and collected peer reviews
  • Write short reflection focusing on CAP and next improvements
Required Materials
  • Rubric reference and PeerCritiqueForm
  • Submission checklist
  • Reflection prompts
Differentiation Strategies

For Struggling Students

  • • Guided Analysis Templates: Step-by-step worksheets for statistical calculations
  • • Simplified Datasets: Smaller, cleaner data samples for initial practice
  • • Visual Learning Supports: Screencasts demonstrating Analysis ToolPak procedures
  • • Peer Mentoring: Partner with students strong in statistical analysis
  • • Alternative Presentations: Poster session format instead of elevator pitch

For Advanced Students

  • • Multiple Regression Models: Explore relationships between multiple variables
  • • Seasonal Trend Analysis: Investigate more complex time-based patterns
  • • Statistical Significance Testing: Apply t-tests and confidence intervals
  • • Advanced Visualization: Create interactive dashboards or animated charts
  • • Consulting Role: Support other teams while completing their own analysis

For English Language Learners

  • • Statistical Vocabulary Support: Bilingual glossary of key terms with examples
  • • Visual Communication Emphasis: Focus on charts and infographics over verbal presentations
  • • Collaborative Team Roles: Pair with native speakers for presentation support
  • • Template-Based Writing: Structured formats for analysis documentation and reflection