Spreadsheet: 838794d1691414615-need-help-creating-automated-school-report-form-system-assessment-reports-generator
Sheet: Data

 | SCHOOL NAME | XYZ JUNIOR SCHOOL
 | CLASS/GRADE | 7
 | YEAR | 2023
 | TERM | II
 | CLASS TEACHER'S NAME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEARNING AREA | 1st Assessment |  |  |  |  |  |  |  |  |  |  |  | LEARNING AREA | 2nd Assessment |  |  |  |  |  |  |  |  |  |  |  | LEARNING AREA | 3rd Assessment |  |  |  |  |  |  |  |  |  |  |  | KEY TO PERFORMANCE LEVELS |  |  |  | SUBJECT TEACHERS |  |  | TERM DATES
 |  | GENDER | ADM. NO. | UPI | ASSESSMENT NO. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL  MARKS | GENERAL PERFORMANCE  LEVEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Exceeding Expectation | EE |  | Learning Area | Teacher |  | Term | Opening | Closing
 |  |  |  |  |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  | 1st Assessment |  | 2nd Assessment |  | 3rd Assessment |  |  |  |  |  | [NAME] | Levels | Interval | Exceeding Expectation |  | Meeting Expectation |  | Approaching Expectation |  | Below Expectation |  |  |  | [NAME] | Levels | Interval | Exceeding Expectation |  | Meeting Expectation |  | Approaching Expectation |  | Below Expectation |  |  |  | [NAME] | Levels | Interval | Exceeding Expectation |  | Meeting Expectation |  | Approaching Expectation |  | Below Expectation |  |  | 3 | Meeting Expectation | ME |  | MATHEMATICS | MDM. NANCY |  | 1 | 2023-02-01 00:00:00 | 29/3/2023
 | [NAME] | M | 12 | [NAME] | A00B13109 | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  | 22 |  | 13 |  | 13 |  |  |  |  |  |  |  |  | Lower | Upper | Lower | Upper | Lower | Upper | Lower | Upper |  |  |  |  |  | Lower | Upper | Lower | Upper | Lower | Upper | Lower | Upper |  |  |  |  |  | Lower | Upper | Lower | Upper | Lower | Upper | Lower | Upper |  | 2 | Approaching Expectation | AE |  | ENGLISH | MDM. MAGDALENE |  | 2 | 2023-02-05 00:00:00 | 27/7/2023
 | BRUCE WILLIS | F | 35 | GKR10 | A00B13112 | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  | 25 |  | 15 |  | 17 |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 50 | 4 |  |  |  |  |  |  |  |  |  |  | 1 | Below Expectation | BE |  | KISWAHILI | MR. ONDITI |  | 3 | 2023-04-09 00:00:00 | 24/11/2023
 | ALEXIS PETERSON | F | 31 | [NAME] | A00B13107 | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  | 17 |  | 12 |  | 16 |  |  |  |  |  | 70 | 4 |  |  |  |  |  |  |  |  |  |  |  | 55 | 4 |  |  |  |  |  |  |  |  |  |  |  | 65 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTEGRATED SCIENCE | MR. [NAME]
 | [NAME] | F | 63 | GKR8 | A00B13110 | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  | 35 |  | 16 |  | 17 |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 50 | 4 |  |  |  |  |  |  |  |  |  |  |  | 45 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOCIAL STUDIES | MR. [NAME]
 | ISSA YUSUF | M | 103 | GKR6 | [NAME] | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  | 13 |  | 17 |  | 14 |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 35 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRE-TECHNICAL & PRE-CAREER STUDIES | MR. [NAME]
 | ISHMAEL RAJAB | M | 40 | GKR3 | A00B13105 | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  | 15 |  | 14 |  | 15 |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 25 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIFE SKILLS | MR. [NAME]
 | JENIFFER MCARTHUR | F | 62 | [NAME] | A00B13104 | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  | 13 |  | 16 |  | 17 |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 65 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HEALTH EDUCATION | MR. ROTICH
 | [NAME] | F | 39 | [NAME] | A00B13106 | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  | 15 |  | 17 |  | 17 |  |  |  |  |  | 20 | 4 |  |  |  |  |  |  |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 35 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUSINESS STUDIES | MR. ONDITI
 | ALAINE JOHNSON | F | 1 | GKR1 | A00B13103 | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  | 15 |  | 17 |  | 13 |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 35 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPUTER SCIENCE | MDM. NANCY
 | GEOFFREY MICHAELS | F | 105 | GKR9 | A00B13111 | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  | 13 |  | 15 |  | 13 |  |  |  |  |  | 20 | 4 |  |  |  |  |  |  |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 45 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOME SCIENCE | MDM. CENSOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 4 |  |  |  |  |  |  |  |  |  |  |  | 20 | 4 |  |  |  |  |  |  |  |  |  |  |  | 65 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGRICULTURE | MR. KERING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 4 |  |  |  |  |  |  |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 70 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHRISTIAN RELIGIOUS EDUCATION | MR. ONDITI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 40 | 4 |  |  |  |  |  |  |  |  |  |  |  | 35 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHYSICAL EDUCATION & SPORTS | MR. [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  | 45 | 4 |  |  |  |  |  |  |  |  |  |  |  | 70 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 4 |  |  |  |  |  |  |  |  |  |  |  | 20 | 4 |  |  |  |  |  |  |  |  |  |  |  | 45 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL MARKS |  | 4 |  |  |  |  |  |  |  |  |  |  | TOTAL MARKS |  | 4 |  |  |  |  |  |  |  |  |  |  | TOTAL MARKS |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GENERAL [NAME] |  | 4