Excel hw

profilePmnguyen1989
spreadsheet_activity_13.xlsx
Home>Business & Finance homework help>Accounting homework help>Excel hw

Final Grade Calculations.csv

Student Number Activity 1 Activity 2 Activity 3 Activity 4 Exam 1 Exam 2
91702391 15 18.52 14.12 47.02 64.00 97.66
91702483 15 14.08 10.29 41.24 68.00 83.61
91704096 15 19.72 14.59 49.28 64.00 100.00
91703441 0 11.13 0.00 16.70 76.00 30.83
91703913 15 19.92 14.44 49.28 72.00 100.00
91703395 15 20.00 15.00 46.40 68.00 99.40
91704146 15 18.10 14.53 50.00 84.00 100.00
91702706 10 19.92 14.59 47.22 54.00 94.73
91703564 14 19.97 14.57 43.10 76.00 94.64
91702600 5 10.80 5.79 21.86 68.00 46.45
91701595 4 13.17 13.03 35.67 74.00 68.87
91702335 4 9.58 2.10 3.00 82.00 21.68
91703334 14 16.05 12.13 38.15 72.00 83.33
91703920 15 19.08 15.00 50.00 82.00 100.00
91703691 15 19.72 14.81 50.00 72.00 100.00
91702088 15 9.58 10.71 48.25 76.00 86.55
91702965 5 18.80 14.16 49.49 64.00 90.45
91703050 15 16.02 8.10 43.72 62.00 85.84
91704203 15 16.67 12.86 40.83 74.00 88.35
91701782 15 18.50 12.81 47.22 82.00 96.53
91703325 10 19.08 12.71 48.05 72.00 92.84
91701591 15 18.25 14.59 42.07 80.00 92.91
91701521 15 19.13 14.57 45.98 74.00 97.68
91702243 15 19.58 14.70 42.48 70.00 94.76
91703117 15 20.00 15.00 50.00 84.00 100.00
91704470 15 19.72 12.60 50.00 70.00 100.00
91701931 10 16.17 12.77 38.35 82.00 80.29
91703045 15 13.90 13.89 46.19 66.00 91.98
91704103 15 11.72 2.14 37.74 70.00 69.60
91702809 0 0.00 0.00 21.24 84.00 24.24
91702293 10 16.63 14.10 45.98 78.00 89.71
91702707 15 10.83 8.27 41.04 72.00 78.14
91702517 0 5.83 0.00 5.77 66.00 14.60
91703378 15 18.27 14.76 44.75 84.00 95.78
91703755 0 11.83 4.29 26.60 70.00 45.72
91702197 15 19.38 14.76 50.00 80.00 100.00
91703788 15 17.50 12.71 50.00 74.00 98.21
91703670 15 19.88 14.81 50.00 66.00 100.00
91703268 15 19.92 14.55 50.00 70.00 100.00
91702311 10 19.08 14.89 50.00 56.00 96.98
91701582 15 19.97 15.00 50.00 80.00 100.00
91703245 0 14.50 2.14 42.07 68.00 61.71
91704299 15 17.63 14.96 42.69 72.00 93.28
91701588 10 13.50 6.11 42.69 76.00 75.30
91704292 15 20.00 15.00 49.49 90.00 100.00
91701958 10 13.33 10.67 29.90 68.00 66.90
91703749 15 19.83 14.96 50.00 78.00 100.00
91703857 15 19.83 10.31 50.00 70.00 98.14
91702252 0 17.82 6.81 33.61 70.00 61.24
91701937 15 19.77 11.98 45.98 70.00 95.73
91702868 15 12.58 6.21 40.21 72.00 77.01
91703162 0 1.67 0.00 10.31 68.00 14.98
91703104 12.5 14.92 12.43 44.95 70.00 87.80
91702924 10 18.33 14.21 49.28 88.00 94.82
91703368 15 20.00 14.72 46.60 76.00 99.32
91702152 5 18.92 14.31 45.98 72.00 87.21
91704322 15 9.13 2.14 45.98 80.00 75.26
91704412 10 16.92 10.24 39.39 72.00 79.55
91702070 0 15.17 7.39 40.42 66.00 73.23
91703979 5 18.10 9.96 36.29 68.00 72.35
91704297 15 10.83 10.71 33.20 72.00 72.75
91702516 10 19.27 14.89 48.05 80.00 95.21
91704062 15 14.75 11.96 41.24 58.00 85.95
91702491 15 19.92 14.76 48.46 82.00 100.00
91701895 15 18.33 14.89 43.10 56.00 94.33
91701970 15 9.17 6.06 40.00 68.00 73.23
91704489 15 17.63 10.71 47.02 66.00 93.37
91702868 12.5 18.17 12.64 37.12 70.00 83.43
91704206 15 19.88 15.00 50.00 88.00 100.00
91703810 15 18.33 14.89 48.25 80.00 99.48
91704213 15 19.17 14.79 50.00 74.00 100.00
91701989 15 19.83 14.81 50.00 76.00 100.00
91702222 15 18.13 14.12 47.43 78.00 97.68
91703472 15 19.75 14.89 48.05 84.00 100.00
91702002 15 17.55 12.49 49.49 76.00 97.53
91703604 5 8.25 3.66 25.78 70.00 45.69
91701771 15 14.17 10.56 47.84 68.00 90.57
91703902 15 19.60 14.85 48.87 70.00 100.00
91703184 5 19.10 12.88 44.54 46.00 84.52
91701544 15 16.42 10.56 16.29 78.00 61.27
91702927 5 13.13 7.24 39.18 70.00 67.56
91704443 15 20.00 14.57 47.22 74.00 99.79
91702551 15 19.33 15.00 47.22 72.00 99.55
91703959 10 18.33 14.74 48.25 70.00 94.33
91702880 15 18.33 15.00 49.49 76.00 100.00

To complete this activity, format the following columsn according to these rules. 1. Activity 1 is out of 15, but most students should score greater than 10. Please have the cells filled with red fill and let the font be white if a student scores less than 10 so I will know who I need to contact. 2. Activity 2 is out of 20 points, and most students do very well. I need 2 conditional formats on this one. First, if a student scores less than 15 I would like red fill with white font. If someone scores a 0, I would likd a black fill with white font. 3. Activity 3 is out of 15 points. Please apply the same rule as Activity 1. 4. Activity 4 is out of 50 points. I would like to congratulate students who score higher than 45 points, and communicate with those below 10 points. Please conditionally format scores below 10 to be red fill with white font and scores above 45 to be green fill with black font. For Exam 1, I would like to quickly see the top 10% of the class. Please conditionally format the top 10% to be a dark blue fill with bright yellow, bold font. For Exam 2, I would like to see a color scale of the entire list of grades. Have it be a three-color scale with 50 as the midpoint score.