objectives, teaching scheme & syllabus … teaching scheme & syllabus for ... mca dual...

OBJECTIVES, TEACHING SCHEME & SYLLABUS

FOR

MCA DUAL DEGREE PROGRAMME

(1ST& 2ND SEMESTER)

EFFECTIVE FROM ACADEMIC YEAR 2014-15

Faculty of Computer Science and Applications

MCA Dual Degree Programme

MCA Dual Degree Programme Objectives

First Year Objective:-

Students will able to understand fundamentals concepts of computational thinking as well as knowledge of how computers and other digital devices are operated through interface as operating system.

Students will able to draft and design a document, analyze and process data in spreadsheet, deliver an effective presentation, design and create database, define queries and to create forms and reports.

Students will able to think logic of any real problem and able to implement it with programming concept. Student will able to integrate concepts of database, commerce, mathematics and statistics to store, summarize, analyze and interpret data for any real application.

Students will get an appropriate level of oral, written and visual communication skills required for technocrats.

List of Subjects o Introduction to computers o Programming principles and logic development o Mathematical and statistical foundations o Operating Systems Concepts o Fundamentals concepts in programming language o Fundamental of commerce and business processes. o Database Fundamentals o Soft Skill development using assignments, case study preparation,

seminars, etc.

Second Year Objective:-

Student to be gain a thorough understanding or grasp key technologies for software application development.

Students to apply knowledge and skills to develop software as a “model” or develop an application in the “software as a model” perspective.

Student will able to understand efficient Query generation and acquire query optimization skills.

Student will able to understand the concepts of Computer interconnectivity, sharing of resources, internet technologies and other network applications.

Student will able to understand the electronic commerce and how electronic commerce is affecting business enterprises, governments, consumers and people in general.



Student will get an appropriate level of technical writing skills in form of case study and project proposal writing.

List of Subjects

o Object Oriented Analysis and Design o Advance DBMS o Object Oriented Programming o Data & File Structure implementation o Computer Networks & Internet o Client Server Architecture Using Visual Basic o E – Commerce o Technical Writing skills using case study, project proposal etc.

Third Year Objective:-

Student will learn concepts of open source and its implementations using different frameworks.

Student will understand the human computer interfaces through implementation of advanced techniques viz multimedia and computer graphics.

Student will learn fundamentals of network management - traffic management, congestion, security and cryptography techniques.

Student will gain thorough understanding of grasp key technologies through client server and object oriented concepts.

Student will learn to analyze and facilitate strategic and operational activities in the organization. The student will study how individuals, groups, and

Organizations evaluate, design, implement, manage, and utilize systems to generate information to improve efficiency and effectiveness of decision making

Student will learn and apply project management skills particularly emphasize on software development project planning and management.

List of Subjects o Open Source Using PHP o Client Server Architecture using .Net frameworks o Advance Computer Networks o Computer Graphics and Basics of Web Designing o Object Oriented Concept through JAVA. o Management Information System o Software Project Management o Minor Project



Teaching and Examination Scheme (MCA Dual Degree Program)

Effective from Academic Year 2014-15

SEMESTER-I

Course Code

Course Title Teaching Scheme Examination Scheme Contact Hours Credit Theory Practical Total

Theory Pract Total Internal Exter nal

Internal Exter nal Case

Study Tests Term

work Tests

CA101 Introduction to computers

4 3 7 7 10 20 70 15 15 70 200

CA102 Programming principles and logic development

4 - 4 4 10 20 70 - - - 100

CA103 Operating Systems Concepts

4 3 7 7 10 20 70 15 15 70 200

CA104 Programming the Internet

4 3 7 7 10 20 70 15 15 70 200

HS111 Study of English Language and Literature

2 - 2 2 25

25 25 25 100

18 9 27 27 450 350 800

SEMESTER-II

Course Code

Course Title Teaching Scheme Examination Scheme Contact Hours Credit Theory Practical Total

Theory Pract Total Internal Exter nal

Internal Exter nal Case

Study Tests Term

work Tests

CA105 Fundamental concepts of programming language

4 3 7 7 10 20 70 15 15 70 200

CA106 Database Fundamentals

4 3 7 7 10 20 70 15 15 70 200

CA107 Fundamentals of commerce and business processes

4 - 4 4 10 20 70 - - - 100

CA108 Mathematical and statistical foundations

4 - 4 4 10 20 70 - - - 100

HS101 Liberal Arts - 2 2 2 - - 50 50 100

16 8 24 24 400 300 700



CA 101: Introduction to Computers (200 Marks)

Credit Hours: 07

Objectives of the Course: This syllabus is designed to familiarize students with computer fundamentals and to make the students familiar with office automation software on Windows platform. It also makes them aware about the Internet and Email technology. Prerequisite: None. Learning Outcomes: Upon successful completion of the course, the students will learn fundamental concepts of computer hardware and software and become familiar with a variety of computer applications including word-processing, spreadsheets and presentations. Students will also learn Internet-based applications, working with email and learning how to browse the web. Instructional Methods & Pedagogy: During theory lectures students will be introduced to the fundamentals of computers, functionalities of various office automation software, Internet and Email system. During Practical sessions students will be made familiar with the working of various software packages like MS Word, MS Excel and MS PowerPoint.

Unit No.

Title of the Unit Minimum Number of Hours

Theory Practical

1. Computer Fundamentals 09

36

2. The Computer System Architecture

07

3. Elements of Word Processing 09

4. Working with Spread Sheet 09

5. Making Small Presentations 08

6. Computer Communication and Internet

06

Total Hours (Theory): 48

Total Hours (Lab): 36

Total: 84



