Databases Reference
In-Depth Information
FIGURE 6.6
Frequency of grading methods highlighted.
If
Workbooks("SampleReport.xls").Worksheets("ClassGrades").Cells
(ii, 16) = _
Workbooks("SampleReport.xls").Worksheets("ClassGrades").Cells
(ii, 13 + jj) Then
'Match - Highlight Background
Call HighlightCell("SampleReport.xls", "ClassGrades",
ii, 13 + jj, 6)
Exit For
End If
Next jj
Next ii
End Sub
All that the above subroutine does is compare the final grade value with each of the three
grading methods to determine which one was utilized. The grading method that was utilized is then
highlighted. Taking a quick look at the results, grading method 1, which utilizes all of the compo-
nents in the class, was not utilized for a single student. Every student benefited from either dropping
the lowest test grade (method 2), or dropping the Quiz average (method 3), and reweighing the
other elements present within the course.
Notice that the final grade can be altered quite a bit by choosing one method over another. In
the case of Ms. Fisher, her grade nearly doubled from a low of 19.8 (using method 3) as opposed
to a high of 35.4 (using method 2). Sadly, even when given the best of circumstances, she was
unable to attain a passing grade. Looking at the other extreme, there are instances when using one
grading method over another makes little difference. Take the case of Mr. Potter, with final calculated
grades of 99.1, 98.8, and 100 using each of the three methods, respectively. No matter what grading
method is used in his case, an A will be his grade. A similar case exists for that of Mr. Dees, whose
grades of 78.7, 79.1, and 77.7 put him in solid C
territory.
Although the above analysis provides a good quick-and-dirty means of looking at the data, the
instructor is probably going to want a more comprehensive analysis on the results of his classes.
The beauty of standardized reports is that, when reports conform to a known format, it becomes
very easy to write macros to perform analyses on them. This can be taken a step further to simplify
+
