PGDCA Syllabus (Regular).pdf

Loading...

Post Graduate Diploma in Computer Application (Regular) Name of Program Abbreviation Duration Eligibility Objective of Program

Program Outcome

Medium of Instruction Program Structure

Post Graduate Diploma Computer Application (Regular) PGDCA 1 Year (Regular) – (2 Semesters) Graduate degree in any faculty from a recognized university. PGDCA programme is aimed towards building prospective career in the field of computer application. The programme is designed with the objective to provide knowledge and skills in the various aspects of computer applications and core programming. Students will also be trained in the latest trends of information technology. PGDCA equips the students with skills required for designing, developing applications in Information Technology. Students will able to learn the latest trends in various subjects of computers & information technology. English The Semester wise break up for the courses in 2 semesters is as given below.

Semester 1 Teaching Paper

101

102

Title Fundamentals of Computers and Introduction to Information Technology Database Management Systems

University Exam Duration

Marks

Internal Marks

Total

4

3 Hrs.

70

30

100

0

4

3 Hrs.

70

30

100

Theory (Hrs)

Practical (Hrs)

4

0

4

Credits

103

Fundamentals of C programming

4

0

4

3 Hrs.

70

30

100

104

GUI Programming – 1

4

0

4

3 Hrs.

70

30

100

105

Office Automation Tools

4

0

4

3 Hrs.

70

30

100

106

Practical – I

0

4

4

2 Hrs.

70

30

100

107

Practical – II

0

3

3

2 Hrs.

70

30

100

108

Practical – III

0

3

3

2 Hrs.

70

30

100

20

10

30

560

240

800

Semester 2 Teaching Paper

Title

Theory (Hrs)

Practical (Hrs)

University Exam Credits

Duration

Marks

Internal Marks

Total

201

GUI Programming – II

4

0

4

3 Hrs.

70

30

100

202

Web Designing tools

4

0

4

3 Hrs.

70

30

100

203

Network Essentials and E-Commerce

4

0

4

3 Hrs.

70

30

100

204

Basics of Accounts and Accounting Packages

4

0

4

3 Hrs.

70

30

100

205

Practical – IV

0

4

3

2 Hrs.

70

30

100

206

Practical – V

0

4

3

2 Hrs.

70

30

100

207

Project

0

--

8

--

200

--

200

16

8

30

620

180

800

Program Passing Rules

As per norms of university for PG Courses

Course: 101: Fundamentals of Computers and Introduction to Information Technology Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective

Pre-requisite Course Out come

Course Content

101 Fundamentals of computers and introduction to Information Technology 4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 This course helps students to understand fundamentals of computer. The course also gives students an idea about various components of computer hardware and its working. The course also briefs the concepts of various operating systems. Students will also be able to learn about Internet and popular internet services like e-mail. 1.To make students understand computer hardware fundamentals 2.To make students understand various components of computer and their working 3.To make students understand the importance and use of operating systems. 4.To make students understand about Internet and internet services Nil After studying the course, students will be able to understand how computer works and the importance of various components of computers. This course also makes students to understand about Internet. After successful completion, students will be able to select particular configuration of computer and operating system necessary for the application. UNIT 1: Basic Computer Organization 1.1. Hardware parts of Computer 1.2. Block diagram of Computer 1.3. I/O devices: Keyboards, Monitors, Pointing Devices, Scanners, OMR, OCR, Printers 1.4. Primary Storage: RAM, ROM (and its types), Cache Memory, Virtual Memory 1.5 Ports: Serial, Parallel, PS2, USB 1.6 Basic Troubleshooting UNIT 2: Secondary Storage 2.1 Electro-Magnetic storage devices: FDD, HDD 2.2 Optical storage devices: CD, DVD, Bluray 2.3 Other portable storage devices UNIT 3: Operating System Concepts 3.1 History and Evolution of OS 3.2 Need of OS 3.3 Single-user & Multi-user OS 3.4 Elements and Functions of OS 3.5 File System (e.g. FAT, NTFS etc.) 3.6 Common Files types (e.g. jpg, doc, txt, pdf etc.)

