Max

Assignment 1 (20)

Assignment 2 (20)

Assignment 3 (20)

Assignment 4 (20)

Assignment 5 (20)

Mid-Term (100)

Final (100)

Alpha

Assignment 1 (20)

Assignment 2 (20)

Assignment 3 (20)

Assignment 4 (9)

Assignment 5 (8)

Mid-Term (88)

Final (79)

Bravo

Assignment 1 (18)

Assignment 2 (10)

Assignment 3 (20)

Assignment 4 (2)

Assignment 5 (13)

Mid-Term (94)

Final (85)

Charlie

Assignment 1 (14)

Assignment 2 (20)

Assignment 3 (20)

Assignment 4 (7)

Assignment 5 (20)

Mid-Term (58)

Final (88)

Assignment 1 (20)

Assignment 2 (19)

Assignment 3 (11)

Assignment 4 (0)

Assignment 5 (1)

Mid-Term (92)

Final (95)

Assignment 1 (20)

Assignment 2 (20)

Assignment 3 (15)

Assignment 4 (12)

Assignment 5 (17)

Mid-Term (83)

Final (100)

Assignment 1 (17)

Assignment 2 (20)

Assignment 3 (20)

Assignment 4 (4)

Assignment 5 (20)

Mid-Term (75)

Final (90)

Assignment 1 (18)

Assignment 2 (15)

Assignment 3 (20)

Assignment 4 (11)

Assignment 5 (15)

Mid-Term (75)

Final (83)

1.You have to calculate the final score in Cell I2 and copy it down to cells I3 to I9.What formula would you enter in cell I2.

Each of the 5 assignments is graded out of 20 points and assignments are worth 25% on the final grade, the mid-term is worth 30% and final is worth 45%

2.You have to calculate the final score in Cell J2 and copy it down to cells J3 to J9.What formula would you enter in cell J2.

Each of the 5 assignments is graded out of 20 points and assignments are worth 25% on the final grade, the mid-term is worth 30% and final is worth 45%

The lowest assignment score is dropped.The weight for assignments is the same as in 1.