Advance Diploma In Computer Application

Advance Diploma In Computer Application - ADCA

Number of Classes : 140

The level or the year of study for which the class is intended.

Batch Size : 20

Batch size refers to the number of training instances in the batch.

Duration : 18 Months

The predetermined time span provided for completing a course.

Download Course Brochure

Computer Component & Fundamental (Windows)

Application Based Training-ABT	Tools and Application
IT/Digital Era - Entering into Computer World Devices of Computer/ Gadgets of computer 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

Application Based Training-ABT	Tools and Application
Operating System Computer Industry	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

Application Based Training-ABT	Tools and Application
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

Application Based Training-ABT	Tools and Application
Start your Career - CV/Resume Creation	Definition, Feature How to start Ms Word File, font group
Beautifying your CV/Resume (Formatting)	Quick Access Tool Bar Paragraph Group, Clipboard group, Editing group
Letterhead - Show case of Your Company	Insert tab: Header & footer group Date & Time, Symbol Picture Home tab: change Case, Border & Shading
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
Create your Own Book	Refrence tab: Insert endnotes, Insert footnotes, table of content watermark, Hyphenation
Links and Security	Refrence tab: Insert caption, index entry, Links: Booksmarks, Hyperlink, cross Reference Review tab: Track changes, Protect document
Connect your Customer (Bulk Mailing)	Mail Merge main document & Data source
Connect your selected customer(Record filtration)	Sorting of Record Filter of Record Lables Envelope
Mark sheet Creation (Tabular format data )	Insert table, Draw table Layout tab Design tab
Document is ready to print/Record your actions	Page setup Print preview Print Macro

Application Based Training-ABT	Tools and Application
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
Invoice / Bill of Supply	Type of Reference : Absolute, Relative Basic formulas Sum, Product, Minus, Quotient, Mod, Percentage)
Result Declared (Automatic Calculation)	Function
Secure your Data/ Lock your data/ Restrict editing	Styles group : Format as table, Conditional Formatting, Cell styles Protection: Track Changes, Protection
Data Analysing Tool (Expense Limit & Comparision)	What if Analysis: Goal seek, Scenario, Data table
Pictorial Representation of Data (Chart Magic)	Pictorial Represntation of data Chart, type of chart, formatting of charts
Organize your Data (Easier to Analyze)	Data validation, Data filtration, sort, subtotal
Analysing Complex Data (Pivot Table)	Logical function: if and, if or Pivot table, Pivot chart, Paste special
Lookup & Refrence , Extract Your Data	Lookup functions : lookup, vlookup, hlookup match, index
Data is ready to Print /Page Setup	Page setup print preview

