Computer Applications Courses Mode: Regular Code: DCA-6M 📍 Ranchi & Daltonganj

DCA – Diploma in Computer Applications

Diploma in Computer Applications (DCA)

Awarding Institution: The Earth Computer Institute

🏛️ Govt. Recognized Diploma Certificate for Jobs

Comprehensive 6-month government-aligned diploma covering Computer Fundamentals, Windows OS, MS Word, Excel, PowerPoint, Access, Internet & Tally ERP/Prime basics.

Duration: 6 Months (Diploma Certificate)

Study Mode: Regular

Fees: Contact Institute / Customizable

Batches: Morning & Evening

💬 WhatsApp Syllabus

Eligibility: Class 10th / 12th Pass or Equivalent

University/Center: The Earth Computer Institute

Course Fee: Contact Institute / Customizable

Certification: Verified & Recognized

Course Overview

DCA (Diploma in Computer Applications) is a premier 6-month certified diploma program that transforms students into computer-literate office professionals. Recognized for government job eligibility, private sector clerical roles, and digital office management, this course provides exhaustive practical training in Windows, Microsoft Office Suite (Word, Advanced Excel, PowerPoint, Access), Typing Speed enhancement, Internet Security, and Accounting fundamentals.

Detailed Syllabus & Modules

6 Structured Modules

1 Module 1: Computer Fundamentals & Windows OS

› History, Generations, Hardware & Software Components of Computers
› Operating System Concepts: Windows 10/11 Navigation, File Explorer, Control Panel
› Keyboard Mastery, Typing Speed & Accuracy Improvement (English & Hindi)
› System Utilities, Antivirus, Printer/Scanner Setup, and Troubleshooting

2 Module 2: Microsoft Word (Professional Document Creation)

› Word Processing, Document Formatting, Typography, Styles, Margins
› Tables, Headers, Footers, Page Borders, Watermarks, Cover Pages
› Mail Merge automation, Certificates, Official Letters, Resume Drafting
› Track Changes, Comments, Proofing, PDF Export and Printing standards

3 Module 3: Microsoft Excel (Data Management & Formulas)

› Worksheets, Cells, Ranges, Data Types, Formatting and Sorting
› Formulas: SUM, AVERAGE, COUNT, IF, Nested IF, VLOOKUP, HLOOKUP, XLOOKUP
› Conditional Formatting, Data Validation, Dropdown Lists, Freeze Panes
› Pivot Tables, Pivot Charts, Financial & Statistical Calculations, Invoicing

4 Module 4: Microsoft PowerPoint & Access

› Slide Design, Master Slides, Animations, Transitions, Audio/Video Embeds
› Business Presentations, Pitch Decks, Kiosk presentations
› MS Access: Database creation, Tables, Queries, Forms, and Report Generation

5 Module 5: Internet, Email, Cyber Safety & E-Governance

› Web Browsers, Search Engines, Cloud Storage (Google Drive / OneDrive)
› Professional Email Etiquette, Attachments, Spam Filtering
› Cyber Safety: Phishing awareness, Two-Factor Authentication, Online Banking safety
› E-Governance: Online Application portals, Digilocker, Digital Signatures

6 Module 6: Accounting Basics & Practical Project

› Introduction to Computerized Accounting concepts
› Basic Ledger, Cash Book, Journal Entries overview in Tally
› Comprehensive Viva, Speed Typing Test, and Capstone Office Project

🎯 What You Will Master

✓ Gain professional proficiency in complete Microsoft Office Suite.
✓ Create automated spreadsheets with VLOOKUP, Pivot Tables, and formulas.
✓ Draft official government and corporate letters, reports, and presentations.
✓ Attain Government Job eligibility with recognized DCA Diploma Certification.

💼 Career Opportunities

★ Data Entry Operator (DEO)
★ Office Assistant / Computer Operator in Govt / PSU / Private Sector
★ Front Desk Coordinator / Administrative Assistant
★ Billing & Inventory Executive

Admissions Open

Enquire for DCA – Diploma in Computer Applications

Get syllabus PDF, batch schedule, and fee details.

+91

📍 Ranchi Lab: Circular Rd, Near Lalpur Chowk

📍 Daltonganj Lab: Redma Chowk / Court More

📞 Direct Call: +91-7677850666

Related Courses

ADCA – Advanced Diploma in Computer Applications 1 Year (12 Months Diploma) C Programming 2 Months (45 Hours) C++ Programming 2.5 Months (50 Hours)