Advanced Visual Basic - CIS256/67

Weekly Schedule

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). 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.

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 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 Exam Read chapter #23 on LINQ.
Your final will be to work with LINQ. Come up with a list of sample queries (10) that retrieve information different types of where statements. Reference some things you did in the Oracle class if you want ideas. Include linking two tables in one query. Your text shows to instances of using a form with embedded LINQ. You can think of this as the final. In fact I wanted to cover one more topic so since this is the last topic... If you run into problems, let me know and this can become a homework and I can give you something else to do - give it a try and let me know.
The final is due by May 18th.
Status sheet: Please give me a list of all the assignments you did.
Week #15
Week of May 4th
Catch up week!
I will be posting information about the final.
Week #14
Week of April 27th
The next two chapters to read are 22 on XML and 23 on LINQ.
Assignments:
Develop code to create XML and then to read it.
Come up with a list of sample queries (10) that retrieve information different types of where statements. Reference some things you did in the Oracle class if you want ideas. Include linking two tables in one query. Your text shows to instances of using a form with embedded LINQ.
Week #13
Week of April 20th
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
Read some of the information on Object-oriented programming in section 4. Definitely read chapter 17 and 18.
Object-Oriented Programs
invench12.zip invClassFirst.zip
invClassSecond2011.zip
EmpClassV2010.zip
EmpClassRevV2010.zip
Assignments:
Write a simple web page based on my example and instructions.
Write a simple object oriented program similar to the examples I have posted. In it experiment with some things you want to try and send me what you did with an explanation.
Week #12
Week of April 13th
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.
Basic
VBGrid
bindonclick
DonorFormSQL
DonorTwoTables
TwoGrids
combinewithSQL
ConvertedtoSQLServer contains all of the examples above
Update database
Assignments:
Write a couple of examples, one that involves combining tables and one that involves updating.
Week #11
Week of April 6th
Read chapter #16. It covers 1) connections and commands, 2) parameters and 3) commands.
Assignments:
I want you to experiment with something covered in each of the three catagories listed.
Check back!
Week #10
Week of March 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.
Finish up reading chapter #15 and move on to chapter #16.
Assignments:
I would love to have you try all of the topics in chapter #15 but that is pushing it. So...
1) Do something with bound text boxes and combo boxes 2) Do something with parameterized queries 3) Pick two other things that interest you in the chapter and do something with them 4) Extra credit if you try something else (but you gotta tell me what you tried and where)
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.
Look at the SQL Server examples I posted last week and execute them on your setup.
Assignments:
Write three programs similar to mine using the database you created or mine.
Week #8
Week of March 9th
Start moving on and reading chapter #15.
Look at these examples of coding and retrieving records from a database.
SQLServer examples
Assignments:
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.
Check back!
Week #7
Week of March 2nd
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.
Assignments:
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 #6
Week of February 24th
Read chapter #12 and do a lot of experimenting.
Assignments:
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.
Week #5
Week of February 17th
Read chapter #10 and #11.
Assignments:
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.
Do exercise 11-1 in the text book murach's Visual Basic 2012/2015.
Week #4
Week of February 10th
Continue with chapter #9 which deals with functions.
Assignments:
Explore the functions and do 5 date functions, 5 string functions and 5 number functions. 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 #3
Week of February 3rd
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.
Assignments:
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 #2
Week of January 27th
Move on and read chapters 6 and 7.
Assignments:
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 January 20th
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 new text book Murach's Visual Basic 2015 or the 2012 version if you have it already. 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 www.murach.com and look for Visual Basic examples (They had them for 2012 and they have them for 2015).
Assignments:
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: Priscilla.Grocer@bristolcc.edu

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