| Information: Assignments due in one week unless otherwise stated.
Please note that I am not going to stay with the text - it moves to slowly 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. I may add some things during the week, so double check the schedule each week!
Week of June 7th
Recommend that you start the course earlier
|I recommend that you start this course now rather than waiting until June 7th.
This will either give you the chance to take a vacation without impacting the
course schedule or give you extra time at the end of the summer to catch up
or to take a break before the fall semester starts. I will be out of town from
May 28th through June 3rd and I will not be checking my email during that time.
I would appreciate it if you would wait until I return to send it work and
questions so my email does not clog.
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.
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 of June 14th
|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
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
Separate speaker notes to accompany calculate examples
Inventory example (inveasy)
Separate speaker notes to accompany inventory example (inveasy)
Twenty things in VB
|Week #3 Assignments
Week of June 21st
|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!
Note: This assignment does not include FOR loops!
Vehicle Insurance Form
|Week #4 Assignments
Week of June 28th
|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.
Be sure to check the example programs through this point - I sometimes do not reference them all.
I had some email problems this morning and lost some email (mainly things delivered on the morning of the 11th), if you did not get a response or you suspect something did not get through, please send it again.
Series of three short programs to be written
This quiz is largely based on the book, so I would use the book as the major reference.
|Week #5 Assignments
Week of July 5th
|Read chapter #6 and chapter #7 in the text. (unfortunately the summer has to move
a little faster).
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.
Start looking at information about arrays.
Be sure to look at the SmartBoard postings by topic. I put a lot up last semester.
|Week #6 Assignments
Week of July 12th
|Read chapter #8 in the text.
Look at the sample programs and PowerPoint presentations on interest (another example of loops), functions, procedures and arrays (you should look at the array examples Note: I have put up a lot of Smartboard notes from previous times I taught the course.
Assignment on if statements, functions, procedures, files etc. due in two weeks
Modify my Bubble Sort program to do a top down sort (be sure to download the bubble sort and try it and look at the Presentations about bubble sorts and top down sorts.
Please use a DO loop. For extra credit you can do it with a For loop.
|Week #7 Assignments
Week of July 19th
|Read chapter #9 in the text.
Go through the array examples paying attention to the one on redimensioning a table.
We will start looking at random files this week so please look at the examples and the PowerPoint.
Extra Credit: Modify the day of the week program to handle dates in in the twenty-first century. You may choose to only handle dates up to some date you choose such as 2050. Be sure to look at the examples, the PowerPoints and the Smartboard notes for information if you decide to do this assignment.
|Week #8 Assignments
Week of July 26th
|Read chapter #10.
You should look at the MaxProfit programs.
This week we will also look at two forms and combo boxes, so check out examples and presentations.
Change of plans!
If you are not comfortable enough in Access to create and populate tables, be sure to find a tutorial or a book and work on introductory Access.
|Week #9 Assignments
Week of August 2nd
|Read chapter #11 - basically, my goal is a chapter a week of reading.
Go over the examples and PowerPoint for combo boxes and lists. Then we will start Access. We will skip Access 97 because it does not use ADODC - I leave it out there so you can see one of the previous connection methods. We start with Getting Started with Access 2000. Note there are SmartBoard demonstrations.
Look at the Donor 2000 and Donor 2000y series of programs.
Combo, list, 2 forms, ADO etc
|Week #10 Assignments
Week of August 9th
|I had a major computer disaster and am still in recovery, but I am now back on line.
My apologies for the delay.
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.
|Week #11 Assignments
Week of August 16th
|Please read chapter #12. This week we are going to continue looking at ADO. We are
also going to start looking at VB.NET. You should either plan to go to a lab (it is available in the central lab
in K130) or find another source for testing VB.NET. You can see Carol Mello about
getting a student version. Places to check for Microsoft
opportunities to use VB.NET are
Try Visual Studio.NET 2003 or
Using Visual Studio.NET
Second ADO assignment
|Week #12 Assignments
Week of August 23rd
|Please read chapter #13 for your own information.
This week we are going to work with using Visual Basic in Access. We will also continue to "play" with VB.NET.
There are Smartboard notes on using VB in Access.
We will look at Visual Basic in Excel this week. Please read chapter #14. If you are taking the second semester of this course, you should review the oriented chapter and take a look at chapter #15 - these concepts will be covered next semester.
I want you to write a program using VB.NET - extra credit if you use Access (see my notes on using ADO in VB.NET).
Go into access and create a form using one of my databases or your own database. The form should have three events that trigger Access code. The Access code you use should include: If statement, calculation statement, loop statement and the results should be displayed on the form. You may use other elements as well to get extra points. Note: Your answers should not look like my examples! This problem must be done entirely in Access. This is a question from your final exam. You may do it now and include it with your final or you can do two different examples in which case you can submit one as part of your final and one as extra credit.
|Week #13 Assignments
Week of August 30th
|You may have one week to do the final - it is officially due on August 30th. Email me when you are ready for me to send it to you.