Post Graduate Diploma in Computer Application (PGDCA)

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

 

  • 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.

 

Course Duration : 52 Weeks

Eligibility : Graduate or Equivalent