3.7 BIOS, POST Operation UNIT 4: Introduction to GUI OS 4.1 Introduction to Windows and Windows User Interface 4.2 Windows versions, Wizard 4.3 Windows Components like Desktop, Start menu, My Computer, Recycle Bin, Notepad, Icons, Dialog Boxes & Toolbars etc. 4.4 Working with Files & Folders: File and Directory management, create, copy, delete, move files, Shortcuts, Types of files, File attributes, Windows Explorer 4.5 Setting Environment using Control Panel – Date & Time, Display, System, Printers, Audio, Network, Fonts, Users, Installing and uninstalling new Hardware & Software on your computer etc. 4.6 Searching Files, Computers UNIT 5: Introduction to Internet & E-mail 5.1 What is Internet? 5.2 Web Browsers and URL 5.3 Internet Settings, Browser Settings 5.4 Web Services like www, ftp, e-mail, chat, search engine etc. 5.5 Concept of Telnet, Remote Desktop 5.6 Basics of E-mail 5.6.1 What is an Electronic Mail? 5.6.2 Email Addressing 5.6.3 Mailbox: Inbox and Outbox 5.6.4 Composing and sending a new E-mail 5.6.5 Replying, Forwarding an E-mail message 5.6.6 Sorting and Searching emails 5.6.7 Mail Attachments 5.6.8 Using Address book 5.6.9 Handling SPAM 5.6.10 E-mail protocols like POP3, SMTP 5.6.11 Difference between Offline Mail Client (Outlook) and Browser based E-mail services Reference Books

Teaching Methodology Evaluation Method

1. Fundamentals of Computers – E Balagurusamy, McGrawHill 2. Fundamentals of Computer – V. RajaRaman 3. How Computers work - Ron White – Techmedia 4. How Internet work – Ron White - Techmedia 5. Introduction to computers - Peter Norton – TMH 6. Inside IBM PC - Peter Norton - PHI 7. Operating Systems - Stallings – PHI 8. Windows XP – Complete Reference, BPB Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 102: Database Management Systems Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective

Pre-requisite Course Out come

Course Content

102 Database Management Systems 4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 This course is an introduction of the concept of database management Systems. The course gives the knowledge about structure and use of various database management systems with major focus on relational database design. 1. To make student understand basic concepts of Database management systems, especially relational database. 2. To make student able to design good database design with implementation of various constrains. 3. To make student effectively using database for storing, managing and retrieving data from DBMS like MS-ACCESS, MySQL, Oracle and DB2 via SQL statements. NIL After studying this course, students will be able to appreciate the applications of database systems. Students will be able to develop database applications with all the constraints which help in storing and retrieving data easily. Student will be able to effectively work with DBMS like MS-ACCESS, MySQL, Oracle and DB2 via SQL Interface. Unit 1: Basic Concepts of Database Management System 1.1 Fundamental concepts of File and databases 1.2 Purpose of database system 1.3 Structure of relational database – instance, schema, record, fields Unit 2: Relational Database Design 2.1 Integrity Constraints: 2.1.1 Concepts of Key: super key, candidate key, primary key, unique key 2.1.2 Data Constraints - Applying Data constraints, Types of Data constraints - I/O, Primary, Foreign and Unique 2.1.4 Business Rule Constraint - Column & Table level, NULL & NOT NULL 2.1.5 CHECK constraint 2.1.6 Default value concepts 2.2 Referential Integrity Constraints (foreign key) UNIT 3: Normalization 3.1 Functional Dependencies 3.2 Need for Normalization 3.3 Normalization using functional dependencies - upto 3NF Unit 4: SQL statements - DDL (MS-Access, MySql, Oracle or DB2)

4.1 Working with databases and tables. 4.2 Various types of data, conventions and terminology 4.3 DDL statements- CREATE TABLE,ALTER TABLE,DROP TABLE Unit 5: SQL statements – DML (MS-Access, MySql, Oracle or DB2) 5.1 DML statements- INSERT, UPDATE, DELETE, TRUNCATE 5.2 SELECT statement 5.2.2 Clauses of SELECT statements 5.2.2 group functions and Built-in functions 5.2.3 Querying multiple tables using join Reference Books

Teaching Methodology Evaluation Method

1. Database System Concepts – SILBERSCHATZ, KORTH, SUDARSHANMcGraw-Hill 2. An introduction to Database Systems- C.J.DATE – Addison Wesley 3. Database System: A practical approach to design implementation and management – THOMAS CONNOLLY, CAROLYN BEGG, Pearson Education 4. Access - The Complete Reference – Virginia Andersen – McGraw-Hill 5. Access Database Design & Programming – Steven Roman - O' Reilly 6. Microsoft Access: Bible – Cary N. Prague 7. MySQL in a Nutshell, Russell Dyer, O’Reilly 8. SQL & PL/SQL Programming Language of Oracle – IVAN BAYROSS Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 103: Fundamentals of ‘C’ programming Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective Pre-requisite Course Out come Course Content

