| Week | Information |
|---|---|
| Assignments due in one week unless otherwise stated. I may add some things during the week, so double check the schedule each week! | |
| Week #1: Week of September 1st |
This week we will spend time going over ADO which was the last topic last semester.
Please review the notes, examples and presentations on this topic in CIS56. |
| Week #2: Week of September 8th |
Topics we will cover: We will continue the review of ADO. Read chapter #1 and #2 when the you get the text. Look at my examples MID Examples, SDI Examples and Combined SDI/MDI examples. Look at the accompanying PowerPoint Presentations. Assignments: ADO and SDI/MDI assignment |
| Week #3: Week of September 15th |
Look at the information on form events (programs). Look at the information on Simple Print Reports (programs and presentation) and the Mask Editing presentation - those I am leaving you to handle on your own. Note that there are zipped files that contain one or more programs in a specific category. Start looking at the controls programs and all the programs that come before them including misc. Pay special attention to image lists. We will work on them this week and next. Check and see which subjects have accompanying PowerPoint presentations and review them. We will finish the review of ADO when I get to the chapters on ADO - remind me that I did not cover updating! Hopefully we will get caught up in a week or two! Assignments: Experiment with controls. Write a simple program that uses five of the controls covered in the text (chapter #2). |
| Week #4: Week of September 22nd |
You should have looked at all of the examples and topics through programs by the
end of next week - that is if I make it through the things I plan to cover. Note that we are going to spend time on ADO this week, so you should start reading the chapters that deal with ADO - chapters #3 and chapters #4 - again continuing into next week probably. Note we will not cover environment until we finish some of the other parts of ADO. We will also go over the design of a relational database and SQL. A little bit of everything... Some information on relational databases and third normal form is at my Oracle site: Handout on definitions: Normalization definitions Also view the slide presentation on normalization: Normalization - information on third normal form Separate speaker notes for normalization presentation Assignments: Hangman assignment |
| Week #5: Week of September 29th |
This week we will deal with data environment designer. We spent the inclass
time in the lab where students became comfortable with the basics of the data
environment with one table and the basics of the report. Some students started
to deal with hierarchy, but that was not part of the lab. Assignments: Students that were not in class should experiment and send me the results. The first three PowerPoints under Data Environment and the beginning programs will help. The book also has a lot of step by step instructions. All I want is proof you are comfortable with establishing and using a data environment with one table and producing a report from the data. |
| Week #6: Week of October 6th |
We will finish up with data environments this week and go over some other aspects
of ADO following the information in the text. Please look at sample programs and
PowerPoint presentations on these topics. Please read chapter #5. Assignments: Students need to work with Environment heirarchies and group reports. Please send me pictures of screens or explainations of what you did to test these concepts. ADO Assignment - due in two weeks |
| Week #7: Week of October 13th |
Finish looking at the examples and presentations dealing with connecting to databases.
Go over the PowerPoint presentations in Connection to Access through code and the samples
under Coded Connections. Assignments: Questions about ACDinCode1.vbp Program under update - mentions the assignment |
| Week #8: Week of October 20th |
First we are going to look at Shape language and then we are going to move on to
object-oriented programming in VB. Please read chapter #6. Spend time going over the programs in the category Class Items. I ended up feeling to sick to go to the conference, so I am home and willing to correct and help - so continue sending email! Assignment: Write a program using a checking account where you deposit or withdraw or a payroll application where you keep a base pay that is increased with this weeks work or some other basic application similiar to what I did in PrItemClassEvent.vbp. In class students did this during lab time. Distance Learning students need to do it on their own. |
| Week #9: Week of October 27th |
We are going to continue with Classes and start looking at the programs under
Savings Account Class - we will get through version 02 which starts to deal with
collections. Also look at the second PowerPoint Presentation that is called More
Introductory material using class module savings account. Assignment: Class/Collection Assignment |
| Week #10 Assignments Week of November 3rd |
Go over chapter #6 very well! Start reading chapter #7. Look at the Class Item series of programs and the SavAcctCls series of programs. I do not know how far we will get - check back! Just a suggestion, but I would consider going through the entire step by step process that the book sets up for chapter #6. I found it a good way to make sure I did not skip anything being covered in the chapter. Look at the presentations that accompany class item and savings accounts. Assignment: No assignment |
| Week #11 Assignments Week of November 10th |
No class this week, but... Finish reading chapter #7 Assignment: As I told you in class, your next assignment is to modify the class program you just wrote so it uses a database. It must be able to add records to the database, retrieve records from the database, change records on the database and delete records from the database. (Due in two weeks) Pass in both the original and the modification that uses the database as separate programs. Note if you prefer to write a totally separate program, that is okay too! |
| Week #12 Assignments Week of November 17th |
Please read chapter #8 and look at the examples and presentations on DLL.
I want you to duplicate what I did in the PowerPoint presentation on DLL. We will
work on this during class. Please bring some of your CIS56 programs on floppy disk. If we have time we are going to try to run them in VB.NET which will involve some conversion. Assignment: Assignment to be done over the next couple of weeks. Look at the version of the MineSweeper program that my husband wrote and I posted at the site. Try to develop an understanding of what he did. If you email me questions, one of us will get back to you. I also suggest using the board room to discuss how the program works. Your assignment is to pick 10 new things you see in this program and explain how they work. MineSweeper In lab we set worked with dll using the PowerPoint on ActiveX DLL. If you did not get it working in lab or if you did not attend lab, you should get it working on your own and send me screen shots showing the results. Do not send me anything in VB. |
| Week #13 Assignments Week of November 24th |
Please read chapter #9 and look at the information on ActiveX Controls. We are going to review the using VB in Access that I did in CIS56 since a lot of you were in the night class and Roger said he did not get to this. I am going to New York for the holidays and won't be home until the weekend. Please hold email until Saturday to keep my email from choking. Assignment: Modify the key pad ActiveX Control so that it acts like a calculator and does addition, subtraction, multiplication and division. You will have a chance to start this in lab. Do something combining VB and Excel. Do something using VB in Access. The grade will vary based on whether you really experiment or just do the minimum. |
| Week #14 Assignments Week of December 1st |
This week we are going to go to the lab and experiment with VB.NET. If you are in
the lab, this will count as your assignment. Assignment: If you were not in the lab experiment with VB.NET you need to send me proof you have worked on it. The proof should include comments about what you did, a program you wrote, a program you convert and things that you found that were different. Option #1 for the final exam |
| Week #15 Assignments Week of December 8th |
The last topic is using VB with the Internet. Please look at the PowerPoints and examples
and read the information in the text. We will also look at connecting to an Access database using VB.NET. The rest of the class, you can go to a lab and do the assignment below or work with VB.NET. Assignment: Assignment Part 1: Set up Internet controls to browse the web. Assignment Part 2: Create two linking DHTML pages that take in information and do calculations based on that information. The amount of work that you do will influence the grade! Assignment Part 3: Following my example, connect to a database using VB.NET. |
| Exam Week Week of December 15th |
You must pass in both the status sheet and the final exam! The final and the status sheet must be passed in by 2:45 on Tuesday, December 16, 2003. You may either email them to me by that time or you may pass them in at that time in the designated room. Additional instructions are on the exam, please read them carefully. Final Exam Status Sheet - required |