The syllabus of the Advance Diploma in Computer Application has various subjects such as Forms, databases, Photo editing software, Design Process, etc. The ADCA courses cover a wide range of topics and are divided into three Modules. This is a flexible course that aims to ensure that the students gain access to all the information they need. The module-by-module ADCA subject list is listed below:

Module 1 : Computer Basic 

• Computer Fundamentals
• English Typing
• Notepad
• Wordpad
• M.S. Paint
• Outlook
• Internet
• Project Work

Module 2 : MS Office

• Microsoft Word
• Microsoft Excel
• Microsoft Powepoint

Module 3 : Advance Excel 

• Working with Formulas
• sum, sumifs, count, counta, countblank, countif, countifs
• Vlookup
• Hlookup
• lookup (all variations)
• Index  with match
• Pivot Table & chart
• Basic & Advance value fiels setting
• Filtering & sorting
• Charts (bar, pie, line, dynamic)
• Conditional Formula (if, Nestedif, and, or and not)
• Working with diffrent types of reports by using macros
• Advance text function using formula and cell formatting
• Validation (Data, Number, Date & Time, Text, List), Advance Filter, Flash Fill
• What if Analysis, Goal Seak, Scenario Manager, Data Table
• Project Work

Module 4 : Tally Prime with GST 

• Fundamental of Accounting: Knowledge of Assets, Liabilities, Expense
• Book Keeping, Ledger, Trial Balance, Final & Trading A/c, Profit & Loss A/c, Balance Sheet
• Introduction of Tally Prime, Company, Ledger, Group, Group Company Creation & Alteration
• Ledger Posting, Bank Reconciliation, Inventory Management, Stock Item, Stock Group
• Stock Summary, Consumption, Production & Cost Center Management, Compound Unit, Bills of material
• Consolidate Balance Sheet, Split Company Data, User Security, Back-up & Restore
• Recording and Maintaining Accounting Vouchers, Vouchers Introduction, Single & Double Entry System
• Payment, Receipt, Contra, Journal, Sales & Purchase Invoice / Vouchers
• Utility Backup & Printing Reports.
• Goods and Services Tax (TDS, TCS), Payroll
• Project Work

Module 5 : Graphic Designing 

• Adobe Photoshop     
• Corel Draw   
• Project Work

Microsoft Excel Advance Features
Menu Bars

• Formula
• Data
• Review
• View

Project & Assignments

• GST Invoice & Bills
• Payroll
• Income Tax
• Mark sheet
• Basic Data Entry
• Salary Statement

Advance Formulas & Functions

• Lookup, Vlookup, Hlookup
• Sumif, sumifs
• Counta, countif, countifs, countblank
• Concatenate
• Datedif, date, month, year, day, edate, eodate, time
• Lan, trim, repeat,
• Upper, lower, proper
• Mid, Left, Right
• Dmax, dmin, dsum, daverage, sumproduct
• If, ifs,
• And, or, true, false
• Pivot Table & Chart
• Whatif analysis, goalseek, data table

Working with option

• Group, ungroup
• Print area
• Print Title
• Freeze panel
• Data validation
• Text to column
• Remove duplicate
• Consolidate

Advance Shortcut

Computer Basics

• Computer Fundamental
• Notepad
• Wordpad
• Paint
• Typing

MS Office

• Microsoft Word
• Microsoft Excel
• Microsoft Powepoint

Internet

• Searching
• Downloading (Songs, Video, Movies, Documents)
• Form Filling (School, College, Job)
• Email id
• Online Shopping
• Ticket Booking (Train, Bus, Flight, Movie)
• Money Transfer

Computer Tips & Tricks

• Shortcuts
• Folder Making
• Deleting
• Hiding
• Wallpaper Setting
• Date Time
• Copy Paste
• Data Transfer
• Printout

Personality Development, Office Management, Basic Hardware

Module 1: Introduction to Graphic Design

Start by learning fundamental design principles, including color theory and typography. Understand the distinctions between raster and vector graphics to lay the groundwork for your design journey.

Module 2: CorelDRAW

Familiarize yourself with CorelDRAW's interface and essential tools. Learn to draw basic shapes, utilize the Pen tool, handle text, using fills, gradients, and managing objects. Practice importing and exporting files.

Project: Design a simple logo and business card.

Module 3: Adobe Photoshop

Navigate Adobe Photoshop’s interface and fundamental tools. Begin with photo editing and retouching, using adjustment layers, basic filters, mastering selections, layers, and blending modes to create more complex compositions.

Project: Retouch a photograph and create a basic digital collage.

Module 4: Adobe Illustrator

