| 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 2012 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 May 4th |
We will have open labs in K101 on Tuesday from 10 to 2 and then we will move to K118 hopefully for an hour or so
and Thurs from 9:30 until 2 and then we will move to K118 for an hour. This is a time to get some more things
in to finish off the semester. Your online final will be posted by Tuesday, May 5th and it is due by 12:45AM on Tuesday, May 12th via email. The required status sheet: REQUIRED status sheet Final Exam Please note that all of these problems involve writing in Visual Basic including #6 where the SQL is within Visual Basic. You can handle date and time together, separately as a text field or any thing that works for you. Woops #1 had an extra average in there I think - got a little carried away. |
| Week #14 Week of April 27th |
I will be doing registration and helping this week so Monday at 10 and Tuesday and Thursday around 2. Pat is available
Tuesday and Thursday around 2 and Wednesday between 2 and 4. Don't forget to sign up to see your advisor! This week we will continue with Web Page Development for the web (look at chapter #11 or do some research on the topic. Assignments: I want you to do the Kayak tutorial from the recommended book. If you do not have the book I can send you the problem - send me an email. Here are some notes on it as well. Kayak info This assignment involves making the Kayak Tour page and linking to the secondary page as shown in the next tutorial. |
| Week #13 Week of April 20th |
I will be doing registration and helping this week so Monday at 10 and Tuesday and Thursday around 2. Pat is available
Tuesday and Thursday around 2 and Wednesday between 2 and 4. Don't forget to sign up to see your advisor! We will continue with database use this week and then start web development. Information about upcoming events through STEM under Posting/Notes on my home page. Some examples using web matrix: Basics ASP using VBHTML in Web Matrix document Code for Basic ASP VBHTML examples shown above Please bring your textbook to class. Assignments: 1) I want you to do maintenance using the wizard. First do it with a grid and second do it field by field. 2) I want to see three experiments with web matrix using VBHTML. 3) I want to see a web page with a variety of things on it created within VB (use chapter 11 for a reference). Please check back! |
| Week #12 Week of April 13th |
I will be doing registration and helping this week so Monday at 10 and Tuesday and Thursday around 2. Pat is available
Tuesday and Thursday around 2 and Wednesday between 2 and 4. Don't forget to sign up to see your advisor! We will continue looking at using database with Visual Basic. Again, we will look at writing our own code and this time we will add updating the files. The STEM club on campus has set up a Facebook page. STEM Club We will continue looking at maintenance. Add a record to a table that we did in class Allows change and delete on the grid. Using the wizard to populate a grid Assignments: I want you to write an update program that will allow you to add, change and delete records on a database table. Need to use a table that I have not written code to update. |
| Week #11 Week of April 6th |
On line week. Pat will be available from
9:30 until around 2:30 mostly in K101 but moving to K118 at 1:45ish on both Tuesday, April 7th and Thursday,
April 9th. This week I want you to review setting up and writing an Access database and using SQL. You
will need both for last weeks assignment. |
| Week #10 Week of March 30th |
I am available at 10 on Monday in my office and Pat is available from 2-4 on Wed and both of us are available
on Tues and Thurs at 2 in K118. Remember, the week of April 6th is an online week. Pat will be available from
9:30 until around 2:30 mostly in K101 but moving to K118 at 1:45ish on both Tuesday, April 7th and Thursday,
April 9th. Two other array examples that came from questions or discussions: structureArray.zip TwoDimArray.zip Another type of two dim array This week we went through the first 10 examples under ADO looking at writing the code as opposed to using the wizard. Assignments: Payroll database example for you to develop and populate You can write separate programs, use buttons to access different procedures or have one problem solved and the rest commented out. Note you cannot use the wizard. First: 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. Second: Write the SQL query within VB that does a grouping by department number and shows the sum of the salary for each group. Third: 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. Fourth: 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. |
| Week #9 Week of March 23th |
I am available at 10 on Monday in my office and Pat is available from 2-4 on Wed and both of us are available
on Tues and Thurs at 2 in K118 (I need to confirm Pat). We will spend more time with arrays. Please check back! Extra credit: As we looked at the program moreArrays, I commented on how to code it so the course numbers are in sequence in the array and that it still retrieves the right course name and said anyone that got me that revision before class on Thursday would get extra credit. Two programs we looked at on Thursday (the second one is really a draft). moreArraysrev.zip (an approach to the extra credit) testMenuS15.zip quick draft 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 - write your own search to find the information 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 Multiple forms, menus and modules assignment: 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. Experiment with both modal and modeless. |
| Catch up week Vacation Week of March 16th |
This is catch up week - I am hoping that a lot of you will get caught up with assignments that you owe me. If you are having problems Pat will be coming in on Tuesday and Thursdayfrom 10 to 3. He is planning on K101 but if other people are using it you may have to look for him or ask at the help desk. You can also email me with questions and problems as well as homework for me to check. |
| Week #8 Week of March 9th |
I will be available Mon at 10 in my office, Pat will be available from 11 to 3 on Tuesday and Thursday and
I will be available with him around 2, Pat will also be available Friday from 11 - 1. We will probably be in
K-118, if you can't find us check with the help desk. We will continue with arrays this week. We are still working on the VB.NET examples although we may get to the more recent ones as well.. Assignments: Array Assignment Mod11 explanation Topdown Sort: I want you to code a top down sort in the way that I coded the bubble sort. I will reassign this after break but I figured I would let you know now in case you want to play with it. |
| Week #7 Week of March 2nd |
I will be available Mon at 10 in my office (snow permitting), Pat will be available Tues and Thurs from
11 to 3 and Wed from 2-4. If you can't find him ask at the help desk. I will be available Tues and
Thurs at 2 for at least an hour (I come and go a little but Pat is there. This week we will look at procedures and functions (chapter #6). A program we talked about at the end of class: chkSub1.zip Next we are going to start looking at the arrays under VB.NET. Please look at the array examples under Introduction to arrays and Introduction to arrays continued. We will review on Tuesday. Under presentations look at Array Introduction. Assignments: 1)Using my firstProcedures program I want you to do something similar. Using procedures, I want you to take in the value of a car and the tax percent and calculate the payment due once using ByRef and once using ByVal. Then I want you to redo it using functions and again use ByRef and ByVal. 2) Using my searchparallel program I want you to do something similar. Set up parallel arrays that have a course id and a course name so this is CIS156 Visual Basic. Put around 6 courses in and then have the user enter a course id and you return a course name. |
| Week #6 Week of February 23rd |
The plan is for a normal week with me available at 10 on Monday in my office, Pat and I available 2ish in K118 on Tues and Thurs and Pat available
Wed from 2-4. A representative from Meditech will be coming to my 11:00 class on Thursday. We will continue with the examples under Lists and Loops and then move on to VB functions. Breaks and validation code (zipped) I want you to look at the project check Check back! Assignments: VB project we will start in class VB function and loop assignment |
| Week #5 Week of February 16th |
Pat from 8 - 4 on Friday and I am around after class on Thursday (1:40) and hopefully at 10AM (snow driving
assumed ok) in my office.
Hopefully we will be in K101 or K118 but if we are not there check with the help desk - we will be sure to report any changes. Loops are our next topic! I want to look at the intro one under chap 5 called basicLoops and I want to look at a series of programs involving Faculty and muffins that are in this zip - you have to keep clicking to get the muffin one. loopscomboetc.zip Assignments: Rock, Paper, Scissors Assignment Write the program. 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. Here are copies of the two break programs if you can't find them at the original source: breaks.zip Check back! |
| Week #4 Week of February 9th |
Tuesday, February 10th is going to be an online day. I have over 2 feet of new snow and it is still snowing and it is 11PM.
So, I will post what you should cover in preparation for the Thursday class.
I believe (depends on his snow situation) that Pat will be in K101 from 11 until 2 and then he will move
to K118. Pat just confirmed that he will be in at 11. I will be available Thursday at 1:45 in K118. Pat just confirmed that he will be in at 11. Check back for the information you need to cover! One thing is posted below. Decision problems from chapter 4 I would also check the Smartboard and audio for 9/4/2014 and 9/6/2014. I will be posting one more Smartboard looking at some examples in VB.NET that include files. We will deal with other versions later in the semester. VB.NET examples using files Note that there are two sets of examples, you should probably stick with the second since it is more current. Hopefully we will also be able to look at breaks, we will see... There is a presentation on breaks in this set of presentations: Loops, breaks, combos and validation zipped Please read chapter #5 on loops - we will start looking at loops next. Assignments: Insurance assignment Check back! |
| Week #3 Week of February 2nd |
Pat and I are available at 1:45 on Tues and Thurs and Pat is also available on Wed from 2 - 4. Depending on
weather, I may be available Monday at 10 in K112. We are going to start looking at chapter #4 and if statements. If you have any questions from what we went over Tuesday, please ask! Assignments: In Class IF assignments - everyone needs to do this and in fact all assignments posted under assignments IF assignment Check back! |
| Week #2 Week of January 26th |
I will be available for help Monday at 10:00 in my office, I will be available Tuesday and Thursday at 2:00 in a lab check my office K112
for a note if I am not there. This week I believe Pat will be available on Tues and Thurs at 2. You can check my
office (K112) or ask at the help desk in the main lab. And then there is the matter of the snow... I live just south of Boston so if the snow is really bad, we may do a online class on Tuesday. Check back at this site and I will post whether I will be there or not. Since there is no school on Tuesday, I made this Smartboard presentation that goes over the first few problems in the intro, week 2 and the start of week 3. Please go over it carefully. If you have any questions we can discuss them Thursday and then move on... VBIntro23S15.pdf Our goal is to finish the examples under chapter #3 this week. If we have time, we will start to look at if statements. 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: Homework is due the Thursday of the week following the assignment. So assignments for this week are due Feb 5th by midnight. Visual Basic program week #2 After we have looked at if statements, go back and modify this program to use IF statements to test quantity. Need to pass both versions in but they are separate grades so you can pass them in at different times - I would like the IF statement version by Feb 11th . Quiz for Thursday (due with homework by Feb 5th): Quiz #1 (zipped file) |
| Week #1 Week of January 19th |
This course will use Visual Basic 2012. The examples were written in 2010 and I checked many of them in 2012 and found no problems. Read chapter #1 in the text, I would also start to read chapter #2. You should be looking at the beginning examples and programs. There are also examples written in .NET that will run as well. They are accompanied by PowerPoint explanations. Again, note while the .NET code works, there are development differences. The software for this course is available through the text and it is also available through the Dreamspark. You should have received an invitation to Dreamspark, if not, you will receive it soon. Assignments: Assignments are due by Thursday at midnight on the week after they were assigned. This assignment is due by midnight on January 29th. 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 I have posted |