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.

The college is not allowing people to withdraw until April 11th and the they will also let us know when the last date to withdraw will be (April 30th I believe). If you want to evaluate your status you can contact me and we can talk about a variety of options depending on your status. If you are behind, your first move should be to get in touch! We can talk about extensions and other options.

Remember HELP is available with Joe on Collaborate - see HELP section below.

The CIS pool is now available for students that need to access licensed software that they cannot use from home.
Remote access virtual desktop
Instructional video for using Remote Access Virtual Desktop - HTML

I have had a lot of requests, so... If you have a few more things I can take them up until the 18th. Beyond that you need to check with me! Joe has finished his SI role, if you want to meet in Collaborate you need to contact me for a time to meet.

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 2019 in the labs and 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.
HELP schedule To contact Joe use moocowoftech@gmail.com. He will be available from 9-2 on Mon thru Fri for open labs at this address: Collaborate
For hours outside of that he will be using Microsoft Teams which is available to you through Office 365. Send him an email from your bcc account with the classes you want to connect to and you will get a link to join. Here is a brief run down on how it works and what to expect: Microsoft Teams overview
There is access to WiFi from your car under the solar canopies on the Fall River Campus.
Final Final Exam Due May 13, 2020
The final is open note/open book with no help from any person other than me. Let me know if you have questions.
Homework is due by the last day of classes (May 11, 2020), however I will take a few things after that. Contact me if you are having trouble.
The status sheet posted last week is a requirement. Please fill it in completely and return it by May 13, 2020.
Week #15
Week of May 4th
Catch up week!
I will be posting information about the final this week. You will have one week to do it.
Required Status Sheet
Week #14
Week of April 27th
I tried a simple example of a web page using 2019. Take a look at both the example and the instructions and then give it a try.
Basic Hello World Web Page
Basic Web Page Instuctions
Check back!
Assignments:
Using my example as a model, create your own web page. Make it different maybe taking in multiple things etc.
Week #13
Week of April 20th
Chapter 11 deals with web page development and it is a good reference. If you do not have the book, do a little research on your own. I will add some more information in the next few days. Unfortunately 2019 is very different, but the book and the article below explain the concepts that were used in slightly older versions.
Other references:
Information about creating a web page in 2015
Catch up week.
Week #12
Week of April 13th
Database examples using SQLServer: Please look at these examples that are done without the wizard.
Basic
VBGrid
bindonclick
DonorFormSQL
DonorTwoTables
TwoGrids
combinewithSQL
ConvertedtoSQLServer contains all of the examples above
SQL Server Database Basics in Powerpoint
Assignments:
Write a program that shows fields without using the wizard and write a program that shows a grid without using the wizared. Extra credit if you use multiple tables and try some of the things I tried in the examples that are not part of the Powerpoint.
Check back!
Week #11
Week of April 6th
Continue work with SQLServer and Visual Basic. Be sure to go over the material in the book. Let me know if you are encountering problems.
If you have the text, please start looking at the chapter 10 and trying the tutorials.
Tutorial about loading into a grid
Tutorial about loading into a grid and an update bar
Tutorial about loading into fields and an update bar
Assignments:
I want you to do an update of a table using the update bar. Do it two ways, one with a grid and one with fields.
Check back!
Week #10
Week of Match 30th
I will give extra credit to anyone who goes to the Collaborate site (see link in HELP above) and either works with Joe on something they need help with or shows him something they have done for the course. Send me an email and let me know what you did. Actually this applies to doing something with Joe using Teams app as well.
We are about to end the basics of VB and start looking at data. First I would like to know where you stand and your comfort level with the material we have covered. Remember Joe is available online - see his HELP schedule above.
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 Note that this was using a slightly earlier version, so getting into VB does not look the same. BUT... Once you are in the things to create the database table are the same.
Binding fields with SQL Server database
There is a video under week #11 you will find helpful.
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.
Check back!
Week #9
Week of March 23rd
Officially there are no classes and no assignments this week. However, I decided to post this weeks work anyway so you can get started on it if you choose to. I feel that choosing to do the work this week will spread the work out better and make the end of the semester easier no matter how it is handled. I will keep putting out the work for each week as originally planned to give you more flexibility. Late points will not be taken. Again, it is your choice whether you do the work this week or leave it for next week.
I want you to look at multiple forms and menus this week.
These are some notes you can look at (note that the Multiple forms and menus from 2018 seems more comprehensive.
Procedures and Functions (3/19/19) in PDF format Accompanying audio
Multiple forms and menus (3/26/19) in PDF format Accompanying audio
Procedures and Functions (3/19/19) in PDF format Accompanying Smartboard presentations
Multiple forms and menus (3/26/19) in PDF format Accompanying Smartboard presentations
Procedures and functions (4/10/18) in PDF format Accompanying audio
Multiple forms and menus (4/12/18) in PDF format Accompanying audio
Procedures and functions (4/10/18) Accompanying Smartboard presentations
Multiple forms and menus (4/12/18) Accompanying Smartboard presentations
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 9th
I will not be on campus Thursday, March 12th - the material for the class will be online. The group advising session is also cancelled, we will reschedule if possible.
Bubble Sort Presentation
Bubble Sort Notes
Top Down Sort Presentation
Top Down Sort Notes
This week we will look at a few more arrays and then go back to look at procedures and function. We may move on to multiple forms, modules and menus. As we look at procedures, remember the quote from the Gaddis and Irvine Visual Basic book: "There are two ways to pass an argument to a procedure: by value or by reference. Passing an argument by value means that only a copy of the argument is passed to the procedure. Because the procedure has only a copy, it cannot make changes to the original argument. When an argument is passed by reference, however, the procedure has access to the original argument and can make changes to it."
Assignments:
Procedure/function assignment
Please check back!
Week #7
Week of March 2nd
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:
In class (or homework if you are not in class. In class arrays
Assignment #1: 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
Assignment #2: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. There is a presentation under week #8 (I had a hard time reclaiming it).
Week #6
Week of February 24th
I will not be on campus Thursday, February 27th. It is an online day. Joe will be available for help during class time. Check back!
We will start looking at arrays this week. First we will look at the ones under .NET.
We go through the soup search - we did dept arrays, two dimensional arrays and started the examples using soup.
Assignments:
1) Write a program that includes a two dimensional array that you can retrieve data from.
2) Create a text file where each record contains the employee id (use numbers not in sequence so not 1,2,3 etc) and the hours worked that week.
3) Write a program that will read the employee hours file you created and search for a match to an employee id in an array in your program. Once you have found a match retrieve from an array or arrays the employees name and their pay per hour and display there employee id, name and the pay they earned this week.
Week #5
Week of February 17th
We will continue with combo boxes etc with an inclass exercise that I would like you to do for the Thursday class when we can review it. I decided since I have not been around that it would be a better use of class time.
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.
Minor break presentation
Minor, Intermediate, Major break presentation
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 10th
My husband is still in the hospital recovering from open heart surgery, so I will be doing all my classes on line this week.
Joe will be around during class time and for labs.
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. Also be sure you look at my examples and the examples tor the topic under VB.NET as well.
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 3rd
My husband is having emergency surgery this week so I will not be in for class on Tuesday and Thursday.
Joe Fletcher is available for help if you encounter probems - check the help session above and look for him in K101 for the 11:00 class and the 12:30 class.
We are going to continue looking at chapter #4 and if statements. If you have any questions from what we went over last class, 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
I strongly recommend that you reference the Smartboard and audio from last Spring and that you look at the examples including those under VB.NET
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 27th
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 6th by midnight.
Visual Basic program week #2
Quiz: Debug Quiz #1 (zipped file)
Week #1
Week of January 20th
This course will use Visual Basic 2015/2017/2019, but the version in the classroom will be 2019. Some of the examples were written in 2010 and I checked many of them in VB2012 on up 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. You can also look for the 2015 version which is available at a better price.
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 a version which matches your book or 2015 or 2017 or 2019 if you want to try working with one of them.
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 hopefully will look 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 30th.
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