Learn Adobe Illustrator's interface and basic tools. Start with drawing shapes, using the Pen tool, working with typography, applying colors, gradients, and patterns. Explore Pathfinder and Shape Builder tools.

Project: Design a simple icon set and a poster.

Module 5: Adobe InDesign

Get to know Adobe InDesign's interface and tools. Create basic layouts incorporating text, images, using styles and tables, and prepare files for print and digital formats.

Project: Design a brochure and a basic multi-page magazine layout.

Final Project

• Integrate all the skills learned by creating a complete branding package for a fictional company. Present your work and engage in peer critiques to refine your designs further.

Tally Prime with GST

• Fundamental of Accounting: Knowledge of Assets, Liabilities, Expense
• Book Keeping, Ledger, Trial Balance, Final & Trading A/c, Profit & Loss A/c, Balance Sheet
• Introduction of Tally Prime, Company, Ledger, Group, Group Company Creation & Alteration
• Ledger Posting, Bank Reconciliation, Inventory Management, Stock Item, Stock Group
• Stock Summary, Consumption, Production & Cost Center Management, Compound Unit, Bills of material
• Consolidate Balance Sheet, Split Company Data, User Security, Back-up & Restore
• Recording and Maintaining Accounting Vouchers, Vouchers Introduction, Single & Double Entry System
• Payment, Receipt, Contra, Journal, Sales & Purchase Invoice / Vouchers
• Utility Backup & Printing Reports.
• Goods and Services Tax (TDS, TCS), Payroll
• Project Work

Description: 

PGDCA full form is Post Graduate Diploma in Computer Application. PGDCA course duration is 1-year, and it focuses on providing students with advanced theoretical and development expertise in computer science and computer applications in the field of IT. PGDCA course fees ranges between INR 7,000 to 1,10,000. PGDCA Syllabus begins with the fundamentals of information technology and lays emphasis on discplines like programming, Java, Data structures, and more.

Description: 

The full form of DCA is a Diploma in Computer Application. It is a one-year computer-based diploma or course. The course is intended to provide learners with basic, realistic and technological details pertaining to programming tools and applications which are used in our everyday lives. An intermediate or 12th class in any stream from a recognized board or university is the required qualification needed for this program

• Basic internet concepts
• Computer Fundamentals
• Introduction to programming
• Programming in C
• RDBMS & Data Management
• Multimedia
• Corel draw
• Tally ERP 9.0
• Photoshop

Digital Marketing Course

Module 1: Introduction to Digital Marketing

• Overview: Understand the basics of digital marketing, including key strategies and channels. Learn the importance of an integrated approach.

Module 2: Search Engine Optimization (SEO)

• Basics: Learn about on-page and off-page SEO techniques, keyword research, and optimization.
• Advanced Techniques: Explore link building, technical SEO, and tools like Google Analytics and Search Console.
• Project: Optimize a sample website and create an SEO strategy.

Module 3: Social Media Marketing (SMM)

• Basics: Understand social media platforms, content creation, and engagement strategies.
• Advanced Techniques: Learn about analytics, social listening, and platform-specific strategies.
• Project: Develop and execute a social media campaign for a brand.

Module 4: Facebook Ads

• Basics: Get acquainted with Facebook Ads Manager, ad creation, and targeting options.
• Advanced Techniques: Dive into ad optimization, A/B testing, and tracking performance metrics.
• Project: Create and manage a Facebook ad campaign with measurable objectives.

Module 5: Affiliate Marketing

• Basics: Understand affiliate marketing concepts, including commission structures and finding affiliate programs.
• Advanced Techniques: Explore strategies for increasing conversions and managing affiliate relationships.
• Project: Develop an affiliate marketing plan for a product or service.

Module 6: AI Tools

• Basics: Learn about AI tools for marketing automation, data analysis, and customer insights.
• Advanced Techniques: Implement AI-driven strategies and tools to enhance marketing efforts.
• Project: Use AI tools to analyze marketing data and optimize campaigns.

Module 7: Blogging and Professional Websites

• Basics: Create and manage a blog, focusing on content creation and SEO.
• Advanced Techniques: Design a professional website with best practices for user experience and SEO.
• Project: Build and launch a blog and a professional website.

Module 8: E-Commerce Website

• Basics: Learn about e-commerce platforms, product listings, and payment integration.
• Advanced Techniques: Implement strategies for driving traffic, optimizing conversions, and managing an online store.
• Project: Develop an e-commerce website with a complete product catalog and marketing plan.

Final Project

Integrate all learned skills to develop a comprehensive digital marketing strategy for a business, including SEO, social media, advertising, and e-commerce. Present and critique each other's work.

Advance Excel 

