Spreadsheet and Database Automation Programming

Spreadsheet and Database Automation Programming
Automating spreadsheets in Excel, interacting with password-protected web sites, writing code to conduct simulations, solving common database interface problems in Access, etc.
IS
540
 Hours3.0 Credit, 3.0 Lecture, 0.0 Lab
 PrerequisitesIS 202 or C S 142; or equivalent; or instructor's consent.
 TaughtWinter
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