INSY 381

INSY 381: Decision Analytics with Spreadsheets

Prerequisite: INSY 281, MGNT 333

Credit Hours: (3)

Students will learn data and decision modeling using spreadsheets. Solution techniques will include linear programming, optimization, forecasting and simulations.

Detailed Description of Content of Course

Topics Include:

Optimization
Simplex Method and Sensitivity Analysis
Linear Programming
Non-Linear Programming
Multiple Objective Optimization
Regression Analysis

Detailed Description of Conduct of Course

Students will analyze problems and create solutions using the appropriate data modeling techniques and implement the solutions in a spreadsheet.

Goals and Objectives of the Course

Students will be able to use the following techniques to solve the following problems using spreadsheets:

Optimization
Simplex Method and Sensitivity Analysis
Linear Programming
Non-Linear Programming
Multiple Objective Optimization
Regression Analysis

Assessment Measures

Homework assignments, quizzes, tests and projects may be used to assess students in this course.

Other Course Information

None.

Review and Approval

Spring 2010 Initial Course Approval Art Carter, Chair

Revised: May 30, 2012

February 27, 2024

April 27, 2026