Home / Templates / First day schedule

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.

Download Word file

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

  1. 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.
  2. Navigate to the Day_One_Schedule sheet. Fill in the header details for the new hire.
  3. Populate each sequential itinerary row from arrival to end-of-day sign-off.
  4. Select activity leads and confirm their availability at least [N_BUSINESS_DAYS] business days before the start date.
  5. Review physical or digital workspace requirements, required personal protective equipment (PPE), and access credentials.
  6. Verify whether duty to accommodate requirements apply to the schedule timing or format.
  7. Print or export the schedule to PDF and transmit it to the new hire and assigned session leads 24 hours before the start date.
  8. 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

  1. Duty to Accommodate: If an incoming employee requires functional adjustments (e.g., ergonomic equipment, modified breaks, assistive software, accessible meeting formats), mark the Accommodation_Flag as "Yes". Do not record personal medical diagnoses, symptoms, or disability categories anywhere in this workbook.
  2. 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.
  3. 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.
  4. 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

  1. 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].
  2. 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].
  3. 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.

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

More first days and probation templates