jsu ms excel

2
JADUAL: MURID TAHUN 5J YANG MENJAWAB ITEM-ITEM DENGAN BETUL CALON ITEM/SOALAN JUMLAH 1 2 3 4 5 6 7 8 1! 11 12 13 14 15 16 17 18 1 2! U BU SHUO HANG 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20 CELESTE THAI YEE HUI 1 1 1 1 1 1 1 1 1 1 1 1 1 1 14 CHAN CHIN MEN 1 1 1 1 1 1 1 1 1 1 1 1 1 1 14 CHAN PUI YIH 1 1 1 1 1 1 1 1 1 1 1 1 1 1 14 CHAT WEI JIAN 1 1 1 1 1 1 1 1 1 1 1 1 1 13 CHIAH JIA HAO 1 1 1 1 1 1 1 1 1 1 1 1 1 1 14 CHONG CHI EE 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 CHONG JUN KEAT 1 1 1 1 1 1 1 1 1 1 1 1 1 1 14 CHUA YEE HAN 1 1 1 1 1 1 1 1 1 1 1 1 1 13 EEI JIA JIET 1 1 1 1 1 5 KUAN YONG JIN 1 1 1 1 1 1 6 LEE LAI JEAN 1 1 1 1 1 1 1 1 1 9 LIAU SHIN SHIH 1 1 1 1 1 1 6 LIAW WEN BIN 1 1 1 1 1 1 1 7 LIM SONG WING 1 1 1 1 1 1 1 1 1 1 10 LIM YI SIONG 1 1 1 1 1 1 6 NG CHONG KAI 1 1 1 1 1 1 1 1 8 NYU JUN VEI 1 1 1 1 1 1 1 1 1 1 1 11 L NYU JUN YI 1 1 1 1 1 5 NYU IAO WEN 1 1 2 O JUN HAO 1 1 1 1 4 OH PEI JING 1 1 1 1 4 PAH !I IAN 1 1 1 1 4 SHEE JIA MIN 1 1 1 1 1 1 6 SOH HONG !HENG 1 1 1 1 1 1 6 TAM WEN WEI 1 1 1 1 1 5 U" 15 18 17 17 8 8 16 16 6 8 10 8 8 12 8 5 8 7 5 3 L" 3 3 4 5 1 0 3 2 1 1 1 1 3 2 1 1 2 1 1 0 U" # L" 18 21 21 22 9 8 19 18 7 9 11 9 11 14 9 6 10 8 6 3 U" - L" 12 15 13 12 7 8 13 14 5 7 9 7 5 10 7 4 6 6 4 3 p 1"13 1"31 1"31 1"38 0"56 0"50 1"19 1"13 0"44 0"56 0"69 0"56 0"69 0"88 0"56 0"38 0"63 0"50 0"38 0"19 D 1"5 1"88 1"63 1"5 0"88 1 1"63 1"75 0"63 0"88 1"13 0"88 0"63 1"25 0"88 0"5 0"75 0"75 0"5 0"38 U # K$%&$'() T*+(,(- L # K$%&$'() T*+*).(/ U+ # B '() () (' ) .('(% $%&$'() ,*+(,(- () %*% *+ ( (&() *,$' L+ # B '() () (' ) .('(% $%&$'() +*).(/ () %*% *+ ( (&() *,$' # I).* - - + % )(- p # I).* - K*-$ (+()

Upload: jia-le

Post on 05-Oct-2015

39 views

Category:

Documents


0 download

DESCRIPTION

Jsu Ms Excel

TRANSCRIPT

Sheet1JADUAL: MURID TAHUN 5J YANG MENJAWAB ITEM-ITEM DENGAN BETULCALONITEM/SOALANJUMLAH1234567891011121314151617181920UBU SHUO HANG1111111111111111111120CELESTE THAI YEE HUI1111111111111114CHAN CHIN MEN1111111111111114CHAN PUI YIH1111111111111114CHAT WEI JIAN111111111111113CHIAH JIA HAO1111111111111114CHONG CHI EE11111111111111115CHONG JUN KEAT1111111111111114CHUA YEE HAN111111111111113EEI JIA JIET111115KUAN YONG JIN1111116LEE LAI JEAN1111111119LIAU SHIN SHIH1111116LIAW WEN BIN11111117LIM SONG WING111111111110LIM YI SIONG1111116NG CHONG KAI111111118NYU JUN VEI1111111111111LNYU JUN YI111115NYU QIAO WEN112O JUN HAO11114OH PEI JING11114PAH ZI QIAN11114SHEE JIA MIN1111116SOH HONG ZHENG1111116TAM WEN WEI111115Ur1518171788161668108812858753Lr33451032111132112110Ur + Lr182121229819187911911149610863Ur - Lr121513127813145797510746643p1.131.311.311.380.560.501.191.130.440.560.690.560.690.880.560.380.630.500.380.19D1.51.8751.6251.50.87511.6251.750.6250.8751.1250.8750.6251.250.8750.50.750.750.50.375U = Kumpulan TeratasL = Kumpulan TerendahUr = Bilangan calon dalam kumpulan teratas yang memberi jawapan betulLr = Bilangan calon dalam kumpulan rendah yang memberi jawapan betulp = Indeks KesukaranD = Indeks Diskriminasi

Sheet2

Sheet3