institute of management studies, devi ahilya ... - mba _ec_ 2... · institute of managem ent...

Institute of Management Studies, Devi Ahilya Vishwavidyalaya, Indore

Syllabus OF MBA (EC) – Semester III ( 2 years Programme)

July-Dec 2012 Elective: VB.NET

Elective Group: A Subjects

1. Visual basic programming

Using .NET Platform 2. SQL server 2008

3 Common Architecture in JAVA 4. J2EE Programming 5. Internet Marketing

6. BUSINESS TRANSFORMATION TOOLS &TECHNIQUES

7. Search Engine Optimization Methods. 8. International Business. 9. e-Commerce Application Development using PHP.

10. Financial Management

Institute of Management Studies Devi Ahilya Vishwavidyalaya, Indore

MBA EC (2 years programme) Semester III

VB.NET Programming

OBJECTIVE : The objective of this course is to provide the students basic knowledge of VB.NET application development special reference to e-commerce.

EXAMINATION: The semester examination is worth 60marks and 40marks for internal assessment. Students will have to answer five questions out of 7/8 questions Contents

1. Introduction To .net Framework a. What is .net framework b. Base Class Libraries c. Common Language Runtime

2. Introduction to Windows Application a. Creating the Windows Form using the Windows Form Designer b. Implement navigation for the user Interface c. Language Basics d. Coding Standards e. Debugging your application

3. Working With Controls a. Introduction to controls available for windows application b. Add Controls To Windows Forms c. Validate User Input d. Error Handling e. Object Oriented Programming implementation

4. Using Data in Windows Forms Applications a. Introduction to ADO.net Architecture b. ADO.net Components c. Accessing the data using ADO.net

5. Deploying Windows Forms Applications a. Plan the Deployment for windows based application b. Creating the setup program to install the application c. Deploy the windows based application

References:

1. VB.Net ( Beginners ) Wrox Publication 2. VB.Net ( Professional ) Wrox Publication 3. VB.Net Black Book 4. VB.Net By Microsoft press


MBA EC (2 years programme) Semester III

SQL Server 2008

Course Objective :

The objective of the course is to provide the students with a conceptual, analytical & Technical framework of SQL Server 2008

Examinations : The semester examination worth 60 marks will contain 7/8 questions out of which 60 marks are for exam

Course Contents :

About SQL Server?

1. SQL Server Editions 2. Installing SQL Server : Planning for Installation, selecting Installation type, Creating Instance etc. 3. Selecting Login security method, configure login security Basics of Database Design

1. Normalization 2. Introducing SQL Server Management Studio 3. Understanding Logical Data Modelling 4. Creating a Database 5. Adding Tables 6. Creating Indexes and Constraints 7. Building Relations

T-SQL Basics

1. What is SQL? 2. Syntax Conventions 3. Executing SQL Statements 4. Identifiers 5. Creating Data Types, Operators, Variables, Functions 6. Using SQL to Build and Alter Objects


SELECT queries 1. The SELECT / FROM/ WHERE / ORDER BY / GROUP BY AND HAVING Clause /

Using TOP N 2. Inner Join, Self Join, Outer Join and Cross Join 3. Basic SQL SELECT and SELECT INTO Statements 4. Sorting SELECT Query Results with ORDER BY 5. Nested & Correlated Sub queries, Union 6. Date & Time, String and Math System Functions 7. Dynamic SQL for Automatic Query Generation 8. The GROUP BY Clause & Aggregate Functions

Action Queries (DML)

1. DELETE / INSERT / UPDATE 2. INSERT INTO Statement with VALUES Clause 3. Understanding INSERT and SELECT Subquery 4. Data Removal with the DELETE Statement 5. Data Modification with the UPDATE Statement

Views, Stored Procedures, and Functions

1. Using Views 2. Using Stored Procedures 3. Using Functions Advanced Transact-SQL

1. Transactions 2. Cursors 3. Structured Error Handling 4. Concept of Commit, rollback Triggers

1. Creating / Altering Triggers 2. Using the Inserted and Deleted Tables 3. Recursive and Nested Triggers

SQL Server 2008 Services

1. The Import and Export Wizard 2. Attaching / Detaching Databases 3. Replication Service 3. Backup of Databases/ Restoring Databases


SQL Server 2008 Reporting Services

1. Using Report Designer 2. Publishing a Report 3. Using Report Builder / Report Manager 4. Security and SQL Server 5. Choosing Service Accounts 6. Authentication Modes 7. Roles / Users / Permissions / Object Ownership

Reference

1. SQL server 2008 by Microsoft general press 2. Wrox publication on SQL server 2008 3. Learn SQL server 2008 in 21 days.


