Joe Chung
Monmouth U. Homepage

DUE DATE: Mon, 9/8

Create your student web page on rockhopper.

On your web page, create a hyperlink to a separate page, specifically for CS 102 (cs102.html). The cs102.html file that you create will be your course journal and will count toward your final grade for assignments. After each week of the course, you will be required to post a brief summary (no more than 100 words) of what was covered in class that week.

By Monday, you should have posted on your CS 102 web page a brief summary of what was covered in class in the first week.

• Example student web page and course journal from previous class:

       http://rockhopper.monmouth.edu/~s0579471
       |
       |-> http://rockhopper.monmouth.edu/~s0579471/cs102.html

1. Complete word processing lab assignment 1 - Basics (handout)

2. Complete word processing lab assignment 2 - Equations and graphics (handout)

DUE DATE: Wed, 9/10

DUE DATE: Fri, 9/12

In 300-500 words, describe Monmouth University's official policy on Internet downloads. List the references you used at the end of your document. Possible references are the student handbook and the University's web site.

Use a word processor to complete the assignment. If using Microsoft Word 2007, be sure to save in the Word97-2003 file format. Use the word count function of the word processor to make sure you have between 300-500 words. SPELL CHECK and GRAMMAR CHECK the document.

Do not email me the document. Instead, save the file to your Z: drive's cs102 folder, under a new subfolder “weekly”. Save the assignment to that folder as “cs102weekly1.doc”. If you're working off campus and want to transfer the file to your Z: drive, see

http://rockhopper.monmouth.edu/cshelp/Remote_file_management

DUE DATE: Monday, 9/15/08.

1. Add an image to your student home page directory (rockhopper:~/public_html). Then add the image to your student home page (index.html).

2. Also, on your student home page (index.html), create an unordered list of links to at least 5 external web sites. Example:

My Links

• 2005 World Champions
• A Linux-related software tracking page
• Themes for Unix/Linux/Other
• Quit Slashdot
• Linux news page

DUE DATE: Fri, 9/19

• Spreadsheet lab assignment 1 - Excel Chart (handout)
• Spreadsheet lab assignment 2 - Turboprop (handout)
• Spreadsheet lab assignment 3 - Body Mass Index (handout)

DUE DATE: Mon, 9/22

Do research on the environmental impact of manufacturing and using computers. Write 300-500 words on the results of your research. Include a chart in the word processor document that shows in some way the environmental impact of computer usage and computer manufacturing. Cite the information sources you used using a list of references. You may copy and paste the chart from the Web as long you cite and list your source.

Use a word processor to complete the assignment. If using Microsoft Word 2007, be sure to save in the Word97-2003 file format. Use the word count function of the word processor to make sure you have between 300-500 words. SPELL CHECK and GRAMMAR CHECK the document.

Do not email me the document. Instead, save the file to your Z: drive's cs102 folder, under a new subfolder “weekly”. Save the assignment to that folder as “cs102weekly2.doc”.

DUE DATE: Wed, 9/24

• Spreadsheet lab assignment 4 - Cable Car Velocity (handout)
• Spreadsheet lab assignment 5 - Plotting Polar Equations (handout)

DUE DATE: Mon, 9/29

• Spreadsheet lab assignment 6 - Coin Toss Simulation (handout)
• Spreadsheet lab assignment 7 - More Random Numbers (handout)

DUE DATE: Fri, 10/3

• Spreadsheet lab assignment 7b - Pair Of Dice (handout)
• Spreadsheet lab assignment 8 - Climatology (handout)

DUE DATE: Mon, 10/13

In 300-500 words, discuss the concept of the “digital divide,” including some policies or efforts that have been proposed and tried in order to eliminate or lesson the digital divide.

Use a word processor to complete the assignment. If using Microsoft Word 2007, be sure to save in the Word97-2003 file format. Use the word count function of the word processor to make sure you have between 300-500 words. SPELL CHECK and GRAMMAR CHECK the document.

Do not email me the document. Instead, save the file to your Z: drive's cs102 folder, under a new subfolder “weekly”. Save the assignment to that folder as “cs102weekly3.doc”.

DUE DATE: Wed, 10/15

• Excel lab assignment 9 - “Let's Make a Deal” simulation

