Best Airforce Coaching Academy in Dehradun

How to Build a Personal Exam Progress Dashboard in Google Sheets

October 14, 2026

How to Build a Personal Exam Progress Dashboard in Google Sheets Table of Contents An exam progress dashboard in Google Sheets is a digital tracking system designed to monitor your preparation journey for competitive exams like NDA, CDS, AFCAT, and other defence examinations. If you’re preparing for the National Defence Academy or pursuing any defence exam, maintaining an organized exam progress dashboard becomes crucial for success. At Cadets Defence Academy, we consistently advise our students to use an exam progress dashboard in Google Sheets because it provides real-time insights into their preparation status. Unlike traditional notebooks, a Google Sheets dashboard allows you to track multiple metrics simultaneously—from subject-wise progress to mock test performance—in one centralized location. The beauty of Google Sheets is its accessibility. Whether you’re at Cadets Defence Academy in Dehradun or studying remotely, you can access your exam progress dashboard from any device, at any time. This flexibility is essential for students juggling classroom learning with self-study routines. Benefits of Tracking Exam Preparation Progress Understanding why you need an exam progress dashboard in Google Sheets is the first step toward consistent preparation. Let’s explore the key advantages: 1. Identifying Weak Areas Early When you maintain a detailed exam progress dashboard, you can quickly identify subjects or topics where your accuracy is below target. This early identification allows you to seek additional support from faculty at institutions like Cadets Defence Academy before the exam. 2. Maintaining Motivation Through Visual Progress Psychological research shows that visual representation of progress significantly boosts motivation. An exam progress dashboard in Google Sheets with charts and progress bars provides tangible evidence of your improvement, keeping you motivated during tough preparation phases. 3. Data-Driven Decision Making Rather than relying on intuition, your exam progress dashboard provides concrete data about: Which study hours are most productive Which subjects need more focus Mock test performance trends Topic-wise accuracy patterns 4. Time Management Optimization By tracking daily study hours in your exam progress dashboard, you can identify your peak productivity hours and optimize your study schedule accordingly. This is particularly useful for NDA aspirants following the rigorous curriculum at Cadets Defence Academy. 5. Performance Analysis for SSB Preparation Beyond written exams, maintaining records in your exam progress dashboard helps with personality development and mock interview performance tracking—essential components of SSB coaching. Setting Up Your Google Sheets Dashboard Creating an effective exam progress dashboard in Google Sheets requires proper planning and organization. Here’s your step-by-step setup guide: Step 1: Create a Master Sheet Begin by creating a new Google Sheet and naming it “Exam Preparation Dashboard 2026.” Create multiple tabs within this single sheet: Dashboard (main overview) Subject Progress (subject-wise tracking) Mock Tests (test scores and analysis) Daily Study Log (daily tracking) Mistake Log (error documentation) Monthly Summary (progress review) Step 2: Design Your Dashboard Layout Your main exam progress dashboard should include: Header Section: Exam Name: NDA 2026 / CDS 2026 / AFCAT 2026 Preparation Start Date Target Exam Date Days Remaining (auto-calculated) Overall Progress Percentage Overview Metrics: Total Study Hours Completed Average Daily Study Hours Number of Mock Tests Taken Current Mock Test Accuracy Topics Completed vs. Total Topics Step 3: Set Color Coding Implement a color-coding system in your exam progress dashboard: Green: 80% or above (Strong) Yellow: 60-79% (Satisfactory) Orange: 40-59% (Needs Improvement) Red: Below 40% (Critical Attention Required) This visual system makes your exam progress dashboard intuitive and action-oriented. Creating a Subject-Wise Progress Tracker The subject-wise component of your exam progress dashboard in Google Sheets is fundamental for defence exam preparation. Create a table with the following columns: Subject Total Topics Topics Completed Completion % Revision Done Accuracy % Target Date Mathematics 15 12 80% 8 75% Oct 15 English 12 10 83% 9 82% Oct 20 General Knowledge 20 15 75% 10 70% Oct 25 Physics 18 14 78% 9 76% Oct 18 Chemistry 16 13 81% 8 79% Oct 22 Pro Tips for Your Subject Tracker: Update this section weekly, not daily Compare your progress with Cadets Defence Academy’s recommended syllabus timeline Allocate more time to weak subjects based on your exam progress dashboard data Review your subject tracker before each revision session Tracking Daily Study Hours and Completed Topics Maintaining daily records in your exam progress dashboard in Google Sheets is critical for consistency. Create a “Daily Study Log” sheet with: Columns: Date Day of Week Subject Studied Topics/Chapters Covered Hours Dedicated Difficulty Level (Easy/Medium/Hard) Notes/Observations Energy Level (1-5 scale) Example Entry: Date Day Subject Topics Hours Level Notes Energy Oct 10 Wednesday Mathematics Trigonometry (Ch. 3-4) 2.5 Hard Struggled with identities 3 Oct 10 Wednesday English Reading Comprehension 1.5 Medium Good pace, need more practice 4 This data in your exam progress dashboard helps identify: Best study times Optimal session duration Topics requiring revision Energy level correlations with subject difficulty Recording Mock Test Scores and Accuracy Mock tests are cornerstone of defence exam preparation. Your exam progress dashboard in Google Sheets should include detailed mock test tracking: Mock Test Analysis Sheet Structure: Test Name Date Total Score Obtained Score Accuracy % Mathematics % English % GK % Time Management (1-5) Weak Topics Status CDS Mock 1 Sept 28 100 78 78% 85% 72% 75% 4 GK – History Satisfactory NDA Mock 2 Oct 2 100 82 82% 88% 78% 80% 3.5 English – Grammar Good Key Metrics in Your Exam Progress Dashboard: Trending Accuracy: Calculate moving average (last 3-5 tests) Subject-wise Performance: Identify consistently weak areas Time Management Score: Track your ability to complete papers Improvement Rate: Measure progress across tests For students at Cadets Defence Academy, this exam progress dashboard data should align with feedback from your instructors. Building a Mistake Log to Identify Weak Areas One of the most powerful features of an exam progress dashboard in Google Sheets is the Mistake Log. This dedicated sheet prevents repetitive errors: Mistake Log Structure: Date Subject Topic Error Type Question What I Did Correct Answer Why I Was Wrong Review Date Oct 5 Math Geometry Calculation Problem 15 Applied