Detailed Syllabus: Unit I: Computer Fundamentals Hours:09 Introduction to computers, History of computers, Characteristics of computers, Block diagram of computer, Types of computers and features, Types of programming languages, Data organization, Types of memory, I/O devices, Number systems. Unit II: The Computer System Architecture Hours:07 Introduction, Central Processing Unit, Memory Unit, Microprocessor, Interconnecting the Units of a Computer, Performance of a Computer, Inside a Computer Cabinet, Introduction to Emerging Technologies. Unit III: Elements of Word Processing Hours:09 Introduction to Word Processing and MS word: Crating, saving and opening word documents, Menus, Shortcuts, Toolbars, Ruler Menus, Scroll bar, Editing a document, Formatting page and Setting Margins, Editing text documents, Using help. Formatting Documents: Setting Font Styles, Paragraph styles and Page styles, Setting document styles, Creating tables, Drawing and formatting pictures, Spell check, Macros, Mail merge, Security, Printing documents. Unit IV: Working with Spread Sheet Hours:09 Features of excel, Concept of worksheet, Excel window, Navigating worksheet, entering & editing data into cells, Insert/delete/hide/show rows/columns, Change column width & row right. Formatting data, Formulas & operators Range of cells, moving – copying data, Spell checking, Various types of addressing, Protecting & hiding data, sorting data, Searching & replacing data, Multiple worksheets &operations on them, Built-in functions, Look up tables, Pivot table, Data organization- what-if analysis, Charts, pictures, file operations, Macros, Circular reference, Goal seek. Unit V: Making Small Presentations Hours:08 Basics, Creation of Presentation, Preparation of Slides, Providing aesthetics and Animation, Slide Manipulation and Slide Show, Speaker notes, handouts, an outline, Presentation of the Slides. Unit VI: Computer Communication and Internet Hours:06 Basic of Computer Networks, Internet, Services on InterNet, WWW and Web Browsers, Basics of Email, Sending and receiving email messages, Email netiquette, Abbreviations and emoticons, Signature and attachments to emails, Filtering emails, Securing emails by using digital certificates, Forms of chats and conferencing. Core books: 1. Pradeep Sinha, Priti Sinha : Computer Fundamentals, 6th Edition, BPB Publications,

2003.



2. Joyce Cox, Curtis Frye, Dow Lambert III, Steve Lambert, John Pierce, Joan Preppernau : Step by Step 2007 Microsoft Office System, 2nd Edition, Microsoft Office Press, 2007.

3. Margaret Levine Young : Internet: The Complete Reference, Millennium Edition, Tata McGraw Hill, 1999.

Reference books: 1. Katherine Murray, Mary Millhollon, Beth Melton : Microsoft Office Word 2007 Inside

Out, Microsoft Press Publication, 2007. 2. Mark Dodge, Craig Stinson : Microsoft Office Excel 2007 Inside Out, Microsoft Press

Publication, 2007. 3. Cliff Atkinson : Beyond Bullet Points: Using Microsoft Office PowerPoint 2007 to

Create Presentations That Inform, Motivate and Inspire, Microsoft Press Publication, 2007.

Web References: 1. http://office.microsoft.com/en-us/training/ [For Microsoft Office Concepts] 2. http://www.baycongroup.com/ [For Microsoft Office Concepts] 3. http://www.gcflearnfree.org/office [For Microsoft Office Concepts]

https://www.google.co.in/search?q=Step+by+Step+2007+Microsoft+Office+System+%28+W+/CD%29+by+Curtis+Frye,+Joyce+Cox,+Steve+Lambert&spell=1&sa=X&ei=L0ViUun9MIOErAeF2oDADw&ved=0CCgQBSgA

http://www.amazon.com/Katherine-Murray/e/B001IU4PZ2/ref=ntt_athr_dp_pel_1

http://www.amazon.com/s/ref=ntt_athr_dp_sr_2?_encoding=UTF8&field-author=Craig%20Stinson&search-alias=books&sort=relevancerank

http://www.amazon.com/Cliff-Atkinson/e/B001I9RREY/ref=ntt_athr_dp_pel_1

http://office.microsoft.com/en-us/training/

http://www.baycongroup.com/

http://www.gcflearnfree.org/office



CA 102: Programming Principles and Logic Development (100 Marks)

Credit Hours: 04 Objectives of the Course: The objective of this course is to provide the beginning programmer with a guide to developing structured program logic. The course assumes no previous programming experience and does not focus on any one particular language. The course introduces programming concepts such as program structure, variables, decision structures, loops, arrays, files, and enforces good style and logical thinking. Prerequisite: None Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand the concepts of computers and logic development. They will gain understanding on developing program structure and program planning process. They will understand the use of flowcharts and pseudo code, use of variables and data types, decision structures and loops, use of arrays and file. Instructional Methods & Pedagogy: The course will start with a brief introduction to problem solving and programming. The students will be provided with logic skills for program design and development, students will be introduced to structured and object-oriented design, sequence control structures, decision control structures, looping control structures, arrays and their applications.

Unit No.

Title of unit Minimum number of hours Theory

1. Overview of Computers and Programming 09

2. Elements of High Quality programs and Basic Program Structure

09

3. Making Decisions 07

4. Looping 07

5. Arrays 08

6. File Handling and Applications 08


Total: 48



Detailed Syllabus:

Unit I: Overview of Computers and Programming Hours:09

Understanding computer systems, Understanding simple program logic, understanding the program development cycle, use psuedocode and flowchart symbols, understanding programming and user environments, evolution of programming models.

Unit II: Elements of High Quality programs and Basic Program Structure Hours:09

Declaring and using variables, performing arithmetic operations, understanding the advantages of modularization, modularizing a program, creating hierarchy charts, Features of good program design, the disadvantages of unstructured code, understanding the basic structure, recognizing the structure, structuring and modularizing unstructured logic.

Unit III: Making Decisions Hours:07

