PGDCA

OPERATING SYSTEMS

2011-12-01T01:42:00.001-08:00

UNIT 1

DISK OPERATING SYSTEMS (DOS) Introduction

History & versions of DOS basics- Physical structure of disk,

Driver Name

, FAT

file & directory structure and naming rules

booting process

DOS system files

DOS commands: Internal - DIR, MD, CD, RD, COPY, DEL, REN, VOL

MS-DOS, commands were added for the ... Some

Executable V/s Non executable files in DOS

UNIT 2

WINDOWS XP

WINDOWS XP

Hardware requirements of Windows

Hardware requirements of Windows.

Windows concepts

Windows Structure, Desktop, Taskbar, Start Menu, My Pictures ,My Music,,working with recycle bin-restoring a deleted file

emptying the recycle bin. Managing files

1. windows.microsoft.com/.../Working-with-files-and-folders - Cached - Similar

2. www.aiita.org/.../3411-advance-diploma-in-computer-application-programming.html - Cached - Similar

creating new folder ,searching files and folders

creating new folder ,searching files and folders

My computer-exploring hard disk ,coping and moving files and folder from one drive to another, formatting floppy drive

Windows Accessories - Calculator, Notepad, Paint, WordPad,Character map,paint,command prompt Windows Explorer

exploring hard disk ,coping and moving files and folder from one drive to another, formatting floppy drive. and other Explorer facilities

burning CD Entertainment

CD player, DVD Player, Media Player, Sound

Recorder, Volume Control, movie maker

UNIT 3

ADVANCED FEATURES OF WINDOWS XP.

ADVANCED FEATURES OF WINDOWS XP

Managing Hardware & Software – Installation of Hardware & Software

Managing Hardware & Software – Installation of Hardware & Software,

Using Scanner web camera,

printers sharing of printers System Tools - Backup

Character map, Clipboard Viewer, Disk Defragmenter

Character map, Clipboard Viewer, Disk Defragmenter,

Drive Space, Scandisk,

System Information, System Monitor, Drive converter (FAT 32) ,disk cleanup ,using

Windows update

communication

Dial up Networking

Direct Cable Connection

Hyper Terminal

Phone Dial

Browsing the Web with internet Explorer

communication through outlook express Multiple Users Features of Windows. Creating and deleting user,

Accessibility

Features of Windows.-Sharing Information between Programs ,

sharing folders and drives browsing the entire network .

mapping windows shared drives

Using shared printers –

Understanding OLE - Embed/Link

Using Cut and Paste a Embed/Link Using Insert Object Manage Embedded/Linked Object

UNIT 4

LINUX

History & Features of Linux

Linux Structure

File system of Linux

Hardware requirements of Linux

Program & Process

Process creation and process identifiers

Functions of profile and login files in Linux

Linux kernel

UNIT-V •

Multi-user features of Linux

Linux commands - bc, cal, cat, cd, chgrp, chmod, chown, clear, cmp, copy, date, find, ps, kill, ls, mail, mkdir, more, mv, rm, rmdir, tty, wc, who, whois, grep, write, telnet

Linux commands - bc, cal, cat, cd, chgrp, chmod, chown, clear, cmp, copy, date, find, ps, kill, ls, mail, mkdir, more, mv, rm, rmdir, tty, wc, who, whois, grep, write, telnet.

Pipeline concepts

Using floppy and cdrom in linux.

vi editor

SYSTEM ANALYSIS AND DESIGN

2011-11-30T23:25:00.000-08:00

UNIT 1

The System Concept

Characteristics

Elements and Types of a system.

TheSystem Development Life Cycle

Considerations for candidate systems

Prototyping

The Role of System Analyst

UNIT 2

System planning and Initial Investigation Information Gathering informationgathering tools.

Structured Analysis

Structured Analysis

The Tools of Structured Analysis (DFD, DataDictionary, Decision tree and Pseduo CodeDecisionTables), pros and cons ofeach tool.

System performance definition
System performance definition

description of outputse

FeasibilityStudy
FeasibilityStudy

Cost/Benefit Analysis: Data Analysis, Cost/Benefit Analysis
Cost/Benefit Analysis: Data Analysis, Cost/Benefit Analysis

The system proposal.
The system proposal.

UNIT 3

The Process and Stages of System Design :

Design methodologies

developmentactivities.

developmentactivities

Input design, output design, forms design types of forms, basics of form design,

Input design, output design, forms design types of forms, basics of form design,

layout considerations and forms control.

UNIT 4

File structure

file organization

objectives of database

data structure

SystemTesting and Quality Assurance

