Table of Content
I / O devices
- Input Devices
- Online Input Devices
- Dumb Terminals
- Intelligent Terminals
- Voice Recognition Devices
- Touch tone Terminals
- Mouse
- Different types of Mouse
- Troubleshooting Mouse
- Keyboard
- Keyboard Cable
- Troubleshooting keyboard
- OFF – LINE INPUT DEVICES
- Key to disk system
- Paper Tape
- Punched card
- Source Data Input
- Point of Sale Terminal
- Optical Character Reader ( OCR )
- Magnetic Ink Character Recognition ( MICR )
- Scanners
- Scanner Operation
- Scanner troubleshooting
- Restore pc – scanner communication
- Grinding noise
- Avoid paper jams in the ADF
- Enlarge an image without distortion
- Resolve color scanning variance
- Scan problem text or editing
- Straighten crooked scans
- Output devices
- Hard copy devices
- Dot Matrix Printer
- Ink Jet Printers
- Laser Printers
- Feeding paper
- Installing a Print Cartridge ( C710 Color Laser )
- Refilling Toner Cartridges
- Printer Maintenance
- Laser printer Maintenance
- Inkjet Printer Maintenance
- Dot Matrix Printer Maintenance
- Plotter output
- Drum Plotters
- Flat bed Plotters
- Soft Copy Devices
- Audio Response Unit : Speakers
- Micro films
Invoking / Closing application ( s ) from Windows 95 Desktop
- Introduction to WINDOWS 95
- Evolution of Windows 95
- Starting Windows 95
- Invoking applications
- Closing applications
- End current working session
Operating Systems
- WINDOWS 95
- Evolution of Windows 95
- Windows 98
- Web integration
- Multiple display support
- Power Management
- Universal serial Bus
- Accessibility Wizard
- Windows 2000
- Windows 2000 Professional
- Netware
- UNIX Operating System
- Working with UNIX
- SHELL
- KERNEL
- Special features exclusive to UNIX OS
Working with Floppy disks using Windows Explorer
- Format Floppy Diskette
- Copy files / folders diskette
- Duplicate Files / Folders
- Change File / Folder Viewing Options
- Finding Files and editing using Notepad
- Method of Adjusting Column Width
- Crate and Edit ASCII Text files using Notepad
- Crating a new documents
- Editing on Existing Text Document
- Moving around the text
- Selecting Text
- Cut, Copy and Paste
- Deleting the Text
- Data Stamping a File
- Search a Text File
Opening, editing and saving Word documents
- Menu bar
- Tool bar
- Ruler bar
- Scroll bar
- Status bar
- WORKSPACE
- WORD FILE
- New
- Open
- CLOSE
- SAVE
- Save As
- Print Preview
- EXIT
Familiarizing with Word toolbars
- Selection of text using the mouse
- Selection of text using the Shortcut keys
- Deleting text
- Copying and Pasting text
- Undoing edits
- Redoing edits
- Repeating edits
- Toolbars
- Paragraph specification
- Paragraph alignment
- Boldfaced text
- Italicizing text
- Underlining text
Creating tables, move, copy, sort items in table
- Tables
- Move or copy items in a table
- Using the mouse to select in a table
- Using the keyboard to select in a table
- Sorting table data
- Change the default working folder for Word
Printing documents
- Printing
- Add a bookmark
- Create a hyperlink
- Change a hyperlink
- Remove a hyperlink
- Assign a hyperlink to a toolbar button or menu command
- About mail merge for form letters and mass mailings
- Additional merge fields
- Print merged documents
Mail Merge
- Set up Mail Merge Main Document
- Attach Data Source
- Open Existing Data Source
- Insert Merge Fields into main documents
- Insert Merged field using menu
- Preview Merged Documents
- Merge Documents
Document enhancement
- Working with master documents
- Creating a master documents
- Creating a subdocuments
- Working with subdocuments
- Move a subdocument
- Delete a subdocument
- Adding existing word document to a master documents
- Split subdocuments
- Make the text in a subdocuments into part of the master document
- To merge subdocuments
- To lock or unlock a subdocuments
- Copying from one documents to another
- Split screen view
- Inserting & Changing Page Number
- Header and Footer
- Closing and Saving all open files
Excel Worksheet
- Spread sheet
- Opening Excel Worksheet
- Title bar
- Menu Bar
- Standard Tool Bar
- Formatting Toolbar
- Formula Bar
- Status Bar
- Excel document window
- Title bar
- Control menu
- Sheet tabs
- Scroll bars
- Column / Row
- Cell
- Entering data
- Printing the Worksheet
- Saving Workbook
- Crating Work Sheet / Work book
- Page Setup
- Page tab provide the option to setup the
- Range
- Increasing / Decreasing the cell width
- Auto sum
- Entering Text
Formatting worksheet in Excel
- Data Types
- Adding Worksheet
- Alignment
- Applying Border
- Applying colors to borders
- Colors and Patterns
Creating charts in Excel
- Types of Charts
- Changing chart types
- Printing of Charts
Using Formulas and Functions in Excel
- Copying Data using Auto fill
- Fill
- Auto fill
- Custom lists
- Formulas
- Text operators
- Reference operators
- Functions
Opening / creating Powerpoint presentation
- Introduction
- Standard tool bar
- Auto Content Wizard
- Working with Text
- Creating Text outside a placeholder
- Inserting Slides
- Re – size the text
- Outline View
- Animation Effects
- Customizing Animation
- Slide Transition
- Changing the Slide look
- Changing presentation Template
- Changing Color scheme
- Adding Background
Outlook Express
- E – mail Service by Internet Access Providers
- Additional Services provided by Internet Access Providers
- Content providers
- Portal
- Hotmail
- Advantages of Hotmail
- Outlook express
Introduction to HTML
- What is HTML or Hypertext markup language?
- Introduction to HTML
- The basic components of HTML
- Breaking text into paragraphs
- Adding line breaks
- Adding Headings
- Adding horizontal lines
Basics of Modems
- How a Modem works
- Device drivers
- AT commands
- Establishing a dial – up connection
- Front panel indicators of a modem
- Modem standard
- Modulations Standards
- ISDN
- 56K Modems
Internet
- What is Internet?
- Service of the Internet
- World Wide Web
- Website
- An URL consists of
- Browser
- Search Engines
- Making an internet connection
- Web Server
- Internet Service Provider ( ISP )
- Internet Access Provider
Drawing simple geometric object using Corel DRAW
- Introduction
- IMAGE AND IMAGE TYPES
- VECTOR Image
- BITMAP Images
- Working on bitmap files
- Resolution
- Objects in Corel DRAW
- Menu Bar
- Tool bar
- Property bar
- Printable Page Area
- Rulers
- Status bar
- Color palette
- Tool box
- Transformation
Working with text, dimensioning objects
- Text tool
- Dimension Tool
Creating special effects using Corel DRAW – Part 1
- Blending objects
- Out lines and Fills
Opening and viewing pagemaker publications
- Current Version of PageMaker
- Starting PageMaker
- Important points to know while using the Paste board;
- Opening and existing publication
- Viewing pages
- Shortcut of viewing preset view sizes
- Zoom In / Zoom Out using zoom tool
- Opening a publication as a copy
- Opening Recent Publication
- Opening earlier version of PageMaker Publication
- Opening publication with missing links
- Matching the fonts in the opened publication
- Moving between page of publication
- Going to a specific page
- Moving to page using ( layout ) from main menu
- To go to first and last page of the publication
- Adding page to a publication
- Adding page using documents setup
- Adding page using Layout menu
- Adding / Inserting Pages by right click on the page
- Removing Pages using Documents setup Box
Creating and using Pagemaker templates
- Pagemaker Templates
- Creating Templates
- Saving publications as a template
- Ending a template
- Built-in Templates with PageMaker
- Drawing Rectangles in publication
- Placing Graphics
Creating drop cap, tilting and changing percentage tint of text
- Copying and Pasting
- Pasting a specified format
- Dragging and Dropping
- Transforming Objects
- Rotating an objects
- Setting Tint Percent
Setting tabs, indent and leading
- Indents
- Tabs
- TAB’s and LEADER’s
- Tips for formatting indents and tabs
Apply for Certification
https://www.vskills.in/certification/Vskills-Certified-Office-Administrator-Basic-Office-Automation