Each Class Will Set Their Own Criteria And Your Instructor

Each Class Will Set Their Own Criteria And Your Instructor Will Post T

Each class will set their own criteria and your instructor will post these into Blackboard under Phase 3. Most classes will use salary, education, passion, etc., but you need to make sure you are using the exact criteria for your class. You will use the criteria to evaluate your careers.

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. Divide 100 points among the criteria, with the highest number of points going to the criteria that is most important to you. Evaluation Matrix Tutorial Attached Files: Evaluation Matrix Example Criteria 17.pdf (188.588 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. 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. Submit your file with both worksheets into the Blackboard assignment for this phase.

Paper For Above instruction

The assignment requires creating a comprehensive evaluation matrix in Excel to compare three different careers based on selected criteria. This process involves multiple steps, including identifying relevant criteria, assigning weights, scoring each career, calculating weighted scores, and visualizing the results with a chart. The goal is to facilitate an informed decision-making process by systematically analyzing the strengths and weaknesses of each career option through quantitative measures.

Introduction

Evaluating potential careers involves understanding various aspects such as salary potential, educational requirements, passion alignment, job stability, growth prospects, and work-life balance. An evaluation matrix provides a structured framework to compare these facets across multiple options, enabling students or decision-makers to make rational, data-driven choices.

Step 1: Setting Criteria

The initial step involves determining the criteria that are most relevant to the decision. While some classes might suggest criteria like salary, education, or passion, it is crucial for each student to tailor these based on personal priorities and the specific careers under consideration. Developing meaningful criteria is essential, as these serve as the foundation for the entire evaluation process. For instance, a student might include criteria such as earning potential, educational investment, job satisfaction, job security, work environment, and societal impact.

Step 2: Developing the Evaluation Matrix

Creating an evaluation matrix in Excel involves listing the three careers as columns and the selected criteria as rows. Each cell contains a score that reflects how well a given career performs on a particular criterion. To incorporate personal priorities, students assign weights to each criterion, summing up to 100 points. The weighting process emphasizes the importance of specific criteria over others, aligning the evaluation with individual values and preferences.

For example, if salary is deemed most important, it may receive 40 points, while other criteria like passion or education might receive fewer points accordingly. Developing this matrix requires careful consideration to ensure that the weights and scores accurately reflect personal evaluations and research findings.

Step 3: Rating the Careers

Using research or factual data, students then assign a score from 1 to 100 for each career on each criterion. These ratings should be based on credible sources such as industry reports, job market analyses, or personal insights. After scoring, Excel formulas are employed to calculate weighted scores by multiplying each criterion score by its corresponding weight. The use of mixed cell references ensures that the calculations update automatically if any scores or weights are revised.

This step allows students to objectively compare the careers, revealing which option scores highest both in raw scores and weighted assessments. The weighted scores provide a nuanced view, factoring in personal priority and quantitative data.

Step 4: Creating Visual Representations

The final step involves visualizing the comparison using Excel charts. A bar, column, or spider chart can effectively illustrate the performance of each career across multiple criteria. Proper labeling and coloring enhance clarity and make it easier to interpret which career stands out in specific areas or overall.

Naming all worksheets appropriately aids navigation within the workbook. Submitting the Excel file with both the data and charts completes the assignment, providing a comprehensive visual and numerical analysis of the career options.

Conclusion

The evaluation matrix is an invaluable decision-making tool in career planning, combining quantitative data with personal values. Its flexibility allows for customized criteria and weights, making the comparison relevant and meaningful for individual goals. Using Excel for this purpose enhances analytical accuracy and provides clear visual insights, supporting an informed career choice.

References

• Belton, V., & Stewart, T. J. (2002). Multiple Criteria Decision Analysis: An Integrated Approach. Springer.
• Hwang, C. L., & Yoon, K. (1981). Multiple Attribute Decision Making: Methods and Applications. Springer.
• Keeney, R. L., & Raiffa, H. (1993). Decisions with Multiple Objectives: Preferences and Value Trade-offs. Cambridge University Press.
• Roy, B. (1996). Decision methods for assessing and prioritizing environmental risks. European Journal of Operational Research, 94(2), 266-280.
• Saaty, T. L. (1980). The Analytic Hierarchy Process. McGraw-Hill.
• Simon, H. A. (1960). The Design of Decision-Making. Harper.
• Thurstone, L. L. (1927). A Law of Comparative Judgment. Psychological Review, 34(4), 273-286.
• Vaidya, O. S., & Kumar, S. (2006). Analytic hierarchy process: An overview of applications. European Journal of Operational Research, 169(1), 1-29.
• Zeleny, M. (1982). Multiple Criteria Decision Making. McGraw-Hill.
• Yoon, K., & Hwang, C. L. (1995). Multiple Attribute Decision Making: An Introduction. Sage.