ANALISIS ITEM (Template en Arifin)

download ANALISIS ITEM (Template en Arifin)

of 51

description

Format penilaian untuk tahun 4 dan 5

Transcript of ANALISIS ITEM (Template en Arifin)

Jwp_BetulNama Ujian:Peperiksaan Akhir Tahun 2010No SoalanJawapanNo SoalanJawapanNo SoalanJawapanCatatan:1C21B41T1. Jika bilangan murid melebihi 60,2D22D42Tanalisis adalah berasaskan sampel besar (27%)3C23C43T2. Sebaliknya, analisis adalah berasaskan sampel kecil (50%)4B24B44T5B25C45TBil Murid, N=29Peratusan=50%6A26B46TK1=2Bilangan=147A27D47TK2=158D28A48TK3=179C29B49TK4=3010C30D50T11D31T51TLangkah-langkah Pelaksanaan12A32T52T1. Masukkan jawapan betul untuk setiap soalan pada Lembaran Jwp_Betul13D33T53T2. Klik Lembaran [Markah] dan masukkan Nama Murid (Opsyenal), Markah dan Jawapan Murid14A34T54T3. Klik butang [Sort Markah]15C35T55T4. Akses Lembaran Analisis untuk mendapatkan analisis yang dikehendaki16A36T56T17C37T57T18B38T58T19A39T59T20C40T60T

MarkahNama MuridMarkahQ1Q2Q3Q4Q5Q6Q7Q8Q9Q10Q11Q12Q13Q14Q15Q16Q17Q18Q19Q20Q21Q22Q23Q24Q25Q26Q27Q28Q29Q30Q31Q32Q33Q34Q35Q36Q37Q38Q39Q40Q41Q42Q43Q44Q45Q46Q47Q48Q49Q50Q51Q52Q53Q54Q55Q56Q57Q58Q59Q60MELMIEZAN MUSA22BCBBBACBCCCADAAACBACBDCCDCDABCNURUL FATIHAH NAJIHAH22CDCBBAABDCDABAABCBBCCDCBCBAABDEDRIN SHA MELVIN USAK21CDCBBAADDCCADAAACBDCCDABDBAACBPAMILA MAILAM21CDCBBADBDCDCDACDCDDCBDDBDDCABDMOHD IRFAN NIEZAM ALEK20CDCBBABBDDDADACBCBAACDABABDABBALFIDO AMIDIN19CDCBBAABDCDACBABCAACADCBDACCBDANDRY CHRISTINUEL ANDREAS19CDCBBAADDCCADBACDBACAAABCBAABBGLEND PILIM19CDCBBAADDCDABBCACBAACDAABCAABCLOVELYN YVONNE IGNATIUS19CDCBBAABCCDCDAABCBACCDABAACAABASYEERA GRACE NGILOH18CDCBBAABCCCBAAABCBACCDABDCDACBEVVYCLYERENSIE ALFIZAN18CDCBBACBCCACDDABCBACCDCBAAAABBHARRY J. BOY JAFFRY18CDCBBADBDCDABBABCAACADCBDACCBDRAMZIAH SAFIYYAH ABD RAHMAN18CDCBBAADDCCDCAABCBACCDABCBCADDREVIRENLY ROSELLEY18CDCBBAABCCDCBBAACCCCCDDBADAAABWILLIANSTHON WILLIS18CDBDBCABCCDCBACBCBCDBDDBDBCABCALYSCIA PAULOS17CDCBBDAADCADCACBCBBCBDABACAABBSITI HASMAH AMPAT17CDCBBCBBCDDACCABCAACBDCBACCABCSITI HAJAR NURFITRY MATURIN16CDCBBAADCCADACADCBCDADABABCBBBRATNA HASSAN15CDCBBCABDCACDDABCDCCCDDBDBCBBCRONALDO ESING15CDCBBABBDDDDDAABCDDABDABCDBABCROBERTO RUKINIT14CDCBBCCDDCDCABABDDADCDDBDBAAACROSLIA RANO14CDCBBDABACDACCABDBACAAABAABCBBMIRSA MUSA13AADCCABBCCBBDBABCCBCAAABCBAABCNORLIZA MISIN13CCCBBDABCCDCCBABCBBDBCDBDCABCDNUR YULIZZA NADIRA JUANIS12CDCBBBABDCADBCACDABABDAAACCABDSITI FARHANA ENGGU12CDCBBACCDCADCDABDCDDBDDDCBCAACEZRANAZRA BABAGON11CDCABDBBDCADDDABCADCADAAABAAABJASNIETAH JANEH11CDCDBAABDDACCCABABAABCDBBDBAACMOHD SHAHRUL NIZAM AFIDUN10CDBBBDCADAACBACBCABADADBBCAABB

