Computer Science (CSC) 204
 Advanced
Visual Basic Programming

Grades                              

Course Syllabus

Credit hours:              3
Semester:                   Spring 2000
Day & Time:              Monday & Thursday from 7:00 to 8:30PM
Room:                         Mac Hall 16

Instructor Information

Instructor:                   Kent Palmer
Office:                         Mac Hall 15B
Office Hours:              Monday 8:30-9:30 PM
                                     Tuesday 2:00-3:30 PM
                                     Wednesday 10:00-11:30 AM
                                     Thursday 8:30-9:30 PM
                                     Friday 10-11:30 AM
Office Phone:              (217) 479-7102
Home Phone:              (217) 245-7675
E-mail:                         kpalmer@mac.edu
Home page:                 http://www.mac.edu/~kpalmer 

Required Material

Several 3 ˝ inch floppy disks. Be sure to label all floppies with your name when turning them in.

Several pocket folders for turning in assignments.

Bradley, Julia Case & Anita C. Millspaugh. Advanced Programming Using Visual Basic 6.0. Boston, MA: Irwin McGraw-Hill, 2001 (Cost $63.50).

Course Expectations

General: Programming is not a spectator sport. You will have to spend considerable time in the lab outside of class sessions to grasp the material in this course.  In general, for every 1 ˝ hour class session you should budget time in your schedule to spend an additional 3 hours in the lab. 

Attendance: If students need to miss a class they should notify the instructor in advance.  Otherwise, students are expected to attend class. If students fail to attend class, their attendance grade will be lowered.  Students will only be permitted to make up exams in case of medical or family emergencies.

Academic Honesty

Students are referred to the policy outlined in the student handbook (The Maggie).

Goals

Catalog description: This course is designed to give students hands-on exposure to features of Visual Basic not covered in the first course.  Emphasis will be placed on using Visual Basic  to access information from databases.  Use of Active X controls and class modules will be covered.  Programming for the Internet will be covered briefly. Prerequisite: Computer Science 202 (Programming using Visual Basic)

After completing this course a student should be able to:

Equal Opportunity

MacMurray strives to provide a diverse learning environment that welcomes students with a wide variety of backgrounds.  I attempt to treat all students equally regardless of race, ethnic background, age, gender, sexual orientation, handicap, or other factor.  If you feel that I am not treating students in my class fairly please talk to me about the concern.  If you are uncomfortable talking with me about the concern, you can see either the Dean Of Students, Anne Jackson (extension 123) or the Dean of the College, Jim Goulding (extension 016).  Both would like to maintain a diverse campus community and can help resolve any discrimination issues.

Student with Disabilities

If you have a disability that may affect your ability to perform the work in this class, please inform me right away.  It may be possible to adapt the computer equipment, material used in the course, or testing methods to accommodate a particular student’s needs.  Ken Roumpos (extension 222) coordinates services for students with special needs.  The Learning Center (extension 170) may also be willing to provide tutoring or other assistance if needed.

Grading Scale

Grade

Percentage

A

90 – 100%

B

80 – 89%

C

70 – 79%

D

60 – 69%

F

0 – 59%

Grade Distribution

Component

Percentage

Exam 1

15 %

Exam 2

15 %

Final exam

20 %

Homework

35 %

Attendance

10 %

Participation

5 %

Attendance Grade

Unexcused absences

Attendance Grade

0-2

A

3-4

B

5-6

C

7-8

D

9 or more

F
 

Approximate Schedule

(Chapter references are to Bradley & Millspaugh, Advanced Programming in Visual Basic 6.0.)

Day

Chapter

Topics covered

August 31

1

Introduction

September 4

Appendix C

Review

September 7

2

Interfacing with user

September 11

2

MDI

September 14

13 (Old book)

Drag and drop

September 18

13 (Old book)

Drag and drop

September 21

3

Database concepts

September 25

3

ADO

September 28

4

Database files

October 2

4

Error types

October 5

 

Exam 1

October 9

5

Programming Object Model

October 12

 

Break

October 16

5

SQL

October 19

14 (Old book)

Graphics

October 23

14 (Old book)

Graphics

October 26

6

Classes

October 30

6

Collections

November 2

6

Object browser

November 6

7

Multitier database concepts

November 9

7

Database concepts

November 13

 

Exam 2

November 16

8

Creating ActiveX code components

Nov 20,23

 

Break

November 27

8

Managing ActiveX code components

November 30

9

Active X Documents

December 4

9

Active X Controls

December 7

10

Programming for the Internet

December 11

10

DHTML

December 14

 

7 PM Comprehensive Final

Homework Schedule

Must turn in floppy containing program as well as printed code!! 

There will be a one-day grace period on all assignments.  After that, credit for an assignment will be reduced by 5% for each additional day it is late (Saturday and Sundays count as late days, but assignments can be turned in on either day).  No assignment will be accepted more than 10 days late.

Be sure to place your name on all work.  When you turn in a floppy disk write your name on the disk.

The following assignments will be graded.

You should always keep an electronic copy of any assignment you turn in.  This is for two reasons: Your instructor could lose what you turn in and some later assignments are based on earlier assignments and you may need to start on these before your graded assignment is returned. 

Keep copies of graded assignments in case you need to prove that the grade recorded is in error.

Please note the documentation requirements on the last page of the syllabus.

Due Date

Chapter

Programming Exercises

Case Studies

Sept. 14

2

2.1,2.4

Video

Sept. 21

13-old

13.1,13.5

Auto

Sept. 28

3

3.2,3.4

Video

Oct. 5

4

4.1, 4.2, 4.3

Video

Oct. 23

5

5.2, 5.3, 5.4

Video

Oct. 30

14-old

14.2,14.3,14.5

Auto

Nov. 6

6

6.3, 6.4

Video

Nov. 13

7

7.3

Video

Dec. 4

8

8.1, 8.2

Video

Dec. 7

9

9.1, 9.2, 9.3

Video

Dec. 11

10

10.1, 10.2, 10.4

Video

Exam Schedule

Week

Exam

Notes

Oct. 5

Exam 1

 

Nov. 13

Exam 2

 

Dec. 14

(7 PM)

Final Exam

This exam will be comprehensive, but greater emphasis will be placed on material covered since the last exam.

 

Documentation

Documentation is required on all assignments. 

Include at least the following:

‘Project:
‘Programmer:
‘Date:
‘Purpose                                  Identify what the entire program will accomplish
‘                                               (Include problem number if from text)
‘Folder:

Declare variables using Dim statements at the beginning of

each event procedure (except for global and module level variables). 

To the right of a Dim statement include a comment explaining what the variable is used for. 

For example:

Dim intTotal As Integer       ‘intTotal is the number of part time and full time employees

Include comments in your event procedures to explain the logic.

MacMurray College Homepage

Department of Computer Science Homepage

 Kent Palmer Homepage  
e-mail instructor

Revised: January 19, 2004 .