ADCA

•    Duration: 12 Months
•    Eligibility: 12th Passed

The Advance Diploma in Computer Application (ADCA) Certification is a comprehensive program designed to provide in-depth knowledge of computer applications and software tools. This course covers essential topics like programming, database management, web design, and office automation, making it ideal for individuals looking to build or enhance their IT skills.

Through hands-on training and practical projects, participants gain expertise in advanced computing concepts, preparing them for roles in IT, software development, and office management. Whether you're a student, professional, or entrepreneur, this certification equips you with the technical proficiency needed in today's digital world.

Syllabus:

---

Module 1: Fundamentals, MS Office Advanced Tools, and Internet
Unit 1: Computer Fundamentals

• Introduction to Computers
• Types of Computers
• Computer Hardware and Software
• Input and Output Devices
• Operating Systems: Types and Functions

Unit 2: MS Office Advanced Tools
Microsoft Word:

• Advanced Formatting Techniques
• Working with Styles and Templates
• Mail Merge and Macros

Microsoft Excel:

• Advanced Formulas and Functions
• Pivot Tables, Charts, and Data Analysis Tools
• Conditional Formatting and Data Validation

Microsoft PowerPoint:

• Advanced Slide Design and Animations
• Creating Interactive Presentations
• Skype
• One Note
• Publisher

Unit 3: Internet Basics

• Introduction to the Internet and Web Browsers
• Internet Safety and Security
• Email and Web Communication Tools
• Social Media and Professional Networking
• Cloud Computing and File Sharing
• E-mail Management

---

Module 2: Photoshop and CorelDRAW
Unit 1: Adobe Photoshop

• Introduction to Photoshop Interface
• Working with Layers and Masks
• Image Editing: Cropping, Resizing, and Color Adjustment
• Text and Typography
• Filters, Effects, and Photo Manipulation
• Creating Logos and Banners
• Exporting and Optimizing Images for Web

Unit 2: CorelDRAW

• Introduction to CorelDRAW Interface
• Basic Drawing and Shape Tools
• Using Layers and Object Management
• Text and Typography in CorelDRAW
• Creating Logos, Posters, and Brochures
• Color Management and Printing Techniques
• Exporting Designs in Different Formats

---

Module 3: HTML, CSS, and JavaScript
Unit 1: HTML (Hypertext Markup Language)

• Introduction to HTML and Structure of a Web Page
• HTML Tags and Elements
• Links, Images, and Multimedia
• Forms and Input Controls
• Tables, Lists, and Semantic HTML

Unit 2: CSS (Cascading Style Sheets)

• Introduction to CSS and Styling Web Pages
• CSS Syntax and Selectors
• Box Model and Layout Techniques
• Advanced Styling: Transitions, Animations, and Effects
• Responsive Web Design (Media Queries)

Unit 3: JavaScript

• Introduction to JavaScript and its Role in Web Development
• Variables, Functions, and Loops
• DOM Manipulation (Document Object Model)
• Event Handling and Validation
• Introduction to AJAX (Asynchronous JavaScript and XML)

---

Module 4: Tally Prime
Unit 1: Introduction to Tally Prime

• Installation and Setup
• Tally Interface Overview
• Company Creation and Configuration

Unit 2: Accounting and Financial Management

• Vouchers and Transactions (Sales, Purchases, Payments, Receipts)
• Accounting Principles and Ledgers
• Inventory Management: Stock Groups and Items
• Stock Valuation Methods

Unit 3: Reporting in Tally

• Generating Financial Reports (Balance Sheet, Profit & Loss)
• GST Returns and Filing
• Customizing Reports
• Exporting Data for Tax Filing

Unit 4: Advanced Features of Tally Prime

• Tally Prime Shortcut Keys and Tips
• Tally Prime's Payroll Module
• Managing Multiple Companies in Tally
• Security and User Management

---

Learning Profile:

Graphic/Website Designer, Office Assistant, Computer Teacher, Programmer.

Finally Exit Profile > Junior S/W Engineer