Information Technology
Evaluation Matrix
An important tool you can use tomake informed decisions
Decisions Can Be Difficult
- When making a choice among severaloptions, it helps to know at the outset whatis of greater or lesser importance to you
- Most of us cannot “have it all”
- The “yardsticks” you will use to measure howeach option rates on different factors can becalled criteria (singular is “criterion”)
Car Purchase
- Some factors (criteria) that may beimportant:
- –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 beimportant:
Determine your criteria and construct amatrix in Excel. Each criteria will be given aweight 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 soreceives the highest weight. Cost, while still aconcern, 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 onmemory (important to us!). System 2 was good onmemory 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 araw score. This shows that System 1 scored thebest.
You should compute a weighted score bymultiplying the weight you assigned times therating 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 willemerge. System 2 appears to meet more of thecriteria 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% |