Spreadsheet: 358967d1416029371-student-ranking-based-on-pass-or-fail-and-average-grade-multiple-condition-class-a-1-
Sheet: exam marksheet

 |  |  |  |  |  |  |  |  | * TH - TIDAK HADIR |  |  |  |  |  | * TK - TERKECUALI
 | NO. | ID NO. | STUDENTS NAME | GENDER | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL MARKS | PERCENTAGE | AVERAGE GRADE | PASS / FAIL | CLASS RANKING | CLASS BATCH RANKING | ACHIEVEMENT
 |  |  |  |  | BAHASA MELAYU | GRADE | BAHASA INGGERIS | GRADE | MATEMATIK | GRADE | SAINS | GRADE | SEJARAH | GRADE | GEOGRAFI | GRADE | KEMAHIRAN HIDUP 2 - ERT | GRADE | KEMAHIRAN HIDUP 3 - PERTANIAN | GRADE | PENDIDIKAN SENI VISUAL | GRADE | PENDIDIKAN SIVIK DAN KEWARGANEGARAAN | GRADE | PENDIDIKAN JASMANI | GRADE | PENDIDIKAN ISLAM | GRADE | BAHASA TAMIL | GRADE | PENDIDIKAN MORAL | GRADE
 | 1 | [PHONE] | AJAYKUMAR A/L RAVINDRAN | L | 80 | A | 65 | B | 80 | A | 75 | B | 56 | C | 89 | A | TK | - | 6 | E | 76 | B | 66 | B | 40 | D | TK | - | 60 | C | 64 | C | 757 | 63.08 | 2.42 | PASS | 1 |  | 3 [ A ]  4 [ B ]  3 [ C ]   1 [ D ]  1 [ E ]
 | 2 |  | ALWI BIN ABDULLAH | L | 60 | B | 56 | C | 66 | B | 80 | A | 56 | C | 80 | A | TK | - | 80 | A | 56 | C | 33 | E | 90 | A | 93 | A | TK | - | TK | - | 750 | 68.18 | 2.09 | PASS | 2 |  | 5 [ A ]  2 [ B ]  3 [ C ]   0 [ D ]  1 [ E ]
 | 3 | [PHONE] | CHRISTHOPER A/L RAYAPPAN | L | 67 | B | 5 | E | 56 | C | 65 | B | 43 | C | 78 | B | 60 | C | TK | - | 88 | A | 76 | B | 77 | B | TK | - | 89 | A | 70 | B | 774 | 64.5 | 2.33 | FAIL | 5 |  | 2 [ A ]  6 [ B ]  3 [ C ]   0 [ D ]  1 [ E ]
 | 4 | [PHONE] | DANABAL A/L MURUGIAH | L | 76 | B | 57 | C | 78 | B | 88 | A | 87 | A | 90 | A | 34 | E | TK | - | 78 | B | 88 | A | 90 | A | TK | - | 98 | A | 65 | B | 929 | 77.42 | 1.83 | PASS | 3 |  | 6 [ A ]  4 [ B ]  1 [ C ]   0 [ D ]  1 [ E ]
 | 5 | [PHONE] | DURGA SRI A/P KALITHASAN | P | 33 | D | 22 | E | 65 | B | 45 | C | 60 | C | 50 | C | 53 | C | TK | - | 77 | B | 50 | C | 78 | B | TK | - | 80 | A | 66 | B | 679 | 56.58 | 2.75 | FAIL | 4 |  | 1 [ A ]  4 [ B ]  5 [ C ]   1 [ D ]  1 [ E ]
 | 6 | 011686QA | GANESH KUMAR A/L RAMASAMI | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 7 | [PHONE] | [NAME] | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 8 | [PHONE] | HARIHARAN NAIR A/L GANAPATHY NAIR | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 9 | [PHONE] | [NAME] | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 10 | [PHONE] | KALAIVAANI  A/P TAMIL MARAN | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 11 | [PHONE] | LOSINI A/P MURUGGAM | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 12 | AU62751 | MUHAMMAD ADAM HAIQAL BIN NOOR IZAM | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 14 | [PHONE] | MUHAMMAD AIMAN BIN KAMARUDIN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 20 | [PHONE] | MUHAMMAD AKIF BIN KAMARUDIN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 24 | [PHONE] | MUHAMMAD AMMAR [NAME] KASIM | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 25 | [PHONE] | MUHAMMAD HAFIS BIN ABDULLAH | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 26 | [PHONE] | MUHAMMAD NUR ISHRAF EZZRAL B MAT ZEHAN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 27 | [PHONE] | MUHAMMAD NURSYAFIQ FIRDAUS B. SAMSUDIN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 28 | [PHONE] | MUHAMMAD SHAHRUL FIKRI BIN MAT TARMIDZI | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 29 | BN43539 | MUHAMMAD SYAFIQ | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 30 | [PHONE] | NAVHIN A/L NEDUJELIAN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 31 | [PHONE] | NISHANTHINI A/P MATHURAIVEERAN | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 32 | [PHONE] | NITHESWER A/L VENUGOPAL | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 33 | AM36700 | PARTHEBAN A/L GANASON | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 34 | [PHONE] | PONASWARI | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 35 | [PHONE] | RASHINI A/P AHILAN | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 36 | [PHONE] | RAVIKUMAR A/L KRISHNAN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 37 | [PHONE] | SARIDHARAN A/L PUVANESVARAN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 38 | [PHONE] | SARVIN A/L SOMAYAH | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 39 | [PHONE] | SHAZWAN AIMAN BIN SHAHIZAL | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 40 | AS14101 | SURIA KUMAR A/L SELVANDRAN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 41 | [PHONE] | THANGARAAJ A/L ANANDAN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 42 | [PHONE] | VICHALI A/P IRASAN | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 43 | [PHONE] | VIENITH A/L M KRISHNAMOORTHY | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 44 | [PHONE] | WAN MOHAMAD SHAHARUDDIN BIN WAN MOHD MARZUKI | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 45 | [PHONE] | YUGENDRAN A/L RAMACHANDRAN | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 46 | 46 | AT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 47 | 47 | AU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 48 | 48 | AV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 49 | 49 | AW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 | 50 | 50 | AX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | PASS | 6 |  | 0 [ A ]  0 [ B ]  0 [ C ]   0 [ D ]  0 [ E ]
 |  |  |  | L
 |  |  |  | P