A.D.C.A. Course Syllabus

Module 1: Complete Fundamentals of Computer

• Introduction to Computers: Understanding computer hardware and software.
• Operating Systems: Basic operations and concepts of different operating systems (Windows, Linux, etc.).
• Computer Components: Learn about CPU, RAM, storage devices, and peripheral devices.
• File Management: How to organize, create, save, and manage files and folders on a computer.

Module 2: Microsoft Word

• Creating and Formatting Documents: Learn how to create professional documents with text formatting, headings, bullet points, etc.
• Using Tables and Graphs: Inserting and formatting tables, charts, and smart art to present data visually.
• Styles & Themes: Applying document styles, and using headers and footers for formal documents.
• Document Review: Using spelling and grammar checks, comments, and revisions.

Module 3: Microsoft Excel

• Basic Spreadsheet Functions: Learn data entry, formatting, and using basic formulas (SUM, AVERAGE, COUNT).
• Data Analysis Tools: Applying conditional formatting, charts, and pivot tables to analyze and present data effectively.
• Excel Functions: Advanced functions like VLOOKUP, IF, and more complex data manipulations.

Module 4: Advanced Excel

• Advanced Formulas & Functions: Deep dive into functions like INDEX, MATCH, and array formulas.
• Data Validation & Protection: Learn how to restrict data input and protect cells in Excel sheets.
• Macros and Automation: Creating and using macros to automate tasks in Excel.
• Complex Pivot Tables & Dashboards: Designing dashboards for business reports.

Module 5: Microsoft PowerPoint

• Creating Presentations: Building slideshows, inserting multimedia, and using themes and transitions.
• Designing Professional Presentations: Advanced slide layouts, graphic designs, and using animations.
• Interactive Features: Embedding hyperlinks, action buttons, and creating interactive presentations.

Module 6: Tally Prime

• Introduction to Tally: Understanding the fundamentals of accounting software.
• Using Tally for Bookkeeping: Learn to enter vouchers, manage accounts, and generate financial reports.
• Taxation Features: Using Tally Prime to manage GST, VAT, and other tax-related entries.
• Inventory Management: Tracking inventory using Tally Prime’s tools.

Module 7: Adobe Photoshop

• Basic Image Editing: Learn to crop, resize, and adjust image quality.
• Advanced Techniques: Using layers, masks, filters, and blending modes for professional image editing.
• Creating Graphics: Learn how to create graphics for websites, advertisements, and social media.
• Text Effects and Typography: Adding and styling text, creating attractive titles and captions.

Module 8: CorelDRAW

• Vector Graphic Design: Learn to create and manipulate vector shapes, paths, and curves.
• Logo and Branding Design: Create professional logos, business cards, and branding material.
• Working with Text and Effects: Using the text tool, applying effects like shadows and 3D styles to designs.
• Advanced Tools: Master tools like PowerClip, Blend Tool, and more for intricate designs.

Module 9: Adobe InDesign

• Document Layouts: Creating multi-page documents like brochures, newsletters, and magazines.
• Master Pages and Styles: Using master pages for consistency across documents and applying paragraph styles.
• Typography in InDesign: Working with text frames, linking text boxes, and managing typography.
• Publishing Projects: Exporting documents for digital and print publication.

Module 10: HTML

• HTML Basics: Learn the structure of a webpage using HTML tags, headings, paragraphs, and links.
• Form Elements: Create forms, buttons, and input fields for user interaction.
• HTML5 Tags: Implement newer HTML5 elements for richer multimedia content.

Module 11: CSS (Cascading Style Sheets)

• Styling Webpages: Learn to apply styles (colors, fonts, layouts) to HTML elements.
• CSS Selectors and Properties: Understanding how to target specific elements on a page.
• Box Model and Layouts: Master positioning, margins, padding, and flexbox for layout control.

Module 12: CSS3

• Advanced CSS Styles: Learn how to use transitions, animations, and responsive design.
• CSS3 Properties: Using modern CSS3 techniques like gradients, shadows, and custom fonts.
• Responsive Web Design: Implement media queries to create mobile-friendly websites.

Who is this course for?

This course is designed for:

• • Handling office tools (Word, Excel, PowerPoint, etc.) for efficient documentation, data analysis, and presentation.
  • Graphic design skills using Photoshop, CorelDRAW, and InDesign for creative work like logo design, marketing materials, and web graphics.
  • Web development basics with HTML and CSS, creating responsive websites.
  • Accounting knowledge with Tally Prime, applying it to financial and tax-related tasks.

This comprehensive course equips students with a wide skill set to excel in diverse IT, design, and accounting roles.

Job Roles and Salary Range after Completing A.D.C.A.:

Course Outcome:

Upon completion of the A.D.C.A. course, students will be proficient in:

• Handling office tools (Word, Excel, PowerPoint, etc.) for efficient documentation, data analysis, and presentation.
• Graphic design skills using Photoshop, CorelDRAW, and InDesign for creative work like logo design, marketing materials, and web graphics.
• Web development basics with HTML and CSS, creating responsive websites.
• Accounting knowledge with Tally Prime, applying it to financial and tax-related tasks.

This comprehensive course equips students with a wide skill set to excel in diverse IT, design, and accounting roles.