courseComputer FundamentalsbeginnerFeatured

Diploma in Computer Applications (DCA)

This 6-month industry-oriented diploma course provides practical training in computer fundamentals, Windows & system utilities, Microsoft Office (Word, Excel, PowerPoint, Access, Outlook), internet & email, web designing with HTML5/CSS3, AI tools, and typing skills. Students gain hands-on experience with 100+ Excel functions, HTML & CSS website basics, cloud tools like Google Drive and OneDrive, and AI tools like ChatGPT, Microsoft Copilot, and Google Gemini through practical assignments and a final project, preparing them for entry-level careers such as Computer Operator, Office Assistant, Data Entry Operator, and Junior Computer Teacher, or for further studies such as the Advanced Diploma in Computer Applications (ADCA).

Duration: 6 months
Mode: online/offline
Language: Hindi/English
View Curriculum

Curriculum

Module 1: Computer Fundamentals

2 weeks

Topics Covered:

  • Introduction to Computers
  • History & Generations of Computers
  • Types of Computers
  • Hardware & Software Concepts
  • Input & Output Devices
  • CPU, Memory & Storage Devices
  • Number System Basics
  • Operating System Fundamentals
  • File & Folder Management
  • Computer Languages (Overview)
  • Computer Maintenance Basics
  • Networking Fundamentals
  • Data Backup & Recovery
  • Digital Ethics & Green Computing

Projects:

  • Computer Hardware Identification

Module 2: Microsoft Windows & System Utilities

2 weeks

Topics Covered:

  • Windows Interface & Navigation
  • Desktop & Taskbar Customization
  • File Explorer & File Management
  • Control Panel & Settings
  • User Accounts
  • Device Manager
  • Disk Management
  • Disk Cleanup & Storage Optimization
  • Windows Security
  • Backup & Restore
  • ZIP/UnZIP Files
  • Printer Installation
  • Basic Troubleshooting

Projects:

  • System Setup & Maintenance Assignment

Module 3: Office Productivity Tools

1 week

Topics Covered:

  • Microsoft Paint
  • Notepad
  • WordPad
  • Snipping Tool
  • Calculator
  • Sticky Notes
  • Character Map
  • PDF Creation & Management
  • File Compression Utilities

Projects:

  • Digital Document Toolkit

Module 4: Microsoft Word

2 weeks

Topics Covered:

  • Document Creation
  • Text & Paragraph Formatting
  • Tables
  • Images & Shapes
  • SmartArt & WordArt
  • Headers & Footers
  • Page Layout
  • Mail Merge
  • Templates
  • References
  • Document Protection
  • Printing & PDF Export

Projects:

  • Professional Resume
  • Mail Merge Project

Module 5: Microsoft Excel

5 weeks

Topics Covered:

  • Excel Features
  • Workbook & Worksheet Management
  • Cell Referencing
  • Formatting
  • Conditional Formatting
  • Data Validation
  • Sorting & Filtering
  • Tables
  • Charts
  • Pivot Tables
  • Basic Dashboards
  • 100+ Excel Functions & Formulas
  • Logical Functions (IF, AND, OR, IFS)
  • Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP, LOOKUP)
  • Math Functions (SUM, MIN, MAX, AVERAGE, COUNT)
  • Conditional Functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS)
  • Text Functions (LEFT, RIGHT, MID, LEN, CONCAT, TEXTJOIN)
  • Date & Time Functions (DATE, TIME, TODAY, NOW)
  • Financial Functions (PMT, PV, FV)
  • Information Functions (IFERROR, ISNUMBER, ISTEXT)
  • Dynamic Functions (FILTER, SORT, SEQUENCE)

Projects:

  • Sales Report Dashboard
  • Excel Data Analysis Assignment

Module 6: Microsoft PowerPoint

2 weeks

Topics Covered:

  • Presentation Creation
  • Themes & Templates
  • SmartArt
  • Charts
  • Images & Multimedia
  • Animations
  • Slide Transitions
  • Hyperlinks
  • Presenter View
  • Printing & Export

Projects:

  • Business Presentation

Module 7: Microsoft Access

2 weeks

Topics Covered:

  • Introduction to Database
  • Creating Tables
  • Primary Keys
  • Relationships
  • Queries
  • Forms
  • Reports
  • Import & Export Data

Projects:

  • Employee Record System

Module 8: Microsoft Outlook

1 week

Topics Covered:

  • Email Configuration
  • Email Management
  • Contacts
  • Calendar
  • Tasks
  • Notes
  • Rules & Signatures
  • Email Security

Projects:

  • Professional Email Setup Assignment

Module 9: Internet & Email

2 weeks

Topics Covered:

  • Internet Fundamentals
  • Web Browsers
  • Search Techniques
  • Google Search
  • Gmail
  • Google Drive
  • OneDrive
  • Cloud Storage
  • Email Writing & Etiquette
  • Online Forms
  • Digital Payments
  • Video Conferencing
  • Online Collaboration
  • Internet Safety & Privacy

Projects:

  • Digital Office Documentation

Module 10: Web Designing (HTML5 & CSS3)

3 weeks

Topics Covered:

  • HTML5
  • HTML Structure
  • Text Formatting
  • Hyperlinks
  • Images
  • Lists
  • Tables
  • Forms
  • Multimedia
  • Semantic Elements
  • CSS3
  • CSS Basics
  • Colors & Fonts
  • Box Model
  • Margin & Padding
  • Flexbox
  • Responsive Design
  • Media Queries
  • Bootstrap (Introduction)

Projects:

  • Personal Portfolio Website

Module 11: Artificial Intelligence (AI)

2 weeks

Topics Covered:

  • Introduction to AI
  • AI in Daily Life
  • Generative AI
  • Prompt Writing Basics
  • ChatGPT
  • Microsoft Copilot
  • Google Gemini
  • AI for MS Office
  • AI for Content Writing
  • AI for Presentations
  • AI Image Generation
  • Responsible Use of AI

Projects:

  • AI-Assisted Office Productivity Project

Module 12: Typing Skills

1 week

Topics Covered:

  • English Typing
  • Hindi Unicode Typing
  • Touch Typing Techniques
  • Keyboard Shortcuts
  • Speed & Accuracy Practice

Projects:

  • Typing Speed Assessment

Module 13: Practical Assignments

1 week

Topics Covered:

  • Microsoft Word Project
  • Excel Data Analysis & Dashboard
  • PowerPoint Presentation
  • Access Database Project
  • HTML & CSS Website
  • AI Productivity Assignment

Projects:

  • Module-wise Practical File

Module 14: Final Project

1 week

Topics Covered:

  • Project Planning
  • Implementation
  • Documentation
  • Presentation

Projects:

  • Personal Portfolio Website
  • Student Information System
  • Employee Record System
  • Sales Report Dashboard
  • Digital Office Documentation
  • AI-Assisted Office Productivity Project

Learning Objectives

  • Understand computer fundamentals, hardware, software, and networking basics
  • Operate and manage Windows systems and basic system utilities
  • Create documents, spreadsheets, and presentations in MS Office
  • Apply 100+ Excel functions to build basic dashboards and reports
  • Manage simple databases using Microsoft Access
  • Build basic websites using HTML5 and CSS3
  • Use internet, email, and cloud storage tools effectively
  • Use AI tools such as ChatGPT, Microsoft Copilot, and Google Gemini for everyday productivity
  • Develop English and Hindi typing speed and accuracy

Why Choose DCA at The Geek Institute of Cyber Security?

The Diploma in Computer Applications (DCA) is a 6-month, industry-oriented foundational program designed to take complete beginners to confident, job-ready computer users. This course builds a strong base in computer fundamentals, MS Office, internet usage, basic web designing, and modern AI tools.

  • Beginner-Friendly Curriculum: 13 structured modules plus a final project — no prior computer knowledge required
  • 100% Practical & Hands-on Training: Every module pairs concept sessions with real assignments
  • 100+ Excel Functions & Formulas: Strong foundation in everyday Excel use, from formulas to basic dashboards
  • HTML5 & CSS3 Website Basics: Build your first website from scratch
  • AI & Prompt Engineering Introduction: Learn ChatGPT, Microsoft Copilot, and Google Gemini for daily productivity
  • Expert Instructors: Learn from experienced trainers in computer applications and office productivity
  • Placement Support: Resume building and interview readiness
  • Professional Certificate: Recognized DCA diploma to start your IT or office administration career

Who Should Enroll?

This course is perfect for:

  • 10th Pass / 12th Pass Students starting their computer education journey
  • First-Time Computer Users wanting a structured, practical introduction
  • Job Seekers wanting entry-level office and computer skills
  • Working Professionals wanting to formalize their basic computer knowledge
  • Students planning to continue into the Advanced Diploma in Computer Applications (ADCA)

Prerequisites: 10th Pass / 12th Pass / Equivalent. No prior computer experience required.

What You'll Build

During this 6-month journey, you'll create a practical portfolio drawn directly from the curriculum:

