ADRE Stage 2 Computer Skill Test: Complete Practical Syllabus, Typing Speed Thresholds & MS Office Testbed Guide
Qualifying the ADRE written test is only half the battle. Master the 25-mark Stage 2 Computer Skill Test: English & Assamese typing speeds, MS Word tables, Excel formulas, and PowerPoint layouts.
- The ADRE Stage 2 Computer Skill Test carries 25 marks and is strictly qualifying and rank-determining for Grade III administrative, junior assistant, and field posts.
- The test evaluates four core areas: English/Assamese typing speed and accuracy, MS Word official document drafting, MS Excel functions (SUM, AVERAGE, IF, VLOOKUP), and MS PowerPoint slide transitions.
- Candidates frequently fail due to unfamiliarity with standard keyboard layouts (InScript vs. phonetic fonts) and unformatted tables under timed pressure.
- Mentora provides a live in-browser Stage 2 practical simulator with real-time metronomes and typing metrics.
Why Stage 2 Is the True Filter of the ADRE Merit List
When the written results of the Assam Direct Recruitment Examination (ADRE) are declared, thousands of candidates rejoice at crossing the cutoff marks.
However, for Grade III posts—including Junior Assistants, Field Assistants, LDA, and Statistical Assistants—the written test is only Stage 1.
Waiting on the other side is the 25-Mark Stage 2 Computer Skill Test.
Every recruitment cycle, approximately 15% to 20% of high-scoring written candidates are disqualified or pushed to the bottom of the district merit list simply because they treated the computer practical as an afterthought.
In this operational guide, we dissect the complete official syllabus, analyze the exact marking parameters for typing and MS Office, and provide hands-on practice templates to guarantee full marks in Stage 2.
1. Exam Structure & Distribution of Marks
The Stage 2 examination is a hands-on laboratory assessment conducted in designated computer institutes across Assam. Candidates are allotted individual desktop workstations connected to a closed local testing network.
| Component | Allotted Marks | Core Competencies Tested | Time Allotted |
|---|---|---|---|
| Part A: Typing Speed & Accuracy | 10 Marks | English typing (30–35 WPM) & Regional Script (Rodali / InScript / Avro) | 10 Minutes |
| Part B: MS Word Drafting | 5 Marks | Official letter drafting, table formatting, bulleted hierarchy, headers/footers | 10 Minutes |
| Part C: MS Excel Data Processing | 5 Marks | Tabular calculation, SUM, AVERAGE, IF statements, currency formatting | 10 Minutes |
| Part D: MS PowerPoint Presentation | 5 Marks | Slide layouts, inserting shapes/tables, bullet transitions, speaker notes | 10 Minutes |
| Total | 25 Marks | Comprehensive Practical Evaluation | 40–45 Mins |
2. Part A: Mastering Typing Speed and Keyboard Layouts
Typing is the primary stumbling block for aspirants who only practice on smartphone glass keyboards.
Key Performance Thresholds:
- English Typing: Aim for a consistent 35 Words Per Minute (WPM) with 95%+ accuracy.
- Assamese / Regional Typing: Familiarize yourself with standard keyboard inputs (InScript keyboard or Rodali phonetic layout). A speed of 20–25 WPM ensures comfortable completion of the assigned paragraph.
Common Deductions:
- 1.Backspacing Habit: Repeatedly using backspace drains seconds. Maintain forward momentum; small typographical slips cost less than leaving the final 40 words un-typed.
- 2.Punctuation Blindspots: Exam passages intentionally include semicolons, double quotes, hyphens, and numeric figures. Practice typing passages containing numerical dates and acronyms.
3. Part B, C & D: The MS Office Practical Playbook
1. MS Word Official Drafting (5 Marks)
You will receive a printed specimen memo or government circular that you must replicate inside MS Word with pixel-perfect alignment.
- Top Margins: Aligning department headers centrally.
- Table Insertion: Creating 4-column tables with shaded header rows.
- Line Spacing & Justification: Setting paragraph alignment to
Ctrl + J(Justified) with 1.15 line spacing.
2. MS Excel Data Analysis (5 Marks)
The Excel section tests whether you can handle payroll data, student ledgers, or district budget statistics:
- Core Functions to Master:
=SUM(B2:B20)(Total expenditure calculation)=AVERAGE(C2:C20)(Mean performance benchmark)=IF(D2>=40, "Pass", "Fail")(Logical condition checks)=ROUND(E2, 2)(Truncating decimal precision)- Formatting: Applying grid borders, centering numeric columns, and setting header rows to bold.
3. MS PowerPoint Slide Architecture (5 Marks)
Candidates are instructed to create a 3-slide deck on an assigned theme (such as Green Energy in Assam or Digital Governance Initiatives):
- Slide 1: Title slide with candidate roll number as subtitle.
- Slide 2: Content slide with 4 bullet points and an inserted 2x2 comparison table.
- Slide 3: Conclusion slide with formatted callout shape.
4. How to Practice Live on Mentora
To bridge the gap between theory and execution, Mentora provides a dedicated Stage 2 Computer Skill Practical Testbed:
- Real-Time Typing Engine: Measures live WPM, accuracy percentages, and backspace counts under a 10-minute countdown timer.
- Interactive Excel & Word Templates: Practice realistic government formatting scenarios with instant visual comparison overlays.
- Bilingual Font Guides: Step-by-step setup instructions for Assamese InScript and Rodali typing on Windows 10/11.
What is the minimum typing speed required for ADRE Stage 2?
While the commission assesses composite accuracy and speed, candidates should comfortably achieve at least 30 to 35 words per minute (WPM) in English with 95%+ accuracy, and 20 to 25 WPM in Assamese/Bengali typing.
Which software version is used during the ADRE Computer Skill Test?
Exam centers generally use Microsoft Office (Office 2013, 2016, or 2019) running on Windows 10/11 desktops. Familiarity with standard ribbon navigation is essential.
What formulas are tested in the MS Excel practical component?
Commonly evaluated formulas include SUM, AVERAGE, COUNT/COUNTA, IF conditions, percentage calculations, cell formatting, borders, and basic sorting/filtering.
Learn this in our ADRE Grade III (Bachelor's & HSSLC)
150-Question SLRC model battery with 2-mark reading comprehension questions (-0.50 penalty) and 12-archetype reasoning drills.