Instructions for the Weighted Criteria Evaluation Chart:
This chart is an Excel version of the evaluation chart in the Find Your Niche! book. Detailed instructions and a further explanation can be found on pages 25 through 30.Download here.
Screenshot of the Excel chart.
Preparing the Chart:
1.) In the light green fields at the top, type in up to 12 of your criteria (your personal considerations) for choosing a career. You can resize these fields to fit the length of what you type in.
2.) In the light blue fields at the top, assign a weight to each of your criteria between 1 and 3. Imagine that you were a critic reviewing a music collection: which song would get three stars? Which would get only one? The number of stars would show which songs you value the most. Likewise, assigning a weight to your personal criteria will help you see your prioirities in both your life and work. Make sure to reserve the 3.0's for the things you can't live without, even though it's tempting to simply assign 3.0's to every criterion on your list.
3.) In the bright yellow fields on the left, type in up to 10 of your top professions.
Using the Chart:
1. Across from each profession listed in bright-yellow, there are light-yellow fields for inputting your raw score. Your raw score is a measure of 0 to 10 of how well a specific job meets your fulfills an evaluation criteria.
2. For each profession, type in a number from 0 to 10 of how well each of your criteria matches that job. Once you type in your raw score, the weighted score will automatically be calculated below for you. The weighted score is the raw score times the criteria weight.
3. Once you have completed a row of profession fields, your total will be calculated automaticaly for you. The totals are located on the right side in bright-yellow and bright-blue. The high scores, which are the total of the weighted scores for each profession, are located in blue.
4. Once you have filled out the raw scores for all of your professions, you can compare the high scores to see which ranks the highest. Please see page 28 for further details on how to use the high scores and how to use the chart overall.