You took three mocks this month. Your scores read 112, 108 and 115. Now what?
If you glance at the percentile and rush into the next test, you are collecting numbers, not building skill. A CAT mock test analysis template fixes this. It turns each attempt into a structured record of what happened, why it happened and what to do next.
This guide gives you a copy-ready CAT mock analysis sheet you can paste into Excel or Google Sheets. It also covers a five-step review method, error categories, section-wise tips, formulas and a ten-week plan built around CAT 2026. Whether you are at the 80th percentile or chasing 99+, the loop is the same: measure, diagnose, fix, retest.
Why Every CAT Aspirant Needs a Mock Test Analysis Template
A mock is a diagnostic tool, like a health check-up. The report is useless unless someone reads it. Most aspirants read only the headline number, and that hides the real story.
A structured mock test review format gives you four things:
- Pattern visibility. One bad mock is noise. Five mocks with the same error type is a pattern.
- Objective decisions. You decide what to study from data, not from how you feel.
- Calmer nerves. Trends replace panic, because a dip becomes a data point.
- Better time use. You see exactly where minutes leak away.
Scores Are Symptoms, Data Is the Diagnosis
Two students can score 105 with completely different problems. One attempts 45 questions with weak accuracy. The other attempts 30 with strong accuracy but leaves easy questions untouched. The fix for each is different, and only a mock performance tracker shows which student you are.
What a Good CAT Mock Analysis Sheet Must Capture
A useful template records five layers:
- Outcome: score, percentile, attempts, accuracy
- Section behaviour: attempts, accuracy and net score per section
- Question-level detail: topic, difficulty, time spent, result
- Error type: why each mistake happened
- Action: what you will do before the next mock
Know the Pattern Before You Analyse: CAT 2026 Snapshot
Your analysis has to reflect the real exam. CAT 2026 is scheduled for November 29, 2026, with an expected structure of 68 questions, 204 marks and 120 minutes, split into three 40-minute sections. Each correct answer earns +3, each wrong MCQ costs −1, and TITA questions carry no negative marking. Always confirm final details on the official IIM CAT website.
Three rules follow from this pattern:
- Sections are timed separately. You cannot borrow minutes from DILR to finish QA, so analyse each section on its own.
- Wrong MCQs cost marks. Accuracy matters as much as attempts.
- TITA has no penalty. Track TITA accuracy separately, because your risk appetite should differ there.
Net score formula: Net Score = (3 × Correct) − (1 × Wrong MCQs)
For a refresher on question counts per section, read our CAT exam pattern guide.
CAT Mock Test Analysis Template (Copy-Ready Format)
Copy the three tables below into a spreadsheet, one tab per table. The sample rows are illustrative, so replace them with your own numbers.
Table 1: Overall Mock Performance Log
| Mock No. | Date | Score (/204) | Percentile | Attempts | Accuracy % | Focus Level (1–5) | One-Line Learning |
|---|---|---|---|---|---|---|---|
| 12 | 01 Sep | 112 | 91.5 | 44 | 78% | 3 | Lost 6 marks on easy DILR set |
| 13 | 08 Sep | 108 | 89.8 | 49 | 70% | 2 | Over-attempted QA, guessed too much |
| 14 | 15 Sep | 115 | 93.2 | 42 | 84% | 4 | Skipped tough sets quickly |
This log shows the big picture. Watch the relationship between attempts and accuracy rather than the score alone.
Table 2: Section-Wise Analysis Template
| Section | Attempted | Correct | Wrong | Accuracy % | Net Score | Time Wasted (min) | Fix for Next Mock |
|---|---|---|---|---|---|---|---|
| VARC | 18 | 14 | 4 | 78% | 38 | 6 | Skip para-jumble if stuck after 90 sec |
| DILR | 10 | 8 | 2 | 80% | 22 | 12 | Decide set selection within 4 min |
| QA | 16 | 12 | 4 | 75% | 32 | 5 | Attempt TITA-friendly arithmetic first |
Fill this table for every mock. After five mocks you will see which section drives your percentile and which section drags it down.
Table 3: Error Classification Table
Every wrong or skipped question gets exactly one label. Be honest, because the label decides the fix.
| Error Type | What It Looks Like | Best Fix |
|---|---|---|
| Concept gap | You had no idea how to start | Revise the topic, then solve 15 targeted questions |
| Calculation slip | Method right, arithmetic wrong | Practise speed maths and write cleaner working |
| Misread question | You solved for the wrong quantity | Underline the ask before solving |
| Selection error | You chose a hard question and dropped an easy one | Use a 60-second triage pass on each section |
| Time trap | You spent 3+ minutes and still failed | Set a hard cut-off per question |
| Unforced guess | Random option, wrong answer | Guess only when you can eliminate two options |
| Focus lapse | Careless error after a long stretch | Train stamina with full-length sitting |
The 5-Step Method to Analyse a CAT Mock
Follow the same routine after every test so that comparisons stay fair.
Step 1: Record the Numbers Within 15 Minutes
Log the score, percentile, attempts, correct answers and accuracy in Table 1 while the test is fresh. Add your mood and focus level too. Many “mystery” score drops trace back to sleep, hunger or stress.
Step 2: Re-Attempt Wrong and Skipped Questions
Before you open the solutions, try every wrong and unattempted question again without a timer. This separates “I couldn’t” from “I didn’t have time”. Questions you now solve easily were time or nerve problems. Questions you still can’t solve are concept problems.
Step 3: Classify Every Error
Use Table 3 and assign one label per question. Then count each label. If “calculation slip” leads the count, another chapter revision won’t help, but timed calculation drills will.
Step 4: Audit Time and Question Selection
Ask four questions:
- Which questions took more than three minutes, even if correct?
- Which easy questions did I never reach?
- Where did I start each section, and was that the right entry point?
- Did I leave a section with unused minutes?
Correct answers that ate three minutes are hidden losses, because they cost you another question elsewhere.
Step 5: Write the Action List and Retest
End every review with a maximum of three actions, for example “revise percentages, do 20 RC questions, cap DILR set selection at four minutes”. Then re-attempt the same mock after 3–4 days to check whether the fixes worked. Keeping the list short makes the next cycle achievable.
How to Interpret Your Mock Analysis Numbers
Raw numbers mean little until you read them together. Use these working guidelines and adjust them as you improve.
Topic accuracy zones (a useful rule of thumb):
- Above 80%: strong area. Attempt these first in the real exam.
- 60–80%: improvement area. The basics are there, and mixed practice will lift accuracy.
- Below 60%: weak area. Go back to concepts before doing more tests.
Attempts vs accuracy patterns:
- High attempts, low accuracy points to over-guessing. Raise your selectivity.
- Low attempts, high accuracy points to being too conservative. Widen your attempt range gradually.
- High attempts, high accuracy, average percentile usually means the paper was easy, so compare with peers.
- Accuracy dropping in the last 15 minutes of a section points to a stamina or panic issue.
Keep the trend in view: consistency across 10–15 mocks says far more than a single result.
Section-Specific Analysis Tips
VARC Analysis
Split your log into Reading Comprehension and Verbal Ability. For RC, record accuracy by passage type (philosophy, economics, science, literature) and note which question types hurt, such as inference, tone or “except” questions. For VA, track para-jumbles, para-summary and odd-one-out separately. If you consistently lose marks on inference, practise justifying each option elimination in one line. Use our VARC preparation strategy for a topic-wise plan.
DILR Analysis
DILR is decided by set selection, so your analysis should be set-based, not question-based. For each set, record:
- Minutes spent choosing and minutes spent solving
- Questions solved out of questions available
- Whether you should have abandoned it earlier
A set you left after ten minutes with zero answers is a lesson in cut-off discipline. Review the abandoned sets again without a timer to see whether a key deduction was missing.
See the DILR preparation guide for set types and practice routines.
QA Analysis
Log every QA question by topic: arithmetic, algebra, geometry, number system and modern maths. Then track TITA accuracy separately from MCQ accuracy, because their risk profiles differ. If arithmetic accuracy is high but geometry sits low, your next week’s practice is already decided.
The Most Repeated CAT Quant Question Types (5-Year Trend) can help you build that week.
Build Your Own CAT Mock Analysis Sheet: Key Formulas
You don’t need advanced spreadsheet skills. These formulas cover most of what matters. Suppose Correct is in column D, Wrong in column E and Attempts in column C:
Accuracy % = D2 / C2
Net Score = (3 * D2) - E2
Attempt Rate = C2 / 22 (use 24 for VARC)
Rolling Average = AVERAGE(B2:B6) (score across last 5 mocks)Add a line chart for score and percentile over time, plus a bar chart for section-wise accuracy. Charts make trends visible in seconds, which is exactly what you need when a mock leaves you demoralised.
A 10-Week Mock Analysis Plan for CAT 2026
With the exam on 29 November, there are roughly ten weeks left as of 21 September 2026. Use the plan below as a starting point and adapt it to your schedule.
Table 4: Mock and Analysis Timeline
| Phase | Weeks | Mocks per Week | Analysis Focus | Goal |
|---|---|---|---|---|
| Baseline | 1–2 | 2 | Full error classification, topic accuracy zones | Identify the top 3 weak areas |
| Repair | 3–5 | 2 | Re-attempt wrong questions, fix concepts, sectional tests | Raise accuracy by 5–8 points |
| Strategy | 6–8 | 2–3 | Time audit, question selection, set triage | Stabilise your section-wise game plan |
| Sharpen | 9 | 2 | Silly-error hunt, stamina check | Lock in exam-day routine |
| Taper | 10 | 1 light | Revision of error log only | Enter the exam calm and confident |
Spend at least as long analysing a mock as you spent taking it. A two-hour test deserves a two- to three-hour review.
You can supplement the plan with free CAT mock tests and previous year papers.
Common Mock Analysis Mistakes to Avoid
- Checking only the percentile. A number without context misleads you.
- Skipping correct answers. Slow correct answers hide lost time.
- Changing strategy after every mock. Give a new approach at least three mocks before judging it.
- Ignoring emotional patterns. Nervousness and focus loss are fixable, but only if you record them.
- Taking mocks back to back. Without review time, extra tests add fatigue, not skill.
- Comparing raw scores across test series. Difficulty levels differ, so compare percentiles and trends instead.
For a wider preparation roadmap, see our CAT preparation strategy, and know how CAT percentile is calculated.
Summary
- A CAT mock test analysis template turns a score into a diagnosis and an action plan.
- Track three layers: overall performance, section-wise numbers and question-level errors.
- Classify every mistake as a concept gap, calculation slip, misread, selection error, time trap, guess or focus lapse.
- Follow the five steps: record, re-attempt, classify, audit time, then act and retest.
- Analyse DILR by set, VARC by passage and question type, and QA by topic.
- Use trends across 10–15 mocks, not single results.
- Build your plan around CAT 2026 on 29 November, and confirm details on the official website.
Frequently Asked Questions (FAQs)
1. What is a CAT mock test analysis template?
It is a structured sheet where you record your score, accuracy, section-wise performance, time usage and error types after every mock. Its purpose is to reveal patterns and guide what you study next.
2. How many hours should I spend analysing one CAT mock?
Aim for about as much time as the test itself, roughly two to three hours for a full mock. Deep review is where most improvement happens.
3. Should I analyse correct answers too?
Yes. Note which correct answers took over three minutes or were lucky guesses. These reveal time traps and weak concepts that scores hide.
4. How many mocks should I take before CAT 2026?
There is no magic number. Most aspirants do well with 15–25 quality mocks, provided each is analysed properly. Quality of review beats quantity of tests.
5. Can I use Excel or Google Sheets for this?
Both work well. Google Sheets is convenient for sharing with a mentor, while Excel suits offline use. The tables in this guide paste directly into either.
6. What accuracy should I target in CAT mocks?
A common working target is 80% or higher in sections you attempt, with a selective attempt count. Because wrong MCQs cost marks, accuracy usually beats volume.
7. How soon should I re-attempt a mock?
Re-attempt wrong and skipped questions on the same day without a timer. Then retake the full mock after 3–4 days to test whether your fixes hold.
Conclusion
Mock tests only pay off when they change what you do next. A well-built CAT mock test analysis template makes that change automatic, because every attempt ends with a diagnosis, a short action list and a retest date.
Start today. Copy the three tables, log your most recent mock, classify each error honestly, and pick three actions for the week. Repeat the loop for ten weeks, and by 29 November your analysis sheet will be your most reliable preparation partner.
Ready for the next step? Take a full-length test, then use this template to review it.
You May Also Like : CAT MOCK, CAT MOCK PYQ
Follow Us On : Facebook, Instagram, Youtube
