Advanced Visual Basic - CIS256/67

Weekly Schedule

Max is willing to do a Friday help on November 30th that I will try to attend - can't be sure. I have asked for K116. Again I want email confirmation from 10 especially if I can come.

Homework is due the Thursday after it is assigned by midnight unless I specify otherwise.

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!
Week #13/#14/#15
November 26th/December 3rd/December 10th
The plan (subject to change so check with me) is to be available for help Monday at 10, I may have some time between 2 and 4 depending on meetings. I also plan to stay late both Tues and Thurs (until 5ish and that can change if you let me know. Max will run an all day workshop on Friday in K116. I may be there and it may be just Max.
You need to read chapter #9 and #10.
Last assignment combined with final: You need to set up a project that deals with chapter #9 and chapter #10. I want you to deal with validation, multiple forms and accessing and writing data to a database. Send me your plan! Make it something you can proudly show a potential employer.
Due December 17th.
Send me a status sheet taken from this week of sheet telling me where you stand on the work.
Week #12
Week of November 19th
Start to read the next few chapters in preparation for next weeks assignment. This week I want you to continue experimenting with ASP.
Pick some things you would like to try with ASP and experiment with them. Include a list of the things you tried. Do some research and play with some of the things you find.
Week #11
November 12th
I am available for help and advisement this week on Tuesday after 2, on Wed at 10 and after 3 and Thursday after 2. Talk to me if you are staying late - I can not stay late Thursday but I can the other days. For advisement sign up on my door. If I get 10 people that committ to come on Friday the 16th, Max and I can put in an entire day of help like we did last Friday.
Max is available in the afternoon as well.
On Thursday during the first part of my 11:00 class and my 12:30 class, we have a guest speaker from Meditech coming in to talk about career opportunities with an emphasis on jobs in the programming area. You are welcome to come (K101).
The last major thing we are going to look at is using the web. I want you to start be reading chapter #8 and reviewing the web information that we covered in CIS156.
You also need to get a free Brinkster account if you do not already have one.
Put up one or more web pages that include a variety of the ASP.NET controls covered in chapter #8 (try 6 of them). You should make sure you are using effective forms.
Week #10
Week of November 5th
Continue with the information from chapter #6 and working on the tutorials I asked you to work with.
Please read chapter #7 on LINQ and SQL.
\ I have posted two experiments. Note that SQL Server was on my machine and available when I started to do these.
Please do some research on animation/graphics making things move in VB. I am posting an example I played with after doing some research myself.
Using a database that you have hopefully (one with multiple tables) apply the information in this chapter to doing a series of queries on the tables and updating the tables. If you do not have a database you can use then I am afraid you will have to create a simple one to use.
Create a simple moving graphic that using buttons you can move up, down, left and right, automate some of the movement and change one graphic to another on click.
Week #9
Week of October 29th
Chapter #6 has some very intense things. Read it carefully.
Because of the storm, I have a lot of people looking for help on Thursday, so... I have to spread out.
What I want you to do is pick a problem/problems similar to the ones done in the tutorials. I want you to go through the tutorials and essentially do what they do. So you should do something very similar but different topic and different info so you have to think as you replicate! Go through each of the tutorials in chapter #6. Pick two of them to make similiar models of to pass in.
Week #8
Week of October 22nd
Continue working on chapter #5 and the ways that you can maintain data in a database. Last semester we looked at writing your own code, now we are looking more at the way to make it happen within so please refer back to both my examples from last semester and to chapter #10 in the first semester text book.
Continue working on the assignment from last week and before. Catch up week!
Week #7
Week of October 15th
Please read chapter #5 and review the use of databases in CIS156.
I would like you to use SQL Server, let me know if there is a problem. A lot of the SQL was covered in CIS156.
I want you to create a database with multiple tables in third normal form and populate the tables. You can send me the layout for confirmation if you want to. I want you to be able to display information from multipe tables and also maintain the tables using SQL.
Week #6
Week of October 8th
I will be around late on Tuesday.
I have a doctors appointment on Thursday so I have to leave right after class. Sorry!
Read chapter #4 in the text and this section I want you to work with the wizard. Then I want you to go back to CIS156 and see how similiar things are accomplished using your own code. Then I would like you to experiment with SQL Server.
Look at two basic examples I put up and two sets of notes that I did as I wrote the code. Note my examples are in Access.
Start out by writing a simple program using a grid and then write a second simple one using separate text boxes (similiar to what I did in the examples noted above. Modify them so they use different SQL and send a form with the different SQL versions on them. The SQL you use should include different AND and OR combinations and definitely a condA and either condB or cond C. Try 5 different SQLs.
I would like you to experiment with both Access and SQL Server so you can try doing the same thing in each.
Week #5
Week of October 1st
This Thursday we will have catch-up day in K101 from 9:30 to 1:45. Come as much as you can if you have things to catch-up! Please take advantage, bring material and fill in the gaps. I will also be available for a while after 1:45 in my office K112 or in a lab. Monday I am available at 10 and Tuesday at 1:45 in K112.
This week as I told you I cannot meet at 3:15 on Thursday but I am around Thursday.
In addition to reading the part of chapter #3 that deals with LINQ, I would like you to also look at some Microsoft information on this:
I want you to also look at console applications in VB. There are some good tutorials and videos on youtube that you might look at.
Some other sources to look at: LINQ query
LINQ connect
First lets look at console applications. Look at the very basic program that I did called ConsoleApp2. I want you to write a program experimenting with setting things like color and size, if statements, looping etc. Go beyond what I did!
Please run through these tutorials and create your own program that creates the output that they create:
LINQ example 2008
LINQ example 2010
Week #4
Week of September 24th
This week I want you to read chapter #3 in the text. We will stay there for a while. Please look at the examples under Programs (2010). Under my programs for 2010 there is a program called EmpArrayList, please spend time making sure you follow what is going on.
I want you to write a program dealing with inventory (or another topic you choose) that processes in very similar ways to EmpArrayList. In other words, I want to make sure you understand how this program works and can create your own version.
Week #3
Week of September 17th
This unit is chapter #2 in the book. Please read it and spend time looking at the tutorials. They cover a variety of concepts very well. I have put two programs that deal with validation out on the web.
I can meet this Thursday at 3:15 - lets aim for where we ended up last week.
I would like you to do a program that deals with validation and I would like you to write a program on the idea of the Kayak program but dealing with what computer option a student should major in. So gather some information and offer some choices. You can pass in two programs or you can combine into one!
Week #2
Week of September 10th
There are four of you doing this course. It seems to me that an exchange of email addresses and possibly a study group would be a good plan. I plan to send your BCC email to each of you and you can take it from there.
Be sure you get the advanced book and read chapter #1. I strongly suggest playing with the tutorials they give you.
I have also put up a few examples. Note in one of my examples I should have handled the message differently in true OOP style. Note on EmpClassRev2010
Note that notes, slides and examples to accompany the text are available at:
Using the programs posted under Programs 2010, send me the answers to this quiz:
Quiz #1
Pick one of the coding challenges at the back of chapter #1 (other than problem #1), and write the program.
Week #1
Week of September 3rd
Please read the last chapter in the introductory book (chapter #12). It covers classes, collections and scrollable controls.
I will be posting examples as we go along and some SmartBoard as well, so please check.
Once you have the new book, please read the first chapter.
Good starting information from Microsoft.
We need to figure out a time to meet - we talked about Tuesdays at around 2:30 or 3:00 so lets try to work out a plan.
I do not know how comfortable you are with object oriented programming from other courses - please let me know.
First assignment: Write a program similiar to the one in chapter 12, tutorial 12-1. I want you to do yours on basic payroll. Have a idno, name, pay type code with an S for salaried or an H for hourly, also have a salary field, a pay per hour field and a hours worked field. Calculate hourly with overtime of 1.5 for those working over 40 hours. Use object oriented techniques.
Check back!


Send e-mail to Priscilla Grocer:

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