JOLIET JUNIOR COLLEGE

DEPARTMENT OF COMPUTER INFORMATION

AND OFFICE SYSTEMS

 

COURSE SYLLABUS

 

 

 

 

Course Prefix and Number    CIS 280

     

Course Title                           Advanced Visual Basic

 

Curriculum                              Computer Information Systems

 

 

Semester Hours                     4

     

Lecture                                   4

     

Lab                                          0

     

Prerequisites                          CIS 230

 

 

 

Catalog Description

 

This course deals with advanced techniques for Visual Basic programming.  Topics include sequential file and direct access file processing, database programming, SQL programming, API calls, Object Linking and Embedding (OLE), and Multiple Document Interface (MDI).  Students will design and implement large programs using interactive Common Dialog controls, Visual Basic controls, and ActiveX controls within multiple files and multi-user database environment.  Sorting and searching of records will be included. 

 

 

Course Objectives:  See attached.

 

 

 

                                                                                   

Prepared by:                                                                 Reviewed by:   

           

 

                             

Hui-Liang Low                                                              Ram Raghuraman

Dept. of CIOS                                                              Department Chairperson            Date

4/98                        Updated 12/00                                

                              Revised 5/98

STUDENT MATERIALS

 

A.  Textbooks:       

 

      Title:                       Visual Basic 6.0 Advanced Topics (w/CD-ROM)

 

      Author:                   Ekedahl

     

      Publisher:                Course Technology

 

 

     

 

B.   Other Required Materials

     

 

 

 

      Other Course Requirements

     

 

 

 

      Student Evaluation (Type of Grading)

 

     

      Grades will consist of projects, quizzes, a midterm and a final exam. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                                                                                                            Teaching Aids or

Week/Days                   Topic or Class Activity                                      Special Instruction

 

      1                            Explore new Visual Basic controls.

 

      2                            Use interactive Common Dialog controls and MDI

                                    to design programs.

 

      3                            Introduce API calls, INI files, and windows registry.

 

      4                            Use control arrays and classes to enhance capabilities

                                    of programs.

 

      5                            Include Object Linking and Embedding and ActiveX

                                    controls into programs.

 

      6                            Process sequential files and random access files.

 

      7                            Introduce relational databases.  Design relational databases.

                                    Use of Microsoft Access DBMS software.

 

      8                            Use Data Manager to create and process databases.

 

      9                            Access database using Data controls and Bound controls.

 

      10                           Access database using Data Access Object (DAO).

 

      11                           Understand SQL concept.                                                         

 

      12                           To sort and find records in database.

 

      13                           Process multiple types of databases with Remote Data Objects (RDO).

 

      14                           Use security and locking in Multi-user database environment.

 

      15                           Write reports using Crystal Report software.

 

     

 

 

 

 

 

 

 

 

 

 

 

OBJECTIVES       

 

At the end of the course, students will:

 

     1.    Understand the important design of a relational database.

 

     2.    Learn how to use the Data Control and Data Access Object to access database.

 

     3.    Understand the concepts important to Object Linking and Embedding, and ActiveX controls.

 

     4.    Write applications to process sequential files and Random Access files.

 

     5.    Demonstrate abilities to create Single Document Interface and Multiple

            Document Interface applications. 

 

     6.    Design and implement large-scale programs using interactive common dialog controls,

            Visual Basic controls, and Active X controls.

 

     7.    Implement sorting and searching of records in databases.