| Schedule by week | Information to cover Please note that the first assignment is at the bottom of the list posted here. You should do the work in order! |
|---|---|
| Notes and assignments #14 | We will talk a little more about files/databases/processing and we will talk some
more about JavaScript and a little about menus and interactive processing if we get to it (if
not, it is covered in your text book). Please look at the presentations on validating/editing data, sequential updating and random updating. Contact me when you are ready for the final - you have one week to do it! Assignments: Donor database assignment Sequential processing exercise in class students will do this exercise in class - everyone must pass in the assignment ( Random processing exercise Let me know when you are ready for the final! You can have one week to work on it. I added a quiz to week #6 (shown below). I would like you to take it because I am experimenting with on line quizzes. I will give you extra credit on the final exam if you take the quiz. Thanks! If quiz |
| Notes and assignments #13 | Please read chapter #11 and chapter #16 in Programming Logic and Design. We
will talk about databases, files, menus etc. We will also start to look at JavaScript which presents a third way to program (we have already looked at COBOL and Visual Basic). I suggest that you look at the PowerPoint presentation on JavaScript and the sample code that I have put up on the web under programs. Assignments: JavaScript assignment |
| Notes and assignments #12 | We will continue with arrays including looking at searches in Visual Basic. Chapter #9 is in Programming Logic and Design is optional. Please read chapter #10 and start reading chapter #11. Please look at the sample VB under programs. Look especially at the random guess program, the indirect search and the two dimentsional array. After we finish arrays, we will talk about databases with multiple tables and files including sequential and random. You should read chapter #16 about relational databases. We will continue with this next week (including the assignments). Assignments: Following the directions in these assignments, set up the tables and populate them with data: Student database to develop Payroll database to develop |
| Notes and assignments #11 | You should browse around in
chapters #6, #7, #8, #9 in Absolute Beginner's Guide to Programming
looking for help with Visual Basic. We will be doing some more with Visual
Basic and if statements and arrays. If you are having problems with this please set up time with Marissa or myself. Assignments: Multiple Break Assignment VB if and array |
| Notes and assignments #10 | We will continue the discussion of breaks and start looking at Visual Basic. Next
we will deal with arrays which is chapter #8. The version of VB we are using for this course is VB 6.0 (although you can use VB.NET if you want to). Students who cannot get to the lab, can contact me about getting a version of VB.NET. The other option for Distance Learning students is to work with regular Basic. I went on the web and found a free version of Basic (not Visual Basic) then can be downloaded. The address is: BBC Basic I really want the distance learning students to work with some version of Basic and try to solve the problems I put on the web. I would prefer VB6 or VB.NET, but I can live with regular Basic. You should also look at the first two introduction to VB presentations - if you get interested, you can look at the others as well. Assignments: A lot of people have not passed in this assignment yet Logic Assignment Minor Break Assignment VB Assignment Note: If you absolutely cannot get to campus to use VB, then you will have to do it with regular basic and use the version mentioned above. |
| Notes and assignments #9 | This week we will focus on chapter #7 in Programming Logic and Design. At the end of the week
you should start looking at chapter #8. You should also start reading chapter #4 and #5 (continue
next week) in Absolute Beginner's Guide. Assignments: COBOL totals |
| Notes and assignments #8 | Please read chapter #7 in Programming Logic and Design. We are going to continue with the COBOL that we started to work last week. People are having trouble with the logic of some of these problems so I want you to do the flowchart and pseudocode for the 8 problems in the COBOL if. Assignments: flowcharts for COBOL IF assignment Computer Code Quiz |
| Notes and assignments #7 | Please read chapter #6 in Programming Logic and Design (I assigned it last week)
We will continue to look at binary numbering systems and computer codes this week
(chapter #3 in Absolute Beginner's Guide). I have put out the examples I captured in class plus some additional examples under the Smartboard notes. You should find these helpful in doing the homework. We are working with COBOL this week, be sure to look at the information on COBOL posted at the site - especially the PowerPoint presentations, but also under notes and handouts, examples and SmartBoard. If you are on campus, you can do COBOL in K101 or contact the help desk for other locations. The COBOL assignments can also be done on paper so you do not have to use the lab. Assignments: Quiz on numbering systems COBOL IF assignment |
| Notes and assignments #6 | Please be sure you are caught up with the reading and that you have looked at
all of the examples and tried to figure out the logic in the logic examples from
last week. I also want you to read chapter #6 which deals with looping. While you are working on the logic assignments for this week, I am going to follow up on the numbering systems and computer codes discussed in the Absolute Beginner's Guide. You will find a handout on this topic at Numbering systems and codes A site that provides useful related information is How Stuff Works - binary Assignments: Logic problems This is a challenge assignment - you can work on it alone or with friends. It will be checked off with a check, check minus, check plus or no grade - I am looking for a sincere effort! Logic assignment (due in 2 weeks) If quiz |
| Notes and assignments #5 | Please read chapter #5 in Programming Logic and Design and chapter #3
in Absolute Beginner's Guide. We did not get as far as I wanted to last week, we will continue looking at logic examples this week. Be sure you look at the PowerPoint presentations on logic - especially the one that says it will help with the quiz - it will help with the logic quiz. You should also be looking at the SmartBoard presentations. Practice exercise: Practice exercise Note that answers are posted as a SmartBoard presentation under the topic Answers (Fall 2004) - not to be passed in for a grade In class exercise - distance learning students should try the problems and then look at the solutions posted at the Smartboard notes last spring and this fall. Another in class exercise: In class logic exercise Assignments: Logic quiz (html format) the quiz is best viewed with Explorer Logic quiz (word format) Quiz #4 (html format) Quiz #4 (word format) Check back to see how we are doing! |
| Notes and assignments #4 | You should read chapter #4 in Programming Logic and Design and chapter #2 in
Absolute Beginner's Guide. We will focus on chapter #3 and #4 this week. Read the notes on LOGO and look at the PowerPoint presentation. Look at the first three presentations under Programming - examples mainly with COBOL. Be sure you have also looked at the first two presentations under logic including Pseudocode and flowcharts that have previously been assigned. You will also find information under the Smartboard presentations. Assignments: Please remember that the quizzes are individual projects and you cannot work on them with anyone else. Quiz #3 (html format) Quiz #3 (word format) Logo assignment |
| Notes and assignments #3 | We are going to focus on chapter #2 this week and hopefully start looking at the material in Chapter #3 so
you should read that as well (Programming Logic and Design). You should also read chapter #1
in Absolute Beginner's Guide. We are going to start to look at StarLogo. You will find a presentation under presentations and you will find a list of StarLogo commands under notes. If you do not want to work in the labs, you will need to download and install a version of StarLogo which is available at: StarLogo On campus, StarLogo is available in K130 and in K101. I believe it is available in some other labs as well. Assignments: Logic assignment will be worked on in class for in class students - required for all students. In this assignment, you should play computer and step through the logic and create the report as you go. This assignment should NOT be done using Access. I would suggest you write the answers in word. Access Design and SQL Project (due in two weeks) Makeup for quiz grades:If you want to improve your grade on quiz #1 you may do the exercises at the end of chapter #1 in the |
| Notes and assignments #2 | Please read chapter #2 in Programming Logic and Design. We will continue chapter #1 and start chapter #2 this week. Note that I have put out SmartBoard notes for week #1. In the lab, you will continue to work with Access. Please be sure to look at the PowerPoint presentation on Access and IF statements prior to the lab. Assignments: For your own benefit (not to pass in): Make sure you could do the exercises at the back of the chapters. Quiz #2 (html format) Quiz #2 (word format) Access IF Assignment We will start this in class. Please Note As a general rule, if you see what is pretty obviously a careless mistake by me, feel free to fix it - just tell me you fixed it, in case it was not a mistake but a problem I wanted you to solve! Extra Credit:If you write the SQL for these queries, I will give you extra credit. You should write them yourself, eliminating the extra parenthesis and the extra table names etc. An SQL presentation is available under presentations. |
| Notes and assignments #1 | The topics will be posted as 14 sets of notes and assignments. You need to plan your schedule
to cover all 14 sets. The summer is not 14 weeks, so plan accordingly. Please read chapter #1 in Programming Logic and Design. If you are not comfortable creating a table in an Access database and then creating a simple query, you should see the Power Point presentation on Assignment #1 / Access which is under Presentations. You should also down load the Assignment #1 Access database which is under Examples - Access database for asgn1. There are several Access tutorials available on the Web site: Links to Access If you do not know the basics of Access you can also see me and I will try to locate a book on the topic for you to use. I posted some notes on using Access under Notes and Handouts but most of them are more than you need to know right now. Note: Some assignments require software. If you are a distance learning student you have to make arrangements to access the software needed. If distance learning students are having problems with software, they should contact me so we can try to work out a plan. For students that come to the BCC campus, all software is available in labs. Note that I have put out SmartBoard notes from semesters when this course was taught in class. I will be adding new SmartBoard notes for the Spring semester. You should access the Smartboard notes from previous semesters even though you are taking the class via Distance Learning. I have also put out a new presentation on Data on files and tables that will help with Quiz #1. Assignments: Note: Assignments are not due until the week after they are assigned. You are welcome to pass them in early. For your own benefit (not to pass in): Exercises at the back of the chapter. Chapter #1 assignment Note that quizzes are due the first day of the week after they are assigned. Quiz #1 (html format) Quiz #1 (word format) |