What you'll learn
The Advanced Diploma in Computer Applications (ADCA) is a comprehensive program designed to equip learners with both foundational and advanced computer skills required in modern offices, IT, and business environments. This course covers computer fundamentals, Windows OS, MS Office applications, advanced Excel, internet usage with AI tools, Tally Prime with GST, programming with Python and SQL, and web designing using HTML, CSS, and JavaScript.
The program emphasizes hands-on training, practical exercises, and project-based learning, preparing learners for employment, freelancing, and entrepreneurial opportunities.
Course Objectives
- To provide a strong foundation in computers and Windows OS
- To develop proficiency in MS Office applications
- To enhance data analysis skills using advanced Excel
- To train learners in accounting and GST management using Tally Prime
- To introduce programming with Python and database management using SQL
- To teach web designing using HTML, CSS, and JavaScript
- To develop practical skills for office, IT, and web development tasks
Show More
Course Syllabus
UNIT–I: Computer Fundamentals
- Introduction to Computers
- Types of Computers and Applications
- Hardware and Software Overview
- Input, Output, and Storage Devices
- Basic Networking Concepts
UNIT–II: Windows Operating System
- Windows Desktop, Icons, Start Menu, Taskbar
- File and Folder Management
- Control Panel and System Settings
- Personalization, Date, Time, Language, and User Accounts
UNIT–III: MS Office
MS Word
- Document Creation and Formatting
- Tables, Images, Headers & Footers
- Printing and File Management
MS PowerPoint
- Slide Creation, Layouts, and Themes
- Animations and Transitions
- Slide Show Presentation
MS Excel (Basic & Advanced)
- Data Entry and Formatting
- Formulas and Functions (SUM, IF, VLOOKUP, COUNTIF, etc.)
- Pivot Tables and Charts
- Data Analysis and Dashboard Creation
UNIT–IV: Internet & AI Tools
- Introduction to Internet and Browsers
- Email Creation and Management
- Online Forms and Cloud Storage
- Introduction to AI Tools (ChatGPT, AI Writing Tools, Productivity Tools)
- Cybersecurity Awareness
UNIT–V: Tally Prime with GST
- Accounting Basics and Company Creation
- Ledger, Voucher, and Inventory Management
- GST Fundamentals and Tax Compliance
- GST Returns (GSTR-1, GSTR-3B)
- Reports and Analysis
UNIT–VI: Python Programming + SQL
Python
- Programming Basics, Variables, and Data Types
- Conditional Statements and Loops
- Functions, Modules, and File Handling
- Mini Projects
SQL
- Database Concepts and Design
- SQL Commands (DDL, DML, DCL)
- SELECT Queries, Joins, and Subqueries
- Connecting Python with SQL for Data Management
UNIT–VII: Web Designing (HTML, CSS, JavaScript)
HTML
- Structure of Web Pages
- Text, Images, Links, Forms, Tables
CSS
- Styling Web Pages (Colors, Fonts, Layouts)
- Responsive Design Basics
JavaScript
- Variables, Data Types, Functions
- Events and Form Validation
- Interactive Web Page Elements
UNIT–VIII: Practical & Project Work
- MS Word Project: Resume / Letter / Report
- Excel Project: Data Analysis / Dashboard
- Tally Project: GST-Based Accounting
- Python + SQL Mini Project
- Web Designing Project: Static Website
- Final Project Assessment
Bestseller
