Diploma in Computer Application (DCA)

Diploma in Computer Applications is a diploma course to study computer applications in depth. The course imparts scientific, practical and technical knowledge to its learners about various computer tools that are used in day to day life. The applications make tasks easier and provide ease of use. A computer programmer or operator are in high demand in all sectors of the market.

They are used at shops to create a database for all the items with their serial numbers, price and quantity ratios. At schools, computer operators are required to sit behind the desk and manage the computer database for the school, list of all the students, their details, fee payment, enrollment details and all other activities of students are recorded in the computer.

An efficient computer operator is needed to handle such large data. In offices, computer operator takes care of the back door operating and keeps employees information in the computer. The benefits of computer are many and an efficient computer technician is required to facilitate computer tasks. That is why DCA degree was created as it imparts knowledge related to computers in a short period of time. Another advantage is that anybody is eligible to study this diploma course. After completing DCA you can have a number of career prospects and all sectors are open to you. This program imparts specialization in the fields of:

  • Basics Computer Skills

  • MS Office Applications

  • Internet Basics

  • E-Business

  • Software Hacking & IT security

  • PC Assembly and Troubleshooting

  • Software Engineering

SYLLABUS – DIPLOMA IN COMPUTER APPLICATION    (DCA)

Duration – 52 weeks

Week- 1

  • COMPUTER FUNDAMENTALS

    1. Knowing computer

    2. Components of computer

    3. Computer Memory

    4. Concepts of Hardware and Software

    5. Data Processing and Number System

  • WINDOWS

    1. Introduction to operating system and its types

    2. Functions of Operating System

    3. Introduction to multiprocessor & processing modes

    4. Working with windows

    5. Managing files and folders

    6. Control Panel

    7. Personalizing your window

    8. Window Accessories

Practical Assignment  

Week -2 to 5

  • WORD PROCESSING

    1. Introduction to Word processor

    2. Word processing Basics

    3. Text creation and Editing

    4. Formatting text and Paragraph

    5. Inserting graphics

    6. Header and footer

    7. Working with table

    8. Mail merge

    9. Page setup and Print

  • LEARNING TYPING

    1. Introduction

    2. Correct posture while working on computer

    3. Digit Placement and Positioning

    4. Typing with Various keys

    5. Touch typing

    6. Speed typing

Practical Assignment  

Week- 6 to 8

  • SPREAD SHEET

    1. Introduction to spread sheet

    2. Elements of spread sheet

    3. Manipulation of cells

    4. Formula and Functions

    5. Managing Data

    6. Inserting charts and Graphs

    7. Page Setup and Print

Practical Assignment  

Week -9

  • DIGITAL PRESENTATION

    1. Introduction to digital Presentation

    2. Basics of Presentation

    3. Preparation of Slides

    4. Inserting Objects

    5. Templates and color scheme

    6. Presentation of slides

    7. Creating multimedia slides

    8. Printing Handouts

Practical Assignment

Week-10

  • INTERNET AND E-MAIL

    1. Introduction

    2. Basics of Computer network

    3. WWW and Web browsers

    4. Navigating through web

    5. Services on web – E-mail, Chat etc

    6. Security and privacy issues

Practical Assignment

Week-11

  • INTRODUCTION TO E- GOVERNANCE AND DIGITAL FINANCIAL SERVICES

    1. Introduction

    2. Scope of e- governance

    3. Digital Financial services

  • BASIC TROUBLE SHOOTING

    1. Introduction

    2. Checking PC connections

    3. Checking I/O device

    4. Basic network problems

Practical Assignment

Week- 12

TYPING PRACTICE/ REVISION SESSION

Week- 13

  • INTRODUCTION TO PROGRAMMING TECHNIQUES

    1. Introduction to programming history

    2. Objective of program design

    3. Various programming techniques

      • Unstructured Programming

      • Procedural Programming

      • Modular Programming

      • Object-oriented Programming.

 

 

 

Week-14 to 16

  • INTRODUCTION TO DATABASE MANAGEMENT SYSTEM WITH MS-ACCESS.

    1. Introduction to Database and RDBMS

    2. Limitations of manual system

    3. Introduction to MS- Access

    4. Creating a New Database

    5. Creating and modifying table

    6. Relationships

    7. Query

    8. Forms and Reports

    9. Import / Export tables etc.

