|Title||Spreadsheet Applications in Business|
|Description||This course is designed for students who will need to construct or use powerful spreadsheets. Its main purpose is to develop proficiency in quantitative modeling to support effective managerial decision-making. This course is mostly project-oriented with a dual focus on spreadsheet engineering and quantitative modelingof financial applications.The goal of spreadsheet engineering is to develop spreadsheets that clearly present information, and that can easily be understood and modified by others. This goal will be accomplished through a series of lectures, tutorials and hands-on exercises covering principles of good spreadsheet design. Specific topics include documentation and commenting of spreadsheets, appropriate use of graphical elements, prevention and correction of spreadsheet errors, facilitating change, and preventing inappropriate change (through data validation and cell and worksheet protection). The second component of this course covers quantitative modeling in framing and analyzing problems in the area of corporate finance. The goal will be to develop spreadsheet models to solve specific financial problems, in order to reach reasonable and justifiable decisions. Several classic quantitative models will be developed and discussed. A set of lectures will introduce and review the fundamental quantitative tools including forecasting, sensitivity analysis, and data analysis using pivot tables. These models will be developed in lab exercises and/or homework assignments.
The course involves a hands-on, in-class learning experience in modeling and analyzing a variety of business decision problems on a common spreadsheet platform. It should, therefore, enhance the students’ problem-solving capabilities as well as spreadsheet skills.
|Prerequisites||CIS 2200 (or equivalent)|
|Learning Goals||Upon successful completion of this course, students will be able to:
BBA learning goals addressed:
|Textbooks||Parsons, Oja, Ageloff, Carey (2006). New Perspectives on Microsoft Office Excel 2003, Comprehensive, Second Edition.Cambridge,MA: Course Technology Inc. ISBN # 0-619-26815-8.|