Course Objectives:
This course has been designed to acquaint the students with
• Introduce students to the applications of computers to manage different data management operations in organizations
• Provides students an opportunity to study the data management for various managerial operations and handling data in corporate environment.
Course Outcomes(CO):
Learning Outcomes (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|
The student will be able to-
|
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.
• 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.