1.5 [Link].
FinTech Semester-1: Detail Syllabus
Course: Office Automation
Course Code:
Semester: I Program: [Link]. FinTech
Teaching Scheme Evaluation Scheme
Contact CCE CCE SEE SEE
Lecture Tutorial Practical Total
Hours Theory Practical Theory Practical
2 0 4 4 25 25 25 25 100
COURSE OBJECTIVES
The course is designed to enable the student:
1. To master advanced features of word processors for business documentation.
2. To develop expertise in spreadsheet functions, formulas, and data analysis tools.
3. To create professional presentations and understand digital communication etiquette.
4. To explore workflow automation and AI tools for productivity.
COURSE OUTCOMES
After successful completion of the course, the students will be able to:
CO1: Create professional business documents using advanced word processing features like mail merge and
styles.
CO2: Perform complex data analysis using spreadsheet functions (VLOOKUP, IF) and Pivot Tables.
CO3: Design effective presentations using master slides and multimedia elements.
CO4: Apply professional etiquette for email, calendar management, virtual meetings, and use automation/AI
tools.
COURSE CONTENTS
Unit-I Operating Systems & Document Processing: 7.5 Hrs.
Windows/Linux basics, file management. Word processing: advanced formatting, styles,
TOC, mail merge. Google Docs/Microsoft 365 collaboration.
Unit-II Spreadsheet Applications: 7.5 Hrs.
Cell referencing, conditional formatting. VLOOKUP, HLOOKUP, XLOOKUP, IF,
AND, OR. Pivot tables, pivot charts, slicers.
Unit-III Presentation & Digital Communication: 7.5 Hrs.
Master slides, multimedia embedding. Email etiquette, Outlook/Gmail scheduling.
Virtual collaboration (Zoom, Teams, Slack).
Unit-IV Automation & Productivity Tools: 7.5 Hrs.
Power Automate/Zapier, Google/Microsoft Forms. AI chatbots (Gemini/ChatGPT) for
drafting, summarization, data organization.
List of Assignments:
Sr.
Name of Assignment Unit Description
No.
Create business letter with styles and
1 Word Document Formatting 1
formatting.
2 Mail Merge Exercise 1 Create mail merge for invitation letters.
Use VLOOKUP, IF, SUMIF, COUNTIF
3 Excel Formulas Practice 2
functions.
4 Pivot Table Report 2 Create pivot table for sales data analysis.
5 Excel Dashboard 2 Create interactive dashboard with slicers.
Create business presentation with master
6 Professional Presentation 3
slides.
7 Email Etiquette Guide 3 Write guide on professional email writing.
8 Google Forms Survey 4 Create survey form and analyze responses.
Write report on using Gemini/ChatGPT for
9 AI Chatbot Usage Report 4
productivity.
Create simple automation using Zapier/MS
10 Workflow Automation 4
Power Automate.
List of Experiments:
Sr.
Name of Assignment Unit Description
No.
1 Create and Format Word Document 1 Create document with styles, tables, images.
2 Mail Merge in Word 1 Create mail merge with Excel data source.
3 Excel Formulas and Functions 2 Practice VLOOKUP, IF, AND, OR functions.
4 Pivot Table Creation 2 Create pivot table and pivot chart.
Create dashboard with multiple charts and
5 Excel Dashboard 2
slicers.
Create presentation with animations and
6 PowerPoint Presentation 3
transitions.
Create form, collect responses, analyze in
7 Google Forms Survey 4
Sheets.
8 Google Calendar and Email 4 Schedule meetings, manage calendar.
9 AI Chatbot Productivity 4 Use AI for drafting emails, summarization.
Participate in Zoom/Teams meeting, record
10 Virtual Meeting Best Practices 4
minutes.
CO & PO Mapping Table:
POs PSOs
COs
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 - - - - - 2 -
CO2 2 - - - - - 2 -
CO3 - 2 - - - - 2 -
CO4 - 2 - - - - 2 -
REFERENCE BOOKS
Microsoft Office 365: In Practice by Randy Nordell (McGraw-Hill)
Excel 2023: The Ultimate Guide by Nathan George
Google Workspace User Guide by Balaji Iyer