| 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. Assignments: 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. Assignments: 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. Assignments: 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. Assignments: 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 Assignments: 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 Assignments: 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. Assignments: 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. Assignments: 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. Assignments: 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! Assignments: 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 Assignments: 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 Assignments: assign1.html |