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/2008. Note that the recommended VB 2005 book may not be available - the 2008 version is available at the bookstore. We can work with either version. 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. |
---|---|
Final Week of May 11th |
The final exam is due by the scheduled start of the final exam: 05/14/09 at 10:15 AM in K101. If you
have not emailed it to me before the start of the exam, you must come to the scheduled exam and
complete the final. Final Exam Required Status Sheet The status sheet is a required part of the final and must be passed in with the final or before the final. |
Week #15 Week of May 4th |
I will be around Tuesday at 11 and at 3, Thursday someone will be available from around 2:00
until 8:00 - I have a meeting for a short period but I will be there most of the time. This week, we are going to look at VB in Excel. Setting up VB in Excel testing.xlsm Calc Pay information payroll.xlsm Assignments: I want you to do an inventory spreadsheet (or something else that interests you) similiar to payroll.xlsm Use the same variety that I did in that example. |
Week #14 Week of April 27th |
I will be around for help Friday, May 1st from 3 to 7 and possibly from 1 or 2. I will be available
Tuesday at 11 and at 2, Thursday at 11 and 3 and Friday at 11 as well as in the afternoon and evening. I was out sick on Tuesday. We will look at VBA on Thursday. Here are notes and a sample Access Database using 2007. 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: I want you to set up a database in Access 2007 (can use 2003 if you want to but notes go with 2007). Then I want you to do VBA. You should have an if, and if...else, a loop, an array, a message and you should fill boxes on the form with information from the table and with information that is the result of a calculation. |
Week #13 Week of April 20th |
This week I will be available Tuesday at 11 and then there will be someone available from 2 to 9 or 9:30
at night. I will be there most of the time, but I have to go to a meeting for about an hour. Andrew and Stephanie will
be there to help as well. After about 6:45 we will need to move to another
lab, so check around, I will be in a lab. I will also be available Friday at 11 in my office. We will continue to look at the web this week. Creating a web site with Brinkster I have set up a site that carries my examples. I will send you the information. If you do not get it, contact me. Assignments: We will work with this assignment in class on Tuesday: First: I want you to take one of the assignments you did and turn it into a web site. Send me the code and the address to run it. Second: I want you to show information from multiple tables in a grid at a website. Third: I want you to show information from individual records at a website. Fourth: I want you to make a program that will update individual records at the site. |
Week #12 Week of April 13th |
This week I will be available on Friday night until a little after 7:00 and next
week I will stay on Tuesday night (April 21st) until around 9:00. If you need help I would
plan to come one or both of these. The room number I am in will be posted on my office
door (K112). This week I will be mixing advising and help. I will be available Monday at 2
in my office and I will hopefully be available a little after 4 on Monday as well. On Tuesday,I will be available at
11 in K101 and after 2 in K101 as well. You can come for help or early advising. Thursday
I will be available at 11 in my office and at 3 in K101. Friday I will be available at 11
in my office and a little after 1 until 7ish - check my office. Please bring your text to class this week, we will be looking at the tutorials on web development (Chapter #11). As always, please check back. ASP intro ASP and db Assignments: I would like you to do the first page of the Kayak tutorial - I am not assigning the part that links to another page. I would also like you to write another program on your own that does something interesting and a third program that uses a database to access information. These should all be loaded up on the web. I am recommending that you get a free site at www.brinkster.com to do this. When I work with Brinkster, I use the classic file manager. I suggest you look at the Smartboard notes that I will post to see the process using Brinkster. |
Week #11 Week of April 6th |
I am available on Tuesday at 11 in K101 and 3 (my office or K101), Thursday at 11 in my office or
K118 and 3 in K101, Friday at 11 in my office or 2:30ish in K101. You should have read or be reading the chapter on databases in your text. As I told you, you should be following along in the textbook with the topics we are doing in class. So, I think that means you should have read up through chapter #11. Using Grids I had inclass students experiment with grids working off my examples. This week we will continue with ADO. Please check back! Assignments: ADO assignment Worked on in class for in class students. Must be done by everyone. |
Week #10 Week of March 30th |
I will be available Tuesday at 11:00 in K101, Tuesday at 3:00 in my office or in
a lab. Thursday I am available at 11:00 in my office or a lab and at 3:00 in K101. Friday you need to contact
me for availability. If those times don't work, contact me and we can try to set up something else. If I were to schedule a Saturday in April, would that help. I need to here back from you if you would like me to do that. I will continue to look at database connections this week. VB ADO updates Assignments: For in class students, we will do this in class on Thursday If you are not in class, you need to do it before next Tuesday. 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 #9 Week of March 23rd |
I will be available Tuesday at 11:00 in K101. I will also be available Thursday at 11
in my office of K118 and at 3 in K101. Friday I am available at 11 in my office and
after 3 in my office or in a lab. Check with me for times if you are interested in staying Friday. We are going to start looking at ADO this week. Please be sure you are comfortable making a simple database including at least one table for now. Building ADO in Access 2005 Screen shots using grid Examples this week Correction Assignments: Write a program that uses the wizard and text boxes. Write a program that uses the wizard and a grid. Write a program that connects to the database and then queries the database. Please use current path and code buttons to move (beginning, end, next, last). Use text boxes. |
Vacation Week of March 16th |
Have a productive vacation and wish me the same! Please be sure to check this list of scholarships. They are a great way to help with tuition. Scholarship Opportunities at BCC |
Week #8 Week of March 9th |
Tuesday of this week will be an open lab in K101. No classes are scheduled. Please come for as long as you can if you are
not caught up in your work! I will also be available on Thursday and Friday at 11 and I may be available later on
Friday - check with me if that works for you. This week we will look at finish arrays, and look at menus and multiple forms. There is also a section on printing that I would like you to look at and play with on your own. This week we will also start to look at Access. If you are familiar with Access, you do not have to stay for the last part of the class. Assignments: I want you to write a program that will meet the following specifications: 1) Set up a structure with multiple types of data that will be used as the type for an array – the structure should have a dept number, a dept name and a dept budget 2) The dept numbers should be something like 11, 18, 29, 33, 36, 38, 41, 44, 47 (note there are significant gaps between the numbers) 3) You should take in a dept number from the user and use it to access the department name and the department budget 4) Use redim to establish the size of the array 5) Use redim preserve to increase the size of the array and add to the populating data |
Week #7 Week of March 2nd |
This week I am available at 11 and 2 on Tues in K101, 11 on Thurs in K118/K112, 3 on Thurs in K101, and Fri at 11 in K112. This week we will continue to look at arrays and then go back to the menus examples. If time permits, we will start to look at Access. Sorry I have gotten behind in correcting - we all need to work on this - you getting assignments in and me getting them back! Please look at my PowerPoint presentations on the Top Down Sort and the Bubble Sort. You should also look at my Bubble Sort program. No notes for Thursday, I was out sick. Assignments: In class, I asked students to take my bubble sort and convert it to a top down sort. Everyone should do this assignment and send it to me. Be sure you have looked at my program called typearry under the array collection. Write a program or programs of your own design that includes the following: One dimension array: You need to set up a structure for the elements of the array. You need to load information into the array. You also need to write a search to search the array. I also want you to create and access a two dimension array. |
Week #6 Week of February 23rd |
This week I am available at 11 on Tues in K101 and 11 on Thurs in K118/K112. I will be out on Friday
at a conference. However the classroom will be available at 9, 10, 12 and 1 so you might arrange to
come and work together on some of the assignments. Please continue reading the text. We are going to start with arrays on Tuesday. I am skipping menus because I want to get into arrays - we will come back to menus. Assignments: Inventory assignment Please note I should have called the id the item number - they are the same! |
Week #5 Week of February 16th |
Help/support labs on Thursday at 11 in K112/K118 and 3:00 in K101. We are going to look at functions and procedures. Please check the sample programs and PowerPoints on these topics. Remember, some of the presentations had developed problems. The zipped versions are fine, so please download them. Assignments: Loops and functions |
Week #4 Week of February 9th |
Help/support lab Tuesday at 11:00 in K101 and also at 2:00 in my office. Thursday I am available at
11 in my office. If you need to see me and these times don't work contact me and we can try to figure
something out. 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. We are going to look at combo boxes and breaks and I am not sure how much further we will get. On Thursday, in class we looked at the break PowerPoint and the break programs (PrMinor and PrMIM). Note there was a mistake in the handling of detail records on the PowerPoint in the Minor, Intermediate and Major programming logic. We also looked at the validation program. In class, we worked on making changes to the programs. Assignments: On this assignment, try to make it look fun to play. Rock, Paper, Scissors Assignment Week 4 in class assignment The programs involved in this inclass exercise are discussed in the Smartboard from this week. They are located in the Breaks and validation programs: PrMIM and the validation program. The listing of the code is at Code for break and validation programs |
Week #3 Week of February 2nd |
I am available for help Tuesday at 11 in K101. I am also available Thursday at 11 and at 3 (my office K112)
and on Friday at 11 and 1-1:30 (my office). Note there may be a note on my door telling you I am in a lab. Read chapter #4. Please note that I really want you to read along in the book, a chapter per week, but the main purpose of the book is for reference. We started loops in the last class and we will continue on with loops this week. We also looked 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. I have also tested them in 2008 and had no problems. Please check back to see where we are for Thursday. Assignments: Algorithms and program design We will look at some of these in class. If you had CIS17 some of these look should look familiar. For those students, go back and look at what you did and modify them a little to follow how you might handle them in VB. Please code either #4 or #5 in VB (extra credit if you do #5). Insurance form and file In class, we did an assignment which is to modify the guess game so that the buttons are only available when they are needed and the user only has 5 chances to guess the number. People not in class should make these modifications and send them in. |
Week #2 Week of January 26th |
This week there will be an open lab at 11:00 in K101 on Tuesday. I am also available for help
at 3:00 on Tuesday and on Thursday and Friday at 11:00. On those days, please come to my office in
K-112. If you have any questions related to homework, come and see me! 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 19th |
This course will use Visual Basic.2005 (NET) (You may use 2008 for homework). Read chapter #1 and chapter #2 in the text. There was a problem with the text, if it is not in we will proceed based on lectures and you can do the reading when you get the book. 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. |