Student Grade Calculator
Spreadsheet for calculating grade based on weighted components.
latest release: 2020-03-05 23:47:56
Spreadsheet for calculating grade based on weighted components. It uses conditionals to ensure that only components that have been graded thus far are included in the calculation (ie: you don't start with a zero in everything). Likewise, conditionals are being used to check if things *have* been added, so when you do it's automatically included in the calculation - no need to change cell range/ count / &c.; The template as shown has space allocated for five categories(eg: Homeworks, Tests, Labs, Final) , but if you need more it's a simple matter of cutting and pasting columns, or if less just delete a few. In short, all you should need to worry about doing is adding the weights (once) and the grades (as they come) and you'll always have an idea where you stand. Enjoy.