Why system testing

what do we test for the test plan quality assurance trends in testing role of data processing auditor

Trainingand Documentation

UNIT 5

Implementing and software maintenance

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 NOTE :-

Various real life case studies and examples in every stages of system analysis and design may be taken

PROGRAMMING WITH VISUAL BASIC.NET

2011-11-30T22:34:00.000-08:00

UNIT 1

Introduction to .NET

.NET Framework features & architecture

.NET Framework features & architecture

CLR

CommonType System

MSIL

Assemblies and class libraries.

Introduction to visual studio,

Project basics

types of project in .Net,

IDE of VB.NET- Menu bar

Toolbar

Solution Explorer

Toolbox

Properties Window
Properties Window

Form Designer
Form Designer

Output Window

Object Browser.
Object Browser.

The environment: Editor Tab,
The environment: Editor Tab,

format tab
format tab

general tab
general tab

docking tab.
docking tab.

visual development & event drive
visual development & event drive

Programming -Methods and events.
Programming -Methods and events.

UNIT 2

The VB.NET Language- Variables -Declaring variables

The VB.NET Language- Variables -Declaring variables

Data Type of variables
Data Type of variables

Forcing variables declarations
Forcing variables declarations

Scope & lifetime of a variable
Scope & lifetime of a variable

Constants
Constants

Arrays
Arrays

types of array
types of array
types of array

control array
control array

Collections
Collections

Subroutines
Subroutines

Functions
Functions

Passing variable Number of Argument Optional Argument
Passing variable Number of Argument Optional Argument

Returning value from function.
Returning value from function.

Control flow statements: conditional statement
Control flow statements: conditional statement

loop statement.
loop statement.

Msgbox & Inputbox.
Msgbox & Inputbox.

UNIT 3

Working with Forms : Loading, showing and hiding forms controlling One form within another.
Working with Forms : Loading, showing and hiding forms controlling One form within another.

GUI Programming with Windows Form:

Textbox
Textbox

Label
Label

Button
Button

Listbox
Listbox

Combobox
Combobox

Checkbox
Checkbox

PictureBox
PictureBox

RadioButton
RadioButton

Panel
Panel

scroll bar
scroll bar

Timer
Timer

ListView
ListView

TreeView

Toolbar

StatusBar

Methods and events.
Methods and events.

OpenFileDilog
OpenFileDilog

SaveFileDialog
SaveFileDialog

FontDialog
FontDialog

ColorDialog
ColorDialog

PrintDialog
PrintDialog

Link Label.
Link Label.

Designing menues : ContextMenu, access & shorcut keys.
Designing menues : ContextMenu, access & shorcut keys.

UNIT 4

Object oriented Programming: Classes & objects
Object oriented Programming: Classes & objects

fields Properties
fields Properties

Methods &Events
Methods &Events

Constructor
Constructor

inheritance.
inheritance.

Access Specifiers: Public Private, Projected.
Access Specifiers: Public Private, Projected.

Overloading
Overloading

My Base & My class keywords.

Overview of OLE
Overview of OLE

Accessing theWIN32 API from VB.NET
Accessing theWIN32 API from VB.NET

COM technology

advantages of COM+, COM & .NET
advantages of COM+, COM & .NET

Create User control

register User Control,

access com components in .net application.
access com components in .net application.

UNIT 5

Database programming with ADO.NET

Overview of ADO, from ADO toADO.NET

Accessing Data using Server Explorer.

Creating Connection,Command,

Data Adapter and Data Set with OLEDB andSQLDB.

Display Data on data bound controls, display data on data grid.

PC PACKAGES

2011-11-29T04:52:00.000-08:00

UNIT 1

Office Packages-Office activities and their software requirement

Word Processing

Word Processing

Spreadsheet, presentation graphics,

Database

Introduction and comparison of various office suites like MS office

Lotus Office Star Office,

Open Office

MS Word Basics: Introduction to MS Office

Introduction to MSWord; Features & area of use.

Working with MS Word.

Creating a New Document

Different Page Views and layouts

Applying various Text Enhancements

Working with –Styles

Text Attributes

Paragraph and Page Formatting;

UNIT 2

Advanced Features of MS-Word:

Spell Check,

Thesaurus,

Thesaurus,

Find & Replace;

Headers & Footers ;

Inserting – Page Numbers, Pictures, Files, Auto texts,

Symbols etc.; Working with Columns, Tabs & Indents;

Creation & Working with

Adding References and Graphics;

Mail Merge, Envelops & Mailing Labels.

UNIT 3

MS Excel: Introduction and area of use;

