| 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. |
|---|---|
| Notes and assignments #14 | We will continue with ADO this week - look through chapter #11. We will not finish ADO this
semester - it will be the first topic next semester. Assignments: Either create a database with multiple tables or use a database other than the donor and student one that I use for examples. Two of the tables should be in a one to many relationship (an example is donor and donation where one donor gives many donations). Do something to show the information from both tables on the form. You can use text boxes and/or grids and you can set the tables up separately or combine them with an SQL statement. Be creative! Extra credit if you included the ability to add records. I want this assignment done with code, not with the Server Explorer. Let me know when you want me to send you the final. You will have one week to do it. |
| Notes and assignments #13 | We will continue working with ADO - please look at the examples and Powerpoints. You should
pay attention to grids. Assignments: This assignment relates to grids: For an A on the assignment: Using a different database than I used, do something with two files where information for one file is displayed in text boxes and information from the other file is displayed in a grid and you match the records. I did donor and donation. The example I did is donortwotables. For a B on the assignment: Do something involving two data adapters and displaying different information. Again use a different database then I did. The example I did is SQLdiffcode. Feel free to experiment and add more things for extra credit or you can do both for extra credit. |
| Notes and assignments #12 | Read chapter #10. We will start working with databases. You should look at the examples and
the PowerPoint called ADO first. Assignments: You need to follow my PowerPoint and set up a program to read from a database of your choice. The PowerPoint is called ADO introduction. Extra credit if the code is in the program so no adjustment is needed to run on my computer. |
| Notes and assignments #11 | Please finish reading chapter #9. Also be sure you remember (or learn) how to work with Access.
You should be comfortable creating a basic table and querying it etc. Then read chapter #10 because we will start dealing with databases next week. Information on printing (programs and PowerPoints) have been posted and you should go through them as well as the information in chapter #9. Assignments: No new assignment - please use the time to work on getting caught up! |
| Notes and assignments #10 | We are going to continue with arrays this week. Then we will move on
to chapter #9, so please start reading that. Assignments: Assignment #1: Look at the presentation on the logic of a top down sort. It is located under Arrays/Topdown sort in the VB6 presentation. VB6 Presentations Then you should modify one of the programs I did using the bubble sort so that instead of the bubble sort it does the topdown sort. For a B, modify bubblesort and for an A, modify arraysort. Both programs are in the zipped collection of array programs. We started this in class and will look at it at the beginning of the next class. Assignment #2: 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. |
| Notes and assignments #9 | Continue looking through chapter #8 and the array examples. We will continue to look at arrays
including two dimension and searches. Assignments: I want you to write a program using an array and a structure. |
| Notes and assignments #8 | Please read chapter #8 if you haven't yet. We will focus on arrays this week. Be sure to start looking at the examples and the presentations. We will continue with arrays next week. Assignments: Array Assignment |
| Notes and assignments #7 | Please read chapter #7 and then move on to 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!
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. |
| Notes and assignments #6 | 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. 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. |
| Notes and assignments #5 | Read chapter #6 in the text. Since I was out last Thursday, we did not not finish loops this week. We will continue with chapter #5 and probably we will not actually start chapter #6 until next week... There is an error on the break PowerPoint. On slide 24, I do not actually check for a dept break. I have fixed it but am waiting for some problems with my BCC host to be able to upload. Assignments: Loop assignment |
| Notes and assignments #4 | 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 review if statements and then 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 |
| Notes and assignments #3 | 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 started looking at loops. Assignments: Insurance form and file |
| Notes and assignments #2 | Read chapter #3 in the text. This week are starting to look at conditions.
Please look at the three Powerpoints having to do with IF and the samples
of if statements. If you want copies of the programs to run as I am running or copies of the code to look at in class, please download and print before class. Assignments: IF assignment in class students will start this program in class |
| Notes and Assignments #1 | The topics will be posted as 14 sets of notes and assignments. You need to plan your schedule
to cover all 14 sets. The summer is not 14 weeks, so plan accordingly. Read chapter #1 and chapter #2 in the text. You should be looking at the beginning examples and code and the beginning PowerPoints. This course uses VB.NET. There is a version available through the college. Let me know if you would like a copy. Assignments: assign1.html |