Visual Basic - CIS156/56

Weekly Schedule

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 2010 in the labs and the book comes with the Express Version. You can get other versions through MSDN. 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.
Week #15
Week of December 12th
I will not be in this week, for family reasons.
Just rechecked the calendar and Friday is officially the last day of classes.
I can be contacted via email and Mark and Wayne will be there for all of my classes to help with any problems.
There will be an open lab from 9:30 to 3:15 on Tues and Thurs and Mark and Wayne will be there for help.
I will email you your final by this Tuesday the 13th and it is due by noon on Tuesday the 20th.
Week #14
Week of December 5th
Monday I will be available at 10 in my office (K112).
Tuesday I will be available from 1:45 until 3:15 in K101 and until 5 in my office.
Thursday I will be available from 1:45 until 3:15 in K101 and in my office (K112) until a little after 6.
We are going to continue with web sites so please try to get a brinkster account.
I have sent you the login information for my sample area at Brinkster. If you did not get it, let me know.
Assignments:
Create a website and upload it to your Brinkster account. I would like to see an image and a link to another page.
Create a website that relates to a database and upload it to your Brinkster account. It looks like Brinkster only supports mdb databases, so you can open your accdb and save it as an mdb.
Week #13
Week of April 25th
Check CIS122 for times I am available.
We will continue to look at ADO this week with our first focus on updating.
Updating using ADO
I want you to go through the chapter on ADO (chapter #10) and follow the examples on using the wizard.
That will give us time to move on to chapter #11 and deal with Web applications. So please read chapter #11.
I would also like you to set up a free account at www.brinkster.com that we will use for web applications.
Assignments:
I want you to write an update using one of the tables that you designed in Access. When I run your program, I want to be able to add a record, delete a record and change a record.
Week #12
Week of November 21st
Tuesday I will be available from 1:40 until 3:15 in K101 and in my office until 5ish.
We will continue with ADO coded by you. These are the examples we will look at:
ADO example using Access 2007
Second group of ADO examples
Assignments:
ADO Assignment using your own code (not the wizard)
There have been real problems with the two grids - we will handle this with effort and extra credit.
Experiment with two grids in 2010
Week #11
Week of November 14th
This week start to look at ADO, both using the wizard and writing your own code. The focus will be on writing your own code, at least at the beginning.
Be sure you have read chapter #10.
This week we are going to continue to talk about databases and connection to databases.
Example - getting started: ADO demo
Programs to look at: ADO getting started
We will then look at some of the examples under ADO work with under programs from VB.NET.
ADO example using Access 2007
Assignments:
Using the database that you developed last week, I want you to implement the first two queries in VB programs. In one of them please use text boxes and in the other use a grid..
Write the SQL queries to access information from one table using the following criteria: conditionA and either conditionB or conditionC.
Write the SQL to show all employees that have a department number of your choice and make over a salary of your choice.
Use the wizard to read one of your tables that you created last week and display the information on the form. Follow the example in the text.
Week #10
Week of November 7th
Please go over the rest of chapter #9.
We started to look at Access. We looked briefly at how to set up tables, how to query them using the user interface and how to query them using SQL. We then look briefly at a relational database and third normal form and how to implement this in Access. This week you need to continue looking at working with Access and SQL. I am including some information here and you should do a little searching on your own. The information I am including comes from a variety of classes where Access is used.
From CIS120/17 here are some basics. The SQL ones are for an earlier version but SQL is SQL once you get to writing the code.
Zipped version of Access 2007 Introduction
Presentation on using SQL queries in Access
    Separate speaker notes to accompany fusing SQL queries in Access
From some other courses
Presentation on SQL in Access - a little more
    Speaker Notes to accompany SQL in Access - a little more
Generic notes on SQL
Normalization - information on third normal form
      Separate speaker notes to accompany normalization presentation
Relational database using donor
      Separate speaker notes to accompany relational databse using donors presentation
Read chapter #10 in the VB book
Assignments:
Payroll database example for you to develop and populate
Write the SQL queries to access information from one table using the following criteria: conditionA and either conditionB or conditionC.
Write the SQL to show all employees that have a department number of your choice and make over a salary of your choice.
Write the SQL to show the employee number, employee name, department number and department name.
Write the SQL to show the employee number, employee name, project number of all projects the employee worked on.
Write the SQL to show the employee number, employee name, project number of all projects the employee worked on and the name of the project.
Week #9
Week of October 31st
Also please remember the audio versions of the lecture and the accompanying Smartboard from last semester. If something is confusing, give them a try .
This week my CIS120 class at 11:00 will have a guest speaker on Thursday from Meditech who will talk about some of the careers available in his company. You are welcome to attend - I have no idea how seating will hold up but there is definitely standing room.
In class we will continue with arrays and start to look at files. Please look over the material in chapter #9.
We are going to look at developing an Access Database and also at SQL.
Assignments:
First: Convert my bubble sort program so it does the sort using the top down method. These two methods are covered in PowerPoint presentations at my site.
Second: I want you to experiment some more with arrays. Write a program of your own design that uses a two dimension table. Also set up an array that has an element containing both the number and the name and extract the number so you can compare it to user input (for example, in one of my soup programs I had 03Seafood Chowder as an element in the table and I used a function to extract 03 to compare in a search). I want you to do something similiar.
Week #8
Week of October 24th
This week we will work on chapter #8 dealing with arrays. You should look at my examples under 2010 and also my examples under VB.NET that were developed in 2005/2008 etc.
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
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 #7
Week of October 17th
Read chapter #6 and then move on to chapter #7. We will look at functions and procedures including some things in the VB.NET examples (including VB functions). Chapter #7 deals with multiple forms, modules and menus so at least get started on those topics.
Assignments:
These can all be combined into one program or you can do separate programs.
•  Write a function that you pass information to. Experiment with ByRef and ByVal and explain any findings.
•  Write a procedure that you pass information to. Be sure to show the difference between using ByVal and ByRef.
•  Write a program to take in a name in the format Last/First Middle (for example Doe/John M) and return the name in the format First Middle Last (for example John M Doe). I want you to do this using functions that exist in VB to do the flip. Modify this to select a title/form of addressing from a radio button and put the title in front of the flipped name. One of the possibilities should be no title in which case you will not add a title. Create a file that contains a record with each flipped name and also display the flipped name on the screen.
•  Write a program using a do...while loop to put out math problems using the math facts concept illustrated in the for...next examples (VB.NET examples). The user should then enter the answer. You should evaluate the answer and tell the user whether it is right or wrong. have a second button that you can click and that will give the user three chances to enter an answer if it is wrong and then tell the answer and move on to the next problem (a loop within a loop).
Week #6
Week of October 10th
This week we will finish up loops by looking at a few more of my examples.
Assignments:
1) Fix the Minor/Intermediate/Major program under Loops and Breaks under VB.NET so that you only have to click once to see all of the data.
2) Write a program that uses three different boxes, that loads the data into the boxes (lists) in different ways and that uses three different kinds of loops different structures and testing.
Week #5
Week of October 3rd
We will finish up chapter #5 this week. Spend some time looking at the .net examples because they have a little more detail. Look at the different methods to set up random for the quess game. Check back!
Assignments:
On this assignment, try to make it look fun to play.
Rock, Paper, Scissors Assignment
Week #4
Week of September 26th
We will look at a little more from chapter #4 and then move on to chapter #5, so please read it.
Look at the examples under 2010 and we also looked at the guess example under loops in the .net. We will continue with these examples next week.
Assignments:
Insurance assignment
Week #3
Week of September 19th
Please read chapter #4. You should look at the examples I have posted for chapter #4 under 2010 and you should look at the if statement examples under .NET.
Check back!
Assignments:
Was done as an inclass assignment when not exculsively online
IF assignment
Week #2
Week of September 12th
Finish reading chapter #2 and chapter #3. We will look at examples from both 2010 and the more generic .net list. Programs to look at: Please look at all of the programs under chapter 3 for 2010 examples. Under the .NET examples, these are the ones I suggest looking at: AppwithLoad, calculations, convert, datatypes, formatting, invenbasic, OrderOperation, testtabindex. The goal is to look at them in class as well, we will see how it goes.
dreamspark.com Check for software
Assignments:
Visual Basic program week #2
As always, check back!
Week #1
Week of September 5th
This course will use Visual Basic 2010 (.NET). If you have a different .NET version, talk to me.
Read chapter #1 in the text, I would also start to read chapter #2.
You should be looking at the beginning examples and programs and the beginning PowerPoints. Note many of these were done for the .NET version and while the code works, there are development differences. The software for this course is available through the text and it is also available through the Microsoft alliance. For information about using the alliance to acquire software for this course: MSDN Alliance Software
Assignments:
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 As always, check back!

Google
WWW www.pgrocer.net

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

Back to the Top
Return to home page