First day schedule template
An hour-by-hour plan for day one. Free for Canadian employers. Fill in the [HIGHLIGHTED] blanks and remove anything that doesn't apply.
Workbook Control and Identification
| Field | Value |
|---|---|
| Workbook Title | First Day Schedule Template |
| Document ID | [FORM_ID] |
| Template Owner | [POLICY_OWNER_TITLE] |
| Approved By | [OWNER_OR_MANAGER] |
| Effective Date | [EFFECTIVE_DATE] |
| Last Reviewed Date | [LAST_REVIEWED_DATE] |
| Review Cycle | [REVIEW_CYCLE] |
| File Location | [FILE_LOCATION] |
1. Instructions & Data Definitions
1.1 Operating Purpose and Scope
This workbook provides Canadian hiring managers and operational supervisors with a structured tool to plan, document, and execute an employee's first day of work. Structured induction schedules establish clear expectations, reduce early turnover, and ensure operational readiness on day one.
Hiring managers must prepare this schedule at least [N_BUSINESS_DAYS] business days prior to the employee's start date. The schedule coordinates direct supervisor check-ins, mandatory health and safety orientations, peer introductions, administrative intake, and IT access provisioning. Where an employee has requested workplace adjustments, the hiring manager must incorporate verified accommodations into the day-one schedule without recording diagnostic or medical details in this sheet.
Worksheet Architecture Plan
| Sheet Name | Purpose | Sheet Type | Owner | Update Frequency |
|---|---|---|---|---|
| Instructions_Help | Operating guidance, role assignments, and definitions | Instructions | [POLICY_OWNER_TITLE] | Annual |
| Day_One_Schedule | Primary tracking grid for day-one itinerary blocks | Data | [SUPERVISOR_TITLE] | Per new hire |
| Lookup_Lists | Controlled validation lists for drop-down menus | Lookup | [POLICY_OWNER_TITLE] | As needed |
| Summary_Dashboard | Status metrics, completion rates, and lead distribution | Summary | [OWNER_OR_MANAGER] | Real-time |
1.2 User Operating Instructions
- Save a copy of this workbook into the secured employee induction directory at [FILE_LOCATION] using the file naming convention:
DayOne_[EMPLOYEE_NAME]_[EFFECTIVE_DATE].xlsx. - Navigate to the
Day_One_Schedulesheet. Fill in the header details for the new hire. - Populate each sequential itinerary row from arrival to end-of-day sign-off.
- Select activity leads and confirm their availability at least [N_BUSINESS_DAYS] business days before the start date.
- Review physical or digital workspace requirements, required personal protective equipment (PPE), and access credentials.
- Verify whether duty to accommodate requirements apply to the schedule timing or format.
- Print or export the schedule to PDF and transmit it to the new hire and assigned session leads 24 hours before the start date.
- On the start date, track time block completion in real time. Record exceptions, carry-forward items, and sign-offs directly in the tracker.
2. Core Data Table
2.1 Primary Data Dictionary (Day_One_Schedule)
The Day_One_Schedule worksheet captures every structured itinerary item for a new hire's first working day.
Day One Schedule Data Dictionary — Specification
| Col | Header Name | Data Type | Required? | Validation Rule / Allowed Values | Default Value |
|---|---|---|---|---|---|
| A | Record_ID | Text | Yes | Pattern: SCH-#### |
Auto-generated |
| B | Employee_Name | Text | Yes | Valid name string | None |
| C | Job_Title | Text | Yes | Open text | [JOB_TITLE] |
| D | NOC_Code | Text | Yes | List: NOC_List |
[NOC_CODE] |
| E | Work_Location | Dropdown | Yes | List: Location_List |
[WORK_LOCATION] |
| F | Schedule_Date | Date | Yes | Valid Date (YYYY-MM-DD) |
=TODAY() |
| G | Start_Time | Text | Yes | List: Time_Slots |
09:00 |
| H | End_Time | Text | Yes | List: Time_Slots |
09:30 |
| I | Activity_Category | Dropdown | Yes | List: Category_List |
Welcome & Orientation |
| J | Activity_Name | Text | Yes | Max 100 characters | None |
| K | Activity_Lead | Text | Yes | Valid staff name | [SUPERVISOR_TITLE] |
| L | Lead_Role | Dropdown | Yes | List: Role_List |
Direct Supervisor |
| M | Venue_or_Link | Text | Yes | Room name or URL | Main Office |
| N | Required_Materials | Text | No | Free text | None |
| O | Accommodation_Flag | Dropdown | Yes | List: Yes_No_List |
No |
| P | Completion_Status | Dropdown | Yes | List: Status_List |
Scheduled |
| Q | Duration_Minutes | Formula | Yes | Calculated number | None |
| R | Created_Date | Date | Yes | Valid Date (YYYY-MM-DD) |
=TODAY() |
| S | Last_Updated | Date | Yes | Valid Date (YYYY-MM-DD) |
=TODAY() |
| T | Updated_By | Text | Yes | Valid user ID / Name | None |
| U | Supervisor_Notes | Text | No | Free text (Max 250 chars) | None |
Day One Schedule Data Dictionary — Mechanics & Descriptions
| Col | Header Name | Formula Syntax | Description | Example Value |
|---|---|---|---|---|
| A | Record_ID | ="SCH-"&TEXT(ROW()-3,"0000") |
Unique record sequence key | SCH-0001 |
| B | Employee_Name | None | Legal or preferred work name | Jane Doe |
| C | Job_Title | None | Position title matching offer | Inventory Specialist |
| D | NOC_Code | None | Canadian occupational code | 14400 |
| E | Work_Location | None | Physical site or remote hub | Facility A - Floor 1 |
| F | Schedule_Date | None | Calendar date of first day | 2026-04-01 |
| G | Start_Time | None | Block commencement time (24h) | 09:00 |
| H | End_Time | None | Block completion time (24h) | 10:00 |
| I | Activity_Category | None | Operational pillar for the event | Safety Orientation |
| J | Activity_Name | None | Detailed event title | Site Hazard Walkthrough |
| K | Activity_Lead | None | Individual facilitating session | [SUPERVISOR_TITLE] |
| L | Lead_Role | None | Relationship of lead to hire | Direct Supervisor |
| M | Venue_or_Link | None | Physical meeting spot or URL | Safety Office / Room 102 |
| N | Required_Materials | None | Handouts, hardware, or PPE | [REQUIRED_PPE] |
| O | Accommodation_Flag | None | Adjustment incorporated | No |
| P | Completion_Status | None | Execution milestone indicator | Completed |
| Q | Duration_Minutes | =(TIMEVALUE(H4)-TIMEVALUE(G4))*1440 |
Total scheduled minutes for item | 60 |
| R | Created_Date | None | Record entry date | 2026-03-25 |
| U | Supervisor_Notes | None | Operational comments or handover | Handout signed and filed |
3. Status or Scoring Fields
3.1 Lookup Lists Configuration (Lookup_Lists)
The Lookup_Lists sheet maintains controlled validation values for data integrity.
Lookup Lists Reference Table
| List Name | Allowed Values | Target Column in Day_One_Schedule |
|---|---|---|
Location_List |
Head Office | Plant Floor | Warehouse | Remote Hub | Client Site | Col E (Work_Location) |
Category_List |
Welcome & Tour | Documentation & Payroll | IT & Systems Setup | Health & Safety | Role Briefing | Peer Meet & Greet | Wrap-Up & Debrief | Col I (Activity_Category) |
Role_List |
[OWNER_OR_MANAGER] | [SUPERVISOR_TITLE] | [POLICY_OWNER_TITLE] | Peer Buddy | IT Support | Health & Safety Lead | Col L (Lead_Role) |
Status_List |
Scheduled | In Progress | Completed | Deferred | Cancelled | Col P (Completion_Status) |
Yes_No_List |
Yes | No | Pending Confirmation | Col O (Accommodation_Flag) |
Time_Slots |
08:00 | 08:30 | 09:00 | 09:30 | 10:00 | 10:30 | 11:00 | 11:30 | 12:00 | 12:30 | 13:00 | 13:30 | 14:00 | 14:30 | 15:00 | 15:30 | 16:00 | 16:30 | 17:00 | Col G (Start_Time), Col H (End_Time) |
3.2 Calculated Fields and Formulas
All formulas use standard Excel functions and include explicit error handling.
Calculated Fields Definition
| Field | Excel Formula | What It Computes | Error Handling Method |
|---|---|---|---|
| Activity Duration | =(TIMEVALUE(H4)-TIMEVALUE(G4))*1440 |
Computes duration of time block in minutes | =IFERROR((TIMEVALUE(H4)-TIMEVALUE(G4))*1440, 0) |
| Unique Record ID | ="SCH-"&TEXT(ROW()-3,"0000") |
Generates standardized primary key | None (deterministic row calculation) |
| Total Scheduled Minutes | =SUM(Day_One_Schedule!Q4:Q100) |
Sums total induction time planned for the day | =IFERROR(SUM(Day_One_Schedule!Q4:Q100), 0) |
| Items Completed Count | =COUNTIF(Day_One_Schedule!P4:P100,"Completed") |
Tallies finished orientation modules | =IFERROR(COUNTIF(Day_One_Schedule!P4:P100,"Completed"), 0) |
| Schedule Completion % | =COUNTIF(Day_One_Schedule!P4:P100,"Completed")/COUNTA(Day_One_Schedule!A4:A100) |
Overall day-one execution rate | =IFERROR(COUNTIF(Day_One_Schedule!P4:P100,"Completed")/MAX(1,COUNTA(Day_One_Schedule!A4:A100)),0) |
| High Risk Incomplete | =COUNTIFS(Day_One_Schedule!I4:I100,"Health & Safety",Day_One_Schedule!P4:P100,"<>Completed") |
Flags critical unfulfilled safety inductions | =IFERROR(COUNTIFS(Day_One_Schedule!I4:I100,"Health & Safety",Day_One_Schedule!P4:P100,"<>Completed"), 0) |
3.3 Conditional Formatting Rules
Apply the following visual formatting rules to the Day_One_Schedule sheet to facilitate real-time monitoring.
Conditional Formatting Specification
| Target Range | Condition / Rule | Formatting Style | Operational Meaning |
|---|---|---|---|
P4:P100 |
Cell Value equal to "Completed" |
Light Green Fill, Dark Green Text | Block executed successfully. |
P4:P100 |
Cell Value equal to "In Progress" |
Light Yellow Fill, Dark Yellow Text | Session currently underway. |
P4:P100 |
Cell Value equal to "Deferred" |
Light Orange Fill, Dark Orange Text | Postponed; requires immediate rescheduling. |
P4:P100 |
Cell Value equal to "Cancelled" |
Light Red Fill, Dark Red Text | Block omitted; requires justification in notes. |
O4:O100 |
Cell Value equal to "Yes" |
Light Blue Fill, Dark Blue Text | Duty to accommodate adjustment present. |
I4:I100 |
Cell Value equal to "Health & Safety" |
Bold Text, Light Grey Fill | Mandatory compliance activity. |
4. Exceptions & Notes
4.1 Accommodation, Safety, and Privacy Operating Rules
- Duty to Accommodate: If an incoming employee requires functional adjustments (e.g., ergonomic equipment, modified breaks, assistive software, accessible meeting formats), mark the
Accommodation_Flagas "Yes". Do not record personal medical diagnoses, symptoms, or disability categories anywhere in this workbook. - Personal Information Handling: Day-one onboarding involves identity, banking, and emergency contact verification. Completed forms containing personal information (such as Social Insurance Numbers, banking transit codes, and home addresses) must be routed directly to [PAYROLL_SYSTEM] or [HRIS_NAME] and never pasted or stored in this schedule sheet.
- Mandatory Safety Induction: If the employee is deployed in a safety-sensitive environment, the "Health & Safety" block is mandatory prior to operating tools or equipment. If this block is deferred, the employee cannot commence active work duties until the safety lead completes the briefing.
- Inclusive Workplaces: Ensure welcoming, non-discriminatory day-one onboarding practices across all teams, respecting diverse employee backgrounds.
4.2 Sample Data (Day_One_Schedule)
The following five rows illustrate realistic, populated records for an onboarding day.
Day One Schedule Example Data
| Record_ID | Employee_Name | Job_Title | NOC_Code | Work_Location | Schedule_Date | Start_Time | End_Time | Activity_Category | Activity_Name | Activity_Lead | Lead_Role | Venue_or_Link | Required_Materials | Accommodation_Flag | Completion_Status | Duration_Minutes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SCH-0001 | Alex Tremblay | Machine Operator | 94100 | Plant Floor | 2026-04-06 | 08:30 | 09:00 | Welcome & Tour | Arrival & Facility Tour | [SUPERVISOR_TITLE] | Direct Supervisor | Main Lobby | Visitor Badge | No | Completed | 30 |
| SCH-0002 | Alex Tremblay | Machine Operator | 94100 | Plant Floor | 2026-04-06 | 09:00 | 10:00 | Health & Safety | WHMIS & PPE Verification | [FIRST_AID_CONTACT] | Health & Safety Lead | Training Rm B | [REQUIRED_PPE] | No | Completed | 60 |
| SCH-0003 | Alex Tremblay | Machine Operator | 94100 | Plant Floor | 2026-04-06 | 10:00 | 11:30 | Documentation & Payroll | Forms Verification | [POLICY_OWNER_TITLE] | [POLICY_OWNER_TITLE] | Office 104 | Direct Deposit Form | No | Completed | 90 |
| SCH-0004 | Alex Tremblay | Machine Operator | 94100 | Plant Floor | 2026-04-06 | 11:30 | 12:30 | Peer Meet & Greet | Team Lunch | Peer Buddy | Peer Buddy | Lunchroom | Meal Voucher | Yes | Completed | 60 |
| SCH-0005 | Alex Tremblay | Machine Operator | 94100 | Plant Floor | 2026-04-06 | 13:00 | 16:30 | Role Briefing | Workstation Onboarding | [SUPERVISOR_TITLE] | Direct Supervisor | Station 4B | Work Orders | No | In Progress | 210 |
5. Summary & Ownership
5.1 Summary Dashboard Specification (Summary_Dashboard)
The summary worksheet provides supervisors and business owners with aggregated operational visibility over the day-one onboarding execution.
Dashboard Metrics Specification
| Metric Name | Calculation Formula | Source Range | Display Format | Target / Threshold |
|---|---|---|---|---|
| Total Planned Blocks | =COUNTA(Day_One_Schedule!A4:A100) |
Day_One_Schedule!A4:A100 |
Integer | 5 to 8 blocks |
| Total Induction Minutes | =SUM(Day_One_Schedule!Q4:Q100) |
Day_One_Schedule!Q4:Q100 |
Integer (Min) | 420 to 480 min |
| Completed Blocks | =COUNTIF(Day_One_Schedule!P4:P100,"Completed") |
Day_One_Schedule!P4:P100 |
Integer | Match planned |
| Overall Completion % | =IFERROR(D3/D1,0) |
Summary cells D3, D1 | Percentage (0.0%) |
100.0% |
| Deferred / Pending Items | =COUNTIF(Day_One_Schedule!P4:P100,"Deferred") |
Day_One_Schedule!P4:P100 |
Integer | 0 items |
| Safety Compliance Status | =IF(COUNTIFS(Day_One_Schedule!I4:I100,"Health & Safety",Day_One_Schedule!P4:P100,"Completed")>=1,"COMPLIANT","PENDING") |
Day_One_Schedule!I4:P100 |
Text (Status Badge) | "COMPLIANT" |
| Activities by Category | Pivot / =COUNTIF(Day_One_Schedule!I4:I100, A12) |
Day_One_Schedule!I4:I100 |
Bar Chart | Balanced distribution |
| Lead Distribution | Pivot / =COUNTIF(Day_One_Schedule!L4:L100, A20) |
Day_One_Schedule!L4:L100 |
Donut Chart | Multi-role coverage |
5.2 Governance, Access Control, and Retention
- Workbook Ownership: This workbook template is maintained and governed by [POLICY_OWNER_TITLE]. Modifications to lookup tables, validation rules, or standard schedule blocks require approval from [OWNER_OR_MANAGER].
- Access and Permissions: Active schedules contain operational planning and staff names. Files must be saved in the secured directory at [FILE_LOCATION]. Access is restricted to the hiring manager, direct supervisor, and [OWNER_OR_MANAGER].
- Record Retention: Retain completed day-one schedules in the employee's local personnel file for [RETENTION_PERIOD] following termination of employment to confirm completion of mandatory training, orientation, and safety briefings.
What to fill in
| Placeholder | What to enter | Who provides it | Required? |
|---|---|---|---|
| [FORM_ID] | Internal tracking or form identifier (e.g., ONB-SCH-01) | [POLICY_OWNER_TITLE] | Yes |
| [POLICY_OWNER_TITLE] | Title of person overseeing onboarding process (e.g., Office Manager) | [OWNER_OR_MANAGER] | Yes |
| [OWNER_OR_MANAGER] | Title of primary business authority (e.g., General Manager / Owner) | [OWNER_OR_MANAGER] | Yes |
| [SUPERVISOR_TITLE] | Title of direct operational supervisor | Hiring Manager | Yes |
| [EMPLOYEE_NAME] | Full legal or preferred name of new employee | Hiring Manager | Yes |
| [JOB_TITLE] | Position title matching offer letter | Hiring Manager | Yes |
| [NOC_CODE] | 5-digit National Occupational Classification code | Hiring Manager | Yes |
| [WORK_LOCATION] | Site name, facility address, or remote designation | Hiring Manager | Yes |
| [EFFECTIVE_DATE] | Date template comes into active service | [POLICY_OWNER_TITLE] | Yes |
| [LAST_REVIEWED_DATE] | Date template was last evaluated | [POLICY_OWNER_TITLE] | Yes |
| [REVIEW_CYCLE] | Maintenance interval (e.g., Annual) | [POLICY_OWNER_TITLE] | Yes |
| [N_BUSINESS_DAYS] | Advance notice lead time for schedule creation (e.g., 3) | [OWNER_OR_MANAGER] | Yes |
| [FILE_LOCATION] | Secure folder directory or document management URL | [POLICY_OWNER_TITLE] | Yes |
| [REQUIRED_PPE] | Specific PPE required for day-one activities (e.g., CSA boots, safety glasses) | [SUPERVISOR_TITLE] | No |
| [FIRST_AID_CONTACT] | Designated certified workplace first aider or safety lead | [SUPERVISOR_TITLE] | Yes |
| [PAYROLL_SYSTEM] | Name of payroll application or service provider | [OWNER_OR_MANAGER] | Yes |
| [HRIS_NAME] | Name of core HRIS or file storage tool | [POLICY_OWNER_TITLE] | Yes |
| [RETENTION_PERIOD] | Personnel file retention duration (e.g., 7 years) | [POLICY_OWNER_TITLE] | Yes |
Official sources
Government and professional sources this template was checked against.
- Government of Canada — Inclusive Workplace
- National Occupational Classification
- Canadian Human Rights Commission — Duty to Accommodate
- Office of the Privacy Commissioner of Canada — Breach Reporting
- CIPD — Recruitment Resources
This template is general information for Canadian employers, not legal advice. Employment standards, human rights and privacy rules differ by province. Check them before you use it.
Hire people, not paperwork
Staffkin runs the whole hire in one place: prescreens, scored interviews, one-click reference checks and onboarding checklists. Free for your first job.
Start free