CIS 215
Computer Programming For Business Using Visual Basic

Lessons page

Class 1

In this lesson the learning objectives are: The Goal Of The Class How Do Computers Communicate Binary -- Octal -- Hexadecimal Stretching Out The Scale Hello In Computer Bits and Bytes Programs and Instruction Sets Types of Programs Computer Programming Common Programming Components Programming Languages and Paradigms Programming Progression Machine Code Assembly Code Level 3 Code -- C++ In This Case 3rd Generation Language Comparison Language Comparison Programming Paradigms Program Coding Command Line to GUI Shift Program Testing Program Documentation Programming Tools The Java SDK or JDK Object-Oriented Language Sample Object Properties of Object "Cat" Methods of Object "Cat" Instantiation/li> Object-Oriented Language Principles: Encapsulation Inheritance Polymorphism Events Event Handlers Custom Event: onPetting() Values and Variables Operators Assignments Comparisons Using Comments The Code "Hello World" Script Using JavaScript "Hello World" Screenshot "Hello World" JavaScript Code Building Your Toolkit To Get Visual Basic Places You May Want To Visit

Return to Syllabus

Class 2

In this lesson the learning objectives are: Why Learn Visual Basic Objects and Controls Types of Controls Controls Are A Type Of Object Event-Driven Programming Visual Basic Controls Control Demonstration The Name Property Examples of Control Names Anatomy of A Name Control Naming Rules and Conventions Steps To Make A Program The Programming Fun Paradox Common App Planning Steps Plan Before You Play The Work Steps Step 1: Clearly Define What The Program Is To Do Step 2: Sketch What The App Will Look Like Step 3: Control Selection Step 4: Control Text Property Step 5: Control Methods Step 6a: Flow Chart The App Step 6a1: Work Flow Use Case Step 6b: Writing Pseudocode Step 6b2: Edit Pseudocode Step 7: Validate Flowchart/Pseudocode Step 8: Actual Programming Step 9: Writing Your Methods Step 10: Testing The App What Is Visual Studio The Visual Studio Environment The Visual Studio Menu Bar The File Menu The Edit Menu The View Menu The Project Menu The Build Menu The Debug Menu The Team Menu The Windows Menu The Help Menu The Name and Text Property The Toolbox

Return to Syllabus

Class 3

In this lesson the learning objectives are: The Basic Building Blocks Of Visual Basic Form Designer Form Getting An Application Started Building A Simple Application Saving An Application Retrieving A Saved Application The "Hello World" Application More On Properties Font Alignment TextAlign Color Size Border Style None (default) FixedSingle Fixed3D Autosize True False Locking Controls IntelliSense The Code Window Event Handling Using Comments Inline Comments Block Comments Errors Syntax Errors Runtime Errors Logic Errors

Return to Syllabus

Class 4
In this lesson the learning objectives are: Variables and Variable Types String Number Declaring Variables Variable Scope The TextBox Object The MessageBox Concatenation Operators and Assignments Precedence and Parantheses Converting Data Types Constants Data Formatting Exception Handling

Return to Syllabus

Class 5
In this lesson the learning objectives are: Exception Handling Group Boxes Tab Order Working With Bugs The "Load" Event Catching The Enter Key Catching The Escape Key The "If" Statement Nested "If" Statements

Return to Syllabus

Class 6
In this lesson the learning objectives are: Logical Operators Comparing, Testing and Working with Strings The "Select Case" Statement Introduction to Input Validation Radio Buttons and Check Boxes Program Design and Problem Solving

Return to Syllabus

Class 7
Getting Ready For The Midterm

Return to Syllabus

Class 8
Midterm

Return to Syllabus

Class 9
In this lesson the learning objectives are: Input and List Boxes Introduction to Loops: The "Do While" Loop Nested Loops List Boxes Multi-column Checked List Combo Random Numbers Simplifying Code with the "With...End With" Statement Tooltips Focus on Program Design and Problem Solving: Building the Vehicle Loan Calculator Application

Return to Syllabus

Class 10
In this lesson the learning objectives are: Procedures Passing Arguments to Procedures Functions More About Debugging Stepping Into, Over and Out of Procedures and Functions

Return to Syllabus

Class 11

In this lesson the learning objectives are: Multiple Forms Form Files and Form Names Renaming Your Forms Form Renaming Rules Adding Your Second Form Switching Between Forms Exclude and Including a Form Form Exclude (Remove) Form Include (Un-Remove) Class Vs. Object Properties of Object "Cat" Methods of Object "Cat" Instantiation Class Vs. Instance Making a Form Appear Closing a Form Hide Not Close Form Events The Load Event The Activated Event The FormClosing Event The FormClosed Event Accessing Controls on a Different Form Private and Public Class-Level Variables in a Form Public and Private Procedures Using Code Modules The Module Declaration Adding a Module Reusing Your Code Form and Module Maintenance in VB Menus Menu Systems Drop-down Menu Basics Shortcuts and Checks in Menus Menu Strip Control The Menu Designer Shortcut Keys Adding a Shortcut to a Menu Command Toggling Menu Items Disabling a Menu Item Separator Bars Submenus Menu Click Event Standard Menu Items Context Menus

