# Thread: Drop lowest score and Weighted average (Excel 2003)

1. ## Drop lowest score and Weighted average (Excel 2003)

I have a couple of questions for you regarding Excel.

1) Students have taken 5 quizzes and their lowest grade can be dropped. How can I have Excel automatically drop each student

2. ## Re: Drop lowest score and Weighted average (Excel 2003)

1- This formula will average the four highest grades in B2:F2

<pre>=AVERAGE(LARGE(B2:F2,{1,2,3,4}))
</pre>

2- Would this do what you want:

Final Grade = .2 * LabQuiz + .35 * LabReport + .45 * WhateverMakesUpTheRest

3. ## Re: Drop lowest score and Weighted average (Excel 2003)

Another technique for #2 (adapt as needed)
Imagine row 1 and 2 as header
rows 3 - whatever are student grades
If col A has names, Col B is for final grade, Col C has "Lab Quiz" grade, Col D has "Lab Report" grade, Col E has the "rest", etc

In A2 have headers, "Name", B2 is for "final grade", C2 "Lab Quiz", D2 "Lab Report", Col E "Rest",etc
C1 has 20%, D1: 35%, E1: 45%

In B3 you can add the formula:
=sumproduct(\$C\$1:\$E\$1,C3:E3)

Then you can copy this down all the rows. You can expand the number of columns and number of "weights" as desired. TO change the weights only involves changing the items in row 1.

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•