Letter Grade Problem
Input a student’s name and test score out of 100. Program should match the test score to a letter grade, then print out the student’s name and letter grade use the following table.
|
Exam score |
Assigned grade |
|
90 and above |
A |
|
80-89 |
B |
|
70-79 |
C |
|
60-69 |
D |
|
Below 60 |
F |
Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdGrade. Place the code under the Click event of a command button titled “Letter Grade”.
Hint: Use a Select Case statement in the flowchart and the code.
