Diploma In Computer Applications

1. Computer Fundamentals

• Introduction to computers
• History & evolution
• Types of computers
• Hardware & software concepts
• Input/Output devices
• Memory and storage basics
• Binary number systems
• File and folder management

. Operating Systems

• Basics of OS
• Windows OS (GUI, file system, utilities)
• Introduction to Linux (basic commands, file management)
• Control Panel and system settings

3. MS Office Suite

MS Word

• Creating, formatting, printing documents
• Mail merge, tables, templates

MS Excel

• Formulas and functions
• Charts, data sorting, filtering

MS PowerPoint

• Slide creation, animations, transitions

(Often Included) MS Access

• Basic database operations, tables, queries, forms

4. Internet & Email

• Internet basics
• Web browsers & search
• Email creation and etiquette
• Cyber safety basics

5. Database Management System (DBMS)

• Database concepts
• Tables, queries, simple SQL
• Use of DBMS in applications

6. Programming Fundamentals

• Introduction to programming logic
• Basic constructs (variables, loops, arrays)
• C/C++ or another simple language (varies by institute)

7. Spreadsheet & Presentation

• Advanced spreadsheet skills (filters, pivot tables)
• Creating effective presentations and slides

8. Practical Training & Project Work

Most DCA programs include lab sessions, assignments, and a final project to apply what you’ve learned in real scenarios.

Typical Structure (Example)

Semester / Module Typical Topics Covered

Module 1 / Semester 1Computer Fundamentals, OS, MS Office (Word, Excel)

Module 2 / Semester 2Internet & Email, DBMS, Programming basics, Projects

Summary of Key Areas

✔ Computer Basics & terminology

✔ Windows & Linux OS

✔ MS Office Suite (Word, Excel, PowerPoint, Access)

✔ Internet and Email skills

✔ Database fundamentals (DBMS/SQL basics)

✔ Introductory Programming

✔ Practical projects & assignments.