Computer Application for Business
07. Computer Applications in Business (Lab)
The Objective of the course is to provide hands on experience to students in using computers for data organization and addressing business needs. There is also stress on use of statistical package for analysis of business data and its proper interpretation using SPSS. The exposure to PROWESS developed by Centre for Monitoring Indian Economy is with a view to make students aware of data bases of Indian Companies and enables them to work on mini projects and think of topic for their final year project.
UNIT-I: Introduction to Computers - Generation of Computer- Types of Input and Output devices- Computer Hardware and Software-Different Types of Languages
UNIT-II: Functional Information Systems – Marketing Information System – Financial Information System – Human Resource Information System – Manufacturing Information System. Information Support System – TPS, Management Reporting System, DSS, ESS, Office Automation System, and Knowledge based system, Enterprise Wide Information System, Latest trends in Information Systems. Issues & Trends in Information System Management – Effectiveness, Security, Ethics, Global Information System – Global System management.
Unit–III: MS-Excel - Overview of MS-Excel features, Creating worksheet, Entering and Editing text, Entering and Editing Formulas. Hands on experience with Prowess of CMIE and a few simple exercises on ratio analysis using the package.
Unit –IV: SPSS - Overview of SPSS, Uses, Data Analysis. Making students/Learn Familiar with Main menu and other features of SPSS Package.
Unit –V: Exercises:
Test-1:- Creating and Editing a Data File.
Test-2:- Cross Tabulation and chi-Square Analyses.
Test-3:- The one-way ANOVA procedure: one-way Analysis of variance.
Test-4:- Bi-variate Correlation: Bi-variate correlation, partial correlations and the correlation matrix.
Test-5:- Multidimensional scaling.
References
Introduction to
The Objective of the course is to provide hands on experience to students in using computers for data organization and addressing business needs. There is also stress on use of statistical package for analysis of business data and its proper interpretation using SPSS. The exposure to PROWESS developed by Centre for Monitoring Indian Economy is with a view to make students aware of data bases of Indian Companies and enables them to work on mini projects and think of topic for their final year project.
UNIT-I: Introduction to Computers - Generation of Computer- Types of Input and Output devices- Computer Hardware and Software-Different Types of Languages
UNIT-II: Functional Information Systems – Marketing Information System – Financial Information System – Human Resource Information System – Manufacturing Information System. Information Support System – TPS, Management Reporting System, DSS, ESS, Office Automation System, and Knowledge based system, Enterprise Wide Information System, Latest trends in Information Systems. Issues & Trends in Information System Management – Effectiveness, Security, Ethics, Global Information System – Global System management.
Unit–III: MS-Excel - Overview of MS-Excel features, Creating worksheet, Entering and Editing text, Entering and Editing Formulas. Hands on experience with Prowess of CMIE and a few simple exercises on ratio analysis using the package.
Unit –IV: SPSS - Overview of SPSS, Uses, Data Analysis. Making students/Learn Familiar with Main menu and other features of SPSS Package.
Unit –V: Exercises:
Test-1:- Creating and Editing a Data File.
Test-2:- Cross Tabulation and chi-Square Analyses.
Test-3:- The one-way ANOVA procedure: one-way Analysis of variance.
Test-4:- Bi-variate Correlation: Bi-variate correlation, partial correlations and the correlation matrix.
Test-5:- Multidimensional scaling.
References
Introduction to
References: Introduction to Computers * Peter Norton, Introduction to Computers, 8/e, TMH, 2008 * Introduction to Information Technology, ITL Education, Pearson Education, 2009 * Dhiraj Sharma: Foundation of Information Technology, Excel, 2009 * Morley, Understanding Computers, 10/e Cengage, 2009 * V * Efraim Turban, R. Kelly Rainer, Jr. Richard E. Potter, Introduction to Information Technology, Wiley, 2006. MS-Excel * Ron Mansfield: Working in Microsoft Office, TMH, 2008 * David Whigham: Microsoft Excel, Data Analysis and Decision Making, Oxford, 2009 * Albright Winston Zappe, Stephen G * Microsoft Office System step by step, 2007 edition, Pearson 2008. * Greg Perry: Microsoft Office 2007, Sam Teach yourself, Pearson Education, 2007