Grading Spreadsheet for an Undergraduate Course

This is a template for grading a rather complex setup of course work.
It is intended for instructors to keep track of their students' performance
without having to use calculators etc.

In this template, the following are accounted for
4 midterms
2 assignments
attendance

For midterms:
In each midterm, a letter grade is assigned to each answered question. (Note: There is no A+)
Questions #1 #2 #3 are worth 15%.
Question #4 is worth 55%.
As each letter grade is entered, the spreadsheet translates / converts them into decimal grades.
For the ranges, see, for instance, cell C3 in Sheet 'Section1'.
The decimal grades are then averaged and translated into letter grades.

For assignments:
Each Assignment is translated into a decimal grade, but it is not used.

For attendance:
According to how much a student missed classes, a letter grade is entered.

To calculate overall grade:
In this template,
attendance counts 10%
assignments count (each) 5%
each midterm counts 20%
Each
letter grades of the midterms
letter grade for attendance
letter grade for assignments
are then converted into decimals
averaged
and the decimal is then translated into a letter grade.

Note: I don't have web hosting. Contact me if the file expires in drop.io ...