Sort Markah

AnalisisAnalisis Peratus Respond Untuk Setiap Pilihan JawapanITEMQ1Q2Q3Q4Q5Q6Q7Q8Q9Q10Q11Q12Q13Q14Q15Q16Q17Q18Q19Q20Q21Q22Q23Q24Q25Q26Q27Q28Q29Q30Q31Q32Q33Q34Q35Q36Q37Q38Q39Q40Q41Q42Q43Q44Q45Q46Q47Q48Q49Q50Q51Q52Q53Q54Q55Q56Q57Q58Q59Q60A3.453.450.003.450.0065.5258.626.903.453.4531.0334.4810.3441.3879.3113.793.4520.6948.2820.6924.1413.7948.2810.3434.4817.2441.3879.3120.690.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00B3.450.0010.3486.2196.553.4517.2468.970.000.003.456.9024.1427.590.0072.410.0055.1720.690.0034.480.000.0082.7610.3441.3810.3410.3465.5241.380.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00C93.106.9086.213.453.4513.7917.243.4534.4882.7617.2434.4827.5917.2420.696.9079.3110.3413.7962.0737.936.9020.693.4520.6927.5937.9310.3410.3434.480.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00D0.0089.663.456.900.0017.246.9020.6962.0713.7948.2824.1437.9313.790.006.9017.2413.7917.2417.243.4579.3131.033.4534.4813.7910.340.003.4524.140.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00Tidak Jawab0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00-0.000.000.000.000.000.000.000.00-0.000.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00Jumlah100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00100.00Jawapan BetulCDCBBAADCCDADACACBACBDCBCBDABDTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTJulat TbMarkah!C2:C15Markah!D2:D15Markah!E2:E15Markah!F2:F15Markah!G2:G15Markah!H2:H15Markah!I2:I15Markah!J2:J15Markah!K2:K15Markah!L2:L15Markah!M2:M15Markah!N2:N15Markah!O2:O15Markah!P2:P15Markah!Q2:Q15Markah!R2:R15Markah!S2:S15Markah!T2:T15Markah!U2:U15Markah!V2:V15Markah!W2:W15Markah!X2:X15Markah!Y2:Y15Markah!Z2:Z15Markah!AA2:AA15Markah!AB2:AB15Markah!AC2:AC15Markah!AD2:AD15Markah!AE2:AE15Markah!AF2:AF15Markah!AG2:AG15Markah!AH2:AH15Markah!AI2:AI15Markah!AJ2:AJ15Markah!AK2:AK15Markah!AL2:AL15Markah!AM2:AM15Markah!AN2:AN15Markah!AO2:AO15Markah!AP2:AP15Markah!AQ2:AQ15Markah!AR2:AR15Markah!AS2:AS15Markah!AT2:AT15Markah!AU2:AU15Markah!AV2:AV15Markah!AW2:AW15Markah!AX2:AX15Markah!AY2:AY15Markah!AZ2:AZ15Markah!BA2:BA15Markah!BB2:BB15Markah!BC2:BC15Markah!BD2:BD15Markah!BE2:BE15Markah!BF2:BF15Markah!BG2:BG15Markah!BH2:BH15Markah!BI2:BI15Markah!BJ2:BJ15Julat RbMarkah!C17:C30Markah!D17:D30Markah!E17:E30Markah!F17:F30Markah!G17:G30Markah!H17:H30Markah!I17:I30Markah!J17:J30Markah!K17:K30Markah!L17:L30Markah!M17:M30Markah!N17:N30Markah!O17:O30Markah!P17:P30Markah!Q17:Q30Markah!R17:R30Markah!S17:S30Markah!T17:T30Markah!U17:U30Markah!V17:V30Markah!W17:W30Markah!X17:X30Markah!Y17:Y30Markah!Z17:Z30Markah!AA17:AA30Markah!AB17:AB30Markah!AC17:AC30Markah!AD17:AD30Markah!AE17:AE30Markah!AF17:AF30Markah!AG17:AG30Markah!AH17:AH30Markah!AI17:AI30Markah!AJ17:AJ30Markah!AK17:AK30Markah!AL17:AL30Markah!AM17:AM30Markah!AN17:AN30Markah!AO17:AO30Markah!AP17:AP30Markah!AQ17:AQ30Markah!AR17:AR30Markah!AS17:AS30Markah!AT17:AT30Markah!AU17:AU30Markah!AV17:AV30Markah!AW17:AW30Markah!AX17:AX30Markah!AY17:AY30Markah!AZ17:AZ30Markah!BA17:BA30Markah!BB17:BB30Markah!BC17:BC30Markah!BD17:BD30Markah!BE17:BE30Markah!BF17:BF30Markah!BG17:BG30Markah!BH17:BH30Markah!BI17:BI30Markah!BJ17:BJ30Analisis Indek Kesukaran (P) dan Indek Diskriminasi (D) Setiap SoalanITEMQ1Q2Q3Q4Q5Q6Q7Q8Q9Q10Q11Q12Q13Q14Q15Q16Q17Q18Q19Q20Q21Q22Q23Q24Q25Q26Q27Q28Q29Q30Q31Q32Q33Q34Q35Q36Q37Q38Q39Q40Q41Q42Q43Q44Q45Q46Q47Q48Q49Q50Q51Q52Q53Q54Q55Q56Q57Q58Q59Q60Tb13131314141494513887834131010122135123531295000000000000000000000000000000Rb13121211135724105243209546791113601092000000000000000000000000000000Tb + Rb262525252719166923131011115422151418922623611322187000000000000000000000000000000Tb - Rb01131922133635144566-54410-13203000000000000000000000000000000P = (Tb + Rb)/N0.930.890.890.890.960.680.570.210.320.820.460.360.390.390.180.140.790.540.500.640.320.790.210.820.210.390.110.790.640.250.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00D = (Tb - Rb)/(N/2)0.000.070.070.210.070.640.140.140.070.210.210.430.210.360.070.290.290.360.430.43-0.360.290.290.070.00-0.070.210.140.000.210.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00Julat TbMarkah!C2:C15Markah!D2:D15Markah!E2:E15Markah!F2:F15Markah!G2:G15Markah!H2:H15Markah!I2:I15Markah!J2:J15Markah!K2:K15Markah!L2:L15Markah!M2:M15Markah!N2:N15Markah!O2:O15Markah!P2:P15Markah!Q2:Q15Markah!R2:R15Markah!S2:S15Markah!T2:T15Markah!U2:U15Markah!V2:V15Markah!W2:W15Markah!X2:X15Markah!Y2:Y15Markah!Z2:Z15Markah!AA2:AA15Markah!AB2:AB15Markah!AC2:AC15Markah!AD2:AD15Markah!AE2:AE15Markah!AF2:AF15Markah!AG2:AG15Markah!AH2:AH15Markah!AI2:AI15Markah!AJ2:AJ15Markah!AK2:AK15Markah!AL2:AL15Markah!AM2:AM15Markah!AN2:AN15Markah!AO2:AO15Markah!AP2:AP15Markah!AQ2:AQ15Markah!AR2:AR15Markah!AS2:AS15Markah!AT2:AT15Markah!AU2:AU15Markah!AV2:AV15Markah!AW2:AW15Markah!AX2:AX15Markah!AY2:AY15Markah!AZ2:AZ15Markah!BA2:BA15Markah!BB2:BB15Markah!BC2:BC15Markah!BD2:BD15Markah!BE2:BE15Markah!BF2:BF15Markah!BG2:BG15Markah!BH2:BH15Markah!BI2:BI15Markah!BJ2:BJ15Julat RbMarkah!C17:C30Markah!D17:D30Markah!E17:E30Markah!F17:F30Markah!G17:G30Markah!H17:H30Markah!I17:I30Markah!J17:J30Markah!K17:K30Markah!L17:L30Markah!M17:M30Markah!N17:N30Markah!O17:O30Markah!P17:P30Markah!Q17:Q30Markah!R17:R30Markah!S17:S30Markah!T17:T30Markah!U17:U30Markah!V17:V30Markah!W17:W30Markah!X17:X30Markah!Y17:Y30Markah!Z17:Z30Markah!AA17:AA30Markah!AB17:AB30Markah!AC17:AC30Markah!AD17:AD30Markah!AE17:AE30Markah!AF17:AF30Markah!AG17:AG30Markah!AH17:AH30Markah!AI17:AI30Markah!AJ17:AJ30Markah!AK17:AK30Markah!AL17:AL30Markah!AM17:AM30Markah!AN17:AN30Markah!AO17:AO30Markah!AP17:AP30Markah!AQ17:AQ30Markah!AR17:AR30Markah!AS17:AS30Markah!AT17:AT30Markah!AU17:AU30Markah!AV17:AV30Markah!AW17:AW30Markah!AX17:AX30Markah!AY17:AY30Markah!AZ17:AZ30Markah!BA17:BA30Markah!BB17:BB30Markah!BC17:BC30Markah!BD17:BD30Markah!BE17:BE30Markah!BF17:BF30Markah!BG17:BG30Markah!BH17:BH30Markah!BI17:BI30Markah!BJ17:BJ30