Computer Science (CSC) 204
 Advanced
Visual Basic Programming

                   Homework Schedule

Course Syllabus

Credit hours:              3
Semester:                   Spring 2002
Day & Time:              Monday/Wednesday/Friday from 2:15 to 3:05 PM
Room:                         Mac Hall 16

Instructor Information

Instructor:                   Kent Palmer
Office:                         Mac Hall 15B
Office Hours:              Monday 7:00 – 8:00 PM
                                     Tuesday 1:30-3:00 PM
                                    Wednesday 3:15-4:15 PM
                                     Thursday 1:30-3:00 PM
                                     Friday 3:15-4:15 PM
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.

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:

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

40 %

Quizzes

10 %

Approximate Schedule

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

Day

Chapter

Topics covered

February 1

 

Introduction

February 4

Appendix C

Review

February 6

Chapter 1

Debugging

February 8, 11

Appendix C

Review

February 13, 15

2

Interfacing with user

February 18

2

MDI

February 20, 22

3

Database concepts

February 25

3

ADO

Feb 27, March 1

4

Database files

March 4

 

Review

March 6

 

Exam 1

March 8

4

Error types

March 11, 13,

5

Programming Object Model

March 15, 18

5

SQL

March 20, 22

6

Classes

March 25,27,29

 

Break

April 1

 

Still on break

April 3

6

Collections

April 5

6

Object browser

April 8, 10

7

Multitier database concepts

April 12

 

Exam 2

April 15, 17

7

Database concepts

April 19, 22

8

Creating ActiveX code components

April 24

8

Managing ActiveX code components

April 26, 29

9

Active X Documents

May 1

9

Active X Controls

May 3, 6

10

Programming for the Internet

May 8

10

DHTML

May 10

Handout

Special topic

May 13

Handout

Special topic

May 22

 

8 AM 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 2 % for each additional day it is late (Each day that the computer lab is open in Mac Hall counts as a day).  No assignments will be accepted after the indicated no credit after date.  

Due Date

No Credit After

Chapter

Programming Exercises

Case Studies

February 11

March 6

C

Handout

 

February 18

March 6

C

Handout

 

February 25

March 6

2

2.1,2.4

Auto

March 4

March 22

3

3.2,3.4

Auto-Skip report

March 15

April 12

4

4.1, 4.2, 4.3

 

April 5

April 12

5

5.2, 5.3, 5.4

 

April 10

May 6

6

6.3, 6.4

Handout

April 24

May 6

7

7.3,7.4

Handout

May 1

May 15

8

8.1, 8.2

 

May 8

May 15

9

9.1, 9.2, 9.4

Handout

May 13

May 15

10

10.1, 10.2, 10.3

Handout

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.

Exam Schedule

Week

Exam

Notes

March 6

Exam 1

Appendix C, Chapters 1, 2, 3, 4, Handouts

April 12

Exam 2

Chapters 4,5,6,7

May 22

(8 AM)

Final Exam

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

MacMurray College Homepage

Department of Computer Science Homepage

 Kent Palmer Homepage  
e-mail instructor

Revised: January 19, 2004 .