|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!
Week of December 11th
|I will be available for help on Tuesday from 11:00 to 4:00 in K101 and 4:00 to 7:00
somewhere. I will also be available of Friday from 12:00 to 4:00 in K101.
This week we will work on Game Maker with an extra credit assignment on Game Maker and scripting. If you have been late with work or missed work this will help. I will take homework through the last day of classes. I will accept one or two assignments over the weekend but if I get a load of work after the last day of classes I will not correct it until January. Your final is December 19th at 8:00. Remember, email final to the usual address and also to firstname.lastname@example.org.
If you are passing in the final via email, it must be received prior to the start of the final or you have to come and take the final or turn in the completed final during the scheduled time.
REQUIRED Status Sheet for Fall 2006
The status sheet must be turned in or the final is incomplete and will not be corrected.
Final Exam (PowerPoint presentation)
Zipped final exam
Extra Credit Assignment:
First: Do a basic Game Maker project using script (include if and while).
Second: Develop a game in Game Maker including script.
Week of December 4th
|This week I will be available for help on Tuesday from 11:00 to 4:00 in K101. I will
stay until 7:00 if I hear from several people by Monday night saying they will stay in
the evening as well. I am not interested in staying if there are not going to be students
to help - so let me know.|
This week we are going to look at random access files and compare it to sequential. Specifically we will look at updating. We will then look at binary, hex and ASCII code.
You should also read the handout about numbering systems and codes under Notes and handouts. (Please note that this handout deals with 7 bit ASCII and you are going to deal with 8 bit ASCII as described in your text). You can also find other sites to reference under your site links. Be sure to look up information on 8 bit ASCII.
As always, check back!
Status sheet: You can fill this in for me to check and see if we are in sync. It is a requirement that you fill it in for the final.
Status Sheet for Fall 2006
Remember this is an ongoing project, so you should be adding in your other courses as well. When you get to your capstone course, we will require that you have a portfolio of the work you have done in your major. So... keep this in mind as you accomplish major projects in your major.
Blog assignment: I want you to find a reference about what makes a good electronic portfolio and what should be included in the portfolio and post the address and a comment about it on the blog. I have posted the questions there. You should login and make a comment. Be sure you sign it so I can give credit!
Random processing exercise will be started in class
Binary, hex, ASCII assignment (I added an extra credit portion)
Week of November 27th
|We will continue with Arrays and Visual Basic and then look at relational databases,
normalization, multiple files and indexes in Access and random processing.
Please be sure to look at the two presentations under Access and SQL called Normalization and Relational Database using donor. You should also read the notes under relational database rules called relational database - normalization rules.
Please check back.
Following the directions in these assignments, set up the tables in Access and populate them with data: (this assignment will stretch into next week.
Student database to develop
Payroll database to develop
Query Assignment:Using the databases that you created above, 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 of November 20th
|We are going to continue looking at sequential processing and Visual Basic and arrays.
Those doing service learning should come to K118 for the 9:00 and/or 10:00 session.
Please look at the presentation called presentation on sequential update processing under Logic including pseudocode and flowcharts under presentations.
Also please look at the presentations on arrays in the same area.
Sequential processing In class students will do this in class - I need it from everyone.
Week of November 13th
|I am going to the conference on the 17th, so class will not be held.
Thanks to everyone who was able to come to the speech - I appreciate the great audience we were able to give to Igor Kholodov!
Next group of service learning students are coming from Morton Middle School on Monday, November 20th at 9:00 and 10:00. I need the students who are doing the service learning project if you can possibly make it. If you have a real conflict, talk to me and we will try to work out a plan.
Open lab at 9 and 11 in K101 and also at 3 on Thursday. Since the speech is at 10 we will be in H209 at 10:00 on Tuesday.
We will look at VB reading and writing files and if we have time a little more at arrays.
Pleas read chapter #10 and #11. We will look at aspects of these chapters in the next few weeks.
We will also start to discuss sequential processing concepts. This may go over into next week.
Write a VB 6 program that will create a file from information entered on the form. Write a second VB 6 program that will read the file you created and display the information on a form. Use my sample programs and PowerPoint presentation to model this.
Sequential processing We may not get to this assignment until next week - check back - in class students will do this in class.
Week of November 6th
|Next Tuesday, Igor Kholodov is coming to speak to CIS students at 10:00 - room to be
announced. Anyone that comes and then gives me a short statement about what was said
will get extra credit. Igor Kholodov is a programmer that developed a board game on learning
programming and then went thru the process of learning how to go into business to
develop and market the game. He was written up in wired and it sounds like he has an
interesting story to share - please try to come!
Please read chapter #8 and I would also like you to look at chapter #9. Both chapters deal with arrays. We will focus on the topics in chapter #8. We will also start on Visual Basic and eventually look at arrays in VB.NET. We will come back to Alice later to deal with arrays and lists in Alice.
Note that we are using VB version 6 which can be downloaded from MSDN the same way that you downloaded Access. If you are comfortable and would prefer to work in VB.NET, that is fine, you can also download that from MDSN.
There are VB PowerPoints and sample VB programs.
Please check back for a Visual Basic assignment!
Thank you to everyone that came in and participating in the service learning project - I appreciate it and the kids had a great time!
Visual Basic Assignment
Week of October 30th
|This week we will start the service learning project - please read the description and
requirements: Service Learning Project
This week we will continue to work on Alice and your portfolio. The service learning project will happen on Friday.
Books on programming with Alice have been posted on the blog.
Extra credit: I will give extra credit for one extra Alice program - should include programming things like modules and other things that make it a well structured program.
Week of October 23rd
|Carol Mello will available on Tuesday (I will be at a conference).
She will show you how to use the userid and password to login and upload your
html pages to the server using WINSCP. You should bring your main page which
should be named index.html and she will show you how to load it. You may also
try to load other pages that you have. We will work on this more after I get back and I will
put up material at that point. So if you are doing Distance Learning, be patient!
The rest of the week we will deal with Alice and portfolio and...
I am away at a conference from Friday (10/20) through Wednesday (10/25)so no email help available! I have had upload problems so the audio for the week of October 16th has not gone up yet.
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 would like 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 and randomnumber to help with this assignment.
Week of October 16th
|Here is a summary of assignments through week #6:
What is due
Read chapter #7 in the text book. We will talk about logic, totals and control breaks this week and move on to Alice.
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
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! Extra credit if you get them all right!
Minor Break Processing
Alice Assignment (two weeks): 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.
Week of October 9th
|This week I will not be able to have the open labs - Tuesday is Monday's schedule
and I have to go to a meeting on Thursday. Marissa will be available on Thursday at 3:00
in K101 I believe.
Please read chapter #5 and chapter #6 in the textbook.
We will continue working on logic and problem solving this week.
We will work on this in class - for now distance learning students should work on solving the problems on their own.
Flowchart/pseudocode class work
Extra credit if you get in the last two flowcharts on this weeks classwork by Friday.
Week of October 2nd
|Remember that I am having an open lab for help on Tuesdays at 11 and most Thursdays at 3 in K101. If
you need help, please stop by. Also, I will occasionally give you an open lab during class time -
I did that last Friday so there are not notes for that class.
I hope you are enjoying learning some programming basics with StarLogo. If you are interested in doing a service learning project with kids we bring over from the Fall River middle schools, please let me know. We will be working with them on StarLogo and some other software.
Note that I have sent you an invitation to use the Yahoo IM to ask questions. The invitation went to your Bristol account. If you did not get the invitatin and you want to use the IM, me know. There is no requirement to use it, it is just another option for getting help.
Guess number, one guess
Guess number, one game
Guess number, multiple games
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 (notepad or word).
Check back after I see where we are.
Week of September 25th
|Remember that I am having a open lab for help on Tuesdays at 11 and most Thursdays at 3 in K101. If
you need help, please stop by.
I should have received multiple emails from each of you - remember you are required to keep in touch once a week - also, I have not gotten quizzes from everyone. If you want to confirm your quiz grade, you can send me an email and ask what got recorded.
You should read chapter #4 in Programming Logic and Design. 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.
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:
On campus, StarLogo is available in K130 and in K101. I believe it is available in some other labs as well.
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 on chapter #2 and #3
Logo assignment (due in 2 weeks)
Week of September 18th
|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!
Remember that the lectures are on the web under audio and the Smartboard presentations are under Smartboard - the pdf version is best and I think I will actually stop using other ways of looking at them.
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).
Look at the first PowerPoint presentation under Logic including Pseudocode and flowcharts that is on structure (focus on loops).
You should also look at the second presentation is this group called presentation on logical if structures.
Presentation on structure (focus on loops)
Separate speaker notes to accompany presentation structure (focus on loops)
Presentation on logical if structures
Separate speaker notes to accompany presentation on logical if structures
Logic assignment ill 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!
Week of September 11th
|I have reserved K-101 for 11:00 on Tuesday for question/help etc., essentially a
lab support office hour. So if you want to go over anything, please plan to
come at that time. This will be every week unless I post otherwise. If no one is
in the lab, I will go back to my office in K-112.
The area to store the portfolios have not been completed, so we will have to wait a week or two before we put your portfolio on the web. So, we are going to take a look at the Access database this week. 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.
For students that come to the BCC campus, all software is available in labs.
For students who need Access at home, it is available through the MSDN Alliance. You should have received an invitation to join the Alliance, if not, please send me an email.
There is a presentation on Data on files and tables that will help with Quiz #1.
You should also look at Smartboard presentations and audio from this semester and previous semesters.
Please read chapter #2 in Programming Logic and Design.
Note: Assignments are not due until the week after they are assigned. You are welcome to pass them in early.
Practice exercise 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).
Game collection table to be developed Due in two weeks (although you will get other assignments next week)
For your own benefit (not to pass in): Exercises at the back of chapter #2.
Quiz on chapter #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! Note that the quiz grade gets reported to me however - it would be nice backup to save a copy of the grade.
Week of September 4th
|CIS career students are going to be required to prepare a portfolio that will be
worked on and evaluated in their capstone course. The portfolio will be started
in this course. This is a work in progress, so some things may change between
now and your capstone course, but you will have time in your capstone course to
pull it all together!|
This week we are going to start learning HTML in class. I will help you develop some of the basic skills to start your portfolio. If you know more advanced HTML or XHTML I invite you to incorporate your skills into the development of the portfolio. However, the requirement is simply a basic set of pages.
You will find presentations on HTML and on Portfolio Development under Presentations and you will find HTML examples under Examples. These examples include two basic templates that can be modified or you can design your own look. You will also find links to tutorials on HTML under links and tutorials. Please read chapter #1 in Programming Logic and Design.
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.
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. Lectures from last semester are available to download.
Note: Assignments are not due until the week after they are assigned (unless otherwise indicated). You are welcome to pass them in early.
For your own benefit (not to pass in): Exercises at the back of the chapter.
This week, I want you to start developing the pages that will form the structure of your portfolio. You do not have to pass in anything this week.
Please check back every week to see if I have added anything!