This is the template Student Grade Calculator. A template that can be used by LibreOffice online, OpenOffice, Microsoft office suite (Word, Excel, Powerpoint) or Office 365.
Download or edit the template Student Grade Calculator valid for LibreOffice online, OpenOffice, Microsoft office suite (Word, Excel, Powerpoint) or Office 365.Spreadsheet for calculating grade based on weighted components.
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.
Free download template Student Grade Calculator integrated with the OffiDocs web apps