Excel Grade Book Template (Averages)

Domain: http://office.microsoft.com/templates
Categories: Gradebook and Grade Tracking

This is a nice gradebook template for Excel from Microsoft.com. It automatically calculates averages and letter grades as you add assignments, quizes, etc. See link details for a tip for improving the formatting.

Rating: 3.11

(9 votes)
Added: 03-19-2004 - Updated: 03-21-2004 - Comments: 1 - Hits month/total: 149/24235
Report error

Version (if applicable): 97 or Later

Inserting and deleting rows messes up the color scheme (alternating white/gray rows). A slight modification will fix this problem.

Using conditional formatting, you can make the rows alternate white/gray correctly even after adding and deleting rows.

Select all the cells in the gradebook table and add a conditional formatting condition using the following formula:

=MOD(ROW(),2)=1

You will also need to set the default background color for all of these rows to white. (Using the normal method of changing the background cell color).

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.