Sunday, October 21, 2007

Doing Letter Grades on Excel

Topic: Open for Discussion Date: 5 December 2006 1:27 AM
Subject: Doing Letter Grades on Excel Author: Mondy, Steven

If anyone is interested...
There's an easy way of doing your grades on excel.
You can assign letter grades to the results you get for students...
Check out the following website. I managed to finally do it on my computer. It works...

careful with the formula...
Make the list of grades you want to give then use the formula,
=VLOOKUP(C21,grades,2,TRUE) for example,
~ the c21: is the actual student grade
~ grades: is the list
~ 2: is the column that has A, B, C in the list,
~True: rounds off the grade to the closest figure...
Try it out, it may help you (or may confuse you...)!
Steven Mondy

1 comment:

Anonymous said...

Can I just say what a relief to discover someone that truly
understands what they're talking about over the internet.
You definitely understand how to bring an issue to light and make it
important. More and more people really need to read this and understand this side of
your story. I was surprised you're not more popular given that you surely possess the gift.

Visit my page; web site ()