103 Fundamentals of ‘C’ programming 4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 The course is for the introduction of fundamental of Computer Programming & Programming Methodology using ‘C’ language. Students will become familiar with algorithm development and problem solving techniques using structured programming. 1. To explain the concept of Computer Programming Methodology 2. To make student understand fundamental concepts of structured programming language and constructs of ‘C’ language. 3. NIL 4. After studying this course, students will be able to develop an algorithm for solutions to various problems. They can convert the algorithms into computer programs using C language. UNIT 1: Programming Languages 1.1 Algorithm and Flowchart 1.2 Concepts of Compiler / Interpreter UNIT 2: Constraints & Variables 2.1 Character Set 2.2 Constants 2.3 Variables 2.4 Storage Classes 2.5 Scope of Variables UNIT 3: Operators & Functions 3.1 Operators: Assignment, Arithmetic, Increment, Decrement, Relational, Logical, Conditional 3.2 Expression 3.3 Evaluation & Assignment of Expression 3.4 Functions 3.4.1 Basic Input & Output Functions 3.4.2 Built-in Functions - Mathematical and String Functions UNIT 4: Jumping, Branching & Looping Statements UNIT 5: Array and Structure 5.1 Array – Meaning and Usages 5.2 One Dimensional Arrays 5.3 Two Dimensional Array 5.4 Structure – Meaning and Usages

Reference Books

1. Programming in C - Balaguruswami - TMH 2. C Programming Language - Kernigham & Ritchie - TMH 3. Programming in C - Stephan Kochan – CBS

Teaching Methodology Evaluation Method

4. C Language Programming - Byron Gottfried –TMH 5. Let us C – Yashwant Kanetkar - BPB Publication 6. Structured programming concepts - La Budde - (Mc.Graw HIll) Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 104: GUI Programming – I Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course Course Objective Pre-requisite Course Out come

Course Content

104 GUI Programming – I 4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 This course is an introduction of Graphical User Interface to students. The course also gives students an idea about various components .NET architecture, Visual Studio and also explains the working of it. 1. To make student understand GUI programming 2. To make student understand various Controls and their use. NIL After studding this course, students will be able to understand how .NET architecture works. This course will also help students to understand the role of various controls of Visual studio their use. After successful completion students will be able to make simple GUI applications. UNIT 1: Introduction to Microsoft .NET 1.1 Microsoft .NET Framework architecture 1.2 Common Language Runtime 1.3 Common Type System 1.4 Microsoft Intermediate Language Assemblies 1.5 Namespaces 1.6 class libraries UNIT 2: The VB.NET Language 2.1 Data Type, Variables 2.2 Constants 2.3 Arrays 2.4 Control Array 2.5 Collections 2.6 Subroutines 2.7 Functions 2.8 Control Flow statements 2.9 Messagebox and Inputbox. UNIT 3: Working with Win Forms 3.1 Form Lifecycle 3.2 Textbox, Label 3.3 Button 3.4 Listbox 3.5 Combobox 3.6 Checkbox 3.7 PictureBox 3.8 RadioButton 3.9 Link Label 3.10 Panel

3.11 Scroll bar 3.12 Timer 3.13 ListView 3.14 TreeView 3.15 Toolbar 3.16 StatusBar UNIT 4: Containers, Dialog Boxes and Menus 4.1 Containers: Flow layout panel, Group box, Panel, Split container, Tab control, Table layout panel 4.2 Dialog Boxes: OpenFileDilog, SaveFileDialog, FontDialog, ColorDialog, PrintDialog 4.3 Menus UNIT 5: Introduction to Database 5.1 ADO.NET Architecture 5.2 Using the BindingSource Reference Books

Teaching Methodology Evaluation Method

1. Visual Basic .NET Programming – Black Book: Stevan Holzner Dreamtech Press 2. Introduction to .NET framework -Worx publication 3. The Complete Reference – Visual Basic .NET : Jeffrey Shapiro - TMH 4. Visual Basic .NET Programming (Black Book) - By Steven Son Holzner , DreamTech Publication 5. Mastering Visual Basic.NET by Evangelos Petroutsos BPB Publication 6. Moving to VB.NET : Stategies, Concepts, and Code - by Dan Appleman – Apress Publication 7. Microsoft Visual Basic .NET Step by Step - by Michael Halvorson, PHI Publication 8. .NET – Complete Development Cycle - by G. Lenz, T. Moeller, Pearson Education 9. Professional VB.NET, 2nd Edition - by Fred Barwell, et al – Wrox Publication Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 105: Office Automation Tools Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective Pre-requisite Course Outcome Course Content

