Active Outline

General Information

Course ID (CB01A and CB01B)
CIS D014B
Course Title (CB02)
Visual Basic .NET Programming II
Course Credit Status
Credit - Degree Applicable
Effective Term
Fall 2021
Course Description
This course prepares students to develop professional-looking and deployable Visual Basic applications using advanced controls, user-created classes, incorporating databases with ADO.NET 3.5, calling APIs, and creating Web applications.
Faculty Requirements
Course Family
Not Applicable

Course Justification

In Visual Basic .NET Programming II, students learn to write applications in the rapid development language of Visual Basic that include database applications and applications running on the web. The course is UC and CSU transferable. It is required for the Visual Basic Programming Certificate of Achievement.

Foothill Equivalency

Does the course have a Foothill equivalent?
No
Foothill Course ID

Course Philosophy

Formerly Statement

Course Development Options

Basic Skill Status (CB08)
Course is not a basic skills course.
Grade Options
  • Letter Grade
  • Pass/No Pass
Repeat Limit
0

Transferability & Gen. Ed. Options

Transferability
Transferable to both UC and CSU

Units and Hours

Summary

Minimum Credit Units
4.5
Maximum Credit Units
4.5

Weekly Student Hours

TypeIn ClassOut of Class
Lecture Hours4.08.0
Laboratory Hours1.50.0

Course Student Hours

Course Duration (Weeks)
12.0
Hours per unit divisor
36.0
Course In-Class (Contact) Hours
Lecture
48.0
Laboratory
18.0
Total
66.0
Course Out-of-Class Hours
Lecture
96.0
Laboratory
0.0
NA
0.0
Total
96.0

Prerequisite(s)

CIS D014A or equivalent

Corequisite(s)

Advisory(ies)

Limitation(s) on Enrollment

Entrance Skill(s)

General Course Statement(s)

Methods of Instruction

Collaborative projects;

Discussion of assigned reading;

Discussion and problem solving performed in class;

Quiz and examination review performed in class;

Homework and extended projects;

Collaborative learning and small group exercises;

Other: Discussion of solutions to assigned homework, lab assignment projects, and test problems.

Assignments

  1. Readings from text, lecture notes, and online manual type web pages.
  2. Computer projects focused on course topics written as in-class activity.
  3. 5 - 7 programming homework assignments pertaining to the topics listed in X as Lab Topics.

Methods of Evaluation

  1. One to three midterms and a comprehensive final examination each to include program writing demonstrating synthesis of course topics and ability to apply skills as referred to in objectives and outcomes. Questions to be evaluated on correctness and code evaluated on correctness of applying correct programming constructs.
  2. Completion of hands on exercises demonstrating ability to apply skills presented in course topics. Evaluated on correctness.
  3. Programming assignments demonstrating synthesis of course topics and ability to apply skills as referred to in objectives and outcomes, will be evaluated for correctness, completeness, technique and style.

Essential Student Materials/Essential College Facilities

Essential Student Materials: 
  • None.
Essential College Facilities:
  • Computer lab with Visual Basic .NET Integrated Development Environment

Examples of Primary Texts and References

AuthorTitlePublisherDate/EditionISBN
Schneider, David I. An Introduction to Programming Using Visual Basic, Eleventh Edition, 2019. Pearson ISBN-13: 978-0135416037 ISBN-10: 0-13-541603-5

Examples of Supporting Texts and References

AuthorTitlePublisher
http://www.MSDN.com
Bradley, J. & Millspaugh, A.( 2010). Advanced Programming Using Visual Basic 2008, 4th edition. McGraw-Hill. ISBN 978-0-07-351722-3
Boehm, A. Murach's ASP.NET 4.5 Web Programming with VB 2012. Murach 2013 ISBN 978-1-890774-76-9
Boehm, A. Murach's Visual Basic 2015. Murach 2016 ISBN 978-1-890774-98-1
Zak, D. (2016). Programming with Microsoft Visual Basic 2015 7th Edition. Cengage Learning ISBN-13: 978-1285860268 ISBN-10: 1285860268

Learning Outcomes and Objectives

Course Objectives

  • Design applications incorporating Software Engineering Principles.
  • Create an MDI project.
  • Design, code, and debug one or more projects with class modules and bas modules.
  • Design, create and debug a Windows database application.
  • Design, create and debug an application creating a dataset from more than one table.
  • Update a database table and related tables
  • Design, create, and debug Web application using ASP.NET 3.5.
  • Create an application that accesses files and produces message logging for the application.
  • Install SQL-Server and WAMP (Windows Apache, MySQL, PHP) to use databases.

CSLOs

  • Design, create and debug an application incorporating class modules, bas modules and multiple forms.

  • Design, create and debug an application creating and updating a dataset from more than one table.

Outline

  1. Design applications incorporating Software Engineering Principles.
    1. Identify the purpose of each of the files listed in the Solution Explorer.
    2. Apply Object Oriented design principles:
      1. Abstraction
      2. Encapsulation
      3. Inheritance
      4. Polymorphism
    3. Employ VB Debugging tools to debug applications.
    4. Analyze the portability feature of applications.
    5. Evaluate the efficiency of program code.
  2. Create an MDI project.
    1. Add one or more child forms to the parent form.
    2. Add and write code to utilize menus.
    3. Facilitate user friendliness by adding context menus and toolbars.
  3. Design, code, and debug one or more projects with class modules and bas modules.
    1. Add a class module and a bas module to a project.
    2. Write code to define class properties, class methods, constructors and destructors.
    3. Write code to instantiate objects from created class module.
    4. Add objects to a collection.
    5. Incorporate Throw and Catch exceptions.
    6. Apply inheritance to create a new class based on an existing class.
    7. Validate user input using the TryParse and display messages using an ErrorProvider component.
  4. Design, create and debug a Windows database application.
    1. Retrieve and display data from a SQL Server database on Windows Forms using the DataGridView.
    2. Bind data fields to form controls.
    3. Populate ListBox and ComboBox with data.
    4. Sort data using SQL query.
  5. Design, create and debug an application creating a dataset from more than one table.
    1. Create a parameterized query
    2. Filter a DataSet.
  6. Update a database table and related tables
    1. Validate user input using validation controls.
    2. Implement TableAdapterManager component to maintain data integrity.
  7. Design, create, and debug Web application using ASP.NET 3.5.
    1. Add button control.
    2. Add HyperLink control to navigate through pages.
    3. Add validation controls.
    4. Display and update database files.
  8. Create an application that accesses files and produces message logging for the application.
    1. Utilize TabControl.
    2. Utilize file dialog.
  9. Install SQL-Server and WAMP (Windows Apache, MySQL, PHP) to use databases.
    1. Install SQL-Server – setup database to access using ADO.Net Connector
    2. Install WAMP – setup database to access using MySQL Connector

Lab Topics

  1. Design the user interface, design the algorithm, write the code, and debug a MDI project using parent form, child forms, and menus.
  2. Design the user interface, design the algorithm, write the code, and debug a project utilizing class modules.
  3. Design the user interface, design the algorithm, write the code, and debug a Windows database application which accesses, displays, and updates datasets.
  4. Design the user interface, design the algorithm, write the code, and debug an application creating a dataset from more than one table.
  5. Design the user interface, design the algorithm, write the code, and debug a Web application using ASP.NET 3.5.
  6. In a project create an application using Tab control, file dialog controls, and run-time file logging for debugging application.
Back to Top