Great Deal! Get Instant \$25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

# 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.

Answered 11 days AfterNov 19, 2017

## Solution

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