| 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 Week of April 22nd/April 29th |
You need to read chapter #9 and #10. Assignments: 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. I am asking for this by noon on August 15th, you can contact me if you need a little more time. |
| Week #12 Week of April 15th |
Start to read the next few chapters in preparation for next weeks assignment. This week I want you to continue experimenting with ASP. Assignments: 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 Week of April 8th |
If I get 10 people that committ to come on Friday the 12th, Max and I can put help time from 11:30 until 5ish. 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. Assignments: 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 #10Week of April 1st | 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. Assignments: 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 #9Week of March 25th | 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. Assignments: 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 #8 Week of March 11th |
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. Assignments: Continue working on the assignment from last week and before. Catch up week! |
| Week #7 Week of March 4th |
Friday I am hear all day for help. 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. Assignments: 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 February 25th |
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. PayRollADOnotes.doc PayRollADOnotesind.doc Assignments: 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 February 18th |
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: LINQ 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 Assignments: 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 February 11th |
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. Assignments: 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 February 4th |
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. Assignments: 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 January 28th |
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: Resources Assignments: 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 January 21st |
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. Assignments: 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! |