Data+table+and+graph


 * **STUDENTS ASSIGNED TO EPIDEMIOLOGY**: The table and graph are your substitute grades for symptoms and treatment- please see the following criteria

For instructions on finding and getting data into a spreadsheet, see research process

Data Table criteria (5 pts)
 * 1) Collect as much continuous “Reported Cases” data as you can. For most diseases this will be 1944-2009.
 * 2) Created a data table for the data. Criteria:
 * 3) Meaningful title
 * 4) Disease name
 * 5) Country name
 * 6) Dates
 * 7) Type of data(cases of...)
 * 8) Data is sorted appropriately (oldest data at the top)
 * 9) Gaps in data should not be entered as zeros, but should have an indication in the table that the data was missing from the source.
 * 10) Data and headers are centered in the cells
 * 11) Borders
 * 12) Headers
 * 13) Fits on one printed page-do not make it too small- large amounts of data need to be separated into 2 columns //NOTE: you must make your graph first with the one long table, then copy it to a new sheet before making 2 columns or your graph will not work//
 * 14) BELOW the table in a footer include the complete bibliographic information

Graph criteria (5 pts) >> name, page 1, date etc should be omitted)
 * 1) With the data, create an x-y scatter plot graph in a separate sheet in Open Office.
 * 2) The graph should fit these criteria
 * 3) Title matches table
 * 4) Appropriate scales on x & y axes with subtitles and units. OMIT the extra zeroes and change the units (Example:Cases, thousands(or ten thousands as needed)- to omit the excess zeroes see hint section)
 * 5) No grid lines vertical or horizontal- use a white background with black data points.
 * 6) Lines used to connect data and/or show trend lines may be colored BUT do not use lighter colors that don’t show up well like yellow.
 * 7) Actual years are used for independent variable (not years since..)
 * 8) Fits on one printed page- NOTE: if your data is only a few years, you may put graph and table on same page- get this passed by instructor
 * 9) Legend if appropriate (if you have more than one set of data) is labeled, not just series 1,2
 * 10) No additional headers or footers should appear on the graph or table page. (your


 * SUBMISSION**: save the table and graph as a 2 page **pdf file** and **upload** to the Disease data folder- please name it by the disease name so your group memebrs can find it easily during the assessment.

HINTS on Omitting zeroes for Y axis: BEFORE creating the graph with the actual data and years a. Insert a new column between the year and cases columns you made b. Choose the first cell in that column next to the first year c. Type in a formula- EXAMPLE : =C2/(1000) or =C2/(10^6) if you need to make it millions then hit return NOTE: This assumes that you have your columns in row 2 d. You will see that data has become a decimal. Highlight that cell then drag the corner down so all cells have that formula. e. Use this column and the year column to make your graph f. Use the ORIGINAL data column and years to make an actual data table highlight those and copy to a new sheet so you do not mess up your graph.

HINTS on the years: If you have trouble getting the scale to be the __actual years__ a. Highlight the data table column with the years only b. Choose format cells c. Choose text- this will make it read the years and not change it to a sequence. BONUS: For extra points, you can determine the line of best fit for the data and the equation for that line.

Questions on how to graph? Please consult me or your math teacher. || ||   ||
 * [[image:http://www.wikispaces.com/_/479e256b/i/bBL.gif width="8" height="8"]] |||| [[image:http://www.wikispaces.com/_/ad4b0f60/i/c.gif width="1" height="1"]] || [[image:http://www.wikispaces.com/_/1f60ab45/i/bBR.gif width="8" height="8"]] ||