| Week | Information Assignments due in one week unless otherwise stated |
|---|---|
| Week #1 Assignments Week ending June 1st |
Read chapter #1 and #2 in the text. View the presentations on introduction, settings and pay examples (including PFirst98). Look at the programs under ArithFst, FirstDay, Calculate, Pay1,Pay2 and First98. 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 #2 Assignments Week ending June 8th |
Read chapter #3 in the text. This is a good chapter to go over because it contains
a lot of small pieces of information that will be helpful as you program. Look ahead and read about IF statements and For statements in chapter #5 and #6 - honest, we will cover #4 and the rest of the information in #5 and #6 later. View the presentations and look at the programs for: Inventory - IF, Bill, Bill If, If Calculate, Inventory Easy and For loops. assign2.html Experiment with 20 things 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. There will be two assignments next week, so you might want to get started on the first one!!!!! |
| Week #3 Assignments Week ending June 15th |
Continue with the reading assigned last week. View the programs and presentations for: I/O Programs and Functions. Vehicle Insurance form Function assignment Quiz on chapter #3 Due in one week |
| Week #4 Assignments Week ending June 22nd |
Read chapter #4. Please view the programs and presentations for: Sub programs, muffin shop .If I skipped any, please note that I have moved to this point, so look at everything to this point!!! Writing a program using procedures, functions etc. |
| Week #5 Assignments Week ending June 29th |
Start really reading chapter #5 and #6 in detail! Look at the programs under break processing and delivery. IF statement etc. assignment |
| Week #6 Assignments Week ending July 6th |
Finish reading chapters #5 and #6 and start chapter #7. Look at the programs and presentations about Do loops under DoTest and Convert For a Do While. Assignment using if, case and do Start looking at the information on arrays! |
| Week #7 Assignments Week ending July 13th |
Continue reading chapter #7. Look at the programs under arrays and view the related presentations. 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. Write a program to make the day of the week program work when the year is in the 21st century (20xx) or when the year is in the 20th century (19xx). You can decide to do it by setting up a 100 year time frame (for example 1950 to 2049), or by having a flexible time frame (50 years back from the current date and 50 years forward) or by handling all dates in the 1900s and the 2000s. You have the program that works for 1900s, now it must work with either. You can modify the entry so that the user has to type in a 4 digit year if that is the way you want to handle it! Next week, we will wind up arrays and look quickly at the material in chapter #8 (we have already dealt with this topic) and then chapter #9. |
| Week #8 Assignments Week ending July 20th |
Look at the PowerPoint presentations and make sure you have looked at all of the
sample programs under arrays. Look at the sample programs and the PowerPoint on Maximum Profit. Array assignment |
| Week #9 Assignments Week ending July 27th |
Read chapter #9 and look at the sample programs on random processing as well as
the PowerPoint presentations. Pay Project |
| Week #10 Assignments Week ending August 3rd |
Read chapter #10 - this chapter will not be covered beyond reading. For
people who do not have the book find an alternate source to read about graphical
display of data, line charts, bar charts and pie charts. Read chapter #11 and look at the examples and presentations on combo boxes, lists etc. Assignment on list and combo boxes Important: I am going away to Europe for two weeks. Continue to send assignments to the usual account. Needless to say I will not be correcting until I get home! If you have questions, then use my email account pgrocer@hotmail.com. I will check this account from the Internet cafes when I can. I have also asked my workstudy Wendy and Tess to be available for questions and help while I am gone. The information to contact them is: Wendy can be reached at Wenco35@aol.com or wenco@mediaone.net Tess can be reached at tfarias@stu-mail.bristol.mass.edu or mstess73@aol.com You can also set up an appointment with Wendy via email or you can contact Tess in the K building lab Monday,Tuesday and Thursday nights from 4 till 9. |
| Week #11 Assignments Week ending August 10th |
Start chapter #12 in Access - we will spend some time on this. Review or start to learn the basics of Access for next week. I am looking for a level similiar to what is covered in CIS11. Some things to help: I have brought over two PowerPoint demonstrations. There are notes under CIS54 and last semesters CIS61 that might be helpful. Please see note under week #10 about contacting me! |
| Week #12 Assignments Week ending August 17th |
Continuing Access. Look at the additional examples! Access assignment Students have had problems with adding records. This is an approach I have used in the past. Essentially I take data into work areas. Add a record, put the data into the record and update! Here is that approach:
Private Sub cmdAdd_Click()
wkIdno = InputBox("Enter ID for new record")
wkName = InputBox("Enter Name for new record")
wkMajor = InputBox("Enter Major for new record")
wkCity = InputBox("Enter City for new record")
wkGPA = InputBox("Enter GPA for new record")
wkYrEntered = InputBox("Enter Year Entered for new record")
ADOStudents.Recordset.AddNew
ADOStudents.Recordset!idno = wkIdno
ADOStudents.Recordset!Name = wkName
ADOStudents.Recordset!Major = wkMajor
ADOStudents.Recordset!gpa = wkGPA
ADOStudents.Recordset!city = wkCity
ADOStudents.Recordset!yrentered = wkYrEntered
ADOStudents.Recordset.Update
End Sub
I will be home mid week!
|
| Week #13 Assignments Week ending August 24th |
Continuing Access and starting to look at Visual Basic within Access. Look at the examples, the presentations on Access as a database for VB and the notes about using Visual Basic in Access. Final exam Status sheet Note that status sheet must be passed in as well. |
| Week #14 Assignments Week ending August 31st |
Final and status sheet due Tuesday at 6:30. |