DU DC I, DC II and Applied Course Syllabus - Management Studies
DU DC I, DC II and Applied Course Syllabus - Management Studies
DU DC I, DC II and Applied Course Syllabus - Management Studies
DU DC I, DC II and Applied Course Syllabus - Management Studies
DU DC I, DC II and Applied Course Syllabus - Management Studies

PAPER NO. AC: 3.1

ENTERPRISE RESOURCE PLANNING AND DATA BASE MANAGEMENT SYSTEM

Learning  Objective:  To  teach  students  how  to  manage  data  in  real  world  using  Relational  Database Management System(RDBMS)  package. The basic idea is to create tables, queries, forms, reports that will be required  for performing  day to day business  activities. Also giving  them exposure  to Enterprise  Resource Planning (ERP) covering some of the functional areas like Sales, HR, CRM.

Course   Contents:

Unit I    Lectures: 6

Introduction  to  Database  Development:  Database  Terminology,  Objects.  Working  with  Tables:  Creating Tables,  working  with  fields,  defining  Data  types,  Changing  TABLE  design,  Assigning  Field  Properties, Setting  Primary  Keys,  Indexing,  Designing  bulletproof  Database:  Data  Normalization,   Relationships  & Integrity Rules, Join Properties. Working with datasheet view: Record manipulation, Sorting & Filtering.

Unit II       Lectures: 6

Working with queries: Query by design & by wizard (Select, Make Table, Append, Delete, Cross Tab, Update, Parameterized Query, Find Duplicate and Find Unmatched), Creating multi table queries, creating & working with table joins. Using operators & expressions: Creating simple & advance criteria.

Unit III        Lectures: 5

Working with forms: Creating Basic forms, working with controls, Introducing Properties. Working with Data on  Forms:  Changing  Layout,  Creating  Calculated  controls,  creating  Sub  Forms,  Working  with  Reports: Creating Basic Reports, Creating Header & Footer, Placing Controls on reports, sorting & grouping, Creating Sub reports, working with External Data: Types of External data, Linking External data, Limitation of Linked data.

Unit IV         Lectures: 4

ERP: Installing the OpenERP All-In-One,  Data Base Creation, Familiarize  with user Interface, Configuring Users, Managing Partners, Updating Module List.

Unit V         Lectures: 7

Sales Order Creation, Managing Alerts on products or partners, Keep Track Of your margins, Creating Price List.  Lead  Management,   Converting   Leads  into  Customers   or  Opportunities,   Planning  your  Meetings effectively. Management of staff, Creation of new Contract, Keeping Track of Expenses, Hire New People, to create and manage new evaluation, Holiday Management.

Text Books:

1.       Michael R. Groh (2011). Microsoft Access 2010 Bible. Wiley India Pvt. Ltd.

2.       www.openerp.com, OpenERP All-In-One Software, MS – Access or its equivalent.

References:

1.   Mathew MacDonald. Access 2010 The Missing Manual. O’Reilly Media

2.   Cox Joyce & Lambert Joan (2011).  Step by Step Microsoft Access 2010. PHI Learning Pvt. Ltd.

PAPER No. AC: 4.1

E-ENTREPRENEURSHIP

Learning Objective:   To familiarize with various aspects of E-Entrepreneurship  and issues associated with it.. Emphasis will be on the application of the concepts learnt.

Course Contents:

Unit I           Lectures: 8

Introduction: Concept of E-entrepreneur and E-entrepreneurship. Distinction between E-entrepreneur and entrepreneur.   Classification  of   entrepreneurs.  Theories  of   Entrepreneurship:  Schumpeter,  McLelland  and Drucker.   E-entrepreneurship   education   and   training,   Critical   success   factors   for   E-entrepreneurship. Development of E-entrepreneurship. Barriers and challenges of E-entrepreneurship.

Unit II         Lectures: 6

Ethical   and  legal  issues   in  E-entrepreneurship.   Economic   and  social   impacts   of  E-entrepreneurship, E-entrepreneurship and employment, role of religion and national culture in E-entrepreneurship. E- entrepreneurship and E-society. Women and youth and E-entrepreneurship.  Building of trust and credibility in E-entrepreneurship. E-governance and E-entrepreneurship.

