Advanced Visual Basic - CIS67

Weekly Schedule

Week Information
Assignments due in one week and programs in two weeks unless otherwise stated
Week #1 Assignments
Week of June 3rd
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). Review the following programs: 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.
Be sure to cover all of the presentations and programs about SDI and the muffin series.
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.
Assignments:
First assignment
Week #2 Assignments
Week of June 10th
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 continue reading chapter #3 and make sure you are comfortable with the concepts of designing a relational database and third normal form.
Start reading chapter #4.
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:
Second assignment
Week #3 Assignments
Week of June 17th
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 and start reading chapter #5 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.
Please look at the additional ADO examples and the PowerPoint presentation!
Assignments:
First ADO assignment
Week #4 Assignments
Week of June 24th
Please finish reading chapter #5 - we will deal with some of the information in it next week. We will be covering the update examples next week as well.
Please look at the examples on Data Environment and the Power Point presentations.
Assignments:
First Data Environment assignment
Week #5 Assignments
Week of July 1st
Please look at the rest of the projects added under Data Environment and the projects under Coded Connections.
Continue looking at the update examples under Data Environment this week.
Please look at the PowerPoint presentations on these topics!
Please start reading chapter #6.
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 #6 Assignments
Week of July 8th
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:
Assignment using Update Program
Week #7 Assignments
Week of July 15th
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.
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.
Assignments:
Your assignment involves SavAcctCls02 or SavAcctCls03. 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. In addition to interest rate, you should add a button that can be clicked to subtract a bank fee from the balance and another button to subtract any penalty that is applied by the bank. These should be handled as methods.
Week #8 Assignments
Week of July 22nd
We will focus on the class concept this week!
Start reading chapter #7 for next week.
Assignments:
Class assignment
Week #9 Assignments
Week of July 29th
Finish reading chapter #7.
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!
Assignment:
Your assignment is to modify the class program that you were assigned last week 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.
Week #10 Assignments
Week of August 5th
Finish reading chapter #8 and move on to read chapter #9.
Please look at examples and presentations on DLL, EXE, Word and Excel.
Start looking at ActiveX controls including the sample PowerPoint presentation.
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.
Week #11 Assignments
Week of August 12th
Chapter #9 is the topic this week. We cover ActiveX Controls. Please see the sample notes and the PowerPoint presentation.
Assignment:
Assignment: Modify the key pad ActiveX Control so that it acts like a calculator and does addition, subtraction, multiplication and division.
Week #12 Assignments
Week of August 19th
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!
Final will be posted!
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 #13 Assignments
Week of August 26th
The final must be passed in 4:00 on Monday, August 26th. All students must take the final whether or not they will complete the course on time. The final is given on the honor system and I trust you to respect that - the only person you can discuss the final with is me!
If you have not passed in the final by 4:00 on Monday, August 26th, points will be subtracted. The status sheet is a requirement of the course - it is also your insurance to make sure that you and I have the same information - I will contact you if there is a problem!
Please send me the final using the usual email address and also send a copy to me at pgrocer@bristol.mass.edu.
Final Exam
Status Sheet - required
If you need a little extra time to complete the work, let me know. The summer involves the same amount of work with less time so I will be as flexible as I can. However, if something is going to be late, we must have agreed via email or penalty points will be taken from your grade.

Send e-mail to Mrs. Grocer:
pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page