ADRE Computer Syllabus 2026

The ADRE computer syllabus covers the practical computer skills required for the Computer Skill Test for applicable Grade III posts. The test focuses on hands-on proficiency in MS Word, MS Excel, and MS PowerPoint, with the difficulty level varying according to the candidate’s qualifying educational category. Candidates preparing for competitive examinations in Assam can also explore CAT coaching in Assam for structured preparation, expert guidance, and regular practice support.

What Is the ADRE Computer Skill Test?

The ADRE computer syllabus covers the practical computer skills required for the Computer Skill Test for applicable Grade III posts. The test focuses on hands-on proficiency in MS Word, MS Excel, and MS PowerPoint, with the difficulty level varying according to the candidate’s qualifying educational category. Candidates preparing for competitive examinations in Assam can also explore CAT coaching in Assam for structured preparation, expert guidance, and regular practice support.

Particular	Details
Test Type	Practical, hands-on
Total Marks	25
Duration	45 minutes
Mode	Computer-based practical test
Applications	MS Word, MS Excel, and MS PowerPoint
Categories	3
Applicable To	Grade III posts, as specified for the relevant recruitment

What Is the Selection Process After the Written Examination?

The Computer Skill Test comes after the applicable written examination for shortlisted candidates. The selection process can broadly involve the following stages: Check Assam Direct Recruitment details to understand the selection stages, eligibility requirements, examination pattern, and other important updates before beginning your preparation.

1. Written Examination: Candidates appear for the applicable Grade III written paper.
2. Computer Skill Test: Shortlisted candidates demonstrate practical computer skills.
3. Document Verification: Required educational and other documents are verified.
4. Final Selection: Candidates are considered for the final merit and appointment according to the applicable recruitment rules.

Candidates should check the official SLRC notification for the exact selection stages and whether the skill-test marks are counted in final merit for their particular post.

What Are the Three Categories in the ADRE Computer Skill Test?

The ADRE computer syllabus is divided into three levels according to the minimum educational qualification associated with the post.

Category	Minimum Qualification	Difficulty Level	Applications	Marks
Category I	HSSLC / HSSLC in Science	Basic	Word, Excel, PowerPoint	25
Category II	Bachelor’s Degree	Intermediate	Word, Excel, PowerPoint	25
Category III	Bachelor’s Degree + Computer Certificate/Diploma or applicable Library Science qualification with computer certification	Advanced	Word, Excel, PowerPoint	25

The same three applications are used across the categories, but the complexity of the practical tasks increases from Basic to Intermediate and Advanced.

What Is the Category I ADRE Computer Syllabus?

Category I is designed around basic MS Office operations. Candidates should be comfortable creating documents, entering spreadsheet data, and preparing simple presentations. Before appearing for the examination, candidates should also check ADRE 3.0 Eligibility, Age Limit and other prescribed requirements to ensure they meet the conditions for the relevant post.

MS Word – Basic

• Create and save a new document
• Bold, italic, and underlined text
• Change font size and formatting
• Align paragraphs
• Copy, cut, and paste text
• Use Find and Replace
• Set margins, paper size, and orientation
• Insert page numbers
• Add basic headers and footers
• Use spell and grammar checking
• Adjust line and paragraph spacing
• Print a document using basic settings

MS Excel – Basic

• Create a worksheet
• Enter and edit data
• Format cells
• Apply borders
• Adjust row height and column width
• Use basic arithmetic operations
• Use SUM, AVERAGE, MIN, and MAX
• Merge and center cells
• Insert and delete rows or columns
• Sort data
• Align cell contents
• Print a worksheet using basic settings

MS PowerPoint – Basic

• Create a presentation
• Add and edit slides
• Enter text in placeholders
• Format text
• Apply themes and slide designs
• Change slide layouts
• Insert images and shapes
• Align objects and text
• Add slide numbers
• Apply basic transitions
• Run a slideshow
• Save and print the presentation

What Is the Category II ADRE Computer Syllabus?

Category II requires intermediate MS Office skills. Candidates should be able to perform all relevant basic operations and handle more advanced formatting, formulas,, and presentation features.

MS Word – Intermediate

• Apply heading and paragraph styles
• Create and format tables
• Merge cells and adjust table widths
• Use advanced headers and footers
• Insert and align images
• Apply text wrapping
• Use section breaks
• Create multi-column layouts
• Configure page numbering
• Use Track Changes and Comments
• Insert hyperlinks and bookmarks
• Apply advanced print settings
• Understand basic mail merge

MS Excel – Intermediate

• Apply number formats
• Use currency, percentage, and date formats
• Apply conditional formatting
• Use IF functions
• Use VLOOKUP and HLOOKUP
• Use COUNT, COUNTA, and COUNTIF
• Use SUMIF
• Apply Data Validation
• Create dropdown lists
• Freeze panes
• Create basic charts
• Sort and filter data
• Set print areas
• Use named ranges

MS PowerPoint – Intermediate

• Apply slide transitions with timing
• Use entrance and exit animations
• Insert SmartArt
• Create tables and charts
• Insert images, icons, and shapes
• Modify the Slide Master
• Rearrange and hide slides
• Add speaker notes
• Set automatic slide timings
• Print handouts and note pages

What Is the Category III ADRE Computer Syllabus?

Category III represents the advanced level. Candidates should be prepared for more complex Word, Excel, and PowerPoint operations in addition to the skills covered at the lower levels.

MS Word – Advanced

