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:

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.

Grade Template—Basic
Source/Contributor: Jason Shattuck
Course: Unknown
Date: Winter 2008
Format: Excel spreadsheet

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.

Section Grade Sheet Template
Source/Contributor: Tim Wright
Course: Unknown
Date: Spring 2007
Format Excel spreadsheet

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.


Grade conversion charts

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.

Grading Scale 150 Point Exam
Source/Contributor: Tracy McKenzie
Course: Unknown
Date: Unknown
Format: PDF

A basic chart showing how to convert 150-point score systems to 4.0 grades.