Course Objectives
1. 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.
Course Outcomes (COs)
Learning outcomes (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|
CO 11.Work on spreadsheets and employ basic functions to handle data. CO 12.Work on advanced inbuilt functions available in spreadsheet software for data analysis CO 13.Work on managerial and financial functions, create charts, perform statistical analysis through spreadsheet software CO 14.Work on database management software to manage data for effective information management CO 15.Understand current trends of e commerce operations and online financial transactions |
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. Advance 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
• 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.