From MariachiWiki

Contents 1 Excel for the Science Teacher 1.1 Registration Details 2 Workshop Program 2.1 Day 1 2.1.1 Morning 2.1.2 Afternoon 2.2 Day 2 2.2.1 Morning 2.2.2 Afternoon 2.3 Suggested Graphing Experiments

Excel for the Science Teacher

Excel for the Science Teacher is an introduction to Excel with hands on activities. The two day workshop will introduce participants to Excel. Participants will create tables and graphs, and utilize curve fits and some statistics. Participants will perform typical middle and high school science experiments and analyze the data using Excel. Participants will also explore Excel features appropriate for managing grade books.

Instructors: Gillian Winters, Ph.D. (Teacher, Smithtown HS East), Helio Takai, Ph.D. (Physicist, Brookhaven National Laboratory) and BingXin Shen (Student, Stony Brook University)

Date: Saturdays: 10/27 and 11/3, from 9:00AM - 4:30 PM. (15 Contact Hours)

Venue: MARIACHI Laboratory, Nuclear Structure Laboratory, Department of Physics and Astronomy - Stony Brook University.

Registration Fee: $50.

Registration Deadline: October 19,2007.

Maximum Number of Participants: 20 (twenty)

Materials:

• Participants should bring their current grade book to the first meeting
• Participants are encouraged to bring their own laptop computer (optional)

Pizza lunch will be served

Registration Details

To register please download this form Registration.pdf, fill and send it to Mrs. Judy Nimmo (jnimmo - at - notes.cc.sunysb.edu) at LIGASE or send it via Fax to 631-632-9791.

For information please contact Dr. Helio Takai ( takai = at = bnl.gov )

Workshop Program

Day 1

Morning

1. Registration. Breakfast
2. Introductions
3. Graphing with Excel: Density of Wood
   1. Enter data - rows, columns, create tables
   2. Function calculation - calculate volume and density
   3. Graph
   4. Trendline and Equation
   5. Error bars, standard deviation, numerical calculation

Afternoon

1. Talk or tour of lab(s)
2. Grade books with Excel (teachers bring their grade books)
   1. Discuss possible formats
   2. Importing data into Excel
   3. Sum, average calculations
   4. Statistics (mean, standard deviation)
   5. Creating a Summary Sheet
   6. Auto format (i.e. red = failed or missing test or lab)
   7. Histograms (histogramming average for grade distributions )

Day 2

Morning

Analyzing a Free Fall Experiment (measuring acceleration of gravity)

1. Graphing with Excel: analyzing data from flashing LED. (Group Work)
   1. Enter distance vs. time data; graph
   2. Calculate velocity; graph velocity vs. time
   3. Calculate acceleration; graph acceleration vs. time
   4. Statistics: t-test
   5. Trendline; Statistics: Chi-squared

Afternoon

1. Physics talk (Speaker TBA)
2. In groups of 4, analyze another laboratory experiment
3. Present to class.

Suggested Graphing Experiments

1. Radioactive decay of candium
2. Yeast Lab 1
3. Yeast Lab 2
4. Global Warming Statistics
5. Life Expectancy (soap bubbles)
6. Earthquake slip
7. Speed of sound
8. Reaction time