DIPLOMA IN OFFICE AUTOMATION (1 YEAR)

Diploma in Office Automation (1 YEAR)

1. Fundamentals of Office Automation

• Introduction to Computers
• History and Evolution of Office Automation
• Types of Office Systems
• Overview of Hardware and Software
• Role of IT in Office Administration

2. Operating System (Windows/Linux Basics)

• Introduction to GUI-based Operating Systems
• File Management
• Control Panel & Settings
• Keyboard Shortcuts and Troubleshooting

3. Word Processing (MS Word / Google Docs)

• Creating, Editing, Formatting Documents
• Tables, Lists, Headers, Footers, and Styles
• Mail Merge
• Templates and Document Review
• Printing & Page Setup

4. Spreadsheet Management (MS Excel / Google Sheets)

• Data Entry and Formatting
• Formulas and Functions
• Charts and Graphs
• Pivot Tables
• Data Validation and Filters
• Introduction to Macros

5. Presentation Tools (MS PowerPoint / Google Slides)

• Creating Presentations
• Design & Transitions
• Animations
• Embedding Charts, Videos, and Hyperlinks
• Slide Show & Printing Handouts

6. Database Management (MS Access / LibreOffice Base)

• Basics of Databases and DBMS
• Tables, Queries, Forms, and Reports
• Primary Keys and Relationships
• Basic SQL Concepts

7. Internet and Email Applications

• Browsers and Search Engines
• Email Configuration (Gmail/Outlook)
• Attachments, Folders, and Filters
• Netiquette and Email Writing
• Online Collaboration Tools

8. Digital Communication and Collaboration Tools

• Google Workspace: Docs, Sheets, Drive, Forms
• Microsoft Teams, Zoom, Slack
• Task Management Tools (e.g., Trello, Asana)
• Cloud Storage & File Sharing

9. Office Equipment Handling

• Printers, Scanners, Photocopiers
• Projectors & Fax Machines
• Troubleshooting Common Issues
• Maintenance and Safety Measures