Return to Syllabus

Class 12

In this lesson the learning objectives are: Arrays Array Characteristics The First Array Element Indexing and Array Subscript is Really Index Array Creation Alternative Array Creation String Array Creation Using a Constant as an Index Array Access Arrays and Loops The First Array Element Using a Loop to Initialize an Array Array Out of Bounds Array Bounds Checking VB Bounds Checking Not Fixing Getting the Length of an Array Arrays are like Variables Multiplication Addition Format String Load a LIstbox with an Array Common Array Constructs Total the Array Average an Array Find Array High Value Array Cloning -- Name Clone Array Cloning -- Value Clone Parallel Arrays List Boxes and Combo Boxes are Arrays Searching and Sorting Arrays Sorting is in Unicode (ASCII) Dynamically Sizing Arrays Using Arrays with Procedures and Functions Passing Arrays as Arguments Passing Arrays By Value and By Reference Returning an Array from a Function Multi-Dimensional Arrays Two-Dimensional Arrays Referencing Data Initialization Summing Five-Dimensional Array Dimensional Limits for an Array The List Data Type Declaring List Variables Common List Operations

Return to Syllabus

Class 13

In this lesson the learning objectives are: Using Files File Vs. Database File Maintenance Output to a File Input from a File Writing to a File Using Imports Stream Writer Object File Location Output to a File Locating Files From VB WriteLine and Write Methods Delimiters ReadLine and Read Methods The Read Pointer Closing a File (StreamReader) File Dialogs OpenFileDialog SaveFileDialog FontDialog ColorDialog Controls The PrintDocument Control File.Exist Method Finding the End of a File Working with Arrays and Files Together The File Filter Property Structures Arrays Vs. Structures Arrays: Multiple Fields in One Array All of the Same Data Type Distinguished by a Numerical Index Structures: Multiple Fields in One Array Can be of Differing Data Types Distinguished by a Field Name Creating a Structure Declaring a Structure Passing Structure Variables Arrays as Structure Members Arrays of Structures

Return to Syllabus

Class 14

In this lesson the learning objectives are: Basic Database Concepts Database Management Systems VB and Database Management Systems Layered Approach to Using a DBMS VB Supports Many DBMS's Database Concepts Terminology Database Table Record Field Key Structure and Content Database Nomenclature SQL Server Field Data Types Database Normalization VB DataGridView Control Data Flow From VB to Database Data-Bound Controls Advantages of Data-Bound Controls List Boxes Text Boxes Labels Combo Boxes Working With Data Sources Deleting a Data Source Binding the Data Source to a DataGridView Control The BindingNavigator Control The AdaptorManager Control Database Fields Direct To Form Connecting a ListBox Control to Your Database The DataSource Property The DisplayMember Property Adding Rows to a Database Table The TableAdapter SQL Database Keys Structured Query Language (SQL) SQL Basics The SQL SELECT Statement The Wildcard Character Sorting a SQL Query Filtering a SQL Query Using Query Builder in VB Using LINQ in VB Using LINQ to Add Query Results to a List Box Sorting the Results of a LINQ Query Ascending Order Descending Order

Return to Syllabus

Class 15

In this lesson the learning objectives are: Microsoft Web Applications Programming For The Web Hypertext and HTML What is a Protocol ? What is Hypertext ? Starting and Stopping Tag Fields What is ASP ? Development of ASP ASP.NET and the LAMP Stack Client Vs. Server Web Clients and Web Servers The URL -- Uniform Resource Locator To Display a Web Page Web Forms and Files Microsoft Web Services IIS Apache HTML Designer Types of Controls Creating ASP.NET Applications Open Website Dialog Box Types of Websites Creating a Web Application Opening an Existing Web Application Running a Web Application Project Web Server Controls Web Server Controls Overview How Web Controls are Processed Label and Text Controls CheckBox Control Handling Events in Web Forms HyperLink Control ImageButton, LinkButton and RadioButtonList ListBox Control CheckBoxList and DropDownList Designing Web Forms Using Tables to Align Text and Controls Adjusting Row Heights and Column Widths Applications with Multiple Web Pages Adding New Web Forms to a Project Moving Between Pages Calling Response.Redirect Using Databases Web Forms Database Access GridView Database Connection Setup Using a DetailView Control to Modify Table Rows SQL Queries Inside the SqlDataSource Control

Return to Syllabus

Class 16
Final Exam

Return to Syllabus