| 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. |
|---|---|
| Unit #15 |
This unit, 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. Let me know when you want the final. |
| Unit #14 |
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. |
| Unit #13 |
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: 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. |
| Unit #12 |
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 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. |
| Unit #11 |
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 Last spring, I had inclass students experiment with grids working off my examples. This week we will continue with ADO. Please check back! Assignments: ADO assignment |
| Unit #10 |
Please continue to look at database connections this week. VB ADO updates Assignments: Quiz Update Assignment: 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. |
| Unit #9 |
We are going to start looking at ADO. 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. |
| Unit #8 |
We will look at finishing 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. 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 |
| Unit #7 | Please look at my PowerPoint presentations on the Top Down Sort and the Bubble Sort. You should also look at my Bubble Sort
program. Assignments: I want you to take my bubble sort and convert it to a top down sort. 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. |
| Unit #6 |
Please continue reading the text. We are going to start with arrays and then menus. Assignments: Inventory assignment Please note I should have called the id the item number - they are the same! |
| Unit #5 |
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 |
| Unit #4 | 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. You need to cover combo boxes and breaks and look 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. Also look at the validation program. Assignments: On this assignment, try to make it look fun to play. Rock, Paper, Scissors Assignment Week 4 assignment The programs involved in this exercise are discussed in the Smartboard from this week for Spring 2009 in the week of Feb 9th listings. They are also under programs (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 |
| Unit #3 | 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 unit 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. 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 last semester, 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. The notes are on the Smartboard from last semester. You need to make these modifications and send them in. |
| Unit #2 | You should look at my examples. If you have any questions, let me know. 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 |
| Unit #1 | There are 15 units in this course to match with the number of weeks in the Spring semester when
the course is primarily taught. You need to do the 15 units during the summer which means some
weeks you will have to do multiple units. 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. |