Spreadsheet Wizard 2

Product

Only editable by group admins

  • Last updated April 3, 2017 at 9:43 AM by rboyd
  • Evidence only visible to group members
Pick and reflect on an artifact that proves you have the skills, knowledge, and dispositions represented by the badge.
Required Artifacts
  1. A histogram chart generated in excel
    • Title of graph or table identifies independent and dependent variabless
    • Axes are labeled.
    • Axes have correct units
    • Axes are scaled properly.
    • Data fills most of the graph space.
    • Data is properly placed.
    • Figure Caption for the graphed data describes the relationship between the independent and dependent variable and how the data was collected.
  2. A scatter plot generated in excel with a linear regression based trendline that displays an equation and an r2 value.
    • Title of graph or table identifies independent and dependent variable. Axes are labeled.
    • Axes have correct units and are scaled properly.
    • Data fills most of the graph space.
    • Data is properly placed.
    • An appropriate line of best fit is drawn and an equation and r2 value for that line is determined and displayed.
    • Figure Caption for the graphed data describes the relationship between the independent and dependent variable and how the data was collected.
  3. A written reflection on how each set of data was obtained and justification for selecting this type of chart.