DCA Course Detail
DCA (Diploma in Computer Application) is a short-term computer course designed to provide foundational knowledge in computers,
including topics like computer fundamentals, operating systems, MS Office (Word, Excel, PowerPoint), Tally, and internet applications.
This diploma is ideal for students, job seekers, and working professionals to boost their computer skills and improve career prospects in government and private sectors.
DCA (Diploma in Computer Applications) Course Syllabus
Module 1: Computer Fundamentals & Windows
- Introduction to Computers
- History & Generations of Computers
- Components of Computer (Hardware & Software)
- Number Systems (Binary, Decimal, Octal, Hexadecimal)
- Windows OS – Files, Folders, Desktop, Control Panel, Taskbar
Module 2: Microsoft Office Suite
MS Word
- Document Creation and Editing
- Formatting Text & Paragraphs
- Tables, Headers/Footers, Page Setup
- Mail Merge and Templates
MS Excel
- Worksheets, Cell Operations
- Formulas and Functions
- Charts & Graphs
- Sorting and Filtering
- Pivot Tables (Basic)
MS PowerPoint
- Creating Presentations
- Slide Design, Layouts
- Transitions and Animations
- Inserting Media (Images, Audio, Video)
Module 3: Internet & Email
- Basics of Internet and WWW
- Web Browsers (Chrome, Firefox, etc.)
- Using Search Engines (Google)
- Creating and Using Email
- Email Etiquette and Attachments
- Introduction to Social Media Platforms
Module 4: Tally (Accounting Software)
- Introduction to Tally (Latest Version – Tally Prime / ERP 9)
- Creating Company
- Ledgers and Groups
- Vouchers and Transactions
- GST Entries & Taxation
Module 5: Database Management System (DBMS)
- Basics of DBMS
- Tables, Records and Fields
- Introduction to MS Access or MySQL
- Creating Database and Tables
Module 6: Computer Networking & Security
- Basics of Networking (LAN, WAN, MAN)
- Network Devices (Modem, Router, Switch)
- Internet Protocols (IP, TCP, HTTP, FTP)
- Network Security Concepts
- Cyber Security Basics
Optional / Extra Modules (Institute-specific)
- Photoshop / CorelDRAW Basics
- Python / C Programming (Introductory)
- Digital Marketing Basics
- Typing Practice (English & Regional Language)