105 Office Automation Tools 4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 This course aims towards learning and use of office suite of applications namely word processing software, spreadsheet software and presentation software. The course also teaches students about various features of these software tools. 1.To make students learn and use Word processing software 2.To make students learn and use Spreadsheet application 3.To make students learn and use Presentation software Nil After studying the course, students will be able to work with office suite and also understand about the important features of word processing software, spreadsheet software and presentation software. UNIT 1: Introduction to Office Suite 1.1. Features and uses 1.2. Word-processing, Spreadsheet, Presentation, graphics UNIT 2: Word-processing 2.1. Working with Word-processing 2.2. Menus & Commands, Shortcut Menus, Toolbars 2.3. Templates, Creating a New Document 2.4. Document Views and layouts 2.5. Working with –Styles 2.6. Headers & Footers 2.7. Text, Paragraph, Page Formatting 2.8. Text Attributes, Text Editing, Text Enhancements 2.9. Bullets & Numbering: Bulleted, Numbered & Multilevel List 2.10. Format Painter and its use 2.11. Tabs & Indents 2.12. Auto formatting, Auto text, Autocorrect, Auto complete 2.13. Insert page numbers, symbols, images, files etc. 2.14. Insert Table of Contents, Footnote, Endnote, Citation, Cross Reference etc. 2.15. Find & Replace 2.16. Spell Check & Grammar, Thesaurus 2.17. Tables 2.17.1. Create Tables 2.17.2. Add, Delete, Insert, Merge Rows and Columns 2.17.3. Convert Text to Table and Table to Text 2.17.4. Borders and Shading 2.18. Margins & Space management in Document 2.19. Adding References and Graphics 2.20. Mail Merge 2.20.1. Letters, Envelopes, Mailing Labels

2.21. Import and Export to/from other file formats 2.22. Printing & various print options UNIT 3. Spreadsheet 3.1. Concepts of Workbook & Worksheets 3.2. Using Wizards 3.3. Different Views of Worksheets 3.4. Using different features with Data, Cell and Text 3.5. Cell Markers 3.6. Working with Data & Ranges, Various Data Types, Name a range of cells 3.7. Cell Formatting, Conditional Formatting , Borders & Shading, Row Height, Column Width and other Format features 3.8. Addressing and its types (Absolute, Relative) 3.9. Series, Fill series of different types 3.10. Column & Row Freezing, Labels, Hiding, Splitting etc. 3.11. Inserting, Removing & Resizing of Columns & Rows 3.12. Functions and their categories like Recently Used, Financial, Logical, Text, Text, Date & Time, Lookup & Reference etc. 3.13. Use of Formulas, Calculations 3.14. Chart Wizard, Different Chart Types 3.15. Analyzing data 3.16. Creating Formats & Links 3.17. Organizing Data in A List 3.18. Sorting and Filtering data 3.19. Sharing & Importing Data 3.20. What-if analysis using Goal Seek, Scenario 3.21. Spelling, Thesaurus, Protect Sheet, Protect Workbook, Password protection 3.22. Page Layout and Page formatting 3.23. Printing of Workbook & Worksheets with various options UNIT 4: Presentation 4.1. Introduction & use, working with PowerPoint 4.2. Creating a presentation 4.3. Using Wizards 4.4. Slides & different types, 4.5. Inserting, Deleting and Copying of Slides 4.6. Working with Notes, Handouts, Columns & Lists 4.7. Adding Graphics, Sounds and Movies to a Slide 4.8. Working with PowerPoint Objects 4.9. Designing & Presentation of a Slide Show 4.10. Printing Presentations, Notes, Handouts with print options 4.11. Master Slide and other Masters 4.12. Slide Transition, Automating Presentation, applying effects Unit 5: Comparison of various office suites like MS- Office, LotusOffice, Star-Office, Open-Office etc. Reference Books

1. Microsoft Office 2013 Bible, Microsoft Press

2. 3. 4. 5. 6. 7. 8.

Teaching Methodology Evaluation Method

MS OFFICE XP COMPLETE BPB publication The 2007 Microsoft Office System Inside Out, Microsoft Press Mastering Word 97, Mansfield, Sybex Pub. Mastering Excel 2010, Bill Jelen, BPB Mastering Microsoft Office 97 – L.Moseley, D.Boody – BPB Mastering Powerpoint 2000 – Murray K., BPB The ABSs of Microsoft Office - Professional Edition by GuyHart – Davis, BPB Publication 9. The Essential Excel 97 Book - Faithe Wempen & Donna Ppayne, Galgotia Publication 10. MS Office Excel Step by Step, Curtis Frye, Microsoft Press Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 106: Practical-I Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective

Prerequisite Course Outcome

Course Content

Reference Books Teaching Methodology Evaluation Method

