Teacher Resources
UNIT05 - Lesson 9
Mock Panel & Revisions: Tutorial Refinement
45 minutes
Lesson Overview
Lesson Focus
Receive feedback and refine tutorials for maximum impact
Key Unit Objectives
Enduring Understandings:
- Accurate payroll calculations protect both employees and business owners from legal and financial risks
- Cash flow timing is critical - payroll commitments must align with revenue cycles
- Systematic reconciliation processes prevent costly errors and maintain compliance
- Professional payroll systems build employee trust and business credibility
Lesson Activities
Activity 1: Mock Screencast Presentations
25 minutesTeams present draft tutorials to peer audience for feedback
Details:
- 3-minute tutorial previews: Each team shows key segments of their screencast
- Clarity assessment: Does the explanation make sense to non-experts?
- Technical review: Are Excel demonstrations smooth and professional?
- Business value check: Is the practical impact clearly communicated?
Activity 2: Structured Peer Feedback
12 minutesSystematic feedback using professional review criteria
Details:
- Screencast rubric review: Evaluate tutorials against final assessment criteria
- Specific suggestions: Provide actionable feedback for improvement
- Technical accuracy check: Verify all Excel formulas and explanations are correct
- Audience appropriateness: Ensure language and pace suit target audience
Peer Feedback Focus Areas
Effective feedback helps tutorials reach professional standards
- Clarity: Can non-experts follow the explanation and demonstration?
- Accuracy: Are all calculations and Excel features explained correctly?
- Business value: Is the practical impact clearly communicated?
- Professional polish: Does the tutorial reflect well on the school/students?
Activity 3: Revision Planning & Implementation
8 minutesPlan and begin implementing improvements based on feedback
Details:
- Priority setting: Identify most critical improvements for tutorial success
- Resource allocation: Divide revision tasks among team members efficiently
- Timeline planning: Schedule final recording and editing for tomorrow
- Quality standards: Commit to professional standards for published tutorial
Required Materials
- Screencast evaluation rubric
- Peer feedback forms with specific criteria
- Revision planning templates
- Technical troubleshooting guide for recording issues
Differentiation Strategies
For Struggling Students
- • Pre-filled Calculator Templates: Provide partial Excel structures to reduce complexity
- • Step-by-Step Formula Guides: Visual walkthroughs for complex calculations
- • Simplified Scenarios: Focus on hourly employees before adding salaried/tipped
- • Extra Practice Time: Additional support sessions for Excel skill building
For Advanced Students
- • Multi-Jurisdiction Payroll: Handle employees in different states with varying tax rules
- • Advanced Excel Features: Explore Power Query for large payroll data processing
- • Leadership Roles: Mentor struggling students and facilitate team discussions
- • Business Extension: Research actual payroll service costs vs. internal processing
For English Language Learners
- • Bilingual Resources: Payroll terms glossary in home language
- • Visual Calculation Guides: Infographics showing payroll process flow
- • Cultural Context: Examples relevant to diverse cultural backgrounds
- • Translation Support: Peer translators for complex business concepts