Office Automation Tools

Objective:
The course is designed with an objective to introduce the various features of Office suite.

Learning Outcome:
On completion of the course, students will be able to
 Perform documentation using various Office suite.
 Perform accounting operation using various Office suite.
 Design PowerPoint presentation using various Office suite.

Unit I:
Introduction to open office / MS office / Libre office 2L

Unit II:
Word Processing: Formatting Text, Pages, Lists, Tables 5L

Unit III:
Spreadsheets: Worksheets, Formatting data, creating charts and graphs, using formulas and
functions, macros, Pivot Table 5L

Unit IV:
Presentation Tools: Adding and formatting text, pictures, graphic objects, including charts,
objects, formatting slides, notes, hand-outs, slide shows, using transitions, animations 4L

Books Recommended:

1. Sushila Madan , Introduction to Essential tools,JBA,2009.
2. Anita Goel, Computer Fundamentals, Pearson, 2012
Computer Lab Based on Office Automation:
 Various Office package (Word processing, Spreadsheet and Presentation)