DCA Course Syllabus

Semester 1: Basics of Computer Applications

1. Fundamentals of Computers

• 1.1 Introduction to Computers & IT
• 1.2 History & Evolution of Computers
• 1.3 Classification & Types of Computers
• 1.4 Hardware and Software Overview
• 1.5 Input & Output Devices
• 1.6 Memory & Storage Devices

2. Operating System (Windows & Linux)

• 2.1 Introduction to OS
• 2.2 Features and Functions of OS
• 2.3 Windows OS (File System, Control Panel, Utilities)
• 2.4 Linux Basics (Commands, File Management, Shell)

3. Microsoft Office Suite

• 3.1 MS Word: Formatting, Tables, Mail Merge, Templates
• 3.2 MS Excel: Formulas, Functions, Charts, Pivot Tables
• 3.3 MS PowerPoint: Slides, Animations, Transitions
• 3.4 MS Access: Database Management, Queries, Forms, Reports

4. Internet & Web Technology

• 4.1 Basics of the Internet
• 4.2 Web Browsers & Search Engines
• 4.3 Email and Social Media
• 4.4 Introduction to Cloud Computing

5. Multimedia & Graphics

• 5.1 Basics of Image Editing (Photoshop/CorelDRAW)
• 5.2 Audio & Video Editing Fundamentals

ADCA Course Syllabus

Semester 2: Advanced Computer Applications

1. Programming in C

• 1.1 Introduction to Programming & C Language
• 1.2 Data Types, Operators, Control Structures
• 1.3 Functions, Arrays, Pointers
• 1.4 File Handling & Structures in C

2. Database Management System (DBMS)

• 2.1 Introduction to DBMS
• 2.2 Relational Database Model
• 2.3 SQL: Queries, Joins, Normalization
• 2.4 MS Access / MySQL / Oracle Basics

3. Web Designing (HTML, CSS, JavaScript)

• 3.1 HTML: Tags, Forms, Tables, Frames
• 3.2 CSS: Styling, Layouts, Animations
• 3.3 JavaScript: Basics, Functions, Event Handling

4. Tally & Accounting Software

• 4.1 Introduction to Tally ERP
• 4.2 Creating & Managing Ledgers
• 4.3 GST, Taxation, and Payroll Management

5. Computer Networking & Cyber Security

• 5.1 Basics of Networking: LAN, WAN, IP Addressing
• 5.2 Internet Protocols (HTTP, FTP, TCP/IP)
• 5.3 Cyber Security Fundamentals
• 5.4 Ethical Hacking Basics

6. Project Work & Practical Sessions

• 6.1 Developing a Mini Project (e.g., Billing System, Student Database)
• 6.2 Hands-on Training on Software & Applications

Downoad Your Certificate