CPT EXAM PATTERN
Computer Fundamentals & Office Applications
Comprehensive study of computer fundamentals including components and their classification, peripheral devices and their purpose.
Input Devices:
Output Devices:
Secondary Storage & Processing:
Study of FDD, Magnetic tape, USB, Pen Drives, Disks and their role in input/output processing. Computing concepts including Data Information, RAM, ROM, Control Unit, Memory Unit, ALU.
Understanding different software categories and their characteristics:
Purpose of operating system, Single User and Multi User Operating Systems with practical examples and implementations.
Comprehensive coverage of GUI interfacing, differences between CUI and GUI. Working with Files and Folders, running applications through File Manager and Program Manager. Setting up peripheral devices including Printer, Webcam, Scanner.
Linux: Introduction, features and advantages, file handling commands, directory handling commands, user management, file permissions.
MAC OS: Introduction, advantages of MAC OS, and basic commands.
Minimum hardware and software requirements for internet usage. Communication Protocols, various browsers, IP Address concepts, network connection steps, and file uploading/downloading procedures.
Sending and receiving mails, basic E-Mail functions, using word processor for E-mail, finding E-Mail addresses, mailing lists and list servers.
WWW advantages, web navigation techniques, and web searching methodologies.
MS OFFICE or open source alternatives like LibreOffice, Apache OpenOffice, NeoOffice for Windows/Linux/MAC OS platforms.
Introduction to Office Software, starting and exiting applications, Office Shortcut Bar introduction and customization techniques.
Common office tools and techniques including opening applications, creating files, entering and editing text, saving files, opening files, closing files, exiting applications, and managing files within office applications.
Essential tools including key combinations, Cut/Copy/Paste, Drag and Drop editing, menu bars and toolbars, Undo/Redo, Spell Checking, AutoCorrect, Find and Replace, Help and Office Assistants, Templates and Wizards.
Comprehensive word processing covering:
Interface Elements:
Document Operations:
Creating new documents, opening pre-existing documents, designing documents, typing text, selecting text, deleting text, formatting text and documents, copying and moving, saving documents, page setup, document properties.
Advanced Features:
Print Preview, Printing, Select All, Find, Replace, Go To. Four different document views: Normal, Web Layout, Print Layout, Outline Layout. Document Map, Full Screen, Zoom, Objects, Page Break.
Content Enhancement:
Header and Footer, Page Numbers, AutoFormat, AutoText, inserting Date and Time, working with Headers/Footers, footnotes, fields, symbols, captions, cross-references, index, tabs, tables and sorting.
Graphics & Media:
Working with graphics, inserting pictures, modifying pictures, WordArt, inserting charts, inserting files, hyperlinking, bookmarks, using different fonts, paragraph formatting.
HyperLinking-Bookmark:
Working with graphics, HyperLinking-Bookmark
—UsingDifferentFonts-Paragraph - BulletsBordersandShading- Columns-DropCap-Theme-ChangeCaseBackground-Frames-Style- SpellingAnd Grammar-SetLanguage- Word Count-Auto Summarize
MergeDocumen, Micro Soft Word Help - macros, Merge Document-Protect Document-Envelopes and Labels -Templates, WizardsAndSampleDocuments-drawingTables
-MergeCell - Spilt Cells - SpiltTable -Table AutoFormat -AutoFit- Sort - Formula - Arrange All- Split- Micro Soft Word Help - f4acros - Custom Toolbars - Keyboard Shortcuts - Menus - Mail Merge. Creating new documents, opening pre-existing documents, designing documents, typing text, selecting text, deleting text, formatting text and documentsSPREAD SHEET (MS Excel or its equivalent in Libre Office/Apache OpenOffice/NeoofficeforWindows/s/Linux/MaaOS):
Features Of Excel - Excel worksheet - Selecting Cell - Navigating With The Mouse And Keyboard - Entering And Editing Text -Text Boxes -TextNotes
Checking Spelling -Undoing And Repeating Action - Entering AndEditing Formulas - Referencing Cells - Order Of Evolution in Formulas - Copying Entries And Equations To Minimize Typing - More Auto FiII Examples - CreatingCustomFiIIListsProtectingAndUnProtectingDocumentsAndCell
Creating A New Worksheet - Excel Formatting Tips And Techniques - Moving cell - Copying Cells - Sorting Cell Data -Insertion CellsInserting As You Paste - Deleting PartsOf Worksheet -Clearing Parts Of A Worksheet - ExcelPageSetup-ChangingColumnWidthAndRowHeights-AutoFormat
Manual Formatting - Using style - Format Code Alter A Number's Appearance - Format Painter Speeds-Up Format Copying - Changing Font Size And Attributes- AdjustingAlignments- 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 AndColumns - Saving A Worksheet - Printing A Worksheet - Printing TipsForLargeExcelProject-PartsOfAFunction -FunctionsRequiringAdd- ins-Function Wizard-ExampleOfFunctionsByCategory -OrganizingYour Data -Excel's Chart Features -Chart PartsAndTerminology -Instantcharts withThechartwizard-CreatingChartOnSeparating 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 -CommaSeparated Value(CSV) File format - Using Worksheet As Databases.
PRESENTATION SOFTWARE (NS Power Point or itsequivalent in LibreOffice/ApacheOpenoffice/NeoofficeforWindows/s/ Linux/Mac Os):
Introduction-StartingPresentationSoftware-ViewsinPresentationSoftware
—Slides - Terminology - Color Schemes - Formatting Slides -Creating a Presentation -Using theAutoContent Wizard -Masters- -Using aTemplate - Creating a Blank Presentation - Working with Text in Power Point - Adding SlidesEditingAndWorkingText-Workingin Outlayingview-Spellchecking
- FindingAnd ReplacingText- FormattingText-AligningText- Developing YourPresentation- ImportingimagesFrom The OutsideWorld- The Clipart Gallery-DrawinginPresentationsoftware-BringingAPresentationtoLife InsertingObjectsinYourPresentation- InsertingAPicture-WorkingWith Graphics-MultimediainPowerPoint-AnimatingTheObjects,Pictures, Graphics,-EnhancementstotheSlideShowShowingSlidesOutOfOrder PrintingPresentationElements-FinalizingThePresentation -Assigning TransitionsAndTimings-SettingTheMasterSlide-SettingUpTheSlide
Show-RunningTheSlideShow. AssessmentPattern: (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 Editlng 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. 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:
I.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,mailmerge,etc...).
Evaluatingtyping speed (25% of Total Marks)
(This may bemade mandatory for qualifying based onthe normsexisting)
Organizing and inserting different objects (15 % Of TOtalMarks)
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)
PreparedaPowerPointpresentationusingthestandard layoutsavailable andfilling different slides with content (Formatted text, images, tables, transition effects, animationetc.,) (20 % of Total marks)
AutoCorrect:
Spread Sheet - MS Excel - Excel Formatting Tips And Techniques:
PRESENTATION SOFTWARE: MS Power Point
Assessment Pattern:
Thanks ..! Please be connected with us for more info..