| Week | Information Assignments due in one week unless otherwise stated. Please note that I am not going to stay with the text - it moves to slow at the beginning and I want to cover more of the fundamentals quickly to give you more flexibility when you write your programs. However, the text is important because it will fill in some information that I may not emphasize. I want you to read the text chapter by chapter and I also want you to use it as a reference. If you are having problems with a concept, look it up in the text. |
|---|---|
| Week #1 Week of January 27th |
Read chapter #1 and chapter #2 in the text. View the presentations on introduction, settings and pay examples (including PFirst98). Note that if you go to the PowerPoint presentations part of this web site you will find separate speaker notes available. Starting in Visual Basic Introduction to Visual Basic Settings in VB Pay examples (projpay)- basic calculations PFirst98 which includes basic pay Look at the programs under Demo, ArithFst, FirstDay, Calculate, Pay #1, Pay #2 and First98. Sample programs where the programs you should look at are located Notice that the programs can be downloaded or simply viewed through the html listing. Assignments: Assignment #1 Please send me all things ready to run on the root of the A drive - I am running into directory problems and I think that is the best solution. That means after all is working, save to the A drive and test there. Send me that working model and I too will test off the A drive!!!! |
| Week #2 Week of February 3rd |
Once again I'm issuing you an assignment to help you become more comfortable
with Visual Basic. I first ask you to continue reading your text. I would like you to read through Chapters 3 and 4. The reason we seem to be moving at a fast rate with regard to the reading is that in order to start writing programs that resemble something, we need a concession of both tools and supplies. Chapters 2 through 4 will give you the resources you need to start writing simple applications that make some sense. I will lecture on those chapters through February 10th inclusively, going back and forth through the chapters to help you become comfortable with the subject matter. Assignments: Assignment #2 |
| Week #3 Week of February 10th |
NOTICE: DUE TO THE HOLIDAY ON MONDAY THE 17th, OUR CLASS WILL BE MEETING ON
TUEDAY EVENING THE 18th. In this way you will not lose additional class time. First, I caution all of you to have finished reading chapters 1 through 4. The first two weeks of the course have been geared more to familiarizing you with visual basic and getting you acquainted with the concepts of controls and properties and some coding. Now, we will take a more serious approach to the language where we can start developing programs that make a little more sense. This week I will be talking about the following features. (1) Reiterating variables, module and local, declarations and the concept of running totals (2) If conditionals and, as some asked for last week, I will use a couple of flowcharts (3) The picture box control using the print method and the tab function (4) The message box (5) I will introduce the date variable type and Date function (6) If time permits, I'll show you the Switch conditional. If not, it will wait for another meeting NOTE: I will be using the check box example I wrote and sent to all you, for demonstration. When we meet, on the 18th, I will talk about Procedures and Sub Functions and, will skip chapter 6 for now, and introduce to you chapter 7 - Looping. We'll look at Multi-forms (chapt.6) later. READING: I want you to read chapter 5, pages 187 through the program example ending at the top of page 205. I also want you to read the short caption on Input boxes on pages 434 - 435. For the time being, skip the beginning of chapter 5 on Menus and the common dialog box control. I will get back to menus later. I'm not interested in the common dialog box for this course but you are welcome to learn about it and use it on your own, if you have a mind to. I am also not interested in the EXE file at this point. We will look at it later on as/if time permits. Assignments: Assignment and Quiz notification |
| Week #4 Week of February 17th |
Due to the class cancellation of February 10th, we actually fell behind on an
entire week's worth of material. Because of this, there is a great deal to be
looked at in order to do some catching up.Reminder: We meet on Tuesday this
week. You are to take the quiz you will find posted along with this assignment notice. Note, that you have been given an extra day to hand in the quiz, because of the cancellation and, as a result, there are topics I didn't cover due to this. I would like you to conclude reading chapter 5 and I would like you to read chapter 7. Because of the backlog of information, there will be only the quiz this week and you are to continue working on assignment 3. No programming assignment this week. This Tuesday, I will be: (1) Quickly reiterating variables, module and local, declarations and the concept of running totals and Constant variables (2) Quickly going over the picture box, the print method and the tab & space function (3) Quickly explain the date function and date variable type and the message box (though most of you have shown me you already know the message box) (4) Go into if statements using flowcharts in the demonstration (5) Introducing you to sub procedures and functions (chapter 5) (6) I will also touch upon run-time, syntax and logic errors. REMEMBER YOU MUST USE WORD TO TAKE THE QUIZ. Assignments: Quiz |
| Week #5 Week of February 24th |
Plan for getting caught up! Please be sure to read! Please look at the information on the sample IF program |
| Week #6 Week of March 3rd |
Reminder: Quiz is due by 10:00 PM, Monday, March 3rd. Assignments: Information and assignment for this week |
| Week #7 Week of March 10th |
For this week, your assignment is to finish reading chapter 7 and read chapter 8
in your text. This coming Monday, I will Finish Procedures and Functions and will present new programs I've put together to demonstrate Procedures, Functions and For Next Loops. Last Monday I mentioned to you that I would let you know about our having class on March 17th. In fact, we are going to have class on Monday, March 17th. I have been and am spending this weekend grading quizzes, and, if time allows some assignments. I will not return the quizzes and grades until all are graded. I would STRONGLY urge you to actually do the hands-on examples at the end of your chapters on your computers, following closely what the authors are doing. The chapters you should do this with, up to this point are: 5, 7 and 8. This should help your understanding. There will be no program assigned this week but next week I will assign a program, which will be more involved than those you've had so far. So, please be sure to read. The program will include some chapter 8 on arrays. Be sure to e-mail me, if there are things in the assigned reading you don't understand, especially after trying the hands-on examples. If anyone is having difficulty and you need special tutoring, please speak with me, and we can talk about making an appointment to meet and work on those things you are having difficulty with as a one-on-one at the school. |
| Week #8 Week of March 17th |
At this time, you should be reading Chapter 8. I will begin to cover arrays in
our next class. REMINDER: WE WILL BE HAVING CLASS MONDAY NIGHT, MARCH 17 TO MAKE UP FOR ONE OF THE NIGHTS WE'VE LOST DUE TO THE INCLEMENT WEATHER. Assignments: Information and assignment on arrays |
| Week #9 Week of March 24th |
Read chapter #6 on multiforms. QUIZ ALERT!!!!! I will ask Mrs. Grocer to post your next quiz on the weekend of April 5-6. This quiz will incorporate chapters 1 through 8 inclusively. Know that this quiz will be programmic, where you will have to correct, explain and possibly add to a program I will have written, with the possibility of a few essay type questions. Please be prepared, by making sure you have read the chapters and understand what they're about. Assignments: Information and assignment - #6 |
| Week #10 Week of March 31st |
This weeks class will cover multi-forms and using Lower boundaries and
Upper boundaries when referencing array elements. Other topics might be touched
on, if time allows. One such topic will be that of drop-down menus which is
covered in chapter 5 of your text. To get ahead on the reading, when you have a chance, begin reading chapter 10 on Data Files. Next week's class will cover topics I have not yet touched on with you. This will include the concept of dynamic arrays. This concept is not contained in your text but, since it is supported in VB 6, you should know what it is about as well as the concept of Option Base 1. Then if time allows, we will begin looking at sequential files. Otherwise we will start files on April 14th. Remember also, that next weekend you will be issued your next Quiz. This quiz will also allow me to gauge your understanding of what we've done so far. As mentioned last week, it will have to do with a program or two. You will have to document and explain a pre-written program's code. There is a possibility that you may have to correct errors in the program as well. This has not been decided as yet. In light of this, I would strongly suggest that of the above options, you at least do the B+ or A+ options. These will best serve to prepare you for the quiz. Any and all things covered up to this point, either in class or the text is fair game for the quiz to include. As usual, direct any questions you may have to me and I will try to get to them A.S.A.P. Assignments: Information and assignment - #7 |
| Week #11 Week of April 7th |
Each of you has or will be receiving two e-mails from me. Each e-mail, will
contain an option of quiz #2. You are to choose either of the two options
to complete and e-mail back to me no later than 10:00 P.M., Monday, April 21,
2003. With each option there is a word document, in which you will find the instructions for each option respectively. You are to refer any and all questions to myself. Tomorrow night I will be going over the "instring" function, the concept of dynamic arrays, drop-down menus, and the RND function. Next week I plan on beginning files. Be sure to have read chapter 10 by then. After completing our look at sequential and random files, we will be looking at the ADO control along with database processing using ACCESS 2000 and some simple SQL. If you want to get ahead on some reading, begin reading Chapter 11 on database files. Assignments: The programs to accompany the quizzes have been posted. Quiz 2, option 1 Quiz 2, option 2 |
| Week #12 Week of April 14th |
For the remainder of the semester, read chapters 9, 11 and 12. We will now be working with files, Access and some simple SQL in VB. If you haven't had any experience with Access, you should start to acquaint yourself with simple database creation. I will go over it next week, but it would help you if you already had an idea of what I'm talking about. Assignments: Information and assignment - #8 |
| Week #13 Week of April 21st |
Be sure to read chapters 11 and 12. REMEMBER THIS WEEK WE WILL MEET ON THURSDAY THE 24th INSTEAD OF MONDAY THE 21st. This week I plan to cover chapter 11 and begin chapter 12 and I will include a brief introduction to ACCESS. Essentially going over what you need to know to create a simple database to satisfy what we will need for the above two chapters. Chapter 11 is a relatively easy chapter. Chapter 12 is also easy, but will need a little more coverage. In the two weeks following I will complete chapter 12 and give you an intro to using SQL in VB. You will need some SQL to complete the final. Next weekend you will be assigned the first part of your final, your final project. The following week, I will give you a list of questions from which you will be required to answer 2 or three of them. The final project will, include at least two programming options, from which you will be able to choose. The focus of the final project will be on chapters 11, 12 and the SQL example(s) I will upload to you and/or explain in class. You will not be able to do all final in the first week after it is issued but you will be able to begin and build on it as we go along. The project part of the final will count for 85% of the final exam grade and the questions for 15%. (NOTE THAT SHOULD ANY CHANGES OCCUR REGARDING ANYTHING ON THIS DOCUMENT, YOU WILL BE NOTIFIED.) |
| Week #14 Week of April 28th |
This assignment/project will count for 85% of your final exam grade. It is comprised of 5 parts. All parts are required! The first four parts are programmic and are being assigned at this time. The fifth part will be assigned next weekend. This, the fifth part, will be a series of up to 10 questions of which you will be required to select and answer any 4. Its point value will be the remaining 15% of the final exam grade. For part 3 of this exam you need to read chapter 15, pages 613 through 621 but only after you have read chapter 12. These pages tell you how to create a report in Visual Basic, a stem-off of the data environment designer, which is explained in chapter 12. IMPORTANT!!!!!!! NOTE WELL THAT IF YOU ARE USING THE TEXT BOOK'S WORKING MODEL OF VB, YOU WILL NOT BE ABLE TO USE THE REPORT DESIGNER. PLEASE KNOW THAT PART III, WHICH REQUIRES A REPORT, CAN BE DONE AT THE SCHOOL IF NECESSARY, AS THE LAB CARRIES A VERSION OF VB THAT SUPPORTS THE REPORT DESIGNER; THE BOOK'S WORKING MODEL DOES NOT CARRY THE REPORT DESIGNER. This exam is due by 10:00 P.M., Friday May 16, 2003 and no later. This will give me enough time to grade everything and submit the final grades by the due date and time of May 21st at 4:00 P.M. and send you your results. I remind you all that all questions must be directed to myself. DO NOT WAIT UNTIL THE 11TH HOUR TO ASK QUESTIONS. Assignments: Final exam information |
| Week #15 Week of May 5th |
Part 5 of the final exam has been posted. Final Exam Part 5 |