MBA EC (2 years programme) - Semester III

Common Architecture in JAVA

Course Objective:

The objective of the course is to provide the students with a conceptual, analytical & Technical framework of Common architechture in JAVA

Examination: The semester examination worth 60marks will contain 7/8 questions out of which marks are for internal test and remaining 40marks will be for assignment, laboratory work, 20 online viva etc.

Course content:

Unit 1

Common Structure, Introduction to design patterns: singleton, observer, adapter Jar/War/Ear

Unit 2 Framework Introduction: Common Framework in J2EE

MVC architecture/frameworks : Benefits Unit 3

Web application frameworks: Struts Unit 4

Unit 5

Struts: Introduction, Benefits, Tag libraries, Types of Action Form, Types of Action Class Validation in Struts

Textbook(s):

1.Head First Design Patterns Freeman; O’Reilly ISBN: 0-596-00712-4 2. Pattern-Oriented Software Architecture, Volume 1, A System of Patterns by Frank Buschmann, et all, ISBN: 0-471-95869-7

3. Pattern-Oriented Software Architecture, Volume 2, Patterns for Concurrent and Networked Objects by Douglas Schmidt, Michael Stal, Hans Rohnert, Frank Buschmann. SBN- 0471606952



J2EE Programming

Course Objective: The objective of the course is to provide the students with a conceptual, analytical & Technical framework of J2EE Programming Examination: The semester examination worth 60marks will contain 7/8 questions out of which marks are for internal test and remaining 40marks will be for assignment, laboratory work, 20 online viva etc.

Course content: Unit 1 Core J2EE concepts, Core J2EE Technologies and component, J2EE application

programming model

Unit 2 Introduction of web server/ Application server, Deployment of J2EE application on web server, Tomcat introduction, installation and configuration of tomcat, application deployment of tomcat

Unit 3 Detailed description of WEB.XML deployment descriptor

Unit 4 Directory structure in web

Unit 5 JSP ( Java server pages ): Introduction, static and dynamic pages, JSP life cycle, JSP attributes, JSP action tags, Sample application

Unit 6 Servlet: Introduction, configuration of a servlet on a web server, difference between JSP and servlet, servlet life cycle Unit 7 A Sample application using JSP and servlet References:

1. Head first servlet & JSP – by Brian Basham, Kathy sierra and Bert rates 2. Sams Teach yourself Java JSP in 21 days 3. Pure JSP: Java server pages by james goodwill, SAMS



Internet Marketing

OBJECTIVE : The Objective of the course is to provide the students with a conceptual, analytical framework to understand the Internet marketing. The emphasis is on online marketing models & methods of implementation. At the end of the course the students will be able to conceptualize the strategies of internet based marketing practices.

EXAMINATION: The semester examination is worth 60marks and 40marks for internal assessment. Students will have to answer five questions out of 7/8 questions

COURSE CONTENT:

1. Introduction to Internet Marketing: Definition, Scope, Advantages &

Disadvantages, Process, Internet Marketing Vs Traditional Marketing, Internet Marketing Strategies, Functions and Responsbilities of Marketing Managers.

2. E-business models, Search Engine Marketing Strategy, Web Marketing, E-business

deployment, RSS Feed, Social Media Marketing.

3. Pay Per Click Campaign: Google and Yahoo Model, Adwords & Adsense, Content Match Type, CTR, Leads & Conversions, PPC Account Management, Budgeting, PPC Strategies, Gap Analysis.

4. Banner Advertisement & E-mail Marketing: Banner Concept, Banner Placement,

E-mail campaign, Newsletter Campaign, Press Release.

5. Affiliate Marketing: Introduction, Affiliate Networks, In-house Affiliate Programs.

6. W3C Standards: W3C Mark Up Validator, Check link, CSS Validator, P3P Validator, And Semantic Data Extractor.

7. Implementation of strategies: Introducing realistic approach of Internet Marketing

strategies development and implementation.

REFERENCE: 1.Internet Marketing: Strategy, Implementation and Practice by Dave Chaffey. 2.Principles of Marketing by Philip Kotler.



BUSINESS TRANSFORMATION TOOLS &TECHNIQUES

OBJECTIVE : The objective of this course is to provide the students basic knowledge of current business transformation. Technique special reference to IT.

EXAMINATION: The semester examination is worth 60 marks and 40 marks for internal assessment. Students will have to answer five questions out of 7/8 questions

COURSE CONTENT:

1. Overview of ERP, Integrated Information, Accommodating variety, seamless integration, Benefits, Modern Enterprise with ERP. Significance and principles of BE, BPR, ERP, IT, MRP, II. ERP implementation, Role of consultant, vendors, users, post implementation Support , ERP cases: SAP Baan.

