Reply
Thread Tools Display Modes
#1
Old 10-18-2008, 01:25 PM
CC CC is offline
Charter Member
Join Date: Apr 2000
Location: not elsewhere
Posts: 4,290
can Excel convert letter grades to numbers?

I'm trying to fake my way though figuring out how to get Excel to figure out my grades for me this semester - clearly taking a chance with my sanity and my students' futures. I think I can figure out how to get the spreadsheet to weight and then calculate the averages. But can I enter a conversion scheme someplace and then simply enter letter grades and have Excel convert them all to numeric equivalents, so that it can then do the calculations? And can I get it to do the reverse - once it has calculated a numeric average of these weighted grades, to then convert it back to a letter grade?
#2
Old 10-18-2008, 01:34 PM
Guest
Join Date: May 2001
Location: In another castle
Posts: 18,988
Yes. Check out the lookup function.
#3
Old 10-18-2008, 01:38 PM
Guest
Join Date: Aug 2001
Posts: 24,584
Yes. I asked that question right here on the boards last year.

Here's the thread
#4
Old 10-18-2008, 01:42 PM
Guest
Join Date: Aug 2001
Posts: 24,584
Also, as i noted in the other thread, this guy explains how it works, and also has a sample spreadsheet that you can download.
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 03:02 AM.

Copyright © 2017
Best Topics: gunshot in mouth charmin vs cottonelle 3dg porn frederica bimmel four way flashers monkeys football rarest zodiac netflix dvd copy guava seeds hard scooter name half fast definition exacerbates pronunciation red splotchy hands denture discussion boards persona gratis weaponized emp claritin for pain hook off stage cat peeing excessively sahara sea water well gpm sicilian slang kmart jewelry dept gorda translation miss susie pornhublive account mailman hours a zzz az ezri dax nude john c chulay doubled over laughing bleach + ammonia crayfish eggs sonicare quadpacer minoxidil success rate dna urine callobius spider my car door wont unlock how many glasses of wine in a 1.5 liter bottle windows 10 printer is in error state selective service system board members how much are old encyclopedias worth saying i love you to a friend mountain bike tires for street does ambien show up in drug tests national bohemian beer logo do electrons orbit around the nucleus cut my legs off and call me shorty steel toed boots on airplane what is the limit on carbon dating homemade pressure washer soap how does a blow torch work ending of quantum of solace why is anime so popular in the west average car horn decibel when to capitalize president of the united states how expensive is titanium per ounce bottle in a bag siphon hose for gas styrofoam in potting soil can you go to jail for downloading music how much is one chicken breast why do we have the letter c chopped onions in a jar is malt o meal good for you john wayne foot size how to cut coke with acetone what is darkness in latin meatloaf with gravy instead of ketchup what kind of chinese food should i order peacock sounds like help