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