Tattoo Policy for NDA, CDS and AFCAT: What’s Allowed

October 9, 2026

Tattoo Policy for NDA, CDS and AFCAT: What’s Allowed Table of Contents Many defence aspirants ask the same worry just before the medical: “Is my tattoo going to stop me from joining?” If you have a tattoo, or you are thinking of getting one, this guide is for you. The tattoo policy for NDA, CDS and AFCAT is strict, but it is not a total ban. Small tattoos in certain places are accepted. Tattoos in the wrong place or of the wrong kind can end your selection. For NDA, permanent tattoos are accepted only on the inner face of the forearm (from inside the elbow to the wrist) and the back of the hand. Tribal candidates get a special case-by-case rule. CDS and AFCAT follow the medical standards of the Army, Navy and Air Force, which are similar in spirit. Always read the latest official notification before you apply. Can NDA Officers Have Tattoos? Understanding the Official Rule Yes, but only under limits. The armed forces want officers who look sharp in uniform and who follow discipline from day one. So tattoos are checked carefully during the medical examination. The UPSC publishes the tattoo rule in the NDA & NA notification every year. In simple words, the rule says permanent body tattoos are allowed only on certain parts of the arms. Anything outside those areas is not accepted. So, can you join NDA with a tattoo? You can, if the tattoo is within the permitted area and is acceptable in nature. Rules can change from one notification to the next, so always check the latest tattoo rules for NDA, CDS and AFCAT on the official websites given at the end of this blog. Is Tattoo Allowed in the National Defence Academy for Non-Tribal Candidates? For general (non-tribal) candidates, the answer is yes, but only in a very small area. According to the UPSC notification, permanent tattoos are accepted only on the inner face of the forearm and on the back (dorsal side) of the hand. This means a tattoo anywhere else on your body is a risk for your NDA eligibility. That includes the neck, face, chest, back, upper arm, legs and palms. The same idea applies to other entries. Are tattoos allowed for CDS candidates? Can you apply for AFCAT with a tattoo? Yes, in most cases, if the tattoo sits in a permitted area and is small and acceptable. But the exact wording can differ by force and by year, so check the notification of your exam. If you are preparing for these exams, you can also look at our CDS coaching in Dehradun and AFCAT coaching programs for complete guidance. Permitted Areas for Tattoos Where tattoos are allowed for NDA, CDS and AFCAT depends on the official medical rule. For NDA, the accepted places are: The inner face of the forearm, from the inside of the elbow to the wrist The back (dorsal side) of the hand People often ask: can CDS candidates have tattoos on their arms? Only if the tattoo is on the permitted part of the arm. A tattoo on the upper arm or shoulder is usually not accepted. Are tattoos on the neck allowed for AFCAT? No. A visible neck tattoo is a common reason for rejection. Do tattoo rules depend on location for defence medicals? Yes, location is the first thing a doctor checks. As a safe thumb rule, the more visible the tattoo is in uniform, the higher the risk. What about size? The NDA notification text we reviewed does not clearly state a size limit. But some other forces, such as the CAPF, mention that a tattoo should be less than one-fourth of the body part. So a tattoo size limit for defence candidates in India is not always written the same way. The safest choice is a small tattoo, and one that is easy to check. Permitted Nature of Tattoos Besides location, the design also matters. Which tattoos are allowed for NDA, CDS and AFCAT? In general, the board looks kindly at tattoos that are small, neat and respectful. Examples are a small religious symbol or the name of a family member, placed on a permitted area. Are religious tattoos allowed in the Indian Armed Forces? Often yes, if they are small, decent and placed correctly. Can a small religious tattoo affect AFCAT eligibility? It should not, if it follows the rules. But the final decision is always taken by the medical board. Tattoos that carry offensive, obscene, political or hateful messages are not accepted anywhere. If your tattoo can hurt anyone’s feelings or look inappropriate, do not take the risk. Tattoo Rules for Tribal Candidates in NDA India has many tribal communities with old traditions of tattoo marks on the face or body. The armed forces respect this. Under the NDA rule, tribal candidates with tattoo marks made as per their existing custom and tradition are permitted on a case-by-case basis. Are tribal tattoos allowed for NDA candidates? Yes, but each case is checked separately. The same idea is followed in tattoo rules for tribal candidates in CDS. To avoid trouble at the medical, keep your Scheduled Tribe certificate and any proof of your community’s custom with you. A tattoo that is not part of a tribal tradition does not get this benefit. Tattoos That Lead to Direct Rejection Can a tattoo cause rejection in NDA, CDS or AFCAT? Yes. Reasons defence candidates are rejected for tattoos usually include: Tattoos on the neck, face, chest, back, legs or palms (for non-tribal candidates) Tattoos outside the permitted area of the forearm or hand Large tattoos or tattoos that cover a big part of a limb Offensive, political or obscene designs A tattoo that is hidden or not declared at the medical Can an AFCAT medical board reject a candidate for a tattoo? Yes, if the tattoo breaks the rule. Never try to hide it. What to do if rejected for a tattoo in the NDA medical? Candidates declared

