Detailed Syllabus- Post Graduatel Diplomain Computer Application

Duration: 576 hrs.

Module-1 Computer Fundamentals &Operating System

Unit -1 Computer Fundamentals
Computer, Advantages and
computer- What is a Computer, Characteristics of a
rowing Computer, Classification
Computer, History of Computer, Generation of
sdavantages of a
of Computers, and Basic Application of Computer.
Arithmetic and logic unit, Control
unit, Storage
Components of computer- Input unit.
/Memory unit, Output unit
Difference between
What is computer memory, Types of memory,
Computer Memory-
Primary memory & Secondary memory
Software, Input devices,
Software- Definition of Hardware and
Concepts of Hardware and Software.
Output devices,System software, Application
Secondary Storage devices,
Difference
System - Concepts of
data and information,
Number
Data Processing and system, Conversion from
information, Introduction to Binary number
between data and
versa.
binary to decimal and vice
programming Language, First
Language- Introduction to program &
History of Computer language),Assembly language,
High level language,
Language(Machine
Programming
translators(Assembler,
Compiler &Interpreter).

Unit-2 Operating System

systens,
and types of operating
to operating system - Operating System
introduction
Functions of Operating
System.
windows
features, Componerts of
windows - Introduction to windows and its folders,
Working with Managing files and
etc.), Operations on windows,
button compression util1ties
(desktop, icons, start Window Accessories,
Personalizing your
window,
Control Panel,
(winrar, winzip).
(Text, Image.
elements of multimedia
What is multimedia,
multimedia- files, plaving audio &
Introduction to
different foimats of image, audio and video
Fonts. Audio and Video), multimedia in varivus
fields,
system, application of
video in computer
Conving files
Pen Drive/CD/DVD, USB ports,
Devices - Usage of
Using External Storage removing a pen drive,
reading/writing/burning

from/to computer, Safely

from/topen drive
a CD/DVD.
 Unit- 3
Installation,
Buying &Installing Handling &
Troubls eshooting
Usability, Laptop or a Computer- Key Things
Built In Desktop, to know Before Buying a Computer( Your Budget,
Graphics, Price, Brand, Operating a

Basic Peripherals),Connecting computer

Troubleshooting-
System, Processor,
with peripherals and
RAM, Hard Drive,
other devices.
devices not Solutions for common computer issues (computer doesn't start,
Handling issuesworking/r
related
ecognize, applications running slowly/hang, Not enough space etc.),
Printer error etc.), to printer (paper
jam, printer isn't
issues related to scanner (paper printing, paper
Handling size mismatch,
using projector. jam, poor image quality etc.),
Module-2 Office Automation
Package
Unit 1- Word
Processing
Introduction &Basics of word processing - Getting
View (Creating, opening and saving document, started, The word interface, Backstage
text, paragraph creation, moving text (Cut, document properties), Entering and editing
Copy & Paste), Holding multiple items in
clipboard, Undo, Redo; Using Shortcuts, Zoom In-Out
Converting to PDF.
Formatting Documents- Setting font styles, size, color, Typeface (Bold,
Italic, Underline), Font
effects, Change case, Highlighting, paragraph indenting,
Bullets &Numberings, Borders &shadings, Header &Footer,
Alignments, Line Spacing, Drop cap,
Footnote &Endnote, Inserting
Page break, Page numbering, Date &Time, Line Break,
Word Wrap, Creating Cover page,
Page Border, Table of Contents, Using Page Themes &Color,
Inserting Watermarks.
Page Layout & Printing- Page Orientation, Setting page margins,
Page size, Columns, Page
Setup &Printing.
Working with Tables- Creating tables, Table Styles, Borders & ShadingS , Cell
Alignment,
Inserting & Deleting rows or columns, Merging, Splitting, Sorting, Using formula. Converting
table into graphs.
Inserting Objects- Inserting ClipArt, Pictures, Textboxes and other files, Formatting &editing
pictures, picture styles, Picture borders, effects &layouts, Positioning, grouping &ordering,
rotating and cropping, Adding and Editing Shapes &SmartArt, Inserting Various types of
charts, Charts layout and formatting.
Features &Tools- Find and Replace, Auto Correct, Bookmarks, Hyperlinks &Cross-Reference.
SpellCheck, Thesaurus, Macros, Mail Merge, Track changes, Document Protection &Security.

Unit 2- Spreadsheet
Introduction and Basics of Spreadsheet - Creating a Spreadsheet,
Spreadsheet, Rows, Columns &Cells, Selecting Range, Cell Addressing,Entering data into
Filling Continuous
rows or columns, Inserting, Deleting or Hiding a Row, Column or Worksheet
Eormulas & Functions- Mathematical Operations (Addition,
Division),. Creating & Copying Formulas and Using Functions, Subtraction, Mu!tiplication.
Cell Referencing (Absolute.
Relative &Mixed), Cube / 3D Formula, HLookup &VLookup.
 Formatting Sppreadsheets-
Background Colors, Text Formatting cells (Setting Fonts, Text Decoration, Setting
Worksheet (Page Alignment, Merge & Wraps, Border & Shading), Formatting
Orientation,
Background, Freeze Panes, Adjusting Margins, Header &Footer, Insert Page break, Set
Advance
Conditional Formatting
Consolidation,Operations-
What-if AnalDataysis. Sorting & Filtering, Creating Data List, Data Validation,

Creating
Pivot tablesCharts and
& Charts.
Graphs- Adding different types of Charts, Charts layout and formatting,
Other Tools
&Printing- Find &
Workbook &Worksheet Replace, Spell Check, Thesaurus, Macros, Track Changes,
Protection, Page Setup &Printing.
Unit 3- Digital
Presentation
Introduction and Basics of Digital
Presentation- Creating, Opening and saving a
Presentation, Save as PDE, Image or Video file,
Themes &Background, Add &Delete Slides, whatSelecting Presentation Layouts, Applying
is a Placeholder, Adding Text to a slide,
PowerPoint Views, Printing handouts and
slides.
Formatting a Presentation- Setting Font size &style,
Insert a Textbox, Adding Header &Footer, Formatting Text Color, Text Alignment,
Using Slide Master.
Inserting Objects &Multimedia- Inserting Tables, Charts,
Shapes and other objects , Adding
Text to Shapes, Group/Ungroup Objects, Creating Photo
Pictures, Clipart, Movies, Setting Animation &Transition
Album, inserting and Formatting
effects, Adding Audio &Video.
Module -3 Internet and its Applications
Unit- 1 Basics of Internet

Concept of internet, Application of internet, Advantages and

disadvantages of internet,
internet protocol, Domain Name System, Internet Connectivity,
WWWN and Web
Navigating through web, Uploading &Downloading, Services on web, Using browsers,
sites.
social media

Unit -2 E-mail

Introduction to E-mail, E-mail addressing, Creating new email

sending email, Replying and forwarding, Sorting and searching account, Composing and
email, Sending email to
multiple users, Sending attachments, Mailbox: inbox and outbox
Unit-3 Using Wireless Networking
Using Bluetooth for connecting devices trom mobile phones
to headphones, and computer
mouse to computers, Connecting to Internet using Mobile Hotspot, WiFi, USB Cable ate
Unit-4 Basic Internet Security Concepts
 Need of
Security over
and privacy internet, security threats, viruses and malwares, e-mail spam,
issues related security
choosing , strong password, to online shopping and social networking sites, safety measures-
Unit - 5 Online Antivirus, Firewalls, safe browsing.
Data storage :
What is cloud and Cloud
cloud storage, benefits of online
storage, Types of cloud
service providers). storage (Public, private, hybridstorage over local storage and portable
and community cloud), cloud storage
Unit-6 Introduction
to
Introduction to e-Governance and Digital Financial Services
e-Governance, Scope of e- Governance, Types of Interactions in e-
Governance, National
Savings and its benefits.e-Governance Programs,
Types of bank account,e-Governance services in !ndia.
from traditional to What is digital financial services,
digital banking, Digital Moving
machines, Digital payment methods. banking products- ATMS, Cards,
knowledge of Safety and Security of Digitalcash deposit
Module - 4 Payments
Using Smartphone
Smartphone &smartphone operating
systems (Google Android, Apple iOS,
Connect your phones to WiFi network.
account, Adding Contacts, what are Using mobile data, Connect yourWindows phone),
gestures, Download Apps, UninstalI/ phone Google
Maps & Navigation, Phone Disable Apps, Using
Backup & Reset. Security over
Number Password, Fingerprint Scanning, smart phones (Pattern Lock,
Face Recognition), App Lock, Secure
Web Browsing
Module- 5 Basics of
Computer Organization
Unit- 1 Information
Representation
Number System & Binary Arithmetic,
representation, conversions, Fixed point & Floating Point
BCD Codes, Error Detecting
and Correcting Codes, ASCII,
EBCDIC & Unicode.
Unit- 2 Binary Logic & Boolean
Algebra
Boolean Algebra, Boolean
forms of Boolean functions,theorems and Functions, Truth Tables, Canonical and
Map) Simplification of Boolean Function (Venn Standard
Diagram & Karnaugh
Unit-3 Digital Logic
Basic Gates (AND, OR,
NOR, AND-OR-INVERTNOT), Universal &other
and OR-AND-INVERTGates (NAND, NOR, XOR, XNOR etc.), NAND.
Implementation of Digital Circuits, Combinational Logic.
implementations of digital circuits.
Unit- 4Combinational Circuits
Half Adder, FullAdder, Half
Demultiplexer,Comparators,Subtractor, FullSubtractor, Encoders,
Code Converters, Decoders,
BCD to Seven-Segment DecoderMultiplexer
Module- 6
Concepts of RDBMS with MS
Unit-1 introduction Access & SQL Server Basics
to RDBMS
RDBMS and
Functions andits characteristics,
Approach,
Limitations of File Based System Database Approach, DBMS
Dependencies and Normalization.Relational Model, Concepts, Codd's Rules, Functional

Unit-2 MS Access
Introduction to MS- Access,
Creating a New Database, Creating and modifying table,
Relationships, Query, Forms and Reports,,Import / Export tables etc.
Unit-3 introduction to
SQL Server
Creating database and tables, Querving and
Derived tables, Introduction to programmingmodifying data, Subqueries &Joins, Views and
Procedures and Triggers. with transact-SQL, Introduction to
Stored
Module-7 Concepts of O0OPs with C++ & Core
Java
Unit 1- Introduction to
Programmin; Techniques
Introduction to program & programming history,
objective of
programming techniques (Unstructured Programming, Proceduralprogram design, various
Program ming, Modular
Programming, Object-oriented Programming), programming languages
assembly language, high level language), translators (machine language,
flcw chart. (compiler & assembler), algorithm and

Unit 2- Introduction to C++ & Data

Structures

Introduction to C++ - Brief history of C++, Characteristics and use of

C++, Comnparison of C
and C++, C++ compiler and installation, Basicsyntax
and program structure of C++, identifiers
and keywords, data types, Variables and ccnstants,
operators, manipulators, variable scope
and storage class.

Control flow statements and loops- Conditional Statements,

Switch Statement, Looping
Statements, break, continue and Goto, Type Casting.
Functions : Function and its types, Declaration, Definition and Calling a
Function,
Arguments, Return Value, Passing Array to Function, Call by Value and Call by Function
Recursion.
Reference.

Arrays and Strings- Declaring and initializing an array,

Entering and
elements, Sorting and Searching array elements, Declaring and initializing accessiag array
two dimensional
arrays, Entering, accessing and other operations on elements in atwo
dimensional array.
Handling Strings in Ctt, string functions.

Pointers- What is pointer, Declaring and Initializing Pointer, Pointers

to pointer, Poin:er to
Array, Passing pointer to function, Pointer Arithmetic.
 PGpCA

Structure What is Structure, Defining and declaring a Structure, Accessing Structure

Elements, Array of Structure, NesteddStructure. Pointers to structure.
Objects and Classes -
the Data 00PS Concepts, Defining class andobject, Class members, Accessing
members, Constructors and types of Constructors, Destructors, This Pointer, Static,
Inline function, Friend
Function
nheritance- What is Inheritance, Base Class and Derived Classes, Access control and
Inheritance, Types of Inheritance, Aggregation.
POlymorphism- What is Polymorphism, Types of Polymorphisn, Function overloading,
Operator overloading, Function Overriding, Virtual
Function.
Abstraction- Abstract Classes, Interface.

Flle Handling -Concept of Files, File opening in various modes, File closing, File pointers and
manipulation, Text File and operations on Text Files, Binary File and operations on Binary
Files.

Data Structures - Introduction to Data Structure, Abstract Data Type,Algorithm Efficiency

and Analysis, Pointers and Dynamic Arrays, Linked List, Stacks & Queues, Recursion ,Trees,
Sorting and searclhing techniques
Unit 3- Core Java

Introduction to Java programming- Introduction to Java, History of Java, Features of Java,

Java Vs. C++, JDK, JRE and JVM, Download and install JDK/JRE (Environment variables set up),
java Variables, Java Data Types, Operatcrs, Conditional statements, looping statements,
Arrays,Strings and Vectors.

0OPS Concepts in Java- Introduction to OPS, OOPS Concepts, Classes, Objects and
Methods, Constructors, static keyword, this keyword, Inheritance and types of Inheritance,
Aggregation, Fina! Classes, Abstract Method and Classes, Packages, Polymorphis, Method
Overlozding Method Overiding, Abstraction, Encapsulation (Package Ascess Modifiers).
Exception Handling in Java- What is Exception Handling, Exceptions &Errors, Typos of Errors,
Syntax of Exception Handling Code, Multiple Catch Statements, Using Finaliy Statement,
Throwing our own Exceptions, Using Exceptions for Debugging.

Multithreading- Introduction to multithreading, Creating Threads, Extending the Thread

Class, Stopping and Blocking aThread, Life Cycle and diferent stages of aThread, Using
Thread Methods, Thread Exceptions, Thread Priority, Synchronization, Implementin: t!a
'Runnable' Interface.

Annlet and Graphical Programming- What are Applets, Difference between Applets ad
Annlications, Building Applet code, Applet Lite Cycle, Creating an ExecuiabBe Applet, Apulet
 Tag, Adding Applet
Input from Users, to HTML File, Running an Applet, Passing Parameters to Applets, Getting
and Polygons. The Graphics SClass, Lines and Rectangles, Circles
and Ellipses,,Drawing Arcs
Daabase
Drivers & connectivity -Introduction to JDBC, Steps to connect to the database,JDBC
Architecture, Types JDBC Drivers, Cónnectivity with Oracle, CoDtectivity with
MySQA, Connection,
Statement and Result set.
Module -8
Data
Communications and |Networking Concepts
Unit-1 Data Communications
What is data
commufication, Compönents of data communication Anzlog and Digítal
SIgnals, Data Transmission mbdes
Iransmission Methods (Parallel (Simplex, Half-Duplex, Ful-Duplex), Digital Data
Transmission, Serial Transmission- Synchronous
Transmission, Asynchronous Transmission),
Comimunication Channels (Wired and Wireless)
Unit- 2 Basic Concents of
Network
What is Network, Evolution of Networking,
Switching), Network Topologies, Types ofSwitching Techniques (Circuit, Message &Packet
Neiworks,
TCP/IP and SLIP /PPP). Networking Protecols (HTTP, ATP
Unit -3 Networking Devices
NIC, Repeater, Modem, Bridge, Hub, Switch,
Router and Gateways.
Unit- 4 Network Reference Model

OSI Reference Model, TCP/IP Reference Model,

Model Comparison of OSI and TCP/AP reference
Module-9 Web Technologies
Unit -1 HTML

Introduction to HTML - VWhat is HTML, HTML Editor, HTML

Elements, Tags and Attributes,
Creating a web Page, Document Structure, HTML, Head, Title and
Body Tags with Attributes,
Saving a HTML page.

Formatting Page - Headings and Paragraph Tags, Line break, Inserting

blank
Formatting tags (<b>, <i>, <u>,<sup> etc.), Adding Horizontal line, Adding space, Pre tag,
Special characters.
Div Tag, Adding Comments.

Creating Lists, Images and Links - Lists and its types, Creating Ordered,
Unordered and
Nested lists, Definition list, Adding Images to webpage, Resizing image,
Alt text, Image Labels.
What are Links, Text Links and Image Links, Inter &Intra Links, Image map.
Adding Tables, Forms and lframes - Using table tag to
insert a table, attributes of tatble tag.
Creating rows and columns, rowspan and colspan, nested table, HTML
Forms, Form eBements.
 Input types,
using an IframeInput
for aattributes,
Link what is anlframe, Inserting lframe, Setting height and width,
Target.
HTML
Audio andMediaVideo
-What is
Multimedia, Multimedia elements, Audio and Video formats, Adding
Files, Attributes of Audio and Video tags.
Unit2
Introduction to CSS
Introduction to Cascading Style
Types of CSs, Creating Sheets (CSS)-What are Cascading Style Sheets, CSS
Syntax,
Inline, Internal and External style sheets, ID and Class.
Working with Text -
Alignment, Text color, Emphasizing Text (Bold and Italics),
Text Wrapping Text Shadow Fonts andDecoration, Indentation, Text
Spacing, Line spacing, Number Font size, Letter and word
and Bullets styles.
Barkgrounds and Borders in CSs- Adding
adding multipie images to background colors, Adding background
Margins ard Paddings, background, Fixed images, CSS background properties, image,
Border, Outlines. Box Model,
Working with Elements in CSS - Display and
classes/Elements. Visibility, Opacity, Positioning, Floating,
Pseudo
Tables and Navigation bars - Borders.
Table Alignment, Table padding, Collapsed Eorders, Table width and Height, Table color,
down list. creatiny simçie navigation bars, navigation
bars with drop
Transfor:ns,Transitions and
What are Transforms, 2D and Animations
3D Transforms, Adding
Transitions and Animations.
Unit -3 JavaScript

Introduction to Java Script

Introduction to Client Side Scripting, introduction
to JavaScript, Application of
External JavaScript, Variables, Data Types, JavaScript,
Operators, Conditional Statements,
Loops, JavaScript Popup Boxes(Alert, Prompt, JavaScript
Confirm).
JavaScript Functions and Events
What are Functions, JavaScript Function
Syntax,
with Return Value, JavaScript Events, Common JavaScript Function Arguments, Function
HTML Events.
JavaScript Objects and Browser Object Model (BOM)
JavaScript Objects, Object Properties and methods,
Math Object, Number Object, Boolean Object, Array Object, String Object, Date Object,
The
Object, History Object, Navigator Object, Location Browser Object Model (BOM), Window
Object, Screen Object, History Location.
Document Object Model and Validations
Introduction to DOM, Document Object,
getElementByld, getElementsByNume,
getElementsByTagName, innerHTML, innerText property, JavaScript Forms and Valida:ions.
Unit - 4 Web Publishing
 Hosting your Site,
developing your Site,Internet Service
Choosing the Provider, Planning and designing your Web Site, Stepsfor
Module- 10 contents, Home Page, Domain Names.
Fundamentals of Software Engineering &Project Management
Anit1 Software
What s Sofware,
Development Life Characteristics,
Cycle, Software
Components and Applications of Software, Software
Process Models(Waterfall, Spiral, and Prototyping),
Concepts of Project Management, Role of Metrics and Measurement.
Unit-2 Software Project Planning
Objectives, Decomposition Technigues: S/w Sizing, Problem Based
Based Esmation, Cost EstimationMödels:cocOMO Estimaion, Process
Model,
Analysis: Principles Of Structured Analvsis, Requirement The S/W Equation, System
Diagram, Data Dictionary. Analysis, DFD, Entity Relationship
Unit- 3 Software Design
Objectives, Principles, Concepts, Design Mythologies: Data Design, Architecture Design,
Procedural Design, Object -Oriented Concepts.
Unit4 esting Fundamentals
Objectives, Principles, Testability, Test Cases: White Box &black box Testing, Testing
Strategies: Verification &Validation, Unit Test, Integration Testing, Validation Testing,
System Testing.
Module - 11 Comiunication &Employability Skills
Unit 1- Basics of Communication Skill
Communication and its importance, Principal of effective communication, Types of
communication, Body language, Listening Skills - Importance of Effective Listening,
Difference between Hearing and Listening, Measures to improve listening.
Unit- 2 Employability Skills

Employment skills- Contents of good Resume, Guidelines for writing Resume, F¡cing
intervievws, Do's & Don'ts for an interview.
Module - 12 Project
Project work based on C++ / Java / Web technologies