| Week | Information Assignments due in one week and programs in two weeks unless otherwise stated |
|---|---|
| Week #1 Assignments Week of September 2nd |
Read chapter #1 and #2 in the text. Please spend some time reviewing the concepts about ADO over the next few weeks. Focus on the information that was covered in CIS56 - the information and examples are available at the CIS56 site. The topics to emphasize when reading the text this week are: Installing and Configuring Visual Basic, Interfacing with the user including MDI and SDI, Windows Common Controls (which you should focus on for next week). Send me an a summary of your experience with Visual Basic. You must have access to the Professional version of VB which would include help to take this course! Some of the topics require full versions instead of student versions. Read the first chapter in the text for additional information. Make all work portable so that I can run it off any drive. I do not want to deal with hardcoded paths. However if a problem develops send me all things ready to run on the root of the A drive. That means after all is working, save to the A drive and test there. Send me that working model and I too will test off the A drive! Let me know if you have done this. Topics we will cover: Look at the following programs: PRMDIBasics.VBP, PRMDIBasicsA.vbp, PRMDICustomer.vbp. Also look at the presentations on these topics: MDImenucontrol and MDIwinmenu. Move on and look at the rest of the sample programs concerning MDI and SDI and look at the related PowerPoint presentations. Assignments: First assignment |
| Week #2 Assignments Week of September 9th |
Apparently there was some confusion over the book. The result is you need to
order a copy of the book from your favorite source. The information on the book is: Advanced Programming using Visual Basic 6 Bradley and Millspaugh Irwin/McGraw-Hill ISBN 0-070242024-3. They give as a referrence www.mhhe.com. Read chapter #1 and #2 when the book comes in. Look at my examples MID Examples, SDI Examples and Combined SDI/MDI examples. Look at the accompanying PowerPoint Presentations (from last week I have the SDI Examples left to cover and a few things in the other examples). Look at the information on form events (programs). Look at the information on Simple Print Reports (programs and presentation). 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. Assignments: Hangman assignment Due in two weeks. |
| Week #3 Assignments Week of September 16th |
Also you need to look at the programs under controls and dynamic and the accompany
slide presentations under controls. Please read chapter #3 and make sure you are comfortable with the concepts of designing a relational database and third normal form. If you have time you can also start reading chapter #4 (officially assigned for next week). 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: You can make the modification to hangman to include databases or add it next week. Your choice but eventually the hangman program needs to be able to randomly access an Access file for a word. You need to either incorporate four additional controls (you already have an image list in hangman) into the assignment from week 1 or week 2 or you need to write another program that uses 4 additional controls. Information: My modem burned out during the thunder storm so I have been off line for a couple of days. I received lots and lots of messages and I am working on getting caught up. |
| Week #4 Assignments Week of September 23rd |
Read chapters #3 and #4 dealing with ADO. Browse through the web site looking at
the ADO notes and examples that are appropriate for you. I will definately make
it through ADO samples using grids and probably start ADO samples using SQL. Note
that there will be no in class on Friday since I am going to a conference on
VB and .net. Assignments: I would like you to work on designing a relational data base for a pool order system. The person who proposed this as a practical example is in the class and will answer questions on the board. I would like the class to exchange information on the board and then each person send me a suggested design by next weekend. The information is Pool information |
| Week #5 Assignments Week of September 30th |
Continue looking at the ADO samples - you should end up covering all of the samples
located on the first page of sample programs (Samples
on the first page) Start looking at Data Environment (covered in chapter #3 in the text). Be sure to look at the PowerPoint presentation on Data Environment tutorial. Reminders: I need to get your design of the relational data base for the pool order system. You need to revise the hangman program so it uses an Access database to bring in the word. You should look up randomizing a number and then you should use a random number to access a record that contains a word for the user to figure out. Assignments: ADO assignment |
| Week #6 Assignments Week ending October 7th |
Please look at the examples on Data Environment and the Power Point presentations.
Needless to say you should also go over the information in the text. Assignments: First Data Environment assignment I did not get through all of the examples this week - I will continue next week. You can leave some of the elements of this assignment for next week! |
| Week #7 Assignments Week ending October 14th |
Please read chapter #5. Please look at the rest of the projects added under Data Environment and the projects under Coded Connections. Please look at the PowerPoint presentations on these topics! Assignment: Take one of the programs that you have done using the ADO Data control or the Data Environment and modify it so that all of the code is in the program and you do not need the either the ADO Data Control or the Data Environment. |
| Week #8 Assignments Week ending October 21st |
Please read chapter #6. Finish up looking at ADO examples. Assignment:I will be at a conference on October 24th and October 25th so there will be no classes those days. So, no new assignments - continue working off the examples and presentations at the web site. |
| Week #9 Assignments Week of October 28th |
Look at the programs under shape language. Also look at the update program (both versions).
We will look at the sample programs under class items as well. Be sure to look
at the related PowerPoint Presentations. We have started to look at object-oriented examples similiar to the ones covered in chapter #6. Look at the examples under Class Items and the first examples under Savings Account Class. Also look at the first two PowerPoint presentations under Class. We will continue with more examples for the next few weeks. Assignment: Your assignment is to analyze the update program and do the related assignment. Note, when you download the update, be sure to download the .frx as well Assignment using Update Program As always, be sure to check back and see if I have added or changed! |
| Week #10 Assignments Week of November 4th |
Go over chapter #6 very well! 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 - but for no assume through SavAcctCls03 (we might get to 04). 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. Assignments: Your assignment involves SavAcctCls02 or SavAcctCls03. On to the assignment: There is a button on the form called Apply Interest that does nothing. I want this button to update the balance by including the interest. I would do this using simple interest, when the button is clicked the current balance should be increased by balance times interest rate. This should be done as a class method. In addition to interest rate, you should add a button that can be clicked to subtract a bank fee from the balance. This should be handled as a method. Other 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 |
| Week #11 Assignments Week of November 11th |
Review the programs in the SavAcct series. Please read chapter #7. Assignments: Class assignment 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. |
| Week #12 Assignments Week of November 18th |
Please read chapter #8. Please look at examples and presentations on DLL, EXE, Word and Excel. We will deal with DLL this week and start to move on to using VB in Word and Excel. Next we will do chapter #9 and ActiveX and then finally look at the Internet. Assignments: Use SavAcct07 and set up the DLL (In-Process). For those in class, this is done! for the class modules. You need to duplicate what I did in the PowerPoint presentation on DLL. Check back! |
| Week #13 Assignments Week of November 25th |
For next week: Chapter #9 is the topic this and next week. We cover ActiveX Controls. Please see the sample notes and the
PowerPoint presentation. I will also be looking at the Internet and Chapter #10, so you need to read this chapter. Essentially next week we will deal with both of these topics. Assignment: For next week: Modify the key pad ActiveX Control so that it acts like a calculator and does addition, subtraction, multiplication and division. |
| Week #14 Assignments Week of December 2nd |
Note that my web site is having problems. It is accessible through dial up
connections and at BCC. There is a problem with the ATT Broadband domain name
server that will hopefully be fixed this week. Please read chapter #10 and look at the Internet programs and Internet presentation I have put out on the Web. If you do not know HTML, it would be good to look over the basics. You can either find an HTML tutorial or you can look at the Notes I have under CIS44 - first week or so is enough! We will look at this information next week. Extra Credit 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! |
| Week #15 Assignments Week of December 9th |
Look at the examples under Internet and note the extra credit assignment posted
last week. There is also a PowerPoint presentation on Internet. Look at the ATM project: ATM Zip The final is due on December 20th at 3:15. It must be accompanied by a status sheet. The final and status sheet should be emailed to me at the standard address you have used this semester and also to pgrocer@bristol.mass.edu. If you do not pass in the final by December 20th at 3:15, you must show up to take the final at that time. Note that the final is given using the honor system - you may not discuss the final with anyone but me - I trust you to do the right thing! Also note that the final and the status sheet have to be done by everyone - even if you plan to take an incomplete in the course - talk to me if this is a problem. Final Exam Required Status Sheet |