Grades: Changing Numbers to Letters

Have you ever wondered if there is an easier way to turn number grades into letter grades without any hassle? Well, there is! When progress reports or report card time rolls around, I bet you are always scrambling to try and get the grades and comments into the grading system. If you have not read my previous blog on grading, please do so before continuing on with this post. You can thank me later!

As you can see below, I have my grade averages but I needed to turn them into letter grades. When using excel, there is a simple formula that can make grading painless. To see a larger image of the picture, click here. Depending on your grading scale, your formula may be different, but the formula I used was =IF(I4>89,"A",IF(I4>79,"B",IF(I4>69,"C",IF(I4>59,"D","F")))). This formula may not be the same if your grading scale is different and if your cells are different than those showing from the image below. Take a closer look at my document. 

Surprisingly I did not have any trouble when changing my averages into letter grades. Once I typed in the formula, I instantly had grades. Using the handle made things even more simple. I typed in the formula once. I made edits when transferring to a different tab but that was not hard. This is a great tool to use and I cannot wait to use it when grading!

When creating a worksheet like the one I created, you will follow ISTE NETS-T 2, Design and Develop Digital-Age Learning Experiences and Assessments. Teachers can use this tool to communicate students grades with students themselves and their parents. When grades are due, this tool will come in handy!