BCM6B14 OFFICE AUTOMATION TOOLS
Module I
MS-Word : Word Basics - Starting word - Creating a new document - Opening
preexisting document - The parts of a word window - Typing text - Selecting text
- Deleting text -Undo - Redo – Repeat- Inserting text - Replacing text -
Formatting text - Cut - Copy -Paste - Formatting Text and Documents - Auto
format - Line spacing - Margins - Borders and Shading.
Headers and Footers: Definition - Creating basic headers and footers - Tables -
Creating table
- Adding, changing, deleting rows - Inserting, changing, deleting column -
Graphics - Importing graphics - Clipart - Insert picture - Clip Art Gallery -
Drawing objects - Text in drawing .
Templates : Template types - Using templates - Exploring templates - Modifying
templates - Macros : Record in macros - Editing macros - Running a macro -
Mail Merge: Mail Merge concept - Main document - Data sources - Merging data
source and main document - Overview of word menu options - Word basic tool
bar.
(Theory 15 Hours and Practical 10 Hours, 20 marks)
Module II
MS EXCEL : Electronic Spreadsheet – Creating and rearranging worksheet -
Structure of spreadsheet and its applications to accounting, finance, and
marketing functions of business - Creating a dynamic / sensitive worksheet -
Concept of absolute and relative cell reference - Using built in functions –
Mathematical, statistical and financial functions – Conditional formatting
–filters- Charts – Pivot table and pivot chart - Goal seeking and solver tools -
Sharing data with other desktop applications - Strategies of creating error free
worksheet.
(Theory 15 Hours and Practical 10 Hours, 20 marks)
Module III
Ms-Power Point : Power point - Basics - Terminology - Getting started - Views
-Creating presentations - Using auto content wizard - Using blank presentation
option -Using design template option - Adding slides Deleting a slide - Importing
images from the outside world - Drawing in power point - Transition and build
effects - Deleting a slide - Numbering a slide - Saving presentation - Closing.
(Theory 9 Hours and Practical 6 Hours, 20 marks)
Module IV
The Internet and its Basic Concepts: Internet concept - History - Development in
India - Technological foundation of internet - Distributed computing -
Client-server computing - Internet protocol suite - Application of distributed
computing - Client-server computing.
(7 Hours, 10 marks)
Module V
Internet protocol suite in the internet environment - Domain Name System (DNS)
-Generic Top Level Domain (g TLD) - Country Code Top Level Domain (cc
TLD) -Indian - Allocation of second level domains - IP addresses - Internet
Protocol Applications of internet in business, Education, Governance, etc.
(Theory 10 Hours, 10marks)