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?

  1. 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

  2. B.

    =(B2+C2+D2+I2)*0.15+(E2+F2+G2+H2)*0.1

  3. C.

    =((B2+C2+D2+I2)*1.5+(E2+F2+G2+H2))/10

  4. D.

    =(B2+C2+D2+I2)/15+(E2+F2+G2+H2)/10

Attempted by 5 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…