Module One : Homework

Using your new CDC Wonder account, (see Module One Web Work Assignment), access the census database using the instructions posted below. Generate a report showing the total number of children age 0 - 4 who reside in your county (all races) for each year from 1990-1996. Save this output and email it to your instructor or teaching assistant.

Detailed Homework Instructions:

1. Go to CDC Wonder and enter using the user name and password you obtained in the Module One Web Work assignment
2. Once you are in Wonder, click on the "HELP" link
3. Next select "Data Sets and Documentation" from the list of items provided
4. Go to the one-page summaries of the content of all CDC Wonder data sets by clicking on the "HERE" link
5. Scroll down to "Census" and click on it
6. Fill in the Census Data Request form which appears:
7. Item #1: Select location and time span. (EX: New York State, Onondaga County, 1990-1996)
8. Item #2: Select race, sex and age. (all races, all genders, age 0-4). For the age category you must fill both blanks, 0-4 through 0-4
9. Item #3: Select output format. (you are given the choice whether you want a report according to age, county, state, race, gender, or year) In this case choose year as the output format.
10. Item #4: Optionally, you may label your request. ("Census" will appear as the default label. You may leave this as is unless you choose otherwise)
11. Click the "Send" button
12. The abstract and report (in chart form) will appear momentarily
13. Below the report you may be given the option to "View or Save this Report in Other File Formats" (see options below)
    

    ASCII text (tables, but no graphs)
    Simple HTML with no links
    Comma delimited for import into spreadsheets
    You may choose any format.

If these choices are not available then you can capture the data from this report in one of two other ways: by copying and pasting into a spreadsheet or saving the data as a text file. To capture the report data using the former method simply highlight the data table using your mouse, select COPY from the EDIT menu, open a new MS Excel document, select PASTE from the Excel EDIT menu, save the Excel file, and email it to your instructor. To capture the report data as a text file simply select SAVE AS.. from the FILE menu, select TEXT FILE (.TXT) from the SAVE AS TYPE drop down menu in the SAVE AS.. dialogue box, give the file a name, save it, and email the file to your instructor.

Please Note: Files with the extension .asp (which are saved if the correct file type is not selected in the SAVE AS.. dialogue box) are not readable by the instructors or TAs.

14. Save the document and email a copy to your instructor as an attachment

If no data are avilable for your county please run your analysis on Queens county in NYC.