PGDCA SYLLABUS-P.G.
DIPLOMA IN COMPUTER APPLICTION ! pgdca course syllabus


PGDCA SYLLABUS
PGDCA SYLLABUS




PAPER-I

FUNDAMENTALS OF COMPUTER
& INFORMATION TECHNOLOGY

UNIT- I

Introduction to Computer
and Information Technology: Brief history of development of 
computer &
generations of computer, Computer system characteristics. Capabilities and 
limitations block diagram
of computer. Types of computer-Analog, Hybrid, digital, micro, 
mini, mainframe, super
computer. Personal computer, types of PCs desktop, laptop, 
notebook, palmtop etc.
Number system Data representation in computers, Number system 
of computers binary,
octal, hexadecimal, representation & their conversion, Coding system 
ASCII, BCD, EDCDIC etc.

UNIT- II

INPUT/OUTPUT devices:
keyboard, mouse, monitor, trackball, joystick, digitizing table,
scanners, digital
cameras, MICR, OCR, OMR, Bar-code reader, Voice recognition, light 
pen, touch screen,
devices, printer, plotter.

UNIT- III

Storage device: Data
storage and retrieval methods-sequential, direct and index 
sequential- various
storage devices-magnetic tape, magnetic disks, cartridge tape, data 
drives hard disk drives,
floppy disks, optical disks-CD, VCD, CDR, CDRW, DVD.

UNIT- IV

Computer software: types
of software, system software, application software, operating 
system, utility program,
assemblers, compilers and interpreter. Operating system functions,

Types batch, single user,
multi user, multiprogramming, multiprocessing, Programming 
languages, machine,
assembly, high level, 4GL, their merits and demerits. Computer virus 
–types of virus, virus
detection & prevention virus on network.

UNIT- V

Data Communication &
networks: analog and digital signals, modulations, amplitude 
modular (am), frequency
modulation (fm), phase modulation (pm), communication process, 
direction of transmission
flow, simplex, half duplex, full duplex. Types of network LAN, 
WAN, MAN etc, Topologies
of LAN ring, bus star, mesh and tree topologies, 
communication protocols
TCP/IP protocol suit. Communication channels media twisted, 
coaxial fiber optic,
serial and parallel communication, Network operating system (NOS), 
bridges, hub, routers,
repeater and gateways. Modem working and characteristics. Types 
of connections- dialup
leased lines, ISDN, broadband.
 

syllabus of pgdca

PAPER-II

PC PACKAGES &
COMPUTERIZED ACCOUNTING SYSTEM

UNIT- I

Fundamental of DOS &
Windows: Fundamental of DOS booting process, internal and 
external commands,
creating and executing batch files and directories creating text files.

Introduction to windows
features, various versions of windows, origin of windows parts of 
windows screen types and
anatomy of windows using.

UNIT- II

Introduction to word
processing (MS-word): Advantages of word processing, editing a file 
using paragraphs,
bullets, indentation, ect. Formatting features, printing the documents, it 
includes paper-size,
margins, header and footer, page no., using macros. Advance word 
processing, header and
footers. Finding text, mail merge and other application, 
mathematical
calculations, table handing.

UNIT- III

Introduction to spread
sheet (MS-Excel): Definition and advantages of electronic 
worksheet, working of
spread sheet, range and related operations. Setting saving and 
retrieving work sheet
file, inserting deleting coping & moving of data cells, inserting and 
deleting rows &
columns, protecting cell printing a worksheet, erasing a worksheet, graphs, 
creation, types of graphs
creating a chart sheet 3D column charts, moving and changing 
the size of chart,
printing the chart.

UNIT- IV

Introduction to
Powerpoint (MS- Powerpoint): Creating a presentation, inserting/ deleting 
slides, different slide
views, editing slides,. Slide transition & editing special effects
inserting 
sound, picture, chart,
organization chart.

UNIT- V

Accounting software Tally
ERP 9: Basic principles of double entry accounting system, 
creating new company
security controls, groups, ledger, voucher type, modifying, new 
company, voucher entry,
generating profit & loss account, trial balance and balance sheet, 
backup & restore. 

syllabus of pgdca




PAPER-III

DATA COMMUNICATION &
COMPUTER NETWORK

UNIT- I

Introduction to Data
Communication– Network models, protocols and architecture,
standards organizations,
line configuration, topology, transmission mode, classification of 
networks, OSI reference
model, TCP/IP model.

UNIT- II

Analog and digital
signals, Data encoding, parallel and serial transmission, modems, 
transmission media:
guided media, unguided media, transmission impairment, 
performance, Synchronous
and asynchronous transmission.

UNIT- III

Multiplexing, LLC, error
detection and correction, flow control, HDLC, LANs- applications, 
architecture, Ethernet,
802.3 LANs, token ring, FDDI, IEEE 802.6, circuit switching, packet 
switching, message
switching, connection oriented and connectionless services.

UNIT- IV

Principles of
internetworking– connection– oriented, connectionless, Routing concepts, 
routing algorithms–
distance-vector routing, link state routing, shortest path routing. 
Congestion control, QOS,
internetworking, network devices.

UNIT- V

Network security
requirements and attacks, public key and private key encryption and 
digital signatures,
digital certificate, firewalls, IDS (Intrusion Detection System)
 

syllabus of pgdca

PAPER-IV

SYSTEM ANALYSIS AND
DESIGN

UNIT- I

The system concept:
characteristics, elements and types of a system, the system

development life cycle,
considerations, for candidate systems prototyping. The role of 
system analyst.

UNIT- II

