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.