1. This class uses weighting, which you will need to account for in the calculation. Exams are worth 80% of the grade, and the class project is worth 20% of the grade. To calculate the final grade percentage you will need to add up the exam scores; then divide by the total number of exam points and then multiply by the weighted percentage. In a similar manner, calculate the percentage for the project. Then add the two totals together to get the final grade. Remember, students cannot earn more than 100%! 2. Once you have the grade percentages, then calculate the letter grades and plus/minus letter grades. 3. Next, complete the data for columns M through R showing the grade percentages (Note** do NOT use adjusted percentages!), the corresponding plus/minus letter that equates to, how many students had that grade, what percentage that is of total students, the grade point and the average. 4. Using the letter grades and total students (columns N and O), create a Grade Distribution graph. 5. Use the technics you learned in the module to complete the file, then complete the assessment questions using the file you create. Your completed file should look similar to this: B C D E G H K M N P Q R S Letter Grade Plus-Minus Letters Percent Letter Total Percent Grade Point Average Name Exam 1 Exam 2 Exam 3 Exam Percent Project Project Percent Percent 90 88 93 72.3%% 57 11% 83.7% B B OE 15 6.7% 0 2 Student 1 97 96 77.1% 100 20% 97.1% A A+ 0.6 D 16 7.1% 16 Student 2 96 73.9% 72 14% 88 3% B B+ 0.7 C 20 8.9% 2 40 4 Student 3 92 5 Student 4 97 96 75.29 15% 89.8% B B+ 0.77 C+ 17 7.6% 2.33 39.61 8 0%% 2.66 47.88 6 Student 97 88 93 74.19 19% 93.1% A A 0.8 B 18 91 89 62 64.5% 3% 67.7% D 0.83 B 36 16.0% 3 108 Stud 56 55 52.3% 6% 57.9% E E 0.87 B+ 28 12.4% 3.33 93.24 85 89 89 91 71.7% 18% 89.7% B B + 0.9 A- 33 14.7% 3.66 120.78 9 Stud 116 10 Stud 93 20% 97.1% A A + 0.93 A 29 12.9% 15% 75.6% C 0.97 A+ 13 5.8% 4.33 56.29 it 10 20% 225 2.834667 Grade Distribution 40 35 25 20 Students 15 10