• Working with Formulas
• sum, sumifs, count, counta, countblank, countif, countifs
• Vlookup
• Hlookup
• lookup (all variations)
• Index  with match
• Pivot Table & chart
• Basic & Advance value fiels setting
• Filtering & sorting
• Charts (bar, pie, line, dynamic)
• Conditional Formula (if, Nestedif, and, or and not)
• Working with diffrent types of reports by using macros
• Advance text function using formula and cell formatting
• Validation (Data, Number, Date & Time, Text, List), Advance Filter, Flash Fill
• What if Analysis, Goal Seak, Scenario Manager, Data Table
• Project Work

Focus Formula

• Lookup, Vlookup & Hlookup
• Vlookup & Hlookup with Match
• Index With Match
• Advanced Conditional Formatting

Report Techniques

• Introducing to Excel Dashboard
• Pivot Table Dashboard using Slicer
• Understanding Reports
• Report using Chart & Table
• Report using Pivot Table

Python

• Installing Python
• Variables, expressions, and statements
• Conditional Execution
• Functions
• Loops and Iterations
• Strings
• Files
• Lists
• Dictionaries
• Tuples
• Regular Expressions
• Network Programming
• Using Web Services
• Object-Oriented Programming
• Databases
• Data Visualization
• Project Work

BCA

Computer Basic 

• Computer Fundamentals
• Typing
• Notepad
• WordPad
• M.S. Paint

MS Office

• MS Word
• MS Excel
• MS PowerPoint
• MS Outlook

Internet

Project Work

Computer Fundamental

• Computer Basics
• Notepad
• Wordpad
• Paint
• Internet
• Typing

Excel Basics

• Working with Formulas
• sum, sumifs, count, counta, countblank, countif, countifs
• Vlookup
• Hlookup
• lookup (all variations)
• Index  with match
• Charts (bar, pie, line)
• Conditional Formula (if, Nestedif, and, or and not)
• Project Work

Tally Prime with GST 

• Fundamental of Accounting: Knowledge of Assets, Liabilities, Expense
• Book Keeping, Ledger, Trial Balance, Final & Trading A/c, Profit & Loss A/c, Balance Sheet
• Introduction of Tally Prime, Company, Ledger, Group, Group Company Creation & Alteration
• Stock Summary, Consumption, Production & Cost Center Management, Compound Unit, Bills of material
• Payment, Receipt, Contra, Journal, Sales & Purchase Invoice / Vouchers
• Utility Backup & Printing Reports.
• Project Work

Computer Basic 

• Computer Fundamentals
• English Typing
• Notepad
• Wordpad
• M.S. Paint
• Outlook
• Internet
• Project Work

MS Office

• Microsoft Word
• Microsoft Excel
• Microsoft Powepoint

Advance Excel 

• Working with Formulas
• sum, sumifs, count, counta, countblank, countif, countifs
• Vlookup
• Hlookup
• lookup (all variations)
• Index  with match
• Pivot Table & chart
• Basic & Advance value fiels setting
• Filtering & sorting
• Charts (bar, pie, line, dynamic)
• Conditional Formula (if, Nestedif, and, or and not)
• Working with diffrent types of reports by using macros
• Advance text function using formula and cell formatting
• Validation (Data, Number, Date & Time, Text, List), Advance Filter, Flash Fill
• What if Analysis, Goal Seak, Scenario Manager, Data Table
• Project Work

C

• Introduction
• Pointers
• Memory
• Variables
• Operators
• Conditionals
• Loop
• Array
• String
• Function
• Structure
• Project Work

C++

• Introduction
• Variables
• Conditionals & Logic
• Loops
• Loops Challenge Project
• Vectors
• Functions
• Functions Challenge Project
• Classes & Objects
• References & Pointers
• Project Work

Computer Fundamental

• Computer Basics
• Notepad
• Wordpad
• Paint
• Internet
• Typing

MS Office

• Microsoft Word
• Microsoft Excel
• Microsoft Powepoint

Advance Excel 

• Working with Formulas
• sum, sumifs, count, counta, countblank, countif, countifs
• Vlookup
• Hlookup
• lookup (all variations)
• Index  with match
• Pivot Table & chart
• Basic & Advance value fiels setting
• Filtering & sorting
• Charts (bar, pie, line, dynamic)
• Conditional Formula (if, Nestedif, and, or and not)
• Working with diffrent types of reports by using macros
• Advance text function using formula and cell formatting
• Validation (Data, Number, Date & Time, Text, List), Advance Filter, Flash Fill
• What if Analysis, Goal Seak, Scenario Manager, Data Table
• Project Work

Tally Prime with GST 

