Courses of Study 2019-2020 
    
    Jun 01, 2020  
Courses of Study 2019-2020
Add to Favorites (opens a new window)

AEM 2830 - VBA for Data Analysis and Business Modeling


     
Spring. 3 credits. Letter grades only (no audit).

Prerequisite: AEM 2010 . Enrollment preference given to: Dyson students.

R. Moghimi.

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.

Outcome 1: Program VBA, a strong tool that adds a great deal of functionality to Excel.

Outcome 2: Develop algorithmic thinking.

Outcome 3: Utilize and understand Basic Data Structures.

Outcome 4: Utilize and understand Conditional Branching and Looping.

Outcome 5: Build Procedures, and Functions in VBA.

Outcome 6: Develop skills in building models to solve real-world business problems.

Outcome 7: Produce an Excel VBA solution for a business application.



Add to Favorites (opens a new window)