wowprompt

Class exam results analysis by subject, section and student

Reads a marks sheet and shows how each subject and section performed, which topics or questions pulled scores down, and which students need help or a stretch. Use it after a unit test, half-yearly or pre-board exam, before a parent-teacher meeting or a remedial plan.

Subject and section tables with average, pass rate and spread, a list of weak topics, students grouped for support and extension, and talking points for parents
The output this prompt produced, unedited.

The prompt

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

  1. | Subject | Section | Average percent | Highest | Lowest | Pass rate | Change from last exam |
  2. Weak topics: | Topic or question | Average score percent | Likely reason | One teaching fix |
  3. Student groups: below pass mark, close to pass mark, steady, ready for extra challenge, each listed by roll number with subjects.
  4. Students whose marks dropped by more than 15 percentage points since the last exam.
  5. Three talking points for the parent-teacher meeting for each group.
  6. 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.
exam results analysisstudent marks analysisclass performanceteacher dataremedial planningschool report

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity