|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 2015 in the labs and the book comes with the Express Version. You can get
other versions through MSDN (community edition).
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.
Remember that I tape all my classes and capture notes on the Smartboard. These are available to you under Audio and Smartboard.
Week of May 7th
|Tues and Thurs will be an open lab to get caught up from 9:30AM to 3:30PMish. Please come if you need help because Lindsey and
I will both be available.
Final Exam Due Tuesday, May 15th at 12:45PM - best to pass it in early!
Email it to the regular email for homework and to my BCC email firstname.lastname@example.org. A current/latest version of the status sheet must also be passed in by the time of the final.
Weei of April 30th
|We are going to start looking at ASP.NET. (chapter 11 if you have the book). Let me know if you would like some material I printed
to help with that.
Very basic web site
Creating web forms
More on web development with ASP
I want you to do the Kayak problem presented in tutorial 11-3 and 11-4 in your text book.
I also want you to create a web page of your own design. Try different things like lists, input, calculations etc.
Week of April 23rd
|Lindsey will be available Tues and Thurs at 2. We will be looking at databases and files this week.
I am out with a stomach bug today. I want you to go over the information I posted about a database and I will post more later today.
Please look at:
Binding fields with SQL Server database
Updating the SQL Server database
Programs used with this weeks and last weeks presentation
Create a database in SQL Server and then use it to show data in a grid, data in separate fields and updates to the data done with a grid and separate fields.
Week of April 16th
|I will be available for advisement and helpThursday at 10 in my office and Tues and Thurs afternoons around 2 on.
We will look more at data this week.
This week is a catch up week and I want you to experiment with creating a SQL server database with Visual Studio. We did one example in class. There are a variety of step-by-step videos on youtube you might try. I want you to aslo look at the read and write examples for Visual Studio in CIS120 and do some research or reading on that topic as well.
Make and populate database on SQL Server
Week of April 9th
|On to procedures and functions as well as forms and menus.
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. I want you to also include a procedure and a function in the code.
Week of April 2nd
|This week is a hybrid week and a catch up week. If you are behind I strongly suggest you go to the help labs that are Tuesday, April 3rd from
9:30 until 3:00 and Thursday, April 5th from 9:30 until 3:00. Hopefully there will be
classmates you can talk to and or work with.
Week of March 26th
| We will continue with the arrays under VB.NET and look at those under 2015 as well and then go back to the chapter we skipped.
Some programs/answers to questions:
moreArraysrev.zip (an approach to the extra credit)
testMenuS15.zip quick draft
TwoDimArray.zip Another type of two dim array
Another version of bubble sort
Week of March 19th
|We are going to continue with arrays under VB.NET and then move into arrays that accompany some other
things from the chapter on arrays. Then we will move back and cover some of the information we
We are going to look at sorting so we will go over these presentations:
Notes on top down sort
Notes on bubble sort
Separate speaker notes to accompany topdown sort
Separate speaker notes to accompany bubble sort
Look at my example of a bubble sort and then write the code for a top down sort.
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
Note that I removed an assignment that you will see next week. Check back
Week of March 5th
|We will start out the week looking at validation and functions and then we will move on to arrays. Remember you can email Dave
for a help appointment. We are going to start looking at the arrays under VB.NET and then Programs VB.NET. There is a zipped
folder arrays. Note that because these are a little older you have to let in prepare it to run. We went over the ones
related to dept on Tuesday and will continue on Thursday.
Week of February 26th
|Dave is available for help but he needs you to contact him and set up a time. His email is Dbourgeois321@gmail.com.
We got through the examples from loops (they are listed under chapter #5). Please be sure to read about loops in the book or another book - remember you can get a book from me.
I will then go through the other examples I listed as things to do - faculty and muffin examples etc.
Next we are going to look at breaks. The logic and the code. We might also look at validation and functions depending on time.
Break, combo, validation (some duplication I suspect) zipped
Loops, breaks, combos and validation zipped
Breaks and validation code (zipped)
Fix PRMIM so that one click on process gives you all of the output.
Look at the check or validate program under Breaks and validation code. Write a similar program where you have 8 fields and you validate all of them using a variety of techniques.
Week of February 19th
| We have some catchup to do this week. Check back and see how we did!
Dave will be available for help in K118 from 4 to 6:30 on Wednesday.
Note I added a simple version of writing a file that we used in CIS120 last semester.
On Thursday, I was in and we got through the examples for chapter #5. We did not get to the Faculty and muffin examples I listed last week.
To help with accumulators you want to get the muffin example under loopscomboetc.zip. Look at the information about getting it under week 4 below.
Rock, Paper, Scissors Assignment Write the program and please include accumulators to report number of games user won, number of games computer won and number of ties.
Week of February 12th
|Dave will be available for help in K118 from 4 to 6:30 on Wednesday.
I am out sick this week. This ia enrollment verification week so please verify you are in the class.
Please go through all the examples for chapter #4 and chapter #5 and make sure you have read those chapters or if you decided against the book that you have found and read information on those topics.
We will also take a look at loops, but if you look at the examples first, that will help make up for the day we missed...
Since 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
So, the ones we will look at are FacCrsSetup, FacCrsUserEntry, FacultyCourses, muffins which is in a loops folder which is in VBNETCIS56. We will also look at a very basic way to use files - more to come later. Go to VB.NET and then Programs VB.NET and in the conditions group there are if examples with files. The programs themselves are in If programs (zipped).
Some help with decision problems from chapter 4
Information on writing a file:
Simple version from CIS120:
projWriteText.zip - creating a file
readProj.zip - reading a file
If examples with files (word version)
Week of February 5th
|I will be available Monday at 10 in my office K112 and Tuesday and Thursday at 2 in K101 (hopefully).
We are going to continue looking at chapter #4 and if statements. If you have any questions from what we went over Thursday, please ask! Please read the chapter as well. If you do not have the book you should find information on line on IF statements. Remember, I have some older VB books that will definitely help with logic if you want to see me about using one.
Some help with decision problems from chapter 4
In Class IF assignments - everyone needs to do this and in fact all assignments posted under assignments
There are a few notes on the first three on the inclassif at Feb 7, 2017 starting at slide 21 I believe.
Week of January 29th
|I will be available Monday at 10 in my office K112 and I sent you an email about Dave, a fellow
student who is willing to help.
I need to reschedule my Tuesday office hours - I will be available later Tuesday afternoon and Thursday at 2.
Either finish chapter #2 and then read chapter #3 or find another source to read about starting Visual Basic and using variables and input. The topics covered in the examples are the things you should follow through and read about.. We will slow down the chapter pace now...
Additional notes on the first few examples:
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 - review
Separate speaker notes to accompany presentation on logical if structures
Homework is due the Thursday of the week following the assignment. So assignments for this week are due Feb 8th 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. Note you need to pass in two versions of this assignment!
Quiz: Debug Quiz #1 (zipped file)
Week of January 22nd
This course will use Visual Basic 2015 although 2017 or 2012 is also acceptable. Some of the examples were written in 2010 and I checked many of
them in VB2012 and VB2015 and found no problems.|
The text I recommend is expensive so if you want to use a different text for reference we can try and make that work. If you decide on a different text, please let me know what you choose. I mainly want the text to explain some of the details that I do not have time to go over in class. I do not give assignments from the text except in one case where I have you try a model problem but I have worked around it with students who do not have the text.
Whatever you decide, you should read the section that discusses the setup of the screen for visual basic (we looked at that in CIS120 if you were in my class).
You can get a copy of Visual Studio Express community for desktops free. I can be used on your desktop or laptop computer. You can download 2015 which matches the book or 2017 if you want to try working with that.
Site to download
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.
We looked at the first two examples: PayCalc.zip, cisBasicProj.zip and developed one from scratch. Next week we will look at the examples under variables and input.
Assignments are due by Thursday at midnight on the week after they were assigned. This assignment is due by midnight on February 1st.
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, the web or from other examples I have posted