Hiring Selection Matrix Tutorial

1
Hiring Selection Matrix Tutorial

• Stephen F. Austin State University

2
Hiring Selection Matrix

• What is a Hiring Selection Matrix?
• A Hiring Selection Matrix is a tool used to
  objectively compare an applicants qualifications
  to a job vacancy. With this tool, you can
  objectively and more accurately compare
  applicants to one another.
• Why use a Hiring Selection Matrix?
• This selection tool helps to ensure that hiring
  selection decisions are made only on lawful
  job-related and non-discriminatory criteria, thus
  providing Equal Employment Opportunity to all
  applicants.

3
Hiring Selection Matrix

• Important Steps before you begin
• Save the Hiring Selection Matrix to the Hard
  Disk on your computer.
• Before you open the saved file, go to
  Start/Programs and open Microsoft Excel (your
  saved file is an Excel file).
• In MS Excel, go to Tools on the Menu and then
  to Macro/Security. A security dialog box will
  open. Select Security Level tab and change the
  security level to Medium. Click ok.
• Now open the file (Hiring Selection Matrix) from
  the location where you saved it. A dialog box
  will pop up. Select Enable Macros.
• For rest of the instructions, click the button
  below.

4
Hiring Selection Matrix
A Snapshot
5
Hiring Selection Matrix
6
Hiring Selection Matrix
MINIMUM JOB REQUIREMENTS
7
Hiring Selection Matrix
Spelling Experience
BOOKKEEPING EXPERIENCE
EDUCATION
SFA EXPERIENCE
TYPING/KEYBOARDING EXP.
MINIMUM JOB REQUIREMENTS
CLERICAL EXPERIENCE
TEN-KEY BY TOUCH
MS OFFICE PRODUCT EXP.
8
Hiring Selection Matrix
5
3
5
5
4
3
5
4
2
9
Hiring Selection Matrix
Sheila Angolie
97
97
Mark Moore
108
108
Alicia Redman
151
151
144
144
John Reid

• As you begin to receive the applications, insert
  names of the applicants.
• Rate their education, experience and skills on a
  scale from 1 to 5.
• The Hiring Selection Matrix will calculate the
  weighted score for each criterion and calculate
  the total. The total will appear below the Total
  Score box against each applicant.
• Enter all the applicant names and rate their
  education, experience and skills.

10
Hiring Selection Matrix
X
0
0
11
Hiring Selection Matrix

• At some point you must decide whom to interview.
  It is at this point the Hiring Selection Matrix
  comes to your aid. Click on the Sort button.
• Clicking this button will place the Application
  Scores in descending order with the highest
  ranked applicants at the top.

12
Hiring Selection Matrix
13
Hiring Selection Matrix
5
5
14
Hiring Selection Matrix
4
3
4
5

• Enter the Interview Score and Reference Score
  for the interviewed candidates on a scale of 1
  to 5.
• The Hiring Selection Matrix will automatically
  calculate the Total Score for you.

15
Hiring Selection Matrix
X
0

• If a reference check is so negative that it
  warrants not hiring an applicant, place an X in
  the score box below Reference Score against the
  applicant name and the total Score will
  automatically reset to zero. Remember to document
  the reference check thoroughly.

16
Hiring Selection Matrix

• To make you final hiring decision, click the
  Sort button once again.
• Clicking the Sort button will resort the data
  with the applicant with the highest Total Score
  on the top.
• This candidate according to the Hiring Selection
  Matrix best meets the needs of this particular
  position.

17
Hiring Selection Matrix