Complete Your Payroll System & Rehearse the Demo
This is the build completion milestone. Your team finishes the core analysis, tests edge cases, and prepares a recommendation with cited evidence. You'll also rehearse your presentation and incorporate peer feedback before the final presentation.
Your Team's Business Scenario
Continue working with your assigned scenario from Lesson 08. Focus on completing the payroll system, testing realistic scenarios, and preparing your recommendation for the final presentation.
Team Scenario Assignment
- Group 1: Harbor Market (grocery) — Seasonal hiring surge
- Group 2: TechStart Solutions — Remote team payroll
- Group 3: Riverside Café — Tipped employee focus
- Group 4: Metro Delivery — Gig worker classification
- Group 5: Westside Auto — Mixed hourly/salaried
- Group 6: GreenLeaf Nursery — Agricultural/seasonal
Business Objectives
- Complete all payroll calculations for your scenario's employees
- Run test scenarios (edge cases, high-volume periods, etc.)
- Document findings and identify risks or limitations
- Prepare a recommendation with supporting evidence
Excel Objectives
- Finalize all workbook sheets matching Lesson 07 structure
- Complete dashboard with summary views and charts
- Add validation rules and conditional formatting checks
- Document assumptions and error-handling behaviors
Milestone 2 — Completion & Rehearsal Acceptance Criteria
Complete these items by end of class:
- All 8 sheets complete with formulas, validations, and formatting
- At least 3 test scenarios documented (normal, edge case, stress test)
- Dashboard displays accurate totals and key metrics
- Recommendation draft: 1 claim + 3 cited workbook numbers + 1 risk statement
- Presentation rehearsal complete with peer feedback incorporated
Workbook Structure (Must Match Lesson 07)
Employees
PayrollRegister
TaxTables
PayStubs
BankReconciliation
CashFlow
Dashboard
Documentation
Keep sheet names and order identical to Lesson 07. Every group uses the same structure for direct comparison and consistent grading.
Recommendation Structure
Your team's recommendation must include:
- 1 Clear Claim: What should the business do or understand?
- 3+ Cited Numbers:引用 workbook 中的具体数据 (e.g., total payroll cost, cash flow impact)
- 1 Risk/Limitation: What's a downside or uncertainty in your recommendation?
- Evidence Chain: Show how data flows from Employee → PayrollRegister → Dashboard → Recommendation
Peer Feedback & Revision
After your rehearsal, gather feedback from another team:
Peer Critique & Feedback
Provide constructive feedback to support peer learning and professional development
Unit 5
Reviewing: Classmate
PayDay Milestone 2 Review
Project by Classmate
Progress
0%
Strengths & Highlights
What did this peer do exceptionally well?
Not Rated
Select rating
0 characters
Areas for Growth
Constructive suggestions for enhancement
Not Rated
Select rating
0 characters
Excel Technical Skills
Spreadsheet functionality and accuracy
Not Rated
Select rating
0 characters
Business Analysis
Strategic thinking and real-world application
Not Rated
Select rating
0 characters
Communication & Delivery
Professional presentation and clarity
Not Rated
Select rating
0 characters
Overall Summary & Additional Comments
Provide any additional feedback, suggestions, or overall impressions
0 characters
Please complete all ratings and comments before submitting
Revision Priorities
- Address at least one concrete suggestion from peer feedback
- Verify all formulas calculate correctly
- Ensure dashboard tells a clear story
- Check that recommendation is backed by workbook evidence
Submission Checklist
- All 8 sheets complete with working formulas
- 3+ test scenarios documented in Documentation sheet
- Dashboard displays accurate totals and key metrics
- Recommendation: claim + 3 cited numbers + 1 risk
- Peer feedback received and at least one revision made
Rubric Alignment
- Technical Accuracy — 50%: Formulas, validations, structure
- Strategic Rationale — 20%: Business alignment
- Communication — 15%: Clear documentation
- Time Management — 10%: Pacing and completion
- Q&A Readiness — 5%: Understanding of your scenario
Milestone 2 Reflection
Reflect on your learning journey and growth in the CAP framework
0/3 Complete
🦁COURAGE
What was the most challenging part of this unit that required you to step outside your comfort zone?
0 characters
🌊ADAPTABILITY
How did you adjust your approach when you encountered unexpected problems or feedback?
0 characters
⚡PERSISTENCE
Describe a time when you wanted to give up but kept working. What motivated you to continue?
0 characters
Progress: 0/3 reflections completed