This course is designed for students who have a basic understanding of spreadsheets, word processors, and databases as well as introductory programming experience. The course introduces methods to automate repetitive tasks and create user-friendly applications in spreadsheets, word processors, and databases using the powerful macro language, Visual Basic for Applications (VBA). Topics include: a review of programming constructs such as data types, looping, conditional statements, and arrays; the design of graphical interfaces with the typical "look and feel" of Windows software; the design of dialog boxes with controls and eventhandling code that responds to user input; automating tasks; consolidating data; providing userfriendly reports.
3 lecture hours, 1 lab hour
Credit: 0.50
Prerequisite: CP102 and previous programming experience, or CP104
Section | Days | Times | Room | Instructor |
---|---|---|---|---|
B | MW | 05:30 PM - 06:50 PM | Mr. Rick Henderson | |
L1 | M | 11:30 AM - 12:20 PM | Mr. Rick Magnotta | |
L2 | T | 05:00 PM - 05:50 PM | Mr. Rick Magnotta |