During this module, you learned about many different types of graphs, which grap
During this module, you learned about many different types of graphs, which graphs are most appropriate for specific data types, and how to create graphs in Excel. Remember that when building a graph in Excel to fully label the graph, title the graph, and to think about what information the graph should show the viewer.
A second important objective in this assignment is to work together with other learners to share, compare, and improve.
Choose any Excel dataset from Content > Course Resources. From that dataset, select any qualitative variable and create an appropriate graph that describes that variable. Use Excel to do this. Be sure to fully label the graph.
From the same dataset, select any quantitative variable and create an appropriate graph that describes that variable. Use Excel to do this. Be sure to fully label the graph.
Next, open a Word document. Paste both of your graphs into the Word document. Include under each graph, the name of the dataset you chose, the name of the variable you are graphing, and why the graph you chose is appropriate.
To enable teamwork and interaction with other learners, this Assignment will also use a shared Google document. Your instructor will post the link to this shared Google document in the Announcements area of the class. Follow these steps to complete the required interactive portion of this Assignment:
Using the link to the shared Google document, open the document online. Next, place your full name on the document in bold. Under your name, type the name of the dataset and the names of the qualitative and quantitative variables you selected in Part A above. Then, paste both of your graphs into the shared Google document.
Choose at least one of your fellow classmates. For each classmate that you choose, look carefully at both graphs that they placed in the shared Google document.
Create a critique of their graphics. Include constructive comments to assist with improvement. Include this critique in your responses.
Choose one of their graphs and redo the graph for them with improvements. Include the improved graph on the shared Google document. Include comments that explain the changes and updates you have made and why they might improve the graph.
(Remember – graphs can always be improved – such as better use of color, labels, style, clarity, etc.)
If work submitted for this competency assessment does not meet the minimum submission requirements, it will be returned without being scored.