|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 I am going to cover file handling sooner. Check the schedule several times a week, I may add some things during the week. Also please note that Notes and assignments #1 is at the bottom.
Week of May 8th
|May 9th is an open lab day for help from 9:00 to 3:00 in K101.
Please remember that the homework assignments make up most of your grade - you need to get them to me!
Your final exam is scheduled for 12:30 on May 15th in K101. You can either email me the final prior to 12:30 on May 15th or you can come to the final and take or complete it. I do not recommend planning to do the entire final in the 2 scheduled hours. The final is given on the honor system - I trust you to only discuss it with me!
Required status sheet: Status sheet
Final Exam: Final exam (html version)
Final exam (word version)
If you have requested an incomplete, you must still take the final unless we have discussed it and you have prior approval.
Week of May 1st
|Be sure you have read the material on ADO (chapters #10 and #11).
I will be out on Tuesday, on Thursday we will look at ADO and then give you a chance to work on assignments. Tuesday, May 9th is an open lab day all day in K101. Your final is scheduled for May 15th, it will be posted one week ahead of time.
No new assignments this week!
Week of April 24th
|Advisement Question: Several students have had difficulty finding the course they wanted if it is a Student
Option Enrollment Course. You should look under distance learning in the course catalog - the course is not
listed under regular classes. Confusing - YES!!!|
Note that CIS67 is being offered at night and since I will not be teaching it, it is not Student Option or Distance Learning. If you need to take the course through Distance Learning, you need to sign up for it under the CIS91 umbrella that I teach. If you need the course during the day and want some support time rather than strictly distance learning, we can set up a time to get together regularly and/or we can use interactive video conferencing! Please get in touch if you want to discuss your options.
We will continue working with ADO - please look at the examples and Powerpoints. Assignments:
I would like you to write two programs (both need connection code):
First: A program that will bring up the user specified record from the database.
Second: A program that will let you add, change and delete records on a database.
Week of April 17th
|We are going to continue on with ADO. You can start looking at some of my examples or you can wait
until I go over them in class.
I would like you to write three programs using ADO:
First: A program that uses two tables in a 1 to many relationship with the data from the one table displayed in text fields and the data from the many table displayed on a grid. You need to move through the data from the one table and bring up the matching records from the many table.
Second: A program with two grids and the ability to select a record from one grid and match to records on the second grid. Each grid should have data from a table.
Third: A program that uses an SQL that brings together data from three tables (correctly related), and displays the data in a grid.
Week of April 10th
|Advisement: Advisement information
On line advisement is available through email or IM. You can also make an appointment for advisement on my door. More dates will be added on my door.
Well, after an interesting start on ADO, I was out sick on Thursday, so we will essentially restart ADO this week!
You need to follow my PowerPoint and or examples and set up a program to read from a database of your choice. The code should be embedded in the program so that I do not have to change anything to execute on my computer.
Week of April 3rd
|Please be sure you have read chapter #9 and #10.
This week we are going to start looking at ADO. In class, we will experiment so be sure you have an Access database available that you can experiment with.
I want you to do the charge account validation problem at the back of chapter #8 (page 539). However I want you to establish the array to hold the numbers without specifying how many elements will be entered into the array. Then have the user determine how many charge accounts are going to be entered in the array. Once the number has been determined, the user should enter the appropriate charge numbers into the array.
You should have the user enter at least 8 numbers into the array.
Week of March 27th
|Open Lab:On Tuesday, March 28th, I am going to hold open labs in all my classes in K101. I will be there
from 9:00 until 2:00 (11:00 has been requested, if I am not there at 11:00 I will
be in my office or the general lab - but hopefully I will be in K101). You may come
during your regular class time or at any time during the period for help. If you are
behind, you should make every effort to at least drop in and touch bases with me.
Please read chapter #9 and next week please read chapter #10.
This week we will talk about printing a report and then we will spend some time reviewing Access. Next week, we will start looking at connections to Access through Visual Basic.
I am going over the basics of Access this week. If you have not had a course that has included Access, I suggest that you look at the introductory material under CIS17.
Array Assignment using structures and redim (see clarification of print report in the assignment)
Week of March 20th
|On Tuesday, I am going to have a review, question and answer, back to basics kind of review session
for those who are behind. Next week Tuesday will be another review/lab. I will cover no new material
either time. I can also stay late. Let's try to get caught up folks!
This week (Thursday) we will continue looking at arrays. Check back to see how we are doing!
Right before vacation,I went over the Bubble sort in class and we looked at an example of the Bubble Sort. I also went over the logic behind the Top Down Sort. To help you understand the structure of these sort alogrithms. Please review this information. I used the following presentations:
Separate speaker notes to accompany topdown sort
Separate speaker notes to accompany bubble sort
Modify my Bubble Sort program so that it does a Top Down sort.
Week of March 13th
|Catch up week for all of us...hopefully!|
Week of March 6th
|I had a real sick headache in class last Thursday when we were dealing with menus and forms and I
Know that there were some points I did not make very well. I am sorry, but... Anyway, please
ask if you have any problems and lets make sure you followed what I went over. We can do some
review on Tuesday.|
Please read chapter #7 this week and chapter #8 over break. Look at the examples and the PowerPoints dealing with multiple forms and menus and be sure to look at the more complex examples in the text. It is a good text in my opinion so I highly recommend doing the reading!
This week we will start to look at arrays.
In class exercise (not to be passed in): Menu/Forms
VB Function assignment
Second assignment: I also want you to experiment with forms and passing data from one form to another. You can include that in the VB Function assignment (my first choice) or you can do a separate assignment.
Week of February 27th
|We will focus on chapter #6 this week. If you want to read ahead, chapter #7 is
Finish looking at the PowerPoints and examples for loops, combo boxes, validation etc. and start looking at the Presentation and examples for procedures and functions as well as multiple forms and menus.
I made a mistake - the editing/validating for ABC etc. should be done in the first program not the second. You should be editing before you write the file.
Week of February 20th
|Read chapter #6 in the text.
We will actually look at things from chapter #5 this week and probably will not get to chapter #6 until next week.
I am going to a conference and will have to leave campus on Thursday so we will only have class for the first hour. It would be a great idea for those in class to stay on and help each other if possible.
I have sent an invitation to access a CIS56 blog - I sent it to your BCC web address. Please accept the invitation. The first thing I have posted is a question by a member of the class about online study partners.
Week of February 13th
|Read chapter #5 in the text. We started looking at loops last week and we will continue
this week. Be sure you have looked at the PowerPoint presentations and examples.
We are going to continue looking at both conditons and loops. On Tuesday we will continue with the discussion of loops.
I want you to modify the quess the number program so that the user only gets a certain number of chances (let's say 5). When they have used all of their chances an appropriate message should display and the Play button should become visible.
Rock, Paper, Scissors Assignment
Week of February 6th
|Read chapter #4 in the text. We will continue looking at conditions and we will also look at
creating and reading sequential files (note that this is not covered in the assigned reading but
you can find it in the text).
Look at the examples and presentations on conditions and files. We may start looking at loops.
Last week I had problems with recordings in this class. One day I do not know what happened, the other day the recorder filled because I had recorded too much during the day. Hopefully I can figure out how to save more on the recorder.
We will look at #5 and #9 in class.
Insurance form and file
Week of January 30th
|Read chapter #3 in the text. This week are starting to look at conditions.
Please look at the three Powerpoints having to do with IF and the samples
of if statements. Remember there are sample programs available to illustrate
If you want copies of the programs to run as I am running or copies of the code to look at in class, please download and print before class.
I will be available in K101 from 3:00 to 5:00 on Thursday, February 2, 2006 for help with any of the courses I teach. If there is no one there for help, I will go back to my office in K112, so come and get me! This is your time to make sure you are staying on track, so take advantage of it - please! For other times that I am available, please check Help Lab
IF assignment in class students will have the opportunity to start this program in class.
Week of January 23rd
|Read chapter #1 and chapter #2 in the text.
You should be looking at the beginning examples and programs and the beginning PowerPoints. This course uses VB.NET. There is a version available through the college. For information about software for this course: MSDN Alliance Software