analisis headcount 2015

3
SEKOLAH : SMK KHIR JOHARI SUNGAI SUMUN KELAS : 5 MELATI 2015 Bil NAMA + TOV OTR1 US1 OTR2 PPT OTR3 PERCUBAAN TAR TAFSIRAN GRED TOV US1 PPT PPC TAR M G M G M G M G K1 K2 M G M G K1 K2 M G M G BIL % BIL % BIL % BIL % BIL % 1 AMIERA AZIERA BT OMER 2 65 B 67 B 64 C+ 68 B 30 52 59 C 70 B+ 29 62 65 B 70 B+ CEMERLANG A+ (90-100) 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 2 SYAZA KAUTSAR BT MOHD HALIM 7 59 C 66 B 59 C 73 B+ 29 66 68 B 80 A 32 64 69 B 80 A A ( 80-89 ) 0 0.0 0 0.0 0 0.0 0 0.0 3 6.7 3 NOR SAFURA BT AZMI 5 60 C+ 65 B 60 C+ 70 B+ 27 60 62 C+ 75 A- 31 73 74 A- 75 A- A- ( 75-79 ) 0 0.0 0 0.0 0 0.0 2 4.4 9 20.0 4 KHALID SAIFULLAH BIN NORDIN 9 47 D 56 C 47 D 66 B 27 54 58 C 75 A- 27 65 66 B 75 A- KEPUJIAN B+ ( 70-74 ) 0 0.0 0 0.0 0 0.0 1 2.2 3 6.7 5 AMIRUL AZAN MORSYID BIN ARIFFIN 7 40 E 47 D 40 E 53 C 17 32 35 G 60 C+ 25 61 61 C+ 60 C+ TINGGI B ( 65-69 ) 1 2.2 0 0.0 4 8.9 7 15.6 2 4.4 6 FATIN SURAYA BINTI MESRAN 5 36 G 41 E 53 C 45 D 15 30 32 G 50 C 17 31 34 G 50 C C+ ( 60-64 ) 3 6.7 4 8.9 3 6.7 6 13.3 8 17.8 7 JAYA RAJU RAO A/L PARAMASWARAN 8 35 G 43 E 37 G 52 C 24 43 48 D 60 C+ 17 14 22 G 60 C+ LULUS C ( 50-59 ) 2 4.4 8 17.8 10 22.2 5 11.1 19 42.2 8 JOEL MESHACH A/L RICHARD 13 21 G 34 G 36 G 47 D 13 40 38 G 60 C+ 8 15 16 G 60 C+ D ( 45-49 ) 5 11.1 8 17.8 6 13.3 2 4.4 0 0.0 9 MISBAHUL MUNIR BIN MUHAMAT RAMLAN 10 26 G 36 G 40 E 45 D 12 34 33 G 55 C 18 17 25 G 55 C GAGAL E ( 40-44 ) 4 8.9 9 20.0 3 6.7 3 6.7 1 2.2 10 MOHAMAD FADHLI B MOHAMED JASNI 9 28 G 37 G 47 D 46 D 14 30 31 G 55 C 24 17 29 G 55 C G ( 0-39 30 66.7 16 35.6 19 42.2 19 42.2 0 0.0 11 MOHAMAD FAIZUL BIN MD SALEH 9 47 D 56 C 53 C 66 B 26 65 65 B 75 A- 24 73 69 B+ 75 A- JUMLAH 45 100 45 100 45 100 45 100 45 100 12 MOHAMMAD ADDY AZWAN BIN OTHMAN 9 42 E 51 C 51 C 61 C+ 20 36 40 E 70 B+ 22 50 51 C 70 B+ LULUS 15 33.3 29 64.4 26 57.8 26 57.8 45 100.0 13 MOHD RAMDZAN B MOHD NOOR 8 31 G 39 G 49 D 47 D 0 21 15 G 55 C 22 21 31 G 55 C GPMP 8.18 7.56 7.29 6.76 4.44 14 MOHD RAZIS B MOHD KASNUN 9 28 G 37 G 34 G 46 D 18 17 25 G 55 C 15 20 25 G 55 C 15 MUHAMAD FIRDAUS BIN RAMILIESE 8 31 G 39 G 36 G 47 D 14 23 26 G 55 C 25 26 36 G 55 C 16 MUHAMMAD NOOR ZIKRI BIN ABD RAZAK 6 36 G 42 E 34 G 49 D 19 43 44 D 55 C 25 40 46 D 55 C 17 MUHD IQMAL B MOHD SIDEK 9 27 G 36 G 33 G 46 D 15 18 24 G 55 C 18 31 35 G 55 C 18 NOOR FARISHA FARHANA BT MOHD ZAINI 7 49 D 56 C 49 D 63 C+ 21 49 50 C 70 B+ 25 60 61 C+ 70 B+ 19 NOORSYAFIKAH BT NOR ZAMAL 10 34 G 44 E 49 D 54 C 25 32 41 E 64 C+ 21 40 44 E 64 C+ 20 NOR HALIZA BT MARUAN 15 31 G 46 D 47 D 60 C+ 28 58 61 C+ 75 A- 25 61 61 C+ 75 A- 21 NORAINATUN NAJWA BINTI GHAZALI 11 31 G 42 E 43 E 54 C 23 34 41 E 65 B 16 48 46 D 65 B 22 NUR MARIAM BT HUSNI 13 35 G 48 D 56 C 62 C+ 29 62 65 B 75 A- 21 60 58 C 75 A- 23 NUR SAFIRA DIANA BINTI ASHA'ARI 8 17 G 25 G 30 G 32 G 11 17 20 G 40 E 13 10 16 G 40 E 24 NURUL AIDA BINTI MASIRAN 6 32 G 38 G 31 G 44 E 18 61 56 C 50 C 18 56 53 C 50 C 25 RATHNA A/P SUBRAMANIAM 13 26 G 39 G 40 E 52 C 20 60 57 C 65 B 25 56 58 C 65 B 26 SAID MOHD FIRDAUS BIN ABDULLAH 8 27 G 35 G 36 G 42 E 16 34 36 G 50 C 21 30 36 G 50 C 27 SH. FATIN AFIQAH AL-HADAD 6 36 G 42 E 30 G 49 D 16 28 31 G 55 C 16 30 33 G 55 C 28 SHARIFAH NAJIHAH 7 30 G 37 G 37 G 43 E 23 45 49 D 50 C 20 36 40 E 50 C 29 SITI NOOR ATIKA BT AHMADI 14 32 G 46 D 44 E 61 C+ 28 47 54 C 75 A- 24 63 62 C+ 75 A- 30 THANA SRI A/P MURALIDARAN 13 16 G 29 G 44 E 42 E 15 48 45 D 55 C 14 42 40 E 55 C 31 THARANI A/P LOHANATHAN 15 11 G 26 G 41 E 40 E 24 52 54 C 55 C 21 57 56 C 55 C 32 VISHALANI A/P SIVA 17 4 G 21 G 26 G 38 G 8 34 30 G 55 C 14 10 17 G 55 C 33 AMIERA AZIERA BT OMER 5 64 C+ 69 B+ 64 C+ 75 A- 30 52 59 C 80 A 29 62 65 B 80 A 34 SYAZA KAUTSAR BT MOHD HALIM 7 59 C 66 B 59 C 73 B+ 29 66 68 B 80 A 32 64 69 B 80 A 35 NOR SAFURA BT AZMI 5 60 C+ 65 B 60 C+ 70 B+ 27 60 62 C+ 75 A- 31 73 74 A- 75 A- 36 KHALID SAIFULLAH BIN NORDIN 9 47 D 56 C 47 D 66 B 27 54 58 C 75 A- 27 65 66 B 75 A- 37 AMIRUL AZAN MORSYID BIN ARIFFIN 7 40 E 47 D 40 E 53 C 17 32 35 G 60 C+ 25 61 61 C+ 60 C+ 38 FATIN SURAYA BINTI MESRAN 6 36 G 42 E 53 C 49 D 15 30 32 G 55 C 17 31 34 G 55 C 39 JAYA RAJU RAO A/L PARAMASWARAN 8 35 G 43 E 37 G 52 C 24 43 48 D 60 C+ 17 14 22 G 60 C+ 40 JOEL MESHACH A/L RICHARD 11 21 G 32 G 36 G 44 E 13 40 38 G 55 C 8 15 16 G 55 C 41 KHALID SAIFULLAH BIN NORDIN 9 47 D 56 C 47 D 66 B 27 54 58 C 75 A- 27 65 66 B 75 A- 42 AMIRUL AZAN MORSYID BIN ARIFFIN 7 40 E 47 D 40 E 53 C 17 32 35 G 60 C+ 25 61 61 C+ 60 C+ 43 FATIN SURAYA BINTI MESRAN 6 36 G 42 E 53 C 49 D 15 30 32 G 55 C 17 31 34 G 55 C 44 JAYA RAJU RAO A/L PARAMASWARAN 8 35 G 43 E 37 G 52 C 24 43 48 D 60 C+ 17 14 22 G 60 C+ 45 JOEL MESHACH A/L RICHARD 11 21 G 32 G 36 G 44 E 13 40 38 G 55 C 8 15 16 G 55 C A+ (90- 100) A ( 80- 89 ) A- ( 75- 79 ) B+ ( 70-74 ) B ( 65- 69 ) C+ ( 60-64 ) C ( 50- 59 ) D ( 45- 49 ) E ( 40- 44 ) G ( 0- 39 ) LULUS 0 0 0 0 1 3 2 5 4 30 15 0 0 0 0 0 4 8 8 9 16 29 0 0 0 0 4 3 10 6 3 19 26 0 0 2 1 7 6 5 2 3 19 26 0 3 9 3 2 8 19 0 1 0 45 ANALISIS MATA PELAJARAN GEOGRAFI 5 MELATI 2015 TOV US1 PPT PPC TAR

Upload: chan-yaw

Post on 11-Jan-2016

24 views

Category:

Documents


0 download

DESCRIPTION

pt3

TRANSCRIPT

Page 1: Analisis HeadCount 2015

SEKOLAH : SMK KHIR JOHARI SUNGAI SUMUN

KELAS : 5 MELATI 2015

Bil NAMA + TOV OTR1 US1 OTR2 PPT OTR3 PERCUBAAN TAR TAFSIRAN GRED TOV US1 PPT PPC TARM G M G M G M G K1 K2 M G M G K1 K2 M G M G BIL % BIL % BIL % BIL % BIL %

1 AMIERA AZIERA BT OMER 2 65 B 67 B 64 C+ 68 B 30 52 59 C 70 B+ 29 62 65 B 70 B+CEMERLANG

A+ (90-100) 0 0.0 0 0.0 0 0.0 0 0.0 0 0.02 SYAZA KAUTSAR BT MOHD HALIM 7 59 C 66 B 59 C 73 B+ 29 66 68 B 80 A 32 64 69 B 80 A A ( 80-89 ) 0 0.0 0 0.0 0 0.0 0 0.0 3 6.73 NOR SAFURA BT AZMI 5 60 C+ 65 B 60 C+ 70 B+ 27 60 62 C+ 75 A- 31 73 74 A- 75 A- A- ( 75-79 ) 0 0.0 0 0.0 0 0.0 2 4.4 9 20.04 KHALID SAIFULLAH BIN NORDIN 9 47 D 56 C 47 D 66 B 27 54 58 C 75 A- 27 65 66 B 75 A- KEPUJIAN B+ ( 70-74 ) 0 0.0 0 0.0 0 0.0 1 2.2 3 6.75 AMIRUL AZAN MORSYID BIN ARIFFIN 7 40 E 47 D 40 E 53 C 17 32 35 G 60 C+ 25 61 61 C+ 60 C+ TINGGI B ( 65-69 ) 1 2.2 0 0.0 4 8.9 7 15.6 2 4.46 FATIN SURAYA BINTI MESRAN 5 36 G 41 E 53 C 45 D 15 30 32 G 50 C 17 31 34 G 50 C C+ ( 60-64 ) 3 6.7 4 8.9 3 6.7 6 13.3 8 17.87 JAYA RAJU RAO A/L PARAMASWARAN 8 35 G 43 E 37 G 52 C 24 43 48 D 60 C+ 17 14 22 G 60 C+

LULUSC ( 50-59 ) 2 4.4 8 17.8 10 22.2 5 11.1 19 42.2

8 JOEL MESHACH A/L RICHARD 13 21 G 34 G 36 G 47 D 13 40 38 G 60 C+ 8 15 16 G 60 C+ D ( 45-49 ) 5 11.1 8 17.8 6 13.3 2 4.4 0 0.09 MISBAHUL MUNIR BIN MUHAMAT RAMLAN 10 26 G 36 G 40 E 45 D 12 34 33 G 55 C 18 17 25 G 55 C GAGAL E ( 40-44 ) 4 8.9 9 20.0 3 6.7 3 6.7 1 2.2

10 MOHAMAD FADHLI B MOHAMED JASNI 9 28 G 37 G 47 D 46 D 14 30 31 G 55 C 24 17 29 G 55 C G ( 0-39 ) 30 66.7 16 35.6 19 42.2 19 42.2 0 0.011 MOHAMAD FAIZUL BIN MD SALEH 9 47 D 56 C 53 C 66 B 26 65 65 B 75 A- 24 73 69 B+ 75 A- JUMLAH 45 100 45 100 45 100 45 100 45 10012 MOHAMMAD ADDY AZWAN BIN OTHMAN 9 42 E 51 C 51 C 61 C+ 20 36 40 E 70 B+ 22 50 51 C 70 B+ LULUS 15 33.3 29 64.4 26 57.8 26 57.8 45 100.013 MOHD RAMDZAN B MOHD NOOR 8 31 G 39 G 49 D 47 D 0 21 15 G 55 C 22 21 31 G 55 C GPMP 8.18 7.56 7.29 6.76 4.4414 MOHD RAZIS B MOHD KASNUN 9 28 G 37 G 34 G 46 D 18 17 25 G 55 C 15 20 25 G 55 C15 MUHAMAD FIRDAUS BIN RAMILIESE 8 31 G 39 G 36 G 47 D 14 23 26 G 55 C 25 26 36 G 55 C16 MUHAMMAD NOOR ZIKRI BIN ABD RAZAK 6 36 G 42 E 34 G 49 D 19 43 44 D 55 C 25 40 46 D 55 C17 MUHD IQMAL B MOHD SIDEK 9 27 G 36 G 33 G 46 D 15 18 24 G 55 C 18 31 35 G 55 C18 NOOR FARISHA FARHANA BT MOHD ZAINI 7 49 D 56 C 49 D 63 C+ 21 49 50 C 70 B+ 25 60 61 C+ 70 B+19 NOORSYAFIKAH BT NOR ZAMAL 10 34 G 44 E 49 D 54 C 25 32 41 E 64 C+ 21 40 44 E 64 C+20 NOR HALIZA BT MARUAN 15 31 G 46 D 47 D 60 C+ 28 58 61 C+ 75 A- 25 61 61 C+ 75 A-21 NORAINATUN NAJWA BINTI GHAZALI 11 31 G 42 E 43 E 54 C 23 34 41 E 65 B 16 48 46 D 65 B22 NUR MARIAM BT HUSNI 13 35 G 48 D 56 C 62 C+ 29 62 65 B 75 A- 21 60 58 C 75 A-23 NUR SAFIRA DIANA BINTI ASHA'ARI 8 17 G 25 G 30 G 32 G 11 17 20 G 40 E 13 10 16 G 40 E24 NURUL AIDA BINTI MASIRAN 6 32 G 38 G 31 G 44 E 18 61 56 C 50 C 18 56 53 C 50 C25 RATHNA A/P SUBRAMANIAM 13 26 G 39 G 40 E 52 C 20 60 57 C 65 B 25 56 58 C 65 B26 SAID MOHD FIRDAUS BIN ABDULLAH 8 27 G 35 G 36 G 42 E 16 34 36 G 50 C 21 30 36 G 50 C27 SH. FATIN AFIQAH AL-HADAD 6 36 G 42 E 30 G 49 D 16 28 31 G 55 C 16 30 33 G 55 C28 SHARIFAH NAJIHAH 7 30 G 37 G 37 G 43 E 23 45 49 D 50 C 20 36 40 E 50 C29 SITI NOOR ATIKA BT AHMADI 14 32 G 46 D 44 E 61 C+ 28 47 54 C 75 A- 24 63 62 C+ 75 A-30 THANA SRI A/P MURALIDARAN 13 16 G 29 G 44 E 42 E 15 48 45 D 55 C 14 42 40 E 55 C31 THARANI A/P LOHANATHAN 15 11 G 26 G 41 E 40 E 24 52 54 C 55 C 21 57 56 C 55 C32 VISHALANI A/P SIVA 17 4 G 21 G 26 G 38 G 8 34 30 G 55 C 14 10 17 G 55 C33 AMIERA AZIERA BT OMER 5 64 C+ 69 B+ 64 C+ 75 A- 30 52 59 C 80 A 29 62 65 B 80 A34 SYAZA KAUTSAR BT MOHD HALIM 7 59 C 66 B 59 C 73 B+ 29 66 68 B 80 A 32 64 69 B 80 A35 NOR SAFURA BT AZMI 5 60 C+ 65 B 60 C+ 70 B+ 27 60 62 C+ 75 A- 31 73 74 A- 75 A-36 KHALID SAIFULLAH BIN NORDIN 9 47 D 56 C 47 D 66 B 27 54 58 C 75 A- 27 65 66 B 75 A-37 AMIRUL AZAN MORSYID BIN ARIFFIN 7 40 E 47 D 40 E 53 C 17 32 35 G 60 C+ 25 61 61 C+ 60 C+38 FATIN SURAYA BINTI MESRAN 6 36 G 42 E 53 C 49 D 15 30 32 G 55 C 17 31 34 G 55 C39 JAYA RAJU RAO A/L PARAMASWARAN 8 35 G 43 E 37 G 52 C 24 43 48 D 60 C+ 17 14 22 G 60 C+40 JOEL MESHACH A/L RICHARD 11 21 G 32 G 36 G 44 E 13 40 38 G 55 C 8 15 16 G 55 C41 KHALID SAIFULLAH BIN NORDIN 9 47 D 56 C 47 D 66 B 27 54 58 C 75 A- 27 65 66 B 75 A-42 AMIRUL AZAN MORSYID BIN ARIFFIN 7 40 E 47 D 40 E 53 C 17 32 35 G 60 C+ 25 61 61 C+ 60 C+43 FATIN SURAYA BINTI MESRAN 6 36 G 42 E 53 C 49 D 15 30 32 G 55 C 17 31 34 G 55 C44 JAYA RAJU RAO A/L PARAMASWARAN 8 35 G 43 E 37 G 52 C 24 43 48 D 60 C+ 17 14 22 G 60 C+45 JOEL MESHACH A/L RICHARD 11 21 G 32 G 36 G 44 E 13 40 38 G 55 C 8 15 16 G 55 C

A+ (90-100) A ( 80-89 ) A- ( 75-79 ) B+ ( 70-74 ) B ( 65-69 ) C+ ( 60-64 ) C ( 50-59 ) D ( 45-49 ) E ( 40-44 ) G ( 0-39 ) LULUS

0 0 0 01

32

54

30

15

0 0 0 0 0

4

8 89

16

29

0 0 0 0

43

10

6

3

19

26

0 0

21

76

5

23

19

26

0

3

9

32

8

19

01

0

45

ANALISIS MATA PELAJARAN GEOGRAFI 5 MELATI 2015

TOV US1 PPT PPC TAR

Page 2: Analisis HeadCount 2015

Panduan pengunaan :

2. Ruangan yang berwarna bermaksud, data akan dikira secara automatik.3. Graf juga akan berubah mengikut data yang telah dikira secara automatik. Persembahan graf boleh diubah mengikut keperluan guru.4. Bilangan pelajar boleh ditambah sehingga maksimum 45 pelajar.

6. Gred markah yang diberi adalah berdasarkan skala di bawah.A+ (90-100)A ( 80-89 )A- ( 75-79 )B+ ( 70-74 )B ( 65-69 )C+ ( 60-64 )C ( 50-59 )D ( 45-49 )E ( 40-44 )G ( 0-39 )

7. Print dalam 'Landscape Orientation' untuk dapat semua data termasuk graf sekali.

1. Pastikan hanya mengisi markah pada ruangan yang tidak berwarna sahaja.

5. Jika jumlah pelajar hanya 20 sahaja, sila gunakan tulisan yang tidak jelas untuk selebihnya supaya tidak kelihatan masa print nanti. Lihat contoh di OT2

Formula tukar skala =IF(C6>89,"A+",IF(C6>79,"A",IF(C6>74,"A-",IF(C6>69,"B+",IF(C6>64,"B",IF(C6>59,"C+",IF(C6>49,"C",IF(C6>44,"D",IF(C6>39,"E",IF(C6>0,"G"))))))))))

8. Bahan ini dihasilkan oleh www.geoandyou.com. Hubungi kami di [email protected] jika ada pertanyaan. Terima kasih.