Information Technology for Management

Paper Code: 
MIB 123
Credits: 
4
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

This paper has been designed to introduce students to the applications of computers to manage different data management operations in an organizations. It provides them an opportunity to study the data management for various managerial operations and handling data in corporate environment.

 

Learning outcomes: On completion of this paper students will-

  • Work on spreadsheets and employ basic functions to handle data.
  • Work on advanced inbuilt functions available in spreadsheet software for data analysis
  • Work on managerial and financial functions, create charts, perform statistical analysis through spreadsheet software
  • Work on database management software to manage data for effective information management
  • Understand current trends of e commerce operations and online financial transactions

 

12.00
Unit I: 
Information Management

Introduction, Classification of Information

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,  COUNTIF, CEILING, FLOOR, TRUNC, ABS, , INT, LOG, MOD, POWER, ROUND, EXP, IF, AND, OR), Date & Time functions (NOW, DATE, TIME, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND) 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

12.00
Unit III: 
Financial Function and Database Management

Financial function: FV, PMT, IPMT, NPER, NPV, PV, RATE, OLE (object linking and embedding).

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
 

 

12.00
Unit IV: 
Multiple Tables and Creating queries, Forms and Reports

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 model as B2B, B2C, C2C, C2B, G2C. Recent Trends in IT:-  Wireless Access Technologies, Types of payments (Credit Card, debit card, online payments, e wallet, upi app based payments etc.)  Bluetooth, wifi, RFID.

Essential Readings: 
  • Martin, Hansen, Klingher & Beth, “Mastering Excel 2000”, BPB Publications, 2013.
  • Wayne L.Winston, “Excel  Data Analysis  and Business Modeling”, 2010
  • John Walkenbach, “Excel 2016 Bible”, Wiley
  • Chandan Sengupta, “Financial Analysis and Modeling using Excel and VBA”, Wiley
  • Michael Alexander, Richard Kusleika, “MS Access 2013 Bible”, Wiley      
  • David Whiteley, “E-Commerce”, Tata McGraw Hill
  • PT Joseph, S.J., “E-commerce: An Indian Perspective”, Third Edition, PHI
  • Henry C. Lucas, Information Technology for Management, McGraw Hill, International Edition, July 2015.

 

ACADEMIC YEAR: 
2021-2022
  • Printer-friendly version
  • PDF version