AEM 2830

Last Updated

  • Schedule of Classes - June 7, 2023 8:54PM EDT
  • Course Catalog - June 7, 2023 7:14PM EDT

AEM 2830
VBA for Data Analysis and Business Modeling

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

This course is an introduction to programming with Excel Visual Basic for Applications (VBA) for students aiming to enter the world of business analytics. Using business applied cases students will increase decision making efficiency and productivity through a detailed understanding of VBA programming languages.

When Offered Spring.

Permission Note Enrollment preference given to: Dyson students.
Prerequisites/Corequisites Prerequisite: AEM 2010.
Forbidden Overlaps Forbidden Overlap: due to an overlap in content, students will not receive credit for both AEM 2830 and AEM 2831.

Outcomes
  • Program VBA, a strong tool that adds a great deal of functionality to Excel.
  • Develop algorithmic thinking.
  • Utilize and understand Basic Data Structures.
  • Utilize and understand Conditional Branching and Looping.
  • Build Procedures, and Functions in VBA.
  • Develop skills in building models to solve real-world business problems.
  • Produce an Excel VBA solution for a business application.

View Enrollment Information

Syllabi:

  •   Regular Academic Session. 

  • 3 Credits GradeNoAud

  •  8485 AEM 2830   LEC 001

  •  

  • Instruction Mode: In Person
    Enrollment preference given to Dyson students in the Business Analytics concentration. Non-Dyson students should place their name on the waitlist during pre-enrollment.