[점수(100점 만점)] : 75
[상세점수] :
[과제(배점:100점)] : 75
[문제] : 과제, True, [틀림]차트의 데이터레이블이 틀렸습니다.
[정답] : ,,,,,,,,,,,,,,,,81.95,,69.23,,
[학생] : ,,,,,,,,,,,,,,,,,,,,
[문제] : 과제, Q14:Q23, [틀림]평균점수 계산이 틀렸습니다.
[정답] : 68.26 =AVERAGEIF($B$4:$B$33,N14,$J$4:$J$33) 79.3 =AVERAGEIF($B$4:$B$33,N15,$J$4:$J$33) 83.15 =AVERAGEIF($B$4:$B$33,N16,$J$4:$J$33) 71.3 =AVERAGEIF($B$4:$B$33,N17,$J$4:$J$33) 77.48 =AVERAGEIF($B$4:$B$33,N18,$J$4:$J$33) 76.9333333333333 =AVERAGEIF($B$4:$B$33,N19,$J$4:$J$33) 81.95 =AVERAGEIF($B$4:$B$33,N20,$J$4:$J$33) 81.5 =AVERAGEIF($B$4:$B$33,N21,$J$4:$J$33) 69.225 =AVERAGEIF($B$4:$B$33,N22,$J$4:$J$33) 78.4 =AVERAGEIF($B$4:$B$33,N23,$J$4:$J$33)
[학생] : 68.26 =AVERAGEIF($C$4:$C$33,O14,J4:J33) 73.95 =AVERAGEIF($C$4:$C$33,O15,J5:J34) 81.75 =AVERAGEIF($C$4:$C$33,O16,J6:J35) 63.5 =AVERAGEIF($C$4:$C$33,O17,J7:J36) 74.96 =AVERAGEIF($C$4:$C$33,O18,J8:J37) 82 =AVERAGEIF($C$4:$C$33,O19,J9:J38) 77 =AVERAGEIF($C$4:$C$33,O20,J10:J39) 79.9 =AVERAGEIF($C$4:$C$33,O21,J11:J40) 63.5 =AVERAGEIF($C$4:$C$33,O22,J12:J41) 73.95 =AVERAGEIF($C$4:$C$33,O23,J13:J42)
[문제] : 과제, J4:J33, [틀림]점수 계산이 틀렸습니다.
[정답] : 95.8 =SUMPRODUCT(F4:I4,$N$5:$Q$5) 88.7 =SUMPRODUCT(F5:I5,$N$5:$Q$5) 84.8 =SUMPRODUCT(F6:I6,$N$5:$Q$5) 72.4 =SUMPRODUCT(F7:I7,$N$5:$Q$5) 60.3 =SUMPRODUCT(F8:I8,$N$5:$Q$5) 78.7 =SUMPRODUCT(F9:I9,$N$5:$Q$5) 63.5 =SUMPRODUCT(F10:I10,$N$5:$Q$5) 76.1 =SUMPRODUCT(F11:I11,$N$5:$Q$5) 70.4 =SUMPRODUCT(F12:I12,$N$5:$Q$5) 82.5 =SUMPRODUCT(F13:I13,$N$5:$Q$5) 76.1 =SUMPRODUCT(F14:I14,$N$5:$Q$5) 94.6 =SUMPRODUCT(F15:I15,$N$5:$Q$5) 88.8 =SUMPRODUCT(F16:I16,$N$5:$Q$5) 63.5 =SUMPRODUCT(F17:I17,$N$5:$Q$5) 75.3 =SUMPRODUCT(F18:I18,$N$5:$Q$5) 71.9 =SUMPRODUCT(F19:I19,$N$5:$Q$5) 82.1 =SUMPRODUCT(F20:I20,$N$5:$Q$5) 70.5 =SUMPRODUCT(F21:I21,$N$5:$Q$5) 66.3 =SUMPRODUCT(F22:I22,$N$5:$Q$5) 78.7 =SUMPRODUCT(F23:I23,$N$5:$Q$5) 75.1 =SUMPRODUCT(F24:I24,$N$5:$Q$5) 79.9 =SUMPRODUCT(F25:I25,$N$5:$Q$5) 72.8 =SUMPRODUCT(F26:I26,$N$5:$Q$5) 83.6 =SUMPRODUCT(F27:I27,$N$5:$Q$5) 56.9 =SUMPRODUCT(F28:I28,$N$5:$Q$5) 77.1 =SUMPRODUCT(F29:I29,$N$5:$Q$5) 87.7 =SUMPRODUCT(F30:I30,$N$5:$Q$5) 59.9 =SUMPRODUCT(F31:I31,$N$5:$Q$5) 66.5 =SUMPRODUCT(F32:I32,$N$5:$Q$5) 65.5 =SUMPRODUCT(F33:I33,$N$5:$Q$5)
[학생] : 95 95 88.7 =SUMPRODUCT(F5:I5,$N$5:$Q$5) 84.8 =SUMPRODUCT(F6:I6,$N$5:$Q$5) 72.4 =SUMPRODUCT(F7:I7,$N$5:$Q$5) 60.3 =SUMPRODUCT(F8:I8,$N$5:$Q$5) 78.7 =SUMPRODUCT(F9:I9,$N$5:$Q$5) 63.5 =SUMPRODUCT(F10:I10,$N$5:$Q$5) 76.1 =SUMPRODUCT(F11:I11,$N$5:$Q$5) 70.4 =SUMPRODUCT(F12:I12,$N$5:$Q$5) 82.5 =SUMPRODUCT(F13:I13,$N$5:$Q$5) 76.1 =SUMPRODUCT(F14:I14,$N$5:$Q$5) 94.6 =SUMPRODUCT(F15:I15,$N$5:$Q$5) 88.8 =SUMPRODUCT(F16:I16,$N$5:$Q$5) 63.5 =SUMPRODUCT(F17:I17,$N$5:$Q$5) 75.3 =SUMPRODUCT(F18:I18,$N$5:$Q$5) 71.9 =SUMPRODUCT(F19:I19,$N$5:$Q$5) 82.1 =SUMPRODUCT(F20:I20,$N$5:$Q$5) 70.5 =SUMPRODUCT(F21:I21,$N$5:$Q$5) 66.3 =SUMPRODUCT(F22:I22,$N$5:$Q$5) 78.7 =SUMPRODUCT(F23:I23,$N$5:$Q$5) 75.1 =SUMPRODUCT(F24:I24,$N$5:$Q$5) 79.9 =SUMPRODUCT(F25:I25,$N$5:$Q$5) 72.8 =SUMPRODUCT(F26:I26,$N$5:$Q$5) 83.6 =SUMPRODUCT(F27:I27,$N$5:$Q$5) 56.9 =SUMPRODUCT(F28:I28,$N$5:$Q$5) 77.1 =SUMPRODUCT(F29:I29,$N$5:$Q$5) 87.7 =SUMPRODUCT(F30:I30,$N$5:$Q$5) 59.9 =SUMPRODUCT(F31:I31,$N$5:$Q$5) 66.5 =SUMPRODUCT(F32:I32,$N$5:$Q$5) 65.5 =SUMPRODUCT(F33:I33,$N$5:$Q$5)