• 4.1: Visuals Based on Numeric Data

    • David McMurrey's "Tables, Charts, Graphs: Show Me the Data" Page

      Read this section. Using Excel or another spreadsheet program, create a table that lists the types of visuals and two best practices for using them. Keep this table open and add to it as you work through the other activities in this unit.

    • The Open University: "More Working with Charts, Graphs and Tables" Page

      Review the sections on tables (section 3), bar charts (section 5), and pie charts (section 6). Continue to add to your chart of visuals using the information you find here. You should document more than two best practices for each visual as you get more in depth with the information.

      After you have read these sections, complete activities 5, 8, 9, and 12.

    • Adam Gaweda's "Creating a Pie Chart in Excel 2013" Page

      Read the instructions and watch the video. Use Excel or another spreadsheet program to create a pie chart with the following data:

      Blueberries: 23%

      Strawberries: 18%

      Raspberries: 56%

      Gooseberries: 3%

    • Additional Review Page

      If you would like to review additional materials about Excel spreadsheets and creating visuals for numeric data, you may want to check out PRDV004: Spreadsheets or PRDV252: Intermediate Excel (though note that PRDV252 is a Legacy course, and its assessments and final exams can no longer be taken).