hello, all I need are the formulas for missing cells (E2,G2,H2,I2,J2)
H Project Percent Grade Percentage Letter Grade Plus-Minus Letters 1 Name 2 Student 1 3 Student 2 4 Student 3 5 Student 4 6 Student 5 7 Student 6 8 Student 7 9 Student 8 10 Student 9 11 Student 10 12 Student 11 13 Student 12 14 Student 13 15 Student 14 16 Student 15 17 Student 16 18 Student 17 19 Student 18 20 Student 19 21 Student 20 22 Student 21 23 Student 22 24 Student 23 25 Student 24 26 Student 25 27 Student 26 28 Student 27 29 Student 28 30 Student 29 31 Student 30 32 Student 31 33 Student 32 34 Student 33 35 Student 34 36 Student 35 37 Student 36 38 Student 37 39 Student 38 40 Student 39 41 Student 40 42 Student 41 43 Student 42 44 Student 43 Exam 1 Exam 2 Exam 3 Exam Percent Project 90 88 93 57 96 97 96 100 89 96 92 72 89 97 96 73 97 88 93 95 91 89 62 16 56 85 55 28 89 89 91 90 93 96 100 100 50 89 89 74 50 86 96 98 98 100 98 100 84 90 63 0 55 89 92 83 90 94 94 88 96 100 98 100 95 95 99 98 79 89 87 100 85 88 93 75 93 64 93 75 78 92 91 28 93 95 96 100 89 91 92 84 67 90 85 88 90 97 99 100 92 91 90 98 90 96 70 100 93 97 91 76 90 83 91 76 8B 86 96 93 93 97 47 94 91 90 93 89 50 50 1 93 93 93 62 50 50 50 0 90 83 96 47 88 91 95 34 94 98 98 85 87 88 100 91 89 94 93 89 83 84 97 49 8B 95 94 95 90 100 05 GA 98 100 100 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