Course name: diploma in office automation duration: 1 year
Chapter 1: CERTIFICATE COURSE IN OFFICE AUTOMATION & E- GOVERNANCE
- Computer & Internet: Desktop computers,
- Block diagram of a computer,
- Input and output devices, memory and storage devices,
- different ports and its uses,
- Different type of printers.
- Software: OS, Windows OS, Application software.
- Networking, different LAN andWAN connections
- connecting to a network,
- testing connection
- Internet,
- IP address
- Hypertext
- Uniform Resource Locator
- Web Browsers
- IP Address
- Domain Name
- Internet Services Providers
- Internet Security
- Internet Requirement
- Web Search Engine
- Net Surfing
- Internet Services.
Chapter 2: Windows XP
- Windows concepts
- Feature
- Windows Structure
- Desktop
- Taskbar
- Start Menu
- My Computer
- Recycle Bin
- Windows Accessories- Calculator,
- Notepad,
- Paint,
- Wordpad,
- Character Map,
- Windows Explorer,
- Entertainment, Managing Hardware & Software-
- Installation of Hardware & Software
- Using Scanner
- System Tools
- Communication
- Sharing Information between programs.
Word Processing
chapter 3: MS Word:
- Creating Saving and Opening Documents in Word
- Interface
- Toolbars
- Ruler
- Menus
- Keyboard 100 Shortcut
- Editing, Previewing
- Printing,& Formatting a Document
- Advanced Features of MS Word
- Find & Replace
- Using Thesaurus
- Using Auto- Multiple Functions
- Mail Merge, Handling Graphics
- Tables & Charts
- Coverting a word document into various formats like- Text, Rich Text format, Word perfect, HTML,PDF etc.
- Worksheet
Chapter 4: MS-Excel:
- Worksheet basics
- creating worksheet
- entering into worksheet
- heading information
- data
- text
- dates
- alphanumeric values
- saving & quitting worksheet
- Opening and moving around in an existing worksheet
- Toolbars and Menus, Keyboard shortcuts
- Working with single and multiple workbook
- working with formulae & cell referencing
- Auto sum
- Coping formulae
- Absolute & relative addressing
- Worksheet with ranges
- formatting of worksheet
- Previewing & Printing worksheet
- Graphs and charts
- Database
- Creating and Using macros, Multiple worksheets- concepts, creating and using.
Chapter 5: MS Power Point:
- Creating slide show with animations
- .Autocentnt Wizard
- creating a lank presentation, autolayout,
- Power point screen
- screen layout and Views
- insert a newslide
- applying design template
- changing slide layout,reordering and hiding slides
- slide show and editing custom slide.
- Resizing a text box
- Textbox properties,
- Delete a text box
- Bulleted lists
- Numbered lists,
- Adding notes,Video and Audio,
- Adding text Editing options,
- Formatting text,Replace fonts,
- Database Basics:
- Databases, Records · Fields,
- data types,
- Database Types · Library Catalogues Introduction into Microsoft Access
- Starting Up Microsoft Access,
- Creating New, and Opening Existing Databases,
- Creating a database using a wizard
- Creating a database without using a wizard,Tables - What they are and how they work,
- Create a table from scratch in Design view
- Primary Keys
- Switching Views
- Entering Data
- Manipulating Data
- Advanced Table Feature
- ,Relationships - How to link multiple tables together,Forms –
- What they are and how they work,
- Creating A Form Using A Wizard,Reports - What they are and how they work,
- Creating A Report Using A Wizard
- Creating Mail Merge Labels using a Wizard Intranet & E-governance
- Intranet tools: E-mail:
- Anatomy of e-mail,
- e-mail address
- finding e-mail address
- adding signature
- attaching files
- opening attachments, managing e-mail account
- Web mail
| S.No |
Exam |
% of mark to Certify |
Timing (in minutes) |
| 1 | Diploma in Office Automation - DOA-01 | 50 | 60 |