Boolean expressions and the selection structure, using the relational comparison operators, Understanding AND and OR logic, making selection within ranges, Understanding precedence.

Unit IV: Looping Hours:07

Understanding the advantages of looping, using a loop control variable, nested loops, Common loop applications.

Unit V: Arrays Hours:08

Storing data in arrays, replacing nested decisions with an array, using constants within an array, searching an array for exact match, using parallel arrays, searching an array for a range match, understanding array bounds, using loop to process array.

Unit VI: File Handling and Applications Hours:08

Understanding computer files, understanding the data hierarchy, performing the file operations, understanding the sequential files and control break logic, merging the sequential files, master and transaction file processing, random access files.

Core Books:

1. Joyce Farrell: Programming Logic and Design, 7th Edition, Course Technology, 2013.



2. Joyce Farrell: Just Enough Programming Logic and Design, Course Technology, 2009.

Reference Books:

1. T. M. Ramachandran: Principles and Techniques of Programming, 2nd Edition, Galgotia Publications, 2004.

2. George Metakides, Anil Nerode: Principles of Logic and Logic Programming, Elsevier Science, 1996.

Web References:

1. http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-00sc-introduction-to-computer-science-and-programming-spring-2011/unit-1/lecture-1-introduction-to-6.00/ [Video lecture of introduction to basics of computer programming]

2. http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-00sc-introduction-to-computer-science-and-programming-spring-2011/unit-1/lecture-2-core-elements-of-a-program/ [ Video lecture for core elements of computer program]

3. http://unesco-nigeriatve.org/download/instructional_materials/nd%20computer%20science/Semesters/Semester%201/COM%20113%20Introduction%20to%20Computer%20Programming%20Final-P/COM%20113%20INTRO%20TO%20COMPUTER%20PROGRAMMING%20Theory%20Book.pdf [For Algorithm, Program, Pseudo code, Type of programming language, Control Structure]

4. https://syl9com.fatcow.com/c1s9c2i/Notes/chap03_old%20book.pdf [For Modules, Hierarchy Charts, and Documentation]

5. http://www.cs.rutgers.edu/~lou/314-f04-slides/topic01_intro.post.pdf [For Introduction to Principles of Programming Languages]

http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-00sc-introduction-to-computer-science-and-programming-spring-2011/unit-1/lecture-1-introduction-to-6.00/



http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-00sc-introduction-to-computer-science-and-programming-spring-2011/unit-1/lecture-2-core-elements-of-a-program/



http://unesco-nigeriatve.org/download/instructional_materials/nd%20computer%20science/Semesters/Semester%201/COM%20113%20Introduction%20to%20Computer%20Programming%20Final-P/COM%20113%20INTRO%20TO%20COMPUTER%20PROGRAMMING%20Theory%20Book.pdf






https://syl9com.fatcow.com/c1s9c2i/Notes/chap03_old%20book.pdf

http://www.cs.rutgers.edu/~lou/314-f04-slides/topic01_intro.post.pdf



CA 103: Operating Systems Concepts

(200 Marks)

Credit Hours: 07

Objectives of the Course: The objective of this course is to provide working knowledge of operating systems which is crucial in effective operation and use of one’s computer system. Also, to make students understand multi-user concepts, use of system editors, basic UNIX commands, and develop their ability to write script files.

Prerequisite: None.

Learning Outcomes: Upon Successful completion of the course, student will learn basic fundamental concepts of operating system and basic DOS and UNIX commands. Students also get familiar with a various operating Systems and its usage, Students will learn How to create and Write Batch Files and Shell script using editors.

Instructional Methods & Pedagogy: In order to achieve the course objectives, students will first be introduced to the basic operating system concepts and basic functions. During practical sessions, the students will be required to use DOS and UNIX commands to understand the system properties and to write script files.

Unit No.


Theory Practical

1. Basic Concepts and Usage of OS 06

36

2. Process Management 08

3. CPU Scheduling 08

4. Operating System Commands 08

5. Editors and Filters 08

6. Shell Programming 10



Total: 84

Detailed Syllabus:



Unit I: Basic Concepts and Usage of OS Hours:06

Operating System Overview: OS objectives and functions (OS as User/Computer

interface, OS as Resource Manager), Evolution of OS, Operating System services, User

Operating System interface, System Call, Operating System Structure, Operating System

Design and issues involved – Interrupts, Interrupt Processing, Interrupt Vectors

Unit II: Process Management Hours:08

Process Control Block, Process States- A two state process model, A five state process

model, A seven state process model, Process Operations- creation, termination and

suspension, Process Vs. Thread, Inter process communication- independent and

cooperative process.

Unit III: CPU Scheduling Hours:08

Types of scheduling - long, medium, short, I/O, Scheduling Criteria, Scheduling

Algorithms - FIFO, Round Robin, Priority Scheduling, SPN, SRN, Feedback

Unit IV: Operating System Commands Hours:08

Basic DOS commands, Batch file, History and Features of Unix OS, Directory structure,

Basic commands – Metacharacter, Shell Variable, Command Substitution, Recording

Script, Navigating File System, Unix Kernel and Shell

Unit V: Editors and Filters Hours:08

Editors: vi, emacs, pico, Simple Filters and pipes, standard Input, Standard output and

Standard Error, Advance Filter – Grep.

Unit VI: Shell Programming Hours:10

Shell Script, Shell environment, Making Script interactive, Command Line Argument,

Evaluating Expression, Operator, Control Statement, Looping statement.

Core Books:

1. William Stallings: Operating Systems Internals and Design Principles, 5th Edition, PHI, 2005.

2. Sumitabha Das: Unix concepts & application, 4th Edition, Tata McGraw Hill, 2010.



3. Kenneth Rosen, Douglas Host, James Farber and Richard Rosinski: The Complete Reference, Tata McGraw Hill, 1999.

Reference Books:

1. Silberschatz: Operating System Concepts, 5th Edition, John Wiley & Sons (ASIA) Ltd., 2008.

2. Mark G. Sobell: A Practical Guide to Linux, Pearson Education, 1997. 3. K.J.George, Operating System Concepts and Principles, Sroff Publishers, 2003

Web References:

1. http://www.nondot.org/sabre/os/articles [A useful collection of documents and

papers on a wide range of OS topics]

2. http://www.ugu.com/sui/ugu/warp.ugu [Excellent source of UNIX information] 3. http://www.tutorialspoint.com/unix/index.htm [ Unix Tutorials] 4. http://williamstallings.com/OS/Animation/Animations.html [Animations of

Operating Systems Concepts] 5. http://placement.freshersworld.com/power-preparation/technical-interview-

preparation/os-interview-questions-23351 [Operating System questions and answers]

6. http://www.ics.uci.edu/~ics143/lectures.html [Lecture notes of OS]

http://www.nondot.org/sabre/os/articles

http://www.ugu.com/sui/ugu/warp.ugu

http://www.tutorialspoint.com/unix/index.htm

http://williamstallings.com/OS/Animation/Animations.html

http://placement.freshersworld.com/power-preparation/technical-interview-preparation/os-interview-questions-23351

http://placement.freshersworld.com/power-preparation/technical-interview-preparation/os-interview-questions-23351

http://www.ics.uci.edu/~ics143/lectures.html



CA 104: Programming the Internet

(200 Marks)

Credit Hours: 07

Objectives of the Course: The objective of this course is to provide working knowledge of design and develop web pages by using markup language.

Prerequisite: None

Learning Outcomes: Upon Successful completion of the course, student will able to design and develop web pages by using HTML Markup Language.

Instructional Methods & Pedagogy: During theory sessions topics related to common technologies and techniques used in the designing of web-based applications will be covered with suitable examples. During Practical sessions, students will be required to design and develop entire web sites using several web designing tools.

Unit No.


Theory Practical

1. Introduction to Internet Applications 06

36

2. Introduction to Web Designing and HTML Documents

06

3. HTML Markup tags and linking 10

4. Images and Tables in HTML 10

5. Forms and Frames in HTML 10

6. Introduction to Web Architecture and Hosting 06



Total: 84

Detailed Syllabus:



Unit I: Introduction to Internet Applications Hours:06

WWW, Search Engines, News-group, E-mail and its Protocols, Web portal ls, Chat, Audio and Video conferencing, FTP, Remote login, Introduction to e-commerce, e-learning, e-governance, e-banking Unit II: Introduction to Web Designing and HTML Documents Hours:06

Web Page, Web Site, Web Browser, Developing Web Documents, Publishing Web

Documents, Maintaining Documents, Overview of HTML, Rules of HTML documents,

Structure of HTML documents

Unit III: HTML Markup tags and linking Hours:10

Tag Definition, Classification of Tags, Basic Tags, Paragraph Tags, List Tags, Horizontal

Rule Tag, Heading Tags, Block quote Tags, Address Tags, FRONT Tag, PRE Tag, DIV tags,

SPAN tag and other formatting tags, URL concepts, Hyperlink tags and attributes,

Create E-mail Hyperlinks

Unit IV Images and Tables in HTML Hours:10

Introduction to Image and Image Format, Tags of images, Inline and Floating Images,

Using Images as a link, Image Map, Introduction to Table, Table tags, rowspan, colspan,

cellspacing, cellpadding, Table examples

Unit V Forms and Frames in HTML Hours:10

Overview of Frames, Frame tags and attributes, Frame targeting, Floating Frames,

Introduction to Forms, Form Tags and attributes, Form controls: Text Field, Password

Field, Multiple Line Text area, Drop Down list, Check Box, Radio Buttons, Scrolled List,

Reset Button, Submit Button, File field

Unit VI Introduction to Web Architecture and Hosting Hours:06

Introduction to Information Architecture, Visualizing Information Architecture, Information, Architecture Components, Introduction to Website hosting, Domain Name, Web Server, Website Parking, Publishing Website through FTP Core Books:

1. Thomas a Powell: The Complete reference HTML, 3rd Edition, McGraw Hill,2001. 2. A. Whyte: Basic HTML, 2nd Edition, Payne-Gallway, Oxford, 2003.



3. Peter Morville & Louis Rosenfeld, Information Architecture for WWW , 3rd Edition, O’Reilly Publication, 2006. 4. Farrar : HTML Example book, BPB,2007. Reference Books:

1. Karl Barksdale, Shane Turner : HTML and Java Scripts Basics, 4th Edition, Course Technology,2006.

2. Shelly Woods: HTML introductory concepts and techniques, 5th Edition, Course Technology,2009.

3. Jon Dukett: Beginning Web Programming with HTML,XHTML and CSS,Wrox Publication.

Web References:

1. www.w3schools.com/html [ For HTML tutorials]

2. html.net/tutorials/html/ [ For HTML tutorials]

3. www.htmlgoodies.com/ [ For HTML resources]

4. https://developer.mozilla.org/en-US/learn/html [ For HTML best practices]

http://www.w3schools.com/html

http://www.htmlgoodies.com/

https://developer.mozilla.org/en-US/learn/html



HS 111: STUDY OF ENGLISH LANGUAGE AND LITERATURE

(100 Marks)

Theory – 2 hours per week

Objectives of the Course: To help learners to develop familiarity with and proficiency in English language, learn the use of language at personal, academic and professional fronts, become accomplished, active readers who appreciate ambiguity and complexity, and who can articulate their own interpretations with an awareness and curiosity for other perspectives, gain a knowledge of the major traditions of literatures, and an appreciation for the diversity of literary, cultural and social voices within

Prerequisite: None

