Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Electronic Waste An Actual Gold And Silver Mine

Authors: Antonio Alcivar

1st Edition

979-8367641059

More Books

Students also viewed these Finance questions