Welcome to the Excel Introduction Course for the Busimess Departmentwho are responsible for the design and development of a software system. All teams in the class will be competing to produce the best product. The main focus of the course will be on the software development process and principles of good object-oriented design. You will learn to use Unified Modeling Language (UML) as a tool to design software. You will use Java to implement your design. We will also discuss what software development is like in "the real world."
This course focuses on learning how to solve business problems using Microsoft Excel 2010. Excel is widely used in business as a tool for solving problems and supporting business decisions. It is a powerful tool for the manipulation and analysis of data . This capability allows business decison makers to decide whether or not to take some course of action. This course will help you learn what type of problems are best solved with spreadsheets and how to solve them. One of the goals of this course is that you learn how to learn - in other words, understand how to explore and discover Excel features and tools to solve problems and support decisions.
Excel can greatly increase your ability to deal not only with the immediate problem, but also with "what-if" analysis. One example of "what-if" analysis is with an organization's financial model in a spreadsheet. The model summarizes various pieces of financial data to determine assets, liabilities, sales, and profitability - creating a representation of the organization in the spreadsheet. The spreadsheet could be used to evaluate what would happen if:
- The company cut sale prices by 8%
- The sales volume increased by 10%
- The inventory turnover improved by 7%
- The company issued $1 million in bonds
Many organizations spend hundreds of hours building models in spreadsheets to help answer questions such as those above. In this course, we will begin to learn how to develop such models to address business problems.
mber of a team of four (five) people who are responsible for the design and development of a software system. All teams in the class will be competing to produce the best product. The main focus of the course will be on the software development process and principles of good object-oriented design. You will learn to use Unified Modeling Language (UML) as a tool to design software. You will use Java to implement your design. We will also discuss what software development is like in "the real world."
I hope you will enjoy this course and find it very interesting. I know I will! Please contact me for help if you have auestions or, especially, if are overwhelmed by the material or if you are just plain lost. If you have any suggestions for improvements in the way the course is structured or in the way material is being developed and presented, please let me know. I welcome such suggestions!