Exercise 3

Schwalbe P.160 - Chapter 4, Ex 4

4. Create a weighted scoring model to determine grades for a course. Final grades are based on three exams worth 15%, 20%, and 25%, respectively; homework is worth 20%; and a group project is worth 20%. Enter scores for three students. Assume Student 1 earns 100% (or 100) on every item. Assume student 2 earns 80% on each of the exams, 90% on the homework, and 95% on the group project. Assume student 3 earns 90% on Exam 1, 75% on Exam 2, 80% on Exam 3, 90% on the homework and 70% on the group project. You can use the weighted scoring model template, create your own spreadsheet, or make the matrix by hand.

Weighted Scoring Model

Assumption: Grades range from A to F, where 50% is the passing mark
A Grade – 86% - 100%
B Grade – 76% - 85%
C Grade – 66% - 75%
D Grade – 50% - 65%
F Grade – Fail

Reference

Schwalbe, K. (2006). Information Technology Project Management (4th ed.). Massachusetts: Thomson Course Technology.