-Create a Column Chart of your MyMathLab Homework grades, Quizzes, Exams, Excel assignments, Projects, participations, (put all on one chart). The chart should update as you enter new scores.
-Enter all your current grades for MyMathLab Homework, Quizzes, and Tests you already have. Enter a grade of 100% for the assignments that are not completed yet. There should be nicely labeled spaces for each of the following:
- Assume there will be 8 MyMathLab Homework
- Assume there will be
- There will be 2
- There will be 5 Exams (Test 1, Test 2, Test 3, Test 4 and the Final Exam).
-Format all these nicely with borders and shading.
- Create cells which will compute the average grade of each category (MyMathLab Homework grades, Quizzes, Exams, Projects). Name these cells appropriately.
- Create cells which will count the number of assignments grades for each
- Create cells which will compute grades of each category and the final grade using the ideas of weighted average. This formula must be linked to each of your input cells, so when you enter a grade, it automatically updates. You may use the average for each category as counting for the full weight of that
