Paper 1 · ICT
UGC NET December 2021 June 2022 (01.10.2022) Shift-I
A class grade is based on three tests each counting 15 percent, four quizzes each counting 10 percent and a homework notebook counting 15 percent, with the marks recorded across columns of a spreadsheet. Which of the following formulae would NOT be a correct calculation of the six-week weighted average for a student in row 2?
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 ✓ Correct
Correct answer: (D) =(B2+C2+D2+I2)/15 + (E2+F2+G2+H2)/10 — The answer is the formula that divides by 15 and 10.
Explanation
★The answer is the formula that divides by 15 and 10.
★The three tests and the homework each carry a 15 percent weight, and the four quizzes each carry 10 percent.
★Multiplying each mark by 0.15 or 0.1 correctly applies these weights, so the first three formulae work.
★Dividing by 15 and by 10 instead of multiplying by 0.15 and 0.1 gives the wrong scale.
★So the formula that divides the sums by 15 and 10 is not a correct weighted average.
★It fails to weight the marks properly.
★So the answer is the formula that divides by 15 and 10.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Shared by Mcqkart · via Mcqkart.in