System planning and
initial investigation: Information Gathering, information gathering 
tools. Structured
analysis, the tools of structured analysis (DFD, Data Dictionary, Decision 
tree and Pseudo codes
Decision Tables), PROS and CONS of each tool, system 
performance definition
description of outputs, feasibility study. Cost/ Benefit analysis, Data 
analysis, Cost/ Benefit
analysis, the system proposal.

UNIT- III

Stages of system design:
Design methodologies, development activities, input design, 
output design forms
design, types of forms, basics of form design layout considerations and 
forms control.

UNIT- IV

File structure: File
organization, objectives of database, data structure, system testing and 
quality assurance, why
system testing, what do we test for, the test plan quality assurance, 
trends in testing, role
of data processing auditor, training and documentation.

UNIT- V

Implementing and software
maintenance: conversion combating resistance to change, post 
implementation review,
software maintenance, hardware/software selection and the 
computer contract,
suppliers, procedure for hardware/software selection, financial 
considerations in
selection, the computer contract system security disaster recovery 
planning. 

syllabus of pgdca

PAPER-V

PROGRAMMING IN C &
C++

UNIT- I

Introduction to “C”
Language: Fundamentals, simple I/O statements, reading and writing,
data types constants,
variable, operators & expressions, library function, control 
statements, if-else,
while, do-while, goto, for statements switch, break, looping statements, 
functions recursion,
arrays, multidimensional arrays, strings & pointers.

UNIT- II

Programming in C++,
functions, class, object, constructor and destructor: Call by reference, 
call by value, return by
reference, inline function, constant argument, function overloading, 
static member function,
static data member,. Classes: implementing class, classes and 
members, accessing class
members, implementing class methods, array of object, friend 
function. Constructor
& destructors: parameterized constructor, multiple constructor, 
constructor with default
argument, copy constructor, destructor.

UNIT- III

Operator overloading
& type casting: Operator overloading, unary operator overloading, 
binary operator
overloading, manipulates string using operator overloading, type 
conversions: basic to
class, class to basic, class to class.

UNIT- IV

Inheritance, virtual
function: single inheritance, multilevel inheritance, multiple inheritance, 
hybrid inheritance,
hierarchical inheritance, virtual base class, abstract class.

UNIT-V

Pointer & File:
Pointer to object, this pointer, virtual function and pure virtual function.
File: 
opening and close file,
detecting end of the file
 

PAPER-VI

RELATIONAL DATABASE
MANAGEMENT SYSTEM (ORACLE)

UNIT- I

Overview of Database
Management: Data, information, data independence, database 
administration roles,
DBMS architecture, different kinds of DBMS users importance of data 
dictionary, contents of
data dictionary, types of database languages. Data models: network, 
hierarchical, relational.
Introduction to distributed database, client/server databases, object
[1]relational
databases, introduction to ODBC concept

UNIT- II

Relational Model: Entity
relationship model as a tool for conceptual design-entities

attributes and
relationships. ER diagrams; concept of keys: candidate key, primary key, 
alternate key, foreign
key; strong and weak entities, case studies of ER modeling 
generalization;
specialization and aggregation, Converting an ER model into relational 
schema. Extended ER
features, introduction to UML, Representation in UML diagram.

UNIT- III

Structured Query Language
(SQL): Relational Algebra: select, project, cross product

different types of joins
(inner join, outer joins, self join); set operations, tuple relational 
calculus, domain
relational calculus, simple and complex queries using relational algebra, 
stand alone and embedded
query languages, introduction to SQL constructs 
(SELECT…FORM, WHERE…
GROUP BY… HAVING … ORDERBY…), INSERT, DELETE, 
UPDATE, VIEW definition
and use, temporary tables, nested queries, and correlated 
nested queries, integrity
constrains: Not null, unique, check, primary key, foreign key, 
reference, triggers.

UNIT- IV

Relational database
design: Normalization concept in logical model; pitfalls in database 
design, update anomalies:
functional dependencies join dependencies, Normal forms (INF, 
2NF, 3NF). Boyce code
normal form, decomposition, multi-valued dependencies, 4NF, 
5NF. Issues in physical
design; concepts of indexes, file organization for relational tables, 
de-normalization,
clustering of tables, clustering indexes.

UNIT- V

Introduction to Query
processing and protection the database: parsing, translation, 
optimization, evaluation
and overview of query processing. Protecting the database 
integrity, security and
recovery, Domain constraints, referential integrity, assertion, triggers, 
security &
authorization in SQL
 




PC Package & Tally
ERP Lab

Note: Practical should be
as per syllabus of theoretical papers.

C, C++ & Oracle Lab

Note: Practical should be
as per syllabus of theoretical papers.

PROJECT

Note:

 01. It is compulsory,
that students would have group of maximum of two students and 
project should be done
under Government sectors/ Public Sector/ Pvt. Limited S/W 
Company/ Software
Technology park of India/ ISO 9001 certified company etc.

02. The students should
not make any project under local or private institutions.

03. The students should
make project themselves and project will not be copy of other 
project.

Steps for Live Project

  • 01. Getting customer’s
    requirements
  • 02. Designs, database and
    business logics.
  • 03. Developing software
    application project.
  • 04. Testing and
    implementing the project.
  • 05. Troubleshooting the
    project application after implementation.
     

The break-up of marks for
Practical will be as under :

Sr. No.

 Argument

Maximum Marks

 Minimum

1.

 Lab Record

 10

 Passing Marks

2.

 Viva/voce

20

3.

 Program Development and Execution

 20

 

Total Marks

 50

 17

The break-up of marks for
Practical will be as under :

Sr. No.

 Argument

 Maximum Marks

 Minimum

1.

 Lab Record

 25

 Passing Marks

2.

 Viva/voce

 25

3.

 Program Development and Execution

 50

 

Total Marks

 100

 40

 
tgas-syllabus syllabus of pgdca !  pgdca course syllabus

By Admin