Sheet1Bil.Nama MuridSoalan12345678910111213141516171819201ABDUL HARIS HAZIM B ABD HALIMBABDCDCDBDACCDCADCBB2MUHAMAD ARIF AIMAN B. ROMLIBDCACDDDBDCCCACADCBB3MUHAMMAD ISMA NIZAM B ISMAILBABDCDCBBDACCDCBDCBB4WAN NUR FARHAN BIN W AHMADDAADADDDBDACBCCBDCBB5SITI MAISARAH BT ROSLANBABDADBBADCCCDDBDCAB6MUHAMMAD UMMUL AIMAN B ROSLIBACDCADDBDACCDADDCBB7NABILAH HUDA BT KAHARBDBDCDDDCDBCCDDBDCBB8ARIF B ZAKARIA @ ARIFFINCDABADADBDCCCAABDCAD9MUHAMMAD WAFIYUDDIN B SARDIBABDCDDBADACBCAABDBB10NUR ALANI FATINI BT MOHD YUSRIDACDCDBBBDACCDACDCBB11AHMAD ARSYAD B AB JALILBDBDCADBBDBCCDAABCBA12MUHD FARIS IKHWAN B ZAMZURIBAADCDDBBABCCCBBDBBA13MUHAMMAD FIRDAUS BIN RAZALIBDDDAADBBAACCCBADCCA14NUR ANIS FARAHIN BT AMRANDACDCDCBBDDCCDAADCDD15AHMAD ZAIM HAZIQ B ZAINUDDINDAADCDDBBAACDCBDCCBB16MUHAMMAD IRFAN B MAT ZAMDAADCDDBBAACAACBACAB17MUHAMAD SYAFIQ HAIKAL B SHAFIEAABCCDDDDAACCACBCCCD18NUR SHAUQINA BT ZAMRIDACBCDCCBDBCCBCCADBA19SITI ELIYA NAJIHA BT ABDUL WAHIDDDBACADBCDACAACCDCBB20SITI HAJAR BT MOHAMED ISADDCACADDBDDCACACDBBA21NUR SALINIE ASWANIE BT HAMZAHDDCBCCDDDDACDBACDCBB22NUR HIDAYAH HUSNA BT M ROSDIBDBCCCDBBABCAACCDCDD23NURUL EREYNA NARESHA BT ROZAKBDDBCADBDDACCBDBDDAB24NASRUL HAKIM B HANAMIBDBCCBDBCAACBCBDDBAB25NURUL AIN NADIA BT MOHD SAHIRBDCACDBBCADCCAABDBBA1234567891011121314151617181920JAWAPANBABDADADBDCCCCCADCBBA1135446102814047962056B140104013151605033410241615C108321241403251679621820D91221401617931730283319324JUMLAH2525252525252525252525252525252525252525

Sheet2NO.ABCDSOALANBIL%BIL%BIL%BIL%1141456149362135200001248352010408322844164163121456541600218400662414281664714312416176880015601493692816644163121083200001768111456520312312120000251000013416312166428147283127288321593641693631216624104062431217282828197618004161872312195201664282820624156000416

