NBA 6470

Last Updated

  • Schedule of Classes - June 18, 2018 7:14PM EDT
  • Course Catalog - June 14, 2018 7:15PM EDT

NBA 6470
Advanced Spreadsheet Modeling

Course information provided by the Courses of Study 2017-2018.

The goal of this hands-on lab course, taught in the Parker Center, is to develop proficiency with Excel's quantitative tools of Solver (for optimization) and @Risk (for simulation). Building on their brief introduction in the Managing Operations core course, students use these advanced tools to analyze problems and cases in finance, marketing, and operations. Although the bulk of this course is devoted to case analysis, occasional lectures introduce some advanced features of these two powerful modeling tools, including integer and nonlinear programming and sensitivity analysis within optimization, and correlated random variables, scenario analysis, and valid statistical analysis within simulation.

When Offered Spring.

Prerequisites/Corequisites Prerequisite: NCC 5080 and NBA 6430 or permission of instructor.

View Enrollment Information

Syllabi: none

  •   Seven Week - Second. 

  • 1.5 Credits GradeNoAud

  • 17980 NBA 6470   LEC 001

  • Add/Drop dates: Johnson Students – January 16th at 8:00am through February 7th at 4:00pm or prior to first class if class is held before these dates. Students may attend first class, but must drop BEFORE the 2nd class meeting to avoid penalties. Send email to gm-registrar@cornell.edu before the 2nd meeting date to request the drop. There is a late fee of $100.00 for each add or drop transaction after the 2nd class meeting date. You will also receive a "W" on your transcript in addition to the late fees after the 2nd class meeting date. Non-Johnson students may add themselves to the waitlists during the enrollment periods, however Johnson Students have priority into the classes and non-Johnsons will be enrolled: 1) IF seats are still available after Johnson students complete their enrollment period and 2) IF the instructor allows.

    Department Consent Required (Add)

Syllabi: none

  •   Seven Week - Second. 

  • 1.5 Credits GradeNoAud

  • 17981 NBA 6470   LEC 002

  • Add/Drop dates: Johnson Students – January 16th at 8:00am through February 7th at 4:00pm or prior to first class if class is held before these dates. Students may attend first class, but must drop BEFORE the 2nd class meeting to avoid penalties. Send email to gm-registrar@cornell.edu before the 2nd meeting date to request the drop. There is a late fee of $100.00 for each add or drop transaction after the 2nd class meeting date. You will also receive a "W" on your transcript in addition to the late fees after the 2nd class meeting date. Non-Johnson students may add themselves to the waitlists during the enrollment periods, however Johnson Students have priority into the classes and non-Johnsons will be enrolled: 1) IF seats are still available after Johnson students complete their enrollment period and 2) IF the instructor allows.

    Department Consent Required (Add)