Working with MS Excel.;

concepts of Workbook & Worksheets;

Using Wizards;

Various Data Types;

Using different features with Data, Cell and Texts;

Inserting, Removing & Resizing of Columns &Rows;

Working with Data & Ranges;

Different Views of Worksheets;

Column Freezing,

Labels,

Hiding, Splitting etc.; Using different features with Data and Text;

Use of Formulas,

Calculations & Functions;

Cell Formatting including Borders & Shading;

Working with Different Chart Types;

Printing of Workbook & Worksheets with various options.

UNIT 4

MS PowerPoint:

Introduction & area of use;

Working with MS PowerPoint;

Creating a New Presentation;

Working with Presentation;

Using Wizards; Slides & its different views;

Inserting, Deleting and Copying of Slides;

Working with Notes, Handouts, Columns & Lists;

Adding Graphics, Sounds and Movies to a Slide;

Working with PowerPoint Objects;

Designing & Presentation of a Slide Show;

Printing Presentations, Notes, Handouts with print options.

UNIT 5

Outlook express:

Setup email account with outlook,

Setup email account with outlook,

sending and receivingmail through outlook,

concepts of CC and BCC,
concepts of CC and BCC,

forwarding mail, Draft messages,
forwarding mail, Draft messages,

formatting e-mail message,
formatting e-mail message,

Concept of MIME Protocol,
Concept of MIME Protocol,

attaching files and items into messages,

inserting hyperlink using outlook editor

creating and using send and receive groupemails,

opening received messages,

opening messages with attachment,

replying to mail
replying to mail

forwarding messages

flagging for further action,

setting email options,

managing contacts with outlook,

Setting up multiple email accounts on single machine.

INTERNET & E-COMMERCE

2011-11-29T01:42:00.000-08:00

UNIT 1

Internet – Evolution

Connectivity - Dial-up

Application. E-MAIL – Concepts

Basics of Sending & Receiving,

Data Transmission Protocols,

Client/Server Architecture & its Characteristics,

FTP & its usages.

Telnet Concept,

RemoteLogging, Protocols,

Terminal Emulation,

Massage Board,

Internet chatting

Voice chat, text chat.

UNIT 2

Word wide web (www) – History.

Word wide web (www) – History

www Working

www Working

Web Browsers, Its functions,

Concept of Search Engines

Web publishing – Concepts

Domain name Registration

Space on Host Server for Web site

Issues in Web sitecreations & Maintenance

FTP software for upload web site.

UNIT 3

Html - Concepts of Hypertext

Versions of HTML

Elements of HTML syntax,

Head &Body Sections

Building HTML documents

Inserting texts, Images, Hyperlinks

Inserting texts, Images, Hyperlinks,
Inserting texts, Images, Hyperlinks,

Backgrounds and Color controls
Backgrounds and Color controls

Different HTML tags
Different HTML tags

Table layout and presentation,
Table layout and presentation,.

Use of font size & Attributes,
Use of font size & Attributes,

List types and its tags,
List types and its tags,

Use of Framesand Forms in web pages.
Use of Framesand Forms in web pages.

Introduction to WYSIWYG Design tools for HTML,
Introduction to WYSIWYG Design tools for HTML,

Overview of MS FrontPage,
Overview of MS FrontPage,

Macromedia Dream weaver, and other popularHTML
Macromedia Dream weaver, and other popularHTML

UNIT 4

Javascript Overview

syntax & conventions.

syntax & conventions.

Variables

Expressions

Branching &Looping statements,

Functions

Functions.

Arrays Objects

Events & Document Object

UNIT 5

E - Commerce An introductions,

Concepts

Advantages and disadvantages,

Technology in E- Commerce

Internet & E-business,

Applications,

Applications

Feasibility & various constraints.

E-transition challenges for Indian corporate.

Electronic Payment Systems: Introduction

Types of Electronic Payment Systems

Digital Token-Based Electronic Payment Systems

Smart Cards and Electronic Payment Systems

Credit Card-Based Electronic PaymentSystems

Risk and Electronic Payment Systems.

FOXPRO

2011-11-22T04:08:00.000-08:00

Mathematical Functions

UNIT 1

FOXPRO - THE RDBMS FOR PC

FoxPro – Versions
FoxPro – Versions

, features,
, features,
, features,

requirement of Hardware and Software FoxPro
requirement of Hardware and Software FoxPro
requirement of Hardware and Software FoxPro

Menu System,
Menu System,
Menu System,

Working with FoxPro Creating Database File Some common operations on data- CREATE,
Working with FoxPro Creating Database File Some common operations on data- CREATE,

