History TA Website
 Teaching Resources Pedagogy Library Career Development

Information and materials on this page are meant to provide course-level grading tools for instructors such as spreadsheet templates and conversion charts that convert numerical scores into the 4.0 scale. As always, it is suggested that TAs for the same course use the same or similar templates in grading their students.

Grading tools for assessing student writing can be found on Grading Criteria & Rubrics page.

Note: There are apparently no standard, university- or, even, department-wide conversion charts established. Indeed some instructors use conversion charts that weight scores differently. Before using any of these conversion charts, be sure to assess whether or not they are appropriate for the class or assignment; you may even want to confer with the instructor on this point.

Spreadsheets can simplify the grading process but, before using them, be sure to test them and their formulas using dummy data. Always double-check the math. Also, it is recommended that all the TAs in a course use the same spreadsheet.

Source/Contributor: Jason Shattuck
Course: Unknown
Date: Winter 2008

A basic Excel template for a course with two essays, a midterm, final, and participation scores. Users will have to type in student information and must review and edit the formula in column S to be sure it reflects the course grade weighting.

Source/Contributor: Tim Wright
Course: Unknown
Date: Spring 2007

A more complex Excel template for a course with two essays (one with a rewrite), a midterm, final, and participation scores. It provides separate worksheets for two sections and a page of instructions (see the tabs at the bottom of the window) that explain how to easily copy student information from MyUW Class. Users must review and edit the formula in column X to be sure it reflects the course grade weighting.

Caution: These conversion tables are offered as guides. Professors often make adjustments to fit the needs and demands of their courses and break the grades at different points (for example, some professors consider points scores as low as 56 equal to a 0.7/D- grade). Check with your supervising professor to make sure you are using the appropriate scale. If he or she is using a different scale, she or he should provide each TA with a copy of that.

Conversion guide from 100-point scale to 4.0 scale
Source/Contributor: Tim Wright
Course: Unknown
Date: Spring 2008
Format: Word document (editable)

A simple chart showing basic, unweighted, 100-point to 4.0 point scale conversion.