analisis item objektif 60 item

Download Analisis Item Objektif 60 Item

Post on 22-Dec-2015

37 views

Category:

Documents

8 download

Embed Size (px)

DESCRIPTION

analisis item

TRANSCRIPT

analisisANALISIS ITEM OBJEKTIF EXCELSEKTOR PENGURUSAN AKADEMIK, JABATAN PELAJARAN SABAHEXCEL ( II ) TINGKATAN ( 3 ) 2010 ( PMR )Mata Pelajaran :Kod Kertas:PPD:No. Soalan123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960Jumlah markahPeratusKod SekolahNama KelasNama GuruNo. Urutan MuridSkema JawapanaABCCCCCBBCABADBDBBBAACBCABDCBDACCACDDCcDDCbDDCbCacCcDCbDDCcNo. Urutan Murid/Nama muridJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan Calon1aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.52aCCBABDDADBACABCDDBCDBABCCABDCACDDCCDDCBDDCBDDCBDDCCDDCBDDCB8203aACBBCBABBCABADBADCCDBBBCABDBCCCCCCCADABADABADABCCCCADABADAB922.54aBCCDBBABBBABAADDBADDACABABBCCABDDDCDDBBDDBBDDBBDDDCDDBBDDBB10255aBBBDCBDBBCABADBDCBBACCBCCBDCCABCCACDDCADDCADDCACCACDDCADDCA717.56aBBCDCACBBCABADBDBDBABCBCCBBACDBCCACDDCCDDCCDDCCCCACDDCCDDCC717.57aBABDBDABDAABDCDAADADBAADBBBDCBCCBBADCBADCBADCBACBBADCBADCBA12308aBCCDCBDABCABADBDDBBAACBCCAAACDCCCACDACCDACCDACCCCACDACCDACC1127.59aACBBDDBCDCBDCCABDBCBBCBCCADCADCCBCBCBDBCBDBCBDBCBCBCBDBCBDB512.510aBBBDCCCDBCABADBDDCBDBCBCBDADCDBDCCCDADBDADBDADBDCCCDADBDADB512.511aBBCDCAADBCABADBDCBBAACBCCBBACDBCCBCDDDCDDDCDDDCCCBCDDDCDDDC82012aBCBDCACDBCABADBDCBBABCBCBDCDCDBCCACDDBBDDBBDDBBCCACDDBBDDBB61513DCABBCDDAACABDDDDCBACCDCDABADADCDABBABBAABBAABBADABBABBAABBA1127.514BBCCDCBDCBDABADDDABADACCBABADCABCCACDDCCDDCCDDCCCCACDDCCDDCC922.515DDBCCCADDBCABADBDDBAABCCCAADDCDBCCACDDCBDDCBDDCBCCACDDCBDDCB82016BAACDDDCCDBBDCABABACDACBCABCABBCBCACBABDBABDBABDBCACBABDBABD102517DBCBDAACDDCABADBDDCAADABCCBACCDCCCDCADDCADDCADDCCCDCADDCADDC922.518DBBBCCACDBCABADBDCBABBABCCBAACDBCCDBAADCAADCAADCCCDBAADCAADC922.519DBCCCCBCABCABADDDBDBBBABCBCDCCDCCABCDDBCDDBCDDBCCABCDDBCDDBC512.520DABCDCCDDBCABADBDDBBABCBCBBACCDBCCDCADCCADCCADCCCCDCADCCADCC61521DBBCDCADDBCABADBDDBCABCBCBBACCDBCCACCDCCCDCCCDCCCCACCDCCCDCC61522DBBCDCADDBCABADBDDCBABCBCCBBDCDBCCBCDDCCDDCCDDCCCCBCDDCCDDCC41023BBBCDCBDDDCABADBDBBBACCBBCBBBCDCCCBCDDDCDDDCDDDCCCBCDDDCDDDC37.524ABBBCCBDCDCABCDBDBBCDBCBCBCDDCDACCACDDDCDDDCDDDCCCACDDDCDDDC41025DBCCDCACDBCABADBDBBAABCBCCBBDCDBCCACDDCCDDCCDDCCCCACDDCCDDCC61526ABBBCCBDCDCABCDBDBBCDBCBCBCDDCDACCACDDDCDDDCDDDCCCACDDDCDDDC41027DBCCDCACDBCABADBDBBAABCBCCBBDCDBCCACDDCCDDCCDDCCCCACDDCCDDCC61528ABBBCCBDCDCABCDBDBBCDBCBCBCDDCDACCACDDDCDDDCDDDCCCACDDDCDDDC41029DBCCDCACDBCABADBDBBAABCBCCBBDCDBCCACDDCCDDCCDDCCCCACDDCCDDCC61530ABBBCCBDCDCABCDBDBBCDBCBCBCDDCDACCACDDDCDDDCDDDCCCACDDDCDDDC41031aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.532aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.533aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.534aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.535aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.536aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.537aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.538aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.539aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.540aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.541aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.542aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.543aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.544aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.545aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.546aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.547aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.548aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.549aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.550aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.551aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.552aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABB1537.553aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABa1537.554aBCBDCDBCDDAAABCDCBAADAABBAABADAACCCAABBAABBAABBACCCAABBAABa1537.5Bahagian Hasil Analisis ItemJumlah Calon5454545454545454545454545454545454545454545454545454545454545454545454545454545454545454545454545454545454545454545454540000Bil. Jawab A404301111441152254621322343953027062933527429252151302913302913302913252151302913302915% Jawab A74%7%6%0%2%2%20%7%7%2%2%96%46%85%4%2%6%4%4%63%72%9%56%50%0%11%54%61%9%50%7%54%46%4%28%2%56%54%2%6%56%54%2%6%56%54%2%6%46%4%28%2%56%54%2%6%56%54%2%9%Bil. Jawab B347143933112651832260262211245103201242835181027121512631231321231321231321263123132123130% Jawab B6%87%26%72%6%6%20%48%9%33%6%4%48%0%48%41%2%22%83%19%6%37%2%44%52%65%33%19%50%2%4%28%2%4%11%6%2%4%57%59%2%4%57%59%2%4%57%59%2%4%11%6%2%4%57%59%2%4%57%56%Bil. Jawab C0237157482103202401622603049132232413527261102448295021121821121821121824482950211218211218% Jawab C0%4%69%28%13%89%4%19%59%0%44%0%2%11%4%48%0%56%7%17%2%6%41%6%44%24%9%4%13%48%2%19%44%89%54%93%4%2%22%33%4%2%22%33%4%2%22%33%44%89%54%93%4%2%22%33%4%2%22%33%Bil. Jawab D11100432301413352602224550103111261020291504704240212210121221012122101424021221012122101% Jawab D20%2%0%0%80%4%56%26%24%65%48%0%4%4%44%9%93%19%6%2%20%48%2%0%4%0%4%17%28%0%87%0%7%4%7%0%39%41%19%2%39%41%19%2%39%41%19%2%7%4%7%0%39%41%19%2%39%41%19%2%Bil. Tak Jawab000000000000000000000000000000000000000000000000000000000000% 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%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%Bil. Jawab Betul404141574821051824522646242250124510395222424618971472924481550212212182122127212212724242522212721221218% Jawab Betul74%7%26%28%13%89%4%19%9%33%44%96%48%85%44%41%93%22%83%19%72%9%41%44%44%11%33%17%13%2%87%54%44%89%28%93%39%41%22%33%39%41%22%13%39%41%22%13%44%4%7%46%4%41%22%13%39%41%22%33%Tahap kesukaran muridMudahSukarSukarSukarSukarMudahSukarSukarSukarSederhanaSederhanaMudahSederhanaMudahSederhanaSederhanaMudahSukarMudahSukarMudahSukarSederhanaSederhanaSederhanaSukarSederhanaSukarSukarSukarMudahSederhanaSederhanaMudahSukarMudahSederhanaSederhanaSukarSederhanaSederhanaSederhanaSukarSukarSederhanaSederhanaSukarSukarSederhanaSukarSukarSederhanaSukarSederhanaSukarSukarSederhanaSederhanaSukarSederhanaPeringkat Negeri JSISkema JawapanaABCCCCCBBCABADBDBBBAACBCABDCBDACCACDDCcDDCbDDCbCacCcDCbDDCc

