Ethical Design of Graphs and Tables

Assignment

Create the graphics and answer the questions. Email me your answers.

You can create the graphics in Excel, but any program is ok. Just make sure I can open them.

Create the following graphics

  1. Create a line graph and a table using the enrollment data. Include the caption and create the graphic in the size that you would include it in a report.

  2. Create a bar graph using honest scaling. Include the caption and create the graphic in the size that you would include it in a report.

  3. Create a graph (your choice of type) that would make you look good if you had been admissions officer form 1970-1980.   The graph must show all the dates from 1970-1986.

  4. Create a graph (your choice of type) that would alarm the college faculty about declining enrollment.  The graph must show all the dates from 1970-1986.

Data  (freshman enrollment figures)

year    enrollment

1970 1,675

1972 1,678

1974 1,695

1976 1,700

1978 1,704

1980 1,710

1982 1,700

1984 1,654

1986 1,603

Questions

  1. Which graph seems the most effective for a reader who (a) wants exact figures, (b) wonders how overall enrollment is changing, or (c) wants to compare enrollments at each college in a certain year.

  2. Assume you are creating two versions of the document containing one of  these graphics and they are for (1) University Administration and (2) an article for a student newspaper. Would the figure captions be the same? How would the graphics be different?  Explain why or why not that they would they not be different (think about the differences in audience needs).

  3. What are some methods you can use to change a readers perception of a graph.

  4. For parts C and D of the exercise, assume you have been given the job of editing the report that contains the graph.  Write a 75-100 word response to the author (a faculty member) explaining why you feel the graph is unethical and should be changed. On the other hand, if you don't feel the graph should be changed, assume you are the author and write a 75-100 word response to the editor, who says it is unethical, explaining why the graph is ethical and does not need to be changed.

    You will write 2 responses, one for C and one for D.