| 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! | |
| Unit #13#14 | You need to read chapter #9 and #10. Assignments: 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. |
| Unit #12 | I want you to look at the things we did with the web last semester and I want you to read chapter #8, #9, #10. 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). I also want You should make sure you are using effective forms. |
| Unit #11 | The last major thing we are going to look at is using the web. I want you to start by reading chapter #8 and by reviewing
the web information that we covered in CIS156. Check back! Assignments: Write an example that shows your understanding of LINQ and SQL. I want you to show the ability to select and to update. |
| Unit #10 | 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. Assignments: Using a database that you have (one with multiple tables) apply the information in this chapter to doing a series of queries on the tables and updating the tables. |
| Unit #9 | Please send me an email and tell me how you are doing. Chapter #6 has some very intense things. Read it carefully. Assignments: 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. Questions, let me know! |
| Unit #8 | 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 unit. Catch up unit! Also get started on next weeks assignment. |
| Unit #7 | This is the half way point in units, please keep scheduling in mind. This unit will focus on chapter #5 so please read it.
Your book is using SQL Server and I Access, your call. Check back for examples, I have been sick so they are going up
slowly. Assignments: I want you to create a database with multiple tables in third normal form and populate the table. 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. |
| Unit #6 | 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. Note that I am using Access, not SQL Server. Look at two basic examples I put up and two sets of notes that I did as I wrote the code. 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. Check back! |
| Unit #5 | 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 |
| Unit #4 | This unit 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. |
| Unit #3 | 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! |
| Unit #2 | 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. |
| Unit #1 | During the summer I post 15 units that compare to the 15 weeks during the fall or spring semesters. You are responsible
for all 15 units so you have to figure out how you are going to work them in. I will post several early in the summer
semester to give you flexibility. 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. The intro book was mainly a filler until you got the new one. 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! |