← Teacher track
Lesson 5 of 6 · 7 min

Reading your class's scores

Listen to this lesson

Nigerian voice narration

Scenario

Fictional training case. Term results show the class average dropped across three topics, and the teacher must decide what to reteach with limited time left in the term. Without a structured analysis of which topics and which pupils are weakest, reteaching risks covering material pupils already understand while skipping real gaps. Work through the example, identify the evidence needed and practise the method with cleared or synthetic inputs. Any additional figures in the explanation are separate practice examples, not claimed rows in a downloadable file.

Colleagues learning with an AI assistant

Worked example

Organise scores by pupil code and topic, never by full name, and ask AI to rank the topics by average weakness and separately flag which pupil codes need the most support. Ask for a 2-week reteach plan structured around the weakest topics first, built from short 15-minute starter activities, targeted practice questions, and ending in a re-test to confirm whether the gap actually closed. Check that the ranked topic order matches your own impression from marking — if AI ranks a topic as weakest that you know pupils actually handled well, recheck the score data for an input error before committing the reteach plan to that topic.

The method

Rank-then-targeted-reteach: use AI to objectively rank topics and flag struggling pupils from the raw score data first, then build the time-bound reteach plan around that ranking rather than teacher intuition alone, closing the loop with a re-test.

Worked practice and common mistakes

Convert scores to comparable percentages where totals differ: 8/10 is 80%, while 12/20 is 60%. Count absences separately from incorrect answers according to school policy. Use topic patterns to plan support, not diagnose motivation. Re-test the same learning objective with a fair comparable item; a harder follow-up test would make improvement difficult to interpret.

Review before using the result

Compare the AI-ranked weakest topic against your own marking impressions. If they conflict, recheck the score data before finalising which topic to reteach first.

Your workplace practice

Use the recommended free assistant with this lesson's fictional example. Here are my class scores by pupil code and topic. Rank the weakest topics, list pupils needing extra support (codes only), and draft a 2-week reteach plan ending with a re-test. Keep a copy of the input and draft. Compare the result with the verification steps above, record any correction, and retain placeholders where evidence is missing. The expected result is a checked draft for human review, not an automatically approved decision. Course examples and practice responses are fictional; amounts, dates, rules and thresholds are not official guidance or supplier quotations.

Try this prompt in Google Gemini

Open Google Gemini (free tier) and paste this prompt there. Suggests patterns and chart ideas from synthetic scores, with counts and learning gaps checked by the teacher.

Here are my class scores by pupil code and topic. Rank the weakest topics, list pupils needing extra support (codes only), and draft a 2-week reteach plan ending with a re-test.

Use this AI · free tier
Google Gemini
Open Google Gemini

Why this tool: Suggests patterns and chart ideas from synthetic scores, with counts and learning gaps checked by the teacher.

Hit a free limit? Switch to ChatGPT or Gemini and continue — the prompt works in any assistant.

Follow-along sample data
Class scores sheet (CSV)
Download
Checkpoint · build the prompt