Course Syllabus
💻 DIPLOMA IN COMPUTER APPLICATIONS
Course Duration: 1 Year (Two Semesters)
Eligibility: 10th / 12th Pass or Equivalent
Medium: Hindi / English
📘 Semester – I
1️⃣ Fundamentals of Computer & Information Technology
- History and Generation of Computers
- Types of Computers (Analog, Digital, Hybrid)
- Hardware and Software Concepts
- Input and Output Devices
- Memory and Storage Devices
- Number System (Binary, Decimal, Hexadecimal)
- Computer Networks and Internet Basics
- Applications of IT in Various Fields
2️⃣ Computers in Office – I (MS Word, MS Excel)
- MS Word: Document creation, formatting, tables, mail merge, templates
- MS Excel: Spreadsheet concepts, formulas, functions, charts, data sorting and filtering
- Printing and Page Setup
- Office Documentation and Data Management
3️⃣ Computers in Office – II (MS PowerPoint, MS Access)
- MS PowerPoint: Creating slides, animation, design templates, presentation setup
- MS Access: Database concepts, tables, queries, forms, reports
- Linking data between Excel and Access
- Presentation and Report Preparation
4️⃣ Operating System (DOS, Windows, Linux)
- Basic concepts of Operating Systems
- File and Directory Management
- Commands of DOS
- Windows Interface, File Explorer, Control Panel, System Tools
- Introduction to Linux and Basic Commands
- Comparison of DOS, Windows, and Linux
5️⃣ Communication Skills & Personality Development
- Verbal and Non-Verbal Communication
- Writing Skills (Letters, Reports, Emails)
- Public Speaking and Presentation Skills
- Time Management and Team Work
- Interview Techniques and Resume Writing
- Grooming and Professional Behavior
💾 Semester – II
1️⃣ Introduction to Internet and Web Technology
- Concepts of Internet and Intranet
- Web Browsers and Search Engines
- Creating Email Accounts and Online Communication
- HTML Basics: Tags, Links, Tables, Forms
- Introduction to Website Design
- Cyber Security and Safe Internet Practices
2️⃣ Introduction to Financial Accounting with Tally
- Basics of Accounting and Double Entry System
- Company and Ledger Creation in Tally
- Voucher Entry and Day Book
- GST, TDS and Payroll Management
- Generating Financial Reports: Trial Balance, P&L, Balance Sheet
- Data Backup and Restore in Tally
3️⃣ Programming in C
- Introduction to Programming Language
- Constants, Variables and Data Types
- Operators and Expressions
- Control Structures: if-else, loops, switch
- Arrays, Functions and Pointers
- Structures and File Handling
- Simple Programming Projects
4️⃣ DBMS with MS Access
- Introduction to Database and Data Models
- Entity Relationship (ER) Concepts
- Creating Tables and Relationships
- Queries, Forms, and Reports
- Data Validation and Normalization
- Introduction to SQL
5️⃣ Project Report
- Preparation of a Mini Project using any studied tools (Tally / C / MS Access / Web Design)
- Project Documentation
- Viva-Voce and Presentation
🧑💼 Career Opportunities After DCA:
- Computer Operator
- Data Entry Operator
- Accountant (Tally)
- Office Assistant
- Web / Database Assistant
- IT Support Staff