Adv.Diploma In Computer Application - ADCA

IT/Digital Era - Entering into Computer World Keep your Data (Storage Device)

• Computer Definition & Features
• Application of computer
• How to start Computer
• login screen - user & Password
• Desktop- Taskbar, Wallpaper, Icons
• How to start paint, some basic tools

• Computer Architecture Diagram
• Father of computer
• Devices of computer: Input, output & processing Memory Unit(MU)
• Primary memory, Secondary memory
• Unit of measurements
• Hardware & Software
• File & folder

Find your Space in Computer (File & Folder)

• Window explorer , File & folder

Searching : Find your File/Folder Wild Cards

• Extensions of program
• Wild card Asterisk(*), Question mark(?)
• Searching for file and folder

1.Start your Career - CV/Resume Creation

• Definition, Feature
• How to start Ms Word
• File, font group

2.Beautifying your CV/Resume (Formatting)

• Quick Access Tool Bar
• Paragraph Group, Clipboard group, Editing group

3.Letterhead - Show case of Your Company

• Insert tab: Header & footer group
• Date & Time, Symbol Picture
• Home tab: change Case, Border & Shading

4.News Paper & Magazine Creation (Column)

• Page layout tab: columns, column break
• Insert tab: Drop cap, Book cover
• file:Auto correct
• Review tab: Word Count, Spell Check, Thesaurus

5.Create your Own Book

• Refrence tab: Insert endnotes, Insert footnotes, table of content
  watermark, Hyphenation

6.Links and Security

• Refrence tab: Insert caption, index entry,
• Links: Booksmarks, Hyperlink, cross Reference
• Review tab: Track changes, Protect document

7.Connect your Customer (Bulk Mailing)

• Mail Merge , Main document & Data source

8.Connect your selected customer(Record filtration)

• Sorting of Record
• Filter of Record
• Lables
• Envelope

9.Mark sheet Creation (Tabular format data )

• Insert table, Draw table
• Layout tab
• Design tab

10.Document is ready to print/Record your actions

• Page setup
• Print preview
• Print
• Macro

1.World of Row and Column - First interaction with excel

• Introduction of excel, Workbook, Worksheet, Row, Column, Cell, type of entries
• Home tab: Cell group, Font group, Alignment

2.Invoice / Bill of Supply

• Type of Reference : Absolute, Relative
• Basic formulas
• Sum, Product, Minus, Quotient, Mod, Percentage)

3.Result Declared (Automatic Calculation)

• Function

4.Secure your Data/ Lock your data/ Restrict editing

• Styles group :  Format as table, Conditional Formatting, Cell styles
• Protection: Track Changes, Protection

5.Data Analysing Tool (Expense Limit & Comparision)

• What if Analysis: Goal seek, Scenario, Data table

6.Pictorial Representation of Data (Chart Magic)

• Pictorial Represntation of data
• Chart, type of chart, formatting of charts

7.Organize your Data (Easier to Analyze)

• Data validation, Data filtration, sort, subtotal

8.Analyzing Complex Data (Pivot Table)

• Logical function: if and, if or
• Pivot table, Pivot chart, Paste special

9.Lookup & Reference , Extract Your Data

• Lookup functions : lookup, vlookup, hlookup
  match, index

10.Data is ready to Print /Page Setup

• Page setup
• Print preview

1.Welcome to Presentation World

• PowerPoint - Definition feature, purpose ,view of slides
• Home tab-slide group

2.Beautifying presentation (Formatting of presentation)

• Font & Alignment Group
• Inset tab - Illustration group
• Themes & Background

3.Masters of Slide/ Slide Automation

