One ecosystem for career clarity and government-exam successOne ecosystem for career clarity and government-exam successExplore
DHRIONDirection · Learning · Progress
Andhra Pradesh · Other APPSC Posts

Telugu Reporter 2026

Eligibility, application dates, pay and the official examination syllabus.

Notification status2026 brief · 22/2026
Editorially checked16 September 2026
ENTRYEligibilityGROWTHService rulesLEGISLATIVE REPORTINGTR22/2026OTHER APPSC POSTS
ROLE FOCUSDebate · transcript · Telugu
Role profile · eligibility · syllabus · career growth
On this pageQualifications and special conditionsAge, fees, reservations and other pending detailsPrevious-notification referenceHow to applySourcesSyllabus — Telugu Reporter
Provisional vacancies1Subject to confirmation
Notification22/2026Brief issued 15 Sep 2026
Applications close02 Nov2026 · 11:59 p.m.

Content status: Source-backed brief-notification draft. Final detailed-notification fields remain open.

APPSC has issued Brief Notification 22/2026 for Telugu Reporter. Applications are scheduled from 2026-10-13 to 2026-11-02 (11:59 PM). The published pay scale is Rs 57,100 – 147,760.

Detail Published information
Notification 22/2026; dated 15 September 2026
Department/service A.P. Legislature Services
Vacancies 1
Pay scale Rs 57,100 – 147,760
Application opens 2026-10-13
Application closes 2026-11-02 at 11:59 PM
Detailed notification expected On or before 2026-10-13

1 carried-forward vacancy.

01

Qualifications and special conditions

A bachelor’s degree from a recognised university under the recognition/equivalence wording in the brief notification. Telugu Shorthand and Typewriting, both Higher Grade, plus the prescribed practical Telugu Shorthand test at 80 wpm. Higher general education and English Shorthand/Typewriting Higher Grade receive the stated preferences.

The brief states that the detailed-notification date is the crucial date. Where it supplies a qualification clause, that clause and its recognition/equivalence provisions control.

02

Age, fees, reservations and other pending details

The downloaded 2026 brief does not provide the complete rules below. These fields are awaiting the detailed notification; no values have been invented.

  • 2026 minimum/maximum age, age reference date and relaxation rules
  • 2026 application/examination fees and exemptions
  • 2026 category, zone/local and gender reservation roster
  • Examination date and admit-card schedule
  • Final certificate checklist and complete application instructions
  • Subsequent corrigenda and detailed notification reconciliation
  • A matched previous detailed notification has not been recovered
03

Previous-notification reference

No matched previous detailed notification was recovered for this specific post.

04

How to apply

Use the official APPSC website during the application window. Read the detailed notification, confirm eligibility, and follow the official registration, application, fee and document instructions. The brief requires online applications; do not treat a generic portal link as an active post-specific application link.

APPSC official website

05

Sources

2026 brief notification and annexures

Source download and content extraction: 16 September 2026. Source pages 1-3 provide the recruitment clauses; later pages contain the scheme and syllabus.

Syllabus — Telugu Reporter

Current official source: 22/2026. Use the post-specific papers and any optional-subject provisions in the annexure.

General Studies & Mental Ability: 150 questions, 150 minutes, 150 marks. Telugu dictation at 80 wpm for 10 minutes (800 words); longhand transcription: 150 minutes, 150 marks. Total 300. The annexure also includes the Computer Proficiency Test scheme.

Open official syllabus PDF ↗

Read the complete source text below. It is organised by official PDF page; use the PDF for equations, diagrams and original table alignment.

Official annexure · page 4
ANNEXURE
SCHEME OF EXAMINATION TO THE POST OF ENGLISH REPORTERS IN
A.P. LEGISLATURE SERVICE

