Vskills Certified Office Administrator - Basic Office Automation Table of Content


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
  • Print
  • 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

 For Support