Information Technology for Management

Paper Code: 
MAM 127
Credits: 
60
Contact Hours: 
4.00
Objective: 

This course has been designed to introduce the students to applications of computers to manage different operation of organizations. It provides them an opportunity to study the hands-on implementation of different technologies in corporate environment.

12.00
Unit I: 
Information Management:

Introduction, Classification of Information, Current trends in information Technology. Spread Sheet: Introduction, operations on spreadsheet and workbooks, Filling series, sort, and Formatting worksheet. Basic Spread Sheet Functions: cell referencing (Relative, Absolute, Mixed). Inbuilt function (SUM, AVERAGE, COUNT, MAX, MIN, IF), Protecting worksheets ,Charts in Excel: types, create chart from adjacent data/ nonadjacent data, data series, editing and formatting ,printing chart

12.00
Unit II: 
Sensitivity Analysis using Spread Sheet

Filter, Advance Filter, Goal Seek, Solver, Scenario Manager, Consolidate, Subtotal, V lookup, H Lookup, pivot table, pivot chart, Freeze Panes. Advance Spread Sheet Functions & tools: Logical Function, Date and time function, Financial function, macro, OLE (object linking and embedding).

12.00
Unit III: 
Management Information System

MIS Definition, Nature & Scope, MIS Characteristics, Functions, Structure of MIS, Role of MIS, MIS as a Control System, , MIS & decision-making, Applications of MIS: Introduction, personnel, production, materials, marketing management.

12.00
Unit IV: 
Database Management System:

Introduction, Types of Database, System Decomposition, MS Access : database structure, Data types, Creating Tables, table fields, Primary keys and field validation and record validation rules, multiple tables , relationships , Sort & Filter in table, Select data with queries: Creating query by design & by wizard, Creating basic forms & Reports.

12.00
Unit V: 
E –Commerce & Recent Trends in IT-

Introduction to E-commerce , E-Business Fundamentals, Different types of E business model as B2B, B2C, C2C, C2B,G2C. Recent Trends in IT:- Wireless Access Technologies, GSM, GPS, GPRS, Bluetooth, Infrared, 3G & 4G technologies, RFID.

References: 

• Henry C. Lucas, Information Technology for Management, McGraw Hill, International Edition, July 2015.
• Kenneth C. Laudon & Jane P. Laudon, Management Information System, Global Edition, Pearson Education, 2015.
• Waman Jawadekar, Management Information System: Text and Cases, Tata McGraw Hill, June 2015.
• Martin, Hansen, Klingher & Beth,“Mastering Excel 2000”,BPB Publications, 2013.
• Barbara C McNurlin, Ralph H Sprague Jr., Information Systems Management In Practice, Sixth Edition, Tata Mc Graw Hill, 2012
• Luiz Antonio Joia,IT- Based Management Challenges and Solutions, Idea Group Publishing, 2012.
• Stephen Haag, Maeve Cummings, Management Information Systems for the Information Age, 4th Edition, Tata McGraw Hill ,2012

Academic Year: