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.
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.
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.
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
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.
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.
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
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).
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.
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
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.
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.
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.