ADCA – Advanced Diploma in Computer Applications (12 Months)

Course Overview:

The ADCA course is designed to provide comprehensive training in essential computer skills, programming, web development, accounting, and modern digital tools. It equips learners with practical knowledge for professional roles in IT, accounting, and business analytics.

Course Modules & Syllabus

Module 1: MS Office

• MS Word: Document creation, formatting, tables, images, mail merge, templates
• MS Excel: Basic & Advanced formulas, functions, charts, pivot tables, data analysis
• MS PowerPoint: Slide design, animations, multimedia, presentation techniques

Module 2: Web Designing (HTML, CSS, JS)

• HTML: Structure of web pages, tags, forms, tables, multimedia
• CSS: Styling, layout, responsiveness, animations
• JavaScript: Basics, DOM manipulation, events, simple interactive web features

Module 3: Python & SQL

• Python Basics: Syntax, data types, loops, functions, file handling
• Python for Data: Lists, dictionaries, data processing, basic projects
• SQL: Database concepts, tables, queries (SELECT, INSERT, UPDATE, DELETE), joins, aggregation

Module 4: Tally Prime with GST

• Company creation, ledger and voucher entry
• Inventory management
• GST setup and returns (GSTR-1, GSTR-3B)
• Billing, reports, and practical accounting exercises

Module 5: Internet & AI Tools

• Internet browsing, email, online research, digital payments
• Introduction to AI tools (ChatGPT, productivity tools, automation tips)
• Using AI for office work and accounting efficiency

Practical Work & Projects:

• Web page design project
• Python mini-projects and database exercises
• Tally accounting practical scenarios
• Excel dashboards and reports

Career Guidance & Certification:

• Resume & portfolio preparation
• Interview preparation for IT & accounting roles
• ADCA Certificate upon completion