Fill in these first
- Marks sheet: [paste rows: roll number or student code, section, subject, marks, maximum marks; add question-wise marks if you have them]
- Exam: [e.g. class 9 half-yearly, maths and science]
- Pass mark: [e.g. 33 percent]
- Previous exam averages, if any: [per subject and section, or none]
- Topics per question or section of the paper: [e.g. Q1-Q5 algebra, Q6-Q9 geometry, or none]
- What the teacher wants: [e.g. remedial groups, report for the principal, PTM notes]
Task
Analyse the results and turn them into next steps for teaching.
Output format
- | Subject | Section | Average percent | Highest | Lowest | Pass rate | Change from last exam |
- Weak topics: | Topic or question | Average score percent | Likely reason | One teaching fix |
- Student groups: below pass mark, close to pass mark, steady, ready for extra challenge, each listed by roll number with subjects.
- Students whose marks dropped by more than 15 percentage points since the last exam.
- Three talking points for the parent-teacher meeting for each group.
- A summary of five lines for the principal.
Rules
- Use roll numbers or codes, never full names, in the output.
- Do not rank sections against each other without noting differences in class size or teacher change.
- A drop in one exam is a reason to talk with the student, not a label.
- Show averages to one decimal place and say how many students each covers.