106 Practical-I 4 4 Hrs 15 (Including Practical work, examination, preparation, holidays etc.) June 2015 1. The course gives the practical knowledge about structure and use of various database management systems with major focus on relational database design. 2. Students will become familiar with problem solving techniques using ‘C’ language 1. To make students work practically on Structured Query Language 2. To get students acquainted practically with various DBMS 3. To make student understand fundamental concepts of structured programming language and constructs of “C’ language. Nil After studying this course 1. Students will be able to effectively work with DBMS like like MSACCESS, MySQL, Oracle and DB2 via SQL Interface. 2. Students will be able to write program for solutions to various problems using ‘C’ language Practical based on: Paper No. 102 (Database Management Systems) using Microsoft graphics & Paper No. 103 (Fundamentals of ‘C’ programming) As per Paper No. 102 and Paper No. 103 Lab. Work 30 % internal assessment and 70% external assessment

Course: 107: Practical-II Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course Course Objective Prerequisite Course Outcome Course Content Reference Books Teaching Methodology Evaluation Method

107 Practical-II 3 3 Hrs 15 (Including Practical work, examination, preparation, holidays etc.) June 2015 The course is an introduction of practical working with various components using .NET architecture and Visual Studio interface. To make students practically work with Visual studio interface and .Net architecture using VB .net Nil After studying the course, students will be able to develop GUI application using basic controls of Visual Studio. Practical based on Paper No. 104 GUI Programming – I As per Paper No. 104 GUI Programming – I Lab. Work 30 % internal assessment and 70% external assessment

Course: 108: Practical-III Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course Course Objective Prerequisite Course Outcome Course Content Reference Books Teaching Methodology Evaluation Method

108 Practical-III 3 3 Hrs 15 (Including Practical work, examination, preparation, holidays etc.) June 2015 This course aims towards learning and use of office suite of applications like word processing software, spreadsheet software and presentation software. 1. To make students learn and use Word processing software 2. To make students learn and use Spreadsheet application 3. To make students learn and use Presentation software Nil After studying the course, students will be able to work with office suite and also understand about the important features of word processing software, spreadsheet software and presentation software. Practical based on Paper No. 105 Office Automation Tools As per Paper No. 105 Office Automation Tools Lab. Work 30 % internal assessment and 70% external assessment

Course: 201: GUI Programming - II Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course Course Objective Pre-requisite Course Out come Course Content

201 GUI Programming – II 4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 This course is advance of vb.net course. It is to make aware students in database related programs in vb.net. 1. To make student understand advance controls of vb.net 2. To make student understand MDI based programming 3. To make understand students database related programming Understanding of .NET Framework After studying this course, students shall be able to develop database related programs in Vb.Net. Unit : 1 : .Introduction 1.1 .NET Framework , CLR, Class Libraries 1.2 Toolbox controls 1.3 Creating Menus & Using Dialogboxes 1.4 Error Handling Unit 2 : Advance GUI Controls & MDI Programming 2.1 Treeview & Listview controls 2.2 Toolbar & Statusbar controls 2.2 Container & Split controls 2.4 MDI Application & MDI Child Handling 2.5 Webbrowser Control 2.6 Reading parameters from Config Files Unit : 3 : Ado.NET Introduction 3.1 Connected Architecture classes 3.2 Disconnected architecture 3.3 Reading & Writing XML 3.4 Database controls & binding Unit 4 : ADO.Net Programming 4.1 Writing database programs using ado.net Connection Class 4.2 Basic CRUD operation 4.3 DataGridView binding 4.4 Master Detail Form programming Unit 5 : Connecting to Various RDBMS using VB.Net 5.1 Programming with MySQL Database 5.2 Programming with SQLServer 5.3 Programming oledb databases like MS access etc. 5.4 Reading and manipulating image files

Reference Books

1. Visual Basic .NET Programming – Black Book: Stevan Holzner Dreamtech Press

Teaching Methodology Evaluation Method

2. Introduction to .NET framework -Worx publication 3. The Complete Reference – Visual Basic .NET : Jeffrey Shapiro - TMH 4. Visual Basic .NET Programming (Black Book) - By Steven Son Holzner , DreamTech Publication 5. Mastering Visual Basic.NET by Evangelos Petroutsos BPB Publication 6. Moving to VB.NET : Stategies, Concepts, and Code - by Dan Appleman – Apress Publication 7. Microsoft Visual Basic .NET Step by Step - by Michael Halvorson, PHI Publication 8. .NET – Complete Development Cycle - by G. Lenz, T. Moeller, Pearson Education 9. Professional VB.NET, 2nd Edition - by Fred Barwell, et al – Wrox Publication Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 202: Web Designing tools Course Code Course Title

202 Web Designing tools

Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 This course is an introduction of Web Designing concepts to students. The course also gives students an idea about various client side technologies like CSS and Javascript. It also gives idea about web page designing using Photoshop and Flash. 1. To make student understand Web Designing 2. To make student understand various concepts of Validation, designing and how to in-corporate those in web page, HTML After studying this course, students will be able to understand and create HTML web pages with multimedia. This course will also help students to understand how to validate user Input and how to apply common design on every web page. UNIT 1: JavaScript 1.1 Fundamentals of JavaScript 1.2 Syntax of JavaScript 1.3 Use of JavaScript in HTML 1.4 Validation using JavaScript

