- Introduction of various software used for business and their significance in the current business environments. Introduction of software MSOffice, VBA, MS PROJECT, SQL, PL/SQL
- Financial modeling like present value of cash flows, valuations, financial ratio analysis, forecasting, trend analysis of data, random input generations, statistics for management course (correlation and regression analysis) data presentation techniques. Spread sheet showing the monthly payments with changing interest rate over a period of loan. For example home loan, personal loan.(Using excel)
- Variable declaration, conditional statements, iteration and result presentation, retrieving of data from the VBA application.
- Understanding of a database, design elements, creation of a database. Retrieving of data from VBA. Importance of storing data, managing and data mining. Introduction of SPSS package for predictive analytical software.
5 Prepare presentations for mini projects assigned for course work of first
semester
|
1. Courter, Mastering Microsoft Office for Business Professional, Techmedia, 2003.
2. Alexis Leon, Introduction to Computers with MS Office 2000, TMH, New Delhi, 2000.
3. Mansfield, MS Office, TMH, New Delhi 1999.
4. * Prowess- Corporate Database, Centre for Monitoring Indian Economy(CMIE), Ph.No.040-
55466091-6,email-cmie.hyd@cmie.com www.cmie.com/products/prowess
5. Groff, SQL 2/e, The Complete Reference, TMH, 2003.
6. Sanders, D.H. Computers In Business--An Introduction Mc-Graw-Hill, Tokyo, 1983
7. Efraim Turban, R. Kelly Rainer, Jr., Richard E. Potter, Introduction to Information Technology,
Second Edition, John Wiley & Sons, Inc., 2003.
8. Bayross, PL SQL the Programming Language of Oracle, BPB, 2002.
9. Bayross, Oracle Teach Yourself SQL / PL SQL using Oracle 8i and 9i with SQLj, BPB, 2002.
|