2. Core Concepts of TQM. Customers focus. Quality for profits. Tools and Techniques

of TQM:SPC ISO 9000:Concepts.Certifications, methods, implementation.

3. Introduction to BPR: Need application & capacities of BPR. Change theory, Pitfalls in Re-engineering, Re-engineering team, Preparing and planning for change, Designing & implementing processes. Similarity and difference between ERP and BPR.

4. Introduction to SCM. Inventory Management devices, logistic system analysis &

design.

5. Introduction to relationship management, concepts of CRM, Development of CRM. Planning CRM.

6. Using Leading Software Packages for B.T. viz., SAP,Oracle, JDE, MS Business Solutions.

REFERENCE:

ERP Concept & Practice by V.K. Garg, N.Venkitaman PHI Quality in totality Parag Dewan Reengineering the Corporation Michel Hammer & James Champy Supply Chain Management B.S.Sahay. Customer Relationship Management, Jagdish Seth

Institute of Management Studies Devi Ahilya Vishwavidyalaya , Indore

MBA EC (2 years programme)- Semester III

Search Engine Optimization Methods Course Objective:

The objective of the course is to provide the students with a conceptual, analytical & Technical framework of SEO (search engine optimization)

Examination The faculty member will award marks out of a maximum of 40marks for the internal performance of the student. The semester examination carrying 60marks will have eight questions out of which students will be required to attempt any five questions.

1. Introduction to Internet Marketing: Definition, Scope, Advantages &

Disadvantages, Process, and SEO Strategies, Role of Marketing Manager; Functions in Internet Marketing.

2. HTML: Important HTML Tags, Use of HTML Tags, Code Verification &

Validation.

3. Search Engines: Introduction of Search Engines, Search Engines Vs Web Directories, PR concept, SE Algorithms, SERP, SE Crawler, SE Submission & Indexing, Google Dance and Sand Effect.

4. Search Engine Optimization: Industry Analysis, Site Analysis, Competitor

Analysis, Keyword Analysis and Research, Types of SEO-ON-PAGE & OFF-PAGE Meta Creation, Navigation & Linking Strategies, Content SEO, other Supplementary SEO, Static SEO & Dynamic SEO, Landing Page, Call to Actions, SEO Tools, Design Issues, Gsitemap, Page Redirect methods.

12. Link Building Strategies: Linking Concept, Link Exchange, Free & Paid Directory

Submission

13. Web Traffic Analysis: Web Stats Tools, Traffic Analysis, Configuring Tools using wizards, Tracking End-users.

14. Lab Sessions: Introducing the realistic approach of SEO.

References: -

1. Search Engine Optimization for Dummies by Peter Kent. 2. SEO Book by Aaron Walls. 3. Search Engine Marketing by Mike Grehan.



International Business

Course Objective: The objective of the course is to provide the students with a conceptual, analytical & Technical framework of international business.

Examination The faculty member will award marks out of a maximum of 40marks for the internal performance of the student. The semester examination carrying 60 marks will have eight questions out of which students will be required to attempt any five questions.

Course Contents 1. International Marketing: Basis of International Trade, Theories of International Trade Absolute Advantage,

comparative advantage and factor endowment theory) Difference between Domestic, International, Multinational, Global Markets, EPRG Frame work.

2. Scanning of International Environment: Social, Political, Legal, Economic. 3. Factors Affecting International Trade: Methods of Entry, Types of Regional Agreements, Role of IMF and WTO in

International Trade. 4. Foreign Trade Policy: EXIM Policy 2002-2007 Salient features. 5. Export Documentation and Procedures and Institutional support for export promotion in India. 6. Product: Identifying New Products, International Product Planning, Product

Design Strategy, Product Elimination, Adoption and Diffusion of New Products, Branding Strategies.

7. Pricing Strategies: Factors Affecting International Prices, Methods of Pricing, Pricing an International Product, Transfer

Pricing, Exchange Rates and its Impact on Pricing, High Sea Pricing. 8. Distribution System for International Markets: Direct and Indirect Channels,

Factors Affecting International Channel, International Channel Management, Wholesaling and Retailing.

9. Promoting Products / Services in Overseas Markets: Perspectives of International Advertising, Standardization v/s

Localization, Global Media Decisions, Global Advertising Regulations, Industry Self-Regulation.

Text Readings

1. W. J. Keegan – “Global Marketing Management”, New Delhi, PHI, 5th Edn. 1997.

2. Sack Onkvisit and John J. Shaw. “International Marketing Analysis and Strategies”,

New Delhi PHI, 1998. 3. Subhash S. Jain, “International Marketing Management”, Delhi, CBS Publishers