Learning Outcomes: At the end of the course, the students should have developed the ability to communicate effectively, they should be able to communicate message accurately, handle intercultural situation that require thoughtful communication, to use appropriate words and tones and so on. They should be able to understand and demonstrate communicative and functional use of English language. They should be able to appreciate literature and understand socio-cultural context. Instructional Methods & Pedagogy: Teaching will be facilitated by reading material, discussion, task-based learning, projects, assignments and various interpersonal activities like case studies, critical reading, group work, independent and collaborative research, presentations, etc.

Unit No.

Title of the Unit Minimum Number of

Hours 1 Communicative English

Introduction to Communicative Grammar and Usage

Parts of Speech

Tenses and Moods

Reading Literature for English Language

08

2 Functional English

Introduction to Functional English English for Personal and Social Use English for Career and Professional Use

08

3 Literature Text and Appreciation

Introduction to Literature and Appreciation

Appreciation of Prose or Fiction

08



Appreciation of Poetry

4 Language, Literature and Contemporary Issues

Language, Culture and Society Literature and contemporary issues

06

Total 30

Reference Books:

1. Hurd Stella (2005), Success with Languages , Routledge

2. John Eastwood (2002) Oxford Practice Grammar, Oxford

3. Loiuse Mullany & Peter Stockwell (2010),Introduction to English Language, Routledge

4. Peter Brooker, Raman Saledan & Peter Widoowson (2005), Reader’s Guide to Contemporary literary theory, Pearson

Web References:

http://www.ocr.org.uk/Images/72885-level-2-functional-skills-english-underpinning-skills-support-material-for-learners.pd





CA105: Fundamental concepts of programming language

(200 Marks)

Credit Hours: 07 Objectives of the Course: Understand the significance of an implementation of a programming language in a compiler or interpreter. Increase the capacity to express programming concepts and choose among alternative ways to express things. How to define problem and solution outline. Logic developments tools, Testing of Logic, C Programming Language concepts.How to Compile, Run and Document the program. To make students understand the simple programming paradigms and to develop in the students the ability to design an appropriate logic to solve a specific problem requiring these paradigms and to implement such logic using “C” computer language as a tool. Prerequisite: None

Learning Outcomes: Upon successful completion of the course, the students will learn fundamental concepts of computer programming concepts.

Instructional Methods & Pedagogy: During theory lectures illustrations of certain real world problems, which are to be solved using computers, will be discussed. Logic development tools will be introduced for solving such problems and “C” computer language will be introduced as a tool. During Practical sessions, students will be required to Develop Computer programs in “C” in order to solve moderate size real world problems.

Unit No.

Title of the Unit Minimum Numbers of hours

Theory Practical

1 Introduction to Programming and Overview of ‘C’

07

36

2 Basic Concepts 08 3 Conditional Branching, Iterative

Execution and Library Function 10

4 Array, Handling of Character string, User defined data types, Enumerations and Bit fields

10

5 Structure, Union & User Define Function

07

6 Pointer 06



Total: 84



Detailed Syllabus:

Unit I: Introduction to Programming and Overview of ‘C’ Hours:07

Programming, PL Generations, Compiler, Interpreter, Linker & Loader. Classification of Programming Language, Structured Programming concepts. Algorithmic Presentation of Problem, Development of Algorithm. Introduction to Programming language “C”, Structure of “C” Program, Simple C Program

Unit II: Basic Concepts Hours:08

Understanding of Identifier, token, Keywords. Basic data type in C. Declaration and use of variable and constant. Storage Class and lifetime of variable. Basic Screen and keyboard I/O in C, Formatted and non-formatted I/O function.

Operators: Arithmetical, Assignment, Equality, Relational, Logical and Bit-wise.

Unit III: Conditional Branching, Iterative Execution and Library Function Hours:10

Introduction of branching, iteration and jumping. Test condition and test expression. Conditional execution and selection. Iteration and repetitive execution. Special control statements. Various Library Functions

Unit IV: Array, Handling of Character string, Enumerations and Bit fields Hours:10

Array: One dimensional, two dimensional and multi dimensional. One dimensional character array and character string. String manipulation functions. Enumeration types. Bitfields.

Unit V: Structure, Union & User Define Function Hours:07

User defined data types using structure and union. Function – concepts, scope and storage classes. Function and its categories. Recursion.

Unit IV: Pointers Hours:06

Understanding of memory address and address operator (&). Void pointer, null pointer. Use of pointer: Array and pointer. Pointer and String. Pointer Arithmetic. Pointer to Pointer. Pointer to function. Pointer to Array and String. Concepts of Dynamic memory allocation.



Core Books:

1. Pradip Dey and Manas Gosh: Programming in “C”, 1st Edition, Oxford, 2007.

2. Brian Kernighan and Dennis Ritchie: C Programming Language, 2nd Edition,

Pentice-hall publication.

3. R.G.Dromey: How to Solve it By Computer, Pentice-hall publication.

4. Behrouz A. Foruuzan & Richard F.: A Structured programming Approach Using

“C”, 3rd Edition, Course Technology.

Reference Books:

1. Jean-paul Trembly and Paul Sorenson: An Introduction to data structure with

applications, 2nd Edition, 1984.

2. Yashwant Kanitkar: Let us C, 8th Edition, BPB Publication.

3. Herbert Schildt: C- The Complete Reference, Tata McGraw Hill

4. E.Balagurusamy: Programming in ANSI C, 4th Edition, Tata McGraw Hill, 2007.

Web References:

1. http://studytipsandtricks.blogspot.in/2012/08/important-points-about-c-

language.html [ For User Defined Function examples]

2. http://www.dummies.com/how-to/content/the-importance-of-the-main-

function-in-c-programmi.html [ For explanation of main() function and its

implications]

