APPSC Group 2 Syllabus for CPT Exam

The syllabus for the Computer Proficiency Test (CPT) in APPSC Group 2 includes proficiency in office automation using computers and associated software. The CPT is divided into five parts, testing practical skills in commonly used software:

Part A: MS Word (Word Processing)

  • Document Creation: Create and save a document, type paragraphs, and format text.
  • Editing: Delete characters, words, lines, undo/redo actions, move, copy, and rename text.
  • Formatting: Character, paragraph, and page formatting.
  • Spell Check: Use spell check, find and replace, bookmarks, and dictionary.
  • Printing: Use print preview and the print dialog box.
  • Mail Merge: Create main documents, data files, mailing labels, and merge documents.
  • Table Creation: Create tables, add/remove rows and columns, adjust cell sizes, use formulas, sort data, and format tables.
  • Typing Speed: Type at a speed of at least 30 words per minute.

Part B: MS Excel (Spreadsheet)

  • Worksheet Creation: Create and save workbooks, enter, edit, and format data.
  • Cell Formatting: Format text, numbers, and cells, change cell dimensions, freeze titles, and split screens.
  • Calculations: Enter and copy formulas, use built-in functions, and apply them across ranges.
  • Graph Creation: Use Chart Wizard to create and format graphs.
  • Printing: Print worksheets.

Part C: MS PowerPoint (Presentation Software)

  • Presentation Creation: Create and save presentations, use toolbars, and auto layout.
  • Slides: Insert text, pictures, add new slides, and apply transitions.
  • Animations: Set animations, sounds, timing, and slide shows.

Part D: Database Management

  • Data Creation and Manipulation: Access the internet using various browsers, search using search engines, create an email account, send/receive emails, and perform e-commerce transactions.
  • Web Content Uploading: Upload content to the web.
  • Mac OS Proficiency: Ability to use Mac OS, Pages, Keynote, and Numbers software.

Part E: Email Management

  • Email Display: Demonstrate ability to display and organize the email inbox content.

Each part focuses on specific practical tasks that evaluate your computer proficiency, totaling a score of 50 marks across all sections.