Distributors, 1997.

Suggested Readings

1. M.R Czinkota.and Ronkainen “International marketing”, Dryden Forthworth 1998. 2. S.J. Poliwoda, “International Marketing”, New Delhi, Prentice Hall of India



e-Commerce Application Development using PHP

Course Objective: The objective of the course is to introduce the PHP programming specially with reference to e-Business and e-Commerce.

Examination: The semester examination worth 60 marks will contain 7/8 questions out of which marks are for internal test and remaining 40 marks will be for assignment, laboratory work, 20 online viva etc. UNIT-1: -Web Applications

Web Architecture: Web Servers, Web Browsers. N-tier Architecture. Client & Sever- side Technologies:-CGI, Asp, jsp. Scripting Languages :- Sever Side, Client Side. Working of Web-Server. Introduction to PHP:- History, Advantages and Disadvantage of using php.

UNIT-2: -Basic Language Constructs Layout of Php Program Various type of Comments Variable, Static Variables, Constants Declaration & Scope Output Using Echo, Print String-Single quoted and double quoted Various String Manipulation Functions. Include & Require

UNIT-3: Control & Functions Logical operators, Comparison operators, Ternary Operator. Branching using if-else. Lopping using do-while, while loop, for loop, Break & Continue, Bounded Versus Unbounded Loops. Arrays and Array Functions. Prototype of functions, Declaration and Calling, Function Scope. Formal Parameter v/s Actual Parameters , Recursion.

UNIT-4: Advanced Php Programming

Introduction to oops, Building Blocks of oops-Abstraction, Inheritance, Polymorphism. Basic PHP constructs for oop, constructor destructor. Defining classes, Inheriting a class, Overriding functions, Object Declarations. Exceptions & Exceptions Handling. File Handling & System Functions.

UNIT-5: Passing Information b/w Pages & Generating Dynamic Pages

Http protocol ,GET & POST method, IP Addresses. Connecting to Database, Making Queries. Inserting & Fetching Data Sets. Displaying Formatted Results on web page. Session Management.

Books: PHP & MYSQL Bible Website: www.php.net, www.mysql.org



FINANCIAL MANAGEMENT

Objective The objectives of this course are to help the students learn the concepts, tools and skills of financial analysis and financial management, and application in the efficient conduct of business Examination Scheme: The faculty member will award internal marks out of 40 based on three assessments of 20 marks each of which best two will be considered. The end semester examination will be worth 60 marks. Contents

1. Introduction: Concept, Nature, Scope & Objectives of Financial Management. 2. Leverage Analysis: Definition, Concepts, Types and EBIT-EPS Analysis. 3. Cost of capital: Time value of Money, Cost of Debt, Cost of Preference, Cost of Equity, Weighted Average Cost of Capital. 4. Capital Expenditure Decision: Basic Principles in Estimating Cost and Benefits of Investments. Appraisal Criteria’s; DCF and NON DCF Methods for Evaluating Projects, Evaluating Mutually Exclusive and Independent Proposals. Cash flow Estimation, Identifying Relevant Cash flows, Evaluating Projects with Unequal Life, Adjusting Cash Flow for Inflation. 5 .Working Capital : Concept need and Determinants, Operating Cycle Approach to Working Capital. Inventory Management; Nature of Inventory and Its Role in Working Capital, Types and Costs associated with Inventory, Inventory Management Techniques. Receivables Management; Cost of Maintaining Receivables, Credit Policies Variables(credit standards, credit period, cash discounts) Cash Management; Cash Forecasting and Preparing cash Budgets, Financing Current Assets; Behaviour of Current Assets and pattern of Financing. 6.Capital Structure theories and Divided Policy. Reference Books



Text reading (Latest Edition) 1. Pandey, I.M. financial Management, Vikas Publishing House, New Delhi. 2. Khan M.Y. and Jain P.K. Financial Management, Tata McGraw Hill, New Delhi. 3. R.P. Rustogi “Financial Management”,Galgotia Publication Reprint 2000. 4. S.P. Guptan “ Financial Management” Sahitya Bhavan Publications. Suggested readings 1. Chandra, Prasanna; Financial Management TMH, New Delhi. 2. Van Horn, James C., Financial management and Policy, Prentice Hall of India. 3. S.C. Kuchhal “ Financial Management” Allahabad Chatanya pub. House, 1995. 4. V.K. Bhalla “ Working Capital Management” Second Edition1998 Anmol Publication, new delhi 1998. 5. R.P. Rastogi “ Graded Problems and Solutions in Financial Management” Galgotia Publication New Delhi 5th Edition2000.

institute of management studies, devi ahilya ... - mba _ec_ 2... · institute of managem ent...

Documents