Course Objective Pre-requisite Course Out come

Course Content

UNIT 2: CSS 2.1 What is CSS? 2.2 Advantage & Disadvantage of CSS 2.3 Creating CSS 2.4 Use of CSS in HTML 2.5 Formatting HTML page using CSS UNIT 3: Graphics Basics 3.1 Bitmap vs. vector-based graphics 3.2 Color/bit depth and image resolution 3.3 Graphic file formats 3.4 Optimizing web graphic 3.5 Vector graphics vs. bitmap graphics 3.6 Regular text vs. anti-aliased text 3.7 Pixel resize vs. smart resize 3.8 Regular graphics vs. interlaced graphics 3.9 Lossy compression vs. lossless compression 3.10 Dithered graphics vs. non-dithered graphics 3.11 Tolerance 3.12 Opacity 3.13 Introduction to Color 3.13.1 Color modes- RGB, CMYK, grayscale, LAB, bitmap, 3.13.2 Color Adjustments- Hue, saturation, and brightness,

Browser safe colors, Shadows, highlights and midtones of an image UNIT 4: Photoshop Environment 5.1 About Photoshop 5.2 The Photoshop Interface 5.3 Setting up a new Photoshop document 5.4 The Photoshop Toolbox and Options bar 5.5 Photoshop Image and Color Basics 4.5.1 Opening, Creating and Saving an Image in Photoshop 4.5.2 Basic image editing, Working with color in Photoshop 5.6 Photoshop Tools Tools - Marquees, Magic wand, Lassos,. Move tool, Crop tool, Slice tools, Pencil, Paintbrush, Eraser tools, History brushes, Gradient, Paint bucket, Burn-dodge-sponge, Blur-sharpensmudge, Shapes-line-rectangle-polygon, Path selection tool, Pen tool, Back ground and foreground. 5.7 Transforms : Using free transform, move, Rotate, scale, Skew, Distort, Perspective, Flip 5.8 Photoshop Layers and Channels and Filters 5.8.1 Introduction to Layers 5.8.2 Layer modes and blending options 5.8.3 Image composting using layers 5.8.4 Introduction to Channels and Actions 5.8.5 Filters – Artistic, Blur , Noise etc. 5.8.6 Text editing and special effects UNIT 5: Introduction to Flash Reference Books

1. HTML, DHTML, Java Script, Perl & CGI, Ivan Bayross BPB 2. 3. 4. 5. 6. 7. 8.

Teaching Methodology Evaluation Method

Publication. Internet and Web Design, Ramesh Bangia ,New Age International Web Design Technology, D.P. Nagpal, Paperback Web Design: The Complete Reference, Thomas A. Powell,Paperback Comprehensive Multimedia And Web Technology, Ramesh Bangia, Meenakshi Arora,Firewall Media Photoshop CS5, In Easy Steps ,Paperback Adobe Photoshop CC Bible, Lisa Danae Dayley and Brad Dayley Exploring Adobe Flash CS6, Prof. Sham Tickoo , Supriya Mishra ,Paperback

Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 203: Network Essentials and E-Commerce Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective

Pre-requisite Course Out come

Course Content

203 Network Essentials and E-Commerce 4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 This course is an introduction to students to understand Computer Network concepts. The course also gives students an idea about the process of E-commerce and security concerns while using E-commerce in business management. 1. To make student understand the nature of computer network 2. To make student understand the Internet Communication. 3. To make student understand the nature of e-Commerce 4. To make student recognize the business impact and potential of eCommerce 5. To explain the economic consequences of e-Commerce; 6. To discuss the trends in e-Commerce and the use of the Internet. NIL After studying the course, students will be able to understand how computer networks, internet and also familiarize students with the process of E-commerce and security concerns while using E-commerce in business management. Unit 1: Networking Fundamentals 1.1 An Introduction to Networks 1.2 Components to connect computer to network 1.3 Categories of Computer Network – peer-to-peer, client-server, LAN,MAN and WAN 1.4 Introduction to Analog and Digital Signals 1.5 Transmission Media- Guided & Unguided 1.6 Transmission Categories- Simplex, Half Duplex & Full Duplex 1.7 Network Topologies- Bus, Ring, Star, Mesh 1.8 Need, Uses and Advantages of Computer Network Unit 2: Internet Communication 2.1 Communication devices to connect notebook computer to network- Infrared, Bluetooth, Ethernet and Cellular WAN Adapter 2.2 Internet connection from home or small office- PSTN,DSL, ISDN, Cable Modem 2.3 Network Addressing- Physical (MAC) & Logical (IP) Address 2.4 IP Addressing- Version 4 2.4.1 Subnet mask 2.4.2 Network Address Classes- A,B and C Unit 3: Introduction to E-Commerce 3.1 History of E-Commerce

