Visual Basic - CIS56

Weekly Schedule

Week Information
Information: Assignments due in one week unless otherwise stated.

I am going to try to stay with the text to some degree but I am going to cover file handling sooner. Check the schedule several times a week, I may add some things during the week. Also please note that Notes and assignments #1 is at the bottom.

Week #15
Week of December 11th
Contact me when you are ready for the exam.
Week #14
Week of December 4th
Be sure you have read the material on ADO (chapters #10 and #11).
Catch up week!
Week #13
Week of November 27th
We will continue working with ADO - please look at the examples and Powerpoints. Assignments:
I would like you to write two programs (both need connection code):
First: A program that will bring up the user specified record from the database.
Second: A program that will let you add, change and delete records on a database.
Week #12
Week of November 20th
We are going to continue on with ADO. You can start looking at some of my examples or you can wait until I go over them in class.
I would like you to write three programs using ADO:
First: A program that uses two tables in a 1 to many relationship with the data from the one table displayed in text fields and the data from the many table displayed on a grid. You need to move through the data from the one table and bring up the matching records from the many table.
Second: A program with two grids and the ability to select a record from one grid and match to records on the second grid. Each grid should have data from a table.
Third: A program that uses an SQL that brings together data from three tables (correctly related), and displays the data in a grid.
Week #11
Week of November 13th
Advisement: Advisement information
On line advisement is available through email or IM. You can also make an appointment for advisement on my door. More dates will be added on my door.
Working on ADO.
You need to follow my PowerPoint and or examples and set up a program to read from a database of your choice. The code should be embedded in the program so that I do not have to change anything to execute on my computer.
Week #10
Week of November 6th
Please be sure you have read chapter #9 and #10.
This week we are going to start looking at ADO. In class, we will experiment so be sure you have an Access database available that you can experiment with.
I want you to do the charge account validation problem at the back of chapter #8 (page 539). However I want you to establish the array to hold the numbers without specifying how many elements will be entered into the array. Then have the user determine how many charge accounts are going to be entered in the array. Once the number has been determined, the user should enter the appropriate charge numbers into the array.
You should have the user enter at least 8 numbers into the array.
Week #9
Week of October 30th
Please read chapter #9 and next week please read chapter #10.
This week we will talk about printing a report and then we will spend some time reviewing Access. Next week, we will start looking at connections to Access through Visual Basic.
I am going over the basics of Access this week. If you have not had a course that has included Access, I suggest that you look at the introductory material under CIS17.
Array Assignment using structures and redim (see clarification of print report in the assignment)
Week #8
Week of October 23rd
This week we will continue looking at arrays. Check back to see how we are doing!
I want you to look at the information about the Bubble Sort. I also have information about the logic behind the Top Down Sort. To help you understand the structure of these sort alogrithms. Please review this information. I used the following presentations:
Topdown sort
    Separate speaker notes to accompany topdown sort
Bubble sort
    Separate speaker notes to accompany bubble sort
Modify my Bubble Sort program so that it does a Top Down sort.
Array Assignment
Week #7
Week of October 16th
Please read chapter #7 this week and start chapter #8. Look at the examples and the PowerPoints dealing with multiple forms and menus and be sure to look at the more complex examples in the text. It is a good text in my opinion so I highly recommend doing the reading!
This week we will start to look at arrays.
Practice exercise (not to be passed in): Menu/Forms
VB Function assignment
Second assignment: I also want you to experiment with forms and passing data from one form to another. You can include that in the VB Function assignment (my first choice) or you can do a separate assignment.
Week #6
Week of October 9th
We will focus on chapter #6 this week. If you want to read ahead, chapter #7 is obviously next!
Finish looking at the PowerPoints and examples for loops, combo boxes, validation etc. and start looking at the Presentation and examples for procedures and functions as well as multiple forms and menus.
Procedure/function assignment
I made a mistake - the editing/validating for ABC etc. should be done in the first program not the second. You should be editing before you write the file.
Week #5
Week of October 2nd
Read chapter #6 in the text.
We will actually look at things from chapter #5 this week and probably will not get to chapter #6 until next week.
Be sure you are using the resources at the site in addition to the text book.
Loop assignment
Note that these are two separate programs - I have had some confusion before.
Week #4
Week of September 25th
Read chapter #5 in the text. We started looking at loops last week and we will continue this week. Be sure you have looked at the PowerPoint presentations and examples.
We are going to continue looking at both conditons and loops. On Tuesday we will continue with the discussion of loops.
I want you to modify the quess the number program so that the user only gets a certain number of chances (let's say 5). When they have used all of their chances an appropriate message should display and the Play button should become visible.
Rock, Paper, Scissors Assignment
Week #3
Week of September 18th
Read chapter #4 in the text. We will continue looking at conditions and we will also look at creating and reading sequential files (note that this is not covered in the assigned reading but you can find it in the text).
Look at the examples and presentations on conditions and files. We may start looking at loops.
I had some trouble with recordings in this class last semester, so they are spotty!
Program design
Insurance form and file
Notes and assignments #2 Read chapter #3 in the text. This assignment set is starting to look at conditions. Please look at the three Powerpoints having to do with IF and the samples of if statements. Remember there are sample programs available to illustrate all concepts.
If you want copies of the programs I cover in my Powerpoints, please download the examples.
For other times that I am available, please check Help Lab
IF assignment
Notes and assignments #1 During the course of the summer there will be 15 notes and assignments that need to be done. This means some weeks you need to do more than one. You can plan your schedule around vacations etc. If you need me to post more, let me know. Read chapter #1 and chapter #2 in the text.
You should be looking at the beginning examples and programs and the beginning PowerPoints. This course uses VB.NET. There is a version available through the college. For information about software for this course: MSDN Alliance Software

Send e-mail to Mrs. Grocer:

Back to the Top
Return to home page
Return to previous page