What Happens After Clearing the NDA Written Examination?

October 2, 2026

What Happens After Clearing the NDA Written Examination? Table of Contents Clearing the NDA written examination is a monumental achievement that marks the beginning of your journey toward becoming an officer in the Indian Armed Forces. However, many aspirants wonder: what happens after clearing the NDA written examination? This comprehensive guide will walk you through every stage of the selection process after you’ve successfully passed the written exam, ensuring you’re fully prepared for what lies ahead. At Cadets Defence Academy, we understand the challenges aspiring cadets face after clearing the written examination. This article provides detailed insights into the post-written exam journey, from SSB interview registration to final merit list preparation. NDA Written Exam Result and Qualification Once you’ve appeared for the NDA written examination conducted by UPSC, the results are declared within 3-4 weeks. Approximately 6,000–7,500 candidates are shortlisted in the NDA written result for SSB interview, making it one of the most competitive stages of the selection process. Key Points After Written Exam Clearance: Results are announced on the official UPSC website Your roll number appears in the qualified candidates list You receive notification via registered email and SMS Qualified candidates proceed to the next stage within 1-2 weeks The significance of clearing the written examination cannot be overstated. It demonstrates your academic proficiency and subject knowledge in Mathematics and General Knowledge. However, this is merely the first milestone in your journey after clearing the NDA written examination. What Is the Next Step After NDA Written Exam? After clearing the NDA written examination, your immediate focus should shift toward preparing for the Services Selection Board (SSB) interview. Aspirants who cleared the written exam should immediately begin preparing for the interview and document verification stages. Immediate Action Steps: Check Your Result – Verify your name and roll number on upsc.gov.in Gather Required Documents – Prepare certificates and testimonials immediately Register for SSB – Complete online registration within the specified timeframe Begin SSB Preparation – Start intensive interview and psychological training Maintain Physical Fitness – Strengthen your body for physical tests The NDA SSB Interview is a five-day process held at Indian Armed Force selection centres across the country. Candidates who clear the NDA exam are called for the SSB interview at various selection centres based on merit and geographical preferences. SSB Interview Call and Selection Process The Services Selection Board (SSB) is the gateway between the written examination and your final selection. After clearing the NDA written examination, you’ll receive an SSB call letter via registered post and email within 1-2 weeks of result declaration. SSB’s Critical Role: Evaluates personality and leadership qualities in depth Assesses psychological fitness and stability Tests physical endurance and coordination abilities Determines officer-like qualities (OLQs) Conducts group discussions and team exercises The SSB interview after clearing the NDA written examination is designed to identify candidates who possess the characteristics required for military leadership. It evaluates not just academic capability, but personality, leadership potential, and overall suitability for a military career. How to Register for the NDA SSB Interview After clearing the NDA written examination, registration for the SSB interview is mandatory and time-sensitive. Candidates must register on joinindianarmy.nic.in to participate in the SSB interview. Step-by-Step Registration Process: Visit the official registration portal: joinindianarmy.nic.in Login with your credentials (roll number and password) Fill in personal and educational details accurately Select your preferred SSB centre from allotted options Upload required documents in specified formats Download and save your admission admit card Pay any applicable registration fees (if required) Important Documents for SSB Registration: 10th and 12th mark sheets (certified copies) Graduation certificate (if applicable) NDA written exam admit card and roll number Valid ID proof (Aadhar, Passport, or PAN card) Medical certificates (if any previous medical conditions) Character certificate from school or college Recent passport-size photographs (4×6 cm) Timely registration after clearing the NDA written examination is crucial, as SSB slots fill up quickly based on preference and merit. Late registration may result in allocation to less preferred centres. What Happens During the SSB Interview? The SSB interview process after clearing the NDA written examination spans five days and includes multiple assessment stages. This comprehensive evaluation includes psychological tests, group exercises, physical tasks, and personal interviews. Day-wise SSB Process Breakdown: Days 1-2: Screening and Aptitude Tests Officer Intelligence Rating (OIR) test evaluation Picture Perception and Discussion Test (PPDT) participation Communication skills evaluation and initial interviews Personal document verification Days 3-4: GTO Tasks and Psychological Tests Group discussion exercises and planning tasks Individual obstacles and physical challenges Comprehensive psychological evaluation Team-based activities and assessments Day 5: Personal Interview and Conference One-on-one interview with assessment panel Comprehensive personality discussion Final assessment and ranking determination Officer-like qualities (OLQs) final evaluation NDA SSB Screening Test The SSB screening test after clearing the NDA written examination is your first hurdle at the SSB centre. This test determines whether you proceed further in the selection process or are recommended for rejection early. Component Duration Details Officer Intelligence Rating (OIR) 20 minutes Numerical and verbal ability assessment Picture Perception & Discussion (PPDT) 60 minutes Observation and discussion skills evaluation Writing Task 30 minutes English language and creativity testing Group Discussion 30 minutes Communication and leadership assessment The screening test after clearing the NDA written examination filters out candidates who may not be suitable for military leadership, ensuring quality candidates proceed to subsequent stages. Approximately 40-50% of SSB candidates are screened out at this stage. Psychological Tests in SSB Psychological assessment is crucial after clearing the NDA written examination. These tests measure your personality traits, decision-making abilities, emotional stability, and psychological fitness for military service. Key Psychological Tests Administered: Thematic Apperception Test (TAT) – Story-telling based evaluation to assess your personality traits and motivations Word Association Test (WAT) – Personality traits assessment through word responses and thinking patterns Situation Reaction Test (SRT) – Decision-making under pressure and crisis management evaluation Self-Description Test (SDT) – Personal strengths and weaknesses identification for self-awareness These psychological tests after clearing the NDA written examination help assess whether

Best Airforce Coaching Academy in Dehradun

Related Post :

How to Build a Personal Exam Progress Dashboard in Google Sheets

Tattoo Policy for NDA, CDS and AFCAT: What’s Allowed

What Happens After Clearing the NDA Written Examination?

CDA - BEST NDA COACHING CENTRE COURSES

Useful Links

Download Corner

Student's Area