Information Technology Fluency II - CIT12

Weekly Schedule

During Finals: I will be in K101 on Monday at 2:45, Tuesday at 8:00 and Thursday at 10:15 for two hours each time.

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.
Week of May 11th
The final will be available by May 7th. It will be sent to all students who have completed enough work to pass the course and are therefore eligible to take the final. Students at BCC should contact me if they have not received the final by May 7th. If you question whether or not you should have received the final, but did not, this is the time to contact me so we can either talk or fix the mistake. The final is due back to me on May 13th. The required status sheet must be passed in with or before the final. I want the final returned to multiple addresses, I have provided them in the email with the final. Old Colony students are on a different schedule and will receive the final at a different time. The status sheet will also be posted by May 7th. It is required as part of the final - it must be turned in with the final or prior to taking the final. Again, it is a required part of the final and of the course. Please note: The final has been sent and is due by midnight on May 13th. Let me know if you have not received it. Required Status Sheet
Week #15
Week of May 4th
I will be around Tuesday at 11 and at 3, Thursday someone will be available from around 2:00 until 8:00 - I have a meeting for a short period but I will be there most of the time.
This week we are looking at how computing fits in with careers and finishing the portfolio.
Information about uploading your portfolio: Here is information about using cisweb at BCC
Talks more specifically about portfolio
There are two written assignments this week: 1)A paper on careers and 2)A paper on relational databases.
I want you to write a paper based on research into careers in computing:
1a) Health students: I would like you to do some research on how computers are used in your field. You need to write a paper dealing with three different areas that are relevant to your potential career. I want depth to the explanations.
1b) All other students: Write a research paper on how computers are used in a field you are considering. You need to deal with three different areas in which computers are used. I want depth to the explanations.
2) Assignment for everyone: Write a short paper researching relational database. Explain normalization and third normal form. Find an example and explain it.
Extra Credit: Extra Credit JavaScript
Week #14
Week of April 27th
Sorry, it is Tuesday and I am out sick.
I will be around for help Friday, May 1st from 3 to 7 and possibly from 1 or 2. 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 do some research on events in JavaScript. This is an address that I suggest: JavaScript events
Look at my JavaScript examples.
Find a good JavaScript tutorial and send me the address.
JavaScript events assignment
Check back!
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.
Assignments to turn in:
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 CIT11, should definitely make their own portfolio pages).
Then 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. Please do not put up identifying information.
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.
I want you to develop a portfolio using HTML. It should include links to some of your work.
JavaScript assignment
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 3 in K101. Friday I will be available at 11 in my office and a little after 1 until 7ish - check my office.
Check back!
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 April 5th
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.
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 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.
I lecture on Alice in CIS17, you can consider looking under the audio for CIS17 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.
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 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.
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.
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 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 Thursday at 11 in K101 in my office or K116. On Friday I am available at 11 and I may be available in the late afternoon. Contact me if you would like to meet me then. Next week is vacation, let's try to get caught up over vacation!
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
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
I want you to go to 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 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.
Sorry I have gotten behind in correcting - we all need to work on this - you getting assignments in and me getting them back! I have been out sick part of the week.
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.
Now we are going to look at StarLogo. We have looked at the logic of queries, but now soon we are going to move on to writing a program involving the three major steps of programming: sequence, selection, repeating or looping. The turtle in StarLogo can do all three of these and you will see the basic stuctures as you experiment with the package.
You will find a presentation under presentations and you will find a list of StarLogo commands under notes.
You should also look at the information about StarLogo procedures which you will find under Notes.
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:
Do not download and use the new version, use the standard version for this assignment.
Assignments (related to LOGO):
Logo assignment
Assignments (related to Access):
Please be sure that you populate the database tables before you do the queries.
Relational Queries
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 available during those times, so please drop in for help if you need it.
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
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 week I will have you implement this database in Access and do queries on this database.
Week #5
Week of February 16th
Help/support labs on Thursday at 11 in K112/K118 and 3:00 in K101.
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
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 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 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.
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 February 2nd
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.
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.
If you are not comfortable with Access, you have several resources you can use. There are a series of PowerPoint presentations that will take you through the basics for this assignment (note that they use a previous version of Access, but the logic is the same). You can use Access 2003 or Access 2007 to do your assignments. Under presentations - look for the one about asgn #1 and if statements. There is also a sample database that you can download under examples. You can also choose to get a book on Access. Finally, there are many tutorials on line - some of which are listed under or links.
Practice exercise The solution to the database is on the web (prior to Access 2007) - the queries in the solution on the web are not the same - if you have questions on the queries, contact me and I will send you the solution. Again this is a practice exercise that you can choose to do to develop comfort with Access - you should definately go over the solution and make sure you are comfortable with it.
If you decide to use Access 2007, here are two tutorials you might try:
Access 2007 in pictures
Tutorial at Microsoft
Access tutorial (document)
Sorry this week has been a very, very full and I am behind in homework. Hopefully I will get caught up this weekend.
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 January 26th
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.
Please note that I added some things from the original posting last week.
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)
Please take this quiz. This 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.
Check back, I am not sure this is complete.
Week #1
Week of January 19th
Please note that some students who are not on campus have requested that several weeks worth of work be loaded at the beginning. For students following the regular schedule, please follow the week of information. You are welcome to work ahead, but note that sometimes after seeing the results from a week, I change something for the following week, so the week of information is not final until the week has passed. It should always check the information for the week that is current.
If you are in the one of the health options, then I am going to ask you to focus on that as you do the assignments throughout the course. In other words, when I ask you to do searches or make web pages or databases, please make anything that is open apply to your field of study. This will help to make this course even more relevant to what you are studying.
The Fluency with Information Technology text is required (it was the text used in CIT11). At various times, I will ask you to take a picture of the screen. If you do not know how, this site may help: Print Screen
Please read the pages under About This Course which include Introduction to CIT12 and the Syllabus.
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
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!


Send e-mail to Mrs. Grocer:

Back to the Top
Return to home page
Return to previous page