SCHEME OF THE EXAMINATION
G.O.Ms.No.562(Ser-A Department, Dt:13.03.2019 and
G.O.Ms.No.33, G.A(Ser-A) Department, Dated:10.03.2023
Written Examination (Objective Type Conventional type Degree standard)
PAPERS
Subject
No. of
Questions
Duration
in
Minutes
Maximum
Marks
Paper-I
General Studies &
Mental Ability 150
150
Minutes
150
Paper-II
(Conventional
Type)
Dictation in English
Shorthand
150 Words Per Minute.
– 05
Minutes
150
Transcription in
Longhand – 90
Minutes
TOTAL 300
Note: 1. Shorthand (English) 150 words per minute. The examination is
intended to test the candidates’ capacity for accurate, verbatim,
reproduction of a passage consisting of 750 words dictated at the rate
of 150 words in 05 minutes.
2. As per G.O.Ms. No.235 Finance (HR -1, Plg & Policy) Dept, Dt:
06/12/2016, each wrong answer will be penalized with 1/3 rd of the
marks prescribed for the question in all objective type papers.

Official annexure · page 5
SYLLABUS

GENERAL STUDIES AND MENTAL ABILITY

1. Major Current Events and Issues pertaining to International, National
and State of Andhra Pradesh.
2. General Science and its applications to the day to day life
Contemporary developments in Science & Technology and Information
Technology.
3. History of India – emphasis will be on broad general understanding of
the subject in its social, economic, cultural and political aspects with a
focus on AP and Indian National Movement.
4. Geography of India with focus on Andhra Pradesh.
5. Indian polity and Governance: constitutional issues, public policy,
reforms and e-Governance initiatives.
6. Indian Economy and planning
7. Sustainable Development and Environmental Protection
8. Disaster management: vulnerability profile, prevention and mitigation
strategies, Application of Remote Sensing and GIS in the assessment of
Disaster
9. Logical reasoning, analytical ability and logical interpretation.
10. Data Analysis: Tabulation of data Visual representation of data Basic
data analysis (Summary Statistics such as mean, median, mode and
variance) and Interpretation.

PAPER – II

Shorthand (English) 150 words per minute. The examination is
intended to test the candidate’s capacity for accurate, verbatim,
reproduction of a passage consisting of 750 words dictated at
the rate of 150 words in 05 minutes.

Official annexure · page 6
SCHEME & SYLLABUS OF THE COMPUTER PROFICIENCY TEST
(CPT)
Scheme for Computer Proficiency Test
(As per G.O.Ms.No.26, G.A. (Ser.B) Dept., dt: 24.02.2023)
Scheme of the examination (Practical Type)
Test Duration
(Minutes)
Maximum
Marks
Minimum Qualifying Marks
SC/ST/PBD B.C’s O.C’s
Proficiency in Office
Automation with usage of
Computers and
Associated Software.
60 100 30 35 40

Syllabus for Computer Proficiency Test
PART-A

1. INTRODUCTION TO COMPUTERS: Introduction to Computers –
Components and their classification – Peripheral devices and
their purpose. Input Devices – Keyboard, Mouse, Scanner,
Lighten, Touch screens, Joystick, Micro phone, Scanner, Digital
camera, Bar code reader, Biometric sensor. Out put Devices:
Display devices, Printers, Monitor, Speaker, Plotter, Secondary
Storage Devices – Feature- Driven Development (FDD), Magnetic
tape, Universal Serial Bus(USB), Pen Drives, Disks – The Role of
input Processing / output processing devices – Computing
Concepts – Data – Information – Random – Access Memory (RAM)
– Read-Only Memory(R OM) – Control Unit – Memory Unit –
Arithmetic Logic Unit(ALU).

2. COMPUTER SOFTWARE TYPES: System Software, Application
Software, Embedded software, Proprietary Software, Open source
software (their purpose and characteristics only).

Official annexure · page 7
3. OPERATING SYSTEM: Purpose of operating sy stem, Single User
and Multi User Operating Systems with Examples.

4. WINDOWS OPERATING SYSTEM: Interfacing Graphical User
Interface (GUI), Differences b etween Character User Interface
(CUI) and Graphical User Interface(GUI) – working With Files and
Folders – More About Files – Running An Application Through the
File Manager – Running an Application Through the Program
Manager – Setting up of Printer, Webc am, Scanner and other
peripheral devices.

5. LINUX/MAC OS (only basic concepts): Introduction to Linux –
Features and advantages of Linux, File handling commands,
directory handling commands – User Management – File
permissions Macintosh Apple Computer (MAC) OS – Introduction
– Advantages of Macintosh Apple Computer (MAC) OS. Basics
commands

6. INTERNET CONCEPTS (only basic concepts): Minimum
Hardware a nd Software Requirements for a system to use
internet, Communication Protocols and Facilities – Various
browsers – What is Internet Protocol (IP) Address – Steps required
in connecting sys tem to network – Uploading and Downloading
Files from Internet

7. ELECTRONIC MAIL (only basic concepts): Sending and
receiving mails, Basic E -Mail Functions, Using your word
processor for E -mail, Finding E -Mail Address, Mailing Lists and
lists Servers.

8. WORLD WIDE WEB (only basic concepts): WWW advantages of
the Web – how to navigate with the Web – Web Searching.

Official annexure · page 8
PART – B
1. OFFICE SUITE : MSOFFICE or any open source office like Libre
Office /Apache Open Office Neo office for
Windows/Linux/Macintosh Apple Computer (MAC)OS.

2. GETTING STARTED WITH OFFICE: Introduction to Office
Software- Starting and Exiting the Office Applications –
Introducing the Office Shortcut Bar – Customizing Office
Shortcut Bar.

3. FILE OPERATIONS IN THE OFFICE: Common Office Tools and
Techniques – Opening An Application – Creating Files – Entering
And Editing Text – Saving Files – Opening Files – Closing a File –
Exiting The Application – Managing Your files With the Office
Applications.

4. TOOLS IN THE OFFICE APPLICATIONS: Key Combinations –
Cut, Copy and Paste – Drag And Drop Editing – Menu Bars And
Toolbars – Undo and – Redo – Spell Checking – Auto Correct –
Find and Replace – Help And The Office Assistants – Templates
and Wizards.

5. WORD PROCESSING (MS WORD or its equivalent in Libre
office /Apache Open Office / Neo office for
Windows/s/Linux/Mac OS): Starting Word
 Title Bar – Menu Bar – Format Bar – Standard Bar – Ruler –
Workspace Area – Scroll Bar – Status Bar – Different Toolbars –
Option a Menu Bar – Creating New Document When Word is
Running – Opening Pre existing Documents When Word is
Running – Designing Your Document – Typing Text – Selection
text – Deleting Text – Formatting text and document – copying
and moving – Saving Document – Page Setup – Properties of a
document – Undo-Redo-Cut-Copy a Document – Pasting a
Document – Print Preview – Printing – Select All – Find – Replace –
Go To – Four Different View Of A Document – Normal, Web
Layout, Print Layout, and Outline Layout – Document Map – Full
Screen – Zoom – Objects – Page Break – Header and Footer – Page
Number – Auto Format – Auto Text – Inserting Date A nd Time –
Working With Header, Footers -footnotes-Fields-Symbols-Caption

Official annexure · page 9
Cross Reference -Index-Tabs-Table and Sorting – Working With
Graphics – Inserting Pictures – Modifying Pictures – Word Art –
Inserting Chart – Inserting Files – Hyper Linking – Bookmark –
Using Different Fonts – Paragraph – Bullets Borders and
Shading-Columns-Drop Cap -Theme-Change Case Background –
Frames-Style-Spelling And Grammar – Set Language – Word
Count – Auto Summarize – Auto Correct – Merge Document –
Protect Document – Envelopes And Labels – – Templates, Wizards
And Sample Documents – drawing Tables – Merge Cell – Spilt
Cells – Spilt Table – Table Auto Format – Auto Fit – Sort – Formula
– Arrange All -Split- Micro Soft Word Help – Macros – Custom
Toolbars – Keyboard Shortcuts – Menus – Mail Merge.

6. SPREAD SHEET (MS Excel or its equivalent in Libre Office /
Apache Open Office / Neo office for Windows/Linux/Mac OS) :
Features Of Excel – Excel worksheet – Selecting Cell – Navigating
With The Mouse And Keyboard – Entering And Editing Text – Text
Boxes – Text Notes – Checking Spelling – Undoing And Repeating
Action – Entering And Editing Formulas – Referencing Cells –
Order Of Evolution in Formulas – Copying Entries And Equations
To Minimize Typing – More Auto Fill Examples – Creating Custom
Fill Lists Protecting And Un Protecting Documents And Cell –
Creating A New Worksheet – Excel Formatting Tips And
Techniques – Moving cell – Copying Cells – Sorting Cell Data –
Insertion Cells Inserting As You Paste – Deleting Parts Of
Worksheet – Clearing Parts Of A Worksheet – Excel Page Setup –
Changing Column Width And Row Heights – Auto Format –
Manual Formatting – Using style – Format Code Alter A Number’s
Appearance – Format Painter Speeds -Up Format Copying –
Changing Font Size And Attribute s – Adjusting Al ignments –
Cantering Text Across Column – Using Border Buttons And
Commands – Changing Color And Shading – Inserting And
Removing Page Breaks – Hiding Rows And Columns –
Rearranging Worksheet – Entering Formula – Excel Functions –
Inserting Rows A nd Columns – Saving A Worksheet – Printing A
Worksheet – Printing Tips For Large Excel Project – Parts Of A
Function – Functions Requiring Add -ins – Function Wizard –
Example Of Functions By Category – Organizing Your Data –
Excel’s Chart Features – Chart Parts And Terminolo gy – Instant
charts with The chart wizard – Creating Chart On Separating
Worksheets – Resizing And Moving Charts – Adding Chart Notes

Official annexure · page 10
And Arrows – Editing Charts – Rotating 3 -D Charts – Printing
Charts – Deleting Charts Setting The Defau lt Chart Type –
Creating Trend Lines Data Map – Working With Graphics in Excel
– Creating And Pacing Graphic objects – Resizing Graphs –
Possible Sources Of Excel Graphics – Creating and Running
Macro – Sorting Excel Data – Adding Subtotals To Databases –
Customizing Excel – Customizing Workspace – Comma Separated
Value (CSV) File format – Using Worksheet As Databases.

7. PRESENTATION SOFTWARE (MS Power Point or its
equivalent in Libre Office/Apache Open office /Neo office for
Windows/Linux/Mac Os): Introduction – Starting Presentation
Software – Views in Presentation Software – Slides – Terminology –
Color Schemes – Formatting Slides – Creating a Presentation –
Using the Auto Content Wizard – Masters- – Using a Template –
Creating a Blank Presentation – Working with Text in Power Point
– Adding Slides Editing And Working Text – Working in Outlaying
view – Spell checking – Finding And Replacing Text – Formatting
Text – Aligning Text – Developing Your Presentation –
Importing images From The Outside Wor ld – The Clipart Gallery –
Drawing in Presentation software – Bringing A Presentation to Life
– Inserting Objects in Your Presentation – Inserting A Picture –
Working With Graphics – Multimedia in Power Point – Animating
The Objects, Pictures, Graphics, – Enhancements to the Slide
Show Showing Slides Out Of Order Printing Presentation
Elements – Finalizing The Presentation – Assigning Transitions
And Timings – Setting The Master Slide – Setting Up The Slide
Show – Running The Slide Show.
Assessment Pattern:
Part-A: Test may be designed to assess the candidate by means of
MCQs.
(20%of Total Marks)
Part-B: A computer based assessment test where they need to:
1. Prepare a model document and organize the same in a formatted
manner. This should cover evaluating the typing speed,
organizing the document and covering several other as pects such
as inserting tables, inserting Images /WordArt, mail merge, etc.)
2. Evaluating typing speed (25% of Total Marks)

