Syl Pgdca 2023
Syl Pgdca 2023
Syl Pgdca 2023
Syllabus for :
2023-24
ligibility :
2. Each theory paper shall carry 100 marks for the University Annual
examination of 3 hburs.duration.
question has 16 marks will be frame by taking one question from each
unit there will be and internal choice within the unit.
4. Each practical paper shall be of 2 hours duration on one day and carry 200
marks for the practical examination. The Practical Examination will involve 4
exercises, each of 20 marks, practical record of 40 marks and viva-voce
examination of 80 marks.
5. The medium of instruction and examination shall be English only but the
candidate can be written its examination in English and llindi both medium.
6. The minirnum marks for passing each theory paper shall be 360/o and 40% in
all the theory papers. In the practical examination and Project Work shall be
7. In the versity examination at the end of the final examination the candidate
eligible the award PGDCA degree shall be classilied on the basis of marks
in complete Examination as follows
irst division - 60Yo or more marks but fails to satisfi the criterion for
classified distinction as lay in the 7 (a).
division - All other than those included in 7(a) and 7(b) above
marks 48Yo or more but less than 60%o of the aggregate marks.
I the rest will be declared to have passed the examination if the
n a minimum pass marks in each paper as mention in the point 6.
'the
must pass PGDCA course with three of the initial
!"*
to the course.
J w
ANNEXURE. I
SYLLABUS FOR
ADUATE DIPLOMA IN COMPUTER APPLICATIONS
aperl-C mputer'Fundamental
l0 - igital Marketing
(/
W
t
( (
l. TheU Examination of the theory paper will consists of 6 questions on
the
qftflr qqfu
(,1- [Mq
"./-
Paper-I Computer Fundamental
Max Marks : 100 Time:3 Hours
Unit -I
Introduction to Computer - What is a Computer -Uses of Computer - Characteristics
and Limitations of Computers - Units of Computer System - Block Diagram of
computer -Type of computer - Analog, Digital and Hybrid Computer. Classification
of computer workstation, Mainframe,'Super computer, Client-Server computer,
Notebook, Tablet Palmtop computer. Generation of Computer. Programming
language (Machine, Assembly and High Level Language) and Language Translators
(Assembler, Interpreter and Compiler).
Unit - II
Introduction to hardware, Input /Output and Storage Devices - Input Devices -
Keyboard, Mouse, Scanner, Light Pen, Touch Screen, OCR, MICR, BCR
- Out
Devices - Monitors, Printers, and Plotters - Computer's Memory - Internal and
Extemal Memory - Various Storage Devices
Unit - [I
Software - Introduction - Types - System Software - Types, Features and Functions
- Application Software -Representation of Data Digital number System (Binary,
Octal, Decimal and Hexadecimal numbers) - Binary Arithmetic - Boolean Algebra -
Logical Gates (NOT, OR; AND). Type of Computer Code'(BCD, ASCII, EBCDIC,
LrNrcoDE).
Unit - IV
Computer Networks - Terminology - Server - Workstations - Network Hardware -
Hub, Switch, Bridge, Router - Communication - Topologies - Advantages
Channels
of Networks - Types of Networks - LAN, MAN, wAN. Intemet - Advantages and
Disadvantages
Server -
-
Web Browser
www -
-
protocols
ISP -
- FTP, HTTP, PPP, SMTP, TCP/IP, POP
Types of Connections
- Web
@
b,( L@:
Unit -V
- Web site - TypeS of Web sites - E-mail - IRC web surfing,
'eb Browser, Search Engine, Downloads
Audio and Video Conferencing, E-
( and Disadvantages). Type of E-commerce. Security issues in
iL_ D Viruses, Anti-Viruses, Firewall etc. Internet threats to the society,
Laws Legal Issues.
5. : Introduction to Computers
4"1! "
@y
Paper - II Introduction to Operating Systems
Unit-I
Unit - II
Management, process concept, process scheduling, cooperating process
inter-process communication, CPU scheduling criteria, Scheduling
t..
ithms, Mqltiple processor, scheduling Real Time scheduling and algorithm
uation. Process Synchronization and Deadlocks.
Unit - III
ge Management: Memory Management Logical and Physical address, space,
Unit - IV
troduction - Features - File system - FAT, FAT 32, NTFS - Terminology -
ndow, Mouse Pointer, Desktop, Task Bar - Folder, Short Cuts - Working with
indows - Creating folders, Removing.Folders, Renaming Folders, Creating Short
Parts of fiindow - My Computer - My documents - My Network Places -
ternet Explorer - Recycle Bin - Moving Items to Recycle Bin, Emptying Recycle
.n. Control Panel - Adding and Removing Hardware - Adding and Removing
- A{ministrative Tools - Working with DATE & TIME - Changing
ay Settings - Working with Fonts - Network Connections - Adding Printers -
-P- o>l
v' 4
t--
Settings - Creating User IDs - Removing User IDs -
Unit -V
lnux - IIIUUU ion- Features and Advantages - Structure - File System - Shell -
of shells Basic Shell Commands - mkdir, cd, ls, mv, cp, rm, cat, wild card
ra1ralli,Lgl5 - \.It ing files, file name conventions, File Access Permissions - working
ith vi editor - Working witfr SheI Script
Book:
2. Systems - CBH
[il]
{---
Paper.- III Office Management Tools
Max Marks : 100 Time :3 Hours
Unit -I
Introduction - What is an Office, Functi6ns of Office, Structure of an Organization,
Introduction to Office Automation -Need and importance of Office Automation. Role
of computer in Office automation and management Office Automations Hardware and
Software Requirements - MS - office 2010 - Features - Components of MS -
Office.
Unit - II
MS - Word - Introduction, Word Processor basics, Guide lines for typing, Menus in
MS Word, Saving the Document, Opening the Documents, Previewing and Printing
the document, Page Settings, Editing the document, Find, Replace and Goto, Header
and Footer, Foot notes - Inserting Pictures, files - Organization chart - Working with
Clip Arts, Auto shapes - Formatting the document, Bullets and Numbering,
Document alignment - Spelling and Grammatical Check - Thesaurus - Mail Merge,
Macros, Creating tables - Sorting, Converting, Applying Formula.
Unit - III
MS - Power Point Introduction * Features - Creating Presentations - Open the
- Slides - Inserting Slides - Delete slid.es - Normal, Slide Sorter,
presentation, Saving
Slide Show, Grid Guides - Iriserting Pictures, Sounds, Movie - Slide Design, Slide
layout, Adjusting back ground, Using Templates - Slide Show, Action Buttons,
Custom Animation.
Unit - IV
MS - Excel Introduction - Features - Spread Sheet basics - labels, Values and
functions - Saving the Work book, Printing - Set print area - Cell and Cell Address -
Cell Pointer - Mathematical Calculations - Formulas, Formula bar, Automatic
Recalculation - Function - Arithmetic Functions, String Functions, Date and Time
Functions - Financial Functions - - Inserting and deleting
Formatting Spread Sheet
rows, columns - Sorting - Adding a Sheet to the workbook - renaming the sheet -
copying data between sheets - protecting the workbook - deleting sheet from the
work book - Working with Chart,
_ /1
f-r /A
-?--
k? u) 1
'L r'l^t-
-4 \L-
Unit -V
- Access - Features - Database - Under stating RDBMS - Objects
RDBMS _ Queries, Reports - Functions of Database Management systems
Creating a - a Table - Fields, Data types, Field Name
Creating
- Keys - Query - Creating a euery - Types of eueries - using
- build expressions - running the query - working with Forms - Basic
- Navigating the records - Adding New Record - Deleting a
from Form - working with Reports - understanding the sections of
- Basic Controls - Setting Properties previewing the Report.
-
4. R.K. Tr - MS Office
5. M
4/ lc- U-
Paper- IV Window Programming With Visual Basic 6.0
Unit - I
Unit - II
The Language - Declaring the Variables, Types of Variables, Converting the Variable
Types, User - defined Data Types, Special values, Examining the variable Types -
Scope of the Variable - Control Flow Statements - if .. then, if .. then .. else, Select
Case statements - Loop Statements - Do .. Loop, For .. Next, while .. Wend, Nested
Control Structures, Exit Statement - Arrays - Declaring Arrays, specifying the limits,
Multi-dimensional Arrays - Dynamic Arrays - Control Arrays - procedures
Unit - III
working with Forms - 'Start up form, Loading, Showing and hiding Forms,
Controlling one form from within another form - Designing Menus - Programming
Menu Commands - Form events - Building Dynamic Forms at runtime - SDI and
MDI - Multiple document Interface - MDI applications - Basics, Built-in Capabilities
of MDI, Parent and Child Menus, Accessing child Forms, Loading and Unloading
Child forms, Ending and MDI Application,Implementing Scrolling Forms.
Unit - IV
R"
lt 7 a
-/. /---
)
zr7" A
I L"h)
L'I
Unit - V
\#
&-o-
PapeT V : DATABASE MANAGEMENT SYSTEM
Unit - II
Unit - III
& EER mapping, Relational algebra relational calculus, Normalization: First Normal
Form, Functional Dependenciel, Decomposition, BCNF, Third Normal Form, Fourth
Normal form
Unit - IV
SQL: Basic Structure, Features, Set operations, Aggregate functions, Nested Sub
Unit - V
'[',.','
av
al,$'
Book: .
A$ \*'r
Paper - VI OOP's Programming with C++
Marks: 100 Time:3 Hours
Unit- I
object-oriented Pdradigm, Structured versus objeci-oriented Development,
Encapsulation and Data Abstraction, Inheritance, . Delegation-object
composition, Polymorphism, Message Communication, popular oop
Languages, Merits and Demerits of ooPs Methodology, c++ at a Glance,
Introduction, Data Encapsulaticin and Abstraction-Classes, Inheritance-
Derived classes, Polymorphism-operator overloading, Friend Functions,
Polymorphism-virtual Functions, Generic Classes-Class Templates, Exception
Handling, Streams Computation, Introduction of C**,, Character Set, Tokens,
Identifiers, and Keywords, variables, Data Types and Sizes, variable
Definition, Variable Initialization, Characters and Character Strings, Operators
and Expressions,. Qualifiers, Typedef Statement, Promotion and Type
Conversion, Constants, Declaring Symbolic Constants-Literals, Enumerated
Data Types, Macro Functions, Operator Precedence and Associatively,
Unit- II
control Flow Statements , Introduction, If Statement, switch statement, for
Loop, while loop, do-while Loop, break statement, continue statement, goto
statement, wild statements, Arrays and Strings, Introduction, Operations on
Arrays, Modular Programming with Functions, Introduction, Function
Components, Passing Data to Functions, Function Return Data Type, Library
Functions, Parameter Passing, Return by Reference, Default Arguments, Inline
Functions, Function Overloading, Function Templates, Arrays and Functions
C++ 51ask, Scope and Extent of Variables, Storage Classes, Functions with
Variables Number of Arguments, Recursive Functions, Structures and
Unions, Introduction, Structure Declaration, Structure Definition, Accessing
Structure Members, Structure Initialization, Nesting OfStructures, Array Of
Structures, Structures and Functions, Data Type Enhancement, Using typedef,
Static Data and Member Functions, class, objects and Memory Resource,
class Design Steps, object Initialization and cleanup, class Revisited,
Constructors, Parameterized Constructors, Destructor, Constructor
overloading, order of Constructions and Destruction, Constructors with
Default Arguments, Nameless objects, Dynamic Initialization through
Constructors, Constructors with Dynamic operations, copy Constructor,
Constructors for Two-dimensional Arrays, Constant Objects and Constructor,
Static Data Members with Constructors and Destructors, Nested Classes
Unit- IV
,Ls/
Between Basic Data Types, Conversion Between Objects and Basic Types,
4$,
conversion Between objects of Different Classes, Subscript operator
overloading, overloading with Friend Functions, Assignment operator
overloading, Tracing Memory Leaks, Niceties of operator overloading and
conversions, Inheritance, Introduction, class Revisited, Derived class
Declaration, Forms of' Inheritance, Inheritance and Member Accessibility,
Constructors in Derived Classes, Destructors in Derived Classes, Constructors
Invocation and Data Members Initialization, Overloaded Member Functions,
Abstract Classes , Multilevel Inheritance, Multiple Inheritance, Hierarchical
inheritance, Multi-path inheritance and virtual Base classes, Hybrid
Inheritance, object Composition-Delegation, when to use Inheritance?,
Benefits of inheritance, Cost of Inheritance
Unit-V
Virtual Functions, Introduction, Need for virtual Irunctions, pointer to
Derived Class Objects, Definition of Virtual Functions, Array of Pointers to
Base class objects, 'Pure virtual Functions, Abstract classes, virtual
Destructors, How is Dynamic Binding Achieved?, Rules for Virtual Functions,
P o\/
4$
Paper - vII Introduction to Emerging Technorogies
Max Marks : 100
Time:3 Hours
Unit - I
lloud Computing: Introduction
of croud comp,ting: Croud computing,
Enabling
sti cs and componenrsof cl oud c omputing Advantage
:Tl:::
nd ^:l.l::,.naracteri
challenges of cloud computing and
rr 1618tr
Unit-II
ficial Interligence Introduction concept
of AI, history. current status, scope,
ts, Type of AI, uses of AI in
daily life, future of AI, environments,
introduction
Machine learning and Deep learning.
Unit III
rduction to IoT Architecturar overview, Design principres and
needed
bilities, IoT Apprications, Sensing,
smart City, Elements of IoT Hardware
ponents- computing (Arduino,
Raspberry pi), communication,
Sensing,
ation, rlo interfaces. Industrial
automation, Transportation,
Agricurture,
hcare, Home Automation
Unit IV
ion: Overview of Block chain, public
Ledgers, Bitcoin, Smart Contracts,
in a Blockchain, Transactions, Distributed
Consensus, public vs Private
Block
n, Understanding Crypto
uggested
Book
. Cloud Principle and paradigms,
Edited By Raj Kumar
Buyya, Jemes
A , Pub.- Wiley-2016.
Unit - I
Introduction to Intemet: History
-The way internet works- connecting to Internet
-
Uses of Intemet - Internet Service Providers. Internet Access Tools:
Information
Retrieval Tools: FTP, Gopher
- Communication tools: Telnet, Usenet
- Multimedia
Information tools: Home Page
-
Information search tools: Archie veronica
- -
WAIS. world wide web (www): what is www web page-
- web site _ web
browsers - Uniform Resource Locator (uRL)
Search Engines- DNS - - Electronic
mail: Introduction - Advantages of E-mail - Address - E-mail components _ E-mail
functions.
Unit - il
Introduction to web Design: creating and Maintaining web Site; planning,
Navigation and Themes, Site types and architecture element
of a web page publishing
and publicizing site/structuring web site. HTML: Basic
concepts - Structure of
HTML document : HTML elements. Links and Addressing:
Linking Basics, uRL -
HTML and Images: HTML Image Basics.
Unit - III
Frames: overview of Frames, Frame Targeting, Floating
Frames. Form _ Advantages
of Form, Element of form, Imprement of Form Erement in a web page
(creation of
form)
Unit - IV
cascading Style sheets: Understanding Style sheet, cSS Syntax
and Applying style
Sheet to HTML document, Developing Style Sheets: Inline,
Internal and External.
<DIV> tag. Using class and ID, Styling Background,
Styling border, styling .fext,
Styling Fonts, Styling Links, Styling Lists, Styling Tables, Margin
Unit - IV
Java Script : Introduction of scripting Language, Memory concepts, arithmetic
decision making. Java Script control structure, Java script Functions,
events, program
(hf ' 0y
modules in va Script. Function definition duration
of identifiers, scope rures,
Controlling ing Flow, recursion Java Script
Global Functions.
Unit V
ava Script & arrays: introduction,
array declaring and allocating
memory, passing
to rns, multiple subscripted arrays.
The Java Script object Model Java
Langu : object,'Developing Interactive Forms,
Cookies and Java Script
Iing Frames in Java script, client -
Side Java Script custom, Java
pt Object.
uggested Refi
1
J. . Powel HTML & XHTML
A.
P' L5y
va Script. Function definition duration
of icrentifiers, scope rures,
gramming Flow, recursion Java
Script Global Functions.
Unit V
Script & /s: introduction, array declaring and allocating
memory, passing
to multiple subscripted arays. The
Java Script object Moder Java
e object, Deveroping Interactive Forms,
cookies and Java script
lling Frames in Java Script, crient -
Side Java script custom, Java
t
L07
Paper - IX Data Communication and Computer
Networks
Unit --II
Data and Signals &w urErfar..rr-ansmrssron:
Digital Transmission: Data
uata and signars: Anarog and Digitar
and Signals:
Data' Analog and Digital Signals,
Periodic and Non periodic Signals. Transmission
rrl[Parnnenl Data
infpairment. Data rate limits and
and Performance. Transmission modes. Transmission
Media: Guided media (Twisted Pair cable,
coaxial cable
& Fiber-optic cable) and
Unguided media Radio wave, Infrared,
Microwave communication. Satellite.
Geosynchronous Sateilites communication
and opticar fiber communication.
Unit --III
Multiplexing & Switching Digital rransmission: Digital to Digital conversion:-
Line coding(Unipolar, polar & Bipolar), Block
coding, Anarog to Digital conversion:
PCM & DM. Digitar to analog conversion:
ASK, FSK, psK & eAM. Anarog to
Analog conversion: Amplitude Modulation, Frequency
Modulation & phase
Modulation' Multiplexing: FDM, wDM, Synchronous
TDM and statistical rDM.
Unit -IV
Error Detection and correction: switching: circuit switched
networks, message
switching & packet switching. Datagram networks,
virtual circ;uit networks. Error
Detection and correction: Introduction, Block
coding: Hamming Distance & parity
bit, Iinear block codes, cyclic codes: CRC, VRC
& LRC, and Checksum. Data Link
control: Data Link control: Framing. Introduction of Flow
und Error control.
(4^$
LOr
Link Protocors: simplest protocor, stop
& wait protocor and
for a Noisy channels.
Unit --V
ted ce Book :
A\1-
v'N
L,
Paper - X Digital Marketing
Unit-I
Digital Marketing Fundamentals Marketing
v/s Sales, Marketing Mix and 4 ps, what
s Digital
iS Disital Marketing,
Markefino raDr\/r
cRM platform,
-l^+r^-- cRM^nr . models, cRM pratform, Marketi
rr r\vlrrt6lng
Automation' Inbound vs outbound
Marketing, content Marketing, Understanding
Traffic, Understanding Leads, Strategic
Frow for Marketing Activities.
Unit-II
website Planning and Structure objective
of website and Flou,, one page website.
Google Analytics, Tracking code, website
Auditing. Search Ilngine optimization:
Basic concepts, how Search Engine works.
Keywords. Keywords, titles, meta tags,
on page optimization techniques, off page optim ization
techniques. sEo Audit &
Future of SEO.
Unit-III
Email Marketing: content writing, contents
writing Techniques and Tools. Email
Machine The strategy. Email Frequency, Triggers
in Emair usilg 4ps, Sequence of
Email Triggers' Email Software and Tools, Importing
Email Lists, planning Email
campaign. Email Templates and Designs, Sending
HTML Email campaigns, web
Forms Lead Importing, Integrating Landing page
Forms campaign Reports and
Insights.
Unit-IV
Google Adwords: Basics, Google Ad rypes, pricing ppc cost Formula, Ad
Models,
Page Runk Billing and Payments, Adwords
User Interface, Keyword planning.
Keywords Control, creating Ad campaigns,
creating Text Ads, crreating Ad Groups,
Bidding Strategy for CpC.
Unit-V
Soclal Media Optimizarion (SMO): Introd uction,
Advanced Facebook Marketing,
w'1d Press Blog Creation, Twitter Marketing, Linkedln. plus /
Marketing. Google
4r)l LOt
arketing.
' social Media Anaryticar Toors, Scheduring posts,
Sociar media
Reply Message' Social media Ad campaigns
& components, youTube
mel Links' channer Keywords, Branding
watermark. Uproading
ideos, F Contents on Channel
uggested Refr
il- v d,.
Paper - XI practical Examination
Marks:
Time : 2 Hours
r Pattel for Practical Examination:
No. of Questi )n marks lbr each Total From
Ouestion Marks
04 25 100 Pape. -
ile Work
iva Voce 50 Marks
50 Marks
L02'
Paper - XII'project Work
a. size A4
b. left 1.5 write top and bottom I inch
c. Time Romance
d. Heading 16 pt
e. Headings l4 pt
f. b Headings 12 bold.
o
b' Metter l2 pt.
h. topics should be number accordingly.
i. gap 6 pt maximum
j. Li Spacing 1.5
<f L02
'op Page
Bvl
I
<Name of Candidatep
I
<Roll No.> I
<Enrollment Number> i
. Session>
<Session :
cond Page
Certificates
Th is is to be cer ified that the project report
entitled .... being submitted
by Mr/Mrs. in I rartial fulfillment for the award of the degree post
of Graduate
Di; rloma in Con Lputer Application
to the Jagadguru Ramanand acharya Rajasthan
Sar rskrit Univers ty, Jaipur
-
is a record of bonafide work carried out the
himself
lhe "self under my guideline and supervision
Tht result embor lied in this project report have not been subrnitted to any other
uni ,ersity or instii ute for the award of any
Degree or Diploma.
n,
(
k- oz
4
fhird Page
-he
third pag may include the Certificate
given by the Original and
company where
andidate has cne his/her project.
'ourth Page
Declaration
'his is
to certil ied that the work reported
in the present project entitled <titre
of the
I roject work> i ; a record of work done by me in the <Department
Name> <Name of
( ollege/Organi:
'ation>' The report are based on the project
work done entirely uy u,
a td not copied iom the
other source.
]
I
S gnature ofcan lidate i
i
ttrame of studer rt> I
C ASS
R, rll number
Se ssion
th Page
S th and Sevenr
hth Page
Introducti<
t
L 5Y
t, a
This must be describe introduction about your
project
survey/Review of the Literature
Define Problem
Define module and their functionalities
a
ofdatabase project
a
this UML diagram must include
the following
a
a diagram
a and collaboration diagram
O Object d
a Use case iagram
a
diagram
a
Result
Conclusi and future enhancements/Recommendations
biography
ku7
(if any)
0(
,{N^l
W.,