



 
Cori, we have two responses for you: Hi Cori, The best you can do is average them. That is what the students are averaging at that moment anyway. Just add the four percents (out of 100) together and divide by four. For example if a student got 50%, 60%, 70% and 80%, then his average would be (50+60+70+80)/4. In Excel it depends on how you have the data recorded. Basically,for each midterm you want (MtScore/MarksPossible*100). Add the four of these together and divide by 4. Victoria
Cori, What I have done in this situation is to take a student's score on a 10% quiz, divide by the maximum possible score on that quiz and multiply by 10. This gives a score out out 10. Do this for each of the quizzes and for the midterm but in this case multiply by 15 to give a score out of 15. Add the resulting four quiz scores and the midterm score to give a midterm grade out of 55. If you want to express this as a percentage, divide by 55 and multiply by 100. I hope this helps,
Harley
 


Math Central is supported by the University of Regina and The Pacific Institute for the Mathematical Sciences. 