Official annexure · page 11
(This may be made mandatory for qualifying based on the
norms existing)
3. Organizing and inserting different objects
(15% of Total Marks)
4. Prepare an Excel Sheet to fill with data and format the sheet,
merging/splitting cells, formulae for calculation in the cells,
conditional formatting, preparation of different grap hs based on
the data. (20% of Total Marks)
5. Prepare a Power Point presentation using the standard layouts
available and filling different slides with content (Formatted text,
images, tables, transition effects, animation etc.).
(20%of Total Marks)

*****

Official annexure · page 12
SCHEME OF EXAMINATION TO THE POST OF TELUGU REPORTERS IN
A.P. LEGISLATURE SERVICE
SCHEME OF THE EXAMINATION
PAPER: WRITTEN EXAMINATION

Subject
No. of
Questions
Duration
in
Minutes
Maximum
Marks
Paper-I
General Studies & Mental
Ability
(Objective Type)
Degree standard
150
150
Minutes
150
Paper-II
(Conventional
Type)
Dictation in Telugu
Shorthand
80 Words Per Minute.
– 10
Minutes
150
Transcription in
Longhand – 150
Minutes
TOTAL 300
Note: 1. Shorthand (Telugu) 80 words per minute. The examination is
intended to test the candidates’ capacity for accurate, verbatim,
reproduction of a passage consisting of 800 words dictated at the rate
of 80 words per minute.
2. As per G.O.Ms. No.235 Finance (HR -1, Plg & Policy) Dept, Dt:
06/12/2016, each wrong answer will be penalized with 1/3 rd of the
marks prescribed for the question in all objective type papers.