ANALISISPelajarItemSkor%12345678910111213141516171819202122232425262728293031323334353637383940PELAJAR 1111111111111111111111X1X111111111111X1113792.537PELAJAR 2111111111X1111111111111X1111111111X11X11369036PELAJAR 31111X111111111111111111X1111111X11X11111369036PELAJAR 41X11111111111111111X1XX11XX1111111111111348534PELAJAR 51111X11111111111111XX1X11XX1111111111111348534PELAJAR 61X11111X1X1111111XX111111X1111X111X11111328032PELAJAR 71X1XX11X11111111111X1XX1111111111X111111328032PELAJAR 8XX1X1111X11X111111XX11111X11111111111111328032PELAJAR 9111X1111111X1X1XXXX1111XX1111111111111113177.531PELAJAR 10111XXX111111111111111X11111111111X11XXXX3177.531PELAJAR 11111X111111111X1XXXX11111XX1111X1111111113177.531PELAJAR 121111XX111X111111111X1X11111111111X11XXXX307530PELAJAR 131111XX111111X111111X1X11111111111X11XXXX307530PELAJAR 141X1111X111111111111X1X111X1111111X1XXXX1307530PELAJAR 15111111111111X11XXX1X1X1XXX111111X1111111307530PELAJAR 1611111X1111X1X1XX1X11111X1X111X11X11111X12972.529PELAJAR 1711X111X111111X11111XXX1XXX1111XX111111112972.529PELAJAR 1811111XX11111111X11111X1X111X1X11XX1XXXX12767.527PELAJAR 19XX1111111111111X1X1XXX1X1XXX1XX11X111111266526PELAJAR 20XX1111111111111X1X1XXX1X1XXX1XX11X111X112562.525PELAJAR 211111X1X111111X1XXXX1XX1111XXX11X1X11X1112562.525PELAJAR 2211111111111111X111111X1XXXXXXXXX1X11XXX12562.525PELAJAR 231X1X1X1111111X1111XXXXX11XX11XXX1XXXXXX1205020PELAJAR 24XX1X11XX11XXX11X1X1XX11X1XXX1XX1XXX111XX1742.517PELAJAR 25111XXXX111X111XXXX111XXX1XXX1X1X1XXXXXX11742.517PELAJAR 26111XX1XXXXXXX111X11XXXXXXXX1X1X11XX1XX11164016PELAJAR 271X1XXX111XXX1X11X1XXX1XXXX1XXXX11XX1XXX11537.516PELAJAR 28X11XX11XXXXX1XX1X1XX1XXXX1XXXXXXX1X11XX11332.513PELAJAR 29XXXXXXX1XXXX11XXXXXX1XXXXX1XX1X11X1XX111123012PELAJAR 30XX1XX11XXXXXXXX1XXXXXX11XX1XXXXXX11XXXX1102510Jum. Betul23182817172122242522222224222419201820122010211320111919231917222414212416161726Bil. Jawapan Betul dalam kump. skor tinggi, NT7486588676878888876475558468887787587788Bil. Jawapan Betul dalam kump. skor rendah, NR4370244443125445243132223132321452242227IK, p0.770.600.930.570.570.700.730.800.830.730.730.730.800.730.800.630.670.600.670.400.670.330.700.430.670.370.630.630.770.630.570.730.800.470.700.800.530.530.570.87ID, D0.380.130.130.750.380.500.500.250.380.380.880.630.380.500.500.380.750.380.380.380.500.380.380.380.630.380.380.750.630.750.750.380.380.630.380.500.630.630.750.1312345678910111213141516171819202122232425262728293031323334353637383940

ikItemPengiraan IKIndeks KesukaranPengkelasan ItemBil calon jawab betul( p )Bilangan calon ambil ujian10.77Mudah20.60Sederhana sukar30.93Terlalu Mudah40.57Sederhana sukar50.57Sederhana sukar60.70Mudah70.73Mudah80.80Mudah90.83Terlalu Mudah100.73Mudah110.73Mudah120.73Mudah130.80Mudah140.73Mudah150.80Mudah160.63Sederhana sukar170.67Sederhana sukar180.60Sederhana sukar190.67Sederhana sukar200.40SukarItemPengiraan IKIndeks KesukaranPengkelasan ItemBil calon jawab betul( p )Bilangan calon ambil ujian210.67Sederhana sukar220.33Sukar230.70Mudah240.43Sederhana sukar250.67Mudah260.37Sukar270.63Mudah280.63Mudah290.77Mudah300.63Mudah310.57Sederhana sukar320.73Mudah330.80Mudah340.47Sederhana sukar350.70Mudah360.80Mudah370.53Sederhana sukar380.53Sederhana sukar390.57Sederhana sukar400.83Terlalu Mudah

idIndeks DiskriminasiPenilaian Item( D )0.38Baik0.13Kurang Baik0.13Kurang Baik0.75Sangat Baik0.38Baik0.50Sangat Baik0.50Sangat Baik0.25Sederhana Baik0.38Baik0.38Baik0.88Sangat Baik0.63Sangat Baik0.38Baik0.50Sangat Baik0.50Sangat Baik0.38Baik0.75Sangat Baik0.38Baik0.38Baik0.38Baik0.50Sangat Baik0.38Baik0.38Baik0.38Baik0.63Sangat Baik0.38Baik0.38Baik0.75Sangat Baik0.63Sangat Baik0.75Sangat Baik0.75Sangat Baik0.38Baik0.38Baik0.63Sangat Baik0.38Baik0.50Sangat Baik0.63Sangat Baik0.63Sangat Baik0.75Sangat Baik0.13Kurang Baik

