Advanced Visual Basic - CIS256/67

Weekly Schedule

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

Assignments without a grade need to be fixed and resubmitted.

Week Information
Assignments due in one week unless otherwise stated. I may add some things during the week, so double check the schedule each week! Note that if you get an assignment returned without a grade you should check and see what revisions need to be made.
HELP schedule Joe Fletcher is my SI. To contact Joe use Zoom Meeting and click join they will then be prompted for the meeting id.
My office hours are 1 on Monday, 10 on Tuesday, 10 on Wednesday, 1 on Thursday. If it turns out other hours work better for students these may change, so check back.
Downloading WinSCP on your PC by SI Joe Fletcher
There is access to WiFi from your car under the solar canopies on the Fall River Campus.
Week #11
Week of November 16th
Read chapter 16,17 and 18.
The assignment for this week deals with object-oriented programming concepts so look over my examples.
I also want you to go back and read the object-oriented chapter in the CIS156 text book.
I want you to write an object oriented program using my examples as a model.
Fill me in on where you are and your plans for finishing.
Week #10
Week of November 9th
Remember that there is a department wide advising session with CIS faculty on Monday Nov 9th from 12:00 to 2:00 and another on Thursday Nov 12th from 6:00 to 8:00. I have sent out the Zoom address, contact me if you do not have it. This is an excellent opportunity to ask CIS faculty questions about the curriculum and your schedule.
On Friday, November 13th there is a talk by William Morrison from Bay State College about digital forensics and cyber security. He will talk about his amazing lab and how they use it to effectively solve situations. Anyone who attends and sends me an email with brief comments about the talk will be given EXTRA CREDIT.

I would like you to go back and review the coding I did in CIS156 for working with SQLServer Databases. These do not use the wizard and instead use the embedded code.
ConvertedtoSQLServer contains all of the examples above
Update database
Write three examples, one that involves combining tables. Extra credit for doing an update.
Week #9
Week of November 2nd
Start moving on and reading chapter #15.
Look at these examples of coding and retrieving records from a database.
SQLServer examples
Referring back to chapter #14. Demonstrate one of the ways they show for handling errors. Extra Credit if you do two of them. Experiment with the dataset designer and the query builder. You can take pictures of the screens and explain them for this part of the assignment.
After looking at my SQL Server examples, write one that is similar to mine using the database you created or mine. Check back!
Week #8
Week of October 26th
Read chapter #13 and #14 on databases.
Be sure you go over the database concepts in chapter #13 and then figure out how to create a SQLServer in VB. It is included with versions 2015 and beyond.
Make and populate database on SQL Server
You will also find some things on YouTube about making a database for VB using SQL Server.
The first part of chapter 14 goes into how to create a data source and how to use them. I would like you to start by creating and using your own. Note that you should also reference the text from CIS156.
Check back!
Week #7
Week of October 19th
Read chapter #12 and do a lot of experimenting.
I want you to experiment with the debugging techniques from chapter #12.
You can either do a write up of what you tried and how it worked or you can do the exercises in chapter 12.
Do exercise 11-1 in the text book murach's Visual Basic 2012/2015.
Week #6
Week of October 12th
Read chapter #10 and #11.
Make a project similar to the project in chapter 10 but use payroll and weekly time card information. Be sure to incorporate the techniques used in chapter 10.
Week #5
Week of October 5th
I have a dentist appointment Tuesday so my office hour is being moved to Friday at 1.
Continue with chapter #9 which deals with functions.
Explore the functions and do a dozen examples including date functions, string functions and number functions. Do at least two of each. In addition, do the flip name problem that we have done in other classes ones using substring and once using another function. Do some validating of data. Experiment with the String Builder class.
Week #4
Week of September 28th
Read chapters 8 and 9. Hopefully all the things from CIS156 are coming back to you.
I want you to go over chapter 8 carefully and find other references to the information if something is not clear.
I want you to set up and work with a jagged array and how to copy and resize a regular array. I want you to experiment with collections. lists, queues and stacks.
Take extra time if you need it.
Week #3
Week of September 21st
I know these first two review assignments are really time consuming so this is a catch up week.
Week #2
Week of September 14th
Move on and read chapters 6 and 7.
I want you to write an program to validate a form with a variety of data. Include the different methods discussed in chapter 7. Include procedures and functions in the program.
Week #1
Week of September 7th
You can use any of the later versions of VB, but since the book is about 2015 that is probably your best bet.
We are using the text book Murach's Visual Basic 2015. I am not totally happy with it so we will do some supplementing! The chapters are a mixture of informtion we have covered and new information or at least information that I believe needs another look, so we will start at the beginning and skim through the first few chapters.
To that end please skim/read the first 5 chapters. Under programs (VB2015 for Murach text) at my site you will see some examples (that go with the 2012 version) I did of things I thought needed to be looked at more closely. Please go over those programs carefully - they supplement the examples in the text. You should also go to and look for Visual Basic examples (They had them for 2012 and they have them for 2015).
Write a review assignment that includes: functions, two dimension array, parallel array with the key other than sequential numbers, structures, multiple forms and modules.

Send e-mail to Priscilla Grocer:

Back to the Top
Return to home page
Return to previous page