Unit III         Lectures: 5

Introduction   to  E-commerce.   Launching   a  Business   on  the  Internet.E-entrepreneurship  and   business plan.Business  Models:  B2C  (Internet);  B2B  (Internet  and  Extranet);  supply  chain  management,  On-line service sector, E-marketing, social media and availability of tools and technology for entrepreneurship

Unit IV                Lectures: 6

Arrangement of funds – loan syndication, consortium finance & venture capital. Role played by SIDBI, NSIC. Steps in starting SSI’s.  On-Line payment mechanisms, essential requirements of electronic payment. Prepaid electronic payment systems. Post-paid electronic payment systems.

Unit V                      Lectures: 3

Case studies on E-entrepreneurship and innovation in small and medium-sized organizations in developed and developing countries.

Text Books:

1.   Gupta C.B. & Srinivasan (1995). Entrepreneurial development (3rd revised ed.). Sultan Chand Pub.

2.   Greenstein, M. and T.M. Feinman Electronic Commerce: Security, Risk, Management and Control Tata McGraw-Hill

References:

1.   Kalakota, R and A. B. Whinston Frontiers of Electronic Commerce A reading

2.   Oster Walder A and Y. Pigneur Bled, Slovenia, June 2002 “An e-business model  ontology for modelling e-business,” Proceedings of the 15th Bled Electronic commerce.

3.   Bharat Bhaskar Electronic Commerce  (Tata McGraw-Hill)

4.   Casson, M Young, B. Basu, A., & Wadson, N. (Ed). (2008). The Oxford Handbook of Entrepreneurship. New York: Oxford University Press.

5.   Khanna, T. (2008). Billions of Entrepreneurs: How china and India Are Reshaping Their Futures and Yours. Harvard Business School Press.

6.   Mullins, J. (2010). The new business road test: What entrepreneurs and executives should do before writing a business plan (3rd ed.). Harlow: Prentice Hall Financial Times.

PAPER No. AC: 5.1

BUSINESS ANALYTICS AND INTELLIGENCE

Learning  Objective:  Understanding  Business  Intelligence  Methodologies  and implementing  the same  for making strategies and decisions faster by converting data into reliable information using rational approach. Course Contents:

Unit I            Lectures: 2

Introduction  to Business  Intelligence:  Changing  Business  Environment  & Computerized  Decision  Support, Framework & Architecture, Intelligence Creation & Use & Business Intelligence Governance.

Unit II           Lectures: 4

Introduction to Data Warehouse: what is Data Warehouse, why Data Warehouse, Framework and Architecture, Data Warehouse Requirements Management (DWRM) Technique, Data warehouse Development Life Cycle, Online   Transaction    Processing(OLTP)    (Database)    Vs.   Online   Analytical    Processing(OLAP)    (Data Warehouse).

Unit III               Lectures: 4

Data   Warehouse   &   Dimensional   Modeling:   Defining   Dimensional   Model,   Facts,   Dimensions   theirs Relationship & Hierarchies, implementing changing Dimensions, Advanced Dimensional Modeling.

Unit IV           Lectures: 6

Designing  the  Data  Warehouse  &  Extraction,  Transformation  &  loading  (ETL)  Strategies:  Identification cleansing   &  Transformation   of  Data,  Advanced   Extraction,   Transformation   &  loading   process.   Data Warehousing & Online Analytical Processing (OLAP): Introduction to OLAP, OLAP Process Overview, Data Mining for Business Intelligence.

Unit V               Lectures: 12

Business   Intelligence    in   Action   using   Microsoft   SQL   Server:   Hands   on   Database   Management System(DBMS)  using SQL Server Management Studio(SSMS), Hands on ETL using SQL Server Integration Services(SSIS), Hands on OLAP using SQL Server Analysis Services(SSAS), Hands on Reporting using SQL Server Reporting Services(SSRS).

Text Books:

1.   Mohanty, Soumendra. (2006). Data Warehousing Design Development and Best Practices. Tata McGraw Hill.2.   Turban,  Efraim  &  Sharda,  Ramesh  &  Delen,  Dursun  &  King,  David  &  Aronson,  Janine  E.  (2011). Business    Intelligence A Managerial Approach(2nd ed.). Pearson Education.

References:

1.   Dalton, Patrick & Whitehead, Paul. (2007). SQL Server 2005 Black Book (2007 ed.). Dreamtech Press

2.   Brust, Andrew J. & Forte, Stephen (2006). Programing Microsoft SQL Server 2005. Microsoft Press

3.   Anahory, Sam & Murray, Dennis (2002). Data Warehousing in the Real World. Pearson education

4.   Berson, Alex & Smith, Stephen J. (1997). Data Warehousing, Data Mining & OLAP. Tata McGraw Hill

PAPER No. AC: 6.1

PROJECT MANAGEMENT

Learning Objective: To make students learn about concepts of project management through the live projects to build, maintain, and control well-formed  project plans as well as schedule, estimate, coordinate,  control, budget, and staff projects and support other users of Project.

Course contents:

Unit I            Lectures: 7

Understanding  Project  Management  Concepts:  Simple  Scheduling:  Introducing  Project-managing  file  and setting options, Ribbon and Tabs, Views- Working with schedule details; Creating a Task List-Creating a new project  plan,  Entering  task  names,  Entering  Duration,  Entering  Milestone,  Organizing  Tasks  into  Phases, linking tasks, switching  task scheduling  from manual to automatic,  setting non-working  days, checking the plan’s duration, documenting the tasks, Setting up Resources:  Entering resource capacity, Entering Resource Pay  Rates,  adjusting  Working  Time  for individual  resources,  setting  up cost  resources,  documenting  cost resources; Assigning resources to task.

Unit II                 Lectures: 5

Project Performance  Measurement:  Customizing  the Gantt Chart View, Customizing  the timeline view, pan and zoom the Gantt Chart View from the Timeline View, Drawing on a Gantt Chart View, Copying Views, printing  Views,  Customizing  and Printing  Reports;  Tracking  progress  on Task:  Saving  a project  baseline, tracking a project as scheduled, entering a task’s completion percentage, entering actual values for tasks.

Unit III               Lectures: 4

Advanced   Scheduling:   Fine  tuning  task  details:  Adjusting   task  relationships,   setting  task  constraints, interrupting  work  on a task,  adjusting  working  time for individual  tasks,  changing  task types-Assignment units, peak, peak units and the scheduling formula, task types and effort driven scheduling, Entering deadline dates, entering fixed costs, setting up a recurring task, viewing the project’s critical path, scheduling summary task manually, In-activating tasks.

Unit IV            Lectures: 7

Control: Setting up resources availability, Entering Multiple pay rates for a resource, setting up pay rates to apply at different times, setting up, material resources; Fine tuning assignment details: Delaying the start of assignment, applying contours to assignments applying different cost rates to assignments, assigning material resources  to tasks, variable  consumption  rates for material  resources,  viewing  resource  capacity,  adjusting assignments in the team planner view. Examining Resource Allocations over time, Resolving resources over- allocations  manually,  leveling  over-allocated  resources,  checking  the projects’ cost and finish date, Sorting project details.

Unit V           Lectures: 5

Project  Closure/Termination:  Tracking  progress  on  tasks  and  assignments-Updating  a baseline,  saving  an interim plan, Tracking actual and remaining values for tasks and assignments, entering actual costs manually, tracking time phased actual work for tasks and assignments,  re-scheduling  incomplete task work. Recording macros, editing macros, Copying project to other programs, opening other file in projects, saving to other file formats, consolidating projects and resources.

Text Books:

1.  Chatfield & Johnson. (2010). Step by Step Microsoft Project-2010. New Delhi: PHI.

2.  Cox, Lambert, Frye. (2011). Step by Step Microsoft Office Professional-2010. New Delhi: PHI.

Click Here for All Delhi University Courses Syllabus

Leave a Reply