Office Automation Tools

Unit

Title and Contents

No. of Lecture

1

Introduction

Concept of Windows, Icon, Menu

Desktop

Creating Folders and Shortcuts

Finding Files& Folders

Creating, Copying, Moving and Deleting Files

Windows Explorer

Basic DOS Commands

Word Processing Package

Typing, Editing, Proofing &reviewing

Formatting Text & Paragraph

Automatics Formatting and Styles

Working with Tables

Graphics and Frames

Mail Merge

15

2

Spread Sheet Package

Concept of Worksheet

Working& Editing in Workbooks

Creating Formats & Links

Protecting and Hiding Data

Built in Functions (Mathematical, Statistical, String & Date)

Formatting a Worksheet & Creating Graphics Objects

Creating Charts (Graphics), Formatting and Analyzing Data

Organizing Data in a List (Data Management)

Sharing & Importing Data Printing

Presentation Package

Creating and Editing Slides

Creating and Editing Objects in the Slide Animation

Creating and Running Slideshow Templates

15