+91 9702570087
Diploma in Computer Application(DCA)
Introduction
DCA, Diploma in Computer Applications, is a one-year diploma course in the field of Computer Applications which involves the study of numerous computer applications such as MS Office, Internet Applications, Operating System, Tally Prime With Gst, Graphic Designing, Web Designing among other subjects.
Pursuing the above courses can help gain more knowledge on the subject and improving your career.
MODULE 1
(OFFICE AUTOMATION)
- Typing speed
- Introduction to computer
- Ms Word
- Ms Excel
- Ms PowerPoint
- Windows
- Internet resources
MODULE 2
(ADVANCED EXCEL)
- Introduction To Excel
- Vlookup
- Hlookup
- If Vlookup
- Vlookup If
- Double Multiple VLOOKUP
- Indirect Function
- Nested If Condition
- If And Or Function
- Sum, Sum If, Sumifs Function
- Count, Count If, Countifs Function
- Date And Time Function
- DatedIF Function
- Financial Function
- Text Function
- Advance Use Of Macros
- MIS Report
- Dashboard Creation
- (Pivot Table Pivot Charts, Slicer, Timeline)
- Advance Data Validation
- Scenario Manager
- Index Match Function
- Choose Function
- Forecast
- Is Function
- DSUM, DMAX, DMIN DAVG
- Master Salary Report And Deduction
MODULES 3
(TALLY PRIME GST)
OPERATING TALLY
- Basic Accounting
- Golden Rules
- Sales / Purchase Voucher
- Receipt / Payment Voucher
- Memorandum Voucher
- Contra Voucher
- Debit Note / Credit Note
- Interest Calculation
ADVANCED TALLY
- Order Processing Tracking Order
- Manufacturing Journal
- Price List
- Logo Printing
- Cost Centre’s Cost Categories
- Multi-Currency
- Allowed Zero Value/Actual Billed Quantity
- Budget Control
- Point Of Sales(POS)
- Payroll
- BRS (Bank Reconciliation Statement)
GOODS SERVICES TAX(GST)
- CGTS, SGST IGST
- TDS (Tax Deducted At Sources)
- TCS (Tax Collected At Sources)
- VAT (Value Added Tax)
MODULES 4
(GRAPHIC DESIGNING)
CORELDRAW
- Introduction To Print Media
- Creating Shapes
- Working On Objects
- Page Layout
- Creating Logos – Poster
- Designing Banner / Artwork
PHOTOSHOP
- Working with Layer Slices
- Selection Tools with Options
- Creating Movie Posters
- Color Correction
- Applying Filter
- Channel Masking
- Text Effects GIF Ads
ILLUSTRATOR
- Understanding Interface
- Working With Vector Graphics
- Drawing With Pen Tool Brush
- Library – Brush, Graphic Style
- Using Symbols Libraries
- Creating A Patterns Design
- Importing / Exporting Files
INDESIGN
- The Work Area
- Setting Up Document
- Tools With Controls
- Text Typography
- Table Of Content Using Styles
- Bullets Library
- Transition Effects
MODULES 5
(WEB DESIGNING)
HTML
- Elements / Attributes
- Font Style
- Link Images
- Table List
- Form & Frames
- Adding Sound Video
WORDPRESS
- Word Press Semantics
- Wrapping Text Around Image
- Comments In Word Press
- Finding Word Press Help
FLASH
- Understanding Tools
- Object & Text Animation
- Time-Line Panel
- Symbols – Instance Library
- Sound & Video
- Creating Animation
WEB HOSTING
- Using An ISP
- Domain / Subdomain Names
- Working With Advance Animation
- Publishing & Exporting
- Hosting Your Site
DREAMWEAVER
- New Site – Location – Storage
- Html Tags – Css Tags
- Working With Frames
- Create Your Own Design Web Page
- Import – Exporting – File Formats
ELIGIBILTY
- HSC+
CAREER OPTIONS
- Receptionist
- Accountant
- Computer Operator
- Graphic Designer
- Web Designer
- Banking
- Insurance
- E-Commerce Marketing