📘 DCA – Diploma in Computer Applications Syllabus (1 Year)

Duration: 1 Year (2 Semesters)

🔹 Semester 1

1. Fundamentals of Computer

• Introduction to Computers
• Characteristics & Types of Computers
• Computer Hardware & Software
• Number System
• Input & Output Devices

2. Operating System (OS) Basics

• Windows / Linux Introduction
• File & Folder Management
• System Tools
• Control Panel Settings

3. Microsoft Office Suite

MS Word

• Formatting
• Mail Merge
• Templates & Tables

MS Excel

• Formulas & Functions
• Charts
• Data Handling

MS PowerPoint

• Slide Design
• Animations
• Presentation Techniques

4. Internet & Multimedia

• Internet Basics
• Email, Browsers, Search Engines
• Multimedia Audio/Video Basics

🔹 Semester 2

5. Programming Fundamentals

• Algorithms & Flowcharts
• Introduction to Programming Logic

6. C Programming / Python (varies by institute)

• Variables, Operators
• Control Statements
• Functions
• Arrays & Strings

7. Database Management System (DBMS)

• Introduction to Databases
• SQL Basics
• Tables, Queries, Forms, Reports
• RDBMS Concepts (MySQL / MS Access)

8. Web Designing

• HTML5 Basics
• CSS3 Styling
• Simple Web Page Development

9. Computer Networks

• Types of Networks
• Network Devices
• Internet Protocols
• Basic Cybersecurity

10. Practical & Project Work

• MS Office Project
• Simple Programming Project
• Webpage Development
• Database Mini Project

✔️ Skills You’ll Gain After DCA

• Basic computer literacy
• Document processing
• Data handling with Excel
• Programming basics
• Web development basics
• Database creation & management
• Internet & digital communication skills

If you want, I can also provide:

📌 A PDF version of the syllabus

📌 Institute-wise syllabus (IGNOU, NIELIT, Rajasthan University, etc.)

📌 Detailed semester-wise notes or study plan

Would you like a specific university’s DCA syllabus?