📍 Ranchi Campus Practical Training

DCA – Diploma in Computer Applications Course in Ranchi

Master DCA – Diploma in Computer Applications with 1:1 computer lab training at The Earth Computer Institute Ranchi branch (Opposite City Center, Lalpur Chowk). Personalized guidance for college exams, competitive programming, and corporate job placements.

📞 +91-7677850666

Ranchi Lab Batch Highlights

⏱️ Course Duration: 6 Months (Diploma Certificate)

🎯 Eligibility: Class 10th / 12th Pass or Equivalent

📍 Campus: Circular Road, Near Lalpur Chowk, Ranchi, Jharkhand - 834001

⏰ Lab Hours: Monday - Saturday: 7:00 AM - 8:00 PM | Sunday: Special Batches

✓ 2-Day Free Demo Class Available in Ranchi

Why Learn DCA – Diploma in Computer Applications at The Earth Institute Ranchi?

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.

At our Ranchi campus, students receive individual high-performance PC access with modern IDEs and compilers. Our experienced instructors conduct step-by-step code walkthroughs, weekly module assessments, and project code reviews.

Complete DCA – Diploma in Computer Applications Syllabus (6 Modules)

Module 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

Module 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

Module 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

Module 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

Module 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

Module 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

Learning Outcomes & Skills

✓ 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.

New Batches in Ranchi

Enroll for DCA – Diploma in Computer Applications

Reserve your workstation at our Ranchi lab.

Campus: Circular Road, Near Lalpur Chowk, Ranchi, Jharkhand - 834001

Helpline: +91-7677850666