APPSC - Computer Proficiency Test (CPT) - Scheme and Syllabus

Scheme for Computer Proficiency Test - Practical Type Examination

Assessment Pattern

Syllabus for Computer Proficiency Test (CPT)

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 Output 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(ROM) - 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).
3. OPERATING SYSTEM: Purpose of operating system, Single User and Multi User Operating Systems with Examples.
4. WINDOWS OPERATING SYSTEM: Interfacing Graphical User Interface (GUI), Differences between 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, Webcam, 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 and Software Requirements for a system to use internet, Communication Protocols and Facilities - Various browsers - What is Internet Protocol(IP) Address - Steps required in connecting system 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.

PART-B

1. OFFICE SUITE: MSOFFICE or any open source office like Libre Office /Apache Open Office Neo office for Windows/Linux/Media Access Control Address (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 LayoutDocument Map - Full Screen - Zoom - Objects - Page Break - Header and Footer - PageNumber - Auto Format - Auto Text - Inserting Date And Time - Working With Header, Footersfootnotes-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 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/s/Linux/ Maa 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 Attributes - Adjusting Alignments - 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 Terminology - 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
7. PRESENTATION SOFTWARE (MS Power Point or its equivalent in Libre Office/Apache Open office/Neo office for Windows/s/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 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