1.In your New class, you would be required to complete 5 assignments during the semester. The best 4 assignment grades would count toward the final grade. In addition, you would be required to complete a term paper, and also take a mid-term and a final examination. Assignments are worth 20% on the final grade, the term paper is worth another 20% on the final grade, and the mid-term and the final are worth 25% and 35%, respectively. Scored for 4 students are provided in Sheet named Problem 1 of the accompanying Excel file named Final

Examination. Maximum scores are in row 2.

a.Calculate overall assignment grade out 20 in Cell G3 for Alpha. You should be able to copy the formula in cells G4 to G6. Copy/write this formula in the section for the answer.

b.You also want to calculate the overall grade for each student. What formula would you enter in cell K3 to calculate the weighted score so that it can be copied to cells K4 to K6 to calculate weighted score (out of 100) for each student.

Name Assn1 Assn2 Assn3 Assn4 Assn5 Assignments TermPaper Midterm Final Weighted Score Max 10 10 10 10 10 20 100 100 Alpha 5 9 6 8 9 17 84 91 Bravo 2 2 0 2 0 18 84 78 Charlie O 4 O 0 3 16 94 70 Delta 6 O 0 3 18 92 98 Numbers may change as you enter formulae. However, the formula would be the same