ADCA – Advanced Diploma in Computer Application

1. MS Office (Basic + Advanced)

• MS Word: Formatting, Templates, Styles, Mail Merge, Document Design
• MS Excel:
• Basic: Formulas, Functions, Data Entry, Formatting
• Advanced Excel:
• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
• Pivot Table & Pivot Chart
• Conditional Formatting
• Data Validation
• MIS Report Designing
• Charts & Graphs
• Macro Recording (Basic)
• MS PowerPoint: Animations, Transitions, SmartArt, Business Presentations

2. Windows Operating System

• File & Folder Management
• Control Panel/Settings
• Disk & Device Management
• Basic Troubleshooting
• User Accounts & Permissions

3. AI Tools & Techniques

• AI-based Productivity Tools (ChatGPT, Bard, Gemini, Copilot basics)
• AI in Office Work: Summaries, presentaion creation, data formatting
• AI-based Image & Video Editing tools (basic)
• AI Automation Tools (simple workflows)

4. Accounting with Tally Prime

• Company Creation
• Ledgers & Groups
• Voucher Entries (Sales, Purchase, Payment, Receipt, Contra, Journal)
• GST Basics
• Inventory Management
• Reports: Balance Sheet, Profit & Loss, Trial Balance
• Exporting/Printing Reports

5. Graphic Designing & Multimedia

• CorelDraw
• Logo Design
• Visiting Card, Banner, Poster Design
• Page Layout & Printing
• Photoshop
• Tools & Workspace
• Image Editing, Retouching
• Background Removal
• Social Media Creatives
• Multimedia
• Audio/Video Editing (Basic)
• Canva Design Basics

6. Cyber Security (Basic)

• Online Safety & Privacy
• Password Security
• Safe Browsing Practices
• Phishing & Online Fraud Awareness
• Virus & Malware Protection

7. Computer Hardware & Software Installation

• Components Identification
• Assembling/Disassembling (Basic)
• Formatting & OS Installation
• Drivers & Software Installation
• Troubleshooting Basic Issues

8. English & Hindi Typing Skills

• English Typing – 30 WNPM Target
• Hindi Typing – 20 WNPM Target
• Accuracy & Speed Improvement
• Typing Test Practice

9. Internet – Advanced Level

• Advanced Browsing Techniques
• Cloud Storage (Google Drive / OneDrive)
• Online Forms & E-services
• Professional Email Handling
• Online Safety & Digital Etiquettes

10. Digital Marketing (Basic to Intermediate)

• SEO Basics
• Social Media Marketing
• Content Creation
• Google Business Profile Setup
• Facebook/Instagram Page Management
• Campaign Basics

11. Project & Practical Evaluation

• MS Excel MIS Project
• Tally Accounting Project
• Graphic Designing Project
• PowerPoint Presentation Project
• Digital Marketing Mini Project