What you'll learn
DIPLOMA IN COMPUTER APPLICATIONS (DCA)
Course Overview
The Diploma in Computer Applications (DCA) is a comprehensive, skill-oriented program designed to provide learners with strong foundational knowledge in computer applications, office automation, programming, and database technologies.
The course focuses on practical training and industry-relevant skills, enabling students to confidently use computers in office, academic, and professional environments.
Duration: 6 Months
Eligibility: 10th Pass & Above
COURSE OBJECTIVES
- To develop fundamental computer literacy and digital skills
- To provide in-depth knowledge of MS Office tools
- To introduce students to programming concepts using C language
- To offer specialization through C++ (OOPS) or Oracle & DBMS
- To prepare learners for entry-level IT and office automation roles
SCHEME OF STUDY
PAPER – I: COMPUTER APPLICATIONS (THEORY & PRACTICAL)
Theory Components
- Introduction to Computer Applications
- Typing Tutor & Speed Practice
- Operating Systems: Windows & Linux
- Word Processing in Detail – MS Word
- Spreadsheet in Detail – MS Excel
- Presentation Tools – MS PowerPoint
- Email & Communication – Outlook Express
- Database Basics – MS Access
- System Tools & Utilities
- Computer Virus & Security
- Internet, E-Commerce & Digital Services
- Digital Transactions, Online Payments & OTP Systems
Practical Training
- Hands-on practice in MS Word, Excel & PowerPoint
- Typing speed improvement exercises
- Internet usage & email handling
- Practical exposure to digital transactions and online tools
PAPER – II: PROGRAMMING & ELECTIVE (THEORY & PRACTICAL)
C Programming (Core Module)
Theory Topics
- Overview of C Programming Language
- Program Structure & Syntax
- Data Types, Variables & Constants
- Operators & Expressions
- Control Structures (Decision & Looping Statements)
- Arrays & Strings
- Pointers & Memory Allocation
- Functions & Recursion
- User-Defined Data Types (Structures, Unions, Enumerators)
- Storage Classes
- Header File Creation
- File Handling
- Basic Graphics Programming
- Introduction to Data Structures
Practical Training
- Writing and executing C programs
- Logic building and debugging
- File handling programs
- Mini programming assignments
ELECTIVE MODULE (Choose Any One)
Option 1: Object Oriented Programming with C++
Theory Topics
- Principles of Object-Oriented Programming
- Data Types & Operators
- Control Statements
- Arrays & Pointers
- Structures & Unions
- Functions in C++
- Classes & Objects
- Constructors & Destructors
- Operator Overloading
- Inheritance & Polymorphism
- C++ Input / Output
- Recent Enhancements in C++
Practical Training
- Developing C++ programs
- Class-based applications
- Object-oriented problem solving
Option 2: Oracle & DBMS
Theory Topics
- Introduction to Database Management Systems
- Introduction to Oracle
- Schema Manager & Table Creation
- SQL Queries
- Data Manipulation using SQL
- SQL Tables, Views & Sequences
- SQL*Plus for Reports
- Introduction to PL/SQL
Practical Training
- Writing SQL queries
- Creating and managing databases
- Generating reports using SQL*Plus
FEES STRUCTURE
Course Fees: ₹25,000
Discounted Fees
- General Category: ₹13,280
- SC / ST: ₹11,952
Installment Plans
General Category
- ₹6,890 × 2 = ₹13,780
- ₹3,570 × 4 = ₹14,280
SC / ST / PH / DP
- ₹6,226 × 2 = ₹12,452
- ₹3,238 × 4 = ₹12,952
CAREER OPPORTUNITIES
After completing DCA, students can work as:
- Computer Operator
- Office Assistant
- Data Entry Operator
- Junior Programmer
- IT Support Executive
- Administrative Assistant
COURSE OUTCOME
On successful completion, learners will be able to:
- Operate computers confidently in professional environments
- Use MS Office applications effectively
- Write basic programs using C / C++
- Understand database concepts and SQL
- Perform digital transactions safely
Show More
Course Syllabus
DIPLOMA IN COMPUTER APPLICATIONS (DCA)
COURSE SYLLABUS
Course Name: Diploma in Computer Applications (DCA)
Duration: 6 Months
Eligibility: 10th Pass and Above
Mode: Classroom / Practical
Medium: English / Hindi
COURSE OBJECTIVES
- To provide fundamental knowledge of computer systems and applications
- To develop proficiency in office automation tools
- To introduce programming concepts using C language
- To provide specialization in either C++ (OOPS) or Oracle & DBMS
- To enhance employability in IT and office-based roles
SCHEME OF STUDY
PAPER – I: COMPUTER APPLICATIONS
THEORY
Unit 1: Introduction to Computers
- Basics of computer systems
- Input & output devices
- Memory and storage devices
- Types of software
Unit 2: Typing Tutor & Keyboard Skills
- Keyboard layout
- Typing techniques
- Speed and accuracy practice
Unit 3: Operating Systems
- Introduction to Operating Systems
- Windows OS features and functions
- Linux OS basics
- File and folder management
Unit 4: Word Processing (MS Word – Detailed)
- Creating, editing, and formatting documents
- Page setup and printing
- Tables, images, and charts
- Mail merge
- Templates and styles
Unit 5: Spreadsheet (MS Excel – Detailed)
- Worksheets and workbooks
- Cell referencing and formatting
- Formulas and functions
- Charts and graphs
- Data sorting and filtering
Unit 6: Presentation Tools (MS PowerPoint)
- Creating presentations
- Slide layouts and design
- Animations and transitions
- Presentation delivery
Unit 7: Email & Communication Tools
- Email concepts
- Outlook Express
- Email creation and management
- Attachments and security
Unit 8: Database Basics (MS Access)
- Introduction to databases
- Tables, queries, forms, and reports
- Data entry and management
Unit 9: System Tools & Computer Security
- System utilities
- Backup and restore
- Computer viruses
- Antivirus and security measures
Unit 10: Internet, E-Commerce & Digital Services
- Internet concepts and web browsing
- Search engines
- E-commerce fundamentals
- Digital transactions
- Online payments and OTP systems
PRACTICAL – PAPER I
- MS Word practical exercises
- MS Excel practical exercises
- PowerPoint presentation creation
- Typing speed test
- Internet and email practical
PAPER – II: PROGRAMMING & ELECTIVE
PART A: C PROGRAMMING
THEORY
Unit 1: Introduction to C
- History and features of C
- Program structure
- Compilation process
Unit 2: Data Types & Operators
- Variables and constants
- Data types
- Operators and expressions
Unit 3: Control Structures
- Decision-making statements
- Looping statements
Unit 4: Arrays & Strings
- One-dimensional and multi-dimensional arrays
- String handling functions
Unit 5: Pointers & Memory Allocation
- Pointer concepts
- Dynamic memory allocation
Unit 6: Functions
- User-defined functions
- Recursion
- Header files
Unit 7: User-Defined Data Types
- Structures
- Unions
- Enumerators
Unit 8: Storage Classes
- Auto, static, extern, register
Unit 9: File Handling
- File operations
- Sequential and random files
Unit 10: Graphics & Data Structures
- Basic graphics programming
- Introduction to data structures
PRACTICAL – C PROGRAMMING
- Program writing and execution
- Debugging techniques
- File handling programs
PART B: ELECTIVE (ANY ONE)
OPTION 1: OBJECT ORIENTED PROGRAMMING WITH C++
Theory
- OOPS concepts
- C++ data types and operators
- Control statements
- Arrays, pointers, structures
- Functions and classes
- Constructors and destructors
- Operator overloading
- Inheritance
- Polymorphism
- C++ input/output
- Recent enhancements in C++
Practical
- Object-oriented program development
- Class-based applications
OPTION 2: ORACLE & DBMS
Theory
- DBMS concepts
- Introduction to Oracle
- Schema objects
- SQL queries
- SQL for data manipulation
- Tables, views, and sequences
- SQL*Plus
- PL/SQL basics
Practical
- SQL query writing
- Database creation and management
- Report generation
EXAMINATION & EVALUATION
- Theory examination
- Practical examination
- Internal assessment
CERTIFICATION
Successful candidates will be awarded the Diploma in Computer Applications (DCA).
CAREER OPPORTUNITIES
- Computer Operator
- Office Assistant
- Data Entry Operator
- Junior Programmer
- IT Support Executive
Bestseller
