Calculating grades from percentages

[Doug Mohr]

Can anyone provide me some assistance regarding how to write a calculation to determine a letter grade. Each of my students has a course percentage. Based on each students percentage I would like to calculate whether their grade is A+, A, A-, etc. Thanks in advance for assistance with how to do this.

[LiveOak]

Grade (calculation, text) =

Case(

Score >= 95, "A+",

Score >= 90, "A",

Score >= 80, "B",

Score >= 70, "C",

Score >= 60, "D",

"F")

Evaluations are performed in order. If the Nth test succeeds, the Nth + 1 test is not performed -bd

[This message has been edited by LiveOak (edited January 20, 2001).]