Visual Basic - CIS156/56

Weekly Schedule

Remember RE-SUBMIT. If you get back a homework with errors and without a grade it means it has not been graded - you need to fix and resubmit to get a grade.

If you contact me and we work out a plan, I will accept a few things over the weekend of May 11th and May 12th.

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 record all my classes and capture notes on the Smartboard. These are available to you under Audio and Smartboard.
Final Exam Your final exam will be posted on Monday night (5/6/19) and will be due by 12:45PM on Tuesday May 14th.
The status sheet is a requirement and must be turned in prior to the final or with the final.
Final Exam
Status Sheet
Week #14/#15
Week of April 29th/May 6th
Tuesday will be the last day of new material classes. Thursday will be an open lab. Next week will also have open labs on Monday, Tuesday and Thursday. Remember that Lindsey has not taken Visual Basic.
Thursday, May 2nd will be an open lab from 9:30 until 6. I will be there most of the time as will Lindsey.
Monday, May 6th will have an open lab from 11:00 until 4:00 with me the first part and Lindsey after 2.
Tuesday, May 7th will have an open lab from 9:30 until 3:00 with me.
Thursday, May 9th will have an open lab from 9:30 until 6:00 with me there until 3:00 and Lindsey until 6:00.
Dave will be available 4:00 until 9:00 on Tuesday, May 7th and Wednesday, May 8th.
Basic ASP:
ASP.NET - Introduction
    Separate speaker notes to accompany ASP.NET
