ADCA – Advanced Diploma in Computer Applications

Semester I

1. Fundamentals of Computer & Operating System

Module 1: Computer Fundamentals

Module 2: Hardware & Software

Module 3: Operating System Concepts

Module 4: Windows Operating System

Module 5: File & Folder Management

Module 6: Storage & System Utilities

Module 7: Software Installation & Management

Module 8: Basic Troubleshooting

2. MS Office & Advanced Excel

Module 1: MS Word

Module 2: Advanced Document Formatting

Module 3: Tables, Mail Merge & Templates

Module 4: MS Excel Fundamentals

Module 5: Advanced Excel Formulas & Functions

Module 6: Data Management, Sorting & Filtering

Module 7: Charts, PivotTables & Data Analysis

Module 8: MS PowerPoint

3. Internet, Digital Communication & Cloud

Module 1: Internet Fundamentals

Module 2: Web Browsers & Search Techniques

Module 3: Email & Digital Communication

Module 4: Google Workspace

Module 5: Cloud Storage & File Sharing

Module 6: Online Forms & Digital Services

Module 7: Digital Security & Privacy

Module 8: Professional Online Applications

4. TallyPrime & GST

Module 1: Accounting Fundamentals

Module 2: Company Creation & Configuration

Module 3: Groups & Ledgers

Module 4: Accounting Vouchers

Module 5: Inventory Management

Module 6: GST Configuration & Transactions

Module 7: Reports & Financial Statements

Module 8: Payroll Basics

5. Programming Fundamentals with C

Module 1: Programming Concepts

Module 2: Algorithms & Flowcharts

Module 3: C Variables & Data Types

Module 4: Operators

Module 5: Conditional Statements

Module 6: Loops

Module 7: Functions

Module 8: Arrays & Strings

Module 9: Structures & File Handling

Semester II

6. Graphic Design & Desktop Publishing

Module 1: Graphic Design Fundamentals

Module 2: Adobe Photoshop

Module 3: Image Editing & Retouching

Module 4: CorelDRAW

Module 5: Vector Graphics

Module 6: Page Layout & DTP

Module 7: Professional Design Projects

Module 8: Print & Digital Design

7. Web Design — HTML & CSS

Module 1: Web Fundamentals

Module 2: HTML Structure

Module 3: Text, Lists, Tables & Links

Module 4: Images, Audio & Video

Module 5: HTML Forms

Module 6: CSS Fundamentals

Module 7: Web Layout & Responsive Design

Module 8: Website Development Project

8. Database Management & SQL

Module 1: Database Concepts

Module 2: DBMS & RDBMS

Module 3: Tables & Relationships

Module 4: Keys & Constraints

Module 5: SQL Commands

Module 6: Queries, Sorting & Filtering

Module 7: Joins & Aggregate Functions

Module 8: Database Design & Normalization

9. Python Programming

Module 1: Python Fundamentals

Module 2: Variables & Data Types

Module 3: Operators & Expressions

Module 4: Conditional Statements

Module 5: Loops

Module 6: Functions

Module 7: Lists, Tuples, Sets & Dictionaries

Module 8: Strings & File Handling

Module 9: Modules & Exception Handling

Module 10: Object-Oriented Programming Basics

10. Computer Networking Fundamentals

Module 1: Networking Concepts

Module 2: Types of Networks

Module 3: Network Topologies

Module 4: Networking Devices

Module 5: Transmission Media

Module 6: IP Addressing

Module 7: TCP/IP & Common Protocols

Module 8: Network Security Basics

11. Advanced Computer Applications Lab

Module 1: Office Automation Projects

Module 2: Advanced Excel Projects

Module 3: TallyPrime Practical Applications

Module 4: Graphic Design Projects

Module 5: Web Design Projects

Module 6: SQL Database Exercises

Module 7: Python Programming Exercises

Module 8: Integrated Application Practice

12. Professional Project

Module 1: Project Selection

Module 2: Requirement Analysis

Module 3: Project Planning

Module 4: System & Database Design

Module 5: Application Development

Module 6: Testing

Module 7: Documentation

Module 8: Project Demonstration & Viva