LIST, APPEND, CLOSE, QUIT
LIST, APPEND, CLOSE, QUIT

FoxPro - Data Types
FoxPro - Data Types
FoxPro - Data Types

VIEWINING AND EDITING DATA
VIEWINING AND EDITING DATA
VIEWINING AND EDITING DATA

MODIFY STRUCTURE, MEMO FIELD AND FILE UTILITIES - File utilities in FoxPro –
MODIFY STRUCTURE, MEMO FIELD AND FILE UTILITIES - File utilities in FoxPro –

DISPLAY DIRECTORY, COPY, DELETE, and RENAME
DISPLAY DIRECTORY, COPY, DELETE, and RENAME
DISPLAY DIRECTORY, COPY, DELETE, and RENAME

UNIT 2

SORTING AND INDEXING OF DATABASE FILES

Sorting & Indexing Concept

Sort Commands - Single & Multiple Key

Advantage & Disadvantages of Sort

Indexing Vs Sorting

, Single & Multiple Key Indexing

, FIND, SEEK,

Rushmore Technology

PRINTING REPORTS AND LABELS FoxPro Report - its creation,

PRINTING REPORTS AND LABELS FoxPro Report - its creation

PRINTING REPORTS AND LABELS FoxPro Report - its creation,

features & Utilities

Preview, Printing

, Preview, Printing

Custom Report,

grouping & Subgrouping.

FoxPro Label - Designing & Printing

UNIT 3

Memory Variables - Creation and Uses
Memory Variables - Creation and Uses,
Memory Variables - Creation and Uses

Simple Vs Array
Simple Vs Array
Simple Vs Array

Saving and Restoring Memory Variables
Saving and Restoring Memory Variables
Saving and Restoring Memory Variables

Time & Date Functions and Commands,
Time & Date Functions and Commands,
Time & Date Functions and Commands,

Date Arithmetic Converting Defining Function Keys
Date Arithmetic Converting Defining Function Keys
Date Arithmetic Converting Defining Function Keys

Keyboard Macros - Creating and Using
Keyboard Macros - Creating and Using
Keyboard Macros - Creating and Using

MATHEMATICAL COMMANDS AND FUNCTIONS

Arithmetic Operations

- Mathematical Functions
- Mathematical Functions

Mathematical Commands, , Statistical Functions
Mathematical Commands, , Statistical Functions
Mathematical Commands, , Statistical Functions

UNIT 4

PROGRAMMING WITH FOXPRO

Concepts of FoxPro commands file

Concepts of FoxPro commands file

Modify Commands

Conditioning

, Branching and Looping within Program files

Text - Endtext,

Executing Commands from other command files

, Macro Substitution

ERROR CONDITIONS AND PROGRAM DEBUGGING AIDS

Common Error Massages

Common Error Massages

Debugging techniques and commands

UNIT-V

MULTIPLE DATA FILES

Concept of Multiple Database Files

Concept of Multiple Database Files

Using multiple database files

Relationing the database

SET RELATION, UPDATE, APPEND FROM, COPY TO, JOIN, Relation Query by Example and SQL

CUSTOM SCREENS & USER DEFINE FUNCTIONS & OTHER TOOLS

Create Custom Screen with @, @_GET, @_EDIT, _SAY_GET_READ,

Creating Box & Lines,

User Define Functions

, Custom Screen

Custom Screen

, Custom Screen

Designing and their Use, FoxDoc for documentation

Data Structure with c

2011-11-21T22:28:00.000-08:00

Development of Algorithms: Notations & Analysis

Development of Algorithms: Notations & Analysis

storage structures for arrays
storage structures for arrays

Arrays Pointer

Arrays Pointer

Sparse matrices

Structures & Arrays of structures.

UNIT 2

Linked list

Single linked list

doubly linked list

circular linked list

Application of linked list (Polynomial manipulation)

Stack & Queue

Implementation of stack as an array and linked list

Application of Stack

Prefix, Infix, postfix expressions

expression evaluation.

UNIT 3

Binary Trees

Binary search trees

Tree Traversing

Operations on Binary trees

UNIT 4

Graphs

Graphs Representation

Path matrix-BFS

DFS- Bi-connected

Shortest path problems.

UNIT 5

Sorting

Selection sort

Bubble sort

Insertion sort

Merge sort

Quick sort

Linear Searching,

Binary Searching.

‘C’ Language Fundamentals and computer fundamental

2011-11-19T00:19:00.001-08:00

