analisisANALISIS ITEM OBJEKTIF EXCELSEKTOR PENGURUSAN AKADEMIK, JABATAN PELAJARAN SABAHEXCEL ( 1 ) TAHUN/TINGKATAN ( 5 ) 2010 ( UPSR/PMR/SPM/STPM)Mata Pelajaran :Kod Kertas:PPD: NAMA SEKOLAH:No. Soalan12345678910111213141516171819202122232425262728293031323334353637383940Jumlah markahPeratusKod SekolahNama KelasNama GuruNo. Urutan MuridSkema JawapanBCDCBABDBACCBADABCBDDAADDBACBCCBDADCDCAANama MuridJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan Calonxxx1234MawarMat1aBADCDABDBACCBADCBCCBCAADDCACACCBDADDDCBB2972.52bCADCBCCDBACCBADBBBBDDDDDDBADABCBCADCACAD26653cBCDCBAADBBCCBADABCABDAADDBBABACBAAAADAAB28704fBCDCBABDBACCBADCDCACDBADDAAACDCBDADADCCD28705fCCDCBABDBACCBADACBACDAADDBBCBDCBDADAACAD30756fCCDBBABDAACCBCDADCABAAADDDCABACBCADADACA24607fCCDCBDBDCACCBADADCBBDCADDDAABCCBDADDDCCD2972.58fADDCBDBCBACCBDDCDCACDADDCADABCBAADAABABD16409gCCDBBDBDCACCBDDCCCBBDCADDCBCDCCBDADDDBAD2562.510gBADCBBBDAACCBADAACBCCAADDDBCBCCBDADDDCAD307511gBDDCBDBADABCDADADCDCCACADBABDCCBADDCCABD205012gADDCBDBBBADCBDDCCACBDBACDCCDACDBDADADCCD1947.513h1ADBDACCCAABDACACDDBCADCCACDBDACBDACBDCDA922.514h2DDACBCACCACCBCAADCCDDDDDABADBDCCBADACCDA1947.515h3BCDCBABBBACCBADDBCCBCAADDDDDCCCBDADCDCDA307516h4ADDCBDBBBACCBADABCADCAADDADCADCBDADADCAA2972.517h5BCDCBABBBACCBDDABCACDAABDCBABDCBDAADDCAB287018h6BCDBBCBDCACCBADCBCABCAADCAACADCDDADADDDD246019m1BCDABCBDBACCBADDBCCDDAADDBACBCCBDADCDCDA3587.520m2ACCABCBDBDCDDCDDABDBACDCBADACDCDACDDBCAB1127.52100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490050zzzbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10255100520053005400550056005700Bahagian Hasil Analisis ItemJumlah Calon2121212121212121212121212121212121212121212121212121212121212121212121212121212100Bil. Jawab A531217213180011229218031214125875301417392486% Jawab A24%14%5%10%5%33%10%5%14%86%0%0%5%57%10%43%10%5%38%0%14%57%67%5%10%24%38%33%24%14%0%5%19%81%14%43%10%19%38%29%Bil. Jawab B101241921751323118112946101312276310221721123245% Jawab B48%5%10%19%90%10%81%24%62%10%14%5%86%5%5%10%43%19%29%48%5%14%5%10%10%33%29%14%48%10%10%81%10%5%5%10%14%10%19%24%Bil. Jawab C51111406234017180407315576323252739181211421440% Jawab C24%52%5%67%0%29%10%14%19%0%81%86%0%19%0%33%14%71%24%33%29%14%10%14%10%24%10%33%14%43%86%5%10%5%5%19%10%67%19%0%Bil. Jawab D16171160121112241837124113415154543712132166141510% Jawab D5%29%81%5%5%29%0%57%5%5%5%10%10%19%86%14%33%5%10%19%52%14%19%71%71%19%24%19%14%33%5%10%62%10%76%29%67%5%24%48%Bil. Tak Jawab0000000000000000000000000000000000000000% Tak Jawab0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%Bil. Jawab Betul10111714197171213181718181218991564111214151578710918171317164141486% Jawab Betul48%52%81%67%90%33%81%57%62%86%81%86%86%57%86%43%43%71%29%19%52%57%67%71%71%33%38%33%48%43%86%81%62%81%76%19%67%67%38%29%Tahap kesukaran murid /Respon muridSederhanaSederhanaMudahSederhanaMudahSederhanaMudahSederhanaSederhanaMudahMudahMudahMudahSederhanaMudahSederhanaSederhanaMudahSukarSukarSederhanaSederhanaSederhanaMudahMudahSederhanaSederhanaSederhanaSederhanaSederhanaMudahMudahSederhanaMudahMudahSukarSederhanaSederhanaSederhanaSukarTahap kesukaran JSI EXCELSkema PermarkahanBCDCBABDBACCBADABCBDDAADDBACBCCBDADCDCAANo. Soalan12345678910111213141516171819202122232425262728293031323334353637383940

