Data

[|Infectious Support]
[|Disease data folder] Disease project descriptor

**Disease Research Process**
In this project you will need several types of sources.

[|2. Instructions for Notes]
==== See an example of how to take notes without having to write them. Be sure to copy the important info for the MLA bibliography. you will need 3 resources: on non-internet, one internet, one an abstract from a journal. ====

3. Peer Reviewed Abstract
l earn how to get the required peer reviewed abstract and article for one of your 3 resources.

**// Starting Your Disease Research //**
 * 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 (CDC)]

// For general Information from the CDC: //
 * 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

// BE //// ST Choice //// for actual data for dis //// eases in the USA: (a teacher designated group member will be gathering the data and providing it for the group. These directions are for them) //
 * 1) Choose //**[|notifiable diseases]**// and then choose “Summary of Notifiable Diseases, 1993”
 * 2) **__ VIEW THIS FILE __**
 * 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 1-6 in **Part 3** (please note: some tables are 2 pages long). The years go backwards, so start with pg 88 of the pdf at **Table 6 first that has 1944** and work back up.
 * 4) Work back up to Table 3 on pg 85 of the pdf., then skip Table 2 and go on to Table 1on pg 83. You will be copying data from as far back your disease is reported as possible. The range will be from1944-1993. NOTE: the oldest years will be on the right of each table.
 * 5) **Do NOT** choose the //selected Deaths table// or //incidence tables or the any that say per 100,000 people//! ( so DO NOT use table 2 on pg 84 )
 * 6) Read the //How to copy data// instructions below
 * 7)  After you have all that data, **choose** the __View this file__ for  “Summary of Notifiable Diseases, **2011**”. F ind your disease and __get the rest of the data from 1994-2010__ found on Tables 8, 9 (pg 85-89 on the pdf). Remember to work backwards up to the most recent years, so start on table 9 set first. NOTE: these tables arrange the years from oldest on the left to newest on the right, unlike the first set you used.
 * 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.
 * 2)  __To Highlight and copy a line of data__ : [[image:yhs-wooten/Picture_6.png width="512" height="142" caption="Picture_6.png"]]
 * 3) 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)
 * 4) Be sure to also highlight and copy the years. Paste that in the cell **above** the data you copied.
 * 5) **NOTE: if the years are not copying as years (ex; it gives you an exponential number in the cell) then skip the copying. Just type in the first 2 years above the corresponding data, highlight both and drag across the row- it will put in the years in order.**
 * 6) ** Repeat for all of the other tables mentioned above. leave a roiw blank in between sets so they are easy to see. **
 * 7) ** To continue the process of creating a table and graph, use the "Hints for Open Office Speadsheet" below.**

If your disease is not located here:
 * There are **other Web lin**ks to try from the Disease page in the Disease Links. page** if your disease is not located here**. You may have to 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:
 * 1) **Create** a data table from it in Open Office (required program). Be sure to use the "Hints for Open Office Speadsheet" below.
 * 2) Make the graph (see criteria).
 * 3) **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:yhs-wooten/text_to_col.png width="428" height="195" caption="text_to_col.png"]]
 * 3) Then see that the data is all in a row in separate cells (BE SURE IT HAS Space and merge delimiters checked). If that looks right (each number in it's own cell, click okay and now the data should all be separated into individual cells. [[image:yhs-wooten/space.png width="329" height="241" caption="space.png"]]
 * 4) Repeat this for all the cells. **Be sure** the year row matches up to the data row- you may have to shift the year over one cell to align it.
 * 5) Convert this Data from horizontal alignment to vertical. Select the 2 rows ( data and years) and **copy**.
 * 6) Drop down or anywhere else that is blank and has at least 10 rows free and then choose **edit**, then **paste special.**
 * 7) Click the box at the bottom that says **transpose** and **okay**. [[image:yhs-wooten/paste_sp.png width="336" height="239" caption="paste_sp.png"]]
 * 8) 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 below so the years are ascending to most recent at the bottom. Be sure you do not overwrite any years.
 * 9) NOTE! For the years (from the 2011 document),you need to put the years into 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.**

Submit a copy of the tables and the graph to the instructor as a pdf by uploading to this [|Disease data folder,] being sure to name it with the disease. These will be used by the individual group members during the summative assessment.**