semakan register apr 2015 smkbs2

6
SMK TAMAN BUKIT SENTOSA 2 BUKIT SENTOSA 48300, RAWANG ENROLMEN DAN KEDATANGAN PELAJAR BAGI BULAN Apr-15 SEPERTI PADA 2 MEI 2015 Bangsa Melayu Cina India Lain-Lain Warga Asing Jumlah Jumlah Jantina L P L P L P L P L P L P Tingkatan PPKI KS1 4 2 0 0 1 0 0 0 0 0 5 2 7 PPKI KS2 5 0 0 0 0 1 0 0 0 0 5 1 6 PPKI KS3 3 1 0 0 0 0 0 0 0 0 3 1 4 PPKI KS4 2 3 0 0 0 0 0 0 0 0 2 3 5 Jumlah 14 6 0 0 1 1 0 0 0 0 15 7 22 Jumlah Tingkatan 1 1 IKHLAS 12 15 0 0 2 0 0 0 0 0 14 15 29 1 AMANAH 10 22 0 0 0 1 0 0 0 0 10 23 33 1 JUJUR 12 23 0 0 1 0 0 0 0 0 13 23 36 1 ADIL 16 19 0 0 0 1 0 0 0 0 16 20 36 1 BIJAKSANA 18 18 0 0 1 1 0 0 0 0 19 19 38 1 TEKUN 21 16 0 0 0 1 0 0 0 0 21 17 38 1 PENYAYANG 19 17 0 0 1 1 0 0 0 0 20 18 38 1 DINAMIK 17 16 0 0 3 1 0 0 0 0 20 17 37 1 ILTIZAM 17 17 0 0 1 0 0 0 0 0 18 17 35 1 USAHA 23 11 0 0 2 1 0 0 0 0 25 12 37 Jumlah 165 174 0 0 11 7 0 0 0 0 176 181 357 Tingkatan 2 2 IKHLAS 12 13 0 1 2 0 0 0 0 0 14 14 28 2 AMANAH 14 14 1 0 1 0 0 0 0 0 16 14 30 2 JUJUR 15 15 0 0 0 0 0 0 0 0 15 15 30 2 ADIL 15 17 1 1 1 0 0 0 0 0 17 18 35 2 BIJAKSANA 20 18 0 0 0 0 0 0 0 0 20 18 38 2 TEKUN 12 21 0 0 0 0 0 0 0 0 12 21 33 2 PENYAYANG 21 20 1 0 0 0 0 0 0 0 22 20 42 2 DINAMIK 19 18 1 0 3 0 0 0 0 0 23 18 41 2 ILTIZAM 20 16 0 0 0 3 0 0 0 0 20 19 39

Upload: chezdin

Post on 14-Sep-2015

28 views

Category:

Documents


5 download

DESCRIPTION

Contoh borang semakan jadual kedatangan pelajar setiap bulan

TRANSCRIPT

Sheet1SMK TAMAN BUKIT SENTOSA 2BUKIT SENTOSA48300, RAWANGENROLMEN DAN KEDATANGAN PELAJAR BAGI BULAN Apr-15SEPERTI PADA 2 MEI 2015BangsaMelayuCinaIndiaLain-LainWarga AsingJumlahJumlah% KehadiranJantinaLPLPLPLPLPLPTingkatanPPKI KS142001000005271173415115115477.48PPKI KS25000010000516755713213213256.82PPKI KS33100000000314701888888879.55254610183564PPKI KS42300000000235684211011011061.82254610183564Jumlah146001100001572233015148148148468.610Jumlah0Tingkatan 101 IKHLAS1215002000001415296132563863863896.0855323905922\1 AMANAH1022000100001023337012572672672696.56\1 JUJUR1223001000001323367353877377379295.0861356346769\1 ADIL1619000100001620367345879279279292.68624871269601 BIJAKSANA1818001100001919387762780380383696.64607310367109\1 TEKUN2116000100002117387923983183183695.31592511497074\1 PENYAYANG1917001100002018387408382382383689.915827112369501 DINAMIK17160031000020173770310881181181486.686028109871261 ILTIZAM17170010000018173566610477077077086.49468\1 USAHA23110021000025123768612881481481484.28606911397208051611916707709401051045Jumlah165174001170000176181357714663577817781785491.8488213410160Tingkatan 202 IKHLAS1213012000001414285803661661661694.16693938773262 AMANAH1414101000001614306402066066066096.9762546716925\2 JUJUR1515000000001515306006066066066090.91587195568262 ADIL1517111000001718357007077077077090.91463983654732 BIJAKSANA2018000000002018387568083683683690.43299177567662 TEKUN1221000000001221336458172672672688.84595876667242 PENYAYANG2120100000002220425556361861892489.81558513456930\\2 DINAMIK1918103000002318417969489089090289.44506112346295\\2 ILTIZAM20160003000020193974611285885885886.955492138568772 USAHA19190011000020204065321987287288074.89439014145804012964890Jumlah16717142840000179177356667183575067506783288.880Tingkatan 303 IKHLAS1026001300001129406611968068088097.21479874655443 AMANAH2018002000002218408522888088088096.82543680862363 JUJUR286001000002963566410176576577086.80458272852583 ADIL1221011300001325387983883683683695.45491276856803 BIJAKSANA1921001000002021418168690290290290.47502073357533 TEKUN21170020000023174073114988088088083.074946100059463 PENYAYANG1526002000001726438569094694694690.494996107660723 DINAMIK1820100200001922418455790290290293.684968132462923 ILTIZAM18170006000018234175614189789790284.284710155962283 USAHA14161043000019193866716983683683679.78471015596228\Jumlah1751882114170000191206397764687885248524873489.700Tingkatan 404 IKHLAS7600420000118193742539939941893.73473151152424 AMANAH92300000000923326673770470470494.74478558453694 JUJUR1518202100001919387766083683683692.824 ADIL1622002100001823418604290290290295.34333544937844 BIJAKSANA1122001200001224367434979279279293.81557398065564 TEKUN15180012000016203665713579279279282.95483411726006\4 PENYAYANG15161020000018163444910755655674880.765186137065564 DINAMIK1680002000016102645913959859857276.76242713833810\\4 ILTIZAM22120022000024143862119281381383676.384 USAHA180004000002202230615145745748466.96Jumlah1441453018120000165157322591293768496849708486.320Tingkatan 5021340765 IKHLAS6181011000081927589559459459499.16354421837625 AMANAH1418010100001420347272174874874897.193780281140615 JUJUR1221201000001521367484479279279294.4458837996662\\5 ADIL1423000100001424387824983183183694.104929132761565 BIJAKSANA20180000000020183871911683583583686.114970118961595 TEKUN1422002100001623397797985885885890.79231483831525 PENYAYANG21180020000023184179011290290290287.58416018436003\\\5 DINAMIK24140020000026144063422686086088073.724160184360035 ILTIZAM2590012000026113749825875675681465.875 USAHA1590041000019102944019863863863868.97Jumlah16517031137000018117835967061108781414482789885.82Jumlah Besar83085412465480000907906181334411454438955314503988688.34Peratus Kedatangan = 88.3488.335258631811.6647413682Hitung Panjang Kedatangan 31283128.272727272722678150367285282Jumlah Besar181379.493623852917.6551622605

Sheet2

Sheet3