A class grade for a six-week period is based on three tests (T1, T2, T3), each…
PYQ UGC NET 2022
A class grade for a six-week period is based on three tests (T1, T2, T3), each weighted 15%; four quizzes (Q1, Q2, Q3, Q4), each weighted 10%; and a homework notebook (HW), weighted 15%. The grades are recorded in the spreadsheet below.
Name | T1 | T2 | T3 | Q1 | Q2 | Q3 | Q4 | HW | AVG |
|---|---|---|---|---|---|---|---|---|---|
Jatin | 87 | 92 | 80 | 76 | 79 | 87 | 74 | 90 | |
Amit | 91 | 85 | 77 | 78 | 88 | 96 | 90 | 92 | |
Anil | 65 | 72 | 70 | 80 | 81 | 74 | 77 | 80 | |
Anita | 96 | 88 | 91 | 76 | 91 | 100 | 74 | 98 |
Which of the following formulas would NOT correctly calculate Jatin’s six-week weighted average?
- A.
= B2*0.15+C2*0.15+D2*0.15+E2*0.1+F2*0.1+G2*0.1+H2*0.1+I2*0.15
- B.
=(B2+C2+D2+I2)*0.15+(E2+F2+G2+H2)*0.1
- C.
=((B2+C2+D2+I2)*1.5+(E2+F2+G2+H2))/10
- D.
=(B2+C2+D2+I2)/15+(E2+F2+G2+H2)/10
Attempted by 5 students.
Sign up free to check your answer
Sign up freeLoading lesson…