user:Column merah merupakan bil.soalan/ item. Jika ujian m.pelajaran tersebut mempunyai 60 soalan/item, pengguna perlu mengisi sehingga ke bil.60.user:Column biru merupakan skema jawapan untuk setiap item. Pengguna perlu mengisi setiap skema jawapan di setiap item.

markah( tidak perlu diisi)Bahagian ini tidak perlu diisi sebarang dataEXCEL ( ) TAHUN ( ) 2010 ( )Mata Pelajaran :Kod Kertas:PPD:Kod SekolahNama KelasNama GuruNo. Soalan123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960markahperatusNo. Urutan MuridSkema JawapanaABCCCCCBBCABADBDBBBAACBCABDCBDACCACDDCcDDCbDDCbCacCcDCbDDCcNo. Urutan MuridJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan CalonJawapan Calon11000000000011100000110110011010110001100110011001000110011001537.521000100010010100000000100010001000000000000000000000000000008203110000010001010010000000010000000000101010101010000010101010922.5410000001000101100010010101000010000000000000000000000000000010255100000000001010000001000000000100010000100010001001000010001717.56100000100001010000001000000010000010000000000000001000000000717.57101000010011000011010011000000000001000100010001000100010001123081000000010010100000011000011100000100100010001000010010001001127.59110000000000000100000000001001000000000000000000000000000000512.510100000000001010000000000000100000000010001000100000001000100512.51110000011000101000000110000001000000000000000000000000000000082012100000100001010000001000000000000010000000000000001000000000615130010000011010000000100000101010001001001100110010100100110011127.514000000000001010001010100010100100010000000000000001000000000922.51500000010000101000001100001100000001000000000000000100000000082016011000000000001010100100010010000010010001000100001001000100102517000001100001010000011010000100000000100010001000000010001000922.518000000100001010000010010000110000000110011001100000011001100922.519000000001001010000000010000000000100000000000000010000000000512.52001000000000101000000100000010000000010001000100000001000100061521000000100001010000001000000100000010000000000000001000000000615220000001000010100000010000000000000000000000000000000000000004102300000000000101000000100000000000000000000000000000000000000037.524100000000001000000000000000000010010000000000000001000000000410250000001000010100000110000000000000100000000000000010000000006152610000000000100000000000000000001001000000000000000100000000041027000000100001010000011000000000000010000000000000001000000000615281000000000010000000000000000000100100000000000000010000000004102900000010000101000001100000000000001000000000000000100000000061530100000000001000000000000000000010010000000000000001000000000410311000000000011100000110110011010110001100110011001000110011001537.5321000000000011100000110110011010110001100110011001000110011001537.5331000000000011100000110110011010110001100110011001000110011001537.5341000000000011100000110110011010110001100110011001000110011001537.5351000000000011100000110110011010110001100110011001000110011001537.5361000000000011100000110110011010110001100110011001000110011001537.5371000000000011100000110110011010110001100110011001000110011001537.5381000000000011100000110110011010110001100110011001000110011001537.5391000000000011100000110110011010110001100110011001000110011001537.5401000000000011100000110110011010110001100110011001