| 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! |
|---|---|
| Questions/Help Available | I will be on campus on Friday the 6th and available for questions. Come to K112. |
| Week #15 Week of December 12th |
Spencer Fry from Yale will be speaking on Tuesday at 11:00. He is still in college,
but has started several businesses and has worked in the game area. He is making the
trip because Mike Vieira asked him to come and speak and I would really like to have
a good turnout to reward him for his effort. I will even give extra credit to anyone
that comes and sends me an email giving their thoughts on the subjects he discusses.
The talk will be held in H210. I will be available for help on Tuesday at 2:00, Thursday at 12:00 (CIS50 has priority, 2:00 (CIS44 has priority), Friday from 9:00 to 11:00 (CIS17 has priority), 12:00 (CIS50 has priority) and 1:00 until 3:00. Help sessions will be in K101. If there is a problem with the room booking at any point, I will be available in K130 or you can find me in my office. Continue with the reading assigned last week. I want you to look at this PowerPoint presentation on Alice: Using Alice Zipped version of Using Alice for download Then I want you to spend time with Alice experimenting with the different things that you can do and looking at the other tutorials etc. Alice can be downloaded from: Alice to download Assignments: Using my Alice presentation as a guide, I want you to create something in Alice. You should have multiple objects (minimum 3). Your Alice code should have a sequence of 10 different methods or things that one of your objects does. Required status sheet: Status sheet - must be turned in by the end of the semester can turn it in early to have me check your status! The final exam may be emailed me prior to the start of the final or you need to come to the scheduled final to take the exam. Please email me at both my usual email and at pgrocer@comcast.net. Final exam (PowerPoint version) Final exam (Word version) |
| Week #14 Week of December 5th |
I can be available for help Tuesday from 2:00 to 3:30 - if K101 is free, we
can meet there or we can go to the lab in K130 and I can help there. Will people that listen to the lectures let me know if they can receive them alright on a MP3 player and for that matter an ipod. I receive fine on my MP3 player, but I am not sure the WMA format works on them all! Checking to see if WMA can "podcast". NOTE: I made a mistake doing the retail flowchart (told you I would not make it through the whole class without at least one mistake and I was right!) Anyway on the flowchart, when I tested ct, I should have written < 5 then process - I wrote the reverse. I wrote what it had to be to get out of the loop! Sorry! It is fixed on the presentation. We started looking at JavaScript on Friday and we will continue this week. We will also look at the solutions to the challenge problems and the retail logic problem. Please read chapter #12, #13 and #14 lightly. I am looking for a basic introduction to the concepts as opposed to a through understanding. I will introduce Alice either at the end of this week of the beginning of next. It is using object-oriented programming. Assignments: JavaScript assignment We will have open time in class to work on the JavaScript assignments |
| Week #13 Week of November 28th |
I had the wrong information, the speech is on Tuesday (Dec 13th at 11:00). The Division is hosting a talk by a speaker
who is involved in entrepreneur endeavers involving games. I would really
like as many of you to attend as possible. I will post the details next week. Computer Code assignments that are not passed in by the end of this week, must be passed in with a work sheet showing what you did - just answers are not acceptable for late assignments. And... I plan to go over the sale item logic problem and the 4 logic challenge problems. If they are not in by this Friday (Dec 2nd), before the start of class, they can not be submitted for credit. Please read chapter #11, we will talk about chapters 10 and 11 this week. We will also start looking at JavaScript either this week or next. Please look at the presentations on Validating data, sequential updates and random updates. They are the last three presentations under logic including pseudocode and flowcharts. Assignments: Sequential processing exercise in class students will do this exercise in class - everyone must pass in the assignment (can be on paper if you do it in class) Random processing exercise (please also show the changes to the index)in class students will have the chance to work on this in class Query Assignment:Using the databases that you created last week, I want you to do the following queries. Do them using the query designer. Extra credit if you do them a second time using SQL. First: Print a list of all employees with the department name. Second: Print a list of all employees who are working on a specific project including the hours they worked on the project. I want the employee name, the project name and the hours the employee worked on the project. Third: Print a list of all employees, their department name, and the projects they are working on including the name of the project. |
| Week #12 Week of November 21st |
On Wednesday, November 23rd, I will be available for extra help in K101 from 1:00 - 3:00. Note:Numbering system assignments that are not passed in by the end of this week, must be passed in with the work sheet - just answers are not acceptable for late assignments. Chapter #9 is optional. If you decide to read it, there are supporting visual basic examples for some of the topics covered. There is an extra credit assignment on this topic. Read chapter #10, you are on your own to cover this chapter, I will cover it very briefly in class. Now we are going to jump out of sequence, I want you to read chapter #16 on relational databases. That is out next major topic. Assignments: Computer Code Quiz Following the directions in these assignments, set up the tables and populate them with data: (this assignment will stretch into next we4ek. Student database to develop Payroll database to develop Extra Credit Asssignment on sorts:Your extra credit assignment is to write the pseudocode for a TopDown sort. The logic is shown in the presentation on TopDown. You might also find the notes on bubble sorts and the sample bubble sort programs helpful. For extra extra credit, write a program that does a TopDown sort. |
| Week #11 Week of November 14th |
Advisement starts this week. I will be available for online advisement on Monday from 10 to 1.
We can email back and forth using pgrocer@comcast.net for advisement purposes. I will also
be available to do advising on Wednesday, Novemeber 9th via email at pgrocer@comcast.net. I can
advise you and give you your pin so you are ready on Monday. I do not have transcripts at home
so you are responsible for telling me what you have taken! Other advisement times will be
posted on my door on Wednesday, November 9th. We will look at binary numbering systems and computer codes this week (chapter #3 in 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: Numbering System Assignment |
| Week #10 Week of November 7th |
See note on advisement under week of November 14th.
This week we will only have class on Tuesday. I have to be at a conference on Thursday and there
are no classes on Friday. I have arranged for someone to be in the lab at 9:00 and 10:00 on Thursday
for help with Visual Basic if you want to continue working on the assignments with support.
In class we will continue looking at VB6. I have also put additional sample programs on the web - some if statement examples. I am also going away for the long weekend - so please be kind to my email and wait until Monday to submit! You should browse around in chapters #6, #7, #8, #9 in Absolute Beginner's Guide to Programming looking for help with Visual Basic. I would also like you to read chapters 9 and 10 in Programming Logic and Design. Chapter #9 has a lot of information that we will not cover, so read it for an overview understanding. People using VB.NET can get information from my CIS56 class examples and presentations. Assignments: No new assignmnets - please work on the VB assignment posted last week! Additional examples are now available. |
| Week #9 Week of October 31st |
I had a problem with my email and lost everything from 10/23/05 through 10/31/05. If you sent
me something during that period, you need to resend. I am working on recovery, but I do not know
when! For safety, you can send a copy to pgrocer@comcast.net if you want to! You should have read chapter #8 in Programming Logic and Design and you should start to read about Visual Basic in your Absolute Beginner's Guide - that means chapter #3, #4, and #5. If you are interested, keep going! Be sure to look at Smartboard presentation and listen to the accompanying audio especially if you are a distance learning student. We will finish up the discussion of breaks. The next topics are Visual Basic and arrays. In class, we will work with VB 6 since that is easier to learn quickly. If you are interested in VB.NET see the notes under presentations. Remember you can get Visual Studio which includes VB.NET using the MSN Allisance. Under programs, you will find some sample visual basic programs (VB6). I want to look at the Random program, the two FOR programs and the first array program. They are the first four programs listed at the site. You need to download both the project and the form to be able to run the programs. When you download, you will see the code, just do a save using the same name. Assignments: Minor Break Assignment Visual Basic Assignment (due week of 11/21/05 extended because of web site problems) We will have additional lab time to work on these. |
| Week #8 Week of October 24th |
You should have read chapter #6 in Programming Logic and Design and now I want you to read
chapter #7. This week we will look at the logic of totals and the logic of breaks. If you are interested in a COBOL compiler for home use, you can explore this site: Fujitsu COBOL Honestly, there is a significant learning curve, so do Option #2 below unless you are really interested. We are going to look at the logic of final totals and final totals in COBOL this week. You can download the sample COBOL program. COBOL total example (zipped) Examples of COBOL breaks are available under programs at this site. I will be available for help this Friday from a little after 1:00 until 3:00 (I originally planned to be there at 1:00 but an appointment that I thought was cancelled has reappeared). Lou will be there at 1:00 and I will come as soon as I can. This is a time for people to get extra help or to work on assignments. Assignments: First assignment:Use the program named C17LAB1.CBL which is in the set of zipped programs in last weeks work for this assignment and do one of the three options. Option #1: I want you to modify the program to handle 4 of the if statements that we flowcharted last week. At least 2 of them should be in the 5-8 range. You should get them running in COBOL. Option #2: I want you to modify the program to handle all 8 of the if statements that we flowcharted last week - you can pass the work in written in the program. Please past the different versions of the program one after another in a single word document to make my correcting life easier! Option #3: We will look at this as a 1 running is equal to 2 done by hand, so if you get 2 running you can do 4 by hand etc. Second assignment: Retail Sale Logic Hint: I would consider using a loop to process the information for the four days of the sale. |
| Week #7 Week of October 17th |
We are going to work on the first assignment in class on Tuesday. The solution must be
passed in by Thursday for credit. If you miss this deadline, you can request an alternate
assignment, but there will be credit lost. This week we are going to start working on COBOL, so I have included a zip of some files we will look at: COBOL examples (zipped) Assignments: Flowchart and pseudocode assignment MUST BE PASSED IN ON THURSDAY Will be started in class on Tuesday! |
| Week #6 Week of October 10th |
Please read chapter #5 and start chapter #6 in Programming Logic and Design. These
chapters deal with decisions and looping and we are looking at these topics in class. We are looking at the logic for a program to guess a random number that the computer selects. We started with a simple quess, then moved to lets only give 5 chances and on Friday will move to the idea of repeated playings of the game. This weekend, I will publish the class notes. Please be sure to look at them if you do not come to class. Also, please look at the notes on Rock/Paper/Scissors logic. Assignments: Quiz #4 Note that you have to enter SUBMIT to have this quiz submitted to me - only do this when you are ready to receive the grade. 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! (due in 2 weeks) LOGO assignment:Do a project (or projects) that involves using an if, an if with an else, a loop and a procedure. Send me the project in logo and the code you used separately. |
| Week #5 Week of October 3rd |
I am going to a conference so I will only be in class on Tuesday. Friday my lab assistant will
be in K101 so if you have questions you can go to the open lab with her on Friday. There are quite a few audios and smartboards that have been put up since the beginning of the semester. If you are having problems with an area these will be helpful. I strongly recommend that distance learning students look at the payroll and rock/paper/scissors game logic that was done last week. 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. Information about LOGO procedures is also available under notes. Information about LOGO 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: Logo assignment |
| Week #4 Week of September 26th |
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 may get to #4 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 We will do this in class. Note that answers to the practice exercise are posted as a SmartBoard presentation Be sure to check the Smartboard presentations and accompanying audio regularly, especially if you are a distance learning student. Assignments: The logic quiz will be started in class - please do not start it until you have looked at the practice exercise. Logic quiz (html format) the quiz is best viewed with Explorer Logic quiz (word format) Quiz #3 Note that you have to enter SUBMIT to have this quiz submitted to me - only do this when you are ready to receive the grade. |
| Week #3 Week of September 19th |
A lot of quizes are being submitted without a name - I am even seeing some 100s without a name
- unless your name shows up with the grade when it is submitted you will not get credit! Smartboard presentations for last week have been put on the web. 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. Look at the first PowerPoint presentation under that is on structure (focus on loops). You should also look at the second presentation is this group called presentation on logical if structures. 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) Please paste the SQL into a word document and pass that in as well! See note about quiz #2 in week 2. |
| Week #2 Week of September 12th |
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 audio for week #1 and a SmartBoard presentation (use Explorer). The Smartboard presentation was being written as I talked. In the lab (probably Friday), 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. 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! To get software for this class: MSDN Alliance Software Assignments: For your own benefit (not to pass in): Make sure you could do the exercises at the back of the chapters. Quiz #2 Again, you can do the quiz until you are happy with the grade! Didn't anyone notice that the 4th question talked about an example below and there wasn't any example! Yikes! Access IF Assignment We will start this in class. 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. You should also copy and paste the SQL into a separate word or notepad document and send it to me along with the database. Sometimes the SQL gets changed back to the Access way and that is not what I am looking for. An SQL presentation is available under presentations. In addition, you can earn extra credit for doing both flowchart and pseudocode and extra credit for doing them electronically. |
| Week #1 Week of September 5th |
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. For students who need Access, it is available through the MSN Alliance. Click on this link to get a copy: MSDN Alliance Software I leave up the Smartboard Notes from previous semesters since much of the material is the same. You should look up Smartboard presentations on topics that you want to go over. There is a presentation on Data on files and tables that will help with Quiz #1. I am going to record some of the lectures in this class and put them on the web. This means that whatever you and I say may be available on the web for all to hear. I will always announce that I am recording prior to turning the recorder on. A lecture for week#1 that deals with assignment #1 and quiz #1 has been posted. 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 I would like you to keep taking this quiz until you get 100, however, you can stop when you get a grade that you are satisfied with! |