In a popular 70's game show, a contestant would be shown three closed doors. Behind one of the doors would be a brand new car, and behind the other two doors would be goats. The contestant would initially pick one of the doors, but the door would not be opened. Instead, the host would open one of the other doors to reveal a goat. Then the contestant would be given the choice to stay with his original pick of doors or to switch to the other closed door to try to win the brand new car. If you were a contestant on the gameshow, which strategy would you choose, stay or switch, to win the car? Explain your choice of strategy.

In your spreadsheet, you'll perform some large number of simulations of “Let's Make a Deal.” (200 is probably a sufficient number of simulations.) In the simulations, you'll stay with the original choice of doors 200 times, and then you'll switch to the other door 200 times. Count the number of times you win the game with both of these strategies.

Note: Make sure that your name and the assignment number appears in any printouts that you are required to submit.

Due date: Wed, 10/22

Database Lab 1 - Create and Sort ( handout)

• Save all work (PDF files) to the Z:\cs102\db\lab1 folder.

Database Lab 2 - Filters and Queries ( handout)

• Save all work (PDF files) to the Z:\cs102\db\lab2 folder.

DUE DATE: Mon, 10/27

In 300-500 words, discuss what Digital Rights Management (DRM) is and how it impacts (or could impact) the media (CDs, DVDs, mp3 players, etc.) and software that you use. List the references/information sources you used.

Use a word processor to complete the assignment. If using Microsoft Word 2007, be sure to save in the Word97-2003 file format. Use the word count function of the word processor to make sure you have between 300-500 words. SPELL CHECK and GRAMMAR CHECK the document.

Do not email me the document. Instead, save the file to your Z: drive's cs102 folder, under a new subfolder “weekly”. Save the assignment to that folder as “cs102weekly4.doc”.

Due: Monday, 10/27

• Save all work to the Z:\cs102\db\lab3 folder.

Download the following comma-delimited file which contains demographic data on all counties in the United States for 1990-1999:

http://rockhopper.monmouth.edu/~jchung/cs102/counties.txt

Import the text file into Excel and save as a DBase IV file (dbf).

Import the dbf file into Access.

Using Access queries, answer the following questions in a Word file called cs102dblab3.doc.

1) What is the loneliest county in the continental U.S. (in terms of population density = 1999 population divided by area (given in square miles))?

2) What is the most fertile county (kids, age 17 and under, as a percentage of the total 1999 population?)

3) What is the least fertile?

4) What percentage of single-parent households (1_M_HOUSEH and 1_F_HOUSEH) in the U.S. are headed by women (1_F_HOUSEH)?

5) Ranking the states, New Jersey ranks in what place in percentage of single-parent households headed by men?

6) Ranking the 100 largest counties (in terms of 1999 population), New York County (Manhattan) ranks in what place in percentage of single-parent households headed by women?

7) Where is divorce most prevalent, that is, what are the five counties in the U.S. with the highest proportion of divorcees [ divorced / (divorced + married + separated + widowed) ]?

8) Where is divorce least prevalent, that is, which five counties have the lowest proportion of divorcees?

9) Which county and which state have the greatest number of mobile homes?

Due: Wednesday, 10/29

• Save all work to the Z:\cs102\db\lab4 folder.

Download the following Excel data file:

(Poverty in school districts, estimated 1995, from U.S. Census Bureau)

http://rockhopper.monmouth.edu/~jchung/cs102/poverty.xls

Open poverty.xls in Access. Generate and save the following reports as PDF files. In each report, include the states that the school districts are in, if applicable.

a) The 25 most populous school districts in terms of total number of people. (create dblab4a.pdf)

b) The 25 most populous school districts in terms of total number of kids. (create dblab4b.pdf)

c) All the states (including Washington D.C.) ranked by proportion of poor kids to all kids. (poor kids / kids) (dblab4c.pdf)

d) Top 25 school districts ranked by proportion of poor kids to all kids. (poor kids / kids, where kids > 0) (dblab4d.pdf)

e) Top 25 school districts in New Jersey ranked by proportion of poor kids to all kids. (dblab4e.pdf)

Make sure that your name is on the reports that you generate.

Due: Wednesday, 11/5

Save all work to the Z:\cs102\db\lab5 folder.

1. Download this Excel file containing [USEPA Toxic Release Inventory] data for 2003 in New Jersey:

http://rockhopper.monmouth.edu/~jchung/cs102/tri2003_reduced.xls

