Diploma in Computer Application (DCA)

Duration : 3 Months or 6 Months | Certification : ECIL - ECIT Certification

Course Description

DCA (Diploma in computer applications) which covers all the basic needs of any office or govt.dept for data entry and office assistant jobs. The course content includes MS Word, MS Excel, MS PowerPoint, MS Access, C Programming, and SQL.

Course Includes :

Hands-On Training
Live Projects
100% Placement Assistance

Course Duration :

Regular Course :   6 Months
Fast Track Course :   3 Months

Course Advantages

  • Certificate can be added to your PSC/UPSC profile.
  • Govt. of India ( ECIL-ECIT) approved certificate
  • Online/Offline Facility Available
  • Latest syllabus and advanced lab facility
  • Excellent Placement Support

Course Features

  • A person who has completed DCA can apply as a computer operator in any firm. He or she can get placed at clerical levels like receptionist, computer operator or cyber cafe owner. He can also work at BPO. DCA diploma holder can execute basic computer tasks and can also become an Accountant.
  • Career Scope as Data Entry Operator, Office Assistant, Office Executive, Bank Clerks, BPO/Call Centers, Office Computer Operators.

What you'll cover in this course

Introduction To Computers PC Architecture And OS Concepts

  • IDP Concepts
  • Introduction to Operating Systems
  • MS – DOS Internal Commands
  • MS – DOS External Commands

MS Word

  • Microsoft Office 2002 Premium
  • Start Word 2002
  • Menus
  • Toolbar
  • Working with files
  • Different ways of viewing document
  • Working with text
  • Formatting paragraphs
  • Lists
  • Tables, Graphics
  • Spelling and grammar
  • Page Formatting
  • Mail Merge in XP
  • Keyboard Shortcuts
  • Creating Web Pages

Ms-Excel

  • Introduction
  • Workbook
  • Worksheet
  • Spreadsheet
  • Basics
  • Modifying a worksheet
  • Formatting cells
  • Formulas and Functions
  • Sorting and filling
  • Filtering and database Tables
  • Charts
  • Pivot Table
  • Protection
  • Macros
  • Goal seek
  • Page Properties and Printing

Ms-Power Point

  • Introduction
  • Power point Screen
  • Working with Slides
  • Working with Text
  • Color Schemes
  • Graphics
  • Slide Effects
  • Master Slides
  • Saving and Printing
  • Keyboard shortcuts

MS ACCESS

  • DBMS Concept
  • MS Access (Office Button)
  • Ms Access Home
  • TABLES, Forms
  • Reports, Query
  • External Data
  • Database Tools
  • Datasheet, Relationship

Programming Techniques And Flowcharting

  • Algorithms and its characters
  • Program Flow Charting and Flow Charting Symbols
  • Control Structures
  • Multidimensional Arrays
  • Single and Multilevel Tables

C With Data Structure

  • C Fundamentals
  • Data type and Declarations
  • Operators and Expressions
  • Input Output Operations in ‘C’
  • Control Statements
  • Functions
  • Arrays
  • String Handling
  • Printers
  • Structures
  • Union Pointers and Structures
  • File Management
  • Command Line Arguments

RDBMS, ORACLE,SQL PLUS

  • Introduction to RDBMS
  • Data base Concepts
  • Data Module
  • E-R Diagram
  • Difference between DBMS & RDBMS
  • Normalization
  • Client - Server concept
  • Introduction to Oracle
  • Advantages of Oracle
  • Oracle as on RDBMS
  • SQL
  • SQL Concepts
  • Benefits of SQL
  • DDL
  • DML
  • DCL
  • Constraints Operators
  • Function
  • Group By
  • Having Clause
  • Views and Joins
  • Sub Queries
  • SQL Plus
  • Security
  • SQL
  • Reports

Talk to Our Expert