INFORMATION TECHNOLOGY FOR MANAGEMENT

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.