Employment Candidate Evaluation

ModelSheet: Custom spreadsheets in minutes

Improve your employment candidate selection process 

This model provides a method for scoring employment candidates based on a list of evaluation criteria. It helps to surface criteria and subjective judgments with its simple and transparent scoring method.

Fully Customizable

Using our automated modeling technology you can create a report that exactly suits your needs. Enter opportunities criteria on a series of simple online forms. There’s nothing to install or learn. Each step is explained, and serves as a prompt for items you may not have considered.

Features

This model asks you to enter:

  • A list of candidates
  • A list of evaluation criteria
  • Scores for each opportunity on each criterion

Easy to Use

Once downloaded, your Candidate Evaluation model is presented in a logical and intuitive format in Excel or Google Docs. Your spreadsheet contains:

  • A carefully arranged layout
  • Excel comments explaining each table
  • Color-coding for data entry
  • Easy modifiable data and preferences

Background:

This model is inspired by research in cognitive psychology on how people make decisions, as summarized in Rational Choice in an Uncertain World, by Reid Hastie and Robyn M. Dawes (2001). Hastie and Dawes recommend replacing subjective integration of multiple decision criteria with weighted linear models of the general type used in this application.

Some people have an uncanny ability to pick good performers. People do a reasonably good job of evaluating one performance dimension at a time; but they are less effective at integrating several performance criteria. This conclusion holds across many if not all domains of human decision-making.

Research shows that many objective measures of performance predict future performance better than subjective opinions from personal interviews. This conclusion holds for decisions regarding employment, school admissions, and promotion, when follow-up studies compare actual performance.

When using quantitative measures of potential, users must ensure that criterion weights and candidate ratings reflect sound judgments. Othewise the quantitative analysis can take on an undeserved life of its own when the model does not capture important aspects of the decision process.

 
StandardProPower Pro
  • Candidates
  • Evaluation criteria
All features in Standard version plus:
  • Summary sheet for each candidate
  • More candidates
  • More evaluation criteria
All features in Pro version plus:
  • More candidates
  • More evaluation criteria
7 day free trial or $147 day free trial or $247 day free trial or $34
Microsoft Office Marketplace logo
Works with Microsoft® Excel® 2003 - 2010
 

Customize spreadsheets by filling in a simple form

Step 11. Choose
The model you want
Step 22. Customize
Online form does the work
Step 33. Download
And it's ready to use

Each spreadsheet offers:

  • Carefully organized layout
  • Comments on every variable table
  • Collapsible groups hide details until wanted
  • Easy-to-read symbolic formulas show what the model does
  • Easily change input data, start date, label text...
Meet your exact needs better than any static template.
 
Learn more about ModelSheet spreadsheet customization solutions

Related spreadsheet models

Decision Support
 

Can't find your solution
Need to know more?

Find out how our consulting services can help you create and manage your ideal custom spreadsheet models.
Go to Consulting Services
 
 

Copyright © 2010, 2011 by ModelSheet Software LLC | All Rights Reserved | Privacy

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.