Sheet6NILAI INDEKS DISKRIMINASI ( ID )PENGKELASAN ITEM0.41 1.00SANGAT BAIK0.31 0.40BAIK0.21 0.30SEDERHANA BAIK0.11 0.20KURANG BAIK0.00 0.10TIDAK BAIK

SKOR MENTAHPELAJARITEM OBJEKTIF YANG BETUL ( / 40 )MARKAH KESELURUHAN ( % )PELAJAR 13793%37PELAJAR 23690%36PELAJAR 33690%36PELAJAR 43485%34PELAJAR 53485%34PELAJAR 63280%32PELAJAR 73280%32PELAJAR 83280%32PELAJAR 93178%31PELAJAR 103178%31PELAJAR 113178%31PELAJAR 123075%30PELAJAR 133075%30PELAJAR 143075%30PELAJAR 153075%30PELAJAR 162973%29PELAJAR 172973%29PELAJAR 182768%27PELAJAR 192665%26PELAJAR 202563%25PELAJAR 212563%25PELAJAR 222563%25PELAJAR 232050%20PELAJAR 241948%17PELAJAR 251743%17PELAJAR 261640%16PELAJAR 271640%16PELAJAR 281333%13PELAJAR 291230%12PELAJAR 301025%10

Sheet3ItemIndeksPengkelasan ItemKeputusanIndeksPenilaian ItemKeputusanKesukaranDiskriminasi( p )( D )10.77MudahKekal0.38BaikKekal20.60Sederhana sukarBaiki0.13Kurang BaikBaiki30.93Terlalu MudahBaiki0.13Kurang BaikBaiki40.57Sederhana sukarKekal0.75Sangat BaikKekal50.57Sederhana sukarKekal0.38BaikKekal60.70MudahKekal0.50Sangat BaikKekal70.73MudahKekal0.50Sangat BaikKekal80.80MudahBaiki0.25Sederhana BaikBaiki90.83Terlalu MudahKekal0.38BaikKekal100.73MudahKekal0.38BaikKekal110.73MudahKekal0.88Sangat BaikKekal120.73MudahKekal0.63Sangat BaikKekal130.80MudahKekal0.38BaikKekal140.73MudahKekal0.50Sangat BaikKekal150.80MudahKekal0.50Sangat BaikKekal160.63Sederhana sukarKekal0.38BaikKekal170.67Sederhana sukarKekal0.75Sangat BaikKekal180.60Sederhana sukarKekal0.38BaikKekal190.67Sederhana sukarKekal0.38BaikKekal200.40SukarKekal0.38BaikKekal210.67Sederhana sukarKekal0.50Sangat BaikKekal220.33SukarKekal0.38BaikKekal230.70MudahKekal0.38BaikKekal240.43Sederhana sukarKekal0.38BaikKekal250.67MudahKekal0.63Sangat BaikKekal260.37SukarKekal0.38BaikKekal270.63MudahKekal0.38BaikKekal280.63MudahKekal0.75Sangat BaikKekal290.77MudahKekal0.63Sangat BaikKekal300.63MudahKekal0.75Sangat BaikKekal310.57Sederhana sukarKekal0.75Sangat BaikKekal320.73MudahKekal0.38BaikKekal330.80MudahKekal0.38BaikKekal340.47Sederhana sukarKekal0.63Sangat BaikKekal350.70MudahKekal0.38BaikKekal360.80MudahKekal0.50Sangat BaikKekal370.53Sederhana sukarKekal0.63Sangat BaikKekal380.53Sederhana sukarKekal0.63Sangat BaikKekal390.57Sederhana sukarKekal0.75Sangat BaikKekal400.83Terlalu MudahBaiki0.13Kurang BaikBaiki

Sheet4ItemIndeks DiskriminasiPenilaian Item( D )10.38Baik20.13Kurang Baik30.13Kurang Baik40.75Sangat Baik50.38Baik60.50Sangat Baik70.50Sangat Baik80.25Sederhana Baik90.38Baik100.38Baik110.88Sangat Baik120.63Sangat Baik130.38Baik140.50Sangat Baik150.50Sangat Baik160.38Baik170.75Sangat Baik180.38Baik190.38Baik200.38Baik210.50Sangat Baik220.38Baik230.38Baik240.38Baik250.63Sangat Baik260.38Baik270.38Baik280.75Sangat Baik290.63Sangat Baik300.75Sangat Baik310.75Sangat Baik320.38Baik330.38Baik340.63Sangat Baik350.38Baik360.50Sangat Baik370.63Sangat Baik380.63Sangat Baik390.75Sangat Baik400.13Kurang Baik

