Schedule
CINS 121 - Introduction to VBA


Orientation:

      
An orientation exercise will be posted on the web site, and will be available by August 30th. If you would like to meet with me to learn how to use the online site, please call or email me for an appointment.

Chat Sessions:

Optional chat sessions to be announced.

Calendar:

Due Date
Topic/Tutorial
Exercise Schedule
9-3

Tutorial 1 Using the Visual Basic Editor

Excel Lesson pages 29-42
Word Lesson pages 45-59
Access Lesson pages 61-78

9-10
Tutorial 2 The Object Model
Excel Exercise 1 pages 115-116
or
Word Exercise 2 page 134-135
9-17
Tutorial 3 Object Variables
Excel Exercise 1 pages 181-82
or
Word Exercise 2 page 193
9-24
Tutorial 4 String Variables
Excel Exercise 1 pages 233-34
or
Word Exercise 1 pages 253-54
10-1
Tutorial 5 Date Variables
Excel Exercise 4 pages 297-98
or
Word Exercise 2 page 309
10-8
Tutorial 6 Numeric Variables
Excel Exercise 4 pages 357-58
or
Word Exercise 1 pages 370-371
10-15
Tutorial 7 The Selection Structure
Excel Exercise 1 pages 421-22
or
Word Exercise 2 page 436
by 10-25

Midterm

 
10-29
Tutorial 8 The Select Case Statement and the MSGBOX Function

 

Excel Exercise 3 pages 481-82
or
Word Exercise 1 page 495

11-5
Tutorial 9 The Repetition Structure and the With Statement

Excel Exercise 9 page 539
or
Word Exercise 8  page 558

11-12
Tutorial 10 More on the Repetition Structure and String Functions
Excel Exercise 1 page 598
or
Word Exercise 1 page 612
11-19
Tutorial 11 Built-In Dialog Boxes and the Office Assistant

Excel Exercise 1 pages 62-63
or
Word Exercise 2 page 680

11-26
Tutorial 12 Custom Dialog Boxes
Excel Exercise 2 page 741
or
Word Exercise 2 pages 759-60
12-2
Tutorial 13 Option Button, Check Box, and List Box Controls
Excel Exercise 2 pages 816-17
or
Word Exercise 1 page 841
12-9
Tutorial 14 Automation
Excel Exercise 3 pages 882-83
or
Word Exercise 3 pages 901-2
Exercises are due on Friday Midnight of the assigned week.

Note: You may substitute any Access exercise for any Excel or Word assignment in Tutorials 2-14

Final Exam: by December 18th, 2004

 

Other Dates:
  • Last Day to Audit a Class: November 8th
  • Drop a Course:                 November 8th
The WebCT Calendar:
  • You should log into WebCT regularly and check the WebCT calendar for other scheduled activities and due dates.


Updated: 1 September 2004
Copyright: Penny Fanzone / CCBC

The Community College of Baltimore County
Essex Campus
7201 Rossville Boulevard
Baltimore, Maryland 21237