In my past blog, I described an easy way of calculating grades. In the real world, professors distribute many tests and assignments through the semester.  Here is an example:

The formula in column H calculates each assignment with the weighted percentage. In H1 the formula is as follows:

=(B2*0.15)+(C2*0.15)+(D2*0.15)+(E2*0.15)+(F2*0.2)+(G2*0.2)

The formula in column I is an IF THEN ELSE statement that calculates the grade letter for each student. In I1 the formula is as follows:

=IF(H2>=90,”A”,IF(H2>85,”B+”,IF(H2>=80,”B”,IF(H2>=75,”C+”,IF(H2>=70,”C”,IF(H2>=60,”D”,”F”))))))

After I test these two formulas, I select both formulas and copy it down by doubling clicking on the Autofill handle on the bottom right of the I1 cell (the little black solid icon). See diagram:

Advertisements