Multiple-choice item analysis template for teachers

Start with one row per question. The blank sheet gives you a place for the answer key, each choice count, omissions, and the next thing to check.

In short

Copy the key and anonymous counts for each test form. Add the choices and omissions before reporting percent correct. If the sum differs from the number who took that form, hold the percentage and check the original tally.

Download the blank item analysis sheet (CSV) or download the completed example (HTML).

What goes in a multiple-choice item analysis sheet?

Give each row an item ID and a form or version so you can match it to the right key. Enter the number who took that form, the keyed answer, and one count for each choice. Give omitted answers their own column. A zero means you checked the tally and found none. Leave an unknown count blank and hold the percentage until you can check it.

Our fictional classroom example has 20 test takers and three single-answer items. We copied the counts into a NOS page and opened Code to check the source alongside the display. Then we switched to View, where the first row was flagged for review.

NOS Code mode with the fictional item review source and preview
The HTML source and its preview are open side by side in Code.
NOS View with Item 04 on hold and three sets of answer counts
View shows the hold above the three items and the reference tally beneath them.

How do you fix a row that adds up to 19 instead of 20?

For Item 04, the first pass recorded A 4, B 8, C 5, D 0, and 2 omitted. The sum was 19. Even after counting the two omissions, one response was still unaccounted for. The separate reference tally showed 9 for B. We kept the two omissions and corrected the copied B count.

NOS Edit mode showing the original Item 04 tally
Edit shows the copied B count of 8 before we correct it.

After the correction, 4 + 9 + 5 + 0 + 2 = 20. The key says B, so 9 of the 20 test takers got it right. On this sheet the denominator is everyone who took that form. Using the 18 who selected a choice would give 50%, which answers a different question.

We opened Share and used the reader link it listed. In a signed-out browser it first showed the hold and withheld the percentage. The workspace editor address sent that same browser to the login page.

NOS Share panel with the example's reader link and permission
The Share panel lists the address a colleague can use to read the example.
Signed-out NOS reader showing the count mismatch and the held percentage
The first reader view shows Item 04 on hold with its percentage withheld.

We saved the correction in Code on the existing page and checked the result in View. When we reopened the original reader link signed out, it showed 9/20 (45%) correct. The colleague can see which count changed and compare it with the reference tally on the page.

NOS View showing the corrected Item 04 tally and 45 percent correct
The corrected row shows B at 9 and two omissions.
Signed-out NOS reader showing the reconciled count and 9 out of 20 correct
The same reader link now shows 20 accounted for and 9/20 (45%) correct.

Open the fictional item review in NOS.

What should you do with an option nobody picked?

Item 04's D received zero selections. Our note says to review D. Reread the option and see whether it describes a plausible mistake when reading a scale. In Item 11, B drew 6 of 20 responses and the key was A. The note there asks whether the two options overlap. Check the wording and answer key before deciding whether either question needs a revision.

The University of Illinois item analysis guide shows option frequencies and omissions separately. Penn State's guide suggests reading the wording of rarely chosen alternatives in the context of the question.

How do you use the blank sheet for a different class?

Copy one empty row per item. Keep different forms on different rows if the keys or choices differ. Once the counts add up, write the correct count, percent correct, and a review note. A note such as “Compare B with the key for Form 2” gives the next reviewer a place to start.

When not to do this

Use your school's approved process for individual grades and scoring decisions. This sheet is for single-answer item totals and teacher review. For questions that allow several selections, make a separate tally designed for that response rule. For other tasks, see the printable gradebook template for grade tracking or the survey results report template for communicating survey findings.

Where does NOS fit?

We used NOS to put the fictional tally and review notes on a single page. The reader link let us check the corrected version without signing in. Keep the shareable version to aggregate counts and the notes a colleague needs to review the item.

Questions people ask

Do omissions count in the denominator?

Yes, on this sheet. Divide the correct count by everyone who took that form, including people who left the item blank. In Item 04, 18 people chose an answer and 20 took the test, so the sheet reports 9/20 (45%).

What if my counts add up to more than the number of test takers?

Hold the percentage and compare the row with the original tally. Check for a duplicate count, a form mix-up, or a response recorded under two choices.

Should I remove an option nobody picked?

Keep a review note. Read the option in context and decide whether it still represents a plausible mistake you want the question to check.

Does the blank CSV calculate results?

The CSV is an empty sheet. Enter the totals and percent correct after checking the tally, and use the count check and review note columns to record what needs attention.

Keep reading