**Instructions for creating an EXCEL grade conversion table
**Go to top of main page

Return to Step 8 in main page

Return to Main Index

Return to Site Map

NOTE:

1.

3.

Divide the difference between points for each grade cut-off by 10. It is in the table under Grade Range Calc. Values Calculated and under Grade Range Calc. Values Used. It is "value (3)". Value (3) may be different for each grade range (e.g. 1.000, 0.900, 0.900). Starting with the point value for the lowest grade in each grade range, add value (3) for that grade range repeatedly to determine the point values for successive grades in that grade range. Place these values next to their corresponding grades (e.g., points in the 60 – 70 grade range = 85, 87, 88, 90, 92, 94, etc.) I round off to the nearest whole number. This procedure produces a linear scale between each grade cut-off. Since value (3) may be different for each grade range, the slope of this linear scale may be different for each grade range.

Divide the number of points needed for "60" by 60. It is "value (4)". Subtract value (4) repeatedly from the points for number grade 60 to determine the descending point values for descending number grades, and place the point values next to their corresponding number grades. I round off to the nearest whole number (e.g., 85 /60=1.4167, "59" = 84 points, "58" = 82 points, etc.) This system creates a linear scale between grades 60 and 0. The slope of this linear scale may be different from the slope for the grade ranges above grade 60.

Because my tests are always difficult, I usually have a low point value for a grade of 90. Therefore, I use a graduated scale rather than using a linear system for grades 91-100. My rationale is that the difference in points on a test between grades of 89 and 90 should be the same as that point difference between grades of 90 and 91. However, the point difference between grades of 91 and 92 may be slightly more, the point difference between grades of 92 and 93 may be even more, etc. up to a grade of 100. This system creates a curvilinear scale between grades 90 and 100. The points scale has an increasing slope as the grades increase from 90 to 100. See Graph at GCT for Test 1

Go to top of this page

Go to top of main page

Return to Step 8 in main page

**Instructions for converting to another instructor's grading system, such as
when team-teaching
**I team-taught a course where the other instructor wanted each of the four
quizzes to be worth exactly 40 points. With this system, students could earn up
to 160 points for the semester. This instructor wanted me to report grades on
this scale, and the point cut-offs on each quiz for grades of A, B, C, and D
were always 36, 32, 28, and 24 respectively. This means that the point cut-offs
for each letter grade during the semester were the point cut-offs for each quiz
multiplied times the number of quizzes given (e.g.,
Table
A for one quiz,
Table B for three
quizzes). Here is what I did for the students’ quiz scores.
Sample
records of test scores. .

**1.** After each quiz, prepare the grade conversion table as above.
Grade
Conversion Table template

**2.** Add one column to the right of the Points column.
(Table
A)

**3.** Enter the correct multiple of each cut-off beside the corresponding
letter grade cut-offs.
(Table A),
(Table
B)

**4.** For grades equivalent to 60-100, add 0.4 consecutively up the column
starting with the points for a grade of 60 (e.g., after three quizzes in
(Table
B), a grade of 60 = 3X24 = 72 points out of 120 possible points using the
40-point per quiz system).

**5.** For grades equivalent to 59-0, subtract 1/60 of the value for the
previous grade (i.e., [points for grade of 59] = [points for grade of 60] -
[1/60 points for grade of 60]; [points for grade of 58] = [points for grade of
59] - [1/60 points for grade of 59]; etc.) This can also be done by using the
correct multiplication factor for each grade (i.e., grade on scale of 100
divided by 60).
(Table C)

Go to top of this page

Go to top of main page

Return to Step 8 in main page

Return to Main Index

Return to Site Map

© Copyright 2004 A.G. DiGiovanna, Salisbury University, Maryland. All rights
reserved.**
**