• Masters
• Animation(triggers
• Transition
• Hyperlink, Actions
• Slide background

4.Its presentation time now

• Slide show tab - From beginnng, from current slide, Custom slide show,setup slide, Hide slide, Record narratio, Rehearse timing, slide show
• Inset tab- photo album

5.Advance feature of Presentation

• Running Clock, Moving Car, Making Picture, Bouncing Ball

1.World of Internet 

• Internet introduction & Benefit
• Computer Network: LAN, WAN, MAN
• Services of internet
• Search engine, Web browser

2.Online Communication

• Inbox , Reply, Forward, composing, Attachments of file,
  Change password(setting of E-mails) , Facebook account handling, 
  Facebook page creation

3.Downloads/Booking

• Ticket Reservation & Booking, Online shopping, Online Bill payment, Book movie ticket
• Download: Image, font style, app, pdf, song, movie

4.Digital India

• Cash less society
• E-wallets, UPI, Plastic money, USSD, Net Banking

1.My Business Card

• Document (Page Setup), Size of Business Card
• Tools (Selection, Direct Selection , Shape Tool(Rectangle, Ellipse, Polygon)
• Shapes Property Fill Color & Outline Color
• File Menu New, Open, Save, Save as, Exit

2.Typography

• Tools Gradient, Text Tool & its properties, Type on Path Tool
• Object Menu Arrange, Group, Ungroup, Lock, Unlock
• Place Image

3.Magazine Cover

• Tools Text tool, Gradient Tool
• Layout Menu Ruler Guides, Create Guides, Layout Adjustment
• Object Menu Effects

4.Stylish Brochure Template

• Tools Frame Tool (Ellipse, Rectangle, Polygon), Eye Dropper, Pen, Pencil, Eraser, Line
• Object Menu Corner Options, Pathfinder"
• Layout Menu Columns, Ruler Guides, Create Guides, Layout Adjustment

5.Books & News Paper Publishing

• Layout Menu Add Page, Go to Page, Edit In Story, Auto flow
• Page Pallete Insert Page Number, Master Page
• Type Menu Drop Cap, Bullets & Numbering, Alignments

6.Indexing

• Type Menu Character, Paragraph, Table & Object style
• Layout Menu Table Of Contents

7.Design & Database Fusion-Merging

• Window Menu Data Merge
• File Menu Export

8.Mail and Print

• Types of Printing
• File Menu Export, Print

1.Layering - Backbone Of Picture /Photo

• Intro Photoshop, Application of Photoshop
• Difference Between Image & Layer
• Color Foreground & Background
• Tools Move, Marquee, Zoom, Hand
• File Menu New, Open, Save

2.Play With Background

• Tools Pencil tool , sharpen , smudge , dodge
  ,burn , sponge , Lasso, Magic Wand, Crop, Slice
• Layer pallete new, duplicate,delete,
• Image menu color balance, hue & saturation

3.Masking (Amazing creativity)

• Tools Brush tool
• Layer Menu Layer Mask, Vector Mask, Clipping Mask
• Filter Menu Effects

4.Movie Poster Making

• Gradient ,eraser , paint, bucket, eye dropper
• Layer menu layer style ,merge visible, merge down, flattern 

5.Wedding Album

• Tools  Pattern Stamp, History Brush, Art History Brush
• Layer Menu Masking

6.Logo Creation

• Tools Text and its Parts
• Image Menu modes (RGB, CYMK ,Grayscale)
• Shape Tools Custom Shape Tool, Other Shapes

7.Day to Night Conversion , Water Ripple

• Tools Pen, Path Selection, Direct Selection
• Edit Menu Define Brush
• View Menu Ruler

8.Retouching Image

• Tools Healing Brush, Patch, Clone Stamp, History Brush, Smudge
• Layer Pallate Blending Modes

9.Light & Glow

• Filter Menu Extract, Liquefier, Distort, Stylize, Artistic Gallery
• Layer Pallate Blending Modes

10.Animated Photo & Waterfall

• Layer Pallete Adjustment Layer
• Image Menu Adjustment
• Window Menu Animation (Frames , Timeline)

11.Web Layout/Thumbnail

• Filter Menu Vanishing Point
• Edit Menu Free Transform

12.Passport Size Photos

• File Menu Automate (Batch Create Droplet, Conditional Mode Change, Fit Image, Photo Merge, Crop & Straighten Photo, Picture Package, Contact sheet II Action)
• Layer Menu Smart Object

13.2D Painting

• Image Menu Adjustment Options
• Layer Menu Blending Options

1. Introduction to Canva

• Overview of Canva and its features
• Setting up a Canva account
• Navigating the Canva dashboard

2. Social Media Graphics

• Designing social media posts for Facebook, Instagram, Twitter, and LinkedIn
• Creating social media stories and ads
• Using Canva's social media templates and design tools

3.Presentations

• Creating engaging presentations for work, school, or personal projects
• Using Canva's presentation templates and design tools
• Adding text, images, and graphics to presentations

4.Infographics

• Visualizing data and information with Canva's infographic templates
• Designing and customizing infographics
• Using charts, graphs, and icons in infographics

5.Posters, Flyers, and Brochures

• Designing eye-catching posters for events, promotions, or advertising
• Creating flyers for events, businesses, or services
• Designing tri-fold or bi-fold brochures for marketing materials

6.Business Cards and Branding Materials

• Creating professional business cards with Canva's templates and design tools
• Developing brand guidelines, logos, and visual identities
• Designing letterheads, envelopes, and other branding materials

7.Videos and Animations

• Creating short videos or animations using Canva's video editing tools
• Adding text, images, and graphics to videos
•  Exporting and sharing videos

8.Invitations and Advanced Topics

• Creating invitations for events, parties, or weddings
• Using advanced Canva features like custom fonts, illustrations, and animations

1.Masking

• Intro of Illustrator, Document (page Setup)
• Tools Selection Tool, Direct Selection Tools, Shape Tool(Rectangle, Rounded Rectangle, Ellipse, Polygon), Bloat Tool, Warp Tool
• Shape Property Fill Color & Outline Color
• Clipping Mask

2.Logo Creation

• Tools Gradient, Pen Twirl, Pucker, Scalop , Crystalize, Wrinkle, Group Selection, Magic Wand, Lasso
• Object Menu Arrange Group, Ungroup, Lock, Unlock, Hide, Show
• File Menu Place Image

3.Create Your Own Pattern / Now Your Creativity

• Tools Text & Its Part, Line Segment, Arc, Spiral, Polar Grid, Rectangle Grid,
• Symbol & Its Part, Shape Bulider tool ,object menu :Blend

4.Floral Vector

• Tools Brush, Pencil, Smooth, Path Eraser, Rotate, Reflect
• Object Menu Blend Option
• Effects Menu Distort & Transaction
• Window Menu Align, Gradient, New Brush

5.Social Media Post

• Tools Scale, Shear Text tool, Gradient tool
• Object Menu Clipping Mask
• Effects Menu Photoshop Effects

6.Boucher /Flyer Designing

• Tools Shapes, Pen tool, Gradient
• Type Menu (Font, Recent Fonts, Size, Glyphs, Area Type options, Type on a path, Create Outlines, Find Fonts, Change Case
• Object Menu Clipping Mask
• View Menu Ruler Guide

7.3D Fun

• Effects Menu 3D > Extrude And Bevel
• Tools Eraser, Hand, Zoom, Star, Flare
• Edit Menu Copy, Paste in Front, Paste in Back , Key board shortcuts

8.Beautiful Flower pot With Symbol

• Object Menu Expand & Expand Appearance
• Effects Menu 3D > Revolve
• Tools Shapes, Pen Tool, Star, Flare

9.Funny Hairy Text (Effect)

• Effect Menu Distort and Transaction, Pathfinder
• Object Menu Blend Options

10.Portrait (Vector Art)

• Tools Pen tool, Pencil Tool
• Object Menu Live Trace
• Effects Menu Illustrator Effects, Convert To Shape, Distort & Transform, Stylize

11.Landscape ( Scenery)

• Effects Menu Photoshop Effects( Noise , Flim Grain ,Grain, etc)
• Tools:- pen tool , Brush Tool
• Object Menu :- Path , Offset Path

12.Mandala Art (Graphics)

• Window Menu Pathfinder, Swatches, Transform, Transparency, Creating Symbols
  Brush Pallete & Creating Brush,

13.Smart Features

• Window Menu  Align, Appearance & Creating Texture Using Appearance, Graphic Style, etc

14.Car Parking ( Smart Features)

• Theory - Revision (Assignment Solve)
• Practical Day - Written Test

1.Learn Web Development 

• HTML Basic Intro and Version
• Elements & Tags , Types of elements(Empty and Container)
• Basic HTML element, Hgroup
• Element(H1 to H6)

2.Styles your webpage

• Using Font Element & Its Attributes
• Styles Element (B,I,U,SUB,SUP,EM,MARK)
• Paragraph Element ,Contents Editable
• Center Element, BR element

3.News Section/Digital Showroom

• Image Element, Image Placeholder, Image Map
• Quotation Element (q , bdo , abbr, address)
• Marquee Element

4.Landing Site/Linking 

• Types of Linking : (Local, Interrnal, External, Download, Mail)
• Anchor Element and its Atributes

5.Count The Points

• Order List , Unorder List, Nested List
• Definition List

6.Result Declaration

• Table Element
  Its Components (TR, TH, TD)
  Its Attributes
• Rows &column Merge, Caption Element

7.Framing

• Frameset Element
  Frameset Rows, Frameset Cols, Frame Src ,
• Iframe Element

8.Video/Audio Gallery

• Use Video Element And Audio Element

9.Enquiry Form/Lead Generation

• Form Element
• Input Element And Its Type
  (Text, Radio, Checkbox, Number, range, Email, Password, Button, Submit, Reset, Image, File, Color, Date, Time, Date time-Local, Search)

10.Banking Form/KYC Form

• Form Element
• Advance Attribute of  Input Element (Autocomplete, Autofocus, Tab index, Required, Size, Step)
• Advance Form Element (Select, Text area, Field set, Legend) 

1.Dynamic Site

• CSS Introduction
• Types Of CSS
  (Inline CSS , Embedded CSS, Link/External CSS)

2.Blocks Creation

• DIV Element, Span Element , Margin, Padding, ID & Class

3.Background Magic

• Background Effects
• Background Properties
• Gradient Background
• Linear, Radial, Angular, Diagonal, Repeating
• Browser Supports Key

4.Customize Text

• Formatting Text Font Properties
• Text Properties Text-Overflow, Word-Break, Word-Wrap, Columns
• Border Effects Style, Width, Color

5.Designer List/Chart Library

• Modified List & Tables
  List Properties, Table Properties
• Shadow Effect Box-shadow, Text-Shadow
• Round Corners
• Div, Button etc 

6.Menu Bars/Google Map

• Creating Menu Bar, Anchor Properties, Transition Effects
• Hover Effect Text, Image

7.Timeline/Animated Webpage

• Animation/Transition
• 2D Animation And 3D Animation

Introduction Of  WordPress

• WordPress intro 
• Xmapp Intro
• Apace , SQL , Localhost 
• PHP,  my admin

Log-in Directory Interface

• Dashboard 
• Front end , Backend Appearance
• Theme , Site Identity

Menu/Page Creation 

• Page (Simple)
• ADD,
• Edit
• Delete
• Menu Location

Plugins

• About Plugins
• Download , Activate
• Elementor 
• (Text, Inner Section, Button Video , Heading ,Image)

Plugins(Form)

• Contact From , Short Code
• WP-from
• Gravity Form
• Formidable From
• Ninja From

Plugins(Gallery)

• Envira Gallery
• Nextgen Gallery
• Photo Gallery By Loweb
• Lightbox 
• Divi Gallery Extended

Widgets & Posts

• Widgets 
• Main, Secondary Post
• Add , Delete , Edit 
• Category
• Tags

Roles and Capabilities Of User

• Administrator , Super Admin 
• Author , Editor 
• Subscriber 
• Add Plugins 
• Easy Collage Plugins

Comments And Appearanc

• Comment 
• Moderate & Unmoderated 
• Hide Comments Appearance
• Style.CSS , 404 Template 

Website Completion

• Revision

Google Sites 

• Intro Of Google Sheet 
• Creation a Website

Advance In Google Sheet 

• Page Creation

Google Site With Google Other App

• Docs, Sheets , Sliders , Form

1.Lets Upgrade Advance Skills

• Type Of Function 
• Find, Concatenate , Length , Abs ,Round ,Roundup , Rounddown,
• Power ,Exact ,Left, Right, Trim, Find , Substitute , ABS , Text 

2.Audit & Management Of Data

• Trace Precedent , Trace Dependent ,
• Remove Arrow , Error Checking , 
• Text to Column , Flash Fill, 
• Data Validation , Remove Duplicate , 
• Consolidate

3.Salary Sheet

• Definition
• Salary sheet Calculation
• Pay slip

4.Dashboard

• Pivot Table
• Pivot Chart
• Slicer
• Timeline 
• Value Function
• Convert Function 

5.Loan Installment Sheet 

• Financial Function 
• PMT, NPER, PV , FV, RATE

6.Garbage Clearing

• If function in Loan Sheet 
• Age Calculation

7.Working With Function

• Double Vlookup Function 
• Vlookup With Match
• Vlookup With Hlookup

8.Xfunction

• If with Vlookup & Hlookup 
• IF with Not
• Xlookukp Function
• XOR

9.Special Tools In Excel 

• Name Manager 
• Conditional Formatting 
• Calendar
• Checkbox

10.Attendance Sheet

• If Error Function
• Eomonth Function

11.Trick & Techniques

• Basic Tricks
• Subtotal With Filter

1.Fundamental of Accounting

• What is Accounting
• Process of Accounting
• Event of  Transaction
• Accounting Terminology

2.Accounting Concept

• Rules of Debit Credit
• Accounting Equation 
• Accounting Principles
• Rules and Approach For Accounting
• Traditional approach
• Modern approach

3.Preparation of Ledger Account

• What do you mean by leadger Format  method of posting leader

4.Explanation of Cash Book

• What is cash book
• Types of cashbook
• Single column
• Double column
• Triple column
• Why cash book maintain separately

5.Bank Reconciliation Statement

• Introduction
• Who maintain cash book and pass book
• Why it is necessary
• Causes of BRS

6.Depreciation

• What is Depreciation factor
  causes of depreciation
• Equation of Depreciation
• Method of Dep.
• SLM
• WDV
• Class Assignment

7.Basics of final Account

• Trading A/C
• Profit and loss  A/C
• Balance sheet
• Format of final accounting
• Class assignment

1.Stock/ inventory Keeping Units

• Introduction
• Creation of stock group
• Creation of Unit of Measure
• Creation of Stock Item
• Creation of Godown

2.Recording of Day to Day Transaction –Voucher

• Introduction
• Receipt Voucher
• Contra Voucher
• Payment Voucher
• Purchase Voucher
• Sale Voucher
• Debit Note Voucher
• Credit Note Voucher
• Journal Voucher
• Creation new Voucher Type
• Non Accounting Voucher
• Inventory Voucher
• Assignment

3.Management of Accounts receivable and Payable

• Management of bill wise bill maintenance Credit Limit

4.Fundaments of Inventory Management

• Recording of  Day to Day Transaction –Voucher

5.Godown Management

• Allocation of stock to Particular Godown while defining opening Balance
• Recording of purchase ,sales, and Stock transfer with Godown Details
• Stock category
• Movements of goods in Batch/Lots-Batch wise Detail
• Expired Batch/Transfer
• Batch Reports
• Stock Valuation Method
• Assignments

6.Management of purchase and sales order

• Purchase order processing
• Sales order processing
• Viewing order details
• Pre close order
• Reorder level
• Assignments

1.Banking

• Cheque management
• Cheque Printing
• Multi Cheque Printing
• Cheque Register
• Cancelled Cheque
• Blank Cheque
• Bank Reconciliation 
• Deposit Slip
• Assignment

2.Cost Centre and Profit Centre Allocation

• Create Cost Centre
• Cost center summary
• Create Cost Category
• Cost Category summary
• Cost Centre Class
• Assignments

3.Price level and price list

• Creation of price list
• Using price list
• Revise price list
• Assignments

4.Bills of Material

• Set component (BOM)
• Accounting of manufacturing process
• Transferring of manufactured goods
• Reports
• Cost estimation
• Assignments

5.Job Costing

• Enable job costing
• Creating Required masters
• Creating manufacturing journal voucher
• Job costing reports
• Assignments

6.Job Work

• Enabling job order processing
• Voucher type set up for job Work In
• Voucher type set up for job Work In
• Job order processing
• Voucher type set up for job Work In
• Job order processing
• Creation of inventory
• Record job work out order voucher
• Issued of raw material to job worker
• Receipt of finished goods
• Job work out reports
• Recording job work in order voucher
• Recording material in voucher
• Manufacturing of finished goods
• Dispatching finished goods to manufacturer
• Job work in order reports
• Assignments

7.Interest calculation

• Activating interest calculation brining the calculated interest amount in books of account
• Using advance parameters for interest calculation
• Advance parameter explanation
• Calculation of compound interest in Tally Prime
• Interest calculation reports
• Assignments

Payroll

• Activating payroll
• Employee group master
• Employee masters
• Creation of payroll units
• Attendance production type
• Creation of pay head
• Defining salary details for an employee
• Salary processing
• Payroll reports
• Payroll statuary deduction
• Provident fund
• EDLI
• Employee state insurance
• Professional tax
• National pension scheme
• Define salary details
• Process salary
• Payroll statuary reports
• Gratuity
• Assignments

Tax Collection at Source

• Configuring Tally Prime for TCS
• Create TCS nature of Goods
• Creation of Accounting Masters
• Sales of TCS Goods at Lower Rates
• Sales of TCS Goods at Nil rate
• TCS on transfer to Right to Use
• Payment of TCS
• TCS reports
• Assignments

Goods and Service Tax

• Getting started GST with GST(Goods)
• Introduction
• Enabling GST and Defining Tax details
• Intrastate Supply of Goods
• Intrastate outward supply
• Interstate supply
• Interstate Inward supply
• Interstate outward supply
• Return Of Goods
• Purchase return
• Sales Return
• Supplies Invoice of tax
• Defining GST Rates at Stock Group level
• Defining GST rates at Stock Item Level
• Defining GST rates at transaction Level
• GST Reports
• Input Tax Credit Set off
• GST Tax payment
• Challan reconciliation
• Assignments

GST(part-2)

• Getting started GST with GST(services)
• Introduction
• Enabling GST and Defining Tax details
• Intrastate Supply of service
• Intrastate Outward Supply
• Interstate Supply of Services
• Interstate Outward Supply of goods
• Cancellation of Services
• Cancellation of Outward Supply
• Defining tax Rates at Master and Transaction Level
• Assignment

1.Setting up a Company in BUSY

• Creating a New Company
• Opening a Company
• Editing a Company
• Closing a Company
• Deleting a Company

2.Accounting & Inventory

• Creating Masters
• Accounts
• Account Group
• Item
• Item Group
• Material Centre
• Material Centre Group
• Unit

3.Entering Vouchers

• Sales
• Sales Return
• Purchase
• Purchase Return
• Payment
• Receipt
• Journal
• Contra
• Debit Note
• Credit Note
• Stock Transfer

4.Advance Features

• Budget
• Credit Limit
• cost Centers
• Price Levels
• Point of Sale- POS
• Bills of Material -BOM

5.Taxation In Busy

• Tax Deduction at Source -TDS
• Tax Collection at Source -TCS
• Goods and Service Tax -GST