Nazarbayev University
Undergraduate Grading System
| Combo Box Label | NU Undergraduate |
| Combo Box Order | 2 |
The Incomplete ("I") and Withdrawal ("W") letter grades will be given special consideration
in the sense that those corresponding numerical grades will not be included in the mean and
standard deviation calculations for the overall course grade. The other ranges and letter
grades are arbitrary and can vary between departments and/or universities.
| Numerical Grade Range | Letter Grade |
|---|
| [95-100] | A |
| [90-95) | A- |
| [85-90) | B+ |
| [80-85) | B |
| [75-80) | B- |
| [70-75) | C+ |
| [65-70) | C |
| [60-65) | C- |
| [55-60) | D+ |
| [50-55) | D |
| [0-50) | F |
| Incomplete | I |
| Withdrawal | W |
Excel formula to convert a numerical grade into the corresponding letter grade
(the placeholder "CELL" will be replaced by the Excel cell that contains the
numerical grade value, and all whitespaces will be removed from the formula) :
IFERROR(
IF( CELL >= 95 , "A" ,
IF( CELL >= 90 , "A-" ,
IF( CELL >= 85 , "B+" ,
IF( CELL >= 80 , "B" ,
IF( CELL >= 75 , "B-" ,
IF( CELL >= 70 , "C+" ,
IF( CELL >= 65 , "C" ,
IF( CELL >= 60 , "C-" ,
IF( CELL >= 55 , "D+" ,
IF( CELL >= 50 , "D" ,
"F" ))))))))))
, "N/A" )