Chronology Current Month Current Thread Current Date
[Year List] [Month List (current year)] [Date Index] [Thread Index] [Thread Prev] [Thread Next] [Date Prev] [Date Next]

Re: Grading & EXcel: letter grade



In addition to the IF statement the table lookup function (VLOOKUP) can also
be used to assign letter grades. I calculate a semester total number of
points for each student and use the VLOOKUP to get the letter grade from the
last two columns of a table below the student scores, something like:

T1 T2 total grade
90 90 180 A
80 80 160 B
................

Excel and QPro treat the boundries between grades slightly differently.

Robert Mathieson
Culver-Stockton College
Canton, MO 63435
(217)231-6000
rmathieson@culver.edu