Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Letter grades average
Can anyone suggest a formula that would take letter grades (A, B, C, D, and
E) and produce an average letter grade based on different components? For example, a student gets a D on one assignment that is worth 10 % of the total grade, a B on another assigmetn that is 40 % and a A in an exam that is 50 % of the total grade. What formual will produce the total grade? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Letter grades average
Google is your friend.
weighted average:excel http://www.google.com/search?num=30&...Aexcel&spell=1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Antonio" wrote in message ... Can anyone suggest a formula that would take letter grades (A, B, C, D, and E) and produce an average letter grade based on different components? For example, a student gets a D on one assignment that is worth 10 % of the total grade, a B on another assigmetn that is 40 % and a A in an exam that is 50 % of the total grade. What formual will produce the total grade? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Letter grades average
Hi Antonio
One method. as the Ascii code for A is 65, B 66 etc., you could take 64 away from each grade value so A 1 B 2 C 3 D 4 E 5 then use =CHAR(ROUNDUP(1*0.5+2*0.4+4*0.1,0)+64) which would result in B as the result of the calculation would most often me a non Integer value, I have used Roundup, before adding back the 64 as this would tend to lower the overall grade rather than taking Int() of the value. You could create a lookup table for the values and percentages using a list like above with a third column showing what percentage is to be assigned to each. Name this 5 x 3 table as Scores. Then with Grades assigned in A1, A2 and A3 use =CHAR(ROUNDUP( VLOOKUP(A1,scores,2,0)*VLOOKUP(A1,scores,3,0)+ VLOOKUP(A2,scores,2,0)*VLOOKUP(A2,scores,3,0)+ VLOOKUP(A3,scores,2,0)*VLOOKUP(A3,scores,3,0),0)+6 4) -- Regards Roger Govier "Antonio" wrote in message ... Can anyone suggest a formula that would take letter grades (A, B, C, D, and E) and produce an average letter grade based on different components? For example, a student gets a D on one assignment that is worth 10 % of the total grade, a B on another assigmetn that is 40 % and a A in an exam that is 50 % of the total grade. What formual will produce the total grade? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Letter grades average
You will also need to assign a "numerical value" to A, B, C, and D.
Antonio wrote: Can anyone suggest a formula that would take letter grades (A, B, C, D, and E) and produce an average letter grade based on different components? For example, a student gets a D on one assignment that is worth 10 % of the total grade, a B on another assigmetn that is 40 % and a A in an exam that is 50 % of the total grade. What formual will produce the total grade? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ASSIGN NUMBER SCORES TO LETTER GRADES | Excel Worksheet Functions | |||
Changing numbers/percentages to letter grades | Excel Worksheet Functions | |||
try to convert letter grades into GPA grade points | Excel Worksheet Functions | |||
HOW DO I CREATE A TOOL FOR CONVERTING PERCENT INTO LETTER GRADES? | Excel Discussion (Misc queries) | |||
Converting Letter Grades to Numeric | Excel Worksheet Functions |