Research+Process

In this project you will need several types of sources.

Informational resources
Instructions for Notes

Peer Reviewed Abstract
**// Starting Your Disease Research //** // For general Information from the CDC: //
 * 1) [|Disease Links]. (Notice some specific diseases are listed here separately. They do not have data on the CDC site, so those diseases assigned need those links)
 * 2) Choose __[|World Health Organization]__: go from there to find your disease. Particularly look for Fact sheets or statistics.
 * 3) Choose [|Center for Disease Control]
 * 1) **Choose** **__search__**. Type in your disease and you’ll get many links from there.
 * 2) **Or** Choose from Health topics : [|Disease & Conditions] **or** *__Top 10__ on the right sidebar

// BEST Choice for actual data for diseases in the USA: //
 * 1) Choose //**[|notifiable diseases]**// and then choose “Summary of Notifiable Diseases, 1993”
 * 2) **__ Download the PDF __** and open it in Adobe Professional. DO NOT choose view this file as the format is more difficult to copy data from into a spreadsheet.
 * 3) This file is long. Go through the contents to see if your disease is there. Go to the data tables __beyond__ the graphs to //Reported Cases of Notifiable Diseases in the US// starting with Table 3-6 in Part 3 (please note: some tables are 2 pages long). The years go backwards, so start farther on with the **Table 6 first that has 1944** and work back up (pg 88 of the pdf).
 * 4) Work back up to Table 3 on pg 85 of the pdf. You will be copying data from as far back your disease is reported as possible. The range will be from1944-1983.
 * 5) NOTE: **Do NOT** choose the //selected Deaths table// or //incidence tables or the any that say per 100,000 people//! (You will NOT use table 1or 2)
 * 6) Read the //How to copy data// instructions below
 * 7)  After you have all that data, **choose** the file download for “Summary of Notifiable Diseases, **2009**”. F ind your disease and __get the rest of the data from 1984-2009__ found on Tables 8, 9, and 10 (pg 80-84 on the pdf). Remember to work backwards up to the most recent years.
 * 8) There are other tables that show disease by ethnicity or age or sex, etc. You may wish to consult those or even use some of that data summarized in a separate table if it helps you make your correlations and predictions. You may find some useful information and links in the brief paragraph at the beginning of the file under your disease,(before the graphs).

**How to copy data** __To just copy data directly__: >
 * 1) After navigating to the correct data tables in Adobe Professional, you can highlight and copy lines of data. Highlight and copy a line of data:
 * [[image:Picture_6.png width="512" height="142" caption="Picture_6.png"]] ||


 * 1) In a new Open Office spreadsheet, paste the text. (It will all be in one cell. Don't worry, we'll fix that in a minute)
 * 2) Be sure to also highlight and copy the years. Paste that in the cell above.
 * 3) Repeat for all of the other tables mentioned above.
 * 4) Continue this process using the "Hints for Open Office Speadsheet" below.

There are **other Web lin**ks to try from the Disease page in my teacher page **if your disease is not located here**. You may have see me for some guidance; try them yourself first.
 * 1) ALL DATA needs to be passed by your teacher for appropriateness/usefulness for that disease. It is also very important to know where the data was taken, ie. USA or Africa, etc.
 * 2) Most of the other sources allow you to highlight specific data lines and copy them into your word document- don’t forget to get the dates! The line up will be off- check for accuracy. __You only need totals for the world or in some cases totals of regions__- see teacher for help.

There are __some diseases which are better done from a worldwide basis OR from the data from a different country__- for example: BSE is a more of an issue in England, therefore data from there makes more sense than from USA. That doesn’t mean you ignore data from USA, as it should be included in the report for comparison. The same goes for African Sleeping sickness- you won’t find USA data. Malaria could be worldwide, or only developing countries or only US citizens- there is data available for each-world is best. Specifying where the data comes from is important later as to how you analyze and predict about the future of that disease.

Once you have your data in Open Office **Hints for Open Office Speadsheet** Help in converting the rows of data and years into Open Office without having to type it all by hand: >> Then see that the data is all in a row in separate cells (try clicking Space). If that looks right, click okay and now the data should all be separated into individual cells. >>
 * 1) **Highlight** what you believe you will use
 * 2) __ get **instructor approval of data before proceeding** __
 * 3) **create** a data table from it in Open Office (required program). Be sure to use the "Hints for Open Office Speadsheet" below.
 * 4) Make the graph (see criteria).
 * 5) **If the only data available is already in graph form, __get instructor approval__, then create backwards to a data table in Open Office, then proceed with making a graph in Open Office. The downloaded graph will not be acceptable for the report, __//you must make your own//__. **
 * 1) After you have selected the dates and data by row, highlight and copy into Open Office (see above).
 * 2) Select cell in the first column and then DATA in the bar and choose TEXT to COLUMN.
 * [[image:text_to_col.png width="428" height="195" caption="text_to_col.png"]] ||
 * [[image:space.png width="329" height="241" caption="space.png"]] ||

>>
 * 1) Repeat this for all the cells.
 * 2) Convert this Data from horizontal alignment to vertical. Select the 2 rows ( data and years) and **copy**.
 * 3) Drop down or anywhere else that is blank and has at least 10 rows free and then choose **edit**, then **paste special.**
 * 4) Click the box at the bottom that says **transpose** and **okay**.
 * [[image:paste_sp.png width="336" height="239" caption="paste_sp.png"]] ||
 * 1) The data will copy into two side by side columns! Then delete the 2 sideways rows you had and repeat this for each double set of rows from your saved files of data. You can highlight each new group as you create them and add them to your growing table. Be sure you do not overwrite any years.
 * 2) For some of the years (from the 1993 document),you need to put years are in ascending order (oldest first to most recent). If it is not reading from oldest to most recent down the column, highlight the 2 columns and go to DATA again, and choose SORT, then be sure it is on **ascending** and click okay- it will rearrange it. Be sure to **center** all **data and headings** within the cells.

**Remember that you need one long column to make the graph from.** __After you make the graph,__ **copy the data into a new sheet and you can move columns around etc. to make a double wide data table to fit large amounts on one page- don’t have 2 long pages of data. If you do not keep the original and don’t sort from a copy and you start moving things, your graph will be messed up.** **DO NOT embed the graph on the data page. Follow the criteria for the graph and data tables.**