SYLLABUS

PAPER-I: GENERAL STUDIES AND MENTAL ABILITY
1. Major Current Events and Issues pertaining to International,
National and State of Andhra Pradesh.
2. General Science and its applications to the day to day life
Contemporary developments in Science & Technology and
Information Technology.

Official annexure · page 13
3. History of India – emphasis will be on broad general
understanding of the subject in its social, economic, cultural and
political aspects with a focus on AP and Indian National
Movement.
4. Geography of India with focus on Andhra Pradesh.
5. Indian polity and Governance: constitutional issues, public
policy, reforms and e-Governance initiatives.
6. Indian Economy and planning
7. Sustainable Development and Environmental Protection
8. Disaster management: vulnerability profile, prevention and
mitigation strategies, Application of Remote Sensing and GIS in
the assessment of Disaster
9. Logical reasoning, analytical ability and logical interpretation.
10. Data Analysis: Tabulation of data Visual representation of data
Basic data analysis (Summary Statistics such as mean, median,
mode and variance) and Interpretation.

PAPER – II

Shorthand (Telugu) 80 words per minute. The examination is
intended to test the candidate’s capacity for accurate, verbatim,
reproduction of a passage consisting of 800 words dictated at
the rate of 80 words per minute.

Official annexure · page 14
SCHEME & SYLLABUS OF THE COMPUTER PROFICIENCY TEST
(CPT)
Scheme for Computer Proficiency Test
(As per G.O.Ms.No.26, G.A. (Ser.B) Dept., dt: 24.02.2023)
Scheme of the examination (Practical Type)
Test Duration
(Minutes)
Maximum
Marks
Minimum Qualifying Marks
SC/ST/PBD B.C’s O.C’s
Proficiency in Office
Automation with usage of
Computers and
Associated Software.
60 100 30 35 40