Practical assignment

Week-17 to 19

  • OVERVIEW OF SQL SERVER

    1. Introduction

    2. Creating database and tables

    3. Data types

    4. Querying and modifying data

    5. Subqueries & Joins

    6. Views and Derived tables

    7. Introduction to programming with transact-SQL

    8. Introduction to Stored Procedures and Triggers

Week-20 & 21

  • HTML

    1. Introduction to HTML elements

    2. HTML tags and Attributes

    3. Creating HTML Page

    4. HTML links, List types

    5. Creating HTML tables

    6. Adding pictures & images

    7. Adding video and Graphics

    8. Page accessibility

    9. Frames and Forms

    10. New elements in HTML

Week- 22 & 23

 

  • INTRODUCTION TO CSS

    1. What is CSS

    2. Types of CSS

    3. Colors and Backgrounds(single and multiple)

    4. Fonts and text

    5. Links

    6. Class and id selectors

    7. Div and span tag

    8. Margins and padding

    9. Borders

    10. Positioning, floats and z-index

    11. 2D and 3D Transforms, transitions and animation

 

 

Week- 24 & 25

 

  • JAVA SCRIPT

    1. Introduction to JavaScript

    2. Basic structure

    3. Control Structure

    4. Arrays and Strings

    5. Functions

    6. Document Object Model

    7. Events and Methods

    8. Validation

 

Practical Assignment

Week- 26

TYPING PRACTICE/ REVISION SESSION

Week-27 ,28

  • INTRODUCTION TO SYSTEM ANALYSIS & DESIGN

    1. Definition, Types & Characteristics of System

    2. Element of System

    3. Advantages of System Analysis

    4. Base for planning for System Analysis

    5. Duties and Job Description of a System Analyst

    6. System Development Life Cycle and its Phases

    7. Tools of Structured Analysis – DFD, Data Dictionary.

 

Week-29 to 34

  • INTRODUCTION TO C

    1. Historical development of C,

    2. The C character Set

    3. Datatypes and Variables

    4. Constants, Literals & Type conversion

    5. C keywords, identifiers &Operators

    6. Decision control structure and Loops

    7. Pointers, Arrays & Strings

    8. Function, passing arguments to Function

    9. Structure and Storage Classes

    10. File Handling.

Week- 35

TYPING/PRACTICE/ REVISION SESSION

Week-36 to 41

  • INTRODUCTION TO C++ WITH OOPS

    1. Introduction to Oops and its characteristics

    2. Program Statements

    3. Variables and constants

    4. Decision control structure and Loops

    5. Functions, passing arguments to function

    6. Arrays & pointers

    7. Strings & structures

    8. Classes & Objects

    9. Constructors and Destructors

    10. Inheritance

    11. Operator overloading & Polymorphism

    12. Virtual, Friend and Static functions

    13. File Handling

Week- 42

TYPING/PRACTICE/ REVISION SESSION

Week-43 to 48

  • VISUAL BASIC 6.0

    1. Introduction to Visual Basic and its environment

    2. Introduction to Visual Basic Controls and their properties

    3. Designing User Interface

    4. Understanding Events and Event Driven Programming

    5. Variables, Constants and Operators

    6. Type conversion, Scope & lifetime of variables

    7. Decisions and Conditions

    8. Looping statements, Arrays & Collections

    9. Sub-Procedures, Sub-Routines & Functions

    10. Working with multiple Forms and Menu Designing

    11. Database

Week- 49

TYPING PRACTICE/ REVISION SESSION

Week- 50

  • COMMUNICATION SKILL

    1. Introduction to communication skill

      • Communication and its importance

      • Principal of effective communications

      • Types of communications and body language

    2. Listening Skills

      • Importance of Effective Listening

      • Difference between Hearing and Listening

      • Measures to improve listening

    3. Reading Skills

      • Importance of reading

      • Types of reading

      • Techniques of reading

    4. Employment skills

      • Contents of good Resume

      • Guidelines for writing Resume

      • Interview Skills

Week- 51 & 52

  • TYPING/ PRACTICE/ REVISION SESSION

*NOTE : Typing practice to be inclusive part throughout  the course.

Course Duration : 52 Weeks

Eligibility : 10+2 or Equivalent