• Modify multilevel heading styles
• Create and update a table of contents
• Insert cross-references
• Work with complex tables
• Create multilevel numbered and bulleted lists
• Apply detailed character formatting
• Configure advanced printing options
• Insert footnotes and endnotes
• Work with citations
• Use field codes and document properties
• Apply document protection

MS Excel – Advanced

• Create and modify pivot tables
• Use VLOOKUP and HLOOKUP
• Use INDEX-MATCH
• Create nested IF formulas
• Apply logical functions
• Use LEFT, RIGHT, MID, and CONCATENATE
• Use TRIM
• Work with TODAY and NOW
• Use date-related functions
• Convert ranges into Excel tables
• Create advanced charts
• Use formula-based conditional formatting
• Protect worksheets and workbooks
• Link data between worksheets

MS PowerPoint – Advanced

• Design presentations using Slide Master
• Create multiple custom layouts
• Use advanced SmartArt
• Create animation sequences
• Use animation triggers and motion paths
• Add hyperlinks between slides
• Insert video and audio
• Insert Excel charts
• Export presentations as PDF or video
• Create custom slide shows
• Use Action Buttons
• Rehearse timings
• Record narration

What Is the Difference Between the Three Computer Skill Categories?

The main difference is the level of computer proficiency expected.

Skill Area	Category I	Category II	Category III
Word	Basic formatting	Styles, tables, sections	TOC, cross-references, advanced formatting
Excel	Basic formulas	IF, VLOOKUP, charts	Pivot Tables, advanced lookups, complex formulas
PowerPoint	Basic slides and transitions	SmartArt and animations	Slide Master, advanced animations and navigation
Overall Level	Basic	Intermediate	Advanced

Therefore, candidates should first identify the category applicable to their post before beginning intensive preparation.

What Documents Should Candidates Carry to the Skill Test?

Candidates should carefully follow the instructions printed on their skill-test admit card and official notice. Depending on the recruitment instructions, candidates may need documents such as:

• Skill Test Admit Card
• Valid photo ID
• Written examination admit card
• Educational qualification certificates
• Computer certificate or diploma, where applicable
• Library Science qualification certificate, where applicable
• Recent photographs, if specified

Do not rely on a general document list alone. The admit card and official SLRC instructions should be treated as the final checklist.

How Can You Approach the ADRE Computer Syllabus?

Practise MS Office Every Day

This is a practical test, so reading computer theory alone will not be enough. Open Word, Excel, and PowerPoint and perform actual tasks regularly.

Practice According to Your Category

Do not spend most of your preparation time on advanced Excel functions if your post requires only the basic level. First master every skill applicable to your category.

Use a Timer

Since the complete test is time-bound, practice completing a combination of Word, Excel,, and PowerPoint tasks under a fixed time limit.

Learn Keyboard Shortcuts

Common shortcuts can save valuable time.

For example:

• Ctrl + C: Copy
• Ctrl + V: Paste
• Ctrl + X: Cut
• Ctrl + Z: Undo
• Ctrl + S: Save
• Ctrl + B: Bold
• Ctrl + I: Italic
• Ctrl + U: Underline
• Ctrl + H: Find and Replace in Word

Practice Excel Functions

Candidates in the intermediate and advanced categories should spend extra time practising functions such as IF, VLOOKUP, HLOOKUP, and other functions included in their preparation level.

Take Full-Length Practice Tests

At least once or twice a week, simulate the practical test. Open the required applications, set a timer,, and complete tasks without outside assistance.

What Are the Common Mistakes While Approaching the ADRE Computer Syllabus?

Candidates often make the mistake of preparing only through theoretical notes. Since the examination is practical, actual computer practice matters more.

Avoid:

• Practicing only one application
• Ignoring Excel
• Learning shortcuts without using them
• Preparing at the wrong difficulty level
• Never practicing under time pressure
• Ignoring typing accuracy
• Waiting until the last few days to practice
• Depending entirely on video tutorials without performing the tasks yourself

Conclusion

The ADRE computer syllabus focuses on practical proficiency in MS Word, MS Excel, and MS PowerPoint. Candidates should first identify the category applicable to their post and then prepare the corresponding basic, intermediate, or advanced skills. Most importantly, practice directly on a computer rather than relying only on theory. Regular timed practice, familiarity with Word, Excel, and PowerPoint, and attention to accuracy can help candidates become more comfortable with the practical test. Since ADRE 3.0 details may be updated through the official notification, candidates should always verify the final syllabus, eligibility, test structure, and selection rules before the examination.

Frequently Asked Questions

What is the duration of the ADRE Computer Skill Test?

The supplied pattern specifies a total duration of 45 minutes for the Computer Skill Test. Candidates should practise completing Word, Excel, and PowerPoint tasks within this overall time. Any exact sectional allocation should be confirmed from the official instructions.

How many marks does the ADRE Computer Skill Test carry?

The Computer Skill Test is described as a 25-mark practical test. The exact treatment of these marks in final selection should be checked against the official recruitment notification applicable to the candidate’s post.

Which applications are tested in the ADRE Computer Skill Test?

The ADRE computer syllabus covers MS Word, MS Excel, and MS PowerPoint. The difficulty increases across Category I, Category II and Category III.

What is the difference between Category I, II and III?

Category I focuses on basic MS Office operations and is associated with HSSLC-level eligibility. Category II requires intermediate skills for degree-level eligibility. Category III tests advanced operations for the applicable degree-plus-computer qualification category.