Introduction to ‘C’ Language
Introduction to ‘C’ Language
Introduction to ‘C’ Language
http://www.coronadoenterprises.com/tutorials/c/c_intro.htmTrackball

Pre Processor

Program Element

Tokan

UNIT 2^ND

Program Development in ‘C’

(1) Program control statement

Sequential Statement

Decision Statement and Looping statement

Array

One Dimensional

Two Dimensional

Multi Dimensional

Array of Character

Sting Manipulation using Library Function

Function

Call by Value

Call by Reference

Recursion

Different Storage Classes

UNIT 3

User Defined Types and Pointer

User Defined Data Types (Structure, Union and Enumeration)

User Defined Data Types (Structure, Union and Enumeration)

Pointers in 'C', Pointer Arithmetic

Structure, Pointer to Function, Pointer to Pointer, Dynamic Memory

Allocation, TypeDef

http://en.wikipedia.org/wiki/C_syntaxs

UNIT 4

Files, Macros and Graphics

Macros, Introduction to File, File I/O, Introduction to Graphics

FUNDAMENTAL OF COMPUTERS AND
INFORMATION TECHNOLOGY

UNIT 1

Brief history of development of computers

Computer system concepts

Computer system characteristics

Capabilities and limitations

Types of computers

Generations of computers

Personal Computer (PCs) – evolution of PCs

configurations of PCs- Pentium and Newer

PCs specifications and main

characteristics. Basic

components of a computer system - Control unit, ALU, Input/Output functions and characteristics

memory - RAM, ROM, EPROM, PROM and other types ofmemory.

UNIT 2

Input/Output & Storage Units-:

Keyboard

Mouse

Trackball

Digital Camera

MICR
MICR

OCR
OCR

OMR
OMR

Bar-code Reader

VoiceRecognition
VoiceRecognition

Light pen
Light pen
Light pen

Touch Screen
Touch Screen
Touch Screen

Monitors -characteristics

types of monitor

Digital Monitor
Digital Monitor

Analog Monitor
Analog Monitor

Size Monitor

Resolution
Resolution

Refresh Rate
Refresh Rate

Interlaced / Non
Interlaced / Non
Interlaced / Non

Dot Pitch,
Dot Pitch,
Dot Pitch,

Video Standard - VGA, SVGA, XGA etc,
Video Standard - VGA, SVGA, XGA etc,
Video Standard - VGA, SVGA, XGA etc,

Printers& types –
Printers& types –
Printers& types –

Storage fundamentals - Primary Vs Secondary Data Storage and
Storage fundamentals - Primary Vs Secondary Data Storage and
Storage fundamentals - Primary Vs Secondary Data Storage and

Various Storage Devices - Magnetic Tape,
Various Storage Devices - Magnetic Tape,
Various Storage Devices - Magnetic Tape,

Magnetic Disks, Cartridge Tape, Hard Disk Drives, Floppy Disks (Winchester Disk),
Magnetic Disks, Cartridge Tape, Hard Disk Drives, Floppy Disks (Winchester Disk),
Magnetic Disks, Cartridge Tape, Hard Disk Drives, Floppy Disks (Winchester Disk),

Blue Ray
Blue Ray
Blue Ray

Disc, SD/MMC Memory cards, Physical structure of floppy & hard disk, drive
Disc, SD/MMC Memory cards, Physical structure of floppy & hard disk, drive
Disc, SD/MMC Memory cards, Physical structure of floppy & hard disk, drive

naming conventions in PC. DVD, DVD-RW.
naming conventions in PC. DVD, DVD-RW.
naming conventions in PC. DVD, DVD-RW.

UNIT 3

Software and its Need
Software and its Need
Software and its Need

Types of Software - System software, Application software
Types of Software - System software, Application software
Types of Software - System software, Application software,

System Software –

Operating System,
Operating System,
Operating System,

Utility Program,
Utility Program,
Utility Program,

Programming languages,
Programming languages,
Programming languages,

Assemblers,
Assemblers
Assemblers

Compilers and Interpreter,
Compilers and Interpreter,
Compilers and Interpreter,

Introduction to operating system for PCs-
Introduction to operating system for PCs-
Introduction to operating system for PCs-

UNIT 4

HUB

Routers

Repeater and Gateways

UNIT -5

Computer Applications in Business-Need and Scope

Computer Applications in Project Management

Computer in Personnel Administration

Information System for Accounting-Cost and Budgetary Control

Marketing and Manufacturing

Computer Applications in Materials Management

Insurance and Stock-broking

Production planning and Control

Purchasing

Banking

Credit and Collection

Warehousing

Use of computers in common public services and e-governance.