2. Open the file in Access to generate a link to the data file.

3. Generate and save the following reports as PDF files (reports should include the amount in pounds of toxic chemicals released and the city and county names where applicable):

(Toxic chemical releases are in pounds.)

(Generate the reports as dblab5a.pdf - dblab5f.pdf)

a) The top 10 individual emitters of the chemical Benzene in the State of NJ in 2003.

b) The top 5 NJ counties with the greatest releases of Chromium & Chromium compounds in 2003.

c) The top 5 NJ cities with the greatest releases of the chemical Ethylene Oxide in 2003.

d) The top emitters of toxic chemicals in your home zip code. (If your home zip code is not in the database, use zip code 08818.)

e) The 10 most emitted toxic chemicals in Monmouth County. (All chemicals in the database are considered toxic.)

f) Total emissions of toxic chemicals from NJ's 11 northern counties: Bergen, Essex, Hudson, Hunterdon, Middlesex, Monmouth, Morris, Somerset, Sussex, Union, Warren. What percentage of NJ's total toxic chemical releases come from just the 11 northern counties?

Make sure that your name is on the reports that you generate.

Due: Wednesday, 11/5

Save ALL work to the Z:\cs102\db\lab6 folder.

• Download the older 1995 NJ Toxic Release Inventory database and open in Access,

 http://rockhopper.monmouth.edu/~jchung/cs102/fa05/access/form95.dbf 

(Look for the TOTREL field in the 1995 table.)

• Import the 2003 NJ TRI data table into the same database as a new table,

 http://rockhopper.monmouth.edu/~jchung/cs102/tri2003_reduced.xls

• Generate and print the following reports as PDF files:

Hints: For numbers 1-4, you'll need to create intermediate queries for 1995 and 2003. For number 2, you may be thrown off by the fact that there were no emissions reported for Cape May County in 1995.

1. The total toxic releases for the entire state of NJ in 2003 and 1995 and the change in lbs. between 1995 and 2003.

2. The 21 NJ counties and their change in toxic releases between 1995 and 2003 as a percent increase or decrease ( (2003-1995)/1995 ).

3. Top 20 toxic chemicals in NJ in terms of percent reduction from 1995 to 2003 ( (2003totrel-1995totrel)/1995totrel is negative).

4. Top 20 toxic chemicals in NJ in terms of percent increase from 1995 to 2003 ( (2003totrel-1995totrel)/1995totrel is positive).

DUE DATE: Fri, 11/14

In 300-500 words, discuss how widely used e-voting (electronic voting) is in the United States and around the world. Also, discuss the potential problems with and common objections to the use of e-voting. List the references/information sources you used.

Use a word processor to complete the assignment. If using Microsoft Word 2007, be sure to save in the Word97-2003 file format. Use the word count function of the word processor to make sure you have between 300-500 words. SPELL CHECK and GRAMMAR CHECK the document.

Do not email me the document. Instead, save the file to your Z: drive's cs102 folder, under a new subfolder “weekly”. Save the assignment to that folder as “cs102weekly5.doc”.

Due: Wednesday, 11/19

Save ALL work to the Z:\cs102\db\lab6 folder.

• Download the older 1995 NJ Toxic Release Inventory database and open in Access,

 http://rockhopper.monmouth.edu/~jchung/cs102/fa05/access/form95.dbf 

(Look for the TOTREL field in the 1995 table.)

• Import the 2003 NJ TRI data table into the same database as a new table,

 http://rockhopper.monmouth.edu/~jchung/cs102/tri2003_reduced.xls

• Generate and print the following reports as PDF files:

Hints: For numbers 1-4, you'll need to create intermediate queries for 1995 and 2003. For number 2, you may be thrown off by the fact that there were no emissions reported for Cape May County in 1995.

1. The total toxic releases for the entire state of NJ in 2003 and 1995 and the change in lbs. between 1995 and 2003.

2. The 21 NJ counties and their change in toxic releases between 1995 and 2003 as a percent increase or decrease ( (2003-1995)/1995 ).

3. Top 20 toxic chemicals in NJ in terms of percent reduction from 1995 to 2003 ( (2003totrel-1995totrel)/1995totrel is negative).

4. Top 20 toxic chemicals in NJ in terms of percent increase from 1995 to 2003 ( (2003totrel-1995totrel)/1995totrel is positive).

