Earth Exploration Toolbook > DataTools > 2007 Program > Calendar > Online 1 > Micromelting Point Lab in Excel

« Sharing Mini-Lessons

Micromelting Point Lab in Excel  

1: Amy Hintzman 04:12 PM Sep 17 2007 504:1701 edittextuser=1373 post_id=1701 initial_post_id=0 thread_id=504 Reply to this post

My dataset will come from data generated from students, so there is nothing to download (I hope that is ok). We are going to do a micromelting point lab, where kids find the melting point of one crystal of an unknown substance. They need to do at least 5 trials, and then we will combine data across all classes. I'm going to have them use Excel to do a variety of things: (1) graph their own trials in different colors to see the variability in their own procedure, (2) graph the class data to find any outliers, and (3) use Excel to calculate the mean melting points for their trials and for the class as a whole. They will then decide which data is most reliable and should be used in determining the melting point of the unknown.

2: Carla McAuliffe 11:01 PM Sep 18 2007 504:1722 edittextuser=31 post_id=1722 initial_post_id=0 thread_id=504 Reply to this post

Hi Amy,

Do you have a sample dataset we can try out from years past? It can be really small or you could post a "dummy" dataset. Our hope with this event is to give everyone a chance to try out the techniques in these mini-lessons. It would be fine to provide data to test out just one of the techniques you describe, such as graphing their own trials in different colors.

Thanks,---Carla

3: Jody Moro 05:40 PM Sep 19 2007 504:1733 edittextuser=1383 post_id=1733 initial_post_id=0 thread_id=504 Reply to this post

Hi Amy! What type of crystals are you using with your students? This activity sounds interesting and I'd like to learn more.

Thanks,
Jody

Join the Discussion

In order to post to this discussion you need to be logged in.

Create a New Account

It only takes 20 seconds and it's free!

Login with your current account

Email Address:  

Password:        

Forgot your password?

« Sharing Mini-Lessons

See more Online 1 »