References:
Problem description:
VIU uses the following grade scale to convert numerical grades to letter grades:
|
Percentage(%) |
Letter Grade |
Grade Point |
|
90-100 |
A+ |
4.33 |
|
85-89 |
A |
4.00 |
|
80-84 |
A- |
3.67 |
|
76-79 |
B+ |
3.33 |
|
72-75 |
B |
3.00 |
|
68-71 |
B- |
2.67 |
|
64-67 |
C+ |
2.33 |
|
60-63 |
C |
2.00 |
|
55-59 |
C- |
1.67 |
|
50-54 |
D |
1.00 |
|
0-49 |
F |
0.00 |
An instructor calculated the final numerical grades for all the students in her class and stored the data in an Excel file which you can download here.
Your task:
Write a VBA program to convert all students' numerical grades to letter grades.
There is a weekly Assignment 7 following this lab.