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
Grade Levels
Product Rating
Not yet rated
File Type
Word Document File
Be sure that you have an application to open this file type before downloading and/or purchasing.
0.07 MB   |   5 pages

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
Answer Key
Not Included
Teaching Duration
2 hours

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$3.00
Digital Download
ADD ONE TO CART
User Rating: 4.0/4.0
 (40 Followers)
$3.00
Digital Download
ADD ONE TO CART
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