Create an Evaluation Matrix Chart in Excel that will let you compare the 3 careers/positions at technology companies side by side on each criterion. 

What should be in the matrix are:

1. Three technology careers/positions (i.e. system analysis, software engineer, help desk technician) to evaluate.
2. Five criteria (all students must use these criteria).  

   Salary
   Education/Certification
   Career Outlook (what percentage of jobs will be available in the future)
   Duties
   Work Schedule

Look up the criteria for each of your careers/professions on the Bureau of Labor and Statistics Occupational Outlook Handbook at 

https://www.bls.gov/ooh/

 and O*Net  

https://www.onetonline.org/

.  You may use other sources of information. 

Create 2 Excel worksheets.   

1. The first is your Excel matrix chart with 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.
2. The second is a chart of your results from the matrix.  The chart may be the style of your choice. It must give good information about the data in your worksheet with your matrix. Name each worksheet in the workbook appropriately. Submit your file with both worksheets into the Blackboard assignment for this phase.

Divide 100 points among the criteria, with the highest number of points going to the criteria that is most important to you.

An example of the matrix is in this section as an attachment.  Watch videos in the video reference folder for guidance.  Additional Resources available under GCFLearnFree.org section.

Do not forget to record your sources/references.

Find attach an example of evaluation matrix example criteria.

Evaluation Matrix

An important tool you can use to
make informed decisions

Decisions Can Be Difficult

• When making a choice among several
options, it helps to know at the outset what
is of greater or lesser importance to you

• Most of us cannot “have it all”

• The “yardsticks” you will use to measure how
each option rates on different factors can be
called criteria (singular is “criterion”)

Car Purchase

• Some factors (criteria) that may be
important:

– Gas mileage

– Seating capacity

– Cost

– Warranty

– Cost of maintenance

– Cargo capacity

College Transfer Choices

• Cost

• Programs Offered

• Transferable Credits

• Housing

• Legacy

• Campus Activities

Device
• Speed

• Memory

• Features

• Cost

• Brand reputation

• Operating system

• Style

• Warranty

Your Thing

• Some factors (criteria) that may be
important:

Determine your criteria and construct a
matrix in Excel. Each criteria will be given a

weight to reflect its relative importance

Evaluation Matrix for Purchasing a Device

Criteria Weight System 1 System 2 System 3

Rating

Weighted

score Rating

Weighted
score Rating
Weighted

score

processor speed

memory capacity

multimedia capability

vendor support

initial cost

Totals

Memory capacity is our most important criteria so
receives the highest weight. Cost, while still a

concern, is not as critical as other factors.

Evaluation Matrix for Purchasing a Device
Criteria Weight System 1 System 2 System 3

Weighted Weighted Weighted

Rating Score Rating Score Rating Score

processor speed 25%

memory capacity 30%

multimedia capability 15%

vendor support 20%

initial cost 10%

Totals 100%

Rank the 3 systems on how well they meet criteria.
System 1 did well on speed and cost, but poor on
memory (important to us!). System 2 was good on
memory but poor on vendor support.

Evaluation Matrix for Purchasing a Computer

Criteria Weight System 1 System 2 System 3
Weighted Weighted Weighted
Rating Score Rating Score Rating Score

processor speed 25% 90 75 75

memory capacity 30% 60 90 80

multimedia capability 15% 75 75 60

vendor support 20% 75 60 75

initial cost 10% 85 75 80

Totals 100%

Evaluation Matrix for Purchasing a Computer
Criteria Weight System 1 System 2 System 3
Weighted Weighted Weighted
Rating Score Rating Score Rating Score
processor speed 25% 90 75 75
memory capacity 30% 60 90 80
multimedia capability 15% 75 75 60
vendor support 20% 75 60 75
initial cost 10% 85 75 80

Totals 100% 385 375 370

At this point you could total the ratings to get a
raw score. This shows that System 1 scored the
best.

You should compute a weighted score by
multiplying the weight you assigned times the
rating you gave for a criteria.

Evaluation Matrix for Purchasing a Computer
Criteria Weight System 1 System 2 System 3
Weighted Weighted Weighted
Rating Score Rating Score Rating Score

processor speed 25% 90 22.50% 75 18.75% 75 18.75%

memory capacity 30% 60 18.00% 90 27.00% 80 24.00%

multimedia capability 15% 75 11.25% 75 11.25% 60 9.00%

vendor support 20% 75 15.00% 60 12.00% 75 15.00%

initial cost 10% 85 8.50% 75 7.50% 80 8.00%

Totals 100% 385 375 370

Sum up the weighted scores and a winner will
emerge. System 2 appears to meet more of the
criteria that we weighted as important to us.

Evaluation Matrix for Purchasing a Computer
Criteria Weight System 1 System 2 System 3
Weighted Weighted Weighted
Rating Score Rating Score Rating Score
processor speed 25% 90 22.50% 75 18.75% 75 18.75%
memory capacity 30% 60 18.00% 90 27.00% 80 24.00%
multimedia capability 15% 75 11.25% 75 11.25% 60 9.00%
vendor support 20% 75 15.00% 60 12.00% 75 15.00%
initial cost 10% 85 8.50% 75 7.50% 80 8.00%

Totals 100% 385 72.25% 375 76.5% 370 74.75%

The summed up weighted score
give a better result because it
shows the one that rated the
highest on things that were
important to us!