ADCA Course Detail and Syllabus
ADCA (Advanced Diploma in Computer Applications) is a 1-year diploma course that provides in-depth knowledge of computer applications from basic to advanced level.
It covers essential topics like MS Office, Internet, Programming, Web Design, Graphic Design, Accounting Software (Tally), and more.
ADCA is typically divided into 2 semesters and includes both theoretical and practical learning.
Semester 1: Basics of Computer Applications
1. Computer Fundamentals
- Introduction to Computers
- History and Generation of Computers
- Types of Computers and Components
- Input/Output Devices
- Number Systems (Binary, Decimal)
2. Operating Systems
- Introduction to OS (Windows / Linux)
- File and Folder Management
- Control Panel and System Settings
3. MS Office Package
MS Word
- Document Formatting
- Tables, Bullets, Numbering
- Page Layout, Mail Merge
MS Excel
- Formulas and Functions
- Charts and Data Tables
- Sorting, Filtering, Conditional Formatting
MS PowerPoint
- Creating Presentations
- Slide Transitions and Animations
- Inserting Images and Videos
MS Access (Basics)
- Database Creation
- Tables, Forms, Queries
4. Internet and Email
- Internet Basics and Browsers
- Search Engines and Effective Searching
- Email Creation and Management
- Online Forms, Downloads, Uploads
Semester 2: Advanced Computer Applications
5. Tally (Accounting Software)
- Introduction to Tally ERP 9 / Tally Prime
- Company Creation
- Ledger, Vouchers, Inventory
- GST & Taxation
- Final Accounts: Trial Balance, Balance Sheet
6. Programming Language (Basic)
- Introduction to Programming Concepts
- Basics of C / Python (as per institute)
- Variables, Loops, Conditions, Functions
7. Database Management System (DBMS)
- Concepts of DBMS & RDBMS
- Tables, Records, Keys
- SQL Basics (Create, Insert, Update, Delete)
- Simple Queries
8. Multimedia & Designing Tools
- Basics of Adobe Photoshop / CorelDRAW
- Image Editing, Layers, Effects
- Logo and Banner Design
9. Computer Networking
- Introduction to Computer Networks
- LAN, WAN, MAN
- Network Devices: Router, Switch, Hub
- IP Addressing & Protocols
10. Cyber Security & Digital Concepts
- Introduction to Cyber Security
- Online Threats (Phishing, Malware, etc.)
- Basics of Digital India & e-Governance
- Online Transactions and Digital Wallets