How do people use Microsoft Office every day?
What each Office program is for
Word vs Excel vs PowerPoint
OneDrive overview
Office ribbon
Saving files
Office Match-Up
Students are given scenarios:
Make a budget.
Write a letter.
Create a slideshow.
They decide which Office program is best.
Typing
Saving
Fonts
Alignment
Spacing
Lists
Design a personal "About Me" document.
Headings
Styles
Images
Text wrapping
Borders
Create a one-page travel flyer or classroom newsletter.
Tables
SmartArt
Shapes
Icons
Create a class schedule or weekly planner.
Comments
Track Changes (simplified)
Sharing
Co-authoring
Students swap documents and leave constructive feedback.
Rows
Columns
Cells
Formatting
Favorite Foods Survey
Students enter class data.
SUM
AVERAGE
MIN
MAX
Calculate classroom statistics.
Pie charts
Bar graphs
Column charts
Turn survey data into charts.
Sort
Filter
Tables
Student gradebook simulation.
Themes
Layouts
Images
Minimal text
Redesign an ugly slide.
Audio
Video
Icons
Animations
Build a presentation about a favorite hobby.
Presenter View
Notes
Speaking skills
Students practice with partners.
Present projects.
Peer feedback.
How do professionals keep their work organized?
OneDrive folders
Sharing
Syncing
Version history
Students organize everything they've created into a clean folder structure and share a folder with you.
Instead of a test...
Students become "Office Interns."
They receive tasks like:
✔ Write a memo in Word.
✔ Create a budget in Excel.
✔ Present results in PowerPoint.
✔ Save everything to OneDrive.
✔ Share it correctly.
This feels authentic and ties the entire unit together.
Throughout the 15 days, students build a single "Dream Event" portfolio.
Examples:
Family vacation
Birthday party
School dance
Gaming tournament
Community fundraiser
Class field trip
Write the proposal.
Build the budget.
Pitch the event.
Organize and share the files.
Students finish with a complete project instead of three unrelated assignments.