Syllabus for Computer Proficiency Test
PART-A

9. INTRODUCTION TO COMPUTERS: Introduction to Computers –
Components and their classification – Peripheral devices and
their purpose. Input Devices – Keyboard, Mouse, Scanner,
Lighten, Touch screens, Joystick, Micro phone, Scanner, Digital
camera, Bar code reader, Biometric sensor. Out put Devices:
Display devices, Printers, Monitor, Speaker, Plotter, Secondary
Storage Devices – Feature- Driven Development (FDD), Magnetic
tape, Universal Serial Bus(USB), Pen Drives, Disks – The Role of
input Processing / output processing devices – Computing
Concepts – Data – Information – Random – Access Memory (RAM)
– Read-Only Memory(R OM) – Control Unit – Memory Unit –
Arithmetic Logic Unit(ALU).

10. COMPUTER SOFTWARE TYPES: System Software, Application
Software, Embedded software, Proprietary Software, Open source
software (their purpose and characteristics only).

Official annexure · page 15
11. OPERATING SYSTEM: Purpose of operating sy stem, Single User
and Multi User Operating Systems with Examples.

12. WINDOWS OPERATING SYSTEM: Interfacing Graphical User
Interface (GUI), Differences b etween Character User Interface
(CUI) and Graphical User Interface(GUI) – working With Files and
Folders – More About Files – Running An Application Through the
File Manager – Running an Application Through the Program
Manager – Setting up of Printer, Webc am, Scanner and other
peripheral devices.

