| 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 Assignments Week of December 8th |
This Tuesday (the last week of classes), I am
going to hold an open lab in K101 from 9 to 3:30. This is a catch up day, so if you are behind try
very hard to come for as many hours as you can. This week we are going to take a look at spreadsheets - there is a PowerPoint using an older version of Excel, but the concepts are the same. I will post an extra credit assignment. Check back! I will post the final this week to give you a week to work on it. Since I was out sick on Thursday, I posted notes on spreadsheets covering what I planned to do in class - I will revisit on Friday. The notes are under the SmartBoard notes and here are the two spreadsheets I used. First grade spreadsheet example Second grade spreadsheet example Assignments: Extra credit: Excel assignment The status sheet is a requirement. It must be passed in with the final or before the final. Required status sheet Final Exam The final and the status sheet must be passed in prior to the official start of the final or you must come to the final and take or complete the final at the posted time. If you have questions, you can email me or come to any of my posted exams with questions. Questions I got: I got an email asking me about how I was using the word true in the Access queries. By true I mean it meets the criteria I am checking. If you have questions, email me! I got a question about #2, the read master is randomly reading a record to match the transaction. The random update PowerPoint that we looked at in class last week might help - see week #14 Presentation on random update processing. |
| Week #14 Assignments Week of December 1st |
I am available in K101 on Tues at 11 and from 2:00-2:30, Thurs at 11 and
at 3. Thursday I am also available around 5:30 in K102. Friday I am
avalable in my office at 11. Next Tuesday, we will have an all day help lab in K101. This week we are going to look at SQL in Access again and look at a little more VB. Please look at this information (the sheets about sequential and random are just work sheets - they are not to pass in. Sequential processing Random processing You should go over these presentations to help understand sequential and random processing: 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: Assignment on SQL and VB files You should use the database you did in week #12 for the SQL assignment - you do not have to develop a new database. 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 information Extra credit: Make 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 #13 Assignments Week of November 24th |
This Tuesday, the Tuesday of Thanksgiving week - I am
going to hold an open lab in K101 from 9 to 4 with some time away at 2 for
a meeting. This is a catch up day, so if you are behind try very hard to come for
as many hours as you can. |
| Week #12 Assignments Week of November 17th |
This is advisement week, so during the times I say I am available for help
I may have someone signed up for advisement. Sorry, but I do not know what slots are
taken. I am available for help/advisement at 11 and 2 on Tuesday in K101,
11 and 3 on Thursday in K101 and 6 on Thursday in K102. I am also available Friday at
11 and 1 in my office. Next week, the Tuesday of Thanksgiving week - I am
going to hold an open lab in K101 from 9 to 4 with some time away at 2 for
a meeting. This is a catch up day, so if you are behind try very hard to come for
as many hours as you can. We have some things to wrap up in Visual Basic - sequential files. We will do this the week after Thanksgiving. We have also started looking at relational databases - we are going to be going back to Access and implement some projects with multiple tables. 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 on relational databases and normalization (chapter #16) Assignments: Database assignment |
| Week #11 Assignments Week of November 10th |
Advisement starts this week. You can do online advisement with me using
the usual email address or you can sign up for advisement with me (K112)
or Sil Ferreira (K216) or Igor Kholodov (K211) or Janelle Arruda (networking) or
Raymond Steele (game). Even though you may have me listed as your advisor, you can
go to another member of the CIS Department for advisement. All of the CIS advisors have the transcripts and the information
to help you choose your Spring courses - please plan to see one of us. If you are in game, contact Raymond directly. Advisement check lists - please note these are not official (we have not caught any errors, but for official/confirmed information you should always check the catalog. Because it is advisement week, I will be available in the labs but I will also be doing advisement. Stephanie will be there as much as she can to provide additional support. Labs are Thursday at 11 in K101, Thursday at 6 in K102. I may have time at 3:00 as well, when I am not advising I will be in K-101. Friday I will be available for advisement and help from 1:00 until 4:00 - check my office (K112). This week we will continue with Visual Basic, looking at input, arrays, loops and files. Wednesday is Tuesday classes. I will be out, but Stephanie will be there to run a catch-up lab so please try to come and get help or just get caught up. Assignments: First VB assignment Remember with VB6, you need to send me the file with the .frm extension and the file with the .vbp extension. |
| Week #10 Assignments Week of November 3rd |
Be sure to get the number and code assignment in on time. It is due on
Sunday and late points will come off if it is not on time. Meditech presentation on campus, Thursday at 11 in K101 Help labs will be at 11 on Tuesday in K101,3 on Thursday in K101. Thursday I will be in K102 at 6:00. I am also available in my office at 11 on Friday. Rose Ferro is available at 10 on Wed in K101. Please read chapter #8. We will be continuing with Alice this week. Please look under examples at tbe Alice ballsbounce examples and the Alice programming power point that deals with the bouncing balls We will start to look at Visual Basic this week. I am using version 6 in the labs simply because it is easier to work with. If you have another version and prefer to use it I have versions through 2005 on my computer so any thing up to there is fine. 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. This quiz is based largely on the reading. Just checking... This quiz should be done individually with no discussion with other students. It is given on the honor system with my trust that you will not ask for or receive help from anyone other than me. You may consult books (I recommend your text book) and information on the web. If you feel that you should clarify your answer or clarify you interpretation of the question, please write a short explanation. 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) The mid-semester is due November 18, 2008 (late penalties apply and no resubmit). |
| Week #9 Assignments Week of October 27th |
I will be available Tuesday at 11 in K101. I am going to a conference for the rest of the week. Stephanie will
be here to help during class times so come and get help or work on projects. Rose is also available in K101 at
10 on Wednesday. We will finish up computer codes on Tuesday and I will introduce Alice. 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 Please read chapter #7 and look over Chapter #11 which talks about object-oriented programming. That is the style used in Alice. If you want to get in touch with me or turn in homework while I am gone, please send it to the regular address and send a copy to pgrocer@bristol.mass.edu. Assignments: Binary, hex, code assignment (html version) Binary, hex, code assignment (word processor version) 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. |
| Week #8 Assignments Week of October 20th |
Meditech presentation on campus I will be available Tuesday and Thursday at 11 in K101, Thursday at 3 in K101 and at 6 in K101 or K102. In addition I will be available Tuesday after 2:30ish and Friday at 11 and in the late afternoon in my office. Rose Ferro is also holding a support lab in K101 on Wednesday at 10:00. CIS17 students can come for help. We will continue to look at HTML and talk about the portfolio I want you to develop. References you might find helpful: HTML tutorial and commands List of CSS commands Here is information about using cisweb at BCC Talks more specifically about portfolio I will be sending you a password and login information. We will be dealing with numbering systems this week - a little break from programming while you finish your JavaScript assignments and work on your portfolio. Numbering systems and code Check back! 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 as a starting point. They are under examples at the web site. However, if you turn in something that has used my templates with very little modification, you cannot get an A on this assignment. If you are comfortable with HTML or would like to learn more about it, please work to make an interesting and professional site. All sites should be prepared with the idea that a future employer will be looking at it and evaluating you in part based on its content. Please note that this is an opportunity to earn extra credit if you do a really nice portfolio. Things you should include: a resume (you do not have to put personal information, you can use first name and the schools address etc - you do not have to put identifying information on the portfolio at this point unless you are comfortable with doing so). I want a picture of you - a face image or another image that would make sense to have on a work oriented portfolio. I want a list of computer course you have taken. I want you to link to a couple of examples of your work (let's try for five examples of work related to computing). You should include one working program written in JavaScript and you can upload an Access database. This is a long term project - due in three weeks. |
| Week #7 Week of October 13th |
Help/support lab Thursday at 11 and 3 in K101. Rose Ferro is also holding a support
lab in K101 on Wednesday at 10:00. CIS17 students can come for help. We are going to move on to looking at a little more about HTML. The goal is to start you creating a portfolio web site. We will spend more time on HTML next week. Look at my notes on the portfolio and my HTML notes under examples. I am going to be out on Friday (attending a state meeting), I would like you to take the opportunity to work with LOGO, I will introduce it on Thursday. Stephanie Chapman, who assists me on lots of projects, will be there for both classes on Friday. She knows LOGO really well and can help you get the project done, so I suggest you come! 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. Please look at the PowerPoint on LOGO and the handout on LOGO procedures. 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 #6 Week of October 6th |
Help/support lab Tuesday and Thursday at 11:00 in K101. Rose Ferro is also holding a help/support lab on
Wednesday at 10:00 in K101 which you are invited to go to for help in CIS17. I will be available on Thursday starting
around 5:30 or 6:00 until 7:00 in K102 Please be sure you have read the first 6 chapters. The book is providing supplemental material to what we are doing in class and is also important. 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 I have gotten questions about rounding in JavaScript. The following code would round a field called ans to two decimal places: ansrounded = Math.round(ans*100)/100; Some more JavaScript examples we are going to look at: simplejsif.html simplejsifloop.html simplejsifelse.html simplejsifelseloop.html simplejsand.html simplejsandloop.html Check back! Assignments: JavaScript assignment (due in two weeks) |
| Week #5 Week of September 29th |
Help/support lab Tuesday and Thursday at 11:00 in K101. Rose Ferro is also holding a help/support lab on
Wednesday at 10:00 in K102 which you are invited to go to for help in CIS17. I will be available until
around 5:00 on Tuesday (starting 3:00 ish) in my office and again on Thursday starting around 5:30 in K102. Please keep reading along in the text book You should read chapter #4 and then move on to chapter #5. Pseudocode examples Note missing end if has been added We are going to start looking at JavaScript this week.I would like to have you look at the JavaScript examples at my site. We are going to start learning to program in JavaScript 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 (version 1) Problem #1 in JavaScript (version 2) Problem #2 in JavaScript (version 1) Problem #2 in JavaScript (version 2) 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. Next I want you to start looking at the JavaScript programs. Go in under programs and scroll to the bottom. Assignments: Algorithm assignment Now take the problems in the Algorithm Assignment and write them in JavaScript. Due in two weeks. |
| Week #4 Week of September 22nd |
We have not been impacted by the eLearning problems at BCC - it does not relate to this course, so we will continue
with the course on the standard college schedule. Help/support lab Tuesday and Thursday 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. Flowcharts/pseudocode Please check back! Assignments: I posted a second assignment last week, that I said we would discuss this week. Here it is again: 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. 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 #3 Week of September 15th |
The extra credit assignment from last week (flowcharts and pseudocode) has be be passed in by Tuesday, September 16 (by 9:00 for
the 9:00 class, by 10:00 for everyone else). You can give it to me on paper in class or send it via email. 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. You can check my schedule or email me if you want to set up another appointment. 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) Practice exercise: Practice exercise Assignments: 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) Here is another assignment, that we will look at some more next week. If you have finished the quiz above work on it. 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. |
| Week #2 Week of September 8th |
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 be available during those hours and again at 2:00 on Tuesday in my office (K-112). If you have any advisement questions or questions about whether or not you are taking the right courses, come and see me! If you have any questions related to homework, come and see me! 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 - must be passed in before next Tuesdays class since I will go over it in class.) 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 September 1st |
Please check back often - I am setting up extra labs where students can come for questions
and help - the schedule is not available yet. 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! Note also that many of the tutorials are in different versions of Access. Prior to Access 2007, they all look very similar. Starting with Access 2007 there are some real changes. 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. You can also check the del.icio.us site (Access tutorials) 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 (probably next week). 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 or the higher Access 2007 default. Please check back every week to see if I have added anything! |