| Schedule by session | 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! I may add to the weekly schedule during the course of the week, so please check back multiple times. Please keep copies of all work you submit until you receive your final grade at the end of the semester. |
|---|---|
| Week #15 Week of May 5th |
I am available on Tuesday at 11 (K101) and from 3:00ish until 7:00 in my office or in K116.
Thursday we are going to have an all day help session from 9:00 until 3:00 in K101. I will not
hold specific classes during that time, you may come anytime and stay as long as you can to work on
homework and get caught up. If you are behind, you really, really need to make the effort to be there. I can also be available on reading day (Friday) from 10:00/10:30ish until noon or 1:00, but only if several students commit to being there. Another extra credit possibility. Work with Visual Basic in Access. If you are interested contact me. You will find information about this at my CIS61 site. I will post the final by Monday morning. I would really appreciate it if you would include a note on the status sheet (or just send me an email) telling me which you found the most helpful in logic development related to programming: LOGO, Alice, JavaScript and Visual Basic. It would be great if you would rank them 1, 2, 3 and 4 and comment on what worked best and what helped you least. Thanks! This week: Please look at the PowerPoint presentations that deal with sequential processing. Presentation on sequential update processing Separate speaker notes Sequential processing will be started in class Presentation on random update processing Separate speaker notes Random processing will be started in class Final exam is posted: Final Exam Required Status Sheet The final exam and the required status sheet are due by 2:45 on May 12th in K101. If you have not taken or completed the exam by that time, you must come to the exam and complete or take the final. The final is given on the honor system - I trust you, please do not betray that trust. The only person you can talk to or ask questions of is me! If you have a couple of assignments that you still need to do, contact me about a deadline. |
| Week #14 Week of April 28th |
I am available on Tuesday at 11 (K101) and from 3:00ish until 7:00 in my office or in K116.
Thursday we are going to have an all day help session from 9:00 until 3:00 in K101. I will not
hold specific classes during that time, you may come anytime and stay as long as you can to work on
homework and get caught up. If you are behind, you really, really need to make the effort to be there. Email me for a user name and password to use WINSCP3 if you do not have it. Your final is scheduled for Monday, May 12th at 2:45. That means that your final will be posted one week ahead of time. The final must be passed in to me prior to the start of the final or you need to come to K101 and take the final. Using WINSCP3 to upload your portfolio This week we are going to look at the concepts of relational databases and multiple tables in Access. There are PowerPoints and notes at the site that you should look at. Normalization - information on third normal form Separate speaker notes to accompany normalization presentation Relational database using donor Separate speaker notes to accompany relational databse using donors presentation Preliminary Status Sheet for you to check your status: Preliminary Status Sheet Assignments: Please make these databases and populate them. I also want you to query them. Student database The queries for the student database are on the page above. Payroll database example The queries for the payroll database are shown below: Query Assignment: Do these queries 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 #13 Week of April 21st |
I am available on Tuesday at 11 (K101) and from 2:30ish until 7:00 - in my office or in K116. We ended up reviewing VB on Friday, so we did not start to look at the portfolio. We will do that this week. Please read about portfolios here: Information about portfolios The next topic is relational databases where we will revisit Access. Please read chapter #14. During the last weeks, I hope to get to a few topics from chapter #8 and chapter #10 so it would be helpful to skim them as well. I am having trouble uploading to the BCC site so the audio and Smartboard are not there yet. Assignments: I want you to put up the beginnings of a portfolio. If you are new to HTML, you are welcome to use my templates which are under examples at the web site. If you are comfortable with HTML, I would like something more interesting. Please note that this is an opportunity to earn extra credit if you do a really nice portfolio. I want a resume (you do not have to put personal information, you can use first name and the schools address etc). I want a list of computer course you have taken. I want you to link to a couple of examples of your work. I only have one link for this in the template, you should add another (lets try for three examples of work related to computing). Email me for a user name and password to use WINSCP3 if you do not have it. Using WINSCP3 to upload your portfolio Another extra credit opportunity: Work with Game Maker. There are two PowerPoint presentations on the topic for you to review. For information about Game Maker, you can start at Game Maker Game Maker Extra credit: Do a game using GameMaker - there are a lot of tutorials at the site to help you get started! Even more Extra credit: Do a game using GameMaker that involves scripting. |
| Week #12 Week of April 14th |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:00ish until 4:00 and
then from 5:30 ish until 7:00ish (I am on a committee that is doing interviews and an interview
has been scheduled for 4:00. You can look for me in my office or in the lab across the hall. This is also advisement week,
so some of the time may be taken up by advisement rather than help! We will be working on Visual Basic some more at the beginning of the week. We will then take a look at HTML and developing a portfolio. Assignments: Visual Basic assignment #2 |
| Week #11 Week of April 7th |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:30ish until 6:30ish
- you can look for me in my office or in the lab across the hall. This is also advisement week,
so some of the time may be taken up by advisement rather than help! I am also on a committee that
is scheduling interviews so an hour may disappear on Tuesday. I will leave a note on my door
if I am at an interview! On Friday, a group of students from Kuss Middle School are coming in to learn about Alice. This is part of our service learning project. I need volunteers to be involved in this, so let me know if you are interested in adding service learning to your transcript. they are going to be here during class time, so it is service learning, work on your own in the back or elsewhere. This week we will start Visual Basic. VB 6 is the easiest to use and the one I will go over in class. You are welcome to use the other versions if you want to. Assignments: Visual Basic assignment |
| Week #10 Week of March 31st |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:30ish until 6:30ish
- you can look for me in my office or in the lab across the hall. This week we will start off by looking at a little more Alice. We will be dealing with numbering systems this week - a little break from programming while you finish your Alice assignments.Numbering systems and code Please note that the part on ASCII code refers to an old code - you need to research ASCII on the web. Assignments: Second Alice Assignment: I want you to write a program using modules, 2 kinds of loops, an if/else and an if/else with an embedded if/else. I want you to do a startup/housekeeping/initialize module, a process module that handles other modules and a wrapup module. Look at my examples (zipped copies of the programs) and PowerPoints on ballsbounce to help with this assignment. Binary/Hex/ASCII assignment You have an extra week on the Binary/Hex/ASCII assignment. |
| Week #9 Week of March 24th |
I will be available Tuesday and Thursday in K101 at 11:00. Check back, some other times will
probably be available. I cannot stay until 7:00 on Tuesday this week, I have an appointment off
campus. Please read chapter #7 and look over Chapter #11 which talks about object-oriented programming. That is the style used in Alice. Either this week or next we will talk about portfolios - I want to wait until I am reasonable sure you have worked with JavaScript. This week I want you to introduce yourself to Alice with my notes and handouts, presentations and examples. Alice can be downloaded from Alice (go with version 2) Please watch tutorial 1 about the ice skater under Alice tutorials (within the package) - there is also a presentation at my site. I want you to look at this PowerPoint presentation on Alice: Using Alice Zipped version of Using Alice for download More Alice: I want to spend more time with Alice this week and I want to start looking at it as a a programming language. Please look at the PowerPoint example and the zipped examples of bouncing balls. I am going to be asking you to write an Alice that has housekeeping/processing/wrapup and other modules as I did in my examples. I just hope you are more creative!!! ballsbounce examples zipped Alice programming If you go to presentations, you can get a zipped version of this presentation that might be easier to see. Either this week or next we will talk about portfolios - I want to wait until I am reasonable sure you have worked with JavaScript. Assignments: Alice Assignment: 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. Mid semester quiz/test Mid semester quiz/test (word version) This is the answer sheet you must use to submit the quiz: Quiz/Test answer sheet Quiz/Test answer sheet (word version) The mid-semester is due March 31st, 2008 |
| Week #8 Week of March 10th |
I will be available Tuesday at 11 in K101 and from 3:00 to 6:30 in my office or K116.
On Thursday, I am running an open lab for help and to get caught up from 9:00 until 3:00 in K101.
You can come for the whole 6 hours or you can come for your class and any other free time you have. Let's get caught up or ready to get caught up over vacation! We will continue to work on JavaScript this week. Assignments: Second JavaScript Assignment: Remember the algorithm assignment from week #5. I want you to write these programs in JavaScript. This assignment is due in two weeks. Algorithm assignment from week #5 |
| Week #7 Week of March 3rd |
I will be available for lab help in K101 on Tuesday and Thursday at 11, from 3:00 until 6:30 on
Tuesday in my office, we can go into a lab to work. I will also be available Thursday late
afternoon. We are going to start the week looking at my JavaScript examples. Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Simple IF Simple IF ELSE Simple IF AND In class we will write the simple IF OR... Assignments: JavaScript Assignment: JavaScript assignment We are starting this in class if you attend class. In addition to the JavaScript programs, I want you to do the flowchart or pseudocode for each of these problems. I recommend doing that first to help you write the program. |
| Week #6 Week of February 25th |
I will be available Tues and Thurs at 11:00 in K101 and Thursday at 2:30 in K101 and 3:00 in my
office. If you need to set up an appointment later in the day, contact me. There was no class on Friday, so we will be starting looking at JavaScript and the examples I included in last weeks layout. Check back to see where we are. Please be sure you have read the first 6 chapters. Please look at the PowerPoint on LOGO and the handout on LOGO procedures. In class we are working through the logic for quess a number, the JavaScript programs are: Guess number, one guess Guess number, one game Guess number, multiple games Next we will start to look at programming using JavaScript. Assignments: LOGO assignment:Logo assignment Copy the code you used and paste it into notepad and send it as an attachment along with the three LOGO projects. Extra credit: 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 in notepad. |
| Week #5 Week of February 18th |
I am at least partially recovered from my email and then computer disaster. If you have not heard back
from me by tomorrow night, I would resend anything I have not returned. This week I will be in the lab in k101 on Thursday at 11 and in my office after my 3:00 class. I will also be around some on Friday if you contact me. Read along in the book - we have been working with topics in the first 6 chapters, so you should read along trying to get all six read. 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 We are also going to start looking at JavaScript this week. Practice exercise: Practice exercise we already looked at Note that answers to the practice exercise are posted as a SmartBoard presentation Problem #1 in JavaScript Problem #2 in JavaScript I took the two examples in the practice exercise and converted them into a program written using JavaScript within HTML. I would like you to look at the examples - you do not have to understand the language rules to see the basic structure. Assignments: Algorithm assignment Quiz (optional quiz 2) This quiz is optional. If you choose to take it, and you have already taken quiz #1 from week 3, I will count the higher grade. If you did not take quiz #1, this is a last chance - there will be a late penalty but it is better than a 0 (note on the assignment I did not mention the late penalty, but if you missed the deadline for the first quiz, I am going to apply a one week late penalty). The quiz must be turned in by Tuesday night, February 26th. Please submit the quiz answers on the answer sheet (it is given below in html and word): Answer sheet (html version) Answer sheet (doc or word version) |
| Week #4 Week of February 11th |
I am experiencing problems with my email account starting 2/11/08. Please send email
to my backup account and try resending to my main account in a few days. Since I developed
problems on the day the quiz was due, I have extended the due date until Wednesday, February 13th.
You should send it to my back up account. I have sent you an email with the address. I will be in lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday. I will also be available in my office (K-112) for help (we can go to a lab) on Tuesday from 3:30 to 6:30 (I maybe free from 2 - 3:30 on Tuesday, but I am not sure yet. I will be available in my office on Thursday from 3:00 to 4:00. Check with me! I should have told you to read chapter #3 and #4. We will continue looking at logic including flowcharts, pseudocode and alogrithms. Please check back! Assignments: Logic quiz (word format) Depending on your settings, the word quiz may have one decision that looks incomplete. You can manipulate it in the word document (the last decision says totInven > reOrdPt) Flowcharts/pseudocode We will work on this assignment in class. If you are a distance learning student or you were not in class, you need to develop the solution for three of the problems from #4 to #8 and send it to me as a check off. I will take attendence to verify who was there! Note that flowcharts can be drawn in word, PowerPoint or using Visio that comes with the text. |
| Week #3 Week of February 4th |
I have asked for the lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday and some other days as well.
I am waiting for confirmation. Let's assume I will have it at the 11:00 times. I will also be
available in my office (K-112) for help (we can go to a lab) on Tuesday from 3:30 to 6:30 (I maybe
free from 2 - 3:30 on Tuesday, but I am not sure yet. Check with me! We will start the week working on the logic we looked at last week and looking at loop structures. Please look at this PowerPoint: Presentation on structure (focus on loops) Separate speaker notes to accompany presentation structure (focus on loops) 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. Presentation on using pseudocode to play computer - help with logic quiz Separate speaker notes to accompany presentation on using pseudocode to play computer You should also be looking at the SmartBoard presentations. Practice exercise: Practice exercise We will do this in class. Please check back and see where we are. 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. You need to take this quiz and return it this week. It is due February 10, 2008 midnight! Quiz Please submit the quiz answers on the answer sheet (it is given below in html and word): Answer sheet (html version) Answer sheet (doc or word version) |
| Week #2 Week of January 28th |
Interesting offer to check. Microsoft Ulitmate Steal Promotion I have asked for the lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday and some other days as well. I am waiting for confirmation. Lets assume I will have it at the 11:00 times. I will also be available in my office (K-112) for help (we can go to a lab) on Tuesday from 3:30 to 6:30 and Thursday from 3:00 to 5:00. Please be sure to look at the first two presentations under Access and SQL: Presentation on using SQL queries in Access Separate speaker notes to accompany fusing SQL queries in Access Presentation on SQL in Access - a little more Speaker Notes to accompany SQL in Access - a little more I have also referenced some tutorials on the del.icio.us site. Please read chapter #2 in Programming Logic and Design. I will spend some time this week talking about the concepts in the book. Look at the second PowerPoint presentation under Logic including Pseudocode and flowcharts that is on logical if structures. You should also look at the first presentation is this group called presentation that has a focus on loops. We may not get to loops until next week! Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures In class work sheet on if statements (Extra Credit if you pass it and it is correct or close to it) Assignments: Access Design and SQL Project (due in two weeks) Please paste the SQL into a word document and pass that in as well! As always, please check back! |
| Week #1 Week of January 21st |
Please read chapter #1 in Programming Logic and Design. If you can't get the book, next
week is fine. The first topics do not rely on the book. We are going to start out working with Access. The version you use is up to you - in the labs we have several different versions. Most of the references I have will not be for Access 2007, but rather for Access 2003. 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. Note the information about Assignment #1 above is for reference only - it is to help you with your first assignment! 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. Practice exercise we will do in class The solution to the database is on the web - the queries will be covered in class (the queries I am asking for are different from the ones in the example). 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 information: MSDN Alliance Software You will receive an invitation from the college to the MSDN alliance. I leave up the Smartboard Notes and audio lectures 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. I record most of the classes where I deliver a lecture so you should always assume that the class is being recorded. If you want to know, just ask! Assignments: Note: Assignments are not due until the week after they are assigned. You are welcome to pass them in early. Late assignments will loose points - see the syllabus for details. Game collection table to be developed Due in two weeks (although you will get other assignment(s) next week) Please remember that I do not want embedded spaces in the field names and I do not want all field sizes for text fields to default to 50. Please check back every week to see if I have added anything! |