« Investigation Reflections

Solar Heating and Heat Transfer  

The lesson includes a science lab investigation with students collecting and recording temperature data and creating line and bar graphs using Excel in the computer lab.
This is the investigation template.

Attachments:

Investigation template for Solar Heating (Microsoft Word 99kB Mar12 09)

1097:3369

Share edittextuser=1660 post_id=3369 initial_post_id=0 thread_id=1097

Solar Heating and Heat Transfer Lab Report includes the science lab procedure, data tables, and instructions for creating graphs using the Chart Wizard in Excel.

Attachments:

Solar Heating and Heat Transfer Lab Report (Microsoft Word 57kB Mar12 09)

1097:3370

Share edittextuser=1660 post_id=3370 initial_post_id=0 thread_id=1097

Sample data tables and graphs show the actual results of one groups data and class average temperature differences.

Attachments:

Sample data tables and graphs (Microsoft Word 39kB Mar12 09)

1097:3371

Share edittextuser=1660 post_id=3371 initial_post_id=0 thread_id=1097

Sample multiple line graph of data (Data Table 1)shows the heating of three surfaces: Black, White, and Aluminum cans.

Attachments:

Multiple line graph of three surfaces. (Excel 22kB Mar12 09)

1097:3372

Share edittextuser=1660 post_id=3372 initial_post_id=0 thread_id=1097

Sample column (bar) graph compares the temperature differences (class data)of black, white, and aluminum cans.

Attachments:

Class average temperature of three surfaces. (Excel 23kB Mar12 09)

1097:3373

Share edittextuser=1660 post_id=3373 initial_post_id=0 thread_id=1097

Marie.
This is a very good lesson. It can be used in the eighth grade Astronomy classes.
Rich Briody

1097:3390

Share edittextuser=1661 post_id=3390 initial_post_id=0 thread_id=1097

Marie.
This is a very good lesson. It can be used in the eighth grade Astronomy classes.
Rich Briody

1097:3391

Share edittextuser=1661 post_id=3391 initial_post_id=0 thread_id=1097

Marie-
I can include this lesson in our ninth grade thermodynamics unit!
Thanks-
Marge P.

1097:3414

Share edittextuser=1714 post_id=3414 initial_post_id=0 thread_id=1097

I had the opportunity to see Marie work with her classes in the computer lab with this lesson. Only a few of the students in these classes had had computer use with the Excel program during the 1st half of the school year. Most of the students are just beginning their use of computers in the lab for the second half of the year so many of the students hadn't used Excel before. Under Marie's direction the student's were very able to complete the Excel charts and discuss why the difference in temp. The lessons went very well and I was happy to see those students from the first half of the computer classes able to help others in the newly learned Excel process under Marie's direction. Nice!

1097:3439

Share edittextuser=1690 post_id=3439 initial_post_id=0 thread_id=1097

Join the Discussion


Log in to reply

« Investigation Reflections