|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
#1 |
|
Member (10 bit)
|
VBA - question on weighted grades
nevermind, that problem was fixed....but i have another question.
i am writing a program that takes 5 quizzes worth 25 points each, 2 exams worth 50 points each, and 1 final exam worth 100 point. the lowest quiz score will be dropped. the grade is based on the following weights: 40% on the final exam, 30% on the exams, and 30% on the four quizzes. (try using these numbers: Quizzes(20,18,20,20,19)Exams(48,45)Final(92)) i dont get how to calculate weighted grades. if someone could explain that to me it would be great. thanks ^dan Last edited by GSXdan; 10-27-2002 at 12:45 PM. |
|
|
|
|
|
#2 |
|
Professional gadfly
|
Just multiply the weights by the scores for each section:
0.4(92)+0.3(48+45)+0.3(20+20+20+19) =88.4 points out of a possible 100. |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|