Welcome to

GEA National College

 

 

  Go Back  

     Post Graduate Diploma in Computer Application (PGDCA)   

None-University Program

                      

              Duration : 1 Yr.                                                                                                                                                                      Eligibility : 10+2 onwards

 

Semester - I

Paper

Subject

Theory Marks

Practical Marks

Paper - I

Computer Organization and Architecture

100

Nil

Paper - II

PC Software

Nil

100

Paper - III

Programming in C++ and Data Structure

70

30

 

Semester - II

Paper

Subject

Theory Marks

Practical Marks

Paper - IV

Basics of Software Engineering

75

25

Paper - V

Database Management System

75

25

Paper - VI

(a) Introduction to Computer Network

(b) Web Technology

50

30

Nil

20

 

 

Detail Syllabi -

 

Paper - I :     Computer Organization and Architecture

Chapter 1:    Introduction to Computer, Types and Application

Chapter 2:    Representation of Information.

Chapter 3:    Basics of Computer Organization

Chapter 4:    The Processing Unit

Chapter 5:    Input - Output Organization

Chapter 6:    Memory Organization

 

 

Paper - II :     PC Software

Introduction to Windows Operating System, Introduction to Windows Programming, Overview of MS Office Packages and their Installation.

 

Chapter 1 :     Microsoft Word

Chapter 2 :     Microsoft Excel

Chapter 3 :     Microsoft PowerPoint

Chapter 4 :     Photoshop

Chapter 5 :     PageMaker

 

Paper - III :    Programming in C++ and Data Structure

Chapter 1 :    Algorithms

Chapter 2 :    Basic concepts of Assembler, Compiler and Interpreters

Chapter 3 :    Fundamentals of C++ Programming

Chapter 4 :    C++ Basics

Chapter 5 :    Programming Conditions

Chapter 6 :    Looping and Iterations

Chapter 7 :    Arrays, Strings and Structures

Chapter 8 :    Functions

Chapter 9 :    Pointers

Chapter 10 :  Dynamic Memory Allocation

Chapter 11 :  The Preprocessor Directives

Chapter 12 :  Objects and Classes

Chapter 13 :  Working with Files

Chapter 14 :  Data Structure

Chapter 15 :  Sorting and Searching

 

 

 

Paper - IV :     Basics of Software Engineering

 

Chapter 1 :    Data Processing Fundamentals

Chapter 2 :    File Structure, Elements of a file

Chapter 3 :    File Processing

Chapter 4 :    Database Concepts

Chapter 5 :    System Concepts

Chapter 6 :    System Analysis

Chapter 7 :    System Design

Chapter 8 :    System Implementation

 

 

 

Paper - V :    Database Management System

 

Chapter 1 :    Introduction to DBMS

Chapter 2 :    Data Association and Relational Data Model

Chapter 3 :    Structural Query Language

Chapter 4 :    Functional Dependency and Normal Form

Chapter 5 :    Database Security and Integrity

 

 

Paper - VI :    (a) Introduction to Computer Network

                        (b) Web Technology

 

(a) Introduction to Computer Network

Chapter 1 :    

Overview : Uses of Computer Networks, Types of Computer Networks, LAN, MAN, WAN etc, Network Topologies, Layered Architecture, Interface and Service, Connection Oriented and Connection Services, The relationship of Services to Protocols, The OSI Reference Model, The TCP/IP Reference Model, Different Interconnection devices: Repeaters, HUBs, Bridges, Switches, Routers and Gateways.

 

Chapter 2 :

Physical Layer : Modulation and Demodulation, Guided and Wireless transmission media, Satellite Communication and their relative merits and demerits.

 

Chapter 3 :

Medium Access Control sub-layer : Ethernet

 

Chapter 4 :

Datalink Layer: Functions of Datalink Layer, Framing, Error Control, Flow Control, Link Management.

 

Chapter 5 :

Network Layer: Functions of Network Layer, Virtual Circuit vs. Datagram Subnet, Establishment of Connection oriented Service, Routing Algorithm, Distance vector routing definition of flow control, Congestion Control, Internet Protocol (IP) Address Structure.

 

Chapter 6 :

Transport Layer: Basic Functionality of Transport Layer, TCP and UDP Protocol.

 

Chapter 7:

Application Layer: Domain Name Service (DNS), Electronic Mail, Mail Transfer Agent and Mail user Agent, FTP, Telnet, www, http, URL, Architecture of world wide web.

 

 

(b) Web Technology

Chapter 1 : Internet Basic

Chapter 2 : Introduction to Client - Server Computing

Chapter 3 : Markup language

                        Scripting language - JAVA Script

                        Extensible Markup language (XML)

Chapter 4 : Web Browser

Chapter 5 : Web Servers

 

 

Practical - 20 Marks

1. Creating web pages using HTML, TAGS, using graphics, multimedia, frames, forms etc in creating interactive web pages, Designing Web sites.

2. Using JAVA script and XML in web pages

3. Introduction to Server Side Scripting using ASP

 


 

Examination and Evaluation System

 

There will be final examination at the end of each semester.

(a) Each paper shall carry 100 marks. The minimum marks required to pass in the Semester examinations shall be 40% in each paper individually and 45% in aggregate in two semesters to be certified.

(b) A failed student is eligible to re-appear in 1 back paper in the final examination provided, the student clears minimum 2 papers securing 40% marks aggregate i.e. total of 80 out of 200

(c) A student who could not appear or failed in the examination will be allowed to clear the same in the subsequent examination.

(d) A student will be allowed to clear a semester examination in maximum of three consecutive chances.

A candidate will be awarded P.G. Diploma in Computer Application (PGDCA) on passing the two semester examinations with 45% in aggregate i.e. 270 marks in aggregate. Final results will be worked out by adding up total marks secured in all the papers. Those candidates who secures 45% or more but less than 60% in aggregate will be declared as having passed the examination in Second class and those securing 60% or above will be declared as having passed in the First Class.

 

 

 

Testimonials Required for Admission

        1. Filled up admission form (available in College Campus)

        2. 4 copies of recent passport size photographs signed by the candidate on back side

        3. Attested copy of the HSLC certificate / admit card or any certificate for verification of the date-of-birth.

        4. Attested copies of degree Mark sheets

       

           

 

Prospectus and Application form can be purchased by paying Rs. 25/- by person or  Rs. 100/- by post in the form of DD in favour of "GEA National College", payable at Guwahati

 

 

 

Special Features of 'GEA National College'

 

1. Well researched free Course material

2. Regular Classes, 6 days in a week

3. Regular Internet Facility

4. Well equipped Library

5. State of the art Infrastructure

6. Placement assistance to all successful students

7. Separate hostel accommodation for boys and girls

8. Visiting Faculties time to time

9. Special personality development and Spoken English workshops for all students

10. Special batches for working professionals

 

*************************

 

  Go Back  

   Tel: 0361 - 2665506 / 0361 - 2664984 / 0 - 9864219852 / 0 - 9435044980 / GUWAHATI, INDIA