Calculating a garde with portions weighted differently.

[Cornelius Morris]

This should be easy, but I keep messing it up.

The quizzes in a class I'm teaching add up to 60% of the grade.
The exam counts for 40 percent.

Suggest a formula?

Student has a 65 average for the quiz portion, 36 for the exam.

Thanks in advance.

 

[Eric Golf]

Hi,

To get a weighted percentage it is score*(weight/100)

so I think you want 65*(60/100)+36*(40/100)

which =53.4%

Is that what you expected?

In excel replace the numbers with the cells containing the scores.

Hope this helps,

Eric Golf

Edit - Note - Averaging the quizzes percentage only works if all quizzes are weighted the same i.e. same number of questions. otherwise you should take sum all correct answers over sum all questions.

 

[Cornelius Morris]

Re: Calculating a grade with portions weighted differently.

Thanks, Eric. That's it exactly.

Cornelius

Hi,

To get a weighted percentage it is score*(weight/100)

so I think you want 65*(60/100)+36*(40/100)

which =53.4%

Is that what you expected?

In excel replace the numbers with the cells containing the scores.

Hope this helps,

Eric Golf

Edit - Note - Averaging the quizzes percentage only works if all quizzes are weighted the same i.e. same number of questions. otherwise you should take sum all correct answers over sum all questions.

 

[Eric Golf]

Re: Calculating a grade with portions weighted differently.

Glad you got it & thanks for letting us know.

Eric