Your privacy choices

KiwiBee uses optional Google Analytics, Google Ads, and Meta Pixel cookies to understand adult visitors, measure completed sign-ups, and improve campaigns. Essential cookies always stay on. OpenAI’s ChatGPT Ads Pixel also measures page views and completed enquiries after advertising consent, and may use hashed contact details for matching. Privacy policy

Skip to main content
Excel template

Test Question Analysis

What's inside

A preview of the first rows. The file adds drop-down lists, formulas that fill in by themselves and room for more rows.

Test question analysis

Enter 1 = correct, 0 = wrong (or part marks). The Average row shows the share of marks earned on each question.

Class
Test
Date
Teacher
No.Student nameQ1Q2Q3Q4Q5Q6…ScorePercent
Example: Mai Tran110111

Sheet: Analysis · 35 rows

How to use it

  1. Write the class, test and date at the top.
  2. Type each student's name.
  3. Enter 1 for a correct answer and 0 for a wrong one in each question column.
  4. Read the average row: a low number means a hard question to reteach.

About this document

An item analysis for a test of up to 20 questions. Enter 1 for correct and 0 for wrong; the sheet scores each student and shows what share of the class got each question right.

Comments

    Test Question Analysis – Free Excel Template | KiwiBee