13. LINUX/MAC OS (only basic concepts): Introduction to Linux –
Features and advantages of Linux, File handling commands,
directory handling commands – User Management – File
permissions Macintosh Apple Computer (MAC) OS – Introduction
– Advantages of Macintosh Apple Computer (MAC) OS. Basics
commands

14. INTERNET CONCEPTS (only basic concepts): Minimum
Hardware a nd Software Requirements for a system to use
internet, Communication Protocols and Facilities – Various
browsers – What is Internet Protocol (IP) Address – Steps required
in connecting sys tem to network – Uploading and Downloading
Files from Internet

15. ELECTRONIC MAIL (only basic concepts): Sending and
receiving mails, Basic E -Mail Functions, Using your word
processor for E -mail, Finding E -Mail Address, Mailing Lists and
lists Servers.

16. WORLD WIDE WEB (only basic concepts): WWW advantages
of the Web – how to navigate with the Web – Web Searching.

PART – B
8. OFFICE SUITE : MSOFFICE or any open source office like Libre
Office /Apache Open Office Neo office for
Windows/Linux/Macintosh Apple Computer (MAC)OS.

Official annexure · page 16
9. GETTING STARTED WITH OFFICE: Introduction to Office
Software- Starting and Exiting the Office Applications –
Introducing the Office Shortcut Bar – Customizing Office
Shortcut Bar.

10. FILE OPERATIONS IN THE OFFICE: Common Office Tools
and Techniques – Opening An Application – Creating Files –
Entering And Editing Text – Saving Files – Opening Files – Closing
a File – Exiting The Application – Managing Your files With the
Office Applications.

11. TOOLS IN THE OFFICE APPLICATIONS: Key Combinations –
Cut, Copy and Paste – Drag And Drop Editing – Menu Bars And
Toolbars – Undo and – Redo – Spell Checking – Auto Correct –
Find and Replac e – Help And The Office Assistants – Templates
and Wizards.

12. WORD PROCESSING (MS WORD or its equivalent in Libre
office /Apache Open Office / Neo office for
Windows/s/Linux/Mac OS): Starting Word
 Title Bar – Menu Bar – Format Bar – Standard Bar – Ruler –
Workspace Area – Scroll Bar – Status Bar – Different Toolbars –
Option a Menu Bar – Creating New Document When Word is
Running – Opening Pre existing Documents When Word is
Running – Designing Your Document – Typing Text – Selection
text – Deleting Text – Formatting text and document – copying
and moving – Saving Document – Page Setup – Properties of a
document – Undo-Redo-Cut-Copy a Document – Pasting a
Document – Print Preview – Printing – Select All – Find – Replace –
Go To – Four Different View Of A Docu ment – Normal, Web
Layout, Print Layout, and Outline Layout – Document Map – Full
Screen – Zoom – Objects – Page Break – Header and Footer – Page
Number – Auto Format – Auto Text – Inserting Date And Time –
Working With Header, Footers -footnotes-Fields-Symbols-Caption
Cross Reference -Index-Tabs-Table and Sorting – Working With
Graphics – Inserting Pictures – Modifying Pictures – Word Art –
Inserting Chart – Inserting Files – Hyper Linking – Bookmark –
Using Different Fonts – Paragraph – Bullets Borders and
Shading-Columns-Drop Cap -Theme-Change Case Background –
Frames-Style-Spelling And Grammar – Set Language – Word
Count – Auto Summarize – Auto Correct – Merge Document –
Protect Document – Envelopes And Labels – – Templates, Wizards
And Sample Documents – drawing Tables – Merge Cell – Spilt

Official annexure · page 17
Cells – Spilt Table – Table Auto Format – Auto Fit – Sort – Formula
– Arrange All -Split- Micro Soft Word Help – Macros – Custom
Toolbars – Keyboard Shortcuts – Menus – Mail Merge.

