5analisis item sub

Upload: mohdtashrif

Post on 18-Jan-2016

252 views

Category:

Documents


0 download

TRANSCRIPT

Sheet1ANALISIS ITEM SUBJEKTIFEXCEL SEKTOR PENGURUSAN AKADEMIK, JABATAN PELAJARAN SABAHEXCEL ( ) TAHUN/TINGKATAN ( ) 2010 ( UPSR/PMR/SPM/STPM )Mata Pelajaran :Kod Kertas:PPD: NAMA SEKOLAH:No. ItemABCDEJumlah MarkahPeratusKod SekolahNama KelasNama GuruNo. urutan muridSkema Permarkahan10302060Nama MuridMarkah CalonMarkah CalonMarkah CalonMarkah CalonMarkah Calon1520103558.321020154575.03520174270.048182643.357192643.36558.376610.087711.79111.710111.711111.712111.713111.714111.715111118.316111.71700.018101016.71900.020111118.32100.02200.02300.02400.02500.02600.02700.02800.02900.03000.03100.03200.03300.03400.035000.036000.037000.038000.03900.04000.04100.04200.04300.04400.04500.04600.04700.04800.04900.05000.05100.05200.05300.05400.05510203040100166.7561121321.7571100011220.058112221728.359111118.36000.000.000.000.0JUM.CALON276832JUM.SKOR14682111423MIN SKOR5.413.713.914.01.5Indeks Kesukaran murid0.50.50.70.00.0Tahap Kesukaran muridSEDERHANASEDERHANASEDERHANA0.00.0JSU EXCELNo. ItemABCDEMARKAHTABURANTABURANTABURANTABURANTABURAN014.81%16.67%12.50%33.33%0.00%125.93%0.00%0.00%0.00%0.00%20.00%16.67%12.50%0.00%0.00%30.00%0.00%0.00%0.00%0.00%40.00%0.00%0.00%0.00%0.00%511.11%0.00%0.00%0.00%0.00%63.70%0.00%0.00%0.00%0.00%77.41%0.00%0.00%0.00%0.00%83.70%0.00%0.00%0.00%0.00%90.00%0.00%0.00%0.00%0.00%1011.11%0.00%12.50%0.00%0.00%110.00%0.00%0.00%0.00%0.00%120.00%0.00%0.00%0.00%0.00%130.00%0.00%0.00%0.00%0.00%140.00%0.00%0.00%0.00%0.00%150.00%0.00%12.50%0.00%0.00%160.00%0.00%0.00%0.00%0.00%170.00%0.00%12.50%0.00%0.00%180.00%0.00%12.50%0.00%0.00%190.00%0.00%12.50%0.00%0.00%200.00%66.67%0.00%0.00%0.00%210.00%0.00%0.00%0.00%0.00%220.00%0.00%0.00%0.00%0.00%230.00%0.00%0.00%0.00%0.00%240.00%0.00%0.00%0.00%0.00%250.00%0.00%0.00%0.00%0.00%260.00%0.00%0.00%0.00%0.00%270.00%0.00%0.00%0.00%0.00%280.00%0.00%0.00%0.00%0.00%290.00%0.00%0.00%0.00%0.00%300.00%0.00%0.00%0.00%0.00%

Sheet20sukar0.3SEDERHANA0.7mudah

Sheet3