Borang Analisis Kehadiran Sekolah.xls
19
ANALISA KEHADIRAN MURID TAHUN 2015 SEKOLAH KOD SEKOLAH BIL. PERATUS MENGIKUT BUKU KEHADIRAN MURID JAN FEB MAC APR MEI JUN JUL OGOS SEPT OKT NOV 1 1 Z 520 19 97.7 471 18 90.2 494 18 98.0 577 22 93.7 454 17 95.4 275 11 98.2 496 18 98.4 526 20 93.9 470 17 98.7 485 18 98.4 402 15 92.4 193 532 27 522 26 504 27 616 26 476 27 280 25 504 28 560 26 476 28 493 27 435 27 2 1 N 512 19 96.2 480 18 95.2 478 18 94.8 570 22 95.0 426 17 92.8 276 11 92.9 454 18 93.4 481 20 89.1 428 17 93.2 443 18 96.5 361 15 87.4 193 532 27 504 27 504 27 600 26 459 25 297 25 486 25 540 24 459 25 459 25 413 24 3 2 Z 494 19 96.3 457 18 94.0 452 18 93.0 557 22 93.8 431 17 92.5 302 11 98.1 484 18 96.0 516 20 92.1 463 17 97.3 499 18 97.5 384 15 88.3 193 513 26 486 25 486 25 594 25 466 25 308 27 504 27 560 26 476 27 512 28 435 26 4 2 N 473 19 95.7 468 18 96.7 457 18 94.0 570 22 96.0 419 17 94.8 261 11 91.3 419 18 93.1 464 20 92.8 407 17 95.8 447 18 94.1 322 15 89.0 193 494 25 484 26 486 25 594 26 442 25 286 24 450 23 500 23 425 24 475 25 362 21 5 3 Z 647 19 97.3 622 18 96.0 625 18 96.7 742 22 96.4 588 17 97.0 389 11 98.2 614 18 94.8 647 20 89.9 573 17 93.6 619 18 95.5 494 15 90.1 193 665 34 648 35 646 35 770 34 606 35 396 35 648 34 720 32 612 34 648 34 548 33 6 3 N 561 19 97.4 564 18 95.3 564 18 94.9 730 22 96.2 534 17 95.2 334 11 94.9 535 18 92.9 588 20 91.9 474 17 92.6 548 18 95.1 430 15 91.9 193 576 30 592 31 594 31 759 33 561 31 352 30 576 30 640 29 512 28 576 30 468 29 7 4 B 643 19 97.9 630 18 97.2 619 18 95.5 760 22 96.0 598 17 97.7 381 11 96.2 608 18 93.8 666 20 92.5 588 17 96.1 630 18 97.2 515 15 95.4 193 657 34 648 35 648 34 792 35 612 35 396 35 648 34 720 33 612 35 648 35 540 34 8 4 M 570 19 94.1 539 18 93.6 539 18 92.8 663 22 94.2 494 17 90.8 316 11 89.8 576 18 90.0 539 20 86.9 460 17 87.3 558 18 91.9 465 15 89.3 193 606 30 576 30 581 30 704 30 544 29 352 29 640 32 620 27 527 27 607 31 521 31 9 5 B 620 19 96.0 556 18 90.8 579 18 94.6 719 22 96.1 556 17 96.2 352 11 96.7 558 18 93.9 568 20 86.1 539 17 96.1 571 18 96.1 454 15 91.7 193 646 33 612 31 612 32 748 33 578 33 364 32 594 31 660 28 561 32 594 32 495 30 10 5 M 565 19 99.1 513 18 97.7 478 18 96.4 640 22 93.8 519 17 96.1 304 11 95.3 434 18 93.5 528 20 91.0 481 17 97.6 509 18 97.5 419 15 96.3 193 570 30 525 29 496 27 682 29 540 31 319 28 464 24 580 26 493 28 522 28 435 28 11 6 B 489 19 99.0 431 18 97.5 458 18 97.9 567 22 99.1 429 17 97.1 272 11 95.1 379 18 95.7 395 20 89.8 370 17 99.5 393 18 99.2 363 15 96.8 193 494 26 442 24 468 25 572 26 442 25 286 25 396 21 440 20 372 22 396 22 375 24 12 6 M 386 19 96.7 390 18 98.5 382 18 96.5 465 22 96.1 362 17 96.8 236 11 97.5 379 18 95.7 464 20 92.8 409 17 96.2 442 18 98.2 323 15 97.9 193 399 20 396 22 396 21 484 21 374 21 242 21 396 21 500 23 425 24 450 25 330 22 13 KHAS 81 19 71.1 74 18 68.5 37 18 64.9 68 22 82.9 50 17 73.5 34 11 77.3 48 18 66.7 46 20 57.5 39 17 57.4 33 18 43.4 37 15 61.7 193 114 4 108 4 57 2 82 3 68 3 44 3 72 3 80 2 68 2 76 2 60 2 14 0 15 0 16 0 NAMA KELAS JUM HARI
-
Upload
samadhakim -
Category
Documents
-
view
47 -
download
4
Transcript of Borang Analisis Kehadiran Sekolah.xls
ANALISA KEHADIRAN MURID TAHUN 2015SEKOLAHKOD SEKOLAH
BIL.PERATUS MENGIKUT BUKU KEHADIRAN MURID
JAN FEB MAC APR MEI JUN JUL OGOS SEPT OKT NOV
1 1 Z520 19
97.7471 18
90.2494 18
98.0577 22
93.7454 17
95.4275 11
98.2496 18
98.4526 20
93.9470 17
98.7485 18
98.4402 15
92.4 193 95.9532 27 522 26 504 27 616 26 476 27 280 25 504 28 560 26 476 28 493 27 435 27
2 1 N512 19
96.2480 18
95.2478 18
94.8570 22
95.0426 17
92.8276 11
92.9454 18
93.4481 20
89.1428 17
93.2443 18
96.5361 15
87.4 193 93.3532 27 504 27 504 27 600 26 459 25 297 25 486 25 540 24 459 25 459 25 413 24
3 2 Z494 19
96.3457 18
94.0452 18
93.0557 22
93.8431 17
92.5302 11
98.1484 18
96.0516 20
92.1463 17
97.3499 18
97.5384 15
88.3 193 94.4513 26 486 25 486 25 594 25 466 25 308 27 504 27 560 26 476 27 512 28 435 26
4 2 N473 19
95.7468 18
96.7457 18
94.0570 22
96.0419 17
94.8261 11
91.3419 18
93.1464 20
92.8407 17
95.8447 18
94.1322 15
89.0 193 93.9494 25 484 26 486 25 594 26 442 25 286 24 450 23 500 23 425 24 475 25 362 21
5 3 Z647 19
97.3622 18
96.0625 18
96.7742 22
96.4588 17
97.0389 11
98.2614 18
94.8647 20
89.9573 17
93.6619 18
95.5494 15
90.1 193 95.1665 34 648 35 646 35 770 34 606 35 396 35 648 34 720 32 612 34 648 34 548 33
6 3 N561 19
97.4564 18
95.3564 18
94.9730 22
96.2534 17
95.2334 11
94.9535 18
92.9588 20
91.9474 17
92.6548 18
95.1430 15
91.9 193 94.4576 30 592 31 594 31 759 33 561 31 352 30 576 30 640 29 512 28 576 30 468 29
7 4 B643 19
97.9630 18
97.2619 18
95.5760 22
96.0598 17
97.7381 11
96.2608 18
93.8666 20
92.5588 17
96.1630 18
97.2515 15
95.4 193 96.0657 34 648 35 648 34 792 35 612 35 396 35 648 34 720 33 612 35 648 35 540 34
8 4 M570 19
94.1539 18
93.6539 18
92.8663 22
94.2494 17
90.8316 11
89.8576 18
90.0539 20
86.9460 17
87.3558 18
91.9465 15
89.3 193 91.0606 30 576 30 581 30 704 30 544 29 352 29 640 32 620 27 527 27 607 31 521 31
9 5 B620 19
96.0556 18
90.8579 18
94.6719 22
96.1556 17
96.2352 11
96.7558 18
93.9568 20
86.1539 17
96.1571 18
96.1454 15
91.7 193 94.0646 33 612 31 612 32 748 33 578 33 364 32 594 31 660 28 561 32 594 32 495 30
10 5 M565 19
99.1513 18
97.7478 18
96.4640 22
93.8519 17
96.1304 11
95.3434 18
93.5528 20
91.0481 17
97.6509 18
97.5419 15
96.3 193 95.9570 30 525 29 496 27 682 29 540 31 319 28 464 24 580 26 493 28 522 28 435 28
11 6 B489 19
99.0431 18
97.5458 18
97.9567 22
99.1429 17
97.1272 11
95.1379 18
95.7395 20
89.8370 17
99.5393 18
99.2363 15
96.8 193 97.0494 26 442 24 468 25 572 26 442 25 286 25 396 21 440 20 372 22 396 22 375 24
12 6 M386 19
96.7390 18
98.5382 18
96.5465 22
96.1362 17
96.8236 11
97.5379 18
95.7464 20
92.8409 17
96.2442 18
98.2323 15
97.9 193 96.6399 20 396 22 396 21 484 21 374 21 242 21 396 21 500 23 425 24 450 25 330 22
13 KHAS81 19
71.174 18
68.537 18
64.968 22
82.950 17
73.534 11
77.348 18
66.746 20
57.539 17
57.433 18
43.437 15
61.7 193 65.9114 4 108 4 57 2 82 3 68 3 44 3 72 3 80 2 68 2 76 2 60 2
14 0
15 0
16 0
NAMA KELAS
JUM HARI
PURATA KESELURUHAN
17 0
18 0
19 0
20 0
21 0
22 0
23 0
24 0
25 0
26 0
27 0
28 0
29 0
30 0
31 0
32 0
33 0
34 0
35 0
36 0
37 0
38 0
39 0
40 0
41 0
42 0
43 0
44 0
45 0
46 0
47 0
48 0
49 0
50 0
51 0
52 0
53 0
54 0
55 0
56 0
57 0
58 0
59 0
60 0
61 0
62 0
63 0
64 0
65 0
66 0
67 0
68 0
69 0
70 0
71 0
72 0
73 0
74 0
75 0
76 0
77 0
78 0
79 0
80 0
81 0
82 0
83 0
84 0
85 0
86 0
95.0 93.2 93.1 94.6 93.5 94.0 92.2 88.2 92.4 92.4 89.9 92.6
CONTOH PENGGUNAAN
Masukkan JUMLAH KEHADIRAN Masukkan HARI PERSEKOLAHAN
22 650.0
44 7
Masukkan JUMLAH KESELURUHAN PURATA BILANGAN MURID (DIKUNCI)
PURATA MENGIKUT
BULAN
PERTUS KEHADIRAN MURID MENGIKUT BULAN SETIAP KELAS (DIKUNCI)
ANALISA KEHADIRAN MURID SEKOLAHANALISA KEHADIRAN MURID TAHUN 2015
NAMA SEKOLAH 0
KOD SEKOLAH 0
BULAN JAN FEB MAC APRIL MEI JUN JULAI OGOS SEPT OKT NOV
95.0 93.2 93.1 94.6 93.5 94.0 92.2 88.2 92.4 92.4 89.9 92.6
PURATA KEHADIRAN
PERATUS KEHADIRAN
JAN
FEB
MAC
APRILM
EIJU
NJU
LAI
OGOSSE
PTOKT
NOV
PURATA KEHADIRAN82.0
84.0
86.0
88.0
90.0
92.0
94.0
96.0
98.0
100.0
JAN
FEB
MAC
APRILM
EIJU
NJU
LAI
OGOSSE
PTOKT
NOV
PURATA KEHADIRAN82.0
84.0
86.0
88.0
90.0
92.0
94.0
96.0
98.0
100.0
BORANG P1BORANG ANALISIS SALAHLAKU PONTENG 2015
Nama Sekolah : 0Kod Sekolah : 0
BULAN 2013 JAN FEB MAC APR MEI JUN JUL OGOS SEPT OKT NOV PURATA KESELURUHAN
Enrolem Murid 442 367 358 358 358 358 358 356 356 356 356 356 358
95.0 93.2 93.1 94.6 93.5 94.0 92.2 88.2 92.4 92.4 89.9 92.6
1 1
#DIV/0!
#DIV/0!
#DIV/0!
PERBANDINGAN KES PONTENG 2014
BIL
BILANGAN DAN PERATUS (%) MURID YANG TERLIBAT
JAN FEB MAC APR MEI JUN JUL OGOS SEPT OKT NOV 2014 2013 BEZA (+/-)
BIL % BIL % BIL % BIL % BIL % BIL % BIL % BIL % BIL % BIL % BIL % BIL % BIL % BIL %
0.01%1 0 0.0 0 0.0 0 0.0 1 0.3 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 10.28
00.00 -1 0.28
367 358 358 358 358 358 356 356 356 356 356 358 442
Disahkan oleh :
Peratus (%) Kehadiran KeseluruhanBilangan Murid Ponteng Sekolah
Bilangan Murid Digantung Sekolah
Bilangan Murid Dibuang Sekolah
Bilangan Murid Keciciran
JENIS SALAH LAKU
KPI KPM
PONTENG SEKOLAH
BIL. MURID KESELURUHAN
KIRA PERATUS SALAHLAKU1 0.276243 MAC3 0.828729 JAN
000000
KIR
