SYLLABUS Advance Diploma in Computer Application (ADCA)
Basic Word 26 Topics
Introduction to Word
Page Setup (Margin, Orientation, Columns, Page size)
Save & open a document
Create new document
Breaks (Page Break & Column Break)
Hyphenation & Line Number
Document Formatting(Change in font, change in font size, highlighting text and change in text color)
Change case
Format Painter
Strikethrough, Double Strikethrough, Small Caps, All Caps
Bold, Italics & Underline
Subscript & Superscript
Indent & Line spacing options
Working with Tables
Bulleted and Numbered List
Change Text Direction
Find and Replace
Spell Check
Working with Text Box
Header and Footer
Draw a Shapes
Working with images in the document
Add a Drop Cap
WordArt and Watermark
Page Border and Page Color
Business Bills, Invoices and Receipts
Essential Word 13 Topics
How to insert symbols
Multi-level List
Step by Step Mail Merge Wizard
Select and Edit Recipients List
Envelopes and Labels
Hyperlink and Bookmark
Insert a SmartArt Graphics and Charts
Selection Pane
Thesaurus, Word Count, Translate and Language
How to create a cover page
Insert date and Time
Take a Screenshot
Arrangement of Objects
Basic Excel 13 Topics
Introduction to Excel
Saving Workbook and Adding / Deleting Renaming Worksheets
Basic calculations : Sum, Product, Factorial, Square Root, Average, Max, Min, Mode & Median
Basic functions like Count, Counta & Count Blank, Upper, Lower, Subtotal
Data Sorting
Format Painter
Text to Column, Text Formatting
Filter, Rand Function
Average and AverageA
Count, Counta and Countblank
How to insert and delete a cell, row and column from a worksheet
Round, Roundup, Rounddown
Date & Time Functions like Date, Day, Month, Year, Today, Hour, Minute, Second
Essential Excel 18 Topics
Charts
Multicategory Chart
Static Transpose
Find Depreciation of an Asset
Logical Functions like IF, IF-Else
Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim
Lookup
Subtotal Function
Rank Function
Rand and Randbetween
Sumproduct
Choose
Format as table
Conditional formatting
Page setup & Print
Freeze Panes
Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,
Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions
Basic PowerPoint 17 Topics
Introduction to PowerPoint
Create a presentation
Slide Setup
Save a presentation
Choose a slide design
Text Formatting in Slides (Change in font, change in font size and change in text color)
Text Alignment in Slides
Background formatting in slides
Working with Text box
Insert Pictures
Draw a shapes
Add Symbols
Working with Tables
Change Text Direction
Insert a Smartart & Chart
Text formatting through WordArt
Different types of Slide Layout
Essential PowerPoint 7 Topics
Create a Photo Album
Insert a Screenshot
Adding Audio and Video to your Presentation
Transitions and Animations
Create custom slideshow of slides
Date and Time & Slide Number
Different views in PowerPoint( Normal, Outline view, Slides Sorter, Notes Pages, Reading View)
Corel Draw 15 Topics
How to Page Setup
Create Basic Shapes
Multi-Page Corel document
Corel Templates
Rulers, Grids and Guidelines
Shortcuts of Basic Commands
Freehand Tool create custom Shapes & Logos
Shape Tool, Connector, Bezier, Pen, Artistic Media, Polyline, Interactive Connector, Dimensions more tools for drawing in Freehand Tool
Blend Options Blend, Contour, Distortion, Drop Shadow, Envelope, Extrude, Transparency
Color Palette, Effects and Gradient
Objects Lock, Unlock, Grouping and Ungrouping
Weld, Trim and Intersect, Place inside Container
Text, Paragraph, Fix text to Path
Images using Powerclip
Bitmaps convert color mode
Adobe Photoshop 22 Topics
Using Layers
Layers Panel in Photoshop
Layer Blending Modes
Lock Layers
Brush & Pencil Tool
Creating and Resizing Artboards
Rectangular & Elliptical Marquee
Lasso Tool make Perfect Selection
Shapes with Pen Tool
Custom Shapes
Image filled Shapes
Quick Selection and Magic Wand
Crop images In Photoshop
Eraser, Background Eraser and Magic Eraser
History panel
Slice tool allows you to divide an image into smaller sections
Blur, smudge and sharpen tool in image
Dodge, Burn & Sponge tool to brighten darken and Increase the color
Clone and Pattern stamp tool
History and Art history brush tool
Add dust & splatters to an image & text for a grunge effect.
ACTIVITIES (change cloth, skin teeth color, website layout, design shapes with pen tool)
HTML 11 Topics
Introduction to HTML 5
HTML Document Structure
Best practices of Saving & Naming HTML Document
Text styling using heading, paragraph & formatting Tags
Insert Images to web page
Insert Audio & Video
Create Ordered, Unordered & Definition List
Create advance HTML Tables
Linking web pages together using Anchor Tag
Adding Forms to web page using difference input types
Using iFrame
CSS 11 Topics
Getting started with CSS
CSS Selectors (Class and ID)
Working with Inline, Internal & External CSS
CSS Box Model
Color & Formatting with CSS
Relative vs. Absolute position
The Box, Boxes in Boxes
Debugging with Chrome Developer Tool
Handling spacing & layouts
Create Navigation with CSS
Formatting Forms, Input
Tally Prime 25 Topics
Getting Familiar with Tally Prime
Fundamentals of Tally Prime
How to create company in Tally Prime
Working with Ledgers and Groups
Recording day to day Entries in Tally Prime
Inventory Management in Tally Prime
Inventory Masters
Inventory Books & Reports
How to create Purchase & Sales Voucher
Order Processing
Reorder Levels
Maintain Bill Wise Details in Tally Prime
Debit & Credit Notes
Delivery, Receipt & Stock Rejection in Tally
Cost Center & Cost Categories
Create Budget in Tally Prime
Payment, Receipt & Contra Voucher
TDS Tax Deducted at source
TCS Tax Collected at source
Setting price list for Wholesalers, Semi-Wholesalers and Retailers
Optional or Quotation vouchers in Tally
POS (Point of Sales) method for multi-mode payments
Payroll management in Tally Prime
BOM (Bills of Material) in Tally Prime
Cost of a particular project in Tally Prime
GST (Goods & Services Tax) 18 Topics
How to create Company & Set Rate in GST
Creating Tax Ledgers
Recording GST Local Purchase
Recording GST Interstate Purchase
Recording GST Local Sales
Recording GST Interstate Sales
Record Payments and Receipts
Recording an Advance Payment to Supplier
Purchase from Unregistered Dealers
Sale of Composite and Mixed supplies under GST
GST Sales Nil Rated, Exempt, SEZ, Deemed Export and Consumer sales
Creating GST invoices for E-commerce operators
Creating GST Export Taxable invoices with currency change
Import of goods & services
Creating E-way Bills
Exporting GSTR-1, GSTR-2, GSTR-3B data to excel
Import data from Tally to Tally
GST Offline Tool
Typing 3 Topics
Why Typing Skills are important
Learn Keyboard letters from A to Z
25 Learning Lessons
Projects 17 Topics
MS WORD- Format documents efficiently in Word using Microsoft Word Styles
MS WORD- Create dynamic layouts using various techniques
MS WORD- Create Mailing labels and Form Letters by Performing Mail Merge
MS EXCEL- Create and manage Spreadsheet Layouts
MS EXCEL- Increase your efficiency by creating and using important Excel shortcuts
MS POWERPOINT- Make great presentations using the Conditional and Table formatting options
COREL DRAW- Create Professional Business Card Designing
COREL DRAW- Create Designer Catalogue
COREL DRAW- Create Logo
COREL DRAW- Create Covers/Packing
CORAL DRAW- Design a Pamphlet & Advertisements
CORAL DRAW- Change the color of T-SHIRT
COREL DRAW- Make a Banner
CORAL DRAW- Design Letter Heads
CORAL DRAW- Design the shapes with the Pen Tool
PHOTOSHOP- Create a creative cinematic effect
PHOTOSHOP- Create a Website Layout
What you'll learn Advance Diploma in Computer Application (ADCA)
- Improve ability and skills by doing work in lesser time
- How to create a mail merge in Microsoft Word
- Using columns, indents, Headers & footers, borders and watermarks
- Format documents effectively using Microsoft Word
- Create Pivot Table and Charts in MS Excel
- Expertise in Lookup and Reference Function
- Animations and Transitions in MS-Power Point
- You will be able to design specific logos with basic shapes
- Distort and apply drop shadow and 3D effects to objects
- You will combine 2 photographs to create amazing compositions
- Accounting with every type of transaction such as payment, receipt, sale, purchase
- Create GST reports,adjust input tax credit and make GST payments
- How to build a custom website with HTML, CSS
- Learn how to create forms and to choose great fonts for your website
Get Free Participation Certificate
Take a demo class & get the FREE Certificate
Upcoming Batches
-
JOIN NOW And Get 61% Scholarship
-
Monday 03-Jun-2024 -
Tuesday 04-Jun-2024 -
Wednesday 05-Jun-2024 -
Friday 07-Jun-2024
About Advance Diploma in Computer Application (ADCA) Course in
In today’s competitive job market, having digital skills is a must. Proficiency in computers is one of the most sought-after skills by hiring managers. Advance Diploma in Computer Application Program offers instruction in the following applications: Essential MS Word, Essential MS Excel, Essential MS PowerPoint, Corel Draw, Photoshop, HTML, CSS, Tally Prime with GST (Goods & Services Tax) and Computer Typing.
ISPL Academy bring you the most comprehensive Diploma Program in Advance Computer Application. Whether you are a professional or a beginner, ADCA (Advance Diploma in Computer Application) course will give you the expertise you need to excel in your career or your day to day digital activities. Our expert trainers and real-life assignments will make sure that you learn accurate, complete and up-to-date skills. This course is especially useful for students who want to start their career but lack the skills required in the job market. This course makes you job-ready. ADCA coure is also useful for Housewives, teachers, professionals who could not get a chance to learn computer earlier and are now feeling themselves left behind because of no computer knowledge and are totally dependent on others for their simple computer tasks. ISPL Academy invites all of you to become computer literate and start afresh.
Exam & Certification Advance Diploma in Computer Application (ADCA)
An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.
Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.
![ISPL Academy Certificate Sample](images/certificate03.jpg)
Advance Courses Alumni
Frequently Asked Questions
What is the duration of the course Advance Diploma in Computer Application?
The duration of the course Advance Diploma in Computer Application is 12 months.
What is the fee of the course Advance Diploma in Computer Application?
The fee of the course Advance Diploma in Computer Application is Rs.23300/-
What topics are covered in the course Advance Diploma in Computer Applications?
This course covers MS Word, MS Excel, Power Point, Corel Draw, Adobe Photoshop, HTML, CSS, Computer Typing, Accounting in Tally and GST (Goods & Services Tax).
What is an Advanced Diploma in Computer Application?
In today’s competitive job market, having digital skills is a must. Proficiency in computers is one of the most sought-after skills. This course is especially useful for students who want to start their career but lack the skills required in the job market.