Create a table in Excel and solve for the following:

1.What percentage of students had an overall grade above 80%?

2.How many students had a grade of B+ or higher?

Score

Grade

Contribution to GPA

A

93-100%

4.00

A-

90-92%

3.70

B+

87-89%

3.30

B

83-86%

3.00

B-

80-82%

2.70

C+

77-79%

2.30

C

73-76%

2.00

C-

70-72%

1.70

D+

67-69%

1.30

D

63-66%

1.00

D-

60-62%

0.70

F

Failure

0.00