3. http://answers.yahoo.com/question/index?qid=20110511020801AAcCxaV [ For

tutorials of C programming]

4. http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0

CFQQFjAG&url=http%3A%2F%2Fwww.iimchyderabad.com%2FMaterial%2Fcnote

s.pdf&ei=GzpmUsSjEoj8rAfB94H4CQ&usg=AFQjCNHjQ35TkD2tE2aCDcKuxgWen

MZWHw&bvm=bv.55123115,d.bmk [ For detailed material of C Programming]

http://studytipsandtricks.blogspot.in/2012/08/important-points-about-c-language.html

http://studytipsandtricks.blogspot.in/2012/08/important-points-about-c-language.html

http://www.dummies.com/how-to/content/the-importance-of-the-main-function-in-c-programmi.html

http://www.dummies.com/how-to/content/the-importance-of-the-main-function-in-c-programmi.html

http://answers.yahoo.com/question/index?qid=20110511020801AAcCxaV

http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0CFQQFjAG&url=http%3A%2F%2Fwww.iimchyderabad.com%2FMaterial%2Fcnotes.pdf&ei=GzpmUsSjEoj8rAfB94H4CQ&usg=AFQjCNHjQ35TkD2tE2aCDcKuxgWenMZWHw&bvm=bv.55123115,d.bmk






CA106: Database Fundamentals

(200 Marks)

Credit Hours: 07

Objectives of the Course: The main aim of the course is to introduce database fundamentals to the students. With this course we shall demonstrate database development activities and prepare students for proficiency in developing database for commercial applications. Prerequisite: Basic knowledge of working with computer. Learning Outcomes: At the end of the course, the students will be able to understand the fundamentals of database development and management. Upon successful completion of the course, the students will also be able to design and create database, define queries for database management and data retrieval. Students shall be able to learn and apply the basic database concepts in real world applications. Instructional Methods & Pedagogy: During the theory lectures, concepts for data storage will be discussed. Also DBMS and RDBMS concepts will be discussed in depth. The database applications used in the real world will be discussed with necessary examples. During the laboratory hours students will implement the concepts that are discussed during lecture.

Unit No.

Title of the Unit

Minimum Number of Hours

Theory Practical

1 Introduction to Database System 04

36

2 Data Modeling using Entity Relationship Model

08

3 Relational Data Modeling 08 4 Database Design Methodology 08 5 Schema Definition, Constraints, Queries 10 6 Advanced Query Processing 10



Total: 84



Detailed Syllabus:

Unit I: Introduction to Database System Hours:04

Basic Concepts: data, database, database systems, database management system Purpose and advantages of Database management system (over file systems) Various data models – ER Model and Relational Model, Three level architecture, Structure of DBMS, Database actors and workers Unit II: Data Modeling using Entity Relationship Model Hours:08 Entity Types, Entity Sets, Attributes, Keys, Relationship Types, Relationship Sets, Roles and Structural Constraints, Weak Entity Types, ER Diagram – Notations and fundamentals, Conversion from ER Model to Relational Model Unit III: Relational Data Modeling Hours:08 Relational Model Concepts, Relational Model Constraints, Relational Model Schemas, Update Operation, Transactions, Dealing with Constraint Violations, Relational Algebra and Calculus Unit IV: Database Design Methodology Hours:08 Functional Dependency and Normalization for Database – Informal Design Guidelines for Relational Schemas, Functional Dependencies, Normal Forms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF), Codd Rules Unit V: Schema Definition, Constraints, Queries Hours:10 Table Fundamentals: Basic Data types, Create Table Command, Viewing Data in the tables, sorting, Insert, Delete and Update Statements in SQL, Modifying the structure of tables, renaming table, truncating table, destroying table. Data Constraints and Functions: - Pseudo columns, Null values, TAB table, DUAL table Operators, Data constraints, Type of data constraints, Modifying constraints, working with data dictionary and use of USER_CONSTRAINTS Functions – introduction, merits and demerits, types of functions Numeric functions, Character functions, Date functions, Conversion functions, Aggregate functions Unit VI: Advanced Query Processing Hours:10



Union, Intersect and Except Nested Queries – Introduction, Co-related Nested Queries, Set Comparison Operators Aggregate Operators, Group By clause, having clause, Order by clause Null Values – Comparison using Null Values, Logical Connectivity – AND, OR and NOT, Impact on SQL constructs, Joins (Inner Join, Outer Join, Self Join, Equi Join, Cross Join) Complex Integrity Constraints in SQL – constraints over single table, domain constraints and distinct types Creation and manipulation of database objects – indexes, views, sequences and synonym Note: In laboratory sessions, students should learn conversion from ER Model to Relational Model Core books:

1. Fundamentals of Database Systems – 5th Edition, Ramez Elmasri, Shamkant B.

Navathe, Pearson Publication

2. SQL, PL/SQL – The programming Language Oracle-by Ivan Bayross

3. Database Management Systems – Third Edition by Ramkrishnan, Gehrke.

McGrawHill Publication

Reference Books: 1. Database System Concepts- Silberschatz, Korth, Sudarshan, Fifth Edition, McGraw

Hill

2. An Introduction to Database Systems, C.J.Date, a Kannan, S Swaminathan, Pearson

Education, Eighth Edition (2006) (Equivalent Reading)

3. Oracle 9i, PL/SQL Programming by Scoot Urban, Oracle Press

4. Database Systems: Concepts, Design and Applications, S. K. Singh. Pearson Education

5. Database Systems: Design, Implementation and Management, Peter Rob, Carlos

Coronel, Cengage Learning, seventh edition (2007)

6. Practice book on SQL and PL/SQL by Anjali, Amisha, Roopal and Nirav publications.

7. Database management Systems, Leon and Leon, Vikas Publication

Web References:

1. http://www.microsoftvirtualacademy.com/training-courses/database-

