| 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 Week of May 5th |
I am available on Tuesday at 11 (K101) and from 3:00ish until 7:00 in my office or in K116.
Thursday we are going to have an all day help session from 9:00 until 3:00 in K101. I will not
hold specific classes during that time, you may come anytime and stay as long as you can to work on
homework and get caught up. If you are behind, you really, really need to make the effort to be there. I can also be available on reading day (Friday) from 10:00/10:30ish until noon or 1:00, but only if several students commit to being there. Your final is schedule for Wednesday, May 14th at 8:00. It will be posted prior to or on Wednesday, May 7th. You need to finish it prior to the start of the final, or you need to report to the final to finish the exam. The status sheet must be passed in at the final or prior to the final - it is a required part of the final and the final is not complete without it. Final Exam If you have questions, please contact me. Required status sheet |
| Week #14 Week of April 28th |
I am available on Tuesday at 11 (K101) and from 3:00ish until 7:00 in my office or in K116.
Thursday we are going to have an all day help session from 9:00 until 3:00 in K101. I will not
hold specific classes during that time, you may come anytime and stay as long as you can to work on
homework and get caught up. If you are behind, you really, really need to make the effort to be there. Your final is scheduled for Wednesday, May 14th at 8:00. The final will be posted one week prior to the final. You must pass it in by the start of the final or come to K101 and take the final at that time. 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 #13 Week of April 21st |
I am available on Tuesday at 11 (K101) and from 3:30ish until 7:00 - in my office or in K116. Please read chapter #11. We did the first few tutorials in class last Thursday. I am having trouble uploading the audio and Smartboard to BCC. 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) I am having trouble loading things to the BCC server so audio and Smartboard from last week are not up. 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 #12 Week of April 14th |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:00ish until 4:00 and
then from 5:30 ish until 7:00ish (I am on a committee that is doing interviews and an interview
has been scheduled for 4:00. You can look for me in my office or in the lab across the hall. This is also advisement week,
so some of the time may be taken up by advisement rather than help! We will look at updating and more wizard processing this week. The two examples I looked at are: Update Examples Please read the chapter on website development. We will be going over the chapter in class. 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 #11 Week of April 7th |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:30ish until 6:30ish
- you can look for me in my office or in the lab across the hall. This is also advisement week,
so some of the time may be taken up by advisement rather than help! I am also on a committee that
is scheduling interviews so an hour may disappear on Tuesday. I will leave a note on my door
if I am at an interview! First we will 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 Then we will look at maintenace later in the week. VB Update code handout On Friday, a group of students from Kuss Middle School are coming in to learn about Alice. This is part of our service learning project. I need volunteers to be involved in this, so let me know if you are interested in adding service learning to your transcript. They will be here from 9 - 11. Assignments: This week I want you to experiment with the wizard type things we covered on Tuesday and are 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 #10 Week of March 31st |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:30ish until 6:30ish
- you can look for me in my office or in the lab across the hall. We will continue with ADO. 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 #9 Week of March 24th |
I will be available Tuesday and Thursday in K101 at 11:00. Check back, some other times will
probably be available. I cannot stay until 7:00 on Tuesday this week, I have an appointment off
campus. This week we will start ADO, read about it in your book and check back. We are going to do something similiar to the first connection example in chapter 10 (runs up through page 631) in class. Examples we will start this week: Zipped intro examples Assignments: I want you to experiment with connection - nothing elaborate - keep it basic. Since I am out sick, I am going to leave it that I would like you to experiment with the ADO connections discussed in your book. I will deal with doing it with code next week. No assignment to pass in this week, but please do experiment. |
| Week #8 Week of March 10th |
I will be available Tuesday at 11 in K101 and from 3:00 to 6:30 in my office or K116.
On Thursday, I am running an open lab for help and to get caught up from 9:00 until 3:00 in K101.
You can come for the whole 6 hours or you can come for your class and any other free time you have. Let's get caught up or ready to get caught up over vacation! 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 March 3rd |
I will be available for lab help in K101 on Tuesday and Thursday at 11, from 3:00 until 6:30 on
Tuesday in my office, we can go into a lab to work. I will also be available Thursday late
afternoon. We will finish off arrays on Tuesday. Check back! Last week we looked at the logic for 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 Check back! |
| Week #6 Week of February 25th |
I will be available Tues and Thurs at 11:00 in K101 and Thursday at 2:30 in K101 and 3:00 in my
office. If you need to set up an appointment later in the day, contact me. Please continue reading the text. We are going to start with arrays on Tuesday. I am skipping menus because I want to break arrays up rather than too much Thursday. Assignments: Inventory assignment Please note I should have called the id the item number - they are the same! |
| Week #5 Week of February 18th |
I am at least partially recovered from my email and then computer disaster. If you have not heard back
from me by tomorrow night, I would resend anything I have not returned. This week I will be in the lab in k101 on Thursday at 11 and in my office after my 3:00 class. I will also be around some on Friday if you contact me. 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 February 11th |
I am experiencing problems with my email account starting 2/11/08. Please send email
to my backup account and try resending to my main account in a few days. I will be in lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday. 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. I will be available in my office on Thursday from 3:00 to 4:00. Check with me! 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. Check back and see where we are after Tuesday. 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 February 4th |
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 January 28th |
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. Lets 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 and Thursday from
3:00 to 5:00. 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. If you want copies of the programs to run as I am running or copies of the code to look at in class, please download and print before class. Assignments: IF assignment in class students will have the opportunity to start this program in class. |
| Week #1 Week of January 21st |
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, we may encounter some problems. I have not tried everything in
the newest version, yet.
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 Assignments: assign1.html When you send me the assignment, please zip the contents of the folder and send me the zipped file. |