| Week | Information Assignments due in one week unless otherwise stated |
|---|---|
| Week #1 Assignments Week ending January 25th |
Read chapter #1 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 ending February 1st |
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 especiall 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 #2 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 (I forgot to list this and the accompanying presentation!!!! 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 ending February 8th |
Read chapter #3 in the text - 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. I am having some trouble with my email - if you do not hear back from me within a week about assignments or questions, check back and see if you got through okay. Hopefully things are on the mend! Be sure that you keep a copy of everything you pass in! 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 ending February 15th |
Read chapter #4 in the text and if you get a chance it would be great to start
looking at chapter #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 probably get to 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. Assignments: Page 168 in the text, problem 4.6 |
| Week #5 Assignments Week ending February 22nd |
Read chapter #5 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). Assignments: Function assignment |
| Week #6 Assignments Week ending March 1st |
Read chapter #6 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). I apologize for the slow down in email responses - my daughter and her husband were home from Turkey and I was "irresponsible" about email during their visit! 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. Assignment on if statements, functions, procedures, files etc. due in two weeks |
| Week #7 Assignments Week ending March 8th |
Read chapter #7 in the text - if possible start looking at chapter #8 as well. Continue working on understanding arrays - look at sample programs and presentations! 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 if you like! Notes on days of week program. I will go over the logic on Thursday 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. Next week we will look at the programs dealing with Max Profit so please look at those programs and the accompanying PowerPoint presentation. Assignments: Day of week assignment Due in two weeks Array assignment |
| Week #8 Assignments Week ending March 15th |
Please read chapter #8. I also suggest you read the random file section in
chapter #10. We will continue with random files on Tuesday and MaxProfit programs on Thursday. Assignments: Payroll Project Due in three weeks |
| Spring Break Week ending March 22nd |
Time for us all to get caught up - hopefully! |
| Week #9 Assignments Week ending March 29th |
Skim chapter #9 - we may or may not cover object oriented this semester - if we do
it will be at the end of the semester and you can reread the chapter then. This
chapter will be a good chapter to read prior to taking the second semester course. Read chapter #10 (be sure to read the information about error handling). If you have time start reading chapter #11. Look at the examples on using two forms - programs and presentations. Also look at the information on combo boxes - programs and presentation. Be sure to review you basic knowledge of Access. There are PowerPoint presentations and there are notes under CIS54 and under CIS61 that you might find helpful. Please spend time getting caught up and making sure you are comfortable with Access. |
| Week #10 Assignments Week ending April 5th |
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 (sorry that I did not get everything loaded this weekend as I said I would in class - I had some problems uploading). Look at the programs under Access - ADO (I did not cover all of them) and More ADO - with Access. Assignments: First ADO Assignment |
| Week #11 Assignments Week ending April 12th |
Please read chapter #12. Please continue looking at the programs under Access - we are going to deal with updating and some more information on grids etc. this week. Sorry - the assignment is late - I was sick. Assignments: Write a program that will update a table - you should be able to add records, change records and delete records. The table should be a database table that you are connected to through an ADO. |
| Week #12 Assignments Week ending April 19th |
Look at the examples under still more ADO - we will cover those in class on
Tuesday - remember Thursday is Monday so there is no class on Thursday! There is one more ADO project - see the assignment under Week #13. |
| Week #13 Assignments Week ending April 26th |
Please skim chapter #13 and read chapter #14. You are on your own covering
this information. I want to take a look at how Visual Basic is used in
Access. The notes on using VB in Access are on the CIS56 main page under Visual Basic in Access. On the examples using Access etc page there are three databases that have the examples I did in class. Please note that I had a very serious problems with my email today (4/24). I think I finally got everything, but if you sent me something today and I do not get it back to you sometime next week, please send me an email asking if I got it. Assignments: This is the final project using ADO in VB, therefore it should be fairly complex. Please put time and effort into including lots of things that you have learned! Any other assignments after this project will be minor. ADO Project |
| Week #14 Assignments Week ending May 3rd |
Next week classes will be in K-101. You can work on projects etc. This week we will look at Excel. Note that from in VB, if you want to use Excel you need to go to References and select Microsoft Excel 8.0 Object Library (when using word make that you select the object library for Word). If you are in Excel, use View/Toolbars/Visual Basic to give you access to the tools you need to create and edit. |
| Week #15 Assignments Week ending May 10th |
Note that the notes on using VB in Access are on the CIS56 main page under Visual
Basic in Access. The final must be passed in 1:00 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 1:00 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 Status Sheet - required |