Mathematics Item Analysis Template

Editable IAL Mathematics item analysis Excel template for teachers: analyse student marks, question difficulty, discrimination and class performance.

The General IAL Mathematics Item Analysis Template helps teachers turn student marks into useful information for teaching, revision and assessment review. It can be adapted for P1, P2, P3, P4, M1, S1, mock examinations, topic tests and other mathematics assessments.

• What the template includes

  • Space for up to 60 questions or question parts
  • Support for 20 main questions and 40 students
  • Editable question labels, maximum marks and topics
  • Automatic question totals, percentages and student rankings
  • Question-level and whole-class summaries
  • Automatic item difficulty and discrimination analysis

• How to use it

  • Complete the Paper Setup sheet with the paper title, question numbers, item labels, maximum marks and topics.
  • Enter student names and marks in the yellow cells on the Marks Entry sheet.
  • Open the Item Analysis sheet to view the automatically calculated results.
  • Keep a blank master copy and save a separate version for each assessment.

• What the analysis shows

  • Mean mark and standard deviation
  • Facility index and difficulty level
  • Number of zero and full marks
  • Upper and lower 27% group performance
  • Discrimination index and quality
  • Items that may need further review

• How it supports teaching

  • Identify difficult questions and common weaknesses.
  • Find topics that need reteaching or further practice.
  • Plan targeted revision lessons and interventions.
  • Give students more specific, topic-based feedback.
  • Review the quality and balance of teacher-created assessments.
  • Use evidence from results to improve future question papers.

The template saves time after marking and provides a clear overview of how students performed across individual questions, topics and the paper as a whole.