Program : Diploma in Printing Technology
Course Title: Office Automation
Course Code : 2109
Workshop
Semester : 2 Credits: No Credit
Course Category: Engineering Science
Periods per week: 3 (L:0 T:0 P:3) Periods per semester: 45
Course Objectives:
To provide the knowledge of IT tools that would enable the students in crafting
professional word documents, excel spread sheets & power point presentations.
To familiarize with the preparation of documents and presentations with office
automation tools.
Course Prerequisites:
Course
Topic Course name Semester
code
IT systems Introduction to IT systems I
Course Outcomes:
On completion of the course ,the student will be able to:
Duration Cognitive
COn Description
(Hours) Level
CO1 Perform word processing and documentation. 16 Applying
Perform spreadsheet preparation and accounting
CO2 15 Applying
operations.
CO3 Develop power point presentation skills. 10 Applying
Lab Exam 4
CO – PO Mapping
Course
PO1 PO2 PO3 PO4 PO5 PO6 PO7
Outcomes
CO1 2 2
CO2 2 2
CO3 2 2
CO4
3-Strongly mapped, 2-Moderately mapped, 1-Weakly mapped
Course Outline:
Module Duration Cognitive
Name of Experiment
Outcomes (Hours) Level
CO1 To perform word processing and documentation.
Overview on Microsoft word & realize the
importance of MS Word as word Processor.
M1.01 Word Orientation with Accessing, Overview 6 Applying
of toolbars, Saving files, Using help and
resources, Rulers, Format Painter.
Create Project Certificate with Formatting
Fonts in word, Drop Cap in word, Applying
Applying
M1.02 Text effects, Using Character Spacing, 3
Borders and Colors, Inserting Header and
Footer, Using Date and Time option in Word.
Create Project Abstract with Formatting
Styles, Inserting table, Bullets and
M1.03 Numbering, Changing Text Direction, Cell 3 Applying
alignment, Footnote, Hyperlink, Symbols,
Spell Check, Track Changes.
Create Newsletter with Table of Content,
M1.04 Newspaper columns, Images from files and 2 Applying
clipart, Drawing toolbar and Word Art,
Formatting Images, Textboxes and Paragraphs.
Create Feedback Form with Forms, Text
M1.05 2 Applying
Fields, Inserting objects, Mail Merge in Word.
Lab exam I 2
CO2 To perform spreadsheet preparation and accounting operations.
Excel Orientation: Overview on Microsoft Excel and
understand the importance of MS Excel as a
M2.01 Applying
Spreadsheet tool. Accessing, Overview of toolbars, 4
Saving excel files, Using help and resources.
Create a Scheduler with Gridlines, Format Cells,
M2.02 Applying
Summation, auto fill, Formatting Text. 3
Perform Calculations: Cell Referencing, Formulae
in excel –average, standard deviation, Charts,
M2.03 Renaming and Inserting worksheets, Hyper Applying
3
linking, Count function, LOOKUP/VLOOKUP.
Performance Analysis: Split cells, freeze panes,
M2.04 group and outline, Sorting, Boolean and logical 3 Applying
operators, Conditional formatting.
Prepare Cricket Score Card: Pivot Tables,
M2.05 Interactive Buttons, Importing Data, Data 2 Applying
Protection and Data Validation.
CO3 To develop power point presentation skills
PPT Orientation, Slide Layouts, Inserting Text,
M3.01 Word Art, Formatting Text, Bullets and 2 Applying
Numbering, Auto Shapes, Lines and Arrows.
Hyperlinks, Inserting –Images, Clip Art, Audio,
M3.02 3 Applying
Video, Objects, Tables and Charts
Master Layouts (slide, template, and notes),
Types of views (basic, presentation, slide slotter,
notes etc), Inserting – Background, textures,
M3.02 3 Applying
Design Templates, Hidden slides. Auto content
wizard, Slide Transition, Custom Animation,
Auto Rehearsing.
Power point test would be conducted. Students
will be given model power point presentation Applying
M3.02 2
which needs to be replicated (exactly how it’s
asked).
Lab exam II 2
Text / Reference:
Book
T/R
Title/Author
T1 Computer Basics with Office Automation by Archana Kumar.
Exploring of Computer Fundamentals & Office Automation by Angeline D
R1
Magdalena Delighta.
R2 Office Automation by Don Tapscott.
R3 Excel 2019 All in One by Lokesh Lalwani.
Online Resources:
Sl No Website/ Link
1 www.office.com
2 http://products.office.com
3 https://khpditweebly.weebly.com/office-automation-notes.html
