NBA 6430

NBA 6430

Course information provided by the Courses of Study 2021-2022.

The goal of this hands-on, lab-style course is to develop proficiency in quantitative modeling within the environment of Microsoft Excel. Students develop and use spreadsheets to analyze a variety of business problems. The course has two principal components: spreadsheets and models. Spreadsheet topics include principles of good spreadsheet design, the effective presentation of information through spreadsheets (including graphical controls and dashboard design), and advanced Excel features (e.g., conditional formatting, data validation). Modeling topics include the art of finding the appropriate level of modeling detail, sensitivity analysis, and using solver and regression to perform optimization and estimation tasks.

When Offered Fall, Spring.

Fees Course fee: $125 for instant access textbook and materials.
Prerequisites/Corequisites Prerequisite: NCC 5060 or NCC 5560.

View Enrollment Information

Syllabi: none
  •   Seven Week - First. 

  • 1.5 Credits GradeNoAud

  • 12671 NBA 6430   LEC 001

  • Instruction Mode: In Person
    Enrollment limited to: Johnson and Graduate Students Only Add/Drop Dates: Johnson Students – January 18th at 8:00am to February 7th at 11:59pm. You may add or drop a first-half class after February 7th with permission of the faculty. A late fee of $100.00 will be charged for each add or drop transaction. If you are dropping after February 22nd at 11:59pmyou will also receive a "W" on your transcript in addition to the late fees. Non-Johnson students may add themselves to the waitlists during their 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. There will be no enrollment from a wait list into a class if you have a time conflict or if it will create an overload. This course is a Management Science Elective.

Syllabi: none
  •   Seven Week - First. 

  • 1.5 Credits GradeNoAud

  • 12672 NBA 6430   LEC 002

  • Instruction Mode: In Person
    Enrollment limited to: Johnson and Graduate Students Only Add/Drop Dates: Johnson Students – January 18th at 8:00am to February 7th at 11:59pm. You may add or drop a first-half class after February 7th with permission of the faculty. A late fee of $100.00 will be charged for each add or drop transaction. If you are dropping after February 22nd at 11:59pmyou will also receive a "W" on your transcript in addition to the late fees. Non-Johnson students may add themselves to the waitlists during their 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. There will be no enrollment from a wait list into a class if you have a time conflict or if it will create an overload. This course is a Management Science Elective.