INFO 301 Business Modeling

This course introduces students to the use of the computer as a business modeling tool. The overarching goal is to teach students to use computers to analyze models and data for integrated decision making across multiple domains including finance, marketing, accounting, strategy, and operations. The course proceeds in several parts: 1) Data Modeling - building on INFO 101 and MATH 114, the course will review data modeling in Excel; 2) Deterministic Modeling - the course will cover decision-making under certainty using optimization models such as linear programming. Problems such as portfolio optimization, transportation, and assignment are covered and the concepts of problem formulation and sensitivity analysis are introduced; 3) Spreadsheet Automation - concepts for programming in Excel will be introduced; 4) Probabilistic Modeling - decision making in an environment of uncertainty is covered using simulation and the principles of decision analysis. Students will also learn to choose the appropriate probability distribution for a given problem; and 5) Data acquisition from databases and SQL - the course ends by teaching how to query Access databases and introduces structured query language (SQL).

pre-rec: MATH 114.