13. SPREAD SHEET (MS Excel or its equivalent in Libre Office /
Apache Open Office / Neo office for Windows/Linux/Mac OS) :
Features Of Excel – Excel worksheet – Selecting Cell – Navigating
With The Mouse And Keyboard – Entering And Editing Text – Text
Boxes – Text Notes – Checking Spelling – Undoing And Repeating
Action – Entering And Editing Formulas – Referencing Cells –
Order Of Evolution in Formulas – Copying Entries And Equations
To Minimize Typing – More Auto Fill Examples – Creating Custom
Fill Lists Prot ecting And Un Protecting Documents And Cell –
Creating A New Worksheet – Excel Formatting Tips And
Techniques – Moving cell – Copying Cells – Sorting Cell Data –
Insertion Cells Inserting As You Paste – Deleting Parts Of
Worksheet – Clearing Parts Of A Wor ksheet – Excel Page Setup –
Changing Column Width And Row Heights – Auto Format –
Manual Formatting – Using style – Format Code Alter A Number’s
Appearance – Format Painter Speeds -Up Format Copying –
Changing Font Size And Attribute s – Adjusting Al ignments –
Cantering Text Across Column – Using Border Buttons And
Commands – Changing Color And Shading – Inserting And
Removing Page Breaks – Hiding Rows And Columns –
Rearranging Worksheet – Entering Formula – Excel Functions –
Inserting Rows And Columns – Saving A Worksheet – Printing A
Worksheet – Printing Tips For Large Excel Project – Parts Of A
Function – Functions Requiring Add -ins – Function Wizard –
Example Of Functions By Category – Organizing Your Data –
Excel’s Chart Features – Chart Parts And Termino logy – Instant
charts with The chart wizard – Creating Chart On Separating
Worksheets – Resizing And Moving Charts – Adding Chart Notes
And Arrows – Editing Charts – Rotating 3 -D Charts – Printing
Charts – Deleting Charts Setting The Default Chart Type –
Creating Trend Lines Data Map – Working With Graphics in Excel
– Creating And Pacing Graphic objects – Resizing Graphs –
Possible Sources Of Excel Graphics – Creating and Running
Macro – Sorting Excel Data – Adding Subtotals To Databases –
Customizing Excel – Customizing Workspace – Comma Separated
Value (CSV) File format – Using Worksheet As Databases.

Official annexure · page 18
14. PRESENTATION SOFTWARE (MS Power Point or its
equivalent in Libre Office/Apache Open office /Neo office for
Windows/Linux/Mac Os): Introduction – Starting Pres entation
Software – Views in Presentation Software – Slides – Terminology –
Color Schemes – Formatting Slides – Creating a Presentation –
Using the Auto Content Wizard – Masters- – Using a Template –
Creating a Blank Presentation – Working with Text in Pow er Point
– Adding Slides Editing And Working Text – Working in Outlaying
view – Spell checking – Finding And Replacing Text – Formatting
Text – Aligning Text – Developing Your Presentation –
Importing images From The Outside World – The Clipart Gallery –
Drawing in Presentation software – Bringing A Presentation to Life
– Inserting Objects in Your Presentation – Inserting A Picture –
Working With Graphics – Multimedia in Power Point – Animating
The Objects, Pictures, Graphics, – Enhancements to the Slide
Show Showing Slides Out Of Order Printing Presentation
Elements – Finalizing The Presentation – Assigning Transitions
And Timings – Setting The Master Slide – Setting Up The Slide
Show – Running The Slide Show.
Assessment Pattern:
Part-A: Test may be designed to assess the candidate by means of
MCQs. (20%of Total Marks)
Part-B: A computer based assessment test where they need to:
6. Prepare a model document and organize the same in a formatted
manner. This should cover evaluating t he typing speed,
organizing the document and covering several other as pects such
as inserting tables, inserting Images /WordArt, mail merge, etc.)
7. Evaluating typing speed (25% of Total Marks)
(This may be made mandatory for qualifying based on the
norms existing)
8. Organizing and inserting different objects
(15% of Total Marks)
9. Prepare an Excel Sheet to fill with data and format the sheet,
merging/splitting cells, formulae for calculation in the cells,
conditional formatting, preparation of different graphs based on
the data. (20% of Total Marks)
10. Prepare a Power Point presentation using the standard layouts
available and filling different slides with content (Formatted text,
images, tables, transition effects, animation etc.).
(20%of Total Marks)

****