[점수(100점 만점)] : 30
[상세점수] :
[과제(배점:100점)] : 30
[문제] : 과제, I4:I33, [틀림]점수 계산이 틀렸습니다.
[정답] : 95.8 =E4*$N$4+F4*$N$5+G4*$N$6+H4*$N$7 88.7 =E5*$N$4+F5*$N$5+G5*$N$6+H5*$N$7 84.8 =E6*$N$4+F6*$N$5+G6*$N$6+H6*$N$7 72.4 =E7*$N$4+F7*$N$5+G7*$N$6+H7*$N$7 60.3 =E8*$N$4+F8*$N$5+G8*$N$6+H8*$N$7 78.7 =E9*$N$4+F9*$N$5+G9*$N$6+H9*$N$7 63.5 =E10*$N$4+F10*$N$5+G10*$N$6+H10*$N$7 76.1 =E11*$N$4+F11*$N$5+G11*$N$6+H11*$N$7 70.4 =E12*$N$4+F12*$N$5+G12*$N$6+H12*$N$7 82.5 =E13*$N$4+F13*$N$5+G13*$N$6+H13*$N$7 76.1 =E14*$N$4+F14*$N$5+G14*$N$6+H14*$N$7 94.6 =E15*$N$4+F15*$N$5+G15*$N$6+H15*$N$7 88.8 =E16*$N$4+F16*$N$5+G16*$N$6+H16*$N$7 63.5 =E17*$N$4+F17*$N$5+G17*$N$6+H17*$N$7 75.3 =E18*$N$4+F18*$N$5+G18*$N$6+H18*$N$7 71.9 =E19*$N$4+F19*$N$5+G19*$N$6+H19*$N$7 82.1 =E20*$N$4+F20*$N$5+G20*$N$6+H20*$N$7 70.5 =E21*$N$4+F21*$N$5+G21*$N$6+H21*$N$7 66.3 =E22*$N$4+F22*$N$5+G22*$N$6+H22*$N$7 78.7 =E23*$N$4+F23*$N$5+G23*$N$6+H23*$N$7 75.1 =E24*$N$4+F24*$N$5+G24*$N$6+H24*$N$7 79.9 =E25*$N$4+F25*$N$5+G25*$N$6+H25*$N$7 72.8 =E26*$N$4+F26*$N$5+G26*$N$6+H26*$N$7 83.6 =E27*$N$4+F27*$N$5+G27*$N$6+H27*$N$7 56.9 =E28*$N$4+F28*$N$5+G28*$N$6+H28*$N$7 77.1 =E29*$N$4+F29*$N$5+G29*$N$6+H29*$N$7 87.7 =E30*$N$4+F30*$N$5+G30*$N$6+H30*$N$7 59.9 =E31*$N$4+F31*$N$5+G31*$N$6+H31*$N$7 66.5 =E32*$N$4+F32*$N$5+G32*$N$6+H32*$N$7 65.5 =E33*$N$4+F33*$N$5+G33*$N$6+H33*$N$7
[학생] :
[문제] : 과제, J4:J33, [틀림]학점 계산이 틀렸습니다.
[정답] : A+ =VLOOKUP(I4,$M$10:$N$18,2) B+ =VLOOKUP(I5,$M$10:$N$18,2) B =VLOOKUP(I6,$M$10:$N$18,2) C =VLOOKUP(I7,$M$10:$N$18,2) D =VLOOKUP(I8,$M$10:$N$18,2) C+ =VLOOKUP(I9,$M$10:$N$18,2) D =VLOOKUP(I10,$M$10:$N$18,2) C+ =VLOOKUP(I11,$M$10:$N$18,2) C =VLOOKUP(I12,$M$10:$N$18,2) B =VLOOKUP(I13,$M$10:$N$18,2) C+ =VLOOKUP(I14,$M$10:$N$18,2) A =VLOOKUP(I15,$M$10:$N$18,2) B+ =VLOOKUP(I16,$M$10:$N$18,2) D =VLOOKUP(I17,$M$10:$N$18,2) C+ =VLOOKUP(I18,$M$10:$N$18,2) C =VLOOKUP(I19,$M$10:$N$18,2) B =VLOOKUP(I20,$M$10:$N$18,2) C =VLOOKUP(I21,$M$10:$N$18,2) D+ =VLOOKUP(I22,$M$10:$N$18,2) C+ =VLOOKUP(I23,$M$10:$N$18,2) C+ =VLOOKUP(I24,$M$10:$N$18,2) C+ =VLOOKUP(I25,$M$10:$N$18,2) C =VLOOKUP(I26,$M$10:$N$18,2) B =VLOOKUP(I27,$M$10:$N$18,2) F =VLOOKUP(I28,$M$10:$N$18,2) C+ =VLOOKUP(I29,$M$10:$N$18,2) B+ =VLOOKUP(I30,$M$10:$N$18,2) F =VLOOKUP(I31,$M$10:$N$18,2) D+ =VLOOKUP(I32,$M$10:$N$18,2) D+ =VLOOKUP(I33,$M$10:$N$18,2)
[학생] :
[문제] : 과제, K4:K33, [틀림]등수 계산이 틀렸습니다.
[정답] : 1 =RANK.EQ(I4,$I$4:$I$33) 4 =RANK.EQ(I5,$I$4:$I$33) 6 =RANK.EQ(I6,$I$4:$I$33) 19 =RANK.EQ(I7,$I$4:$I$33) 28 =RANK.EQ(I8,$I$4:$I$33) 11 =RANK.EQ(I9,$I$4:$I$33) 26 =RANK.EQ(I10,$I$4:$I$33) 14 =RANK.EQ(I11,$I$4:$I$33) 22 =RANK.EQ(I12,$I$4:$I$33) 8 =RANK.EQ(I13,$I$4:$I$33) 14 =RANK.EQ(I14,$I$4:$I$33) 2 =RANK.EQ(I15,$I$4:$I$33) 3 =RANK.EQ(I16,$I$4:$I$33) 26 =RANK.EQ(I17,$I$4:$I$33) 16 =RANK.EQ(I18,$I$4:$I$33) 20 =RANK.EQ(I19,$I$4:$I$33) 9 =RANK.EQ(I20,$I$4:$I$33) 21 =RANK.EQ(I21,$I$4:$I$33) 24 =RANK.EQ(I22,$I$4:$I$33) 11 =RANK.EQ(I23,$I$4:$I$33) 17 =RANK.EQ(I24,$I$4:$I$33) 10 =RANK.EQ(I25,$I$4:$I$33) 18 =RANK.EQ(I26,$I$4:$I$33) 7 =RANK.EQ(I27,$I$4:$I$33) 30 =RANK.EQ(I28,$I$4:$I$33) 13 =RANK.EQ(I29,$I$4:$I$33) 5 =RANK.EQ(I30,$I$4:$I$33) 29 =RANK.EQ(I31,$I$4:$I$33) 23 =RANK.EQ(I32,$I$4:$I$33) 25 =RANK.EQ(I33,$I$4:$I$33)
[학생] :
[문제] : 과제, Q4:U4, [틀림]평균점수 계산이 틀렸습니다.
[정답] : 70 =AVERAGE(E4:E33) 70.7666666666667 =AVERAGE(F4:F33) 79.6666666666667 =AVERAGE(G4:G33) 76.2 =AVERAGE(H4:H33) 75.5333333333333 =AVERAGE(I4:I33)
[학생] :
[문제] : 과제, Q5:U5, [틀림]최고점수 계산이 틀렸습니다.
[정답] : 99 =MAX(E4:E33) 98 =MAX(F4:F33) 97 =MAX(G4:G33) 96 =MAX(H4:H33) 95.8 =MAX(I4:I33)
[학생] :
[문제] : 과제, Q6:U6, [틀림]최저점수 계산이 틀렸습니다.
[정답] : 41 =MIN(E4:E33) 45 =MIN(F4:F33) 64 =MIN(G4:G33) 55 =MIN(H4:H33) 56.9 =MIN(I4:I33)
[학생] :
[문제] : 과제, O10:O18, [틀림]인원이 틀렸습니다.
[정답] : 2 =COUNTIF($J$4:$J$33,N10) 3 =COUNTIF($J$4:$J$33,N11) 3 =COUNTIF($J$4:$J$33,N12) 5 =COUNTIF($J$4:$J$33,N13) 8 =COUNTIF($J$4:$J$33,N14) 4 =COUNTIF($J$4:$J$33,N15) 3 =COUNTIF($J$4:$J$33,N16) 1 =COUNTIF($J$4:$J$33,N17) 1 =COUNTIF($J$4:$J$33,N18)
[학생] :
[문제] : 과제, True, [틀림]차트종류가 틀렸습니다
[정답] : xlColumnClustered
[학생] :
[문제] : 과제, True, [틀림]차트제목이 틀렸습니다.
[정답] : 컴퓨터 성적
[학생] :