| Week | Information Assignments due in one week and programs in two weeks unless otherwise stated |
|
|---|---|---|
| Week #1 Assignments Week ending September 7th |
Read chapter #1 and #2 in the text. If you choose to use another book, the topics to read about are Installing and Configuring Visual Basic, Interfacing with the user including MDI and SDI, Windows Common Controls (which we might get to next week or it might be another week). Review the programs done in class: PRMDIBasics.VBP, PRMDIBasicsA.vbp, PRMDICustomer.vbp. Also look at the presentations on these topics: MDImenucontrol and MDIwinmenu. 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. |
|
| Week #2 Assignments Week ending September 14th |
Continue reading chapters #1 and #2 and checking the presentations and programs
about SDI and the muffins series. First assignment | |
| Week #3 Assignments Week ending September 21st |
Please look at the last program about Popup menus at the bottom of Combined SDI/MDI. 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. 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 Second assignment |
|
| Week #4 Assignments Week ending September 28th |
Please review ADO by looking at the text book, programs, notes and the PowerPoint presentations. I would also like you to experiment with the Data Environment and Data Report Designer - do something simple that is not to be passed in. Read chapter #4 in the text. Be sure you are comfortable with the concepts of SQL - basic information is available at this site but you might also look for a web source as a supplement. Experiment with using SQL in ADO. There is no project this week - I want you to spend your time becoming very comfortable with the information in chapters #3 and #4. |
|
| Week #5 Assignments Week ending October 5th |
Please look at the additional ADO examples and the PowerPoint presentation! Read chapter #5 in the text. First ADO assignment |
|
| Week #6 Assignments Week ending October 12th |
Please look at the examples on Data Environment and the Power Point presentations. They
are all uploaded and ready. I did not get to the update examples that
are on the web - those will be next week. We will be covering the update examples
and the information in chapter #5 next week. First Data Environment assignment |
|
| Week #7 Assignments Week ending October 19th |
Please look at the rest of the projects added under Data Environment and the
projects under Coded Connections. As promised I will get to the update examples under Data Environment this week. Please look at the PowerPoint presentations on these topics! Please read chapter #6, we will look at that next week. 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 26th |
Look at the programs under shape language. Also look at the update program. Your
assignment is to analyze the update program and do the related assignment. Note, if you download the update, be sure to download the .frx as well - there is a connection in it to the combo box, so... Assignment using Update Program |
|
| Week #9 Assignments Week ending November 2nd |
Look at the editing changes in the update program - new version Go over chapter #6 very well! Look at the Class Item series of programs and the SavAcctCls series of programs. Your assignment involves SavAcctCls02 or SavAcctCls03. Note: We did not cover SavAcctCls03 in class although it was my plan. Therefore, you might prefer to do the assignment using SavAcctCls02 (the slide presentation currently only goes through this program). 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. If you are doing this assignment after mid November of 2001, then 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. 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. We will start to look at chapter #7, so you should start reading that as well. |
|
| Week #10 Assignments Week ending November 9th |
There is apparently a problem with the server where I put the examples and presentations for this
course, I will check on it tomorrow, but I suspect that I will not be able to load for a day or two!
The server I use for this page is okay, so... We will focus on the class concept this week! Really, we will cover chapter #7 next week - it is a chapter with difficult concepts! Class assignment |
|
| Week #11 Assignments Week ending November 16th |
I am home sick. I am reluctant to start the class/database over the Web so I have decided to have you look at chapter #10 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! Do some catching up! | |
| Week #12 Assignments Week ending November 23rd |
No class this week | |
| Week #13 Assignments Week ending November 30th |
We will cover using classes and Access databases. Please look at the program under
SavAcct07 which deals with class and database and check out the PowerPoint
presentation as well! Your assignment is to modify the class program that you were assigned the week of November 9th 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. For next week please read chapter #8 and we will deal with ActiveX. The next chapter will be chapter #9. |
|
| Week #14 Assignments Week ending December 7th |
Please look at examples and presentations on DLL, EXE, Word and Excel. Assignment:Use SavAcct07 and set up the DLL (In-Process) for the class modules. You need to duplicate what I did in the PowerPoint presentation on DLL. If you were in class Friday, we did this in the lab and therefore the assignment is done. Please read chapter #9. The final is posted! |
|
| Week #15 Assignments Week ending December 14th |
Chapter #9 is the topic this week. We cover ActiveX Controls. Please see the sample notes and the
PowerPoint presentation. Please work on the final and any missing assignments! |
|
| Final Exam Due December 21st at 4:00 |
Required status sheet Final Exam due at 4:00 on Friday the 21st of December. The final must be emailed to my usual address and to pgrocer@bristol.mass.edu. If you cannot email me the final by then, you must contact me ahead of time to make arrangements! I will not be on campus on Friday! If you want to pass the final in other than by email, you must have it at my office by 4:00 on Thursday the 20th of December. Contact me if there is a problem and we will develop a solution! |