Visual Basic - CIS156/56

Weekly Schedule

Your final is due Tuesday, August 16th. Your final has been sent to you, and is due back in a week (Aug 16th). Work may be passed in through August 22nd

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.
Unit #14 We are going to continue with web sites so please 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.
Unit #13 We will continue to look at ADO this unit 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.
Unit #12 We will continue with ADO code (note I am focusing on writing the code instead of the wizard). 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
Unit #11 This unit we are going to start to look at ADO, both using the wizard and writing your own code. My focus will be on writing your own code, at least at the beginning. Please start to look at my ADO examples.
Be sure you have read chapter #10.
This unit 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 unit, 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.
Unit #10 Last unit 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.
Unit #9 Please remember the audio versions of the lecture and the accompanying Smartboard. If something is confusing, give them a try.
In class we will continue with arrays and start to look at files. Please look over the material in chapter #9.
This unit, we are going to look at developing an Access Database and also at SQL.
I want you to review Access (assuming you had it in CIS120/17). If not, do some research.
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.
Unit #8 This unit 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
Unit #7 This is the half way point in assignments - when you finish this assignment you are half way through the units.
Read chapter #6 and then move on to chapter #7. We will look at functions and procedures on Tuesday including some things in the VB.NET examples (including VB functions). Chapter #7 deals with multiple forms, modules and menus.
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).
Unit #6 This unit we will finish up loops which means I want you to look at 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 in different ways and that uses three different kinds of loops.
Unit #5 We will finish up chapter #5 this week (hopefully). We will 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
Unit #4 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
Unit #3 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:
Check off exercise
IF assignment
Unit #2 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 was to look at them in class as well, we will see how it goes. That means you should be sure to check the audio and the Smartnotes for the class.
dreamspark.com Check for software
Assignments:
Visual Basic program week #2
As always, check back!
Unit #1 There are 15 units in the semester, I will put one up every few days for a while so you can develop a plan to help you get through all of the units during the summer. 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.
I have put out new programs that relate to this text and version 2010. Look at these but also look at examples from previous verions. You should also be looking at the beginning examples and programs and the beginning PowerPoints for previous versions. Note many of these were done for the .NET version and while the code works, there are development differences, usually minor. 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