Test Item Analysis Template

Test Item Analysis Template for DepEd Teachers (SY 2026–2027) | Free Download

If you’re a Filipino public school teacher scrambling to make sense of test results right after a periodical exam, you’re not alone. Every term, thousands of teachers across the country sit down with a stack of answer sheets — and the pressure to submit an item analysis report on top of everything else can feel overwhelming.

But here’s the good news: a well-designed Test Item Analysis Template can cut your work in half. And in this guide, we’re going to walk you through everything you need to know — what item analysis is, why it matters more than ever under DepEd’s new three-term calendar, how to use the template properly, and where you can download it for free.

Let’s dive in.

What Is a Test Item Analysis? (And Why Every DepEd Teacher Needs One)

A Test Item Analysis is the process of evaluating each question (or “item”) in your exam to determine how well it measured what it was supposed to measure. Think of it as a quality check — not just for your students, but for your test itself.

“Item analysis is not just a grading tool. It is one of the most powerful feedback mechanisms a teacher has — revealing both what students learned and whether the test fairly measured that learning.” — DepEd Assessment Practitioner

When you conduct item analysis, you answer two key questions:

Did students learn this competency? (difficulty index / percentage of correct responses)
Did the question effectively separate students who know it from those who don’t? (discrimination index)

Under the MATATAG Curriculum and DepEd’s shift to a three-term school calendar (DepEd Order No. 009, s. 2026), item analysis has become even more critical. Here’s why.

The Three-Term School Calendar and Item Analysis: What Changed?

Starting School Year 2026–2027, DepEd implemented a restructured academic year divided into three terms instead of the old four-quarter system. The school year runs from June 8, 2026 to April 8, 2027, covering a total of 201 class days.

Here is a quick overview of the new calendar structure:

Term	Instructional Period	End-of-Term Block	Key Assessment Window
Term 1	June 15 – September 1, 2026	September 2–15, 2026	Summative Tests + Term Exam
Term 2	September 16 – December 4, 2026	December 7–18, 2026	Summative Tests + Term Exam
Term 3	January 4 – March 23, 2027	March 24 – April 8, 2027	Final Assessments + Closing

Each term now includes a structured End-of-Term Block — a two-week period dedicated to assessments, remediation, grade computation, and INSET activities. This is exactly when your item analysis report needs to be ready.

The good news? With three dedicated assessment windows per year (instead of four rushed quarters), you now have a cleaner, more organized rhythm for conducting and submitting item analysis.

What Does a Test Item Analysis Template Include?

A standard DepEd-compliant Item Analysis Template typically captures the following data fields:

Basic Information Header

School Name
District / Division
School Year
Subject
Term (Term 1, Term 2, or Term 3 — updated for the new calendar)
Grade Level & Section
Grading Period / Term
Name of Test (e.g., Term 1 Examination)
Date Administered

Per-Item Data Table

Item No.	Competency / Learning Objective	Answer Key	Tally of Correct Responses	Total Correct	% of Correct Responses	Mastery Level
1	Identify the main idea of the text	B	IIIII-IIIII-IIIII	15	60%	Nearly Mastered
2	Infer character traits from dialogue	A	IIIII-IIIII	10	40%	Below Mastery
3	Identify cause and effect	C	IIIII-IIIII-IIIII-IIIII	20	80%	Mastered

Mastery Level Legend

Percentage Range	Mastery Classification
75% – 100%	Mastered
51% – 74%	Nearly Mastered
50% and below	Below Mastery (Least Learned)

Summary Section

Mean Percentage Score (MPS): Total correct responses ÷ (Total items × Total learners) × 100
Standard Deviation (SD)
Approximation Level (AL)
List of Least Learned Competencies (items with Below Mastery rating)
Recommended Remediation Actions

Signature Block

Prepared by: (Subject Teacher)
Checked by: (Master Teacher / Head Teacher)
Approved by: (School Head)

Share to your friends!

Step-by-Step Guide: How to Accomplish Your Item Analysis Template

