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 Exam1, 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.
Please click on the image for a full screen view
