ADCA SYLLABUS (UPDATED)

Module 1: Fundamentals of Computer

• Introduction to Computers
• History & Generations of Computers
• Hardware & Software
• Input, Output & Storage Devices
• Types of Computers
• Memory Units

Module 2: Operating System (Windows)

• Introduction to Operating Systems
• Windows Features & Versions
• Desktop, Taskbar, File & Folder Management
• Control Panel & System Settings
• Shortcuts & System Tools

Module 3: MS Word

• Creating & Formatting Documents
• Page Setup, Margins & Orientation
• Tables, Images & Shapes
• Headers, Footers & Page Numbers
• Mail Merge
• Printing & PDF Creation

Module 4: MS Excel (Basic to Advanced)

• Spreadsheet Basics
• Cell Formatting & Functions
• Formulas (SUM, IF, VLOOKUP, HLOOKUP)
• Charts & Graphs
• Sorting & Filtering
• Data Validation & Pivot Table

Module 5: MS PowerPoint

• Creating Presentations
• Slides, Layouts & Themes
• Animations & Transitions
• Audio/Video Integration
• Slide Show & Printing

Module 6: Internet & Email

• Internet Concepts
• Web Browsers & Search Engines
• Email Creation & Management
• Attachments & Cloud Storage
• Online Safety & Cyber Awareness

Module 7: Computer Accounting (Tally with GST)

• Accounting Fundamentals
• Company Creation in Tally
• Ledgers & Groups
• Voucher Entries
• GST, Taxation & Reports
• Balance Sheet & Profit & Loss

Module 8: MS-DOS

• Introduction to MS-DOS
• DOS Commands (DIR, CD, MD, RD, COPY, DEL)
• File & Directory Management
• Internal & External Commands
• Batch Files (Basics)

Module 9: Computer Networking

• Basics of Networking
• Types of Networks (LAN, WAN, MAN)
• Internet & Intranet
• Network Devices (Router, Switch, Modem)

Module 10: Web Designing Basics

• Introduction to Web Technology
• HTML Basics
• Creating Simple Web Pages
• Hyperlinks, Images & Tables

Module 11: Data Entry & Typing Practice

• English Typing Practice
• Hindi Typing (Kruti Dev / Mangal)
• Speed & Accuracy Improvement
• Practical Data Entry Work

Module 12: Cyber Security & Digital Literacy

• Computer Viruses & Protection
• Antivirus & Firewalls
• Digital Payments & Online Services
• Cyber Laws & Ethics

Practical & Project Work

• Office Automation Project
• Accounting Project
• Presentation Project
• Final Practical Examination

Course Duration

• 6 Months / 12 Months

Certification

• ADCA Certificate