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