ADCA Course – Advanced Diploma in Computer Applications
Course Overview
ADCA (Advanced Diploma in Computer Applications) is a comprehensive computer education program designed to develop practical and professional computer application skills.
The course provides learners with a strong foundation in computer fundamentals, operating systems, MS Office, internet and digital communication, accounting software, database management, programming, graphic design, web development, and computer security.
ADCA is suitable for students, job seekers, office professionals, entrepreneurs, and anyone who wants to develop practical computer skills for education, employment, business, and day-to-day digital work.
The course combines theory, practical training, assignments, projects, and real-world applications so that students can develop confidence in using computers and commonly used software applications.
Course Objectives
After completing the ADCA course, students will be able to:
Understand computer fundamentals and terminology
Identify computer hardware and software
Work confidently with Windows and file management
Use keyboard shortcuts and productivity techniques
Create and format professional documents
Prepare spreadsheets and perform calculations
Create professional presentations
Manage databases and records
Use the internet effectively and safely
Communicate through email and digital platforms
Perform basic accounting work using accounting software
Understand GST and computerized accounting concepts
Create and edit graphics
Understand basic programming concepts
Develop basic websites
Understand databases and SQL
Apply basic cybersecurity practices
Use cloud and digital services
Complete practical computer-based projects
Develop job-oriented computer application skills
Course Modules
Module 1: Introduction to Computers
Topics Covered
Meaning and definition of a computer
History and evolution of computers
Characteristics of computers
Advantages and limitations of computers
Applications of computers
Types of computers
Desktop computers
Laptop computers
Tablets and smartphones
Workstations
Servers
Supercomputers
Computer generations
Analog, digital, and hybrid computers
Basic computer terminology
Practical
Identify different types of computers
Identify common computer components
Understand basic computer specifications
Module 2: Computer Hardware
Topics Covered
Hardware and its importance
CPU
Motherboard
RAM
ROM
Cache memory
Hard disk
SSD
Pen drive
Memory cards
Keyboard
Mouse
Monitor
Printer
Scanner
Speakers
Microphone
Webcam
Projector
UPS
Ports and connectors
Practical
Identify hardware components
Connect basic computer peripherals
Understand storage devices and their uses
Module 3: Computer Software
Topics Covered
Meaning of software
System software
Application software
Utility software
Programming software
Operating systems
Device drivers
Software installation
Software updates
Licensed and open-source software
Basic software troubleshooting
Module 4: Operating System and Windows
Topics Covered
Introduction to operating systems
Functions of an operating system
Windows desktop
Start menu
Taskbar
Desktop icons
File Explorer
Windows settings
User accounts
Applications
Windows search
Installing and uninstalling software
System updates
Basic system maintenance
Practical
Customize desktop settings
Open and manage applications
Install and uninstall software
Manage basic Windows settings
Module 5: File and Folder Management
Topics Covered
Files and folders
Creating folders
Renaming files and folders
Copying and moving files
Deleting and restoring files
Recycle Bin
File extensions
File properties
Searching files
Sorting and organizing files
Compressing files
ZIP and extracted folders
Backup fundamentals
Cloud storage basics
Practical
Students will organize a structured folder system for documents, images, projects, and assignments.
Module 6: Keyboard, Mouse and Computer Shortcuts
Topics Covered
Keyboard layout
Function keys
Navigation keys
Special keys
Numeric keypad
Mouse operations
Single click
Double click
Right click
Drag and drop
Keyboard shortcuts
Windows shortcuts
Application shortcuts
Productivity techniques
Typing practice
Practical
Keyboard typing exercises
Shortcut exercises
File-management exercises
Module 7: MS Word
MS Word is an important component of office productivity training.
Topics Covered
Introduction to MS Word
Word interface
Creating documents
Opening and saving documents
Save and Save As
Text editing
Copy, cut, and paste
Find and Replace
Character formatting
Font styles and sizes
Text color
Bold, Italic, and Underline
Paragraph formatting
Alignment
Line spacing
Indentation
Bullets and numbering
Borders and shading
Page formatting
Margins
Page orientation
Page size
Columns
Page breaks
Module 8: Advanced MS Word
Topics Covered
Tables
Table formatting
Merge and split cells
Images
Shapes
Icons
SmartArt
Charts
Text boxes
WordArt
Header and Footer
Page numbers
Footnotes and Endnotes
Table of Contents
References
Citations and bibliography
Hyperlinks
Bookmarks
Mail Merge
Labels and envelopes
Document protection
Printing documents
Exporting documents as PDF
Practical Projects
Resume/CV
Business letter
Official application
Certificate
Notice
Report
Invoice
Professional document
Mail Merge project
Module 9: MS Excel
Topics Covered
Introduction to Excel
Workbook and worksheet
Rows and columns
Cells and ranges
Data entry
Editing data
Formatting cells
Number formats
Cell borders
Row height and column width
Worksheets
Renaming and organizing sheets
Basic formulas
Relative and absolute references
Basic Functions
SUM
AVERAGE
MIN
MAX
COUNT
COUNTA
ROUND
IF
Module 10: Advanced MS Excel
Topics Covered
Logical functions
Text functions
Date and time functions
Conditional formatting
Sorting
Filtering
Data validation
Tables
Charts
PivotTables
PivotCharts
Lookup concepts
VLOOKUP/XLOOKUP concepts
INDEX and MATCH concepts
Spreadsheet protection
Printing and page setup
Data analysis basics
Practical Projects
Student mark sheet
Salary sheet
Attendance sheet
Sales report
Expense tracker
Inventory sheet
Business dashboard
Module 11: MS PowerPoint
Topics Covered
Introduction to PowerPoint
PowerPoint interface
Creating presentations
Slides and layouts
Slide themes
Text formatting
Images
Shapes
Icons
SmartArt
Tables
Charts
Audio and video
Hyperlinks
Slide transitions
Animations
Presentation views
Speaker notes
Slide Master
Header and Footer
Presentation printing
PDF export
Slide show
Practical Projects
Educational presentation
Business presentation
Product presentation
Project presentation
Seminar presentation
Module 12: MS Office Productivity
Topics Covered
Word, Excel, and PowerPoint integration
Copying data between applications
Embedding objects
Creating professional documents
Office productivity techniques
Templates
File formats
PDF creation
Document sharing
Printing and scanning workflow
Module 13: Internet Fundamentals
Topics Covered
Introduction to the Internet
History of the Internet
Internet vs World Wide Web
Websites and web pages
Web browsers
Search engines
URLs
Domains
IP addresses
HTTP and HTTPS
Downloading and uploading
Online forms
Online services
Cloud services
Practical
Browse websites
Perform effective searches
Download and organize files
Complete online forms
Module 14: Email and Digital Communication
Topics Covered
Email fundamentals
Creating an email account
Inbox
Sent items
Drafts
Spam
Attachments
CC and BCC
Email formatting
Email signatures
Professional email writing
Email organization
Email security
Digital communication etiquette
Practical
Send professional emails
Attach files
Organize emails
Create a professional email signature
Module 15: Digital Services and Online Applications
Topics Covered
Online registration
Online forms
Online document services
Online banking concepts
Digital payments
UPI fundamentals
QR payments
Online shopping
Ticket booking
Government digital services
Cloud storage
Online collaboration
Digital identity and account security
Practical
Practice filling online forms
Upload/download documents
Use cloud storage
Understand safe digital payment practices
Module 16: Cybersecurity and Digital Safety
Topics Covered
Introduction to cybersecurity
Common cyber threats
Malware
Viruses
Trojans
Ransomware
Phishing
Social engineering
Password security
Strong passwords
Multi-factor authentication
Safe browsing
Email security
Data privacy
Software updates
Backup
Public Wi-Fi safety
Social media safety
Online fraud awareness
Practical
Identify suspicious emails
Create a password-security checklist
Practice safe browsing habits
Prepare a personal data-protection checklist
Module 17: Computer Networking Fundamentals
Topics Covered
Introduction to networking
Network terminology
LAN
MAN
WAN
PAN
Network devices
Modem
Router
Switch
Access Point
Network cables
Wi-Fi
Internet connection
IP address
Basic network troubleshooting
Practical
Identify networking devices
Understand basic network configurations
Troubleshoot common connectivity problems
Module 18: Computer Maintenance and Troubleshooting
Topics Covered
Preventive maintenance
Hardware maintenance
Software maintenance
Disk space management
System updates
Antivirus and security
Backup
Common computer problems
Slow computer
Application errors
Printer problems
Internet connectivity problems
Keyboard and mouse problems
Basic troubleshooting methods
Practical
Students will diagnose and document common computer problems.
Module 19: Computer Accounting Fundamentals
Topics Covered
Introduction to accounting
Meaning of accounting
Importance of accounting
Types of accounts
Accounting principles
Debit and credit
Journal
Ledger
Cash book
Trial balance
Profit and loss
Balance sheet
Basic business transactions
Practical
Record basic transactions
Prepare simple journal entries
Understand ledger posting
Module 20: Tally and Computerized Accounting
Topics Covered
Introduction to computerized accounting
Tally software fundamentals
Company creation
Company configuration
Groups
Ledgers
Accounting vouchers
Contra voucher
Payment voucher
Receipt voucher
Journal voucher
Sales voucher
Purchase voucher
Debit Note
Credit Note
Cash and bank transactions
Module 21: Tally – Inventory and Business Transactions
Topics Covered
Inventory management
Stock groups
Stock categories
Stock items
Units of measurement
Godowns
Purchase management
Sales management
Purchase orders
Sales orders
Delivery notes
Receipt notes
Stock transfer
Inventory reports
Practical
Create inventory records
Record purchase and sales
Generate inventory reports
Module 22: GST and Taxation Concepts
Topics Covered
Introduction to GST
GST terminology
CGST
SGST
IGST
Input Tax Credit
GST registration concepts
GST configuration in accounting software
GST invoices
Tax-inclusive and tax-exclusive pricing
GST reports
Return-related concepts
Basic tax-compliance awareness
Note: Tax laws, rates, procedures, and compliance requirements may change, so practical training should follow the applicable current rules and official guidance.
Module 23: Financial Reports in Tally
Topics Covered
Trial Balance
Profit and Loss Account
Balance Sheet
Cash Flow
Fund Flow concepts
Stock Summary
Day Book
Outstanding reports
Receivable reports
Payable reports
Bank-related reports
Financial analysis basics
Module 24: Payroll Fundamentals
Topics Covered
Introduction to payroll
Employee records
Salary structure
Attendance
Pay heads
Salary calculation
Deductions
Payroll reports
Payslips
Basic statutory payroll concepts
Module 25: Database Fundamentals
Topics Covered
Introduction to databases
Data and information
Database management systems
Relational databases
Tables
Records
Fields
Primary keys
Foreign keys
Relationships
Database normalization concepts
Database security
Backup and recovery
Module 26: MS Access / Database Application
Topics Covered
Introduction to MS Access
Creating databases
Tables
Fields and data types
Primary keys
Relationships
Forms
Queries
Reports
Sorting and filtering
Data validation
Importing and exporting data
Practical
Create a student database
Create tables
Build forms
Create queries
Generate reports
Module 27: SQL Fundamentals
Topics Covered
Introduction to SQL
Database terminology
Creating databases
Creating tables
Inserting records
Updating records
Deleting records
SELECT queries
WHERE clause
ORDER BY
GROUP BY
Aggregate functions
JOIN concepts
Basic database operations
Practical
Students will create and query a small relational database.
Module 28: Programming Fundamentals
Topics Covered
What is programming?
Programming languages
Algorithms
Flowcharts
Pseudocode
Variables
Constants
Data types
Operators
Input and output
Conditional statements
Loops
Functions
Arrays/lists
Basic debugging
Module 29: Python Programming Fundamentals
Python may be introduced as a beginner-friendly programming language.
Topics Covered
Introduction to Python
Installing Python
Python development environment
Syntax
Variables
Data types
Operators
Input and output
Conditional statements
Loops
Strings
Lists
Tuples
Sets
Dictionaries
Functions
Modules
File handling
Exception handling
Introduction to Object-Oriented Programming
Practical Projects
Calculator
Number guessing program
Student marks program
Simple quiz
Expense tracker
Basic data-processing program
Module 30: HTML and Web Development Fundamentals
Topics Covered
Introduction to websites
How websites work
HTML fundamentals
HTML document structure
Headings
Paragraphs
Links
Images
Lists
Tables
Forms
Audio and video
Semantic HTML
Basic CSS
Colors
Fonts
Backgrounds
Borders
Basic page layout
Practical
Create a personal webpage
Create a student profile page
Create a simple business webpage
Module 31: Graphic Design Fundamentals
Topics Covered
Introduction to graphic design
Elements of design
Principles of design
Color theory
Typography
Composition
Raster and vector graphics
Image formats
Resolution
Digital images
Basic photo editing
Basic graphic creation
Module 32: Adobe Photoshop / Image Editing
Topics Covered
Photoshop interface
Creating documents
Image opening and saving
Layers
Selections
Cropping
Resizing
Image adjustment
Brightness and contrast
Color correction
Background removal
Text tools
Shapes
Filters
Basic photo retouching
Exporting images
Practical Projects
Photo editing
Passport-size photograph preparation
Poster
Social media graphic
Simple advertisement
Module 33: CorelDRAW / Vector Graphics
Topics Covered
Introduction to vector graphics
CorelDRAW workspace
Shapes
Lines
Curves
Bezier tools
Node editing
Text
Color fills
Outlines
Alignment
Grouping
Layer/object management
Logo design
Business card design
Poster design
Exporting artwork
Practical Projects
Logo
Business card
Letterhead
Poster
Certificate
Advertisement
Module 34: MS Paint and Basic Digital Drawing
Topics Covered
MS Paint interface
Canvas
Pencil
Brushes
Eraser
Fill tool
Color picker
Shapes
Text
Selection tools
Resize
Crop
Rotate
Basic image editing
Saving images
Practical
Basic digital drawing
Simple poster
Basic image editing
Module 35: Cloud Computing Fundamentals
Topics Covered
Introduction to cloud computing
Cloud storage
Online documents
File synchronization
File sharing
Online collaboration
Cloud backup
Cloud security
Personal and business cloud services
Advantages and limitations of cloud computing
Practical
Upload files to cloud storage
Create folders
Share files
Collaborate on documents
Module 36: Artificial Intelligence and Modern Digital Tools
Topics Covered
Introduction to Artificial Intelligence
AI in education and business
Generative AI fundamentals
AI-assisted writing
AI-assisted research
AI image generation concepts
AI productivity tools
Prompt writing basics
Responsible use of AI
Fact-checking AI-generated information
Privacy and data protection when using AI tools
Practical
Create prompts for common tasks
Use AI for brainstorming
Improve a document with AI assistance
Develop an AI-assisted productivity workflow
Module 37: Practical Office Automation
Topics Covered
Digital office workflow
Document creation
Spreadsheet management
Presentation preparation
Email communication
Printing and scanning
PDF management
File organization
Data entry
Digital record keeping
Online form handling
Basic office automation concepts
Practical
Students will complete a simulated office workflow from document creation to digital submission and record management.
Module 38: Data Entry and Documentation
Topics Covered
Data entry fundamentals
Typing accuracy
Data formatting
Spreadsheet data entry
Record maintenance
Document verification
Data sorting and filtering
Error identification
Data backup
Digital documentation
Professional file naming
Practical
Create a customer database
Prepare a data-entry spreadsheet
Organize digital records
Module 39: Digital Marketing Fundamentals
Topics Covered
Introduction to Digital Marketing
Website promotion
Search Engine Optimization
Social media marketing
Content marketing
Email marketing
Online advertising
Google Business Profile concepts
Basic analytics
Digital branding
Practical
Create a basic digital marketing plan
Prepare social media content
Perform basic keyword research
Module 40: Practical Projects
ADCA emphasizes practical learning through projects.
Project 1: Office Documentation Project
Create:
Official letter
Resume
Notice
Certificate
Report
Table-based document
Project 2: Excel Business Project
Create:
Sales report
Expense sheet
Salary sheet
Attendance sheet
Student mark sheet
Charts and summary report
Project 3: Accounting Project
Create a sample business in accounting software and record:
Capital
Purchases
Sales
Expenses
Receipts
Payments
Bank transactions
Inventory
Applicable taxes
Project 4: Database Project
Create a student/customer database containing:
Tables
Forms
Queries
Reports
Project 5: Web Development Project
Create a simple multi-page website using:
HTML
CSS
Images
Navigation
Forms
Project 6: Graphic Design Project
Create:
Logo
Business card
Poster
Certificate
Social media graphic
Final ADCA Capstone Project
At the end of the course, students can complete an integrated computer application project.
Suggested Project
Complete Digital Office Management System
The project can include:
Word-based documentation
Excel-based data management
PowerPoint presentation
Database records
Accounting records
Basic website
Graphic materials
Email communication
Cloud storage
Digital security practices
Project report
Final presentation
This project allows students to apply multiple skills learned throughout the ADCA program.
Practical Skills Developed
After completing the ADCA course, students can develop practical skills in:
Computer operation
Windows
File management
Typing
MS Word
MS Excel
MS PowerPoint
Internet
Email
Digital services
Cybersecurity awareness
Computer networking basics
Accounting software
GST concepts
Database management
SQL
Programming fundamentals
Python fundamentals
HTML and CSS
Graphic design
Photoshop fundamentals
CorelDRAW fundamentals
Cloud computing
Digital marketing
AI-assisted productivity
Office automation
Career Opportunities
ADCA can provide a foundation for entry-level roles such as:
Computer Operator
Data Entry Operator
Office Assistant
Computer Assistant
Office Executive
Back Office Executive
Documentation Executive
MIS Executive
Junior Accountant
Accounts Assistant
Computerized Accounting Assistant
Billing Executive
Customer Support Executive
Junior Web Assistant
Graphic Design Assistant
Digital Marketing Assistant
IT Support Assistant
Actual job requirements vary by employer, location, experience, and specialization.
Who Can Join the ADCA Course?
The course can be suitable for:
Students
School and college graduates
Job seekers
Beginners
Office employees
Entrepreneurs
Small business owners
Freelancers
Data-entry aspirants
Accounting learners
Anyone interested in computer applications
The specific educational eligibility can be defined by the training institute according to its program structure.
Course Duration
A comprehensive ADCA program is commonly structured as a 6–12 month course, depending on the syllabus, practical hours, assignments, projects, and institute curriculum.
A suggested structure can include:
Classroom theory
Computer lab practice
Assignments
Software-based exercises
Practical examinations
Projects
Final assessment
Assessment and Examination
Students can be evaluated through:
Theory Assessment
Computer fundamentals
Operating systems
Office applications
Internet
Accounting
Programming
Database
Web development
Graphics
Cybersecurity
Practical Assessment
MS Word practical
MS Excel practical
PowerPoint practical
Internet and email practical
Accounting practical
Database practical
Programming practical
Web development practical
Graphic design practical
Project Assessment
Individual or group project
Project documentation
Practical demonstration
Viva/presentation
Final evaluation
Course Certification
After successfully completing the prescribed course requirements, students may receive an ADCA Certificate from the respective training institute or organization.
The certificate can document the student’s completion of the ADCA curriculum and practical training.
Benefits of Learning ADCA
The ADCA course can help students:
Build strong computer fundamentals
Develop office productivity skills
Improve digital literacy
Learn multiple computer applications
Develop accounting and data-management skills
Understand programming fundamentals
Gain basic web development knowledge
Develop graphic design skills
Improve workplace productivity
Build practical project experience
Prepare for entry-level computer-related roles
Develop a foundation for further IT education
Further Learning Opportunities
After ADCA, learners can choose to specialize in areas such as:
Advanced Excel and MIS
Tally and computerized accounting
GST and taxation
Graphic design
Web development
Python programming
Software development
Database management
Digital marketing
Data analytics
Cybersecurity
Cloud computing
Artificial Intelligence
UI/UX design
Conclusion
The ADCA – Advanced Diploma in Computer Applications is a broad, practical computer education program that brings together essential digital and office skills with introductory knowledge of accounting, databases, programming, web development, graphic design, networking, cybersecurity, and modern digital technologies.
Through a combination of theory, practical exercises, software training, assignments, and real-world projects, students can develop a strong foundation for academic work, office environments, business activities, and further professional specialization.
ADCA can therefore serve as a structured starting point for learners who want to build comprehensive computer application skills and progress toward more specialized careers in technology, business, accounting, design, or digital services.