CERTIFICATE IN DATA ENTRY & OFFICE AUTOMATION (CDEOA)

Duration: 4 Months

Class Schedule: 2 classes per week, 2 hours each

Eligibility: 10th Pass

Fees: ₹8000 (GEN), ₹7200 (SC/ST/DP)

SCHEME OF STUDY

Paper-I: Theory

This part of the course focuses on building foundational computer knowledge and practical office automation skills. Here’s a detailed breakdown:

1. Introduction to Computers (FOC)

• Basics of computers: Definition, components, types of computers.
• Input & output devices, storage devices.
• Software vs Hardware.
• Operating principles of computers.

1. Typing Tutor

• Basics of typing using software-based tutors.
• Techniques to improve speed and accuracy.
• Introduction to touch typing.

1. Operating Systems (Windows/Linux)

• Functions and types of operating systems.
• Using Windows: File management, Control Panel, Task Manager.
• Introduction to Linux: Basic commands, file handling, and navigation.

1. Advanced Word Processing (MS Word 365 in Detail)

• Creating, formatting, and editing documents.
• Using templates, styles, and themes.
• Working with tables, charts, and graphics.
• Mail merge, tracking changes, comments, and advanced printing options.

1. Spreadsheet (Advanced MS Excel 365 in Detail)

• Entering and formatting data, formulas, and functions.
• Data analysis: Sorting, filtering, conditional formatting.
• Advanced tools: Pivot Tables, Charts, Macros, and Data Validation.
• Use of Excel for accounting, finance, and reporting.

1. Presentation Using MS PowerPoint 365

• Creating professional slideshows.
• Using animations, transitions, and multimedia.
• Tips for effective presentations.

1. Use of DigiLocker

• Understanding DigiLocker for storing and sharing digital documents.
• Linking Aadhaar, government documents, certificates, and e-documents.

1. Internet, E-Commerce & Data Entry

• Basics of the Internet and its uses.
• Introduction to e-commerce platforms and online transactions.
• Data entry techniques and accuracy standards.

1. E-mail, Social Networking & e-Governance Services

• Setting up and using email effectively.
• Social media basics for professional purposes.
• Overview of e-governance services in India (online public services).

1. Digital Financial Tools & Applications

• Introduction to UPI, mobile wallets, net banking.
• Digital payments security and transactions.

1. Overview of Cybersecurity

• Basic concepts of cybersecurity.
• Common threats: phishing, malware, ransomware.
• Safe browsing and data protection.

1. Overview of Future Skills and Artificial Intelligence

• Introduction to AI, Machine Learning, and emerging tech.
• Practical use of AI tools like Copilot & ChatGPT for productivity.

Paper-I: Practical

The practical sessions are hands-on and focus on building real-world skills.

1. Typing Practice & Typing Speed Test

• Learn to type efficiently in English (and optionally regional language).
• Regular practice sessions to improve speed and accuracy.
• Timed tests to measure typing speed (words per minute - WPM) and accuracy.

1. MS Office Practical

• Word: Document creation, formatting, mail merge, table creation.
• Excel: Formulas, pivot tables, charts, macros, data validation exercises.
• PowerPoint: Designing slides, applying transitions, multimedia insertion.

1. Internet & Email Practical

• Sending and receiving emails, attachments, and professional email etiquette.
• Using online tools, browsing, and research.

1. Data Entry Exercises

• Hands-on data entry projects using MS Excel and other applications.
• Learning speed, accuracy, and error checking.

1. DigiLocker & e-Governance Tools Practice

• Uploading documents, linking Aadhaar, downloading e-certificates.

1. AI Tools Practice

• Using ChatGPT and Copilot for document drafting, summarization, and data processing tasks.

✅ Skills You Will Gain

• Professional typing and data entry skills.
• Advanced MS Office (Word, Excel, PowerPoint) proficiency.
• Internet literacy, email etiquette, and digital payments knowledge.
• Awareness of cybersecurity practices.
• Basic knowledge of AI tools and future-ready digital skills.