Sheet5ItemIndeksPengkelasan ItemIndeksPenilaian ItemKeputusanKesukaranDiskriminasi( p )( D )

Sheet7ItemIndeksPengkelasan ItemKeputusanIndeksPenilaian ItemKeputusanKesukaranDiskriminasi( p )( D )10.77MudahKekal0.38BaikKekal20.60Sederhana sukarBaiki0.13Kurang BaikBaiki30.93Terlalu MudahBaiki0.13Kurang BaikBaiki40.57Sederhana sukarKekal0.75Sangat BaikKekal50.57Sederhana sukarKekal0.38BaikKekal60.70MudahKekal0.50Sangat BaikKekal70.73MudahKekal0.50Sangat BaikKekal80.80MudahBaiki0.25Sederhana BaikBaiki90.83Terlalu MudahKekal0.38BaikKekal100.73MudahKekal0.38BaikKekal110.73MudahKekal0.88Sangat BaikKekal120.73MudahKekal0.63Sangat BaikKekal130.80MudahKekal0.38BaikKekal140.73MudahKekal0.50Sangat BaikKekal150.80MudahKekal0.50Sangat BaikKekal160.63Sederhana sukarKekal0.38BaikKekal170.67Sederhana sukarKekal0.75Sangat BaikKekal180.60Sederhana sukarKekal0.38BaikKekal190.67Sederhana sukarKekal0.38BaikKekal200.40SukarKekal0.38BaikKekal210.67Sederhana sukarKekal0.50Sangat BaikKekal220.33SukarKekal0.38BaikKekal230.70MudahKekal0.38BaikKekal240.43Sederhana sukarKekal0.38BaikKekal250.67MudahKekal0.63Sangat BaikKekal260.37SukarKekal0.38BaikKekal270.63MudahKekal0.38BaikKekal280.63MudahKekal0.33Sangat BaikKekal290.77MudahKekal0.63Sangat BaikKekal300.63MudahKekal0.75Sangat BaikKekal310.57Sederhana sukarKekal0.75Sangat BaikKekal320.73MudahKekal0.38BaikKekal330.80MudahKekal0.38BaikKekal340.47Sederhana sukarKekal0.63Sangat BaikKekal350.70MudahKekal0.38BaikKekal360.80MudahKekal0.50Sangat BaikKekal370.53Sederhana sukarKekal0.63Sangat BaikKekal380.53Sederhana sukarKekal0.63Sangat BaikKekal390.57Sederhana sukarKekal0.75Sangat BaikKekal400.83Terlalu MudahBaiki0.13Kurang BaikBaiki

MBD0009A272.unknown

MBD0009A27A.unknown

MBD0009A27E.unknown

MBD0009A280.unknown

MBD0009B14D.unknown

MBD0009A281.unknown

MBD0009A27F.unknown

MBD0009A27C.unknown

MBD0009A27D.unknown

MBD0009A27B.unknown

MBD0009A276.unknown

MBD0009A278.unknown

MBD0009A279.unknown

MBD0009A277.unknown

MBD0009A274.unknown

MBD0009A275.unknown

MBD0009A273.unknown

MBD0009A26A.unknown

MBD0009A26E.unknown

MBD0009A270.unknown

MBD0009A271.unknown

MBD0009A26F.unknown

MBD0009A26C.unknown

MBD0009A26D.unknown

MBD0009A26B.unknown

MBD0009A262.unknown

MBD0009A266.unknown

MBD0009A268.unknown

MBD0009A269.unknown

MBD0009A267.unknown

MBD0009A264.unknown

MBD0009A265.unknown

MBD0009A263.unknown

MBD0009A25E.unknown

MBD0009A260.unknown

MBD0009A261.unknown

MBD0009A25F.unknown

MBD0009A257.unknown

MBD0009A25C.unknown

MBD0009A25D.unknown

MBD0009A25A.unknown

MBD0001F7BE.unknown

MBD0009A24B.unknown

MBD0009A24A.unknown