Final Grade Report

Upon completion of a class, a final grade needs to be calculated for each student in the section. The final grade can involve averaging two worksheet grades for a semester class, or four worksheet grades for a year long class. It should automatically calculate a grade (A, B, C, D, or E) based on the following formula: (4 * num(A) + 3 * num(B) + 2*num(C) + num(D)) / num(worksheets) . It should then round to the nearest integer and display A, B, C, D, or E depending on whether students have 4, 3, 2, 1, or 0. It also must be possible for teachers to over-ride the calculated final grade.