CPT - COMPUTER PROFICIENCY TEST

Computer Proficiency Test

Duration: 60 Minutes

Minimum Qualifying Marks: 40

Maximum Marks: 100

కంప్యూటర్ ను MS ఆఫీస్ సాఫ్ట్వేర్ లను ఉపయోగించి ఆఫీస్ ఆటోమేషన్‌లో ప్రావీణ్యత అర్హత పరీక్ష APPSC వారు నిర్వహించు టెస్ట్ లో వచ్చు ముఖ్యమైన విషయాలను క్రింద ఇవ్వబడినది

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 (MSWORD 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 coping and moving – Saving Document – Page Setup – Properties of a document – and 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 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 –Split Cells – Split 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 TheMouse 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.

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 aspects such as inserting tables, inserting Images/WordArt, mails merge, etc...).
2. Evaluating typing speed (25% of Total Marks) (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 graphs based on the data.(20% of Total Marks);
5. Prepared 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)