# Excel Case Study – Unit 2

Excel Case Study – Unit 2
In this case study, you will format a gradebook, apply a calculation, use the VLookup and IF Functions.
Professor Williams needs help in organizing his grade book. He would like your help in cleaning it up and making it easier to use. In Professor Williams’ course, the maximum points a student can earn is 750. The following table displays the grade equivalent to the total points for this course:
Total Points Calculated Grade 675 A
635
A- 600 B
560
B- 535 C
490
C- 450 D
0
F
Case Focus:
Help Professor Williams rework his grade book. Open the data file EX_AYK18_Data.xlsx and perform the following:
1. Reformat the workbook so it is readable, understandable, and consistent. Replace column labels, format and align the headings, and add borders and shading as appropriate.
2. Add a column in the grade book for the final grade next to the total points earned column.
3. Use the VLookup Function to automatically assess final grades based on the total points column.
4. Using the IF Function, format the workbook so each student’s grade shows a pass or fail—P for pass, F for fail-based on the total points.
File Needed: EX_AYK18_Data.xlsx