Spreadsheet: 807370d1669873545-formular-for-analyze-best-and-weak-students-grades-and-ranks-bvj-issa-
Sheet: MAIN SHEET

NO | CANDIDATE NAME | SEX M=1 F=2 | WARD | SCHOOL | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | % OF PERFORMANCE | GRADE
 |  |  |  |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI &TEKNOLOJIA |  | M/JAMII & STADI ZA KAZI |  | URAIA NA MAADILI |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D |  |  |  |  |  | overall rank | rank of mens points | rank of womens points | top five overall | bottom five overall | top five men | bottom five men | top five women | bottom five women
 | BONIFAS MATHAYO TOIYEI | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 |  | A
bens test | CHIRISTOPHER ABRAHAMU SANANGA | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 |  | A
 | DAUDI [NAME] | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 4 | E | 50 | A | 304 | 43.42857142857143 |  | A
 | ELIA MESHACK  NGAIMEREKI | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 23 | C | 25 | C | 4 | E | 22 | C | 224 | 32 |  | B
 | ELIA NEMUGOYO LEPERI | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 19 | D | 25 | C | 4 | E | 28 | C | 226 | 32.28571428571428 |  | B
 | EZEKIEL NAIGISA ROINE | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 15 | D | 20 | D | 4 | E | 27 | C | 216 | 30.85714285714286 |  | B
 | EZEKIEL NOAH OLOIBONI | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 21 | C | 11 | D | 4 | E | 10 | E | 196 | 28 |  | C
 | GREYSON AYUBU IDDY | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 37 | B | 32 | B | 4 | E | 27 | C | 250 | 35.71428571428572 |  | B
 | [NAME] LENG'ATA | 1 | KINUA | NAMELOCK | 39 | B | 27 | C | 32 | B | 29 | C | 34 | B | 2 | E | 33 | B | 196 | 28 |  | C
 | DANIEL MWEHE PAULO | 1 | KINUA | NAMELOCK | 21 | C | 13 | D | 14 | D | 16 | D | 21 | C | 2 | E | 12 | D | 99 | 14.14285714285714 |  | D
 | [NAME] | 1 | KINUA | NAMELOCK | 21 | C | 17 | D | 16 | D | 18 | D | 21 | C | 2 | E | 13 | D | 108 | 15.42857142857143 |  | D
 | FARAJA SIMON YOHANA | 1 | KINUA | NAMELOCK | 31 | B | 33 | B | 30 | C | 27 | C | 30 | C | 2 | E | 35 | B | 188 | 26.85714285714286 |  | C
 | FESTO ASSA MFUNDO | 1 | KINUA | NAMELOCK | 38 | B | 21 | C | 34 | B | 31 | B | 33 | B | 2 | E | 36 | B | 195 | 27.85714285714286 |  | C
 | IDDI ATHUMANI ALLY | 1 | KINUA | NAMELOCK | 33 | B | 15 | D | 25 | C | 25 | C | 29 | C | 2 | E | 31 | B | 160 | 22.85714285714286 |  | C
 | ISACK TIMOTHEO MBEGA | 1 | KINUA | NAMELOCK | 36 | B | 24 | C | 21 | C | 20 | D | 29 | C | 2 | E | 28 | C | 160 | 22.85714285714286 |  | C
 | ISAYA BENARD YOHANA | 1 | KINUA | NAMELOCK | 29 | C | 16 | D | 27 | C | 26 | C | 20 | D | 2 | E | 23 | C | 143 | 20.42857142857143 |  | D
 | LUTTA ROJA NIKOLAS | 1 | KINUA | NAMELOCK | 23 | C | 17 | D | 18 | D | 19 | D | 21 | C | 2 | E | 24 | C | 124 | 17.71428571428572 |  | D
 | MAINGWA LARADAI LEKIRIAMA | 1 | KINUA | NAMELOCK | 21 | C | 11 | D | 19 | D | 19 | D | 16 | D | 2 | E | 18 | D | 106 | 15.14285714285714 |  | D
 | NURUDINI ATHUMANI HASSANI | 1 | KINUA | NAMELOCK | 34 | B | 15 | D | 24 | C | 26 | C | 26 | C | 2 | E | 26 | C | 153 | 21.85714285714286 |  | C
 | ENJO DICKSON LENGARWA | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 29 | C | 28 | C | 2 | E | 38 | B | 245 | 40.83333333333334 |  | A
 | ENJO STANLEY MAJENDI | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 38 | B | 36 | B | 4 | E | 27 | C | 251 | 41.83333333333334 |  | A
 | GRACE LAMECK MOKIWA | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 26 | C | 10 | E | 3 | E | 9 | E | 195 | 32.5 |  | B
 | HALIMA MAULIDI RAMADHANI | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 29 | C | 30 | C | 6 | E | 28 | C | 237 | 39.5 |  | B
 | HAPPYNESS LOSERIAN ROINE | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 21 | C | 15 | D | 2 | E | 15 | D | 201 | 33.5 |  | B
 | HELENA  NDALU MAZOEYA | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 13 | D | 15 | D | 4 | E | 18 | D | 196 | 32.66666666666666 |  | B
 | LILIAN ZEPHANIA TWATI | 2 | [NAME] | NAMELOCK | 30 | C | 21 | C | 26 | C | 17 | D | 25 | C | 2 | E | 26 | C | 145 | 24.16666666666667 |  | C
 | MARTA MUSA CHOYAI | 2 | [NAME] | NAMELOCK | 35 | B | 21 | C | 26 | C | 22 | C | 34 | B | 6 | E | 26 | C | 164 | 27.33333333333333 |  | C
 | [NAME] | 2 | [NAME] | NAMELOCK | 30 | C | 16 | D | 21 | C | 38 | B | 25 | C | 2 | E | 28 | C | 158 | 26.33333333333333 |  | C
 | MUSUNGUI LAZARO ORMEMEI | 2 | [NAME] | NAMELOCK | 22 | C | 15 | D | 15 | D | 14 | D | 21 | C | 4 | E | 18 | D | 105 | 17.5 |  | D
 | NAISHIE GABRIEL TUKE | 2 | [NAME] | NAMELOCK | 26 | C | 19 | D | 15 | D | 12 | D | 23 | C | 3 | E | 19 | D | 114 | 19 |  | D
 | [NAME] | 2 | [NAME] | NAMELOCK | 42 | A | 16 | D | 15 | D | 43 | A | 27 | C | 6 | E | 30 | C | 173 | 28.83333333333333 |  | C
 | REHEMA [NAME] | 2 | [NAME] | NAMELOCK | 27 | C | 15 | D | 15 | D | 22 | C | 23 | C | 2 | E | 19 | D | 121 | 20.16666666666667 |  | D
 | ROZI ISRAIL LEMJOMBA | 2 | [NAME] | NAMELOCK | 27 | C | 14 | D | 15 | D | 33 | B | 25 | C | 4 | E | 16 | D | 130 | 21.66666666666667 |  | C
 | SARA GABRIEL [NAME] | 2 | [NAME] | NAMELOCK | 5 | E | 19 | D | 23 | C | 13 | D | 32 | B | 2 | E | 29 | C | 121 | 20.16666666666667 |  | D