Coming soon
INFORMATION TECHNOLOGY FOR MANAGEMENT
This course will introduce students to the applications of computers to manage different data management operations in an organization. It provides them an opportunity to study the data management for various managerial operations and handling data in corporate environment.
|
Course |
Learning outcome (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|
|
Course Code |
Course title |
|||
|
24MBAS127 |
Information Technology for Management (Practical Lab) |
CO37: Create spreadsheets and employ basic functions to handle data. CO38: Examine Sensitivity analysis using Spread sheet CO39: Analyze data by using advanced inbuilt functions available in spreadsheet software CO40: Create charts, perform statistical analysis using managerial and financial functions through spreadsheet software CO41: Analyze database management software to manage data for effective information management and also examine current trends of e commerce operations and online financial transactions CO42: Contribute effectively in course-specific interaction |
Approach in teaching: Interactive Lectures, Group Discussion, Tutorials, Case Study Learning activities for the students: Self-learning assignments, presentations |
Class test, Semester end examinations, Quiz, Assignments, Presentation |
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
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.
Advanced Spread Sheet Functions & tools: Logical Function, Date and time function
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
Multiple tables, relationships, Sort & Filter in table, select data with queries: Creating query by design & by wizard, Creating basic forms & Reports.
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.
- 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
Suggested Readings:
- 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)
E resources:
- https://www.tutorialspoint.com/management_information_system/classification_of_information.htm
- https://www.managementstudyguide.com/types-of-information-systems.htm
- https://www.guru99.com/introduction-to-formulas-and-functions-in-excel.html
- https://trumpexcel.com/excel-functions/
- https://beginnersbook.com/2015/04/dbms-tutorial/
- https://www.javatpoint.com › dbms-tutorial
- https://ecommerceguide.com
- https://data-flair.training
- https://www.grin.com/document/280494
- https://www.bigcommerce.com/blog/ecommerce-payment-processing/#online-payment-methods
- https://www.tutorialspoint.com/e_commerce/e_commerce_payment_systems.htm
- https://www.oecd-ilibrary.org/
- https://www.getastra.com/blog/knowledge-base/ecommerce-security/
- https://support.microsoft.com/en-us/office/access-video-training-a5ffb1e...
- https://www.tutorialspoint.com/ms_access/index.htm
Journals :
- https://www.journals.elsevier.com/international-journal-of-information-management-data-insights
- International Journal of Electronic Commerce https://www.tandfonline.com/toc/mjec20/current
- https://www.sciencedirect.com/journal/electronic-commerce-research-and-applications
