| 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... The important thing is to follow the topics in the week of. We are using VB 2010 in the labs and the book comes with the Express Version. You can get other versions through MSDN. 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 December 10th |
This is a catch up week and a start the final week. The final has been sent to you. I would like it turned in to me by December 17th. The required status sheet will also be sent. Contact me with any problems. |
| Week #14 Week of December 3rd |
We are going to look at web development this week. Be sure to read the examples in your textbook. WebDev Assignments: Write an ASP program that uses some different tags including a button that causes processing. Upload the program on Brinkster and get it working. Write an ASP program that connects to a table to view the data - if you can get an update working lots of extra credit. |
| Week #13 November 26th |
The plan (subject to change so check with me) is to be available for help Monday at 10, I may have some time between 2 and 4 depending on meetings. I also plan to stay late both Tues and Thurs (until 5ish
and that can change if you let me know. Max will run an all day workshop on Friday in K116. I may be there and it may be just Max. This week we will continue with ADO. Please go to Brinkster and set up a free account, we will be looking at ASP next week. databaseuupdate.zip There was a problem in ADOlookupadd12 when a catch error occured. Adding this line to the catch fixed the problem. donationDT.Rows.RemoveAt(donationDT.Rows.Count - 1) Assignments: ADO update start Please finish this program so you can add a drive, remove a drive and change information about the drive. Use the add delete example I went over in class as a model. Write an update of your own to update one of your tables (no wizard). Extra credit if you want to go in and develop an update with the wizard. |
| Week #12 Week of November 19th |
We will continue with ADO - please check back and if you have a copy of the text, please look at the wizard examples carefully. Assignments: I want you to experiment with the wizard. Do some exploring on your own and send me the results. Things I want you to try: 1) Do something involving two tables with a one to many relationship. Show information from the one side in the text boxes and information from the many side in a grid. Play around with the bars at the top that let you move through the records. 2) Work with using a list box. 3) Work with adding some processing code to a program created with the wizard. 4) Something you learned through experimenting. |
| Week #11 November 12th |
I am available for help and advisement this week on Tuesday after 2, on Wed at 10 and after 3 and Thursday after 2. Talk to me if you are staying late - I can not stay late Thursday but
I can the other days. For advisement sign up on my door. If I get 10 people that committ to come on Friday the 16th, Max and I can put in an entire day of help like we did last Friday. Max is available in the afternoon as well. On Thursday during the first part of my 11:00 class and my 12:30 class, we have a guest speaker from Meditech coming in to talk about career opportunities with an emphasis on jobs in the programming area. You are welcome to come (K101). We will be looking at some more ADO code - I have posted examples. There was a problem with SQLdiffcode12 in class today. Easy fix, just set rowIndx = 0 before you do the FillTextBoxes() in both of the button click events Information about Access 2010: Sample Access 2010 database Access 2010 example explanation Presentation on using SQL queries in Access Separate speaker notes to accompany fusing SQL queries in Access From some other courses Presentation on SQL in Access - a little more Speaker Notes to accompany SQL in Access - a little more Generic notes on SQL Normalization - information on third normal form Separate speaker notes to accompany normalization presentation Relational database using donor Separate speaker notes to accompany relational databse using donors presentation Read chapter #10 in the VB book Assignments: Payroll database example for you to develop and populate First: Write a program to access one of the tables in the database from VB using code not the wizard. Have these SQL Selects as part of the program. Have one working and the others commented out, but test them all. Write the SQL query within VB (using VB code) to access information from one table using the following criteria: conditionA and either conditionB or conditionC. Display the results in a grid. Write the SQL query within VB (use the same program that you used above) that does a grouping by department number and shows the sum of the salary for each group. Second: Write a program that uses two tables and shows the employee number, employee name, department number, department name. Do it using a one select that combines the information from the two tables. Third: Write a program that shows employee number and employee name in text boxes and then shows the information from the EmployeeProject table in a grid. Have a match button that will match the employee number and just show the project information for that employee. Please check back! |
| Week #10 Week of November 5th |
I will be around Monday at 10 in my office (K112) and Tuesday and Thursday after my classes are done (1.45) in K101. Contact me if you need help at a different time. You should be up through chapter #9 in reading. Again, if you need a text book for reference, let me know. This week we will look at the examples under files under VB 2010/2008/2005, we will review Access and we will start to look at ADO. Look at the ADO examples under2010/2008/2005 (we looked at the first four - more are being added). Note that we are not using the wizard at all. We are writing our own code. Please check back! Assignments: This is an experiment with what we looked at this week assignment: First: Using the streamwriter write a file. Extra Credit: Use the append. Second: Using the streamreader read a file and display on the screen. Third: Using an Access database within VB (no wizard allowed - I want code you write) bring up information from individual records and show them in textboxes on the form. Be able to move forward and backward and have a find as well. Fourth: Using an Access database within VB (no wizard allowed - I want code) - bring up the information from a table in a grid. Your select should show certain fields and have a where clause to only bring up certain records. |
| Week #9 Week of October 29th |
We will finish up with arrays (chapter #8) on Thursday and go back and look at multiple forms and maybe even modules and menus (chapter #7). Check back! Assignments: I want you to write a program that uses multiple forms and one of the forms should have a menu. Set up modules as well. Pass information from one form for display on the other form. Throw in an array for good measure. |
| Week #8 Week of October 22nd |
This week please spend time on arrays which are covered in chapter #8. 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 Second assignment Please modify my bubble sort program under VB.NET examples to do a top down sort (the top down sort logic and the bubble sort are explained in PowerPoint presentations). |
| Week #7 Week of October 15th |
We will start looking at functions and procedures this week. We looked at the examples under 2010 and looked
at the VB functions which is the last program (FuncinVB) under the .NET examples. We worked on the assignment in class so no audio or video. Note that information about reading or writing files is under VB.NET in Sample Programs under If examples with files and the programs are zipped with If programs. Assignments: Procedures/functions assignment |
| Week #6 Week of October 8th |
I am available Tues late. This week we will finish up loops by looking at a few more of my examples. There were some questions about audio and this site looks like a good resource. Audio using resources Assignments: 1) Fix the Minor/Intermediate/Major program under Loops and Breaks under VB.NET so that you only have to click once to see all of the data. 2) Write a program that uses three different boxes (other than text boxes), that loads the data into the boxes in different ways and that uses three different kinds of loops. You should also include 5 coding types of things that help you do things like the with, Selection..., Enabled etc. Having corrected a few, I realize I need you to tell me where the 5 things are! |
| Week #5 Week of October 1st |
This Thursday we will have catch-up day in K101 from 9:30 to 1:45. Come as much as you can if you have things to catch-up! Please
take advantage, bring material and fill in the gaps. I will also be available for a while after 1:45 in my office K112 or in a lab.
Monday I am available at 10 and Tuesday at 1:45 in K112. We will finish up chapter #5 this week (hopefully). Spend some time looking at the .net examples because they have a little more detail. Look at the different methods to set up random for the quess game. Check back! Assignments: On this assignment, try to make it look fun to play. Rock, Paper, Scissors Assignment |
| Week #4 Week of September 24th |
This week I have a meeting Monday at 10 so I will be available Monday at 1:45 until around 3. I am also available Tuesday and Thursday
at 1:45 and Thursday I will be around until around 5:30. If I am not in my office (K112) I will leave a note on my door saying where I am. We will start the week continuing the if in class assignment and then we will start to deal with loops. Be sure to look at basicLoops under chapter #5. Assignments: Insurance assignment |
| Week #3 Week of September 17th |
We are looking at decisions this week - you should look at the basic if statements under chapter #4. Assignments: IF assignments you will find notes about this under the third week from the Spring semester 2012 IF assignment |
| Week #2 Week of September 10th |
Finish reading chapter #2 and chapter #3. We will look at examples from both 2010
and the more generic .net list. Programs to look at: Please look at all of the programs under chapter 3 for 2010 examples.
Under the .NET examples, these are the ones I suggest looking at: AppwithLoad, calculations, convert, datatypes,
formatting, invenbasic, OrderOperation, testtabindex. To help with conditions, below is a presentation on the structure of IF statements. Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Assignments: Visual Basic program week #2 Quiz: Quiz #1 (zipped file) |
| Week #1 September 3rd |
This course will use Visual Basic 2010. Read chapter #1 in the text, I would also start to read chapter #2. 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 You should get an invitation to MSDN early this week. I strongly suggest that you follow the class I taught in Spring 2012. There are audio notes that contain the lectures and accompanying Smartboard notes that capture the notes and examples from the class. During the first week in the spring, we went over Payroll Calculations (intro), Basic Project (chap #2), and we looked at Variables and input (chap #3). Not sure how far we will get in chapter #3. We looked over the first two examples and started to look at the exception example. Assignments: Remember that homework is due the week after it is assigned, but because you have to juggle the extra units, I am very flexible. Just keep on a good pace and keep in touch. For your first VB assignment, I want you to: a) use labels, textboxes and buttons b) have at least one button to process, one button to clear and one to end c) do a couple of calculations (one should be an add) d) format the form (things like color, font) e) define and use a variable f) include something else from the book or from other examples we covered |