Certified Computer Fundamentals (MS Office) Professional

TABLE OF CONTENT

COMPUTER APPRECIATION

• Introduction - What is Computer?
• Characteristics of computer
• Generation of computers
• Classification of Computers
• Applications of Computer
• Commonly Used Computer Terms
• Basic Operations of a Computer – Input, Process and Output
• Units of a computer system
• Representation of information
• Input Devices
• Output Devices
• Storage Devices
• Types of Software
• Disk Organization
• Operating System

MS-DOS

• What is DOS?
• How is MS-DOS organized?
• Types of DOS commands
• File naming rules
• DOS Commands
• Using COPYCON to build a file
• Introduction to simple batch files

WINDOWS-XP

• Windows Basics
• The User Interface
• Windows Accessories

MS - WORD 2003

• MS- Word Window Elements
• File Management
• Using the Interface
• Editing Text
• Viewing Options
• Insertion Options
• Formatting Document
• Word Tools
• Mail Merge
• Using Wizards
• Document Templates
• Reference Document
• Tables
• Charts
• Creating Web Pages

MS - EXCEL 2003

• Worksheet Basics
• Split Windows
• Freeze Panes
• File Management
• Working with workbooks
• Menus and toolbars
• Editing data
• AutoFill
• Viewing Options
• Formula
• Working with Ranges
• Formatting Cells
• Hide and Display Sheets, Rows and Columns
• Style
• Tools
• Data Operations
• Previewing Charts
• Creating and using multiple worksheets and linking workbooks
• Overview of linked and embedded objects
• Linking or embedding an object
• Linking Worksheets

MS - POWER POINT 2003

• Loading of PowerPoint
• Starting with a presentation
• Different Views
• Slide Management
• Formatting Options
• Working of a Slide Show
•  

MISCELLANEOUS TOPICS

• Virus
• Data Processing Concepts
• Networking Concepts

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

Write a review