ADVANCE DIPLOMA IN COMPUTER APPLICATION ( M-09 )

Module 1: Fundamentals of Computer & Windows

• Introduction to Computer & History
• Hardware & Software Overview
• Operating System (Windows)
• File Management & Shortcuts
• MS Paint, Notepad, WordPad

Module 2: Microsoft Office (Advanced Office Automation)

MS Word

• Creating & Formatting Documents
• Tables, Header & Footer, Page Setup
• Mail Merge & Macros

MS Excel

• Basic & Advanced Formulas
• Charts, Pivot Tables, Conditional Formatting
• Data Validation, Sorting & Filtering

MS PowerPoint

• Slide Creation, Animations & Transitions
• SmartArt & Custom Design
• Presentation Techniques

MS Access (Database Management)

• Tables, Queries, Forms, Reports
• Relationship & Data Normalization

Module 3: Internet & Digital Communication

• Internet Basics & Web Browsing
• Email Management (Gmail, Outlook)
• Google Drive, Cloud Storage
• Online Form Filling & Government Portals

Module 4: Tally with GST & Accounting Basics

• Fundamentals of Accounting
• Tally ERP 9 / Tally Prime Overview
• Ledger, Voucher, Inventory Management
• GST, TDS & Taxation Reports
• Payroll & Banking Transactions

Module 5: Programming & Web Development

Basic Programming (C & C++)

• Data Types, Loops, Functions
• Arrays, Pointers, File Handling

Web Development (HTML, CSS, JavaScript)

• HTML Tags, Forms, Tables
• CSS Styling, Responsive Design
• JavaScript Basics

Module 6: Graphic Designing & Multimedia

• Adobe Photoshop / Canva Basics
• Image Editing & Logo Designing
• Business Card & Banner Designing

Module 7: Database Management & SQL

• Introduction to Database
• SQL Queries (Select, Insert, Update, Delete)
• MySQL Database Connectivity

Module 8: Cyber Security & Ethical Hacking Basics

• Introduction to Cyber Security
• Computer & Network Security
• Common Cyber Threats & Protection

Module 9: Final Project & Career Guidance

• Live Project Work
• Resume Writing & Interview Preparation
• Freelancing & Online Job Opportunities

12TH PASS