Own the Schedule Build

It’s your turn to finish the workbook. Work with your team, but every student needs screenshots or exports of their own roster, schedule, and hours sheets for tomorrow’s peer review.

Harbor Market Scenario

The grocery owner wants six straight days of café coverage, longer bakery prep blocks before holidays, and a rotating cashier crew so nobody burns out. Use the practice dataset plus any custom hires you need.

At least two departments must share one floater (use ID SV01 from the dataset).
Each department should have a different overtime story (e.g., bakery near 40 hours, market below 35).
Add one “what-if” row to the Hours sheet that models an extra Sunday brunch shift.

Deliverables Checklist

Roster updated with at least 10 employees, availability, and overtime flags
WeeklySchedule filled for all 7 days × 4 blocks with zero empty priority slots
Hours & Gross sheet calculating TotalHours, OvertimeHours, GrossPay per ID
Conditional formatting in place: orange when >38 hours, red when over 40
Summary table showing total hours by Department and top overtime risk

Quality Bar

Double-booking rule: No employee ID should appear twice in the same day column.
Availability rule: If a worker marked “no Sundays,” leave them out of Sunday columns.
Cash rule: Hours & Gross must reconcile total hours to the sum of schedule blocks (use SUM to verify).

Use =COUNTIF(Column,ID) to spot duplicates quickly.

Stretch Goals (Optional)

Build a pivot table that shows hours by Department + Day.
Add slicers for Department and MaxHours so the owner can filter instantly.
Create a sparkline per employee that visualizes hour load across the week.

Time Check: You have 12 minutes. Prioritize accuracy before decoration. Save versions often and name your file Lesson05-Schedule-Lastname.xlsx so peer reviewers can find it quickly.

Previous: Guided Practice

Lesson Overview Next: Assessment

Phase Navigation

Hook Introduction Guided Practice Independent Practice Assessment Closing