Course Outline
 

 

Computer Appreciation
  • Classification of Computers as per processing speed
  • Applications of Computer
  • Illustrating Computer Terms like hardware, software, etc.
  • Computer Operations of Input, Process and Output
  • Various units of a computer system
  • Representation of information in bytes, KB, MB, etc.
  • Input devices used with computer
  • Output devices used by computer
  • Storage Devices of computer
  • Types of Software in computer
  • Disk Organization in computer and terms about it
  • Explaining Operating System's roles, and types
MS-DOS
  • What is DISK OPERATING SYSTEM?
  • Organization of MS-DOS
  • File naming rules to be followed in MS-DOS
  • Types of DOS commands
  • Various DOS Commands
  • Using COPYCON to build a file
  • Introduction to simple batch files
WINDOWS-XP
  • Windows Basics and its elements
  • The User Interface components in MS-Windows
  • Accessories in MS-Windows under Entertainment, Games, System Tools, Calculator and Date-Time.
  • Using Notepad, its menus and their usage
  • Paintbrush, WordPad and windows explorer menus and their usage.
  • Common operations like browsing, copy-cut-paste files and shutting down Windows
MS - WORD 2003
  • MS- Word Window Elements
  • File Management for new, open, close, save, save as and exit MS-Word
  • Moving and selection by mouse and keyboard
  • Different files in MS-Word as windows and their arrangement and views
  • Printing document and using the page setup options
  • Using the Interface of toolbars and menu bar
  • Editing Text for cut-copy-paste, undo and redo, delete and find-replace
  • Different views of a document, setting the header and footer and show or hide optional window component like toolbars, ruler, etc.
  • Break and its type explaining usage of each
  • Steps for inserting pictures, clip art, word art, and auto shapes in the document
  • Insertion options for miscellaneous items like symbol, date-time and page number
  • Formatting font, paragraph of a document
  • Setting the format of bullet and numbering, border and shading, columns and tabs
  • Using MS-Word Tools like Spell and Grammar Check, Thesaurus, AutoCorrect, AutoText, AutoComplete and Macros
  • Document protection
  • Utilizing Mail Merge facility in MS-word for letter, envelopes and labels
  • Using Wizards of MS-Word like The Letter Wizard
  • Document Templates use in MS-Word
  • Using Reference in a Document
  • Tables creation, sorting and formatting in MS-Word
  • Creating Charts and Web Pages in MS-Word
MS - EXCEL 2003
  • Basics of Worksheet and MS-Excel window
  • Split Windows and Freeze Panes in MS-Excel
  • File Management for create, open, save, save as, close of workbook in MS-Excel
  • Setting for Printing, Page setup, break and Header and Footer in MS-Excel
  • Working with workbooks for moving and selecting data and worksheet
  • Menus and toolbars of MS-Excel
  • Using of Cut-copy-paste, redo-undo, drag-drop, paste special operations of data
  • Steps to insert, delete row, column and cell
  • Using find-replace and go to facility of MS-Excel
  • Following rules for sheet names
  • Steps to Rename, add, delete worksheets and how to move worksheet in multiple open workbook
  • Using AutoFill facility by mouse and fill option
  • Explaining the different Views of worksheet and show or hide of optional components like toolbar, formula bar, etc.
  • Explaining formula, different data types, operators and MS-Excel in-built functions
  • Using auto sum and function wizard facility of MS-Excel
  • Working with cell Ranges and names
  • Relative and Absolute Reference in MS-Excel
  • Formatting Cells by Auto formatting, by toolbar, Format Dialog Box and Conditional Formatting in MS-Excel
  • Hide and Display Sheets, Rows and Columns
  • Setting Styles in MS-Excel
  • Various tools of MS-Excel like Spell Check, Workbook Sharing, What If Analysis, Scenario Manager, Goal Seek, Macros and Workbook protection
  • Explaining Data and list Operations of sort, find by criteria, filter and advanced filter
  • Using pivot table
  • Working with graphs and charts
  • Creating and using multiple worksheets and linking workbooks
  • Linking and embedding in MS-Excel
MS - POWER POINT 2003
  • Accessing PowerPoint
  • Basics of starting, opening and closing a presentation
  • Different Views of presentation in MS-Powerpoint
  • Slide Management for creating, deleting and changing order of slides
  • Editing the slide master
  • Formatting Color Scheme and Background
  • Adding Clip Art and Drawing Objects
  • Setting the Customs Animation and transitions in Slide Show
  • Setting up a Slide Show and Slide Timings Creating common language set
Miscellaneous Topics
  • Explaining Virus and it’s types, spread and preventive measures to follow.
  • Data Processing concepts explaining input, process and output cycle
  • Illustrating Networking concepts about networks(LAN,WAN), topology(Bus, Ring, Star), internet and intranet

Apply for Certification

https://www.vskills.in/certification/Certified-computer-fundamentals-ms-office-professional-vs-1021