🏫 DIPLOMA IN OFFICE AUTOMATION – SYLLABUS OUTLINE

1. Fundamentals of Computers

• Introduction to Computers
• Types of Computers and Their Applications
• Computer Hardware Components (CPU, Memory, Input/Output Devices)
• Software – System & Application Software
• Operating Systems Basics (Windows/Linux)
• Computer Networks and Internet Basics

2. Microsoft Office Suite

a) MS Word

• Creating, Editing, Formatting Documents
• Page Setup, Margins, and Printing
• Using Tables, Mail Merge, Headers & Footers
• Working with Templates and Styles

b) MS Excel

• Creating and Managing Worksheets
• Formulas, Functions, and Charts
• Data Sorting, Filtering, and Pivot Tables
• Conditional Formatting and Data Validation

c) MS PowerPoint

• Creating Presentations
• Slide Design, Transitions, and Animations
• Inserting Images, Charts, and Multimedia
• Presentation Tips and Printing Slides

d) MS Access (Optional in some syllabi)

• Introduction to Databases
• Creating Tables, Queries, and Forms
• Generating Reports

e) MS Outlook (Email Management)

• Sending and Receiving Emails
• Calendar and Task Management
• Contacts and Meetings

3. Typing and Data Entry Skills

• English Typing Practice (Speed and Accuracy)
• Numeric Data Entry
• Formatting Office Documents

4. Internet and Web Applications

• Internet Basics & Browsers
• Email Creation and Management
• Online Collaboration Tools (Google Workspace, MS Teams, etc.)
• Cloud Storage and File Sharing

5. Office Management & Communication Skills

• Basics of Office Administration
• Filing and Record Management
• Business Correspondence (Letters, Memos, Reports)
• Telephone and Email Etiquette
• Time Management and Scheduling

6. Practical Project / Internship

• Preparing Business Documents
• Data Handling using Excel
• Presentation on Office Tasks
• Real-World Office Automation Project

7. Optional Modules (Institution-Specific)

• Tally / Accounting Software Basics
• Digital Marketing Fundamentals
• PDF Editing and Scanning Tools
• Basic Graphic Design (Canva / Photoshop)

📜 Course Duration:

6 months – 1 year (depending on institution)

🎓 Eligibility:

10th / 12th pass or equivalent

💼 Career Opportunities:

• Office Assistant
• Data Entry Operator
• Computer Operator
• Executive Assistant
• Front Office Staff
• Administrative Executive