Sheet1ANALISIS ITEM SUBJEKTIFEXCEL 1 SEKTOR PENGURUSAN AKADEMIK, JABATAN PELAJARAN SABAHEXCEL ( I ) TAHUN/TINGKATAN ( 4 ) 2009 ( UPSR/PMR/SPM/STPM 2010)Mata Pelajaran : Bahasa MelayuFizikKod Kertas:4531/2, 4531/3PPD:PAPARNo. ItemA1A2A3A4A5A6A7A8B9B10C11C12A1A2B3B4Kod SekolahNama SekolahNama GuruMarkah Penuh56767108112020202016121212No. Urutan MuridMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah CalonXEE4239SMK MAJAKIRFenella133111422431013XEE4239SMK MAJAKIRFenella23112122254823XEE4239SMK MAJAKIRFenella33211122301813XEE4239SMK MAJAKIRFenella42110010233621XEE4239SMK MAJAKIRFenella5201012330611XEE4239SMK MAJAKIRFenella6320022121222401XEE4239SMK MAJAKIRFenella731121324341235XEE4239SMK MAJAKIRFenella822110226311011XEE4239SMK MAJAKIRFenella93311123225521XEE4239SMK MAJAKIRFenella103111173310921XEE4239SMK MAJAKIRFenella11210113332122701XEE4239SMK MAJAKIRFenella1221001332014701XEE4239SMK MAJAKIRFenella1333012223301021XEE4239SMK MAJAKIRFenella141121030102711XEE4239SMK MAJAKIRFenella151000020121310XEE4239SMK MAJAKIRFenella16330014421112XEE4239SMK MAJAKIRFenella173011123311711XEE4239SMK MAJAKIRFenella183500110322721XEE4239SMK MAJAKIRFenella1934011401126914XEE4239SMK MAJAKIRFenella202002011332822XEE4239SMK MAJAKIRFenella213001051113911XEE4239SMK MAJAKIRFenella2233111431381041XEE4239SMK MAJAKIRFenella233530133033711XEE4239SMK MAJAKIRFenella2434112313471035XEE4239SMK MAJAKIRFenella253221223451452XEE4239SMK MAJAKIRFenella2641022223251041XEE4239SMK MAJAKIRFenella272210235321711XEE4239SMK MAJAKIRFenella282220154236822JUM.CALON2828282828282828201220828281018JUM.SKOR735322222879586834327011209472028MIN SKOR2.61.90.80.81.02.82.12.41.72.73.51.47.51.72.01.6Indeks Kesukaran0.50.30.10.10.10.30.30.20.10.10.20.10.50.10.20.1Tahap KesukaranSEDERHANASEDERHANAsukarsukarsukarsukarsukarsukarsukarsukarsukarsukarSEDERHANAsukarsukarsukarMARKAHTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURANTABURAN00.00%17.86%39.29%35.71%21.43%0.00%17.86%3.57%20.00%0.00%0.00%25.00%0.00%10.71%0.00%5.56%17.14%28.57%46.43%50.00%57.14%10.71%14.29%17.86%25.00%25.00%20.00%25.00%3.57%42.86%60.00%61.11%228.57%21.43%10.71%14.29%21.43%39.29%25.00%28.57%25.00%25.00%20.00%37.50%0.00%28.57%10.00%16.67%350.00%17.86%3.57%0.00%0.00%25.00%32.14%39.29%25.00%25.00%15.00%12.50%3.57%7.14%10.00%11.11%43.57%7.14%0.00%0.00%0.00%14.29%7.14%7.14%5.00%8.33%15.00%0.00%7.14%7.14%10.00%0.00%50.00%7.14%0.00%0.00%0.00%7.14%3.57%0.00%0.00%16.67%10.00%0.00%3.57%3.57%10.00%5.56%60.00%0.00%0.00%0.00%0.00%0.00%0.00%3.57%0.00%0.00%10.00%0.00%7.14%0.00%0.00%0.00%70.00%0.00%0.00%0.00%0.00%3.57%0.00%0.00%0.00%0.00%5.00%0.00%25.00%0.00%0.00%0.00%80.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%5.00%0.00%14.29%0.00%0.00%0.00%90.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%10.71%0.00%0.00%0.00%100.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%21.43%0.00%0.00%0.00%110.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%120.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%3.57%0.00%0.00%0.00%130.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%140.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%150.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%160.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%170.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%180.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%190.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%200.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%210.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%220.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%230.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%240.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%250.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%260.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%270.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%280.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%290.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%300.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%310.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%320.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%330.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%340.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%350.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%360.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%370.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%380.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%390.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%400.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%410.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%420.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%430.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%440.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%450.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%460.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%470.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%480.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%490.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%500.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%Catatan:Tidak perlu mengisi sebarang data di column warna kelabu

Analisis markah ujian daripada 0 markah sehingga markah penuh, dan taburan (%) murid-murid yang mendapat sesuatu markah bagi sesuatu item. eg: Dalam BM K.2 seramai 17.14% daripada 35 murid mendapat 2 markah bagi item A i,37.14% daripada 35 murid mendapat 2 markah bagi item A ii, 14.29% daripada 35 murid mendapat 2 markah bagi item B0% daripada 35 murid mendapat 2 markah bagi item C37.14% daripada 35 murid mendapat 2 markah bagi item DAnalisis Data termasuk:i. Jumlah calon: jumlah murid yang mengambil ujianii. Jumlah skor: semua murid yang mengambil ujianiii. Min skor: purata skor bagi setiap calon/muridiv.Indeks kesukaran: di antara 0 - 1 v. Tahap kesukaran: Sukar, Sederhana dan Mudah

Sheet20sukar0.3SEDERHANA0.8mudah

Sheet3