Download and save the tab-delimited 2006 NJ toxic releases data at http://rockhopper.monmouth.edu/~jchung/cs102/nj2006tri.raw.txt . Open the file in Excel. Follow instructions to reduce the data to only the fields we are interested in. Generate this final report:

5. The 21 NJ counties and their change in toxic releases between 1995 and 2006 as a percent increase or decrease ( (2006-1995)/1995 ).

In this optional assignment, we're going to try mapping the individual toxic emitting facilities from the 2006 NJ TRI data. We will be using Google Maps/Google Earth for this exercise. This will require you to have a Google account, which you should have already created.

Steps:

1) Make sure you're logged into your Google account. We will use the Google Docs spreadsheet for this exercise.

2) Go to Google's Spreadsheet Mapper page . We will largely just follow the steps given there. From there, open the “starter spreadsheet,” which will open a Google Docs spreadsheet in your web browser.

3) Use Access to filter the NJ TRI 2006 data to show only the facility names, latitude, longitude and street address, in that order. This data will be pasted into the Google Docs spreadsheet that you have opened.

4) After our initial attempt at mapping the NJ TRI facilities, we will attempt to apply different color Google Maps placemarks to the facilities, depending on the level of toxic emissions from those facilities. We'll categorize the facilities into 4 groups (templates) based on the level of total releases:

total releases          group (template)          placemark color
--------------          ----------------          ---------------
1       - 9,999               1                       green
10,000  - 99,999              2                       yellow
100,000 - 999,999             3                       orange
> 1,000,000                   4                       red

You'll want to change your copy of the Google Spreadsheet Mapper and rename it to “NJ TRI 2006 Test”. In “NJ TRI 2006 Test,” follow my instructions for replacing the default placemarks for templates 1-4.

DUE DATE: Thursday, 12/4

The assignment for this week must be done in the Google Docs word processor:

 In at least 250 words, discuss what OpenID is, including the
 perceived advantages and potential problems with OpenID.  List the
 references/information sources you used.                                     
                                                                              

SPELL CHECK the document.

Do not email me the document. Instead, publish the document in Google Docs, and email me the published URL.

Due date: Monday, 12/08

Save any files to Z:\cs102\present\lab1 .

From the 4 tables at this URL

 http://rockhopper.monmouth.edu/~jchung/cs102/cpu2000-110806.html

create an Excel spreadsheet (presentlab1.xlsx) containing 2 tables: CINT2000 and CFP2000 (throw away the last two tables called CINT2000 Rates and CFP2000 Rates). To do this, you should save the web page as html and then open the html file in Excel. Include these fields in your spreadsheet: Company Name, System Name, #CPU and Peak.

To perform the following analyses, export the spreadsheet tables to Access databases and run queries.

To create the presentation, use PowerPoint. Save the presentation as presentlab1.ppt. First create a title slide with the title “Presentations Lab 1: CPU Benchmarks”, then create 5 slides that include the following information (Use a suitable background image on all slides):

• You can create the following bar charts in Excel and then copy and paste into the Google Docs Presentation:

1. A slide containing a horizontal bar chart showing the top 10 peak CINT2000 scores by System Name for single core CPUs (1 core)

2. A slide containing a horizontal bar chart showing the top 10 peak CINT2000 scores by System Name for dual core CPUs (2 cores)

3. A slide containing a horizontal bar chart showing the top 10 peak CFP2000 scores by System Name for single core CPUs (1 core)

4. A slide containing a horizontal bar chart showing the top 10 peak CFP2000 scores by System Name for dual core CPUs (2 core)

5. A bullet point slide that makes the following points:

• Title: 'Top 10 Peak cint2000/cfp2000 Comments'
• System Name that has the highest peak CINT2000 score (include Company Name)
• System Name that has the highest peak cfp2000 score (include Company Name)
• Which CPU type has the most entries in the top 10 for CINT2000? for CFP2000?
  • CPU type would be, for example, Intel Xeon, AMD Opteron, Intel Pentium 4, etc.

• JavaScript Lab 1, Due date: Friday, 12/5
• JavaScript Lab 2, Due date: Wednesday, 12/10
• JavaScript Lab 3, Due date: Wednesday, 12/10
• JavaScript Lab 4, Due date: Wednesday, 12/10
• JavaScript Lab 5, Due date: Wednesday, 12/10