Information Technology for management

Paper Code: 
MTM 127
Credits: 
4
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: 
Unit I

Information &Database Management System:– Introduction, Classification of Information, Methods of Data & Information Collection, Value of Information, Database Management System:Introduction, Types of Database,  System Decomposition, Integration of Sub Systems, Current trends in information  Technology.

 

12.00
Unit II: 
Unit II

Management Information System & Strategic Issues of IT: - MIS Definition, Nature & Scope, MIS Characteristics, Functions, Structure of MIS, Role of MIS, MIS as a Control System, IT Application in Management, Strategy for Integrating Information Technology with Business Environment.

12.00
Unit III: 
Unit III

Internet& Recent Trends in IT- Internet Tools & Services, Introduction to E-commerce and ERP.Recent Trends in IT:-  Wireless Access Technologies, GSM, GPS, CDMA, GPRS, Bluetooth, Infrared, 3G & 4G technologies, RFID; E-Business Fundamentals.

12.00
Unit IV: 
Unit IV

What if analysis with Spread-Sheet Various Tools & Functions: Filling series fill with drag, data sort, Formatting worksheet, Functions and its parts, Some useful Functions in spreadsheet (SUM, AVERAGE, COUNT, MAX, MIN, IF), Cell referencing (Relative, Absolute, Mixed), Renaming sheet, Printing worksheet.

12.00
Unit V: 
Unit V

Decision Making& Advance Spread-Sheet Tools-: Strategic, tactical & Operational information for Making decisions, EIS. Advance Spread-Sheet Tools- Goal seek, Finance Functions & advance Auto Filter, V look up, H-look up, Scenario, Sub-total, Macro, Protection.

Essential Readings: 
  • Leidner Dorothy, Turban Efrain, Information Technology for Management, 6th Edition, Wiley India, 2012.
  • 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
  • Henry C. Lucas, Jr., Information Technology: Strategic Decision Making for Managers, John Wiley & Sons Inc., 2012.

 

References: 
  • Henry C. Lucas, Information Technology for Management, McGraw Hill, International Edition, July 2013.
  • Kenneth C. Laudon & Jane P. Laudon, Management Information System, Global Edition, Pearson Education, 2013.
  • Waman Jawadekar, Management Information System: Text and Cases, Tata McGraw Hill, June 2013.
  • Martin, Hansen, Klingher & Beth,“Mastering Excel 2000”,BPB Publications, 2013

 

Academic Year: