IS 520

Business Programming and Spreadsheet Automation

Information Systems Marriott School of Business

Course Description

Programming in Excel Visual Basic; automating common tasks; retrieving data from web servers; building optimization models and user forms.

When Taught

Fall and Winter

Grade Rule

Grade Rule 8: A, B, C, D, E, I (Standard grade rule)

Min

3

Fixed

3

Fixed

3

Fixed

0

Other Prerequisites

IS 201 or equivalent or instructor's consent

Title

Understand Basic Programming Concepts

Learning Outcome

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

Title

Retrieve Data from Internet and Database Servers

Learning Outcome

Retrieve data from internet web servers and corporate database servers.

Title

Automate Repetitive Procedures in Excel

Learning Outcome

Automate repetitive procedures in Excel.

Title

Build Forms for Gathering User Input

Learning Outcome

Build forms for gathering user input

Title

Apply Programming Technology to Solve Business Problems

Learning Outcome

Apply programming technology to solve unstructured business problems.