fundamentals#?fbid=tbZ92pOp_Tt [For overall subject]

http://www.microsoftvirtualacademy.com/training-courses/database-fundamentals#?fbid=tbZ92pOp_Tt

http://www.microsoftvirtualacademy.com/training-courses/database-fundamentals#?fbid=tbZ92pOp_Tt



2. http://www.ntu.edu.sg/home/ehchua/programming/sql/Relational_Database_Design.html

[for relational database design]

3. http://docs.oracle.com/cd/A97335_02/apps.102/a81358/05_dev1.htm [For ER Diagram]

4. http://plsql-tutorial.com/ [For PL/SQL]

http://www.ntu.edu.sg/home/ehchua/programming/sql/Relational_Database_Design.html

http://docs.oracle.com/cd/A97335_02/apps.102/a81358/05_dev1.htm

http://plsql-tutorial.com/



CA107: Fundamentals of Commerce and Business Processes

(100 Marks)

Credit Hours: 04

Objectives of the Course: This syllabus is designed to impart the basic knowledge of four major components of Commerce, namely Finance, Business entities, Banking and Human Resource & Marketing Management. Prerequisite: No additional Prerequisite required.

Learning Outcomes: Upon successful completion of the course, the students will learn fundamental concepts of commerce and become familiar with the importance of prudential financial management and the factor it plays in the success or failure of businesses and organizations.

Instructional Methods & Pedagogy: During theory sessions, the basic terminology along with concrete Illustrations will be discussed. The fundamentals in relation with different industries will be taught and demonstrated so that students can visualize the various business entities and commercial processes.

No. Title of the Unit Minimum Number of Hours Theory

1. Basics of Accounts 09 2. Cost Accounting 07 3. Financial Management 08 4. Business entities 08 5. Banking 07 6. Human Resource & Marketing

Management. 09


Total: 48

Detailed Syllabus: Unit I: Basics of Accounts (09 Hours) Introducing the concepts of Accounting principles and convictions, objectives of Financial Accounting, Double Entry Book-keeping System, recording financial transaction,preparation of Statutory Financial Statements, Profit & Loss account:



(Balance sheet, Cash flow Statement), analysis of Financial Statement: (Ratio Analysis, Common size B/S, Comparative Financial Statement).

Unit II: Cost Accounting (07 Hours) Meaning of Cost, Costing and Cost Accounting, Methods of Costing, Marginal Costing, Break-even Analysis, Make or buy decision. Unit III: Financial Management (08 Hours) Meaning and functions of Financial Management, Sourcing of funds and cost of funds, Optimum utilizations of funds, Time value of money, Investment decision, Dividend decision, Working Capital Management, Cash flow,Taxation. Unit IV: Business Organization (08 Hours) Forms of business organization, sole proprietorship firm, Partnership firm, Joint stock Company, Co-operative Society. Unit V: Banking (07 Hours) Introduction to Banking, Deposits Management, Types and Schemes, Management of Advances, Types of Management, Banking Services, Banking Products. Unit VI: Human Resource & Marketing Management (09 Hours) Human Resource: HR planning in context of software industries, Selection, Development and Training, Welfare and working conditions. Marketing Management: Selling and Marketing comparison, Core concepts of marketing, Pricing Decisions, Advertising and Sales promotion. Core books: 1. Dr. S.N. Maheshwari: Financial Accounting, Sultan Chand Publication.

2. I.M.Pande: Financial Management.

3. V.S.P. Rao: Human Resource Management.

Reference books: 1. Dr. S.N. Maheshwari: Advanced Accounting, Sultan Chand Publication.

2. M.N. Arora: Advanced Cost Accounting, Himalaya Publishing House



3. B.S.Mathur: Banking Law & Practice.

Web References: 1. http://iws.collin.edu/ost/pdfs/ACNT1303/ACNT1303lecture_notes.pdf [Introduction

of Accounting]

2. http://www.ucosbdc.org/Websites/ucosbdc/Images/accounting_basics.pdf

[Accounting Equation, Balance Sheet]

3. http://wiki.svtuition.org/2009/03/basic-accounting-notes.html [Area of Accounting,

Accounting Elements]

4. Training and Development Practices In Indian Hotel Industry: An Empirical

Investigation International Journal of Marketing and Human Resource Management

(IJMHRM), Volume 1 * Issue 1 * May 2010,

http://www.iaeme.com/MasterAdmin/UploadFolder/paper4.pdf [Human

Resources]

5. Making Better Marketing Decisions Faster with Accounting Data

http://www.omicsgroup.org/journals/making-better-marketing-decisions-faster-

with- accounting-data-2168-9601.1000e116.pdf [Marketing Management]

6. How small businesses master the art of competition through superior competitive

advantage,http://www.aabri.com/manuscripts/121156.pdf[Marketing

Management]

http://iws.collin.edu/ost/pdfs/ACNT1303/ACNT1303lecture_notes.pdf

http://www.ucosbdc.org/Websites/ucosbdc/Images/accounting_basics.pdf

http://wiki.svtuition.org/2009/03/basic-accounting-notes.html

http://www.iaeme.com/MasterAdmin/UploadFolder/paper4.pdf

http://www.omicsgroup.org/journals/making-better-marketing-decisions-faster-with-%20accounting-data-2168-9601.1000e116.pdf

http://www.omicsgroup.org/journals/making-better-marketing-decisions-faster-with-%20accounting-data-2168-9601.1000e116.pdf

http://www.aabri.com/manuscripts/121156.pdf



CA108: Mathematical and Statistical foundations

(100 Marks)

Credit Hours: 04

Objectives of the Course: The primary objective of this course is to cover concepts which are essential to student who does any mathematical computation in computer sciences. To acquaint the students with the Statistical techniques required for solving certain Real world problems at the end of the course the students should be able to tackle moderate size real world problems using appropriate techniques.

