| Week | Information | Information: Assignments due in one week unless otherwise stated. I am going to try to stay with the text to some degree but I am going to cover file handling sooner. If you have a different textbook, that is fine - just be sure to read about the topic we are covering and remember this is VB 2005. Check the schedule several times a week, I may add some things during the week. Please keep copies of all work you submit until you receive your final grade at the end of the semester. |
|---|---|
| Week #15 Assignments Week of December 8th |
This Tuesday (the last week of classes), I am
going to hold an open lab in K101 from 9 to 3:30. This is a catch up day, so if you are behind try
very hard to come for as many hours as you can. Required status sheet Final Exam |
| Week #14 Assignments Week of December 1st |
Read chapter #11 on web applications. Assignments: Last week I posted an extra credit Excel assignment. My mistake - this assignment was given in week #12: Use the book and develop a couple of web applications - they do not have to be uploaded - they can be run locally. I want two examples with the similiar to the Kayak example. Extra credit if you did some more examples. |
| Week #13 Assignments Week of November 24th |
This Tuesday, the Tuesday of Thanksgiving week - I am
going to hold an open lab in K101 from 9 to 4 with some time away at 2 for
a meeting. This is a catch up day, so if you are behind try very hard to come for
as many hours as you can. Assignments: No assignments this week. I have posted a next week assignment in case you want to get started on that: This is an example of using Visual Basic in Excel. We will look at that this week. Extra credit if you do an example that experiments with this and does even more than my example. Calc Pay information payroll.xlsm |
| Week #12 Week of November 17th |
This is advisement week, so during the times I say I am available for help
I may have someone signed up for advisement. Sorry, but I do not know what slots are
taken. I am available for help/advisement at 11 and 2 on Tuesday in K101,
11 and 3 on Thursday in K101 and 6 on Thursday in K102. I am also available Friday at
11 and 1 in my office. Next week, the Tuesday of Thanksgiving week - I am
going to hold an open lab in K101 from 9 to 4 with some time away at 2 for
a meeting. This is a catch up day, so if you are behind try very hard to come for
as many hours as you can. Please read chapter #11. This week we are going to look at VBA. Here are notes and a sample Access Database using 2007. I am going to introduce 2007 and then show you how to do VBA using it. The notes and the sample database are shown (for previous versions you can go to CIS61 and find information). VBA Basic Notes (word version) VBA Basic Notes (html version) VBA Array Notes (word version) VBA Array Notes (html version) withVB.accdb (DB with VBA) Assignments: Please do tutorial 11-3 and 11-4 in the text or make up your on similiar problem. Also you shoud do something similiar to tutorial 11-5 using your own database. Extra credit if you do some of the things later in the chapter. VBA Assignment |
| Week #11 Week of November 10th |
Advisement starts this week. You can do online advisement with me using
the usual email address or you can sign up for advisement with me (K112)
or Sil Ferreira (K216) or Igor Kholodov (K211) or Janelle Arruda (networking) or
Raymond Steele (game). Even though you may have me listed as your advisor, you can
go to another member of the CIS Department for advisement. All of the CIS advisors have the transcripts and the information
to help you choose your Spring courses - please plan to see one of us. If you are in game, contact Raymond directly. Advisement check lists - please note these are not official (we have not caught any errors, but for official/confirmed information you should always check the catalog. On Thursday and Friday I will be combining advisement and help. At 11 on Thursday I will be in K101 and at 6:00 I will be in K102. Depending on who signs up for advisement I will probably be available part of the 3-4 on Thursday and part of the 11-12 on Friday. Friday I will also be working on advisement and available for help from 1 to 4. Please look at updating and more wizard processing this week. Two examples to look at are: Update Examples Please read the chapter on website development. As always, please check back. Assignments: Please write a very basic update to be able to add records to a table, delete records from the table and change information on the table. Keep in basic so you can focus on the update features. I want you to write the code and not use the wizard. Extra credit if you do an update problem using the wizard. |
| Week #10 Week of November 3rd |
Meditech presentation on campus, Thursday at 11 in K101 First look at the wizard - the chapter in your text has a lot of relevant information. Notes on ADO with text fields and wizard (html version) Notes on ADO with text fields and wizard (word version) Then we will look at a few more coded examples: More ADO zipped examples Assignments: This week I want you to experiment with the wizard type things in the textbook. Write programs that uses multiple tables together and multiple tables separately - experiment and explain your experiments when you pass in the programs. |
| Week #9 Week of October 27th |
Please make sure you are comfortable with creating tables in Access. If you have not done it, go back
and look at examples in CIS17 that cover the basics. I work mainly with Access 2003 for these examples. This week we will start ADO, read about it in your book and check back. I would run through the first connection example in chapter 10 (runs up through page 631). Examples we will start this week: Zipped intro examples Assignments: I am looking for you to experiment with things - doing something similiar to my examples is acceptable for this assignment, although, feel free to explore and expand. Program #1: Write a program that queries an Access table and displays information in text boxes. Code the ability to move to first, next, previous and last. I want you to use code and to use the current path to access the DB. Progam #2: I want you to write a program similiar to the one in my sample that shows two tables in a one to many relationship. Data from the first table should be in text boxes with the ability to move to first, last, next and previous. Data from the second table should be in a grid. Code the ability to match similiar to the match key in my example (Donortwotables). |
| Week #8 Week of October 20th |
Meditech presentation on campus I will be available Tuesday and Thursday at 11 in K101, Thursday at 3 in K101 and at 6 in K101 or K102. In addition I will be available Tuesday after 2:30ish and Friday at 11 and in the afternoon in my office. This week we will look at print, please read the section in the back of your text on this topic. We will also look at Access (we started this in the last class last week.) Assignments: Array Assignment using structures and redim |
| Week #7 Week of October 13th |
I want you to finish off arrays this week. Look at the presentations on the logic of a Bubble Sort and a Top Down Sort. To help you understand the structure of these sort alogrithms. I used the following presentations: Topdown sort Separate speaker notes to accompany topdown sort Bubble sort Separate speaker notes to accompany bubble sort Assignments: Modify my Bubble Sort program so that it does a Top Down sort. Array Assignment |
| Week #6 Week of October 6th |
I will be available Tues and Thurs at 11:00 in K101 and Thursday at 5:30ish in K102.
Please continue reading the text. We are going to start with arrays. Check out menus as well. Assignments: Inventory assignment Please note I should have called the id the item number - they are the same! |
| Week #5 Week of September 29th |
Help in K101 on Tues and Thurs at 11 and on Tuesday until from 3 to 5. Please read along in the textbook and keep pace with the topics. We are at around chapter #6. We need to finish breaks, then we will start to look at procedures and functions. Be sure you are using the resources at the site in addition to the text book. Remember, the .NET examples work fine in 2005. Assignments: Assignment #1: Loop assignment Note that these are two separate programs in assignment #1 - I have had some confusion before. Assignment #2: Write a brief program to take in a name in the format Last/First Middle (for example Doe/John M) and return the name in the format First Middle Last (for example John M Doe). |
| Week #4 Week of September 22nd |
We have not been impacted by the eLearning problems at BCC - it does not relate to this course, so
we will continue with the course on the standard college schedule. I will be in lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday. Read chapter #5 in the text. We looked at loops last week . Be sure you have looked at the PowerPoint presentations and examples. We are going to continue looking at both conditons and loops. Assignments: I want you to modify the quess the number program so that the user only gets a certain number of chances (let's say 5). When they have used all of their chances an appropriate message should display and the Play button should become visible. Rock, Paper, Scissors Assignment |
| Week #3 Week of September 15th |
I have asked for the lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday and some other days as well.
I am waiting for confirmation. Let's assume I will have it at the 11:00 times. I will also be
available in my office (K-112) for help (we can go to a lab) on Tuesday from 3:30 to 6:30 (I maybe
free from 2 - 3:30 on Tuesday, but I am not sure yet. Check with me! Read chapter #4. We will continue looking at conditions and we will start looking at loops. We are also going to look at creating and reading sequential files (note that this is not covered in the assigned reading, but you can find it in the text. Remember, all of the .NET program examples are working fine in 2005, so just open them and test. Assignments: Algorithms and program design We will look at some of these in class. Please code either #4 or #5 in VB (extra credit if you do #5). Check back - I think we will make it to this assignment - if not, next week. Insurance form and file |
| Week #2 Week of September 8th |
Read chapter #3 in the text or about IF statements in VB.NET. I want to get to the point we are
doing if and calculations because otherwise there really is not a lot to do. So, this week we
are going to look more at conditions. Please note that all of my beginning VB.NET examples can and
do run just fine under VB 2005. If you download them from the web site and then run them they will
go through a small conversion - it does not change my code that I have noticed. So please look
at the .NET examples and PowerPoints. There are
three Powerpoints having to do with IF and the samples
of if statements. Remember there are sample programs available to illustrate
all concepts. Assignments: IF assignment |
| Week #1 Week of September 1st |
There are 15 units in this course (the last one being the final). This means that you will have to
space them out so that you accomplish all of the units. Some weeks you will have to do multiple
units. I will post them so you can work ahead. Let me know if you want a faster pace.
This course will use Visual Basic.2005 (NET). At the beginning of the course VB.NET will work fine.
As we get into some later things, you will need to be using the 2005 version. Read chapter #1 and chapter #2 in the text. You should be looking at the beginning examples and programs and the beginning PowerPoints. Note many of these were done for the .NET version and while the code works, there are development differences. The software for this course is available through the text and it is also available through the Microsoft alliance. For information about using the alliance to acquire software for this course: MSDN Alliance Software Let me know if you need an invitation! Assignments: assign1.html When you send me the assignment, please zip the contents of the folder and send me the zipped file. |