| 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! Note that if you get an assignment returned without a grade you should check and see what revisions need to be made. | |
| Final Exam | Read chapter #23 on LINQ. Your final will be to work with LINQ. Come up with a list of sample queries (10) that retrieve information different types of where statements. Reference some things you did in the Oracle class if you want ideas. Include linking two tables in one query. Your text shows to instances of using a form with embedded LINQ. You can think of this as the final. In fact I wanted to cover one more topic so since this is the last topic... If you run into problems, let me know and this can become a homework and I can give you something else to do - give it a try and let me know. |
| Week #14/#15 Week of April 29th/May 6th |
Thursday will be an open lab. Next week will also have open labs on
Monday, Tuesday and Thursday. Remember that Lindsey does not know Visual Basic. Thursday, May 2nd will be an open lab from 9:30 until 6. I will be there most of the time as will Lindsey. Monday, May 6th will have an open lab from 11:00 until 4:00 with me the first part and Lindsey after 2. Tuesday, May 7th will have an open lab from 9:30 until 3:00 with me. Thursday, May 9th will have an open lab from 9:30 until 6:00 with me there until 3:00 and Lindsey until 6:00. Dave will be available 4:00 until 9:00 on Tuesday, May 7th and Wednesday, May 8th. He will also be available Saturday 10:30 until 2:30 for the week of April 29th. Check back for the week of May 6th. I want you to read chapter #22 on XML and do a little research on XML. Assignments: Develop code to create XML and then to read it. |
| Week #13 Week of April 22nd |
Read some of the information on Object-oriented programming in section 4. Definitely read chapter 17 and 18. Object-Oriented Programs invench12.zip invClassFirst.zip invClassSecond2011.zip EmpClassV2010.zip EmpClassRevV2010.zip Assignments: Write a simple object oriented program similar to the examples I have posted. In it experiment with some things you want to try and send me what you did with an explanation. |
| Week #12 Week of April 15th |
Read chapter #16. It covers 1) connections and commands, 2) parameters and 3) commands. Assignments: I want you to experiment with something covered in each of the three catagories listed. Check back! |
| Week #11 Week of April 8th |
Finish up reading chapter #15 and move on to chapter #16. Assignments: I would love to have you try all of the topics in chapter #15 but that is pushing it. So... 1) Do something with bound text boxes and combo boxes 2) Do something with parameterized queries 3) Pick two other things that interest you in the chapter and do something with them 4) Extra credit if you try something else |
| Week #10 Week of April 1st |
Look at the SQL Server examples I posted last week and execute them on your setup. Assignments: Write three programs similar to mine using the database you created or mine. |
| Week #9 Week of March 25th |
Start moving on and reading chapter #15. Look at these examples of coding and retrieving records from a database. SQLServer examples Assignments: Referring back to chapter #14. Demonstrate one of the ways they show for handling errors. Extra Credit if you do two of them. Experiment with the dataset designer and the query builder. You can take pictures of the screens and explain them for this part of the assignment. Look at these examples of coding and retrieving records from a database. Check back! |
| Week #8 Week of March 18th |
Read chapter #13 and #14 on databases. Be sure you go over the database concepts in chapter #13 and then figure out how to create a SQLServer in VB. It is included with versions 2015 and beyond. Make and populate database on SQL Server You will also find some things on YouTube about making a database for VB using SQL Server. Assignments: The first part of chapter 14 goes into how to create a data source and how to use them. I would like you to start by creating and using your own. Note that you should also reference the text from CIS156. Check back! |
| Week #7 Week of March 4th |
Read chapter #12 and do a lot of experimenting. Assignments: I want you to experiment with the debugging techniques from chapter #12. You can either do a write up of what you tried and how it worked or you can do the exercises in chapter 12. |
| Week #6 Week of February 25th |
Read chapter #10 and #11. Assignments: Make a project similar to the project in chapter 10 but use payroll and weekly time card information. Be sure to incorporate the techniques used in chapter 10. Do exercise 11-1 in the text book murach's Visual Basic 2012/2015. |
| Week #5 Week of February 18th |
Read chapter #9 which deals with functions. Remember that Dave took this last semester and he does tutoring. He is available Tues and Wed 4 - 7 and Sat 10:30 - 2:30. Assignments: Explore the functions and do 5 date functions, 5 string functions and 5 number functions. In addition, do the flip name problem that we have done in other classes ones using substring and once using another function. Do some validating of data. Experiment with the String Builder class. |
| Week #4 Week of February 11th |
I want you to go over chapter 8 carefully and find other references to the information if something is not clear. Assignments: I want you to experiment with collections. lists, queues and stacks. Check back! |
| Week #3 Week of February 4th |
Read chapters 8 and 9. Hopefully all the things from CIS156 are coming back to you. I want you to go over chapter 8 carefully and find other references to the information if something is not clear. Assignments: I want you to set up and work with a jagged array and how to copy and resize a regular array. |
| Week #2 Week of January 28th |
Move on and read chapters 6 and 7. Sorry I do not know why this did not show up. Anyway it can be late! Assignments: I want you to write an program to validate a form with a variety of data. Include the different methods discussed in chapter 7. Include procedures and functions in the program. |
| Week #1 Week of January 21st |
We are using the new text book Murach's Visual Basic 2012 or the 2015 version. I am not totally happy with it so we will
do some supplementing! The chapters are a mixture of informtion we have covered and new information or at least information
that I believe needs another look, so we will start at the beginning and skim through the first few
chapters. To that end please skim/read the first 5 chapters. Under programs (VB2012 for Murach text) at my site you will see some examples (that go with the 2012 version) I did of things I thought needed to be looked at more closely. Please go over those programs carefully - they supplement the examples in the text. You should also go to www.murach.com and look for Visual Basic examples (The had them for 2012 and they have them for 2015). Assignments: Write a review assignment that includes: functions, two dimension array, parallel array with the key other than sequntial numbers, structures, multiple forms and modules. |