Midterm: Thursday, June 11, 2015: 9:30 am - 10:50 am, N2085/N2095
Final Exam: Saturday, August 8, 2015: 12:00 noon - 2:00 pm, BA113
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||09:30 am - 10:50 am||1C18||Mr. David Brown|
|Lab L1||R||11:00 am - 11:50 am||BA113||Mr. David Brown|
Regulations: Faculty of Science Regulations