Homework answers / question archive / As a Teaching Assistant in MIS143, you need to calculate the grades and final grades for all students using Grades

As a Teaching Assistant in MIS143, you need to calculate the grades and final grades for all students using Grades

Business

Share With

As a Teaching Assistant in MIS143, you need to calculate the grades and final grades for all students using Grades.xlsx. The final grades include the quiz scores as well as individual assignments and a final project assignment. Note that you wish to impress your professor who likes functions such as LOOKUP because you wish to receive a good recommendation and a raise.

undefined

• Calculate the class averages and letter grades that the correspond to for all students. Call this worksheet “Quizzes”. 
• Calculate the class average and final letter grades for all students. Also, create an appropriate chart showing the distribution of grades. Call this worksheet “Final Grade”.