Teacher Resources
UNIT05 - Lesson 10
Public Presentation: YouTube Publication & Business Q&A
45 minutes
Lesson Overview
Lesson Focus
Publish professional tutorials and engage with authentic business audience
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: Final Tutorial Upload & Publication
10 minutesPublish completed tutorials to school YouTube channel
Details:
- Upload process: Submit final screencasts to school YouTube channel
- Metadata optimization: Add descriptions, tags, and thumbnails for discovery
- Quality check: Verify video and audio quality meets publication standards
- Link sharing: Prepare links for live audience engagement
Activity 2: Live Business Owner Q&A Session
25 minutesPresent tutorials to real small business owners and answer questions
Details:
- Tutorial presentation: 3-minute live overview of each team's payroll system
- Practical questions: Business owners ask about real-world implementation challenges
- Expert responses: Students demonstrate deep understanding through detailed answers
- Business networking: Professional interaction with local entrepreneur community
Final Assessment: Business Professional Interaction
Authentic assessment through real business community engagement
- Professional communication: Business-appropriate language and demeanor
- Technical mastery: Confident explanation of Excel features and benefits
- Practical application: Realistic advice for actual business implementation
- Problem-solving: Thoughtful responses to unexpected questions and challenges
Activity 3: Unit Reflection & Portfolio Addition
8 minutesReflect on learning journey and document achievements
Details:
- Learning reflection: How did building payroll systems change your business understanding?
- Skill transfer: Which Excel and business skills apply to other contexts?
- Community impact: How does sharing knowledge benefit the local business community?
- Portfolio documentation: Add tutorial links and reflection to digital portfolio
Activity 4: Unit 6 Connection & Closure
2 minutesConnect payroll insights to upcoming pricing analysis unit
Details:
- Cash flow connection: How does payroll timing affect pricing decisions?
- Preview Unit 6: Using payroll cost data for competitive pricing strategies
- Celebration: Acknowledge teams' professional tutorial creation and business engagement
Required Materials
- YouTube upload guide and school channel access
- Business owner contact list and introduction materials
- Reflection prompts connecting to portfolio development
- Unit 6 preview materials showing payroll cost connections
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