3.2 3.3 3.4 3.5

Concepts, Advantages and Disadvantages of E-Commerce Impact of E-Commerce on business Traditional Commerce and E-Commerce Types of E-Commerceb2b,b2c,b2e,b2g,g2b,g2g,g2c,c2c,c2b

Unit 4: Electronic Payment Systems 4.1 Introduction to EPS 4.2 Types of Electronic Payment Systems-Payment card, Digital cash, Digital wallet, Smart card 4.3 Online banking (netbanking) 4.4 Electronic Funds Transfer 4.5 Payments on retail sites using credit/debit card, Netbanking etc. Unit 5: Case Studies 5.1 Travel Segment - IRCTC, GSRTC 5.2 Retail Segment - Flipkart, Snapdeal, Amazon, Jabong, Yepme 5.3 Wholeseller Segment - Alibaba, IndiaMart 5.4 Other Segments - Google Adsense, SMC, MyGov India, gujaratindia Reference Books

Teaching Methodology Evaluation Method

1. Data Communication and Networking – B. Forouzan – MCGrawth Hill2. Computer Networks - A. S. Tanenbaum- PHI Publication 2. Networking Complete- 1st Edition 2002, BPB Publication (Text Book) 3. Black, “Computer Networks - Protocols, Standard, Interface”, 2nd Edition, Prentice Hall of India 4. Business on the net - by Kamlesh N. Agarawala , Amit Lal & Deeksha Agarawal ( Macmillan India Ltd.). 5. E-Commerce an Indian Perspective (Second Edition) By Pt Joseph, S.J., Prentice-Hall of India 6. E-commerce, The cutting edge of Business, K.K.Bajaj & D.Nag-TMH 7. Electronic Commerce, David Kosiur-PHI 8. E-Commerce, An Indian perspective, P.T.Joseph Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 204: Basics of Accounts and Accounting Package Course Code Course Title

204 Basics of Accounts and Accounting Package

Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

4 4 Hrs 15 (Including Class work, examination, preparation, holidays etc.) June 2015 The purpose of this course is to introduce to teach basic concepts of Financial Accounting & explain working of Financial Accounting Software 1. To explain basic component of financial account and book keeping using ledger and subsidiary books. 2. To teach preparation of Final accounting statements 3. To explain working of accounting package for financial accounting. NIL After studying this course, students will be able to understand procedure of financial accounting for any organization and able to interact with accounting or information systems. UNIT 1: Introduction to Accounting concepts 1.1 Definition of Accounting 1.2 Accounting principles 1.3 Introduction of financial, cost and management accounting 1.4 Classification of Accounts (Real , Personal & Nominal) 1.5 Identification of Transaction 1.6 Double entry system

Course Objective

Pre-requisite Course Out come Course Content

UNIT 2: Journal & Subsidiary Books (With Preliminary examples) 2.1 Journal 2.2 Cash Book & Petty cash Book 2.3 Purchase, Sale, Purchase Return and Sale Return Book UNIT 3: Accounting process 3.1 Recording of Transaction in Journal/subsidiary book 3.2 Posting to ledger 3.3 Preparation of Trial Balance 3.4 Passing Adjusting Entries 3.5 Preparation of Final Accounts UNIT 4: Working with accounting package – Book Keeping 4.1 Creation of Company 4.2 Opening the company making it active 4.3 Creating ledger A/c 4.4 Entering Vouchers 4.5 Access to the various Books of Account UNIT 5: Working with accounting package – Final Accounts 5.1 Creation of Financial Accounting Statement - Trial Balance, Trading A/c, Profit & Loss A/c , Balance Sheet 5.2 Ratio Analysis to interpreter financial statements

Reference Books

1. Financial Accounting - Vol. I, Mohammed Hanif & Amitabha Mukherjee, , Paperback 2. Modern Accountancy Vol. I, A. Mukherjee, Tata Mcgraw Hill 3. Basic Accounting-Concepts and Methods, Vijay Asdhir, Himalaya Publishing House 4. Book-Keeping And Accountancy, Prof. Jose Paul,Himalaya Publishing House 5. Computerized Accounting, P.H. Bassett, BPB Publication 6. Tally .ERP 9 in Simple Steps, Kogent Learning Solutions Inc., Wiley 7. Implementing Tally .ERP 9, A. K. Nadhani, Paperback

