SYLLABUS – HARTRON’S POST GRADUATION DIPLOMA IN COMPUTER APPLICATION    (HPGDCA)
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 18
·        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 – 19 to 24
·         INTRODUCTION TO C++  & DATA STRUCTURE
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
14.   Introduction to Data Structure
15.   Abstract Data Type
16.   Algorithm Efficiency and Analysis
17.   Pointers and Dynamic Arrays
18.   Linked List, Stacks & Queues
19.   Recursion
20.   Trees
21.   Sorting and searching techniques

Week – 25
TYPING PRACTICE/ REVISION SESSION

Week – 26 to 28

·        FUNDAMENTALS OF COMPUTER NETWORKS
1.       Introduction to Data Communication and its modes
§  Digital & Analog
§  Parallel & Serial
§  synchronous & asynchronous
§  simplex, half duplex, full duplex & multiplexing
2.       Communication Channels
§  Wired transmissions ( Coaxial Cables- base band, broadband, Optical Fiber transmission)
§  Wireless transmission(Microwave, infrared, laser, radio & satellite transmission)
3.       Communication Switching Techniques
§  Circuit, Message & Packet Swiching
4.       Network Reference Models
§  OSI references model
§  TCP/IP reference model
§  comparison of OSI and TCP/ IP reference model
5.       Network Topologies
6.       Data link layer design issue
§  Services provided to the network layer
§  Framing, error control
§  Flow control HDLC, SDLC
§  Data link layer in the internet (SLIP, PPP).
7.       MAC sub layer
§  CSMA/CD, IEEE standards, FDM, TDM, CDMA
8.       The Network Layer (Design Issues)
9.       Routing Algorithms
§  Optimality principled, shortest path routing
§  Concept of Internet Working

Week – 29 to 34
·        WEB TECHNOLOGIES
1.       Introduction to Web Server
2.       Web Client/Browser communication
3.       Introduction to HTML elements
4.       HTML tags and Attributes
5.       Creating HTML Page
6.       HTML links, List types
7.       Creating HTML tables
8.       Adding pictures & images
9.       Adding video and Graphics
10.   Page accessibility
11.   Frames and Forms
12.   New elements in HTML
13.   Introduction to CSS
14.   Types of CSS
15.   Colors and Backgrounds(single and multiple)
16.   Fonts and text
17.   Links
18.   Class and id selectors
19.   Div and span tag
20.   Margins and padding
21.   Borders
22.   Positioning, floats and z-index
23.   2D and 3D Transforms, transitions and animation
24.   Introduction to JavaScript
25.   Basic structure
26.   Control Structure
27.   Arrays and Strings
28.   Functions
29.   Document Object Model
30.   Events and Methods
31.   Validation
32.   Hosting your Site
33.    Internet Service Provider
34.    Planning and designing your Web Site
35.    Steps for developing your Site

Week – 35 to 37
·        CONCEPTS OF  SOFTWARE ENGINEERING & PROJECT MANAGEMENT
1.       Introduction to software engineering
2.       Characteristics , Components and Applications
3.       Software Process Models (Waterfall & Spiral model, Prototyping)
4.       Concepts of Project Management
5.       S/W Project Planning
6.       Decomposition Techniques
7.       Cost Estimation Models (COCOMO Model, The S/W Equation)
8.       Principal of Structured Analysis
9.       DFD, ER-Diagram & Data Dictionary
10.   Concepts of S/W Design and Designing  Methodology 
11.   Testing Fundamentals and Testing Strategies


Week – 38 to 40
·        CONCEPTS OF RDBMS WITH SQL SERVER BASICS
1.       Introduction Database and RDBMS
2.       Limitations of File Based System Database Approach
3.       DBMS Functions and Approach
4.       Relational Model, Concepts & Codd’s  Rules
5.       Functional Dependencies and Normalization
6.       Introduction To SQL server
7.       Creating database and tables
8.       Data types
9.       Querying and modifying data
10.   Subqueries  & Joins
11.   Views and Derived tables
12.   Introduction to programming with transact-SQL
13.   Introduction to Stored Procedures and Triggers

Week – 41 to 43
·        BASICS OF COMPUTER ORGANIZATION
1.       Information Representation
§  Number  System & Binary Arithmetic
§  Fixed point & Floating Point representation
§  BCD Codes
§  Error Detecting and Correcting Codes
§  ASCII, EBCDIC Codes
2.       Unicode Binary Logic
§  Boolean Algebra, theorems and Functions
§  Truth Tables
3.       Simplification of Boolean Function ( Venn Diagram & Karnaugh Map )
4.       Digital Logic
§  Basic Gates (AND, OR, NOT)
§  Universal Gates ( NAND, NOR, XOR, XNOR)
§  Implementation of Digital Circuits
§  Combinational Logic     
5.       Combinational Circuits
§  Half Adder, Full Adder
§  Half Subtractor, Full Subtractor
§  Encoders, Decoders
§  Multiplexer, Demultiplexer



Week – 44 to 49

·        VB. Net
1.       Introduction to .net framework
2.       Features and architecture of Vb.net
3.       Introduction to visual studio.net
4.       .Net IDE interface & 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.    Introduction to object oriented programming( creating Class, Inheritance, Polymorphism, Interface)
12.   Exception handling
13.   Overview of ADO.net
14.   Database Connectivity using SQL Server

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 to 52

TYPING PRACTICE/ REVISION SESSION

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