Office & Productivity Projects

  • Professional Resume and Mail Merge Project (MS Word)
  • Sales Report Dashboard and Excel Data Analysis Assignment (MS Excel)
  • Business Presentation (PowerPoint)
  • Employee Record System (MS Access)
  • Professional Email Setup Assignment (Outlook)

Internet & Web Projects

  • Digital Office Documentation (Internet & Email, Cloud Storage)
  • Personal Portfolio Website (HTML5 & CSS3)

AI & Digital Skills Projects

  • AI-Assisted Office Productivity Project using ChatGPT, Microsoft Copilot, and Google Gemini
  • Typing Speed Assessment

Final Project

Choose from sample projects such as:

  • Personal Portfolio Website
  • Student Information System
  • Employee Record System
  • Sales Report Dashboard
  • Digital Office Documentation
  • AI-Assisted Office Productivity Project

Career Opportunities

DCA prepares you for entry-level career paths:

Office & Administrative Roles (₹8,000 - ₹15,000/month)

  • Computer Operator
  • Office Assistant
  • Data Entry Operator

Teaching & Support (₹8,000 - ₹14,000/month)

  • Junior Computer Teacher
  • Computer Lab Assistant

Further Study Paths

  • Advanced Diploma in Computer Applications (ADCA)
  • Specialized Web Designing courses
  • Advanced Excel & Data Analysis
  • AI Tools & Prompt Engineering Specialization

Learning Experience

Learning Format

  • Duration: 6 months
  • Mode: Online or Offline
  • Structured Learning: Concept sessions, practical labs, and assignments across 13 modules plus a final project
  • Total Hours: 96+ hours of training

Learning Methodology

  • 40% Theory & Concepts
  • 60% Hands-on Practice & Assignments
  • Weekly assignments and module-wise practical files
  • Module-wise assessments
  • Practical Assignments module covering Word, Excel, PowerPoint, Access, HTML & CSS, and AI productivity
  • Final Project with beginner-friendly, real-world deliverables

Course Includes

  • Course Material: Complete notes and practice files for every module
  • Software Access: MS Office and basic web development tools
  • Lab Practice: Individual computer with necessary tools
  • Assessments: Regular tests and project evaluations
  • Certification: Recognized DCA diploma
  • Job Support: Resume review and interview preparation
  • Alumni Access: Lifetime learning community

Fee Structure

Course Fee: ₹12,000 (6 months)

Payment Options:

  1. One-time Payment: ₹11,000 (₹1,000 discount)
  2. Quarterly: ₹6,200 × 2 installments
  3. Monthly: ₹2,100 × 6 installments

What's Included:

  • All course materials and software access
  • Lab access during and after class hours
  • Project guidance and module-wise evaluation
  • Certificate upon completion
  • 6-month post-course support

Certification & Recognition

Upon successful completion, you receive:

  1. DCA Diploma Certificate
  2. Geek Institute Completion Certificate — With grade
  3. Project Completion Certificate — For your final project
  4. Digital Badge — For LinkedIn and resume

Student Success Stories

"DCA gave me my first real computer skills. The Excel module alone helped me get a data entry job within a month of finishing."Priya Sharma, Data Entry Operator

"I had never touched a computer before this course. Starting from Computer Fundamentals made everything easy to follow, and now I work as an office assistant."Mohit Yadav, Office Assistant

"The HTML & CSS module gave me the confidence to build my own portfolio website. I'm now continuing into ADCA to learn more."Kavita Joshi, DCA Graduate continuing to ADCA

Frequently Asked Questions

Do I need any computer knowledge before joining DCA?

No, DCA starts from Computer Fundamentals and is designed for complete beginners.

Is DCA enough to get a job?

DCA builds a strong foundation for entry-level roles such as Computer Operator, Office Assistant, and Data Entry Operator. For more advanced roles, students can continue into the ADCA program.

Can I join ADCA after completing DCA?

Yes, DCA is an ideal first step before joining the Advanced Diploma in Computer Applications (ADCA).

Is online mode available?

Yes, both online and offline modes are available.

Does this course cover web designing?

Yes, the course includes an introduction to HTML5 and CSS3, including a Bootstrap introduction, and you'll build a personal portfolio website.

Are AI tools covered in DCA?

Yes, the AI module covers ChatGPT, Microsoft Copilot, Google Gemini, prompt writing basics, and using AI for MS Office, content writing, presentations, and image generation.

Tags

MS OfficeBasic ExcelHTML/CSSInternet & EmailAI ToolsTyping