Question
A professor uses an Excel sheet to calculate the final grades of his courses. Below you can find the formula that he uses for this
A professor uses an Excel sheet to calculate the final grades of his courses. Below you can find the formula that he uses for this purpose. His class has four quizzes (Q1, Q2, Q3, and Q4) four projects (P1, P2, P3, and P4) one mid term (MT) and one final test (FT). Notice on the formula that the quizzes and the projects are graded zero to 10, while the mid term and the final are graded zero to 100. The quizzes accounts for 10% of the final grade while the projects 40%, and the tests 25% each (see the formula).
During the course the professor decided to help students that missed one quiz by offering and extra quiz (QX) that all students could take. Also, he offered an extra project (PX) worth ten points, for extra points towards the final test.
Please modify (type) the formula to account for these changes (the extra quiz and the final test extra points).
You do not need to solve it, nor to use Excel. Just update (retype) the formula to accurately calculate the final grade.
=(((Q1+Q2+Q3+Q4)/40)*10)+(P1+P2+P3+P4)/40)*25)+((MT/100)*25)+((FT/100)*25)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started