Medium badge

Spreadsheet Wizard 3 Public

Del Lago Academy

You can calculate statistical measures and interpret and infer from these measures.

Required Evidence

Process

Pick and reflect on an artifact that illustrates the strategies you used to be successful in a task. More Info

Product

Pick and reflect on an artifact that proves you have the skills, knowledge, and dispositions represented by the badge. More Info

Metacognitive Reflection

Write a reflection that explains how learning the skills, knowledge, and dispositions in this badge make you a better practicing scientist. More Info

Badge Overview

Expectations

You can :
  • Use excel to calculate mean, median, standard deviation, and relative standard deviation for a given data set.
  • Explain why a scientist would use mean, median, standard deviation, and relative standard deviation.
  • Use mean, median, standard deviation, and relative standard deviation to make inferences about a data set.
  • Produce a trendline for exponential or logarithmic data.
  • Calculate percent error
  • Quantify error (error bars)
  • Discuss the significance of error to the reliability of results and the validity of a conclusion.

Why Earn This Badge?

Being able to compile and represent data is a highly sought after skill no matter what industry you are working in. Excel is one of the most commonly used tools for this task and will greatly set you apart from other applicants in the job market. It will also put you ahead of the curve in future courses in high school and college.

Who created this badge?

Badge Designers: 
http://www.competencyx.com

Badge Graphic Designer:
Sarah Kapin

Badge Experts

Badge Learners