Lesson ProgressPhase 2 of 6
Phase 2Introduction
Introduction: Project Rehearsal: Shared Payroll Workbook Audit
Present the shared workbook download path, name each sheet and evidence block, define success criteria
Phase 2: Shared Artifact Orientation
Your Shared Payroll Workbook
Download the shared teacher workbook. Every group uses this same file today so we can compare audit findings. Your job is to understand the structure, then trace evidence from calculations to recommendation.
Download: Shared Workbook
Download: unit05-lesson07-student.xlsx
This is the same workbook every group uses today. The teacher workbook has complete solutions. Focus on understanding the structure and evidence chain, not just matching answers.
Workbook Map: What Each Sheet Proves
| Sheet | Purpose | Evidence It Provides |
|---|---|---|
| Employee_Data | Raw employee hours, rates, and tax info | Input zone - validates hours, rates, dates |
| Payroll_Calculations | Gross pay, deductions, net pay per employee | Core calculations - links to Employee_Data |
| Tax_Tables | Federal and state tax brackets | Lookup source for deductions |
| Bank_Reconciliation | Compare payroll register to bank statement | Tie-out proof - differences explained |
| Dashboard | Executive summary with KPI thresholds | Decision-ready output - recommendation + risk |
Definition of Done
A complete, submission-ready project workbook includes:
- Payroll calculations accurate for all 10 employees
- Reconciliation tie‑outs pass (register = bank within $0.01)
- Executive summary states one clear recommendation with supporting evidence
- Validation rules catch invalid inputs (negative hours, rates greater than 100%, stale dates)
- Charts bind to Tables using structured references
- Clear error messages on lookup failures (IFNA/IFERROR)
Vocabulary for Workbook Audit
Lock in key terms for today's rehearsal.
Attempts: 0Score: 0%
📝 Fill in the Blanks
Complete each sentence by typing the missing word or phrase
📚 Word Bank
Available answers