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
Prerequisite: CP102 and previous programming experience, or CP104
Regulations: Faculty of Science Regulations
|Lecture A||MW||12:00 pm - 01:20 pm||SBE1230||Mr. David Brown|
|Lab L1||W||01:30 pm - 02:20 pm||P1033||Mr. David Brown|