Discipline: Computer Information Systems Degree Credit  [X]
Non Credit  [ ]
Nondegree Credit  [ ]
Comm Service  [ ]
 

Riverside Community College District
Integrated Course Outline of Record

Computer Information Systems 15C


COURSE DESCRIPTION
15C Visual Basic Programming: Databases Units: 3.00
 
Prerequisite(s): None.

Advisory: Previous Visual Basic programming experience , CIS 15A or CSC 15A
This course in Visual Basic programming assumes the student has Visual Basic programming experience. The course emphasizes database programming topics and techniques. Topics include random access files, relational databases, MS Access programming, SQL Queries, Data Controls, Data-Bound Controls, ADO Programming, Data Forms, Data Reports, Data Validation, Universal Data Access, and Remote Data Access. 54 hours lecture.
 
SHORT DESCRIPTION FOR CLASS SCHEDULE
Database Programming in Visual Basic
 
ADVISORY ENTRY SKILLS
Before entering the course, students will be able to:
  1. Design, create, test, debug, and implement Windows based applications in Visual Basic.

  2. Design and create user-friendly multiple form applications that make appropriate use of a variety of Windows controls.

  3. Design and create applications that make effective use of graphics and multimedia.

  4. Design and create applications that effectively incorporate strings, arrays, and files.

  5. Design and create applications that make use of a variety of objects and their properties and methods.

  6. CIS-96/97 are self-paced, competency-based, skill development computer labs. They provide the computer practice times to master the skills taught in the lecture classes. There is one-on-one instructor assistance available with additional help provided by student aides. Basically, the skills that are presented in the lecture classes have to be practiced to be mastered and that is the purpose of CIS-96/97.
STUDENT LEARNING OUTCOMES
 Upon successful completion of the course, students should be able to:

1.   Design and create Visual Basic applications that access, modify,
      and display external databases without the use of bound controls.

2.   Create Visual Basic applications that display database information
      in a variety of data bound controls on a form and allow validated
      user modifications to the database.

3.   Create Visual Basic applications that produce professional looking
      database reports.
 
COURSE CONTENT
  TOPICS
 
  1. Introduction to the Visual Basic Interface
  2. Introduction to Classes: Creating and Using Classes, Properties, Methods, Constructors
  3. Designing User Interfaces: Guidelines, Controls, Input Validation, Sample Applications
  4. Introduction to Databases: Basics, Relational Databases, SQL Statements
  5. Using the DataGrid and Data Bound Controls
  6. Classes Revisited: Class Libraries, Objects, Interfaces, Exception Handling, Inheritance
  7. ADO.NET Database Objects: Creating and Designing Databases, Connections, DataAdapters, DataSets, and Updating Databases using SQL
  8. Database Components: Northwind Database, Data-Related Components, Command Objects, Creating and Testing Components
  9. Creating Reports: Crystal Reports, Report Designer
  10. Optional Topics: Creating Web Applications, Writing Code in Web Forms, Web Applications with Database Objects, Web Services
 
METHODS OF INSTRUCTION
 Methods of instruction used to achieve student learning outcomes may include, but are not limited to:

  • Class lectures/discussions/demonstrations of the Visual Basic interface, classes, database controls, SQL queries to modify and filter data, ADO.NET Database programming, and database report creation
  • Pair and small group activities/discussion in programming to create correct VB database applications
  • Class exercises to encourage development of proper database design, programming, and reporting techniques
  • Handouts to assist in the understanding of database design and programming, bound controls, forms, SQL queries, and reports
  • Cooperative learning tasks where students program certain exercises together to learn how to work as a team
  • Distance Education: Online, Hybrid, and Web Enhanced
 
METHODS OF EVALUATION
 Students will be evaluated for progress in and/or mastery of learning outcomes by methods of evaluation which may include, but are not limited to:

  • Written programming assignments to develop proper design criteria and programming techniques
  • Quizzes/examinations to test understanding of VB database design and programming, classes, use of bound controls, database components, SQL queries, and report creation
  • Final examination to assess students’ mastery of essential concepts of VB database programming
ASSIGNMENTS

Required Reading Assignments


Required Writing Assignments


Other Outside-of-Class Assignments
 
COURSE MATERIALS
 All materials used in this course will be periodically reviewed to ensure that they are appropriate for college level instruction. Possible texts include:

  • Gaddis, Tony & Irvine, Kip. Advanced Visual Basic 2005. 4th ed. San Francisco, CA: Addison Wesley, 2007.
  • Gaddis, Tony & Irvine, Kip & Liang, Kaiyang . Advanced Visual Basic.NET . 3rd ed. El Granada, CA: Scott/Jones Inc., 2005.
08/07
513