🎓 Office Automation Course

✅ Course Duration: 3 Months

✅ Mode: Online/Offline

✅ Eligibility: Basic Computer Knowledge

✅ Objective: To enable students to handle day-to-day computer tasks using office software like MS Word, Excel, PowerPoint, Internet, and Google tools.

This course provides learners with essential computer skills required in modern office environments. Those who are looking to enhance their productivity and efficiency through digital tools will benefit from this course, including students, job seekers, and professionals.

It covers everything from the basics of computer operation to the most advanced office applications. In this course, students learn the fundamentals of computers, operating systems, input/output devices, and file management. Aside from training in essential applications like Notepad, WordPad, and Paint, the course also covers Microsoft Word, Excel, and PowerPoint in-depth.

During the course, participants will be able to create documents, spreadsheets, and presentations, manage data, and perform calculations using formulas and functions. This course also covers Internet usage, email communication, Google Workspace tools (Docs, Sheets, Slides, Forms), and common keyboard shortcuts.

Additionally, this course includes practical knowledge of file handling, printing, scanning, and working with PDFs. By the end of the course, students will be completely prepared to do office work on their own and in a professional way. This will make them more likely to get jobs in a wide range of fields, such as education, administration, finance, and customer service.

✅ Module 1: Introduction to Computers

• What is a Computer?
• Characteristics of Computers
• Types of Computers (Desktop, Laptop, Server, etc.)
• Input Devices (Keyboard, Mouse, Scanner, etc.)
• Output Devices (Monitor, Printer, Speakers, etc.)
• CPU, RAM, Storage Devices (HDD, SSD, USB, etc.)
• How Computers Work (Basic flow of Input → Processing → Output)

✅ Module 2: Operating System Basics

• What is an Operating System?
• Functions of Operating System
• Types of Operating Systems (Windows, Linux, macOS)
• Components of Windows Interface:

1. Desktop
2. Taskbar
3. Start Menu
4. File Explorer

• Creating and Managing Files/Folders
• Control Panel Overview

✅ Module 3: Application Software

• Definition and Importance
• Types of Software:
• System Software
• Application Software
• Examples of Application Software:

1. MS Office (Word, Excel, PowerPoint)
2. Browsers (Chrome, Firefox)
3. Media Players, PDF Readers

• Installing and Uninstalling Software

✅ Module 4: Notepad, WordPad & Paint

📝 Notepad

• Interface of Notepad
• Creating and Saving a Text File
• Editing, Formatting, and Printing Text

🗒️ WordPad

• Difference between Notepad and WordPad
• Formatting Text (Bold, Italic, Underline)
• Inserting Images and Tables
• Page Setup and Print Options

🎨 Paint

• Interface of Paint
• Using Drawing Tools
• Creating Shapes, Adding Colors
• Saving and Printing Drawings

✅ Module 5: Microsoft Word (Word Processor)

• MS Word Interface
• Creating, Saving, Opening Documents
• Formatting Text and Paragraphs
• Using Tables, Images, Shapes, and WordArt
• Page Setup, Header/Footer, Page Numbers
• Mail Merge
• Printing Documents

✅ Module 6: Microsoft Excel (Spreadsheet)

• MS Excel Interface
• Entering Data and Formulas
• Common Functions (SUM, AVERAGE, IF, VLOOKUP)
• Formatting Cells and Worksheets
• Creating Charts and Graphs
• Sorting, Filtering, and Data Validation
• Printing Sheets

✅ Module 7: Microsoft PowerPoint (Presentation)

• MS PowerPoint Interface
• Creating a Presentation
• Slide Layouts and Design Templates
• Adding Text, Images, Videos, and Animations
• Slide Transitions
• Presenting and Printing Slides

✅ Module 8: Internet & Email

• Introduction to Internet and Browsers
• Using Search Engines
• Creating Email Accounts (Gmail/Outlook)
• Sending/Receiving Emails with Attachments
• Email Folders: Inbox, Sent, Draft, Trash
• Online Safety and Etiquette

✅ Module 9: Google Tools

• Google Account Basics
• Google Docs (Like MS Word)
• Google Sheets (Like MS Excel)
• Google Slides (Like PowerPoint)
• Google Forms (Creating Surveys)
• Google Drive – Uploading and Sharing Files

✅ Module 10: Shortcut Keys and Office Management

• Common Shortcut Keys in Windows and MS Office

1. Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + S, etc.
2. Windows + D, Alt + Tab, etc.

• File and Folder Management
• Scanning, Printing, and Creating PDFs
• Digital Signature Basics
• Task Scheduling and Calendar Use