Infectious+Disease+Project

**//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)] __

BEST CHOICE FOR DATA FOR DISEASES IN THE U.S.


 * 1) Choose //<span style="background-color: transparent; color: #000000; font-family: Tahoma; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Tahoma; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">__<span style="background-color: transparent; color: #0000ee; font-family: Tahoma; font-size: 16px; text-align: start; vertical-align: baseline;">[|notifiable diseases] __ ** // and then choose <span style="background-color: transparent; color: #008080; font-family: Tahoma; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">“Summary of Notifiable Diseases, 1993”
 * 2) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Times; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Times; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Tahoma; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Download the PDF  **  <span style="background-color: transparent; color: #000000; font-family: Arial,Helvetica,sans-serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">and open it in Adobe Professional. <span style="background-color: transparent; color: #000000; font-family: Times; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"> DO NOT choose view this file as the format is more difficult to copy data from into a spreadsheet.
 * 3) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">This file is long. Go through the contents to see if your disease is there. Go to the data tables beyond the graphs to //<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Reported Cases of Notifiable Diseases in the US // starting with Table 1-6 in **<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Part 3 ** (please note: some tables are 2 pages long). The years go backwards, so start with pg 88 of the pdf at **<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Table 6 first that has 1944 ** and work back up.
 * 4) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Work back up to Table 3 on pg 85 of the pdf., then <span style="background-color: transparent; color: #ff0000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">skip Table 2 <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Do NOT ** choose the //<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">selected Deaths table // or //<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">incidence tables or the any that say per 100,000 people //! ( <span style="background-color: transparent; color: #ff0000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">so DO NOT use table 2 on pg 84 <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">)
 * 6) <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Read the //<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">__<span style="background-color: transparent; color: #0000ee; font-family: Geneva; font-size: 16px; text-align: start; vertical-align: baseline;">How to copy data __ // instructions below


 * 1) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">After you have all that data, **<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">choose ** the File Download for <span style="background-color: transparent; color: #008080; font-family: Tahoma; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">“Summary of Notifiable Diseases, **<span style="background-color: transparent; color: #008080; font-family: Tahoma; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">2009 **”. <span style="background-color: transparent; color: #000000; font-family: Tahoma; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"> F <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">ind your disease and get the rest of the data from 1994-2009 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.
 * 2) <span style="background-color: transparent; color: #008080; font-family: Garamond,serif; font-size: 17.6px; text-align: start; text-decoration: none; vertical-align: baseline;">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).

<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">How to copy data ** <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"> To just copy data directly : > || Picture_6.png ||
 * 1) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">After navigating to the correct data tables in Adobe Professional, you can highlight and copy lines of data. <span style="background-color: transparent; color: #ff0000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">To Highlight and copy a line of data  <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">:
 * [[image:yhs-wooten:Picture_6.png caption="Picture_6.png"]] ||


 * 1) <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Be sure to also highlight and copy the years. Paste that in the cell above the data you copied.
 * 3) <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Repeat for all of the other __<span style="background-color: transparent; color: #0000ee; font-family: Geneva; font-size: 16px; text-align: start; vertical-align: baseline;">tables mentioned above __.
 * 4) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">To continue the process of creating a table and graph, use the __<span style="background-color: transparent; color: #0000ee; font-family: serif; font-size: 16px; text-align: start; vertical-align: baseline;">"Hints for Open Office Speadsheet" __ below.

<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">There are **<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">other Web lin **ks to try from the Disease page in my teacher page **<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">if your disease is not located here **. You may have to see me for some guidance- try them yourself first.
 * 1) <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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.

<span style="background-color: transparent; color: #008080; font-family: Garamond,serif; font-size: 17.6px; text-align: start; text-decoration: none; vertical-align: baseline;">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.

<span style="background-color: transparent; color: #0000ff; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Once you have your data in Open Office <span style="background-color: transparent; color: #000000; display: block; font-family: Geneva; font-size: 16px; text-align: center; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: center; text-decoration: none; vertical-align: baseline;">Hints for Open Office Speadsheet ** <span style="background-color: transparent; color: #ff0000; font-family: Times; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Help in converting the rows of data and years into Open Office without having to type it all by hand: >> || text_to_col.png || <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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. >> || space.png ||
 * 1) <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Highlight ** what you believe you will use
 * 2) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Times; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">get **<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">instructor approval of data before proceeding **
 * 3) <span style="background-color: transparent; color: #000000; font-family: serif; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">create ** a data table from it in Open Office (required program). Be sure to use the __<span style="background-color: transparent; color: #0000ee; font-family: serif; font-size: 16px; text-align: start; vertical-align: baseline;">"Hints for Open Office Speadsheet" __ below.
 * 4) <span style="background-color: transparent; color: #000000; font-family: Geneva; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Make the graph (see __<span style="background-color: transparent; color: #551a8b; font-family: Geneva; font-size: 16px; text-align: start; vertical-align: baseline;">criteria __).
 * 5) <span style="background-color: transparent; color: #000000; display: block; font-family: Bradley Hand ITC TT-Bold; font-size: 16px; text-align: justify; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Bradley Hand ITC TT-Bold; font-size: 16px; text-align: justify; text-decoration: none; vertical-align: baseline;">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, <span style="background-color: transparent; color: #000000; font-family: Georgia,serif; font-size: 17.6px; text-align: justify; text-decoration: none; vertical-align: baseline;">//<span style="background-color: transparent; color: #000000; font-family: Georgia,serif; font-size: 17.6px; text-align: justify; text-decoration: none; vertical-align: baseline;">you must make your own // .**
 * 1) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">After you have selected the dates and data by row, highlight and copy into Open Office (see above).
 * 2) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Select cell in the first column and then DATA in the bar and choose TEXT to COLUMN.
 * [[image:yhs-wooten:text_to_col.png caption="text_to_col.png"]] ||
 * [[image:yhs-wooten:space.png caption="space.png"]] ||

>> || paste_sp.png ||
 * 1) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Repeat this for all the cells.
 * 2) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Convert this Data from horizontal alignment to vertical. Select the 2 rows ( data and years) and **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">copy **.
 * 3) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Drop down or anywhere else that is blank and has at least 10 rows free and then choose **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">edit **, then **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">paste special. **
 * 4) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">Click the box at the bottom that says **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">transpose ** and **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">okay **.
 * [[image:yhs-wooten:paste_sp.png caption="paste_sp.png"]] ||


 * 1) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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) <span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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 **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">ascending ** and click okay- it will rearrange it. Be sure to **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">center ** all **<span style="background-color: transparent; color: #000000; font-family: Optima; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">data and headings ** within the cells.

<span style="background-color: transparent; color: #000000; font-family: Times; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">**<span style="background-color: transparent; color: #000000; font-family: Times; font-size: 16px; text-align: start; text-decoration: none; vertical-align: baseline;">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.