Code for Classic ASP
Object Oriented VB:
The last chapter in the book has information on object-oriented programming.
invench12.zip
EmpClassV2010.zip
EmpClassRevV2010.zip
Check back!
Week #13
Week of April 22nd
I will be around Tuesday and Thursday when I do not have advisement at 2ish. Lindsey is available Thursday 2-6. (Remember Lindsey does not know Visual Basic but the lab will still be available). Dave will be available 4:00 - 7:00 on Tues and Wed and 10:30 -2:30 on Saturday. Jayson (from the tutoring center) is available 9-12 Tues in New Bedford.
We are going to look at files (covered in chapter 9).
Assignments:
I want you to use the streamwriter to write a file and then streamreader to read the file.
Week #12
Week of April 15th
I will be around Tuesday and Thursday when I do not have advisement at 2ish. Lindsey is available Thursday 2-6. Dave will be available 4:00 - 7:00 on Tues and Wed and 10:30 -2:30 on Saturday. Jayson (from the tutoring center) is available 9-12 Tues in New Bedford.
This week we will look at a coded update and then move on to web pages. Please bring your book if you can.
Update database
Notes on web and 2017.
Assignments:
Your first assignment is to write an update using my example - you just do it for a different file. This can take more than a week.
Your second assignment is to do tutorials 2,3,4 in the text book web development chapter having to do with a picnic and a kayak trip.
Check back!
Week #11
Week of April 8th
I am available at 10 in K112. I will be around Tuesday after class. Lindsey is available 2-4 on Monday and Thursday 2-6. Dave will be available 4:00 - 7:00 on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford.
On Tuesday at 11:00 in K101, a group of CIS graduates who are working in IT will come to class to talk about their work and answer questions. You are invited to attend.
We will continue to look at the coded database SQL Server examples.
Binding fields with SQL Server database
The last day for student withdrawal is April 11th. Let me know if you have questions.
We will continue to look at the coding examples and experiment with the wizard including changing the SQL and using the Query Builder. We will look at using fields, grids and getting a menu at the top that allows manipulation and maintenance.
Assignments:
Write the following programs (these should be your code, not the wizard):
1) A program that brings up table data and displays it in fields.
2) A program that uses information from two tables that is linked in the select. Display in a grid.
3) A program that uses two tables that are declared separately and are linked in the processing.
Check back!
Week #10
Week ofApril 1st
I am available at 10 in K112. I will be around Tuesday after class. Lindsey is available 2-4 on Monday and Thursday 2-6. Dave will be available 4:00 - 7:00 on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford.
We will start looking at databases this week.
Please look at the coded examples I have on the web site as Database examples using SQLServer.
I want you to experiment with creating a SQL server database with Visual Studio. We wiil work on one example in class. There are a variety of step-by-step videos on youtube you might try.
Make and populate database on SQL Server
Assignments:
Create a SQL Server database and table using Visual Studio. Do programs similiar to the grid program I coded and one of the simple textboxes programs I coded. Show data from your database table. You need to write the code rather than use the wizard.
Check back!
Week #9
Week of March 25th
I am available at 10 in K112. I will be around Tuesday after class. Lindsey is available 2-4 on Monday and Thursday 2-6. Dave will be available 4:00 - 7:00 on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford.
We will look at multiple forms and menus this week.
Assignments:
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.
Extra credit if you use a context menu as well. Remember that you need to select the context menu you have set up in the form properties.
Check back!
Week #8
Week of March 18th
Thursday is an open lab day from 9:30 or 10:00 until 6 in K101. Come for as many hours as you can and work to get caught up with Lindsey or myself to answer questions.
I am available at 10 on Monday in my office K112 and Tues at 2:00 in K101/K112. Lindsey is available 2-4 on Monday and 10-12:30 and 2-6 on Thursday. Dave will be available Tues and Wed from 4-7 and on Saturday from 10:30 to 1:00. Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford.
We will spend some time looking at procedures, functions, VB functions etc.
Assignments:
VB Quiz
Vacation
Week of March 11th
Dave is available for help on Tues and Wed from 4-7 and Sat from 10:30 to 2:30. He will probably be in K101 or K118 but if not, the help desk will know where he is.
Week #7
Week of March 4th
I am out sick 3/5/19. Dave will be available 4:30 - 7:30 on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford.
Note - do not use special characters in naming your project etc. I just debugged with commas in the name and it does not work. You can use underscores.
We will start by finishing up array examples. Please go over any array examples we did not cover under VB.NET with emphasis on the redim. Then look at the examples from the chapter examples on arrays. Check back!
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
Week #6
Week of February 25th
I am available at 10 on Monday in my office K112 and on Tues and Thurs at 2 in either K101 or K112. Lindsey is available 2-4 on Monday and 2-6 on Thursday. Dave will try to be available on Saturday from 10:30 to 2:30 on Saturday (he has some family health problems). Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford.
We started looking at arrays last Thursday and we will continue on. The first group we are looking at are under VB.NET and then we will move to the ones associated with chapters in the text.
The class on Tuesday (Feb 24th) got into a lot of things I want to make sure you understand - please be sure to look at the Smartboard and listen to the audio.
Assignments:
Write a top down sort - you can use the bubble sort and the PowerPoint on top down sorts to help. I want you to not only sort on a number, I want you to carry another field with it - lets say department number and department name or course number and course name.
VB Problems
Check back!
Week #5
Week of February 18th
I am available at 2 on Tues and Thurs. Dave is available 4-7 on Tues and Wed and 10:30 to 2:30 on Saturday. Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford.
We will continue with combo boxes etc with an inclass exercise on Tuesday. If you come to class please do not start it until then so we can talk it through.
We will also look at more examples including writing a file and then we will move on to arrays and then go back to procedures and functions.
Refresher on breaks:
Breaks and validation code (zipped)
You should also look at the PowerPoint on minor, intermediate and major breaks.
Assignments:
Combo in class assignment - please write this program
Fix PRMIM so that one click on process gives you all of the output. You will find it under VB.NET in the break examples.
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 #4
Week of February 11th
I am available at 10 on Monday and 2 on Tues and Thurs. Lindsey is available 2-4 on Monday and 3-6 on Thursday. Dave is available 4-7 on Tues and Wed and 10:30 to 2:30 on Saturday. Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford. I strongly sugggest you set up some study groups and meet when Lindsey or Dave are available to answer questions.
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.
Continuing with if and loop! 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
Assignments:
Insurance assignment
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)
Check back!
Week #3
Week of February 4th
I will be available Monday at 10 in my office K112 and Tuesday at 2 in K101. Lindsey will be available 0n Monday from 2-4 and Thursday from 2-6, Dave is available Tues and Wed from 4-7 and Sat from 10:30 to 2:30. Lindsey has only had a brief introduction to VB, Dave has taken both VB courses.
There is a lot of support and you should definitely use it if you have questions or encounter a problem. We are hear to help you succeed! Please take advantage of that.
To repeat: If you need help with something, now would be the time to ask your questions!
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
Assignments:
In Class IF assignments - everyone needs to do this and in fact all assignments posted under assignments
IF assignment
As always, check back!
Week #2
Week of January 28th
I will be available Monday at 10:30 in my office K112 and Tuesday and Thursday at 2:00 for an hour or so. Dave my tutoring/lab assistant will be available Wed from 4 to 7 and Saturday from 10:30 to 1:30.
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:
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 - review
    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 7th by midnight.
Visual Basic program week #2
Quiz: Debug Quiz #1 (zipped file)
Week #1
Week of January 21st
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:
Assignments are due by Thursday at midnight on the week after they were assigned. This assignment is due by midnight on January 31st.
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 and explain what you did as a comment

Send e-mail to Priscilla Grocer: pgrocer@bristol.mass.edu

Back to the Top
Return to home page