Pre-requisite: None Learning Outcomes: Upon successful completion of this course, the students should be able to apply various mathematical & statistical methods to solve out real world problems. Instructional Methods & Pedagogy: During Theory lectures illustrations of certain real world problems requiring Algebraic, Numerical computations and Statistical inference will be explained.

No. Title of the Unit Minimum Numbers of

hours

Theory

1. Sets, Relations and Functions / Set Theory

09

2. Matrices and Determinants 07

3. Differentiation & Integration 09

4. Basic Statistics 07

5. Probability 08

6. Linear Programming Problem 08


Total: 48

Detailed Syllabus:

Unit I: Sets, Relations and Functions Hours:09

Sets: Number systems (Real and Complex numbers), Cartesian product of sets



Relations: One-One, Many-One, One-Many, Many-Many Relations Functions: Certain Standard functions (Polynomial, Algebraic, Exponential, Logarithmic, Trigonometric), Functions of several variables, graphical representations of function Group: Semigroup, subsemigroup, Monoid, submonoid group, abelian group, permutation group, multiplicatibe abelian group, cyclic group Subgroups: Cosets, right cosets, left cosets, normal subgroups, quotient groups, isomorphism, homomorphism, automorphism

Unit II: Matrices and Determinants Hours:07

Matrices, Matrix Operations, Properties of Matrix Operations, Determinants (up to order 3) and their properties, Cofactor expansion, The Inverse of a Matrix, The Rank of a Matrix and Applications, Eigen values and Eigen vectors

Unit III: Differentiation & Integration Hours:09

Concept of Limits: Evaluation Techniques, Continuity of functions, Concept of Differentiation Derivatives of Standard Functions, Evaluation Techniques, Derivative as a Rate of Change Indefinite Integrals (Primitives / Anti derivatives): Primitives of Standard Functions, Methods of Integration, Definite Integral, and Integration as Area under the curve

Unit IV: Basic Statistics Hours:07

Basic Concepts of Statistics: Basic vocabulary of Statistics, Presenting Data in Tables and Charts, Difference between group and ungroup data Measures of Central Tendency: Mean, Median, Mode for Group and Ungroup data Measure of Dispersion: Range, Mean Absolute Deviation, Variance, and Standard Deviation for group data

Unit V: Probability Hours:08

Basic concepts of Probability: Events, Sample spaces, Contingency Tables and Venn diagram, Simple Probability, Joint Probability, marginal Probability, Conditional probability, Baye’s Theorem Concept of Probability Distribution: Standard Probability Distributions (Binomial, Poisson, Exponential, and Normal)

Unit VI: Linear Programming Problem Hours:08



Overview of Operations Research: Features and Advantages of Operation Research. Linear Programming: Structure and mathematical model of linear programming Problem, Linear Programming Model Formulation, Graphical Method, Simplex method, Big-M method, Duality in Linear Programming.

Core Books:

1. J.P.Tremblay & R. Manohar: Discrete Mathematical Structures with Applications to

Computer Science, Tata McGraw Hill, 1997.

2. Dr. K.R.Kachot, Dr. L.K.Patel & Dr. T.P.Singh: Linear Algebra and Graph Theory,

Mahajan Publication House.

3. Mourice D. Weir, Joel Hass & Frank R. Giordano: Thomas’ Calculus, 11th Ed.,

Pearson, 2008.

4. David M. Levine, Timothy C. Krehbiel, Mark L. Berenson & P.K. Viswanathan:

Business Statistics – A First Course, 5th Ed. Pearson.

5. J.K.Sharma: Operations Research Theory & Applications 5th Ed. Macmillan

Reference Books:

1. Hogg & Tannis: Probability and Statistical Inference, Sixth Ed., Prentice-Hall, NJ, USA,

2000.

2. Larsen & Marx: An Introduction to Mathematical Statistics and Its Applications, Third

Ed., Prentice Hall, NJ, USA, 2001.

3. Dr. S.P.Gupta: Statistical Methods: Sultan Chand & Sons.

4. V Krishnamurthy, V.P. Mainra, J.L. Arora: An Introduction to Linear Algebra, East

West Press.

Web References:

1. http://www.mathtutor.ac.uk/differentiation [For Differentiation & Integration] 2. http://www.mathsisfun.com/data/ [For Probability] 3. http://www.msubillings.edu/BusinessFaculty/Harris/LP_Solve2.htm [For Linear

Programming Problem] 4. http://www.sce.carleton.ca/faculty/chinneck/po.html [For Optimization Techniques]

http://www.mathtutor.ac.uk/differentiation

http://www.mathsisfun.com/data/

http://www.msubillings.edu/BusinessFaculty/Harris/LP_Solve2.htm

http://www.sce.carleton.ca/faculty/chinneck/po.html



HS101: Liberal Arts

(100 Marks)

Practical – 2 hours per week

Objectives of the Course: To help learners to

recognize the nature of aesthetic values and explore elements of arts and aesthetics with reference to personal, cultural and civic sphere

connect art and aesthetics with Science and Technology to understand and extend research and innovation for a society

Pre-requisite: None Learning Outcomes: At the end of the course, students will have developed the ability to enjoy, interact with and perform arts and aesthetics; and will have developed the ability and creativity to transfer sense of design and innovation in science and technology. Instructional Methods & Pedagogy: Teaching will be practical based on the hands on experiences, live and interactive sessions. It may also run in the workshop mode.

Students may select any one course from the following:

Sr. No. Course Code Course Title(s) Credits

1

HS 101

Painting

02

2 Photography

3 Sculpting

4 Music

5 Drama and Dramatics

6 Yoga

7 Dance

8 Pottery and Ceramic Art

9 Media and Graphic Design