The information at this site is in draft form and is the property of Priscilla Grocer. The information may not be duplicated or distributed without her permission. ©Copyright 2000
| Category | Information |
|---|---|
| Syllabus | Syllabus for CIS56 |
| Resources | Notes and handouts for CIS56 PowerPoint Presentations Chat Room Board Room Sample programs for CIS56 |
| Work | Programs for CIS56 Assignments for CIS56 Test information for CIS56 |
| Visual Basic Links | Links to Visual Basic for CIS56 |
| Notes and handouts | Link to retrieve |
|---|---|
| BCC lab handout | BCC Lab instructions to log in and use
software |
| Logic notes |
Notes on breaks Notes on top down sort Notes on bubble sort |
| Notes on Access |
Intro to Access Introduction to VB Access Continuation of VB Access Introduction If statements in VB Access More on IF with nesting Loops in VBAccess Call and pass in VBAccess Notes on ADO Data Controls |
| Notes on SQL |
SQL from Access Generic notes on SQL |
| Presentations | Link to retrieve |
|---|---|
| Break processing |
Minor Break Processing PowerPoint Presentation |
| Assignments | Link to retrieve |
|---|---|
| Text | Read chapters #1, #2, #3 - look ahead and read about IF statements and For statements
in chapter #5 and #6 - honest, we will cover #4 and the rest of the information in #5 and
#6 Now read chapter #4 and then we will move into a complete coverage of chapters #5 and #6. Read chapter #5 and #6 for the week of Feb 21st. Read chapter #7 on arrays. Read chapters #8 and #9 on files. Read information on Access from a book, the Web etc. Read the posted notes on programming in Access using VB. I am skipping chapter #10 and #11 for now - I will definately get back to #11 - we may not make it back to #10. Read chapter #12 on databases. |
| Programs to write | Link to retrieve |
|---|---|
| Assignments |
assign1.html Try Visual Basic assign2.html Experiment with 20 things Assignment to flip a name using functions Assignment using if, case and do Writing a top down sort Extra credit: Modify the days of the week program to handle dates in 2000. Array assignment VB in Access Assignment Access from VB assignment - (NOTE: Revised from the original posting - Sorry, I made a mistake and copied an old problem that I meant to revise - extra credit if you already did the original posting of problem #3) - Note also this is not officially assigned until after the class on Tuesday and there is some helpful information coming. I didn't complete everything on Thursday. If you want to do it now, see the handout on ADO under Access Notes. It gives step by step instructions. Explain the following program - be specific and explain the commands. PrMovie.vbp frmMovie.frm I will be in Saturday from 10:00 until around 4:00 to help with assignment problems. Excel Assignment |
| Projects |
VBfstproj00.html Visual Basic Project #1 Pay Project - Project #2 |
| Test Information | Link to retrieve |
|---|---|
| Quiz on Chapter #3 | quizch3.html |
| Final Exam | If you are caught up, you may take the final exam alternative that is posted here. Note, the database
you need to use will be available on Monday, May 8th in K-205. Be sure to check the exam to determine your
eligibility to take this alternative. Final exam alternative Status sheet for CIS56 The status sheet must be turned in with the final! I have enoyed the class and appreciate the work you have done! |
| Resources and sites on the Web | Link to retrieve |
|---|---|
| Visual Basic Pages |
Carl and Gary's Visual Basic Home Page On-line VB Magazine Lots of information on Visual Basic Another site with lots of information and tutorials Tutorial on databases and VB |