Solapur University was established to cater to the regional needs of Solapur district, simultaneously creating global awareness among its students

As you want I am providing Solapur University PGDCA Syllabus

Fundamentals of Computer & Information Technology
Introduction to A/c Package & MS-Office
System Analysis & Design With C Programming
Web Programming with PHP
i) Lab Course I
No. 1,2 ,3,4based on Paper
ii) Mini Project based on Paper
No. 3 OR 4
਀DBMS & RDBMS Using Oracle
ASP.NET Using C #
Java Programming
Lab Course – II
Based on Paper No. 7, 8 & 9
Major Project
Viva Voce

Solapur University PGDCA Syllabus
PGDCA – Semester I
Topic : 1 (10)
Introduction to Computer and Information Technology :
Characteristics of Computer, Concept of Hardware and Software, Evaluation of
computer and Generations, Classification and types of computer, Block Diagram of
computer system, Motherboard, Number System – Binary, Decimal, Octal and
Hexadecimal.
Topic : 2 (10)
Input and Output Devices :
Input Devices- Keyboard, Mouse, Light pen, Joystick, Scanner, MICR, OMR, Bar
code reader.
Output Devices- Monitor-LCD,LED, Projector, Printer Dot Matrix, Inkjet, Laser,
plotters.
Topic : 3 (10)
Computer Memory:
Memory concept, Semiconductor Memory- RAM, ROM, PROM, EPROM, Secondary
Storage Devices- Magnetic Tape, Magnetic Disk,(Floppy Disk and Hard Disk),Pen
Drive, Optical Memory - CD, DVD
Topic :4 (10)
Introduction to Operating Systems:
,Operating System- Concept, Types, Functions . Introduction to Windows , Linux.
Topic : 5 (10)
Computer Languages:
Machine Level Language, High Level Language and Assembly Language.
Translators- Assembler , Complier, Interpreter.
Topic : 6 (10)
Computer Networks and Security of Data:
Concepts of network, Network Topologies, LAN, MAN, WAN. Introduction to
Internet, E-Mail .Computer Viruses- Characteristics, types, Detection and removing
the viruses , Antivirus Softwares
Topic : 7 (5)
Introduction to Information Technology:
Definition of IT, Information System , IT Applications – IT in Business, IT in
Education etc.
Books :
1) Computer Fundamental ‐ P.K. Sinha
2) Computer Today ‐ Basundara
3) Computer Fundamental ‐ V. Rajaraman
4) Computer Today ‐ Donald N. Sanders.
PAPER NO. : 2
UNIT -1 (10)
Accounting Concepts : Concepts of Accounting, Manual Vs Computerized
Accounting, Golden Rule, Accounting Equation etc.
Introduction to Tally : Introduction, Creation of Company, Introduction to Gateway
of Tally, Menu, Company Info menu.
UNIT – 2 (10)
Accounts Configuration & Classification : Features & Configuration options for
company maintaining accounts, Planning about organization of Chart of Accounts,
Group and Ledgers Account Masters and Vouchers :
Working with Account Masters, viz, Group, Ledger, Cost Centre andCategory,
Currency, Entry of Accounts Vouchers with Examples of Billwise, Interest
Computation, Printing of Vouchers, Creation and Alteration of Vouchers types and
Vouchers Classes. Final Accounts : Viewing Balance Sheet, P& L Account, Trial
balance.
UNIT– 3 (10)
MS Word Basics: Introduction to MS Office; Introduction to MSWord; Features &
area of use. Working with MS Word.; Menus & Commands; Toolbars & Buttons;
Shortcut Menus, Wizards & Templates; Creating a
New Document; Different Page Views and layouts; Applying various Text
Enhancements; Working with –Styles, Text Attributes; Paragraph and Page
Formatting; Text Editing using various features ; Bullets, Numbering, Auto formatting,
Printing & various print options
UNIT – 4 (10)
MS Excel: Introduction and area of use; Working with MS Excel.; concepts of
Workbook & Worksheets; Using Wizards; Various Data Types; 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 –5 (15)
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.
Reference Books:
1. Implementing Tally 6.3 by A.K.Nadhani, K.K.Nadhani, BPB Pub.
2.. Accounting by Tally ( Illustrated) by L.B.Singh & V.P.Singh, Asian Pub.
3. Computerised Financial accounting using tally- Rajan Chougule.
4. Windows XP Complete Reference. BPB Publications
5. MS Office XP complete BPB publication6
6. MS Windows XP Home edition complete, BPB Publications
7. I.T. Tools and Applications, A. Mansoor, Pragya Publications
8. Tally.ERP 9 By Asok K Nadhani BPB Pub.
Solapur University , Solapur
PGDCA- Semester - I
SYSTEM ANALYSIS & DESIGN WITH C Programming
1. SYSTEM ANALYSIS AND DESIGN OVERVIEW - (10)
meaning and definition of system, difference between system and software,
business system concepts, characteristics, elements of system, types of system,
subsystems, system development life cycle, feasibility study-social, technical,
operational and economic feasibility, role of system analysis and users in system
development
2. TECHNIQUES FOR KNOWING USER REQUIREMENT - (10)
observation, document searching, questionnaire, interview ,Charting techniques-
Decision table, decision tree, program Flowchart, system flowchart, table of Content
DFD Levels of DFD for library system ,ERD concept of Enttity,attribute ,
relations,System Design – File , Code ,I/O, etc.
3: PROGRAMMING METHODOLOGY (07)
Algorithm: Definition, properties, developing well-known algorithms. Flowcharts:
Principles of flowcharting, symbols, converting algorithms to flowcharts.
4: GETTING STARTED WITH C (10)
History, Character set, Keywords, Identifiers variables, constants, symbolic
constants. Data types Operators: Arithmetic relational and logical operators,
assignment, precedence and associatively, mixed mode expression conditional
expression. Input, Output Functions.
5 CONTROL STRUCUTURES (08)
If-else, switch, loops - while, for, do-while, Break, continue exit statements, goto, and
labels blocks. ,Functions in C
6 ARRAYS AND POINTERS: (10)
Arrays, single and multidimensional arrays, string operations. Introduction t o
pointers , pass by reference, pointer to pointer Structutres :- passing structure to
function, array of structure
7 FILES: (05)
Text and binary file, FILE structure, file operations
References:
1. Basic system analysis and design- alan denial & donYeats
2. System analysis and design-davis w.s.
3. System analysis and design-edwards p.
4. System analysis and design-award e.h.
5. Let Us C - Y.C.Kanetkar.
6 The C programming Language - Ritchie and Kernighan.
7. C in depth II Edition By S..K Srivastav
Solapur University , Solapur
PGDCA- Semester - I
WEB PROGRAMMING WITH PHP
Unit 1: (10)
PHP/HTML Introduction:
Need of Open Sources – Advantages of Open Sources – Applications –
Commercial aspects of Open Source movement A Brief History of PHP - Installing
PHP - A Walk Through PHP - Installing and Configuring PHP on Windows.
Language Basics:
Lexical Structure -Data Types -Variables -Expressions and Operators – Constants -
Flow-Control Statements -Including Code -Embedding PHP in Web Pages
HTML Basics:
Structure of HTML Document, Types of Html Tags, Basic HTML Tags
Unit 2: Functions: (10)
Calling a Function - Defining a Function - Variable Scope -Function Parameters -
Return Values -Variable Functions - Anonymous Functions.
Strings: Quoting String Constants - Printing Strings - Accessing Individual
Characters -Cleaning Strings - Encoding and Escaping -Comparing Strings -
Manipulating and Searching Strings - Regular Expressions.
Unit 3:Arrays : (10)
Indexed Versus Associative Arrays - Identifying Elements of an Array - Storing Data
in Arrays - Multidimensional Arrays - Extracting Multiple Values - Converting
Between Arrays and Variables - Traversing Arrays - Sorting - Acting on Entire Arrays
Unit 4: Web Server: (05)
Apache Web Server – Working with Web Server – Configuring and using apache
web services.
Open source software tools: Browsers – Processors – Compilers – Model driven
architecture tools.
Unit 5: Databases: (10)
Using PHP to Access a Database - Relational Databases and SQL - Advanced
Database Techniques - Sample Applications.
MySQL: Introduction – What is MySQL? - MySQL Data Types - Primary Keys and
Auto Increment Fields – Queries - Download MySQL Database - Facts About
MySQL database - Connecting to a MySQL Database - writing your own SQL
programs - Closing a Connection.
Unit 6 : PHP MySQL Create Database and Tables: (10)
Create a Database - Create a Table - Insert Data Into a Database Table - Insert Data
From a Form into a Database. Record Selection Technology: Select Data From a
Database Table - Display the Result in an HTML Table - The WHERE clause - The
ORDER BY Keyword – Working with Strings – Date and Time – Working with
metadata.
Unit 7 : Database ODBC: (10)
Create an ODBC Connection – Connecting to an ODBC – Retrieving records –
Retrieving Fields from a Record – Closing an ODBC Connection.
Reference Books :
1. MySQL Bible Steve Suchring John Wiley sons, 2002
2. Programming PHP Rasmus Lerdorf and Levin Tatroe O’Reilly Publications,
2002
3. PHP: The Complete Reference by Steven Holzner ,Tata Mcgraw Hill,2007
4. Beginning PHP and MySql:From Novice To Professional by W.Jason Gilmore,
Apress,2010

Address
Solapur University
Solapur-Pune National Highway
Kegaon
solapur
Maharashtra
Country : India
Contact No : 0217-2351300
Contact Email : info@solapuruniversity.com

more Solapur University PGDCA Syllabus detail attached a pdf file;

Attached Files

Solapur University PGDCA Syllabus.pdf (199.5 KB, 96 views)