| 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. |
|---|---|
| Final Week of May 11th |
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. Your final is scheduled for 05/12/09 at 8:00 AM in K101. That means it needs to be emailed to me at my usual address, at grocer2009@yahoo.com and to pgrocer@bristol.mass.edu prior to the start of the final. If you have questions, you can email me or come to any of my posted exams with questions. |
| Week #15 Week of May 4th |
Check back on Monday for information about final. This week we will look at Spreadsheets - check back First grade spreadsheet example Second grade spreadsheet example Assignments: Extra credit: Excel assignment |
| Week #14 Week of April 27th |
I will be around for help Friday, May 1st from 3 to 7 and someone will be available starting at 1 (I will
be there much of the time from 1-3. I will be available
Tuesday at 11 and at 2, Thursday at 11 and 3 and Friday at 11 as well as in the afternoon and evening.
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 This is a week to get caught up! You can do the sequential and random processing as a check off for extra credit. |
| Week #13 Week of April 20th |
This week I will be available Tuesday at 11 and then there will be someone available from 2 to 9 or 9:30
at night. I will be there most of the time, but I have to go to a meeting for about an hour. Andrew and Stephanie will
be there to help as well. After about 6:45 we will need to move to another
lab, so check around, I will be in a lab. I will also be available Friday at 11 in my office. If you have any questions about Visual Basic, let me know. 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: For the assignment below, set up and populate the tables and do the queries. First Database assignment - student DB |
| Week #12 Week of April 13th |
This week I will be available on Friday night until a little after 7:00 and next
week I will stay on Tuesday night (April 21st) until around 9:00. If you need help I would
plan to come one or both of these. The room number I am in will be posted on my office
door (K112). This week I will be mixing advising and help. I will be available Monday at 2
in my office and I will hopefully be available a little after 4 on Monday as well. I will be available Tuesday at
11 in K101 and after 2 in K101 as well. You can come for help or early advising. Thursday
I will be available at 11 in my office and at 1 in K101. Friday I will be available at 11
in my office and a little after 3 until 7ish - check my office. This week we will continue with Visual Basic. You need to look at the program examples on loops, on the array, on the guess game and on file handling. Assignments: Second VB Assignment |
| Week #11 Week of April 6th |
I am available on Tuesday at 11 in K101 and 3 (my office or K101), Thursday at 11 in my office or
K118 and 3 in K101, Friday at 11 in my office or 2:30ish in K101. We are working with Visual Basic (version 6) this week. Please look at the examples, I will post the assignment on VB on Thursday night. Check back! Assignments: This quiz is based largely on the reading. Just checking to make sure you are doing the reading. 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. Textbook quiz This is the answer sheet you must use to submit the quiz: Textbook quiz answer sheet Textbook quiz answer sheet (word version) The Textbook quiz is due April 17, 2008 (late penalties apply and no resubmit) Visual Basic Assignment:The algorithm assignment was originally given in week #5. You then wrote those programs in JavaScript. Now I want you to write them in Visual Basic. Please note that there were two Alice assignments last week. One was done in class for in class students. |
| Week #10 Week of March 30th |
I will be available Tuesday at 11:00 in K101, Tuesday at 3:00 in my office or in
a lab. Thursday I am available at 11:00 in my office or a lab and at 3:00 in K101. Friday you need to contact
me for availability. If those times don't work, contact me and we can try to set up something else. If I were to schedule a Saturday in April, would that help. I need to here back from you if you would like me to do that. Mid semester status sheet We will start this week by looking at computer codes and taking questions on binary and hex. We will also look at some basic information from the text. In the text we will look at some information from chapters #8, #10, #11 and #14 in the next couple of weeks, so I recommend reading these chapters in addition to chapters #1 - #6. 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 As you read about object-oriented programming, relate it to Alice. That is the style used in Alice. Assignments: First 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. This will probably get done in class. Second Alice Assignment: I want you to write a program using modules/methods, 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/method, a process module/method that handles other modules/methods and a wrapup module/method. Look at my examples (zipped copies of the programs) and PowerPoints on ballsbounce to help with this assignment. |
| Week #9 Week of March 23rd |
I will be available Tuesday at 11:00 in K101. I will also be available Thursday at 11
in my office of K118 and at 3 in K101. Friday I am available at 11 in my office and
after 3 in my office or in a lab. Check with me for times if you are interested in staying Friday. Friday I am working with the college on a project to bring middle school students to the college. So we will not have a class on Friday, but any of you that are interested in earing credit towards a service learning project are invited to come and help. The hours are 9-11. 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. Here is information about using cisweb at BCC Talks more specifically about portfolio Numbering systems and code Assignments: I want you to put up the beginnings of a portfolio written in HTML. 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 - first draft due in three weeks. Binary and Hexidecimal Assignment |
| Vacation Week of March 16th |
Have a productive vacation and wish me the same! Please be sure to check this list of scholarships. They are a great way to help with tuition. Scholarship Opportunities at BCC |
| Week #8 Week of March 9th |
Tuesday of this week will be an open lab in K101. No classes are scheduled. Please come for as long as you can if you are
not caught up in your work! I will be available on Thursday and Friday at 11. I may be available late on Friday, let
me know if you would like to meet with me then. 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. 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 #7 Week of March 2nd |
I have a student who can provide help on Monday from 12 to 2, on Tuesday from 1 to 2, on
Wednesday from 12 to 2, on Thursday from 10 to 12 and on Friday from 1 to 2. If you would benefit
from help at any of these times, you need to send me the times you are available and permission
to give the student your email. This week I am available at 11 and 2 on Tues in K101, 11 on Thurs in K118/K112, 3 on Thurs in K101, and Fri at 11 in K112. We are going to continue with JavaScript. We will look at the examples from last week first and then we will look at the logic and code for the guess game. The JavaScript programs are: Guess number, one guess Guess number, one game Guess number, multiple games Assignments: Sorry I have gotten behind in correcting - we all need to work on this - you getting assignments in and me getting them back! I was out sick this week as well, I missed Thursday. Assignments: JavaScript assignment |
| Week #6 Week of February 23rd |
I have a student who can provide help on Monday from 12 to 2, on Tuesday from 1 to 2, on
Wednesday from 12 to 2, on Thursday from 10 to 12 and on Friday from 1 to 2. If you would benefit
from help at any of these times, you need to send me the times you are available and permission
to give the student your email. This week I am available at 11 on Tues in K101 and 11 on Thurs in K118/K112. I will be out on Friday at a conference. However the classroom will be available at 9, 10, 12 and 1 and I will have a student that can provide help covering the class, so come during any of those times. Please read chapter #6 in the text book. 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: I want you to work on the JavaScript for the Algorithms that I assigned last week. This is a catchup week! |
| Week #5 Week of February 16th |
Help/support labs on Thursday at 11 in K112/K118 and 3:00 in K101. Please read chapters #4 and move on to chapter #5. The book is providing supplemental material to what we are doing in class and is also important. Pseudocode examples These go with last weeks in class exercise. 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: For students who were not in class last Friday (people that were there signed an attendance list), this assignment must be done. Students who were there, did flowcharting in class. Alternative flowcharts For everyone: Please write out the solutions to the algorithm problems in words and then in a second chart test them with numbers: Algorithm assignment Now take the problems in the Algorithm Assignment and write them in JavaScript. You need to get them working so that if you put in test numbers, you see the correct results. |
| Week #4 Week of February 9th |
Help/support lab Tuesday at 11:00 in K101 and also at 2:00 in my office. Thursday I am available at
11 in my office. If you need to see me and these times don't work contact me and we can try to figure
something out. 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 Check back and see where we are and if I post anything additional.! 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. It is due at the end of this week (by February 15th). Note that there are no resubmits on this quiz and the quiz should be done individually. 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 February 2nd |
The extra credit assignment from last week (flowcharts and pseudocode) has be be passed in by Tuesday, February 3rd by 10:00.
You can give it to me on paper in class or send it via email. I am available Tuesday at 11 in K101. I am also available Thursday at 11 and at 3 (my office K112) and on Friday at 11 and 1-1:30 (my office). Note there may be a note on my door telling you I am in a lab. We will start the week working on the logic we looked at last week and looking at loop structures. Last week I forgot to go over Forms and Reports. Please note that there are PowerPoints that go over it and if you have questions, ask Tuesday. 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) Note: The assignment below will be given next week (the best we will get to this week is starting it). Here is another assignment, that we will look at some Tthis week and into 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 January 26th |
Interesting offer to check. Microsoft Ulitmate Steal Promotion This week there will be an open lab at 11:00 in K101 on Tuesday. I am also available for help at 3:00 on Tuesday and on Thursday and Friday at 11:00. On those days, please come to my office in K-112. 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. Depending on time, I may 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. 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! When you pass in an assignment, please put your name, course and which assignment it is in the subject line. As always, please check back! |
| Week #1 Week of January 19th |
Please check back often each week, I may add things during the week. 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! |