| Week | Information Assignments due in one week unless otherwise stated. Please note that I am not going to stay with the text - it moves to slow at the beginning and I want to cover more of the fundamentals quickly to give you more flexibility when you write your programs. However, the text is important because it will fill in some information that I may not emphasize. I want you to read the text chapter by chapter and I also want you to use it as a reference. If you are having problems with a concept, look it up in the text. |
|---|---|
| Week #1 Assignments Week of January 20th |
Read chapter #1 and chapter #2 in the text. View the presentations on introduction, settings and pay examples (including PFirst98). Note that if you go to the PowerPoint presentations part of this web site you will find separate speaker notes available. Starting in Visual Basic Introduction to Visual Basic Settings in VB Pay examples (projpay)- basic calculations PFirst98 which includes basic pay Look at the programs under Demo, ArithFst, FirstDay, Calculate, Pay #1, Pay #2 and First98. Sample programs - where the programs you should look at are located Notice that the programs can be downloaded or simply viewed through the html listing. Assignments: assign1.html Try Visual Basic Please send me all things ready to run on the root of the A drive - I am running into directory problems and I think that is the best solution. 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!!!! |
| Week #2 Assignments Week of January 27th |
NOTE: The text book is mainly for reference. The material and the order of the
material that I will cover is more closely covered in the PowerPoint presentations
and the sample programs that are covered in class. This is especially true at the
beginning of the course. The book is dealing with a lot of things that are good
to know and you should take note of them because they will help as you write your
programs. So... Read chapter #3 in the text. We are actually covering a lot of
the material in chapter #3 and chapter #4 so it would be a great idea if you
could read ahead or at least scan the material. You should look at a series of programs - you will find them under sample programs in the following catagories: Style with lines and shapes Inventory - IF Bill and Bill IF If Calculate Inventory Easy You should look at the following presentations: Style with lines and shapes Separate speaker notes to accompany style with lines and shapes Inventory programs (inven1, inven2, inven3 etc.) Separate speaker notes to accompany inven1, inven2, inven3 etc. Bill examples - using IF Separate speaker notes to accompany bill examples Calculate examples Separate speaker notes to accompany calculate examples Inventory example (inveasy) Separate speaker notes to accompany inventory example (inveasy) We may not finish them all this week - I will let you know! Assignments: Twenty things in VB |
| Week #3 Assignments Week of February 3rd |
Read chapter #4 in the text book. Again, remember that I am not following the structure
of the book which appears to be closely aligned to the structure of VB Help - I want
to get to topics like decisions, looping and files a lot earlier then we could if
we stuck with the topics in the book. However, again I do believe that the book
provides a lot of valuable information and should be read! Note loops are covered
in chapter #7 and data files in chapter #10 if you want to browse for information. Be sure that you keep a copy of everything you pass in! You should also keep the email that gives you a grade. At the end of the semester, you will be asked to fill out a status sheet and this information will help. It will also help if something did not get through - email is not perfect! Look at the examples and look at the PowerPoint presentation under Introduction to graphics/images. Several people tried to include images in their 20 things and ran into problems getting it to me - these examples and the presentation deal with these problems. Look at the examples under the category I/O Programs and look at the PowerPoint Presentation entitled Read and Write - I/O (note it has accompanying speaker notes). Look at the sample programs under the category For Loops and look at the PowerPoint Presentation entitled For loop examples (note it has accompanying speaker notes). I am putting out a program under Muffin Programs that I may or may not get to! Assignments: Note: This assignment does not include FOR loops! Vehicle Insurance Form |
| Week #4 Assignments Week of February 10th |
We are working more in chapter #7 - we will be coming back to chapter #5. I am
officially assigning chapter #5 to read but in fact you might find it helpful
to read through chapter #7 and then come back to #5. Please look at the muffin programs and the break programs. Look at the accompanying PowerPoint Presentations. You should also read the notes on breaks that are under Notes and Handouts and then Logic Notes. We will hopefully start DO loops, so start looking at the sample programs under (Delivery, DoTest, Convert For to Do While). Also look at the PowerPoint presentation on DO loops. If we do not do much with DO loops, we will start with them next week. I am adding a few examples to the site which I may reference. Assignments: Series of three short programs to be written Quiz This quiz is largely based on the book, so I would use the book as the major reference. You should work on this individually. Due February 27th, points will be taken off if the quiz is late. |
| Week #5 Assignments Week ending February 17th |
Read chapter #6 in the text. Continue looking at the information on DO loops. Look at the sample programs and PowerPoint presentations on functions and sub programs (subroutines). We will emphasize functions available from VB. Assignments: Function assignment |
| Week #6 Assignments Week ending February 24th |
Read chapter #7 in the text. Look at the sample programs and PowerPoint presentations on interest (another example of loops) and arrays (you should look at the examples up through muffins and the presentations up through Arrays continued - day of week will be next week). Assignments: Start in class assignment: Write a program to sort numbers using the top-down sort. Do a program similiar to the one that I did for the bubble sort. As sometimes happens, I did not get as far as I thought I would. The sort assignment above will not be given this week. It will be given next week. Assignment on if statements, functions, procedures, files etc. due in two weeks |
| Week #7 Assignments Week of March 3rd |
Read chapter #8 in the text - if possible start looking up information about arrays as well. Continue working on understanding arrays - look at sample programs and presentations! Assignments: Start in class assignment: Write a program to sort numbers using the top-down sort. Do a program similiar to the one that I did for the bubble sort. Please use Do loop - for extra credit you can also do it with a FOR loop. Array assignment My email has been down for a while - I will hopefully be up and running soon! |
| Week #8 Assignments Week of March 10th |
Read chapter #9 in the text. Continue working on arrays. I want you to look over the date program and make sure you understand what is happening - also think about alternative ways of approaching the problem! Notes on days of week program. I will go over the logic and then ask you to modify the program so that it handles numbers in the twenty first century as well! The handout that shows solutions for the dayofweek program that involves 1900s only is Day of week calculations We will start looking at random files this week so please look at the examples and the PowerPoint. Assignments: Day of week assignment Due in two weeks |
| Vacation Week Week of March 17th |
Hope you are enjoying vacation and getting caught up - I am trying, but I hope you are being more successful than I am! |
| Week #9 Assignments Week of March 24th |
Read chapter #10 in the text. We did not get to random files last week, so we will start with them this week. We will also look at the MaxProfit programs. Check back! Assignments: Payroll Project Due in two weeks |
| Week #10 Assignments Week of March 31st |
We will finish MaxProfit programs and look at using multiple forms, combo boxes,
error processing etc. Start reviewing Access if you already know it. I will go over it briefly in class, but only the parts we need to make things work in this course. Note: There are PowerPoint presentations and there are notes under CIS54 and under CIS61 that you might find helpful. Assignments: Assignment |
| Week #11 Assignments Week of April 7th |
We will start Access this week. I have a few little things left to do and then
we review using Access. We will skill Access 97 because it does not use ADODC - I leave it out there so you can see one of the previous connection methods. We started uisng at Getting Started with Access 2000 and got down to the set with 3 in them. Note there are SmartBoard demonstrations that I did in class. Assignments: No new assignments this week. Opportunity to catch up! |
| Week #12 Assignments Week of April 14th |
Please read chapter #11. Find an SQL tutorial to read - some possibilities are under links at this site. Look at the series of Donor programs under Getting started with Access 2000. Look at the programs under Access - ADO (I may not cover all of them) and More ADO - with Access. Assignments: First ADO Assignment |
| Week #13 Assignments Week of April 21st |
Please read chapter #12. Continue looking at my examples of ADO - we will get through most of them by next week and then we will start looking at using VB in Access and Excel. Assignments: Second ADO Assignment |
| Week #14 Assignments Week of April 28th |
You should skim through the rest of the text book for concepts and capabilities. Finish looking at the ADO examples. Final will be posted next weekend. Assignments: Last ADO Assignment |
| Week #15 Assignments Week of May 5th |
Note that the notes on using VB in Access are on the CIS56 main page under Notes
and Handouts and then Visual Basic in Access. Be sure to go over them carefully. Also look at the Excel examples under samples. misc.mdb Misc. with VB misctry.mdb Misc. with VB continued donor00.mdb - Access97 Check back for some more sample databases. The final must be passed in 2:45 on Tuesday, May 14th. 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 2:45 on Tuesday, May 14th then you must take the final during the alloted time. 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: Final Exam Status sheet - required must be passed in with the final or before |