This course aims to sharpen students' ability to frame a business problem and organize the relevant information in a way that is conducive to developing a spreadsheet model, and to perform logical analyses in an organized and rigorous fashion. Students will learn how to create a workable prototype of a spreadsheet based upon formula-charts, or a directed-graph diagram, applying principles of spreadsheet engineering to design the spreadsheet in a way that prevents errors. The course will teach students how to design, build, test, and use a spreadsheet, as well as how to process and visualize data in preparation for building a well-structured model. Students will be exposed to settings in which models can be used effectively. They will apply modeling concepts in practical situations and learn to extract insight from models and to use those insights to communicate, persuade and motivate organizational decision making. They will also learn how to formulate a constrained optimization problem with multiple variables for a variety of applications including, Strategy, Operations, Technology Management, Marketing, and Finance. The course will show how to understand how to use sensitivity analysis to evaluate the impact of a parameter on the optimal solution to a problem and cover the key principles for Real-Time Data Capture for Analytic. Finally, students will learn the latest technologies for effectively linking spreadsheets to relational data bases, and to reliably manage large scale spreadsheets. 1.5 cr.