Gradebook Templates

Guided Excel Spreadsheet (up to 45 students) [xls]: Step-by-step instructions on how to setup and use this spreadsheet are included in the file. Setup by inputing your assignment names and percentages, then just input letter grades for each assignment -- spreadsheet converts to numeric and calculates final grade for you. Optional calculation of class averages by assignment or class.

Guided Excel Spreadsheet (up to 25 students) [xls]: Same as above, only smaller for lower-enrollment courses.

Guided Excel Spreedsheet with Writer's Notebook / Reader Response / Quiz Tracking (up to 45 students) [xls] Same grade sheet as above only adds a section to track up to 15 Writer's Notebook, Reader Response, or Quiz grades. Give point grades for each individual assignment, which are totaled and assigned a single letter grade for the entire project. Single letter grade is then inserted into your gradebook and averaged based on your assigned percentages.

Guided Excel Spreedsheet with Writer's Notebook / Reader Response / Quiz Tracking (up to 25 students) [xls]: Same as above, only smaller for lower-enrollment courses.

[xls] - Some links on this page are in Microsoft .xls file format requiring the use of Microsoft Excel. If you need them in a more accessible format, please contact dmphelp@osu.edu.

0