user:Column merah merupakan bil.soalan/ item. Jika ujian m.pelajaran tersebut mempunyai 60 soalan/item, pengguna perlu mengisi sehingga ke bil.60.

markah ( tidak perlu diisi)Bahagian ini tidak perlu diisi sebarang dataEXCEL ( ) TAHUN/TINGKATAN ( ) 2010 ( UPSR/PMR/SPM/STPM)Mata Pelajaran :Kod Kertas:PPD: Nama Sekolah:Kod SekolahNama KelasNama GuruNo. Soalan12345678910111213141516171819202122232425262728293031323334353637383940markahperatusNo. Urutan MuridSkema JawapanBCDCBABDBACCBADABCBDDAADDBACBCCBDADCDCAANama MuridJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan Calon1a10110111111111101100011110110111111011002972.52b001110011111111010111001111000110111011026653c111111011011111111001111110010110100101028704f111111111111111001001011101000111110110028705f011111111111111100001111110110111110011030756f011011110111101101000111100010110110100124607f01111011011111110110101110101111111011002972.58f001110101111101001001101000011000000000016409g01101011011110100110101110010111111010102562.510g1011101101111111011001111001111111101110307511g1011101001010111010001001110011100110000205012g00111010110110100000101010000101111011001947.513h10000000001000000001000000000001111001101922.514h200011000011110010101100101101010011001011947.515h31111111011111110110001111000011111111101307516h400111010111111111101011110010011111011112972.517h51111111011111011110011101000101111001110287018h61110101101111110110001110011001011101000246019m111101011111111101101111111111111111111013587.520m201001011101000100000000000000010001001101127.521000000000000000000000000000000000000000000022000000000000000000000000000000000000000000023000000000000000000000000000000000000000000024000000000000000000000000000000000000000000025000000000000000000000000000000000000000000026000000000000000000000000000000000000000000027000000000000000000000000000000000000000000028000000000000000000000000000000000000000000029000000000000000000000000000000000000000000030000000000000000000000000000000000000000000031000000000000000000000000000000000000000000032000000000000000000000000000000000000000000033000000000000000000000000000000000000000000034000000000000000000000000000000000000000000035000000000000000000000000000000000000000000036000000000000000000000000000000000000000000037000000000000000000000000000000000000000000038000000000000000000000000000000000000000000039000000000000000000000000000000000000000000040000000000000000000000000000000000000000000041000000000000000000000000000000000000000000042000000000000000000000000000000000000000000043000000000000000000000000000000000000000000044000000000000000000000000000000000000000000045000000000000000000000000000000000000000000046000000000000000000000000000000000000000000047000000000000000000000000000000000000000000048000000000000000000000000000000000000000000049000000000000000000000000000000000000000000050zzz10001010100010001010000001001001000000001025510000000000000000000000000000000000000000000520000000000000000000000000000000000000000000

user:Column merah merupakan bil.soalan/ item. Jika ujian m.pelajaran tersebut mempunyai 60 soalan/item, pengguna perlu mengisi sehingga ke bil.60.

sheet0%Sukar33%Sederhana70%Mudah