Information Technology for Management

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

Course Outcomes

Learning and teaching strategies

Assessment Strategies

On completion of this course, the

Approach in teaching:

Class test, Semester

students will be able to;

 

CO 13.Create spreadsheets and employ basic functions to handle data.

CO 14.Examine Sensitivity analysis using Spread sheet

CO 15.Analyze data by using advanced inbuilt functions available in spreadsheet software

CO 16.Create charts, perform statistical analysis using managerial and financial functions through spreadsheet software

CO 17.Analyze database management software to manage data for effective information management

CO 18.Examine current trends of e commerce operations and online

financial transactions

 

Interactive Lectures, Group Discussion, Tutorials, Case Study

 

 

Learning activities for the students:

Self-learning assignments, presentations

end examinations, Quiz, Assignments, Presentation

 

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: 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, 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: 

 R. Elmarsi and S.B. Navathe, “Fundamentals of Database Systems”, Addison Wesley, 4th Ed.,
 David Whiteley, “E-Commerce”, Tata McGraw Hill, 2000.2004.
 Microsoft Excel 2016 - Data Analysis and Business Modeling PHI Publication 2017

References: 

 A. K. Majumdar, P. Battacharya, “DataBase Management Systems’, TMH, 1996.
 Bipin Desai, “An Introduction to Database Systems”, Galgotia Publications, 1991.
 Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 6th Edition, McGraw
Hill, 2005.
 T.N. Chhabra, R.K.Suri “E-Commerce new vistas for business” Dhanpat Rai & Co.
 E-Commerce: C. V.S Murthy (Himalaya Publishing House)

Academic Year: 
2022-2023
  • Printer-friendly version
  • PDF version