Create a weighted scoring model . 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.