DIPLOMA IN COMPUTER APPLICATION

🎓 Diploma in Computer Application (DCA) – 1 Year Syllabus

1. Computer Fundamentals

• History and evolution of computers
• Types of computers (Analog, Digital, Hybrid)
• Components: Hardware vs Software
• Input/output devices
• Memory types: RAM, ROM, cache, storage devices
• Number systems and binary arithmetic

2. Operating System

• Introduction to Operating Systems
• Features and functions (Windows, Linux basics)
• File and folder management
• System tools and utilities
• User management and permissions (Windows GUI & Linux CLI basics)

3. Microsoft Office Suite

a. MS Word

• Document creation, editing, formatting
• Page layout, tables, mail merge

b. MS Excel

• Spreadsheet basics, formulas, charts, data sorting/filtering

c. MS PowerPoint

• Creating slides, themes, transitions, animations

d. MS Access (Optional based on institute)

• Basic database creation, tables, forms, and reports

4. Internet & Web Technology

• What is the Internet? Browsers and search engines
• Email (Gmail, Outlook), attachments, etiquette
• Cloud storage (Google Drive, OneDrive basics)
• Online safety, cyber security fundamentals
• Basics of e-commerce and social media

5. Programming in C (or Python)

• Introduction to programming concepts
• Variables, operators, data types
• Control structures (if, loops)
• Arrays and functions
• Simple programs (calculator, student marks system)

6. Database Management System (DBMS)

• What is a database?
• Tables, fields, records, keys
• SQL basics: SELECT, INSERT, DELETE, UPDATE
• Introduction to MySQL or SQLite
• Data backup and retrieval

7. Computer Graphics (Optional in Some Institutes)

• Basics of image editing software (e.g., Photoshop or Paint.NET)
• Working with layers, text, and effects
• Designing basic posters or banners

8. Tally ERP (Basic Accounting Software)

• Introduction to Tally
• Ledger and group creation
• Voucher entry
• GST basics
• Financial report generation

9. Project Work & Practical Training

• Real-world application of learned software
• Mini project (e.g., Invoice system in Excel, Library management in C)
• Typing and data entry speed improvement
• Final viva and file submission