| Week | Information |
|---|---|
| Assignments due in one week unless otherwise stated. I may add some things during the week, so double check the schedule each week! Please keep copies of all work you submit until you receive your final grade at the end of the semester. | |
| After finals | I have spent the last week at the hospital in NY because of serious complications with the birth of my granddaughter, so my grades will not be posted for about a week. I am working on them slowly, I just did not want you to be concerned. |
| Week #15 Week of December 12th |
I will not be in this week, for family reasons. Just rechecked the calendar and Friday is officially the last day of classes. I can be contacted via email and Mark and Wayne will be there for all of my classes to help with any problems. There will be an open lab from 9:30 to 3:15 on Tues and Thurs and Mark and Wayne will be there for help. The final will be posted along with the required status sheet by Tuesday the 13th. Your final and status sheet need to be emailed to me before 10:30AM on Tuesday the 20th. Note that I do not correct the final until I receive the status sheet. Final Exam and Required Status Sheet: Final Exam CIT122 Required Status Sheet |
| Week #14 Week of December 5th |
Information about uploading your portfolio:
Here is information about using cisweb at BCC Talks more specifically about portfolio Please do some research on events in JavaScript. This is an address that I suggest: JavaScript events Look at my JavaScript examples. Assignments: Find a good JavaScript tutorial and send me the address. JavaScript events assignment |
| Week #13 Week of November 28th |
Monday I will be available at 10 in my office (K112) Tuesday I will be available from 1:45 until 3:15 in K101 and until 4:30 or 5 in my office. Thursday I will be available from 1:45 until 2:35ish in K101. We are continuing with JavaScript and looking at developing or adding to a portfolio. Portfolio Information: Portfolio information Templates for portfolio (can make your own or modify these - extra credit if you make your own): Students who have prior experience with HTML (other than CIT121, should definitely make their own portfolio pages). index.html portfoliotablecontents.html Assignments to turn in: First (this is due by the end of the semester): Develop a portfolio that would be helpful to you in looking for a job. It should contain information about you (you can eliminate identifying information if you want to). You should upload some samples of your work and have the table of contents above point to these examples. You can use Brinkster for your portfolio or you can use a cisweb site if you have an address. Please let me know if you would like room on the cisweb server at BCC and I will get you a username and password. Second: I want you to write a short paper (about a page) on whether you enjoyed using Alice, whether you think it gets the idea of programming across, and what you learned about programming from experimenting with Alice. Third: JavaScript assignment |
| Week #12 Week of November 21st |
I will be around Tues afternoon from 1:45 to 5 (until 3:15 in K101 and then my office K112). Monday I am available at 10. We are continuing to look at JavaScript. I suggest finding a good tutorial. One of my students recommends this one. JavaScript tutorial recommended by a student. Remember (from last weeks tutorials), W3schools also has some excellent resouces to help with JavaScript. Assignments to turn in: Go back and look at the algorithm assignment you did in week #1, I would like you to do this assignment using JavaScript. You need to get all 4 programs working and send them to me. |
| Week #11 Week of November 14th |
I am available for help on Tues and Thurs from 1:45 until 3:15 in K101 and I stay until around 6ish on Thursday in my
office (K112). If you need hep, please come by. I want you to start looking at the JavaScript examples under JavaScript Introduction. Remember, when you look at the page and click on source you can see the source code that created the page. I want you to read about JavaScript in the text book and you will also find resources at my site. Tutorial on JavaScript Another JavaScript tutorial Looks like a good JavaScript tutorial Assignments to turn in: Java Script Quiz #1 To do this assignment, copy the JavaScript in the quiz to notepad and save it with a .html extension. Then make the changes I asked for and open it in a browser window to view the results. |
| Week #10 Week of November 7th |
I will be available for help Monday at 10 in K112 and Tues at 1:45 in K101 - check back about Thursday. I lecture on Alice in CIS120/17, you can consider looking under the audio for CIS120/17 for information. There will also be accompanying Smartboard notes. If you start Alice, the tutorial #1 with the ice skater is a good aid as well. I want to spend more time with Alice this week and I want to start looking at it as a a programming language. Please look at the PowerPoint example and the zipped examples of bouncing balls. I am going to be asking you to write an Alice that has housekeeping/processing/wrapup and other modules as I did in my examples. I just hope you are more creative!!! ballsbounce examples zipped Alice programming If you go to presentations, you can get a zipped version of this presentation that might be easier to see. Assignments: 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 and randomnumber to help with this assignment. Check back! |
| Week #9 Week of October 31st |
Please remember I am available for help Tuesday and Thursday afternoons usually starting at 1:45. And I have an office hour at 10 on Monday.
If you need help and those do not work, let me know. Looking back at Access: Please look at the PowerPoint presentations under Access and Access SQL - I think they will answer a lot of questions and problems that you are having. If you do not remember how to develop a web page in HTML from the CIT11 course, please review the concepts. When we come to looking at JavaScript in a few weeks remembering HTML will be important. In week #8, we looked at writing simple scripts/programs to direct a turtle. This week we are going to look at progamming with Alice. I want you to look at this PowerPoint presentation on Alice: Using Alice Zipped version of Using Alice for download Then I want you to spend time with Alice experimenting with the different things that you can do and looking at the other tutorials etc. Alice is available at Alice site If you want to download Alice to work at home, please download version 2.0. Assignments: 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 Week of October 24th |
I am available for help Thursday afternoon from 1:45 until around 6 (I have a tentative meeting I might have to
leave for (hour max), but I think I am all set. I would like you to have read (skimmed the more advanced chapters), the chapters on databases in your text book. We are not covering some of the more advanced topics which is why I suggested you could skim them. Look at the presentation on if statements and flowcharting if statements: Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Interesting sites for health care people - I would like to know what you think of them. Medical Library Association One persons analysis of health care information on the web Assignments: Logic Flowcharts: Draw the logic flowcharts for the queries you did in the query assignment for week #4. You only have to do the if portion of a flowchart, similiar to what I did in the presentation. Note that #1 does not have an if, you can just write the box to process. Query assignment from week #4 You can do a flowchart using symbols in PowerPoint, Word (please save a a doc version), or you can use Visio which came with your book or you can use Impress which comes from Open Office and is free. I want you to go to del.icio.us and set up an online bookmark storage area. Then please find and bookmark 3 tutorials on HTML and then send me the address of your bookmark site. If you already have a site, simply add to it. |
| Week #7 Week of October 17th |
I am available for help on Tuesday from 1:45 until 3:15 in K101 and in my office later, on Thursday from 1:45 until 3:15 in K101
and in my office later (I will be around until around 6:00 with a one hour meeting I think mixed in there. You should have read the chapters on Access in the text book and checked some web sites on Access. You should also have read about relational databases and normalization including my PowerPoints on the subject. I decided to wait since there were a lot of questions on queries. Assignments (related to Access): Please be sure that you populate the database tables before you do the queries. Relational Queries |
| Week #6 Week of October 10th |
I want to start looking at the concepts of relational databases so
I am going to ask you to set up two samples that I have created that will
illustrate the set up of relational databases. I want you to go over these two presentations carefully to help understand the concepts. Normalization - information on third normal form Separate speaker notes to accompany normalization presentation Relational database using donor Separate speaker notes to accompany relational databse using donors presentation I would also like you to read this very over simplified version of a database for a medical clinic: Medical clinic example Assignments: These two examples lead you through setting up a a set of tables that are related. Please do the two examples in Access and send them to me. Student database Payroll database example I want you to design the following database: More complex student database to design Next unit I will have you implement this database in Access and do queries on this database. |
| Week #5 Week of October 3rd |
This week I have office hours at 10 on Monday in K112 and I will be in K101 on Tues from 1:45 until 2:30. Zipped version of Access 2007 Introduction I want you to do some more research on Access and on SQL, looking for tutorials and other explanations that help you understand. Here are a few possibilities: W3Schools SQL Another SQL tutorial I want you to look at the presentations under Access and SQL because I want you to experiment with SQL this week. I would also like you to look at the two presentations under Access and SQL. The presentations are: 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 Here are some notes on SQL including Smartboard and audio: Intro SQL in Access (1/27/09) in PDF format Accompanying audio Intro SQL in Access (1/27/09) in PowerPoint Accompanying audio Intro SQL in Access (1/27/09) Accompanying Smartboard presentation Look at the presentation on if statements: Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Assignments: Assignment #1: Using the same database that you used for the last two weeks, I want you to write five SQL queries. You should write them and send me a text file containing the code you wrote. You should also test them in Access and send me the Access database with the five SQL queries numbered SQL1 through SQL5a and SQL5b. Note that I do not want unneeded parenthesis in your code. Problem #1: Show three fields and test one of them with a criteria. Problem #2: Show some of the fields and test two things in an AND relationship. Problem #3: Show some of the fields and test two things in an OR relationship. Problem #4: Show all of the fields. You are testing for three things to be true OR just one thing to be true. Problem #5: Show all of the fields and test three things. The first thing must always be true and then either of the other two must be true. Write the SQL two ways. |
| Week #4 Week of September 26th |
I will be available for help Tues and Thurs afternoon. On Tues I am available from 1:45 until 2:30 and on Thurs I am available from 1:45
until 3:00 and then from 4:00ish until around 6:00 for anyone who wants some help. Hopefully I will be in
K101, if not look for me in my office (K112)and we will find a lab. The late hours on Thurs will be my office. I also have an office hour at 10:00 on Monday in my office. Please read the chapter on database queries. In the current text it is chapter #16 A Table with a View: Database Queries. In previous versions it might be chapter #15 or chapter #14. You are looking for the chapter on Database Queries. Continue to look at the things you can do with Access. Be sure to look at the presentation on if queries in Access (Presentation for if queries in Access). You should be receiving or have received an invitation to join the MSDN Alliance at your BCC account - if you do not get it, let me know. For information about software for this course: MSDN Alliance Software I have put notes from a inclass session on the web under notes. The notes are mostly on Access but also have comments on one of the algorithms. Assignments: Query assignment Please note, I do not want you using the wizard for any of your queries. I want you to learn to do the queries by working out the logic yourself. |
| Week #3 Week of September 19th |
I will be available for help Tues and Thurs afternoon. On Tues I am available from 1:45 until 3:15 and on Thurs I am available from 1:45
until 3:30 and then from 4:30 until around 6:00 for anyone who wants some help. Hopefully I will be in
K101, if not look for me in my office (K112)and we will find a lab. The late hours on Thurs will be my office. The reading depends on what version of the book you have. Essentially I want you to read about databases. In the third edition, read chapter #16 A table with a view: database queries. In edition two they have two chapters #14 which is getting to first base: introduction to database concepts and #15 which is a table with a view: database queries. Information about Access available at various parts of my site: Zipped version of Access 2007 Introduction Access 2007 Inventory example Assignment #1 for Access 2007 in pdf format Presentation for if queries in Access Separate speaker notes to accompany if queries in Access Creating a DB in Access 2007 Zipped Donor DB and PowerPoint First11.accdb (database sample version 1) DBSept11.accdb (database sample version 2) Assignments: Part 1 of the assignment: Develop a table that would be useful to you in your professional or personal life. I want you to define a table and enter data into the table (should be a mixture of text and numeric data). Explain why you made each field the type and size you decided on. Populate the table. The next set of notes and assignments will have you query the table you created. If you are in a medical/health major, you should design a table related to your area of study. In developing your database please note the following guidelines: (1) field names should not have embedded spaces and special characters other than Underscore (most database systems are very strict about this and I want you to be aware of this), (2) use appropriate types of data (text vs numbers) and be sure to pick appropriate sizes, (3) designate a primary key that uniquely identifies each record. Part 2 of the assignment: Once you have developed the table I want you to do three queries: (1) Display 4 fields and have them meet a certain criteria. For example, if state is one of your fields you could display only those that have "MA" in their state. (2) Display records that meet two criteria in an AND relationship. (3) Display records that meet two criteria in an OR relationship. |
| Week #2 Week of September 12th |
I will be available for help Tues and Thurs afternoon from 1:45 until 3:15 for anyone who wants some help. Hopefully I will be in
K101, if not look for me in K112 and we will find a lab. Please read the chapters on Social Implications of IT and Privacy and Digital Security. We will be starting Access next. If you do not have Access available you can download it using the MSDN Alliance. You should be getting your invitation soon. I would like you to do some reading about copyright and fair use. Some suggested sites are: University of Maryland Copyright and Fair Use Stanford Copyright and Fair Use Copyright crash course If you are in HealthCare Information, please read the following: Medical Library Association on copyright and fair use I would also like you to read some information on computer ethics: The Ten Commandments of Computer Ethics ACM code of ethics Computer Ethics (explore some of the information at this site) Assignments: Please take this quiz. The quiz is a check off assignment and not a graded assignment so be honest and test yourself. Tell me which ones you got right and which ones you got wrong. Quiz on copyright and fair use When you pass in work, please put your name, course and which assignment it is on the subject line. Write a short paper explaining copyright, fair use and ethics related to computing in a way that could be put in a company handbook. If you are in healthcare, please consider that when you write your paper. |
| Week #1 Week of September 5th |
If you need help on something, please don't hesitate to send me your partially done assignment and ask
for help. You should also know that I take resubmissions on homework and in fact frequently ask you to
resubmit if I think you need to understand the material better. I will post times when I am available for help on the schedule on my home page and I will let you know when I am holding help labs. I know that different people have different versions of the book. I would like you to review the chapters on Algorithmic Thinking and on Representing Multimedia Digitally. You should also check this site for a definition of algorithm and more explanation. Algorithm at Answers.com One definition of an algorithm Some of my examples Assignment: Do the following assignment: Algorithm Assignment #1 Please email me this assignment. I want you to follow my model and lay out the processing steps and then, still following my model, test using test data you make up. In my example I tested using the numbers 49 and 24. If you have problems with this assignment, we can go over it via email or in person. Send me your best effort and I will try to help. Check back! |