Teaching Methodology Evaluation Method

Class work, Discussion, Self Study, Seminars and/or Assignment 30 % internal assessment and 70% external assessment

Course: 205: Practical-IV Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course Course Objective Prerequisite Course Outcome Course Content Reference Books Teaching Methodology Evaluation Method

205 Practical-IV 3 3 Hrs 15 (Including Practical work, examination, preparation, holidays etc.) June 2015 This course is to make aware students in database related programs in vb.net. 1. To make student understand advance controls of vb.net 2. To make student understand MDI based programming 3. To make understand students database related programming Ability write simple GUI program with basic controls using .NET Framework After studying this course, students shall be able to develop database related programs in Vb.Net. Practical based on Paper No 201 GUI Programming –II As per Paper No 201 GUI Programming - II Lab. Work 30 % internal assessment and 70% external assessment

Course: 206: Practical-V Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective Prerequisite Course Outcome

Course Content Reference Books Teaching Methodology Evaluation Method

206 Practical-V 3 3 Hrs 15 (Including Practical work, examination, preparation, holidays etc.) June 2015 The course gives students knowledge about working with various client side technologies like CSS and JavaScript. Students can work with web page designing tools like Photoshop and Flash. To make student practically work to implement various concepts of Validation, designing. To make student able to design web pages. Nil After studying this course, students will be able to understand and create HTML web pages with multimedia. This course will also help students to understand how to validate user Input and how to apply common design on every web page Practical based on Paper No 202 Web Designing tools As per Paper No 202 Web Designing tools Lab. Work 30 % internal assessment and 70% external assessment

Course: 207 Project Course Code Course Title Credit Teaching per Week Minimum weeks per Semester Review / Revision Purpose of Course

Course Objective Prerequisite Course Outcome Course Content

207 Project 8 -15 (Including project work, examination, preparation, holidays etc.) June 2015 The project work is introduced to make students implement their theory and practical knowledge they learned during this degree course to solve real life problem related to the industry, academic institutions or other organization. It involves practical work for understanding and solving problems in the field of computing To help students develop their practical ability and knowledge about practical tools/techniques in order to develop software. Knowledge of programming methodology and GUI tools Student will be able to develop software applications. The students are required to carry out project during the semester. At the end of the semester, the students have to submit their project report in bounded form as per guideline given by department.

Reference Books Teaching Methodology Evaluation Method

The project report and project completion certificate is mandatory for appearing in Project Presentation and Viva – Voce. -Project guidance, review !00% assessment is based on the Project Presentation and Viva – Voce as conducted as per the University exam schedule.

Loading...

PGDCA Syllabus (Regular).pdf

Post Graduate Diploma in Computer Application (Regular) Name of Program Abbreviation Duration Eligibility Objective of Program Program Outcome Mediu...

166KB Sizes 32 Downloads 19 Views

Recommend Documents

PGDCA - Nielit
2PGDCA4(A). 2PGDCA4(B). Elective - 2. OOPs & Programming with. C++. Financial Accounting with Tally. 4. 1. 3. 80. 20. 25

PGDCA - MCU, Bhopal
Jul 31, 2007 - 1. Strong knowledge and skill base of the followings from the core field : • Office Application package

PGDCA - Mata Gujri College
Brain W. Kernigham and Dennis M. Richie: The C Programming Language, 2nd Ed.,. PHI. 2. R. S. Salaria, “Problem Solving

PGDCA - Himachal Pradesh University
SEMESTER –I. Course. Code. Paper. Max. Marks. Theory. Internal. Assess. Exams. Duration (Hrs.) DCS-101 Fundamentals of

mrsptu pgdca study scheme 2016 batch onwards - Maharaja Ranjit
E. Balagurusamy, 'Programming in ANSI C', 2nd Edition”, Tata McGraw Hill. 1. Brian Kernighan and Dennis Ritchie, 'C Pr

Syllabus
Text book. 1. Popov E.P., Engineering Mechanics of Solids, Prentice Hall of India. Reference books. 1. Timoshenko S.P. &

Syllabus
ELECTRONICS AND COMMUNICATION ENGINEERING. With effect ... 50. 3. 100. 2K6EC 306. Electronic Circuits I. 3 1. -. 50. 3.

Syllabus
Introduction to need of environmental management. Policies,procedures and resources for implementing and maintaining eff

Syllabus
Feb 26, 2015 - Getting Started with Web Designing (Dreamweaver CS 6 may be used). ➢ Working with Lists ... Understandi

SYLLABUS
H.L. Ahuja, Micro Economic Theory, S. Chand & Company, New Delhi. 2. Seth, M.L., Micro Economics, Laxmi Narayan Agarwal,