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
|Lecture A||TR||-||1C18||Mr. David Brown|
|Lab L1||R||-||BA113||Mr. David Brown|
Regulations: Faculty of Science Regulations