INSTRUCTIONS AND RESOURCES

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)

NOTE: when reporting percentages, only show the data to 1 decimal place. For this report, create a "Leadership" grouping for the executive team (include all VPs and the C-Suite occupations: CEO, CFO, CHRO, CIO and COO. Do NOT include Managers in this grouping). Make sure that this group has been collapsed so only the heading "Leadership" is visible and none of the individual occupations are visible. Then create another group for all other employees and label it "All Other Occupations". For this group, make sure it is expanded to show the occupations that are included in this section.

Employee ID Gender 200000 M 200001 M 200002 M 200003 M 200004 M 200005 M 200006 F 200007 M 200008 M 200009 F 200010 M 200011 M 200012 M 200013 M 200014 M 200015 F 200016 M. 200017 M 200018 M Age Status Pave Reaso Part/Full Time 38 Active Active Full Time 47 Active Active Full Time 42 Active Active Full Time 60 Active Active Full Time 41 Active Active Full Time 53 Active Active Full Time 38 Active Active Full Time 63 Active Active Full Time 45 Active Active Full Time 32 Active Active Full Time 25 Active Active Part Time 21 Active Active Full Time 62 Active Active Full Time 44 Active Active Part Time 43 Active Active Full Time 38 Active Active Full Time 53 Active Active Full Time 41 Active Active Full Time 65 Active Active Part Time Occupation Division CEO Main Office CFO Main Office CHRO Main Office CIO Main Office COO Main Office VP Education Software Main Office VP Government Software Main Office VP Medical Software Main Office VP Military Software Main Office Cleaning Services Main Office Co-op Students Government Software Engineer Medical Managers Military Managers Military Managers Military Administrators Main Office Accounting Medical Managers Government Managers Military Service Years Salary Visible Minority? Aboriginal? Disability? 12 $663,532.08 Yes No No 27 $487,583.79 No No No 22 $256,127.66 Yes No No 17 $281,621.88 No No No 4 $370,921.53 No No No 22 $343,076.96 Yes No No 14 $315,557.59 Yes No No 4 $318,590.76 No No No 22 $374,621.46 No Yes No 2 $44,915.56 No No No 0.5 $18,192.53 Yes No Yes 2 $147,320.44 No No No 22 $249,253.48 Yes No No 5 $182,990.63 Yes No No 13 $212,068.32 Yes No No 14 $42,732.91 No No No 19 $79,481.70 No No 4 $187,258.88 No Yes 25 $253,245.74 Yes No Yes 2 2 2