hiring selection matrix tutorial n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Hiring Selection Matrix Tutorial PowerPoint Presentation
Download Presentation
Hiring Selection Matrix Tutorial

Loading in 2 Seconds...

play fullscreen
1 / 16

Hiring Selection Matrix Tutorial - PowerPoint PPT Presentation


  • 136 Views
  • Uploaded on

Hiring Selection Matrix Tutorial. Texas Tech. Hiring Selection Matrix. What is a Hiring Selection Matrix?

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Hiring Selection Matrix Tutorial' - jael-newton


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
hiring selection matrix
Hiring Selection Matrix
  • What is a Hiring Selection Matrix?
    • A Hiring Selection Matrix is a tool used to objectively compare an applicant’s 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.

Texas Tech

hiring selection matrix1
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.

Texas Tech

hiring selection matrix a snapshot

‘Hiring Selection Matrix’ is an Excel Spread Sheet tool that comes with pre-designed elements. You just have to enter the data.

Hiring Selection Matrix – A snapshot.

Texas Tech

hiring selection matrix3

In this tutorial, we will see how to use this ‘Matrix’ for an ‘Office Support Position.’

To evaluate candidates – type-in all the required and preferred qualifications as listed on your Position Description.

‘Minimum Job Requirements’ as shown on this slide is pre-entered on your Excel sheet.

Hiring Selection Matrix

MINIMUM JOB REQUIREMENTS

Texas Tech

hiring selection matrix4

In the case shown, we enter education, Clerical experience, MS Office experience, Ten key by touch, TTU experience, bookkeeping experience, keyboarding score and spelling score as preferred skills .

In this example, we are looking at office support position.

‘Minimum Job Requirements’ is pre-entered in the first box, as shown. Click on the remaining boxes and type-in all the preferred skills as listed on the Position Description.

Hiring Selection Matrix

SPELLING SCORE

KEYBOARDING EXPERIENCE

EDUCATION

TTU EXPEREINCE

BOOKKEEPING EXPERIENCE

CLERICAL EXPERIENCE

TEN-KEY BY TOUCH

MINIMUM JOB REQUIREMENTS

MS OFFICE PRODUCT EXP.

Texas Tech

hiring selection matrix5

‘Minimum Job Requirements’ always gets rated 5. It is pre-entered.

  • Rate the second criterion – ‘Education.’ Enter the assigned weight in the box below ‘Education.’ We rate it 3.
  • Rate the third criterion – ‘Clerical Experience.’ Enter the assigned weight in the corresponding box below. We rate it 5.
  • Rate the fourth criterion – ‘MS Office Exp.’ Enter the assigned weight in the corresponding box below. We rate it 5.
  • Repeat the above for the preferred criteria that you have in the position description in the vertically aligned boxes above.

For the position, shown here, we rate the ‘preferred skills’ as shown. The scale to be used is 1 to 5.

Assign a weight to Each ‘Preferred Skill’ that you entered in previous slide – Use a scale from 1 to 5 (with 5 being the highest).

Hiring Selection Matrix

3

5

5

4

3

5

4

2

5

Texas Tech

hiring selection matrix6
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.

Texas Tech

hiring selection matrix7

You may enter an ‘X’ under the ‘Minimum Job Requirements’ in the score box against the applicant to set his/her total to zero.

If upon review, you do not see that an applicant meets the minimum requirements as listed on the Notice of Vacancy, place and ‘X’ in the ‘Applicant Score Box’ under the ‘Minimum Job Requirements’ and the applicant score will reset to zero. Remember to document your evaluation thoroughly.

Hiring Selection Matrix

X

0

0

Texas Tech

hiring selection matrix8
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.

Texas Tech

hiring selection matrix9

In this case the hiring supervisor might interview the top two applicants since their scores are close.

Hiring Selection Matrix

Texas Tech

hiring selection matrix10

Assign weights to ‘Interview Score’ and ‘Reference Score’ – Use a scale from 1 to 5 (with 5 being the highest). The weights should be in-line with the scores for the rest of the criteria.

Hiring Selection Matrix

5

5

Texas Tech

hiring selection matrix11
Hiring Selection Matrix

4

3

5

4

  • 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.

Texas Tech

hiring selection matrix12
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.

Texas Tech

hiring selection matrix13
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.

Texas Tech