<\/span><\/h2>\n\n\n\nFirst, clear one common confusion.<\/p>\n\n\n\n
There is no “Computer” subject in the ADRE written paper. The written exam tests General English, General Mathematics, General Knowledge, Social Studies, and Logical Reasoning and Mental Ability.<\/p>\n\n\n\n
Computers appear only at the skill test stage. So the ADRE computer syllabus is really the syllabus for the Computer Skill Test.<\/p>\n\n\n\n
It is a practical test. You sit at a machine and perform tasks. There are no MCQs, no theory questions, no definitions of RAM or ROM.<\/p>\n\n\n\n
Who has to appear<\/strong><\/p>\n\n\n\nOnly Grade III (Class III) candidates take this test. Grade IV candidates do not.<\/p>\n\n\n\n
You are called only after you provisionally qualify in the written exam. That means Paper III (HSSLC level) or Paper IV (Bachelor’s Degree level).<\/p>\n\n\n\n
Candidates for stenographer and driver posts sit different skill tests. Those follow separate rules.<\/p>\n\n\n\n
<\/span>Where it fits in selection<\/strong><\/span><\/h2>\n\n\n\n\nWritten examination (OMR based, negative marking of 1\/4 mark).<\/li>\n\n\n\n Computer Skill Test \u2014 25 marks, qualifying in nature.<\/li>\n\n\n\n Document verification with originals.<\/li>\n\n\n\n Final merit list and appointment.<\/li>\n<\/ol>\n\n\n\nFail the skill test and the written score stops mattering. Treat it seriously.<\/p>\n\n\n\n
<\/span>Exam Pattern at a Glance<\/strong><\/span><\/h2>\n\n\n\nDetail<\/strong><\/td>Information<\/strong><\/td><\/tr><\/thead>Conducting body<\/td> SLRC, Assam<\/td><\/tr> Test type<\/td> Practical, hands-on<\/td><\/tr> Total marks<\/td> 25<\/td><\/tr> Software tested<\/td> MS Word, MS Excel, MS PowerPoint<\/td><\/tr> Categories<\/td> Three (I, II, III)<\/td><\/tr> Nature<\/td> Qualifying<\/td><\/tr> Applicable to<\/td> Grade III posts only<\/td><\/tr> Mode<\/td> Offline, on computers at the centre<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nReported durations vary across coaching sources, from roughly 25 to 45 minutes. Do not rely on that figure from third-party sites. The exact duration is printed on the official notice and admit card.<\/p>\n\n\n\n
Machines and software are provided at the centre. Personal laptops, phones, pen drives and external storage are not allowed inside.<\/p>\n\n\n\n
<\/span>The Three Categories Explained<\/strong><\/span><\/h2>\n\n\n\nThe ADRE computer syllabus is split by the minimum qualification of the post you applied for. Same three applications, three difficulty levels.<\/p>\n\n\n\nCategory<\/strong><\/td>Minimum qualification for the post<\/strong><\/td>Level<\/strong><\/td><\/tr><\/thead>Category I<\/td> HSSLC \/ HSSLC in Science<\/td> Basic<\/td><\/tr> Category II<\/td> Bachelor’s Degree in any stream<\/td> Intermediate<\/td><\/tr> Category III<\/td> Bachelor’s Degree plus a computer certificate or diploma of at least 6 months, or a Library Science degree with similar certification<\/td> Advanced<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nIdentify your category before you open a single tutorial. Preparing at the wrong level wastes weeks.<\/p>\n\n\n\n
<\/span>Category I Syllabus: HSSLC Level (Basic)<\/strong><\/span><\/h2>\n\n\n\nThis level tests whether you can produce a clean, printable file without help.<\/p>\n\n\n\n
<\/span>MS Word<\/strong><\/span><\/h3>\n\n\n\n\nCreate a new document and save it in the format asked for<\/li>\n\n\n\n Basic formatting: bold, italic, underline, font type, size and colour<\/li>\n\n\n\n Paragraph alignment: left, centre, right, justify<\/li>\n\n\n\n Cut, copy, paste, undo and redo<\/li>\n\n\n\n Find and Replace<\/li>\n\n\n\n Page setup: margins, paper size, orientation<\/li>\n\n\n\n Insert page numbers and simple headers and footers<\/li>\n\n\n\n Line and paragraph spacing<\/li>\n\n\n\n Spell check<\/li>\n\n\n\n Print with basic settings<\/li>\n<\/ul>\n\n\n\n<\/span>MS Excel<\/strong><\/span><\/h3>\n\n\n\n\nEnter data into a new worksheet<\/li>\n\n\n\n Move between workbooks and worksheets<\/li>\n\n\n\n Basic formulae: SUM, AVERAGE, MIN, MAX<\/li>\n\n\n\n Arithmetic operators in cells<\/li>\n\n\n\n Cell formatting: font, borders, fill<\/li>\n\n\n\n Column width and row height<\/li>\n\n\n\n Text alignment, merge and centre<\/li>\n\n\n\n Insert and delete rows and columns<\/li>\n\n\n\n Sort data A\u2013Z and Z\u2013A<\/li>\n\n\n\n Set print area and print the sheet<\/li>\n<\/ul>\n\n\n\n<\/span>MS PowerPoint<\/strong><\/span><\/h3>\n\n\n\n\nCreate a presentation and add slides<\/li>\n\n\n\n Choose and change slide layouts<\/li>\n\n\n\n Add and format text in placeholders<\/li>\n\n\n\n Apply a theme or design template<\/li>\n\n\n\n Insert images and basic shapes<\/li>\n\n\n\n Align objects on a slide<\/li>\n\n\n\n Slide numbering and simple transitions<\/li>\n\n\n\n Run the slideshow<\/li>\n\n\n\n Save and print as slides, handouts or notes pages<\/li>\n<\/ul>\n\n\n\n<\/span>Category II Syllabus: Bachelor’s Degree Level (Intermediate)<\/strong><\/span><\/h2>\n\n\n\nEverything in Category I still applies. These topics sit on top. The ADRE computer syllabus widens sharply at this level, especially in Excel.<\/p>\n\n\n\n
<\/span>MS Word<\/strong><\/span><\/h3>\n\n\n\n\nApply predefined heading and body styles<\/li>\n\n\n\n Insert and edit tables: merge cells, resize columns, apply table styles<\/li>\n\n\n\n Advanced headers and footers with page numbers and date<\/li>\n\n\n\n Insert images with text wrapping<\/li>\n\n\n\n Section breaks and multi-column layouts<\/li>\n\n\n\n Page numbering across sections<\/li>\n\n\n\n Track Changes and Comments<\/li>\n\n\n\n Hyperlinks and bookmarks<\/li>\n\n\n\n Custom print settings such as page ranges and duplex printing<\/li>\n<\/ul>\n\n\n\n<\/span>MS Excel<\/strong><\/span><\/h3>\n\n\n\n\nNumber formatting: currency, percentage, date<\/li>\n\n\n\n Conditional formatting rules<\/li>\n\n\n\n IF, VLOOKUP and HLOOKUP<\/li>\n\n\n\n COUNT, COUNTA, COUNTIF and SUMIF<\/li>\n\n\n\n Data validation, including drop-down lists<\/li>\n\n\n\n Freeze panes<\/li>\n\n\n\n Basic charts: column, bar, pie<\/li>\n\n\n\n AutoFilter and multi-level sorting<\/li>\n\n\n\n Named ranges<\/li>\n\n\n\n Print titles, repeat header rows, scale to fit<\/li>\n<\/ul>\n\n\n\n<\/span>MS PowerPoint<\/strong><\/span><\/h3>\n\n\n\n\nSlide transitions with timing<\/li>\n\n\n\n Entrance and exit animations<\/li>\n\n\n\n SmartArt graphics<\/li>\n\n\n\n Tables and charts inside slides<\/li>\n\n\n\n Slide Master for consistent design<\/li>\n\n\n\n Custom layouts, such as two-column text with image<\/li>\n\n\n\n Duplicate, reorder and hide slides<\/li>\n\n\n\n Speaker notes<\/li>\n\n\n\n Print handouts and notes pages<\/li>\n<\/ul>\n\n\n\n<\/span>Category III Syllabus: Degree Plus Diploma (Advanced)<\/strong><\/span><\/h2>\n\n\n\nThis is the toughest level. The ADRE computer syllabus here assumes formal computer training.<\/p>\n\n\n\n
<\/span>MS Word<\/strong><\/span><\/h3>\n\n\n\n\nMultilevel heading styles applied consistently<\/li>\n\n\n\n Automatic Table of Contents, inserted and updated<\/li>\n\n\n\n Cross-references to headings, tables and figures<\/li>\n\n\n\n Large tables: merge and split cells, complex borders<\/li>\n\n\n\n Customised multilevel numbered and bulleted lists<\/li>\n\n\n\n Detailed character formatting and text effects<\/li>\n\n\n\n Footnotes, endnotes and citations<\/li>\n\n\n\n Advanced print options, including printing comments and markup<\/li>\n\n\n\n Document protection and editing restrictions<\/li>\n<\/ul>\n\n\n\n<\/span>MS Excel<\/strong><\/span><\/h3>\n\n\n\n\nPivotTables and PivotCharts: grouping, filtering, value field settings<\/li>\n\n\n\n INDEX-MATCH along with VLOOKUP and HLOOKUP<\/li>\n\n\n\n Nested IF, with AND and OR<\/li>\n\n\n\n Text functions: LEFT, RIGHT, MID, CONCATENATE, TRIM<\/li>\n\n\n\n Date functions: TODAY, NOW, DATEDIF<\/li>\n\n\n\n Convert a range into an Excel Table and style it<\/li>\n\n\n\n Formula-based conditional formatting and colour scales<\/li>\n\n\n\n Dependent drop-down lists<\/li>\n\n\n\n Advanced and combination charts with data labels and axis titles<\/li>\n\n\n\n Worksheet and workbook protection<\/li>\n\n\n\n Linking data across sheets<\/li>\n<\/ul>\n\n\n\n<\/span>MS PowerPoint<\/strong><\/span><\/h3>\n\n\n\n