Step 1: Criteria
The class need to collaborate and develop a set of criteria to evaluate the 3 careers. CRP Phase 3 is dueSunday November 20, 2016 at 11:59 PMOur criteria for Phase 3 will be:
Pay/BenefitsLocationQualifications/SkillsJob growthwork/life balance
Step 2: Evaluation Matrix
Create an evaluation matrix in Excel that will let you compare the 3 careers side by side on each criterion. Refer to the tutorial presentation about creating an evaluation matrix if needed. What should be in the matrix is the 3 careers, the criteria to be used, how you personally weigh each criterion. Create your own matrix in Excel and name this file EM_Lname (where Lname is your lastname).
Evaluation Matrix Tutorial
- Evaluation Matrix Tutorial.pdf (314.658 KB)
Learn how an evaluation matrix is constructed. One of the most important parts is developing criteria that will be used in your evaluation. This presentation has some blank slides for you to practice coming up with criteria for various decisions (not the one that is the focus of your research project). Try coming up with your own criteria before looking at the completed presentation below.
Step 3: Rate Criteria
Based on your research, rate each career on each criterion (on a scale of 1 to 100). Again refer to the presentation about creating an evaluation matrix if needed. After you have rated all 3 careers, create Excel formulas to calculate weighted scores using a mixed cell reference. Remember you personally gave a weight to each criteria in Step 2. This will enable you to see which career scored best with the raw scores and then which career scored best with the weighted scores.
Step 4: Create a Chart
Create an Excel chart worksheet. The chart may be the style of your choice. It must give good information about the data in your worksheet. Name each worksheet in the workbook appropriately (One worksheet is your evaluation matrix the other is your Chart). Submit your file with both worksheets into the Blackboard assignment for this phase.
Click on this link and submit your completed evaluation matrix and chart.