| 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! |
|---|---|
| I will be available for help most Tuesdays (I will post if I am not) from 2-4 in K-116. I will also be available on Thursdays from 11-12 in K-101. My work study Marissa will be there as well and covering for me if I have to step out. Please try to come if you are having problems. If no one is comes I will be in my office K-112. | |
| Week #15 Week of May 7th |
Please complete this survey that the Division has requested and email it to me or give it to
me in class or slide it under my door or give it to Karen Costa in the Division office.
CIS Student Survey Homework is due the day of the final. I will take a few assignments over the weekend after the final, I will even take one or two at the beginning of the week. However, if you turn in a large number of assignments you may receive an incomplete (if there is enough work to pass the course). There will be an open lab from 9-11 and 1-2 in K 101and then help in K116 from 2-4 on Tuesday. The final and required status sheet were posted on May 4th and are due prior to the start of the final on May 11th at 12:30 in K101. If you have not turned in the final and the status sheet prior to the start of the final, you need to report for the final and take the final and fill out the status sheet during the scheduled time. Remember the status sheet is a requirement. I do not correct the final until I have received both the status sheet and the final. Status Sheet Final exam |
| Week #14 Week of April 30th |
Because I was out on Friday, we will continue with codes this week and then look at Game
Maker on Tuesday. Most of my classes are open labs this week, you are welcome to come and work when I am here. On Thursday I will be out, but Marissa will be here to answer questions. Next Tuesday is an open lab all day 9-11 and 12-2 in K101 and 2-4 in K116. 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. Binary conversion Hexadecimal information ASCII We will also look at Game Maker this week. 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 The ethical use of the Internet is something we all need to consider. Please read the following articles: Ten Commandments of Computer Ethics Code of Ethics Bloggers code of ethics Check back as always! Assignments: Binary/hex/ASCII assignment I want you to take this quiz and then correct it (the answers are given at the site) - send me the list of what you got right and what you got wrong with an comments about the ones you got wrong (why you got them wrong, do they make sense etc) This is not graded - I will check it off if you do the quiz and it it has the corrections requested. Copyright and Fair Use Quiz The final will be posted at the end of the week - it is due on May 11th at 12:30PM. Extra credit: Do a game using GameMaker - there are a lot of tutorials at the site to help you get started! Extra credit: Do a game using GameMaker that involves scripting. |
| Week #13 Week of April 23rd |
If you attend the speech by Paul Graf and send me a writeup of your thoughts, you can earn some
extra credit. This is a check list of assignments up to this point in the semester: Preliminary Status Sheet This week we will 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. Read the information in your textbook nor relational databases and normalization (chapter #16) As always, check back and see how we are doing! Assignments: Following the directions in these assignments, set up the tables in Access and populate them with data: 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 #12 Week of April 16th |
We are finishing up Visual Basic this week and then we will move on. Please look at the PowerPoint presentations that deal with sequential and random processing. Please be sure you have read chapter #10 and #11 in your text. Presentation on sequential update processing Separate speaker notes to accompany sequential update processing Presentation on random update processing Separate speaker notes to accompany random update processing Assignments: 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 will be started in class Random processing exercise will be started in class |
| Week #11 Week of April 9th |
Advisement starts this week. I will be available for online advisement on Monday from 9-10 and
Wednesday afternoon and evening and then
on campus according to the signup on my door (I keep adding slots as needed, so check back).
You can also email me or IM me for advisement. We are going to continue working on Visual Basic this week - specifically we will look at loops and arrays (there is information on arrays in your text that you should be reading. We are having a group of kids for the service learning project from 9:00 to 11:15ish on Friday, so we will not have class on Friday. There will be seats in the back of the lab so you are welcome to come and work on projects and I will be able to help you. Anyone that would like to get involved in service learning and working with the kids on LOGO and Alice is invited to join us. Please read chapter #10 and #11. We will look at aspects of these chapters in the next few weeks. Check back! Assignments: Visual Basic Assignment |
| Week #10 Week of April 2nd |
The first service learning group is coming this week from 10:00 - 12:00, so our class is
going to be working with the kids. For students who are not participating, I will be
available for help. You can use the back computers in the class room. You
can also let me know you are in the main lab and I will check on questions there. I hope
many of you will choose to participate in the service learning project! I will not be available for help Thursday at 11:00. 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. 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. Assignments: Problem #1: Write a program using Visual Basic that will let the user key in the hours worked, their pay per hour, and the amount they want to withhold. Have the computer then calculate their pay and display it. Problem #2: Write a program with Visual Basic that takes in a student name and a major. Check the major using an IF statement. If the major is CI print a message giving the student's name and a message saying they are majoring in Computer Information Systems, otherwise print the students name and a message saying your are not a CI major. |
| Week #9 Week of March 26th |
I was out Friday so we have some more to do on Alice and on the portfolio project. Check back and
see how we are doing. Please bring something to class that you can upload to the portfolio
site so you can check this out. Please continue looking at Alice and working on your Alice
project. Assignments: 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. To start out, your portfolio should have a link to an Access database that you have done, a link to your JavaScript assignment (you should show the assignment and your solutions running) and a link to at least one assignment that you did in word. |
| Week #8 Week of March 19th |
This week we will continue with Alice and we will also go back to the portfolio project. We will look at modules in Alice and how to create a program with structure using the Alice objects, methods and modules. I will then ask you to do a second Alice assignment using modules. The first week of this class, we looked at creating the html pages to put on the web. We will now upload the pages and start to create a portfolio. Remember, do not put any personal information on the web that you are not comfortable with the world seeing - this includes last name, address, phone, email and other identifying information. If you decide to use the portfolio when you are job hunting, you can make adjustments at that time. Please read chapter #7 in the text. Alice tutorials: Alice Tutorial from Alice.org Alice tutorial This week we will also start to discuss the service learning project. Please read the description and requirements: Service Learning Project Assignments: First Alice Assignment: The Friday before vacation, we started Alice and I put the information about downloading Alice and the first assignment that we did in class under vacation week, the information on this assignment is now officially an assignment so look under Vacation Week for the first Alice assignment. 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 and randomnumber to help with this assignment. |
| Vacation Week | On the last day of classes before vacation, we started looking at Alice. You can find a PowerPoint
presentation at my site explaining its use. The ice skating tutorial that comes with the package is an
excellent introduction. Alice can be downloaded from Alice The first assignment is: 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. This assignment will be officially given the first day after vacation. Students that were inclass finished the assignment on Friday, so students that were not there might find it beneficial to experiment over vacation. |
| Week #7 Week of March 5th |
Note I have added a help lab in K-101 on Thursdays at 11:00. Acutally this week on Thursday (Match 8th), I am going to have all my classes from 9:00 until 2:00 open labs. You can come to K-101 during your class time or any time during that period for help. If you are not completely caught up, you should make a point of coming for at least your class hour! Again, please read chapter #5 and chapter #6 in the textbook. Be sure to look at the PowerPoints on JavaScript and the examples that I have posted under programs. JavaScript tutorial Assignments: JavaScript assignment In addition to the JavaScript programs, I want you to do the flowchart and pseudocode for each of these problems Check back! |
| Week #6 Week of February 26th |
Marissa will run the 2-4 help on Tuesday, I have a meeting in Boston Tuesday afternoon. We will start this week by finishing the guessing game and then working on logic flowcharts. We will combine this with coding JavaScript. Please read chapter #5 and chapter #6 in the textbook. Check back to see what we are doing at the end of the week. Assignments: Flowchart/pseudocode class/homework I will take class attendance - if you were in class when we did a particular flowchart, you do not have to do that flowchart as part of your homework. All flowcharts that you were not in class to participate in the development must be done as homework - the assignment is a check off rather than a graded assignment. |
| Week #5 Week of February 19th |
I should have received multiple emails from each of you - remember you are required to keep in touch
once a week.
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. The practice exercise and the accompanying JavaScript programs are under last weeks date because we worked with them last week. We are going to continue our discussion of logic this week by developing the logic for solving some problems. We are also going to look at JavaScript. 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. 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 Assignments: Please do not start the logic quiz until you have looked at the practice exercise. (Note the word version is clearer) Logic quiz (html format) the quiz is best viewed with Explorer Logic quiz (word format) 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 #4 Week of February 12th |
We did not get to loops last week, so we will start the week off by looking at the loop assignment
listed for last week. Presentation on structure (focus on loops) Separate speaker notes to accompany presentation structure (focus on loops) 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 Practice exercise: Practice exercise We will do this in class. 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. The Smartboard notes and audio for 9/28/06 should help and there will be notes from this class posted next week. Be sure to check the Smartboard presentations and accompanying audio regularly, especially if you are a distance learning student. 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. Logo assignment (due in 2 weeks) |
| Week #3 Week of February 5th |
Remember that the lectures are on the web under audio and the Smartboard presentations are
under Smartboard. 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 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. Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Presentation on structure (focus on loops) Separate speaker notes to accompany presentation structure (focus on loops) Assignments: Access Design and SQL Project (due in two weeks) Please paste the SQL into a word document and pass that in as well! |
| Week #2 Week of January 29th |
I had a few technical difficulities, but the notes and audio are finally up and working - I hope.
Let me know if there is a problem. I will be available in K-116 for help on Tuesday from 2-4 so if
you have questions or need help, please drop by. I will be out on Friday, I am giving a speech at a conference. I think it is useful to come to class anyway and work together on assignments - your choice! 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. Another resource is the Smartboard presentations and audio from this semester and previous semesters. Please read chapter #2 in Programming Logic and Design. Assignments: 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 I am asking for are different from the ones in the example. If you have questions, ask! 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. |
| Week #1 Week of January 22nd |
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. Assignments: 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. Portfolio Project 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! |