Diploma in Computer Applications (DCA) – Complete Syllabus

Course Duration

• 6 Months (Fast Track)
• 12 Months (Regular)

Eligibility

• 10th Pass / 12th Pass / Graduate (depending on institute)

Module 1: Computer Fundamentals

• Introduction to Computers
• History & Generations of Computers
• Types of Computers
• Hardware & Software
• Input & Output Devices
• Storage Devices
• Computer Memory
• Number System
• Operating System Basics

Module 2: Windows Operating System

• Windows Interface
• File & Folder Management
• Control Panel
• User Accounts
• System Settings
• Installing Software
• Keyboard Shortcuts
• Printer Setup
• Basic Troubleshooting

Module 3: Microsoft Word

• Creating Documents
• Text Formatting
• Page Layout
• Tables
• Images & Shapes
• Headers & Footers
• Mail Merge
• Templates
• Printing Documents

Practical:

• Resume
• Letter
• Certificate
• Invoice

Module 4: Microsoft Excel

• Workbook & Worksheet
• Cell Formatting
• Formulas & Functions
• Charts
• Sorting & Filtering
• Conditional Formatting
• Data Validation
• Pivot Tables
• Printing Excel Sheets

Functions Covered

• SUM
• AVERAGE
• COUNT
• IF
• VLOOKUP/XLOOKUP
• HLOOKUP
• INDEX-MATCH
• CONCAT
• LEFT
• RIGHT
• MID
• DATE Functions

Practical

• Salary Sheet
• Student Marksheet
• Attendance Sheet
• Sales Report

Module 5: Microsoft PowerPoint

• Creating Presentations
• Themes
• SmartArt
• Charts
• Animation
• Transition
• Slide Master
• Presentation Tips

Practical

• Company Profile
• Project Presentation
• Business Presentation

Module 6: Internet & Email

• Internet Basics
• Web Browsers
• Google Search Techniques
• Gmail
• Email Writing
• Google Drive
• Google Docs
• Google Sheets
• Google Forms
• Cloud Storage
• Video Conferencing (Zoom/Google Meet)

Module 7: Database Management

• Introduction to Database
• MS Access
• Tables
• Queries
• Forms
• Reports
• Relationships

OR

SQL Basics

• Database Concepts
• CREATE
• INSERT
• UPDATE
• DELETE
• SELECT
• WHERE
• ORDER BY

Module 8: HTML & Web Designing Basics

• Introduction to HTML
• HTML Tags
• Lists
• Tables
• Forms
• Images
• Hyperlinks
• CSS Basics
• Simple Website Design

Module 9: Programming Fundamentals

C Programming

• Variables
• Data Types
• Operators
• Loops
• Functions
• Arrays
• File Handling

OR

Python Basics

• Variables
• Data Types
• Input/Output
• Operators
• Conditions
• Loops
• Functions
• Lists
• Dictionaries
• Simple Programs

Module 10: Cyber Security & Digital Skills

• Cyber Safety
• Password Security
• Online Banking Safety
• UPI Safety
• Phishing Awareness
• Virus & Malware
• Antivirus
• Data Backup
• Digital Payments
• Digital Signatures
• AI Tools Basics (ChatGPT, Microsoft Copilot, Google Gemini)

Module 11: Tally Prime (Basic)

• Company Creation
• Ledger
• Voucher Entry
• GST Basics
• Reports
• Inventory

Module 12: Soft Skills & Employability

• Communication Skills
• Spoken English Basics
• Resume Writing
• Interview Skills
• Office Etiquette
• Personality Development

Practical Projects

• Student Management System
• Salary Management in Excel
• Office Documentation
• Business Presentation
• Personal Portfolio Website
• Database Project
• Final Practical Assessment

Assessment Pattern

• Theory: 30%
• Practical: 50%
• Project: 20%

Certification

Students who successfully complete the course and pass the assessments will receive a Diploma in Computer Applications (DCA) certificate.

Skills You Will Gain

• Computer Operations
• MS Office (Word, Excel, PowerPoint)
• Internet & Email
• Data Management
• Basic Programming
• Database Handling
• Web Designing Basics
• Tally Prime Basics
• Cyber Security Awareness
• Office Automation

This syllabus is suitable for a 6-month to 1-year DCA program and aligns with the skills commonly required for office, administrative, and entry-level IT roles.