Present Your Payroll System & Reflect
This is the final presentation milestone. Your team presents its complete payroll system, demonstrates how it solves the business scenario, and reflects on what makes a payroll system trustworthy.
Your Team's Payroll Scenario
Present the complete payroll system you built for your assigned scenario. Be ready to explain the business problem, your solution, and why the system is trustworthy.
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
Presentation Flow (40 minutes)
- 5 min setup and transitions
- Six groups × ~5 minutes each
- 5 min final wrap and next steps
- Presenter order will be posted at the start of class
Business Objectives
- Demonstrate accurate payroll modeling for your scenario
- Explain the business problem and your solution
- Present your recommendation with cited evidence
- Discuss risks, limitations, and cash-flow impact
Excel Objectives
- Show validated formulas and error-handling
- Demonstrate dashboard and summary views
- Walk through the evidence chain from data to recommendation
- Highlight controls that prevent payroll mistakes
Milestone 3 — Presentation Acceptance Criteria
Complete these items for your presentation:
- Final workbook with all 8 sheets complete and accurate
- 4–5 minute presentation covering: problem, solution, evidence, recommendation
- Dashboard tells a clear story with accurate totals
- Recommendation includes 1 claim + 3 cited numbers + 1 risk statement
- Ready to answer audience questions about your system
What to Include in Your Presentation
- Problem Statement: What payroll challenge does your scenario face?
- Solution Overview: How does your workbook solve it?
- Key Features: Validations, lookups, reconciliation, dashboard
- Evidence Chain: Show the flow from Employee data → Calculations → Dashboard
- Recommendation: Your main claim with cited numbers from the workbook
- Risks & Limitations: What could go wrong or needs more data?
- Q&A Readiness: Be prepared for questions about your system
Audience Review
Audience members should provide feedback using this rubric:
Peer Critique & Feedback
Provide constructive feedback to support peer learning and professional development
Unit 5
Reviewing: Classmate
PayDay Final Presentation
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
Feedback Focus Areas
- Technical accuracy of payroll calculations
- Clarity of the evidence chain
- Strength of recommendation and cited evidence
- Quality of dashboard and visual communication
- Q&A readiness and confidence
Submission Checklist
- Final workbook: PayrollProject-Group[X]-LastNames.xlsx
- All 8 sheets complete with working formulas and validations
- Documentation sheet with test scenarios and assumptions
- Presentation slides or notes (if applicable)
- Peer review feedback submitted
Rubric (used by reviewers)
- Technical Accuracy — 50%: Correct modeling, formulas, validations
- Strategic Rationale — 20%: Aligns to business goals and trade-offs
- Communication & Clarity — 15%: Concise story, visuals, audience fit
- Time Management — 10%: Pacing, clean transitions
- Q&A Readiness — 5%: Confident, concise responses
Post-Presentation 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