Using the template doesn’t have to be complicated. Follow these simple steps:

Step 1: Administer the Test

Give your scheduled Summative Test or Term Examination as planned within the Instructional Block of the term.

Step 2: Collect and Score the Answer Sheets

Go through each learner’s paper and mark correct (1) and incorrect (0) answers for each item. In a class of 40 students with 50 test items, you’ll be filling a 40×50 grid — which is exactly why an automated Excel version saves so much time.

Step 3: Tally Correct Responses Per Item

For each item, count how many students answered correctly. Record this in the “Total Correct” column of your template.

Step 4: Compute the Percentage of Correct Responses

Use this formula:

% Correct = (Number of Correct Responses ÷ Total Number of Students) × 100

Example: If 30 out of 40 students answered Item 5 correctly: (30 ÷ 40) × 100 = 75% → Mastered

Step 5: Determine the Mastery Level

Apply the legend:

75%–100% = Mastered
51%–74% = Nearly Mastered
50% and below = Below Mastery (these become your priority for remediation)

Step 6: Identify Least Learned Competencies

Look at all items rated “Below Mastery.” These competencies are your remediation targets for the next instructional cycle — a critical step now that DepEd has embedded the ARAL (Academic Recovery and Accessible Learning) Program within the three-term structure.

Step 7: Compute the MPS

MPS = (Total Score of All Students ÷ Highest Possible Score) × 100

Or alternatively:

MPS = Average of all % Correct Responses across all items

Step 8: Accomplish the Signature Block and Submit

Have the template signed by the Master Teacher or Head Teacher, and approved by the School Head, before filing it in your RPMS-PPST Portfolio (this supports Objective 11 for Proficient Teachers).

How Item Analysis Connects to the ARAL Program

Under DepEd Order No. 009, s. 2026, each term’s End-of-Term Block includes dedicated time for remediation and academic recovery. The ARAL Program is the formal mechanism for this — and item analysis is the diagnostic engine that tells you exactly which competencies need to be retaught.

Here’s how the connection works:

You conduct item analysis after the Term Exam.
You identify least-learned competencies (Below Mastery items).
You design ARAL sessions targeting those specific competencies.
You reassess through follow-up activities in the next term’s opening block.
You document the intervention for your RPMS portfolio.

This is the cycle. Item analysis is not just paperwork — it is the starting point of meaningful learning recovery.

Automated vs. Manual Item Analysis Template: Which Should You Use?

Many teachers still use the manual tally method (drawing marks on paper), but automated Excel templates have become the standard in most schools. Here’s a comparison:

Feature	Manual Template	Automated Excel Template
Time Required	2–4 hours per class	30–60 minutes per class
Computation Accuracy	Prone to human error	Automatically computed
MPS Auto-Calculation	Manual formula needed	Built-in formula
Multiple Terms Support	Must re-create each term	One file, three term sheets
RPMS-Ready Output	Needs formatting	Ready to print and sign
Cost	Free (printed)	Free (download)

Our recommendation: Use the Automated Item Analysis Template available for free download below. It comes pre-formatted with formulas for MPS, percentage correct, and mastery level — and it has separate sheets for Term 1, Term 2, and Term 3 aligned with the new three-term calendar.

Free Download: Test Item Analysis Template (SY 2026–2027, Three-Term Calendar)

You can download the Test Item Analysis Template for FREE!

We have prepared a fully updated, automated Excel template aligned with DepEd’s three-term school calendar for SY 2026–2027. The file includes:

Separate sheets for Term 1, Term 2, and Term 3
Automated MPS, % Correct, and Mastery Level computation
Elementary version (up to 50 items)
Secondary version (up to 100 items)
RPMS-ready format with signature block
Least Learned Competencies summary section
Pre-formatted for printing (A4, landscape)

The download is completely FREE — no sign-up required. Just click the download button on this page and get your template instantly. Share it with your co-teachers too!

Test Item Analysis Template