Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 134
Default 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!
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASSIGN NUMBER SCORES TO LETTER GRADES DOUG ECKERT[_2_] Excel Worksheet Functions 4 September 15th 08 08:31 PM
Changing numbers/percentages to letter grades Preston Steele Excel Worksheet Functions 7 January 19th 07 03:09 AM
try to convert letter grades into GPA grade points scabbage Excel Worksheet Functions 3 October 22nd 05 05:31 AM
HOW DO I CREATE A TOOL FOR CONVERTING PERCENT INTO LETTER GRADES? fernman Excel Discussion (Misc queries) 3 September 5th 05 04:47 PM
Converting Letter Grades to Numeric Angelo D Excel Worksheet Functions 6 April 25th 05 07:29 PM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"