Spreadsheet: Features of spreadsheet-MS Excel – Features of MS Excel; Functions in Excel:
Financial functions: NPV, IRR, PMT, IPMT. Statistical functions: AVERAGE, MEAN,
MEDIAN, AVEDEV, CORREL, STDEV, RANK, Database functions: DAVERRAGE, DMAX,
DMIN, DSUM; Graphics in Excel.
Business applications of Excel: Managerial decision – making with Excel; Model development
with Excel; Financial analysis using Excel; Break-even analysis, budgeting and ratio analysis
with Excel; Inventory management with Excel, Investment appraisal with Excel. Goal seek,
pivot table and scenario management for decision – making.
Internet – Features of the Internet;WWW:Email, Telnet, FTP, News groups, search engines,
portals, Business applications of the Internet.
E-Commerce: introduction to e-commerce, Models of e-commerce: B2C, B2B, B2G and C2C.
Electronic payment systems: e-cash, e-cheque, credit cards, debit cards. EDI and e-commerce.
EDI standards. Setting up and promotion of a website for e-commerce.
Security issues in E-commerce: security risks in e-commerce, security tools and risk
management. IT Act 2000 – digital signature, digital signature certificates, e-governance,
electronic records, certifying authorities, network appellate tribunal, penalties.
MCom (Masters in Commerce) Subjects