• Fundamental of Accounting: Knowledge of Assets, Liabilities, Expense
• Book Keeping, Ledger, Trial Balance, Final & Trading A/c, Profit & Loss A/c, Balance Sheet
• Introduction of Tally Prime, Company, Ledger, Group, Group Company Creation & Alteration
• Ledger Posting, Bank Reconciliation, Inventory Management, Stock Item, Stock Group
• Stock Summary, Consumption, Production & Cost Center Management, Compound Unit, Bills of material
• Consolidate Balance Sheet, Split Company Data, User Security, Back-up & Restore
• Recording and Maintaining Accounting Vouchers, Vouchers Introduction, Single & Double Entry System
• Payment, Receipt, Contra, Journal, Sales & Purchase Invoice / Vouchers
• Utility Backup & Printing Reports.
• Goods and Services Tax (TDS, TCS), Payroll
• Project Work

Module 1: Introduction to Graphic Design

• Overview: Learn design principles, color theory, and typography basics. Understand the difference between raster and vector graphics.

Module 2: CorelDRAW

• Basics
  • Get familiar with the interface and tools
  • Learn to draw shapes
  • use the Pen tool, and work with text.
• Advanced Techniques
  • Explore fills
  • gradients
  • Object management
  • Practice importing and exporting files.
• Project
  • Design a logo and business card.

Module 3: Adobe Photoshop

• Basics
  • Navigate the interface and tools
  • Edit and retouch photos
  • use adjustment layers
  • Apply filters.
• Advanced Techniques
  • Master selections
  • layers
  • Blending modes
  • Create complex compositions.
• Project
  • Retouch a photograph and create a digital collage.

Module 4: Adobe Illustrator

• Basics
  • Learn the interface and tools
  • Draw shapes
  • use the Pen tool
  • work with typography.
• Advanced Techniques
  • Apply colors
  • gradients
  • patterns
  • Use Pathfinder and Shape Builder tools.
• Project
  • Design an icon set and create a poster.

Module 5: Adobe InDesign

• Basics
  • Get to know the interface and tools
  • Create layouts with text and images.
• Advanced Techniques
  • Use styles
  • tables
  • Prepare files for print
  • Digital formats.
• Project
  • Design a brochure and a multi-page magazine layout.

Final Project

Create a complete branding package for a fictional company, integrating all learned software tools. Present and critique each other’s work.

Web Designing Course

Introduction

This course aims to equip beginners with the foundational skills needed to design and create functional, aesthetically pleasing websites. It covers the core languages of web development—HTML, CSS, and JavaScript—along with an introduction to responsive design and best practices for user experience (UX) and user interface (UI) design.

Module 1: HTML (HyperText Markup Language)

• Basics of HTML: Understanding tags, elements, and attributes.
• Structuring Web Pages: Using headings, paragraphs, lists, and links.
• Multimedia Integration: Embedding images, audio, and video.
• Forms and Tables: Creating interactive forms and organizing data with tables.

Module 2: CSS (Cascading Style Sheets)

• Introduction to CSS: Selectors, properties, and values.
• Styling Text and Layouts: Font properties, colors, and spacing.
• Box Model: Margins, borders, padding, and content.
• Responsive Design: Media queries and flexible grid layouts.

Module 3: JavaScript (JS)

• JavaScript Basics: Variables, data types, and operators.
• DOM Manipulation: Selecting and modifying HTML elements.
• Event Handling: Responding to user actions.
• Basic Animations and Effects: Creating dynamic user experiences.

Module 4: Responsive Web Design

• Fluid Grids and Flexible Images: Ensuring websites look good on all devices.
• Bootstrap Framework: Using pre-designed components to speed up development.
• Mobile-First Design: Designing for mobile devices first, then scaling up.

Module 5: UX/UI Fundamentals

• Principles of Good Design: Balance, contrast, and emphasis.
• User-Centered Design: Focusing on the needs and behaviors of users.
• Wireframing and Prototyping: Planning and testing design concepts before development.

Conclusion

By the end of this course, students will have the skills to create and maintain their websites. They will understand the basics of web design and development, enabling them to continue learning and exploring more advanced topics independently.

ADIT (Advance Diploma in Information Technology) is a professional course that covers advanced computer applications, programming, and office automation. It is useful for jobs in IT, data management, web development, and office automation.

ADIT (Advance Diploma in Information Technology) – Syllabus :

1. Computer Fundamentals & Operating System

2. MS Office

MS Word

MS Excel

MS PowerPoint

MS Access (optional)

3. Advanced Excel

4. Internet & Digital Concepts

5. Web Designing

HTML

CSS

JavaScript

6. Python Programming

7. Database Basics (Optional in some institutes)

8. Cyber Security Basics

9. Project Work / Practical Assignment

10. Soft Skills & Communication