One Year ADCA – Module Structure

✅ Module 1 (Month 1–2): Computer Fundamentals

Topics: Introduction to Computers, Generations of Computers, Hardware & Software, Input/Output Devices, CPU & Memory, Types of Computers, Number System Basics

Practical: Basic computer handling

✅ Module 2 (Month 2–3): Operating System (Windows)

Topics: Introduction to OS, Windows Features, Desktop, Taskbar, Settings, File & Folder Management, Control Panel, Shortcut Keys, System Tools

Practical: File operations & system settings

✅ Module 3 (Month 3–5): MS Word (Advanced)

Topics: Document Creation, Formatting & Styles, Page Setup, Tables & Graphics, Header/Footer, Mail Merge, Templates, Printing Options

Practical: Letter, report, certificate design

✅ Module 4 (Month 5–7): MS Excel (Advanced)

Topics: Worksheets & Formatting, Formulas & Functions, Logical Functions (IF, COUNTIF), Charts & Graphs, Sorting & Filtering, Data Validation, Pivot Table (Basic)

Practical: Result sheet, salary sheet, billing

✅ Module 5 (Month 7–8): MS PowerPoint

Topics: Presentation Design, Slide Master, Themes & Layout, Animation & Transition, Charts & Media, Presentation Delivery

Practical: Business presentation

✅ Module 6 (Month 8–9): Internet & Email

Topics: Internet Basics, Browsers & Search Techniques, Online Forms, Email Creation & Use, Attachments & Drive, Cyber Safety

Practical: Email sending, online work

✅ Module 7 (Month 9–10): Tally / Basic Accounting

Topics: Accounting Concepts, Company Creation, Ledger & Voucher, GST Basics, Reports

Practical: Simple accounting entries

✅ Module 8 (Month 10–11): HTML & Web Designing

Topics: HTML Structure, Tags & Attributes, Text Formatting, Links & Images, Tables & Lists, Forms (Basic)

Practical: Create basic website pages

✅ Module 9 (Month 11): Database Basics

Topics: DBMS Concepts, Tables & Fields, Keys, SQL Basics, Queries

Topics: Live Project Work, Office AuPractical: Simple database queries

✅ Module 10 (Month 12): Project & Vivatomation Project, Documentation, Viva Voce