| 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! |
|---|---|
| Week #15 Week of December 10th |
This week we will put up the portfolio and look at a few other things that I would like to cover. You can 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 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. Homework is due by the last day of classes. I will take a few assignments up to the start of the final, but we are talking about a few! If you feel you will not pass the course, you should get in touch with me to discuss your options. The final is an online or inclass final. I will post it one week ahead of time which means I will post it by the 12th of December. It must either be submitted to me prior to Wednesday, December 19, 2007 or you must come to the scheduled final at 8:00 that day to take the final in class. If you have any problems accessing the final let me know. Final exam in word format I found three minor errors in #2 on the final. The main loop should have been called loop not start and the X statement saying returns to add to inventory was incomplete. Also the last record on the master file should have an item number of 16789 instead of !6789. I have fixed them. Let me know if you see any others! Required status sheet 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! |
| Week #14 Week of December 3rd |
On Tuesday, we will have a open lab in K101 from 9:00 until at least 2:00, if there is interest I can stay
until 4:00 at least. There will be two Facilitated Study Groups for CIS17 this week. They will be on Wednesday from 10-11 and Thursdays from 1-2 in K102. I will also be available from 3:00 - 4:00 in K116. In putting up your portfolio, you need to contact me for your username and password. Optional check off sheet to check your status: Preliminary status sheet This week I am going to try and get through putting your portfolio up on the web and the development of databases that have multiple tables. We will discuss the rules for developing a relational database that is in third normal form. Relational database notes Please look at the two PowerPoint presentations under Access and SQL that are named Normalization - information on third normal form and Relational database using donor. This is an inclass exercise we will do: Student Database to develop Next week we will finish what is left and I will give you a chance to work with Game Maker for extra credit. Presentation on random processing: Presentation on random update processing Separate speaker notes to accompany random update processing Assignments: Random processing we started in class 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. We are also going to put the portfolio on the web. I would like you to have the two pages we started ready for us to load and work with in class. I want you to put out an assignment you did in word saved as a web page, a sample JavaScript that you created and one of your Access databases. Note we did not get to putting up the portfolio - just started to work on it in one class. First thing next week, it will happen! |
| Week #13 Week of Novembner 26th |
I will be available in K101 at 11:00 on Tuesday and K116 at 3:00 on Thursday and there
will be two Facilitated Study Groups for CIS17 this week. They will be on
Wednesday from 10-11 and Thursdays from 1-2 in K102. Next Tuesday, I am going to have another open lab in K101 from 9:00 until at least 2:00 - if there is a need we will cover through until 3:00 or 4:00. Please come for a many hours as you can and get caught up! One of my students suggested looking at this site for student offers: Microsoft Education We have looked at arrays which is covered in your text - chapter #8. We will also look at reading and writing files, breaks (this may wait but please read chapter #7) and sequential processing this week or next. You should find the topics in the text and read them (these relate to chapters #10 and #11). Essentially I would like you to work on these chapters, looking for basic concepts rather than indepth knowledge We will continue looking at Visual Basic and hopefully get to putting your portfolio on line. Using WinSCP3 Please look at the PowerPoint presentations that deal with sequential processing. Presentation on sequential update processing Separate speaker notes to accompany sequential 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 under read and write and PowerPoint presentation to model this. Sequential processing will be started in class |
| Week #12 Week of November 19th |
Happy Thanksgiving! This week is catch up week - on Tuesday there will be an open lab in K101 from 9:00 until 2:00. I will be there as well as Shawn and Stephanie - if you are behind or need help, please come for as many hours as you can. Let's get caught up! I can do a little advisement as well! |
| Week #11 Week of November 12th |
Advisement starts this week! There will be two Facilitated Study Groups for CIS17 this week. They will be on Wednesday from 10-11 and Thursdays from 1-2 in K102. Information on binary/hex: Binary conversion Hexadecimal information We will work on starting to put up the HTML portfolio web site. I would like you to have the two pages we started ready for us to load and work with in class. I want you to put out an assignment you did in word saved as a web page, a sample JavaScript that you created and one of your Access databases. We will work on this in class. This week we will start to work on Visual Basic - check back and see how we are doing! Assignments: Work on your portfolio web site (see details above - we will go over the requirements this week or next Tuesday). You need to contact me for your username and password. Visual Basic Assignment |
| Week #10 Week of November 5th |
Lab in K101 at 11:00 on Tuesday also Thursday 4:00 - 6:00 probably in K116. Check my door! There will be two Facilitated Study Groups for CIS17 starting this week. They will be on Wednesday from 10-11 and Thursdays from 1-2 in K102. You are going to be creating a web site, and I want you to become familiar with some of the ethical ideas involved. Please read the following: Ten Commandments of Computer Ethics Code of Ethics Bloggers code of ethics Some major changes happened with the BCC server storage and therefore the information such as PowerPoints, Smartboard and audio that I store there. Please let me know if you cannot access anything. I have put the Smartboard notes for JavaScript in a temporary location so you can access it. This presentation should help with JavaScript: JavaScript introduction We will be dealing with numbering systems this week - a little break from programming while you finish your JavaScript 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: 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 |
| Week #9 Week of October 29th |
I am available in K101, Tuesday at 11:00. I am also available Thursday and Friday at 11:00 in my office.
I am also available Monday from 1:30 - 3:00 in my office and Thursday at 4:00 in K116 (I am rescheduling the 3:00 help to 4:00). Please get help if you need it! This week we are going to continue looking at JavaScript - please look at the examples under programs and JavaScript up to the ones on arrays. We will work on them in class on Tuesday. Check back and see how we are doing. Assignments: First JavaScript Assignment: JavaScript assignment We are doing 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. We will work on this in class on Thursday and Friday. Second JavaScript Assignment: Remember the algorithm assignment from week #4. I want you to write these programs in JavaScript. This assignment is due in two weeks. 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 #8 Week of October 22nd |
My nag for the week - I did not get the quiz from quite a few people - the same people on the
whole who have not passed in a lot of homework. You can still pull this course out and even get a
good grade, but you really need to get more involved with homework! This week we are going to continue looking at the guess logic that I started last week as well as Alice. We are also going to look at the logic for final totals. Please note that there will be a help lab on Tuesday at 11:00 in K101 and Thursday at 3:00 in K116. 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: 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. |
| Week #7 Week of October 15th |
Please note the JavaScript examples added to last week - we looked at those examples in class
on Friday the 12th. I have to go to a conference this Thursday and Friday. I will be available Tuesday at 11:00 in K101 and Stephanie will have an open lab on Thursday from 9:00 - 11:00 and from 12:00 - 2:00. She knows Alice very well, so take advantage of these times to work on your Alice assignment or to get caught up. Between being sick and being away, I am behind in homework. Hopefully I will get caught up in the next week - sorry! Be sure that you have read through chapter #6 in the textbook. You should now be starting to read chapter #7. We will deal with logic examples including control breaks next week and included Alice in this discussion. 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 Assignments: 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. Mid semester quiz Mid semester quiz (word version) This is the answer sheet you must use to submit the quiz: Quiz answer sheet Quiz answer sheet (word version) |
| Week #6 Week of October 8th |
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. 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: Portfolio Project This week, I want you to start developing the pages that will form the structure of your portfolio. We will actually load it in about two weeks, so please have something ready by that time. |
| Week #5 Week of October 1st |
This week there will be a help/support lab with me at 11:00 on Tuesday in K101 and a series of
help/support labs on Thursday, October 4th from 9:00-11:00 and 12"00 to 2:00 in K101 with
Stephanie. A good time to get caught up! There will be no class on Friday. Please hold sending
homework while I am out this week (don't want my email to clog), I will be back after Columbus Day.
If you have questions, I will check my BCC account and the backup account. Please work on finishing chapter #4, reading chapter #5 and starting chapter #6. 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 Assignments: LOGO assignment #1:Logo assignment (due in 2 weeks) LOGO assignment #2: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). |
| Week #4 Week of September 24th |
Help/support lab Tuesday at 11:00 in K101. Please read chapters #3 and start reading chapter #4 this week. We will talk about complete programs and other topics in these chapters. Please check back! Assignments: Algorithm Assignment Will start in class I hope, depends on time for assignment below. 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! |
| Week #3 Week of September 17th |
Stephanie will be in the open lab at 11:00 in K101 on Tuesday. I will be in and out. 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. The logic quiz will be started in class - please do not start it until you have looked at the practice exercise. Logic quiz (word format) |
| Week #2 Week of September 10th |
I have asked that K-101 be reserved for 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. Until I hear otherwise, lets assume it worked
- if not I will go to K-112 and meet anyone that wants help in the main lab. I am going to review queries and the introduction to SQL on Tuesday, I will also build on what we have covered. 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. I am going to post the rest of the week after I see how we are doing. Please read chapter #2 in 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 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! |
| Week #1 Week of September 3rd |
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. 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 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. 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! |