Class 3-Workforce profile updated P.pptx

metrics

1. Workforce Profiling Pt.1 Class 3

2. Agenda Questions from last week? Continue practicing the pivot table questions Go through each of the training guides so that you can complete each question without having to look at the suggested answers Assignment 1 – due next class this week at 11:59pm How to profile the workforce and why it is done?

3. Assignment 1: Corporate Profile Report (10%) You are to create a report that contains the following data: Total Headcount Active Employees Gender Diversity (split between male and female with % female) Aboriginal Diversity (employee counts with % that are Aboriginal) Visible Minority Diversity (employee counts with % that are Visible Minority) Disability Diversity (employee counts with % that identify as having a disability) Check the instruction sheet (found in the Assignment folder ) for complete details

4. Diversity

5. Diversity 4 groups in Canada are tracked according to provincial and federal legislation Referred to as “Employment Equity” Persons with a disability Aboriginal / First Nations Women Visible Minorities

6. Tracking Legally Employees do not have to disclose if the belong to one of the four groups Most companies provide a voluntary survey upon hiring, asking if they are from any of the four groups Surveys are reported to the federal or provincial governments to track progress and compliance

7. Diversity Aim: Workforce is Reflective of Society Persons with a disability ~2% of population Indigenous Peoples ~2 – 3 % Women ~48 – 52% Visible minorities ~25% But what if you’re in an area with few of these group?

8. 

9. Class Activity Download the Excel file, “Payroll Database Generesta” from the “Course Case Study Files” folder Today we will create a report that looks at: Headcount Active Employees Gender Diversity (Male, Female, Male %, Female %) Once built, at your tables collect observations

10. Reminder – Next Class Assignment 1 is due at 11:59pm next day of class We will continue this report and include: Leaves of Absence (Total, LTD, Maternity, Sick) Labour Structure (Full-Time, Part-Time, FTE) Age Demographics (Under 25, 25-34, 35-44, 45-54, 55+) Continue practicing the pivot table questions Go through each of the training guides so that you can complete each question without having to look at the suggested answers