Whoops! Something went wrong.

Click here to refresh the page

HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key

HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
HHMI Tutorials- Using Excel Spreadsheets to Analyze Data- NO Key
Product Description
To go with the awesome spreadsheet data analysis tutorials from HHMI (https://www.hhmi.org/biointeractive/spreadsheet-data-analysis-tutorials), I created this worksheet to walk my students through all 3 sets of information and hold them accountable for it. Students learn how to use Excel to:

-complete simple mathematical functions
-calculate central tendency
-calculate variance and standard deviation
-create a bar graph of means of data
-put error bars on the bar graph to 95% confidence/2 SEM

I have my students complete this as an assignment (and figure it will take them about 2 hours to complete) and then apply the knowledge in class. I am taking my kids to a nearby museum where we are helping with mussel research; they use the mussel data and use Excel to calculate statistics and graph the info, as learned in the HHMI tutorial. You could do the same with any sort of data that you find.

--------------------------------------

NOTE: I also have a version WITH a key available for sale. That version also has a preview of the product, if you would like to download that and get a closer view of the worksheet. See here: https://www.teacherspayteachers.com/Product/HHMI-Tutorials-Using-Excel-Spreadsheets-to-Analyze-Data-WITH-Key-2117380
Total Pages
5 pages
Answer Key
Not Included
Teaching Duration
2 hours
Report this Resource
  • Comments & Ratings
  • Product Q & A
Loading...
$3.00
Digital Download
Add one to cart

Advertisement

Advertisement

$3.00
Digital Download
Add one to cart
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up