Andhra Pradesh Public Service Commission: Vijayawada
Proficiency in Office Automation
with usage of Computers and Associated Software
60
Minutes
100
Maximum Marks
40
Qualifying Marks
01
Computer Fundamentals
Foundation of computing concepts
Introduction to Computers
→ Definition & characteristics
→ Evolution & generations
→ Types of computers
→ Basic organization
Hardware Components
→ Input devices
→ Output devices
→ CPU components
→ Memory types
Software Concepts
→ System vs Application software
→ Operating systems
→ Utility programs
→ Programming languages
Data Representation
→ Number systems
→ Storage units
→ Character encoding
→ Number conversion
02
Operating System
Windows interface & file management
Windows Basics
→ Desktop & Taskbar
→ File Explorer
→ Window management
→ Creating shortcuts
File Management
→ Creating/deleting files
→ Copy, cut, paste
→ File properties
→ Search functionality
System Tools
→ Control Panel
→ Task Manager
→ Disk cleanup
→ Program management
Accessories
→ Notepad & WordPad
→ Paint application
→ Calculator
→ Screenshot tools
03
Microsoft Word
Document creation & formatting
Document Basics
→ Creating & saving
→ Opening & editing
→ Page setup
→ Printing
Text Formatting
→ Font styles & sizes
→ Bold, Italic, Underline
→ Paragraph alignment
→ Bullets & numbering
Tables & Graphics
→ Creating tables
→ Inserting images
→ WordArt effects
→ Headers & footers
Advanced Features
→ Find & replace
→ Spell check
→ Mail merge
→ Table of contents
04
Microsoft Excel
Spreadsheets & data analysis
Spreadsheet Basics
→ Workbooks & worksheets
→ Cells, rows & columns
→ Data entry
→ Cell references
Formulas & Functions
→ Arithmetic formulas
→ SUM, AVERAGE, COUNT
→ IF, SUMIF, COUNTIF
→ VLOOKUP basics
Formatting & Charts
→ Cell formatting
→ Conditional formatting
→ Creating charts
→ Chart customization
Data Management
→ Sorting & filtering
→ Data validation
→ Freeze panes
→ Print settings
05
Microsoft PowerPoint
Presentations & visual storytelling
Presentation Basics
→ Creating presentations
→ Slide layouts & themes
→ Managing slides
→ Slide views
Content Creation
→ Text & text boxes
→ Images & shapes
→ SmartArt graphics
→ Tables & charts
Animations & Effects
→ Slide transitions
→ Object animations
→ Animation timing
→ Custom paths
Presentation Delivery
→ Slideshow settings
→ Presenter view
→ Speaker notes
→ Exporting & sharing
06
Internet & Email
Web navigation & digital communication
Internet Basics
→ Internet & WWW
→ Web browsers
→ Search engines
→ File downloads
Email Communication
→ Email accounts
→ Composing emails
→ Attachments
→ Inbox management
Online Safety
→ Viruses & malware
→ Antivirus software
→ Safe browsing
→ Password security
Essential Keyboard Shortcuts
General
Copy Ctrl+C
Paste Ctrl+V
Cut Ctrl+X
Undo Ctrl+Z
MS Word
Bold Ctrl+B
Italic Ctrl+I
Underline Ctrl+U
Save Ctrl+S
MS Excel
Sum Alt+=
New Row Ctrl++
Delete Ctrl+-
Find Ctrl+F
Assessment Pattern
Part A
Multiple Choice Questions
Theory assessment via MCQs
20%
of Total Marks
Test designed to assess the candidate by means of Multiple Choice Questions covering theoretical concepts.
Part B
Computer Based Assessment Test
Practical evaluation across multiple applications
1
Document Preparation & Typing Speed
Prepare a model document and organize it in a formatted manner. This covers:
→ Evaluating typing speed (mandatory qualifying)
→ Document organization
→ Inserting tables
→ Inserting Images/WordArt
→ Mail merge operations
→ Various formatting aspects
40%
Total
Typing Speed Evaluation
25%
Mandatory qualifying based on existing norms
Organizing & Inserting Objects
15%
Tables, images, WordArt, formatting
2
Excel Spreadsheet
Prepare an Excel sheet with comprehensive data operations:
→ Data filling & formatting
→ Merging/splitting cells
→ Formulae for calculations
→ Conditional formatting
→ Different graph types
→ Data-based charts
20%
of Total Marks
3
PowerPoint Presentation
Create a presentation using standard layouts with diverse content:
→ Formatted text content
→ Image insertion
→ Tables & data
→ Transition effects
→ Animations
→ Standard layouts
20%
of Total Marks
Marks Distribution Summary
20%
Part A MCQs
25%
Typing Speed
15%
Word Objects
20%
Excel Sheet
20%
PowerPoint
Thanks ..! Please be connected with us for more info..