Business Programming and Spreadsheet Automation

Business Programming and Spreadsheet Automation
Programming in Excel Visual Basic; automating common tasks; retrieving data from web servers; building optimization models and user forms.
IS
520
 Hours3.0 Credit, 3.0 Lecture, 0.0 Lab
 PrerequisitesIS 201 or equivalent or instructor's consent.
 TaughtFall, Winter
 ProgramsContaining IS 520
Course Outcomes

Automate Repetitive Procedures in Excel

Automate repetitive procedures in Excel.

Understand Basic Programming Concepts

Understand basic programming concepts such as variables, arrays, procedures, conditions, and control of flow statements

Retrieve Data from Internet and Database Servers

Retrieve data from internet web servers and corporate database servers.

Apply Programming Technology to Solve Business Problems

Apply programming technology to solve unstructured business problems.

Build Forms for Gathering User Input

Build forms for gathering user input