Computer Applications in Management (Functional Electives IT & Systems)

Paper Code: 
MBS-421
Credits: 
4.0
Contact Hours: 
40.00
Max. Marks: 
100.00
Objective: 
  • This course is designed to make the students of management familiar with the applications of computers in Business Management. This paper shall prepare students to learn and acquire necessary computer skills required for day to day office application. The students will also be able to learn to solve business mathematical problems with the aid of computers.
8.00
Unit I: 
Application of Computers

Working of a Computer System, Evolution of Computers, Generations of Computer Languages, Applications of Computers, Use of Computer in Marketing, Finance, HR. IT Outsourcing Advantages and Disadvantages.

8.00
Unit II: 
Software Concepts

Types of Software: System Software, Language Processors, Operating System and its types, Application Software, Packages, Utilities and its types, Customized Software.

8.00
Unit III: 
Introduction to Spreadsheet

Conditional Formatting, Logical Functions, Date and Time Functions, Math Functions, Data Sorting

8.00
Unit IV: 
Financial Analysis using spreadsheets

Financial Functions-PMT(), PV(), NPV(), FV(), IRR(),RATE(), DDB(), CTERM(), SLN(), HLOOKUP(), VLOOKUP(), Data Tables

8.00
Unit V: 
Computer Applications in Finance using spreadsheets

Data Analysis, Query, Charts, What-if-Analysis tools: Data Summarization and visualization using pivot tables, scenarios, goal seek

Essential Readings: 
  • Fundamentals of Computers, V Rajaraman, Prentice-Hall of India, 2004.
  • Fundamentals of Information Technology, Alexis Leon, Vikas Publishing House, 2008.
References: 
  1. Using Information Technology, Brian Williams, McGraw-Hill, 2010
  2. Elementary Data Analysis Using Microsoft Excel, Anita M Meehan, C. Bruce Warner, McGraw-Hill, 1999.
  3. Corporate Financial Analysis with Microsoft Excel, Francis J. Clauss, McGraw-Hill, 2009.
  4. Computer Finance and its Applications, Wessex Institute of Technology Southampton, UK,  WIT Press, 2004.