| Week | Information Assignments due in one week unless otherwise stated |
|---|---|
| Week #1 Assignments Week of September 2nd |
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 September 9th |
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 and chapter #4 in the text. 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 of September 16th |
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. 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 you should look at! Assignments: Note: This assignment does not include FOR loops! Vehicle Insurance Form |
| Week #4 Assignments Week of September 23rd |
I have been having modem problems - first it got hit by lighting and then the
replacement lasted a week! I am back on line and will try to get to things as
soon as possible, but as you can imagine there is a tremendous backlog! 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 of September 30th |
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 of October 7th |
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). 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 of October 14th |
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 of October 21st |
Please read chapter #8. I also suggest you read the random file section in
chapter #10. We will continue with random files and MaxProfit programs. Assignments: Payroll Project Due in three weeks |
| Week #9 Assignments Week of October 28th |
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 of November 4th |
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 of November 11th |
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. 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 of November 18th |
Look at the examples under still more ADO. 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. 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 #13 Assignments Week of November 25th |
Next, 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. Please look at the examples at the web site under Word and Excel> No new assignments this week! |
| 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. No new assignments this week. |