Application Based Training-ABT	Tools and Application
Welcome to Presentation World	Powerpoint - Definition feature, purpose ,view of slides Home tab-slide group
Beautifying presetation (Formatting of presentation)	Font & Alignment Group Inset tab - Illustartion group Themes & Background
Masters of Slide/ Slide Automation	Masters Animation(triggers Transition Hyperlink, Actions Slide background
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
Advance feature of Presentation	Running Clock, Moving Car, Making Picture, Bouncing Ball

Application Based Training-ABT	Tools and Application
World of Internet	Internet introduction & Benefit Computer Network: LAN, WAN, MAN Services of internet Search engine, Web browser
Online Communication	Inbox , Reply, Forward, composing, Attachments of file, change password(setting of E-mails) Facebook account handling, facebook page creation
Downloads/Booking	Ticket Reservation & Booking, Online shopping, Online Bill payment, Book movie ticket Download: Image, font style, app, pdf, song, movie,
Digital india	Cash less society E-wallets, UPI, Plastic money, USSD, Net Banking

Application Based Training-ABT	Tools and Application
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
Typography	Tools Gradient, Text Tool & its properties, Type on Path Tool Object Menu Arrange, Group, Ungroup, Lock, Unlock Place Image
Magazine Cover	Tools Text tool, Gradient Tool Layout Menu Ruler Guides, Create Guides, Layout Adjustment Object Menu Effects
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
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
Indexing	Type Menu Character, Paragraph, Table & Object style Layout Menu Table Of Contents
Design & Database Fusion-Merging	Window Menu Data Merge File Menu Export
Mail and Print	Types of Printing File Menu Export, Print

Application Based Training-ABT	Tools and Application
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
Play With Backgrond	Tools Pencil tool , sharpen , smudge , dodge ,burn , sponge , Lasso, Magic Wand, Crop, Slice Layer pallete new, duplicate,delete, Image menu color balance, hue & saturation
Masking (Amazing creatity)	Tools Brush tool Layer Menu Layer Mask, Vector Mask, Clipping Mask Filter Menu Effects
Movie Poster Making	Gradient ,eraser , paint, bucket, eye dropper Layer menu layer style ,merge visible, merge down, flattern
Wedding Album	Tools Pattern Stamp, History Brush, Art History Brush Layer Menu Masking
Logo Creation	Tools Text and its Parts Image Menu modes (RGB, CYMK ,Grayscale) Shape Tools Custom Shape Tool, Other Shapes
Day to Night Conversion , Water Ripple	Tools Pen, Path Selection, Direct Selection Edit Menu Define Brush View Menu Ruler
Retouching Image	Tools Healing Brush, Patch, Clone Stamp, History Brush, Smudge Layer Pallate Blending Modes
Light & Glow	Filter Menu Extract, Liquefier, Distort, Stylize, Artistic Gallery Layer Pallate Blending Modes
Animated Photo & Waterfall	Layer Pallete Adjustment Layer Image Menu Adjustment Window Menu Animation (Frames , Timeline)
Web Layout/Thumbnail	Filter Menu Vanishing Point Edit Menu Free Transform
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
2D Painting	Image Menu Adjustment Options Layer Menu Blending Options
Revision

Application Based Training-ABT	Tools and Application
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
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
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
Floral Vector	Tools Brush, Pencil, Smooth, Path Eraser, Rotate, Reflect Object Menu Blend Option Effects Menu Distort & Transaction Window Menu Align, Gradient, New Brush
Social Media Post	Tools Scale, Shear Text tool, Gradient tool Object Menu Clipping Mask Effects Menu Photoshop Effects
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
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
Beautiful Flower pot With Symbol	Object Menu Expand & Expand Appearance Effects Menu 3D > Revolve Tools Shapes, Pen Tool, Star, Flare
Funny Hairy Text (Effect)	Effect Menu Distort and Transaction, Pathfinder Object Menu Blend Options
Portrait (Vector Art)	Tools Pen tool, Pencil Tool Object Menu Live Trace Effects Menu Illustrator Effects, Convert To Shape, Distort & Transform, Stylize
Landscape ( Scenery)	Effects Menu Photoshop Effects( Noise , Flim Grain ,Grain, etc) Tools:- pen tool , Brush Tool Object Menu :- Path , Offset Path
Mandala Art (Graphics)	Window Menu Pathfinder, Swatches, Transform, Transparency, Creating Symbols Brush Pallete & Creating Brush,
Smart Features	Window Menu Align, Appearance & Creating Texture Using Appearance, Graphic Style, etc
Car Parking ( Smart Features)	Theory - Revision (Assignment Solve) Practical Day - Written Test

Application Based Training-ABT	Tools and Application
Learn Web Development (Interaction with Web World)	HTML Basic Intro and Version Elements & Tags , Types of elements(Empty and Container) Basic HTML element, Hgroup Element(H1 to H6)
Styles your webpage (Edit and Beautifying Your Webpage)	Using Font Element & Its Attributes Styles Element (B,I,U,SUB,SUP,EM,MARK) Paragraph Element ,Contents Editable Center Element, BR element
News Section/Digital Showroom (Make Your Attractive SIte)	Image Element, Image Placeholder, Image Map Quotation Element (q , bdo , abbr, address) Marquee Element
Landing Site/Linking (Click And Connect with Other Site)	Types of Linking : (Local, Interrnal, External, Download, Mail) Anchor Element and its Atributes
Count The Points (Provide product item as List)	Oder List , Unoder List, Nested List Definition List
Result Declaration (Courses Details & Adminssion Schedule)	Table Element Its Components (TR, TH, TD) Its Attributes Rows &column Merge, Caption Element
Framing (Create Layout of Webpage)	Frameset Element Frameset Rows, Frameset Cols, Frame Src , Iframe Element
Video/Audio Gallery (Create Vlog/Blog)	Use Video Element And Audio Element
Enquiry Form/Lead Generation (Create Forms For the Client/Students)	Form Element Input Element And Its Type (Text, Radio, Chechbox, Number, range, Email, Password, Button, Submit, Reset, Image, File, Color, Date, Time, Datetime-Local, Search)
Banking Form/KYC Form (Make Modern Styles of Form )	Form Element Advance Attribute of Input Element (Autocomplete, Autofocus, Tab index, Required, Size, Step) Advance Form Element (Select, Text area, Fieldset , Legend)

Application Based Training-ABT	Tools and Application
Dynamic Site (Know about CSS)	CSS Introduction Types Of CSS (Inline CSS , Embedded CSS, Link/External CSS)
Blocks Creation (Birds Of Same Feather Flock Together)	DIV Element, Span Element , Margin, Padding, ID & Class
Background Magic (Play with Gradient color)	Background Effects Background Properties Gradient Background Linear, Radial, Angular, Diagonal, Repeating Browser Supports Key
Customize Text	Formatting Text Font Properties Text Properties Text-Overflow, Word-Break, Word-Wrap, Columns Border Effects Style, Width, Color
Designer List/Chart Library	Modified List & Tables List Properties, Table Properties Shadow Effect Box-shadow, Text-Shadow Round Corners Div, Button etc
Menu Bars/Google Map	Creating Menu Bar, Anchor Properties, Transition Effects Hover Effect Text, Image
Timeline/Animated Webpage	Animation/Transition 2D Animation And 3D Animation

Application Based Training-ABT	Tools and Application
Introduction	Wordpress intro Xmapp Intro Apace , Sql , Localhost Php my admin
Log-in Directory Interface	Dashboard Front end , Backend Apperence Theme , Sity 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 , ShortCode 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 Apperence	Comment Moderate & Unmoderate Hide Comments Apperence Style.CSS , 404 Template
Website Comletion	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
Website Creation
Revision /Project

Application Based Training-ABT	Tools and Application
Learning With Animation	Intro Of Flash/Animate Timeline Intro Frames : Blank Frame, Duplicate Frame , Blank Keyframe Tools : Selection , Rectangle , Oval , Polygon ,Paint Bucket , Color Fill & Outline
Tweeting In Animation	Tweens : Create a Motion Tween & Shape Tween Layer : Insert , Rename , Delete Guide Layer Tools : Gradient Transforms , Transform, Eraser, Sub- Selection , Brush , Line Color : Linear & Radial Gradient
Rollover Effect	Intro Symbol ( Movie Clip , Button, Graphics) Tools Layer Masking Single & Double Rotate (Auto CW, CCW)
Day to Night Conversion	Window Menu Library Symbol Movie Clip Advance Options Alpha, Filters (Glow, Blur, Bevel, Shadow)
Add action to Your Animation	Action Script ( Action Script 2.0 & Action Script 3.0) Actions Button Create Animation Analog Clock Digital Clock Fan Moving etc
Character Moking & Moving	Using Layer Layer Masking Filters Effect Symbols Tools Add Sound

Application Based Training-ABT	Tools and Application
Fundamental of Accounting	What is Accounting Process of Accounting Event of Transaction
Fundamental of Accounting	Accountng Terminology
Accounting Concept	Rules of Debit Credit Accounting Equation Accounting Principles
Accounting Concept	Rules and Approch For Accounting Traditional approach Modern approach
Journal Entries	Advance Journal Entries with Students Practice Assignments
Preparation of Ladger Account	What do you mean by leadger Format method of posting leader
Explanation of Cash Book	What is cash book Types of cashbook Single column Double column Triple column Why cash book maintain separately
Bank Reconciliation Statement	Introduction Who maintain cash book and pass book Why it is necessary Causes of BRS
Depreciation	What is Depreciation factor causes of depreciation Equation of Depreciation Method of Dep. SLM WDV Class Assignment
Basics of final Account	Trading A/C Profit and loss A/C Balance sheet Format of final accounting Class assignment

Application Based Training-ABT	Tools and Application
Stock/ inventory Keeping Units	Introduction Creation of stock group Creation of Unit of Measure Creation of Stock Item Creation of Godown
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
Management of Accounts receivable and Payable	Management of bill wise bill maintenance Credit Limit
Fundaments of Inventory Management	Recording of Day to Day Transaction –Voucher
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
Management of purchase and sales order	Purchase order processing Sales order processing Viewing order details Pre close order Reorder level Assignments

Application Based Training-ABT	Tools and Application
Banking	Cheque management Cheque Printing Multi Cheque Printing Cheque Register Cancelled Cheque Blank Cheque Bank Reconciliation Deposit Slip Assignment
Cost Centre and Profit Centre Allocation	Create Cost Centre Cost center summary Create Cost Category Cost Category summary Cost Centre Class Assignments
Price level and price list	Creation of price list Using price list Revise price list Assignments
Bills of Material	Set component (BOM) Accounting of manufacturing process Transferring of manufactured goods Reports Cost estimation Assignments
Job Costing	Enable job costing Creating Required masters Creating manufacturing journal voucher Job costing reports Assignments
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
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

Application Based Training-ABT	Tools and Application
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

Busy

Application Based Training-ABT	Tools and Application
Setting up a Company in BUSY	Creating a New Company Opening a Company Editing a Company Closing a Company Deleting a Company
Accounting & Inventory	Creating Masters Accounts Account Group Item Item Group Material Centre Material Centre Group Unit
Entering Vouchers	Sales Sales Return Purchase Purchase Return Payment Receipt Journal Contra Debit Note Credit Note Stock Transfer
Advance Features	Budget Credit Limit cost Centers Price Levels Point of Sale- POS Bills of Material -BOM
Taxation In Busy	Tax Deduction at Source -TDS Tax Collection at Source -TCS Goods and Service Tax -GST

Advance Diploma In Computer Application - ADCA

Empower Your Digital Journey with ADCA at Sardar Patel Academy & Research Centre

At SPARC, we believe in shaping futures through cutting-edge education. Our Advanced Diploma in Computer Applications (ADCA) is a comprehensive program designed to equip you with the skills needed in today's dynamic digital landscape.

What is ADCA?

The ADCA course at SPARC is a unique blend of practical knowledge and industry-relevant skills. Our curriculum is crafted to provide a holistic understanding of key areas in the digital realm.

Course Highlights:

Graphics Designing : Unleash your creativity with hands-on training in graphic design. Learn industry-standard tools and techniques to create visually stunning designs.

Web Designing : Dive into the world of web development. From HTML to CSS and beyond, our course covers the essentials to make you proficient in crafting modern and responsive websites.

Accounting Basics : Gain a solid foundation in accounting principles. Understand financial transactions, manage ledgers, and develop skills crucial for a career in accounting.

Basic Computer Skills : Whether you're a beginner or looking to enhance your computer proficiency, our course covers the fundamental skills needed in today's tech-driven world.

Why Choose ADCA at SAPRC?

Experienced Faculty: Learn from industry experts and experienced instructors dedicated to your success.

Practical Approach: Our courses emphasize hands-on experience, ensuring you are ready to tackle real-world challenges.

Industry-Relevant Curriculum: Stay ahead of the curve with a curriculum designed to meet the demands of the ever-evolving technology landscape.

Placement Assistance: Avail of our placement assistance services and step confidently into the professional world.

Embarking on the journey of an Advanced Diploma in Computer Applications (ADCA) at SPARC opens the door to a spectrum of exciting career opportunities. Upon completion of the program, ADCA graduates can explore a variety of roles in different industries :

1. Graphic Designing:

Graphic Designer
Multimedia Artist
UI/UX Designer
Creative Director

2. Web Designing:

Web Developer
Front-End Developer
E-commerce Specialist
User Interface (UI) Developer

3. Accounting Basics:

Junior Accountant
Bookkeeper
Accounts Assistant
Financial Analyst

4. Basic Computer Skills:

Data Entry Operator
Office Administrator
Customer Service Representative
IT Support Specialist

Contact

Job Oriented Courses