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:English / Hindi
Price:₹22,500₹25,000
View Curriculum

Course Syllabus & 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

Hands-On 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

Hands-On 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

Hands-On 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

Hands-On 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)

Hands-On 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

Hands-On 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

Hands-On Projects:

  • Employee Record System

Module 8: Microsoft Outlook

1 week

Topics Covered:

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

Hands-On 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

Hands-On 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)

Hands-On 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

Hands-On 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

Hands-On 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

Hands-On Projects:

  • Module-wise Practical File

Module 14: Final Project

1 week

Topics Covered:

  • Project Planning
  • Implementation
  • Documentation
  • Presentation

Hands-On Projects:

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

What You'll Learn

  • 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

Requirements & Prerequisites

  • •10th Pass / 12th Pass / Equivalent
  • •Basic willingness to learn computer operations from scratch
  • •No prior computer experience required

Certification

Industry-Recognized Credential

Verified Certificate of Completion from The Geek Institute of Cyber Security upon successful completion of the course curriculum, practical labs, and projects.

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: ₹10,000 (₹2,000 discount)
  2. Quarterly: ₹5,000 × 2 installments
  3. Monthly: ₹2,000 × 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.

Ready to start your tech journey?

Enroll now in Diploma in Computer Applications (DCA) and gain practical skills, live industry mentorship, and verified certification.

Price:₹22,500₹25,000

Related Courses & Programs

Advanced Diploma in Computer Applications (ADCA)
Featuredcourse
Advanced Diploma in Computer Applications (ADCA)
This 1-year professional computer application course provides practical training in computer fundamentals, Windows & system utilities, Microsoft Office (Word, Excel, PowerPoint, Access, Outlook), internet & digital communication, web designing with HTML5/CSS3, PHP & MySQL, TallyPrime with GST, AI tools, cyber security, and typing skills. Students gain hands-on experience with 150+ Excel functions, responsive web design, PHP/MySQL CRUD applications, TallyPrime accounting, and AI tools like ChatGPT, Microsoft Copilot, Google Gemini, and DeepSeek through practical projects and a final capstone project, preparing them for careers such as Computer Operator, Office Executive, Data Entry Operator, Computer Teacher, MIS Executive, Web Designer, Tally Operator, and Technical Support Executive, or for higher studies in IT and Computer Applications.
MS OfficeAdvanced ExcelHTML/CSSPHP
Category:Computer Fundamentals
Level:intermediate
Duration:12 months
View Details
Geek Certified Cyber Security Professional (GCCSP)
Featuredcourse
Geek Certified Cyber Security Professional (GCCSP)
This 12-month career transformation program provides practical training in ethical hacking methodology, Linux & network security, web application penetration testing, advanced exploitation, Active Directory attacks, cloud & IoT security, digital forensics, mobile security, blockchain security, and AI in cyber security. Students gain hands-on experience with industry-standard tools like Kali Linux, Metasploit, Burp Suite, Ghidra, Wireshark, and Nmap, while building a professional portfolio through real-world labs, CTF challenges, and a final capstone project, preparing them for careers as Penetration Testers, Security Analysts, SOC Analysts, and Cyber Security Consultants.
Ethical HackingPenetration TestingNetwork SecurityWeb Application Security
Category:Cyber Security
Level:beginner
Duration:12 months
View Details
Advanced Diploma in Full Stack Web Development (MERN)
Featuredcourse
Advanced Diploma in Full Stack Web Development (MERN)
This 12-month career transformation program provides practical training in HTML5, CSS3, Tailwind CSS, JavaScript (ES6+), React.js with Redux, Node.js, Express.js, MongoDB, MySQL, TypeScript, Next.js, GraphQL, Redis, and DevOps with Git, Docker, and AWS. Students gain hands-on experience through 20+ real-world projects including e-commerce platforms, social media apps, SaaS dashboards, and a final capstone project, preparing them for careers as Full Stack Developer, Frontend Engineer, Backend Developer, MERN Stack Developer, and Software Engineer with an average salary of ₹6-15 LPA.
MERN StackReact.jsNode.jsMongoDB
Category:Web Development
Level:beginner
Duration:12 months
View Details