# The Grade 1 File has the grades of the students calculated for the following category weighting: Category Weight Exam 50% Excel 35% Quizzes 15% You are to copy the information into a new worksheet,...

The Grade 1 File has the grades of the students calculated for the following category weighting:

Category Weight
Exam 50%
Excel 35%
Quizzes 15%

You are to copy the information into a new worksheet, label it Grade 2 and change the category weighting to the following:

Exam 25%
Excel 55%
Quizzes 20%

Use a Vlookup to put the percentage grade in the column labeled Grade 2 in the Grade 1 Worksheet.

Use an If function to give the student the highest percentage.

Use a Vlookup to give the students a letter grade based on a 90% for A, 80% for B, 70% for C, 60% for D, F for all below 60%..

What is the grade distribution (i.e., number of A, B, C, D, and F).

If we want the top 20% of the students to get an A, what must the percentage be changed to for getting an A.

## Answer To: The Grade 1 File has the grades of the students calculated for the following category weighting:...

David answered on Nov 30 2019
A    8
B    76
C    100
D    47
E    10
(blank)
Gran
d Total    241
Total
A    B    C    D    E    (blank)    8    76    100    47    10
new percentage
Category    Exams            Excel            Quizzes
Weight    50%            35%            15%