ITM 353

Advanced Spreadsheet Analysis and VBA

(3 Credits)

This course invloves the use of spreadsheets and VBA (Visual Basic for Applications) to solve business and decision support problems.

Please enter attendance information:

First Name:

Last Name :

Course :

Course Objectives

  • Pivot tables, stats, and simulation.
  • Handling large data sets.
  • Linear programming.
  • Simulation.
  • Basics of the VBA language.
  • Recording macros.
  • VBA variables and objects.
  • VBA arrays, logic flow, and loops.
  • VBA user interface.
  • Solving typical DSS applications.

Textbook

Developing Spreadsheet-Based Decision Support Systems Using Excel and VBA
By Seref, Ahujan, & Winston (0-9759146-5-0)

Additional Materials

CBU student unix server account, other server backup, and/or USB drive as needed for backup.

Course Grading

  • 40 % - Homework
  • 15 % - Project 1
  • 15 % - Project 2
  • 15 % - Project 3
  • 15 % - Project 4

The schedule is a tentative guideline. The progress of the class will typically vary somewhat from this outline and additional material may be added. Scheduled and unscheduled homework, quizzes, and tests will be announced in class, therefore it is important to stay informed if absent from class.