Visual Basic - CIS56

Weekly Schedule

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.

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

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