Curriculum Project

About the Curriculum Piece
Using the 5 E Model template for your curriculum piece, plan a Lesson Plan  based on a concept that piqued your interest this week. Adapt it to a lesson that you can actually use, science and math. Make sure that it includes appropriate math and science integration, standards, content and assessment. Please ask if you have questions

 Here is an example lesson plan: http://www.cs.duke.edu/csed/alice/aliceInSchools/workshop08/lessonPlans/white/5ELessonPLanInvitationtotheGame.pdf



5E Lesson Plan
Name: Mr. .I.
Subject Area: Environmental Science
Grade Level: 11-12
Lesson Title: Stream Ecology: Water Sampling Project
Introduction: Science and math are interconnected. A thorough understanding of science will not be possible without a good background in math, hence the need for every science teacher to understand how to integrate math into the science curriculum, most methods of collecting scientific data involves the direct application of math. Most college entrance examinations in science are not necessarily connected to any state standards of learning; instead, it requires the students to apply their knowledge of math and science in answering questions.
Lesson Objectives:
Students will analyze water samples taken at different sections of the river for specific contaminants.
Students will relate contaminants to local sources.
Students will take pH readings of the river over a specified period in a year.
Students will measure the dissolved oxygen (DO) and Biological Oxygen Demand (BOD) of the sample, test for specific contaminants and record the kind of living organisms found in the sample.
Students will use appropriate instruments to measure the discharge of the river at different segments of the river.
Students will use GPS equipment to mark the waypoints of the different segments of the river where water sampling activities were performed.
Students will use math and graphing skills to conduct water sampling investigations.
South Dakota Science Standards:
9-12. N. 2.1 Students are able to apply science process skills to design and conduct student investigations
Project Length: One academic year
Formula for calculating the flow rate or discharge of a segment of the stream:
Flow=ALC/T
 Where:
 A= Average cross-sectional area of the stream (stream width multiplied by average water depth.
L= Length of the stream reach measured (about 20ft.)
C= A coefficient or correction factor (0.8 for rocky bottom streams or 0.9 for muddy-bottom streams)
T= Time in seconds for the float to travel the length of L
Students will plot a hydrograph using an excel spreadsheet, they will plot Discharge (Flow Rate) values on the Y-axis and Time on the X-axis
List of Materials:
Thermometers
Aquatic Nets
pH testing and dissolved oxygen testing kits. 
Chest Waders
GPS Equipment
Stop Watch
Meter Stick
Long tape measure-at least 30 ft
Oranges
Digital Cameras
Phase One: Engage the Learner
The teacher will show students 10 minute video clips of a healthy freshwater ecosystem and a polluted freshwater ecosystem.
The teacher will ask students to state the differences they observed in the videos.
The teacher will ask the students to determine the section of a river that will be expected to have a faster flow rate.
The teacher will ask students why they would not drink water that was scooped from a local wetland.
The teacher will administer a Pre-test on water quality.  
Phase Two: Explore the concept
Students use the Ph measurement kit to determine the ph of different household items and laboratory reagents, students will use materials with Ph measurement close to opposite ends of the Ph scale and other materials that are closer to the middle.
Students will study the characteristics of the different types of invertebrates that are usually found in freshwater ecosystems.
Students will understand the meaning of eutrophication and its effects on local streams.
Students will classify freshwater invertebrates in terms of their tolerance to pollution.
Students will learn how to use a GPS unit in water sampling.
Students will learn how to plot values recorded for a similar project using an excel spreadsheet.
Phase Three: Explain the Concept and Define the Terms
The teacher will use a 60-75 slide PowerPoint presentation that contains all aspects of the project, pausing at different stages to check for student understanding.
Phase Four: Elaborate on the concept
Students will gather their water sampling gear and equipments and embark on a water sampling field trip with the teacher; they will work in groups and practice hands-on water sampling activities.
Students will use their GPS equipment to mark the waypoint and determine the latitude and longitude of their observation spot. Students will save this information on their equipment and record it on their worksheet.
Students will collect water samples from recorded area and determine the hydrogen ion concentration (pH) of the water sample; in addition, they will determine the dissolved oxygen (DO) and the Biological Oxygen Demand (BOD) of the sample.
Students will test for specific contaminants and record the kind of invertebrates found in that section of the river.
Students will measure the flow rate of the river at the observation spot.
Students will use a digital camera to take photographs of the observation spot; students will file the pictures of each observation spot with worksheets containing other information about the spot.
Students will use their latitude and longitude data to visit their observation spots during the winter and spring to repeat the data collection process. Data from each observation period will be filed separately. After the final field trip, each group will create a class report that summarizes the changes in their observation spot over the course of the school year.
New students undertaking this project in subsequent years will compare their observation to those made in previous years.
Phase Five: Evaluate Students’ Understanding of the Concept
Student work will be collected and checked for accuracy. The data will be compared with data collected by the teacher and deviation from expected values will be measured. Their hydrographs will be evaluated.             




   
                         

      

5-E Lesson Plan

NameSandi Hurst
Subject AreasMath and Science
Grade Level8th Grade
Lesson Title:  The Effect of Salinity on Density of Water

IntroductionScience and math are two areas that, although logically able to be integrated, are often treated as two separate entities.  This lab and analysis will enable students to complete a cross-curricular lesson completing a scientific investigation, collecting data, creating visual representations, and then analyzing visual evidence in order to predict future or alternative outcomes.  

Lesson Objectives:
  • Students will follow steps to conduct a scientific experiment
  • Students will make a table and graph of scientific data
  • Students will describe the relationships between two variables in a linear equation
  • Students will analyze data to make predictions

South Dakota Science Standards
  • 8.N.2.1  Students are able to design a replicable scientific investigation.
  • 8.E.1.4  Students are able to examine the chemical and physical properties of the ocean to determine causes and effect of currents and waves.

South Dakota Math Standards
  • 8.A.4.1  Students are able to create rules to explain the relationships between numbers when a change in the first variable affects the second variable.
  • 8.A.4.2  Students are able to describe and represent relations using tables, graphs, and rules.
  • 8.M.1.1  Students are able to apply proportional reasoning to solve measurement problems with rational number measurements.
  • 8.M.1.2  Students are able to find area, volume, and surface area, with whole number measurements.
  • 8.S.1.1  Students are able to find the mean, median, mode, and range of a data set.
  • 8.S.1.2  Students are able to use a variety of visual representations to display data to make comparisons and predictions.


Lesson Length:  2 Days (1 for lab and 1 for analyzing data)

Lesson OverviewConsider the following formula: 

D=m/v
(D=density, m=mass,v=volume)
(Density is measured in units derived from mass and volume, usually g/cm3,
Mass is measured in units of weight like grams (g) or kilograms (kg),
Volume is measured in units of volume like cm3 or m3)

An egg put in a glass of tap water will sink to the bottom of the glass because the density of the egg is greater than the density of the tap water.  (FYI – the density of fresh water is about 1g/cm3).  However, if you keep adding salt to the glass, the egg will float back to the top because the density of the water eventually becomes greater than the density of the egg (without affecting the volume of the water).

In this lab, you will determine exactly how much salt is needed to make an egg float in a glass of water.  You will use a technique known as serial dilution in which you begin with a salinated solution (the stock) and dilute it by set amounts of tap water.  The resulting amount, or concentration, can be determined using the following equation:

new concentration = ________volume of stock________
                                  (volume of stock + volume of water)


List of Materials:
·         Clear 16-ounce plastic cups
·         Table salt (1 cup per group)
·         Water
·         Measuring cup (liquid)
·         1-quart containers for each lab group
·         Spoons for stirring and egg transfer
·         Eggs – must be room temperature (5 per group)
·         Lab instructions
·         Lab notebooks (if no room to write on lab instructions)
·         Pens/pencils
·         Laptops with access to Microsoft Excel


Phase One:  Engage the Learner
  • Ask students what happens to salt (NaCl) when it is put into water. Also ask how the water is affected.
  • Ask students what they know about the ocean compared to (most) lakes?  Focus on salinity.
  • Have students share experiences traveling to different bodies of water (lakes, rivers, seas, oceans, etc.).
  • Have small groups explore the following websites and then report their findings to the rest of the class:


Phase Two:  Explore the Concept
Have student groups conduct the following experiment (each student should have a hand-out with the following instructions as well as room to answer the questions):
  1. Make a stock solution of 1 cup of salt dissolved in 1 quart of water using the following procedure:
o   Pour 3 cups of water into the 1-quart container.
o   Add 1 cup of salt.
o   Stir until the salt is dissolved.
o   Add more water to fill the container to the 1-quart line.
o   Stir the mixture again.
  1. Label four of the plastic cups #1-4 and label the fifth cup “tap water.”
  2. Add ¾ cup of stock salt solution to cup #1.
  3. Add ¾ cup plain tap water to cups #2-5.
  4. Add ¾ cup stock solution to cup #2.  Mix.
  5. Measure out ¾ cup of the solution from cup #2 and add it to cup #3.  Mix.
  6. Measure out ¾ cup of the solution from cup #3 and add it to cup #4.  Mix.
  7. Answer the following questions in your lab notebook or on the lab sheet:
1.     What are the relative salt concentrations of cups #1-4?  (For example, cup #2 is half stock solution plus half tap water so it is a 50% relative salt concentration.)
2.    What are the absolute salt concentrations of cups #1-4?  (1 cup of salt is approximately 292 g; 1 quart of water is 0.946 L)
  1. Start with cup #5.  Carefully place the egg in the cup to see if it will float.  Did it?  Use a spoon to lift the egg out of the cup.
  2. Repeat the step above that you used for cup #5 with each of the other cups in this order:  cup #4, cup #3, cup #2, and cup #1.
  3. In which cup did the egg first float?  (Save this solution for Step 13).  If the egg floated in more than one cup, did you notice any difference in how it floated?
  4. Now you know approximately (within a factor of 2) how much salt is needed to make an egg float.  Now you will conduct another experiment to get an even more precise estimate!
  5. This time you will begin your dilution steps with the same concentration solution in which the egg first floated.
  6. Figure out a new dilution sequence using even smaller steps than before.  For example, you could try diluting the solution by 20% with each step.  That means that, with each step, the new concentration should be 80% of the original concentration.
  7. Record the following information in your lab notebook or on your lab sheet:
o   What amounts of new stock solution and water do you need to use?  (Remember – you will need enough solution to more than cover the egg.)
o   Record your computations and dilutions.
  1. Make the new dilution sequence following the same procedure as outlined in steps 5-7.
  2. Repeat steps 8-11 for the new solutions.
  3. Repeat the entire procedure for the other four eggs.
  4. Record your results in the following chart:

Egg
Density
Concentration of Solution Floated In
















  1. How much variation in density is there from egg to egg?


Phase Three:  Explain the Concept and Define the Terms
  • As a large group, brainstorm definitions for the following terms, creating a class definition:
- density                         - mass                                      - volume
- serial dilution                - stock                            - concentration
- relative concentration            - absolute concentration
  • Discuss the scientific lab procedure used (how was uniformity of measurements maintained, what solutions caused the eggs to float/sink, etc.)
  • List results from all group experiments on the board.
  • Have students create charts in Excel of the class results and then create a scatterplot of their results. 


Phase Four:  Elaborate on the Concept
  • Have students individually answer the following questions:
1.     How much variation in density is there from egg to egg (range)?
2.    What is the average/mean density . . . the mode . . . the median?
3.    Why does adding salt to water increase its density?
4.    What could account for the variation in density of the eggs?
5.    Did each groups’ eggs float in the same concentrations of water?  Why or why not?
6.    How could we make our results even more accurate?
  • Have students discuss their answers in Pair-Share small groups.
  • Discuss the answers as a large group.


Phase Five:  Evaluate Students’ Understanding of the Concept
  • Have students turn in their lab reports/results as well as the answers to the questions in Phase Four (allow students time to revise their responses after the group discussion.)
  • Have students answer the following questions based on their lab results and charts (can be on their lab reports/results sheets or on another sheet of paper):
    1. Would a hard-boiled egg float at the same concentration as an uncooked egg?  Why or why not?
    2. How would the results have been impacted if other eggs, such as those from an ostrich, robin, or hummingbird, had been used?
    3. Find out how much salt there is in each of the oceans (Atlantic, Pacific, Indian, Arctic).  Would an uncooked egg float in each of the oceans?  Why or why not?


References:






South Dakota Department of Education Science and Math Content Standards


From Johnny Olson

Name:  Johnny Olson
Subject Area:  Mathematics
Grade Level:  8th
Lesson Title:  Equations with Two Variables
Introduction:
                In this lesson, we are going to take a look at different linear equations.  In order for students to do well in this exercise, they need to have some background knowledge of linear equations.  They will need to know how to graph linear equations by hand, and they will need to know about slope, rate of change, and the slope- intercept form.  We will have done lessons on all of these subjects before this lesson, so all of the students should have a good understanding of them. 
                In this lesson, we are going to use Microsoft Excel to graph linear equations.  I want them to know how to graph by hand before doing this lesson, so they don’t always rely on computers, calculators, and technology. Once I have taught the students how to graph equations using Microsoft Excel they are going to make some observations.  We will use these observations to talk about slope, rate of change, the y-intercept, tables, ordered pairs, and how all of these things affect the linear graph. 
                I like using Microsoft Excel for this exercise instead of graphing calculators because it is so much easier to see graphs and equations at the same time.  It is also easier to see multiple graphs at once.  I like the bigger screen on the computer making the graph(s) easier to see as well.
Lesson Length:  1-2 Days
Standards:
·         CC.8.F.1
·         CC.8.F.2
·         CC.8.F.2
Outcomes: 
·         Students will
o   Get a greater understanding of the slope – intercept form of linear equations: y=mx+b.
o   Compare different linear graphs.
o   Understand how slope and the y-intercept affect at graph
o   Compare linear and non-linear graphs.
Materials:  
·         Computer lab
·         Microsoft Excel



Phase One:  Engage the Learner
In the regular classroom:
·         Tell the students that they are going to the computer lab today.
o   This will spark their interest right away.  Middle school kids like going to the computer lab.  It excites them, even if it is to do math.
·         Before the students can go, they must first graph this equation by hand:  y=3x-4.
o   This is something they have already learned.  It should show prior understanding of the material.
·         Once they have correctly graphed the equation by hand, tell them that they are going to learn how to graph it on the computer. 

Phase Two:  Explore the Concept
In the computer lab:
·         Have the students log on to the computers.
·         Students are to graph their equation (y=3x-4) on the computer with one instruction:  they have to graph it in Microsoft Excel.
o   Students are good at using technology.  They also want to play around with computer on their own for the first couple minutes.  Instead of fighting this, I make it a part of the lesson. I want them to try to figure it out on their own
·         Give them about 5 minutes to try on their own.
·         For students who complete this, give them another equation to graph.
Phase Three:  Explain the Concept and Define the Terms
In the computer lab:
·         After the students have had time to try graphing on their own and fiddle with the computer, the teacher will demonstrate how to graph.
·         Not all students will be able to figure out how to graph on their own, so a demonstration or two is necessary. 
·         The teacher demonstrates by graphing the equation y=2x+4 on the projector while the students graph at their computers.
o   Go slow so all students can keep up.
o   Have some of the students who understand the process help struggling students.
·         The teacher demonstrates by graphing the equation y=2x+2 on the projector while the students graph at their computers.
o   Students will graph this equation on the same screen as the first equation.
o   Discuss with the class about the similarities and differences between the two graphs.
Phase Four:  Elaborate on the Concept
In the computer lab:
·         Teacher has the students graph these four equations on their own:
o   Y=2x-4
o   Y=2x
o   Y=2x+3
o   Y=2x+5
·         Once the students graph these equations, they need to make observations about the similarities and differences of the graphs.
·         Have students discuss these observations with the class.
·         Students should see how the y-intercept changes a graph.

·         Teacher now has the students graph these four equations on their own:

o   Y=x+2
o   Y=2x+2
o   Y=1/3x+2
o   Y=-2x+2
·         Once again, students make observations about the similarities and differences of these graphs.
·         Discuss these observations with the class.
·         Students have just seen how the slope changes a graph.
·         Talk about rate of change here was well. 
o   Slope is the rate of change.

·         As an extension, have students come up with an equation that is not linear, and have the students  graph that equation.
o   Why isn’t it linear?
o   What makes the equation different from a linear equation?

Phase Five:  Evaluate Students’ Understanding of the Concept
In the lab if time:
·         Give students a worksheet with groups of equations.
·         Have the students make predictions on how the graphs are the same and different using what they saw on the computer screen.
o   They should be talking about how the slope and y-intercept change the linear graph.
·         If there is time in the lab, they can check their answers using Microsoft Excel.
·         The Chapter Test will also be a way to evaluate the students’ understanding.

Lesson Plan from Barb Hascall:


5-E Lesson Plan

Integrated Math and Science                                                                                            
Barb Hascall
Introduction Angles of Polygons: 
The primary objective for this lesson is to investigate the relationship between the number of sides of a convex polygon and the sum of its interior angles using a linear model.  From there students will devise a formula to find the measure of an individual angle of a regular polygon.

Lesson Outcomes:
Students will make tables and graphs in excel
Students will describe the relationships between the number of sides, non-overlapping triangles and the sum of the interior angle measures.
Students will then make a conjecture based on their information about a formula to find the sum of the measures of the interior angles of a convex polygon.

Common Core Math Standards:
CC.9-12.F.BF.1 Build a function that models a relationship between two quantities. Write a function that describes a relationship between two quantities.

CC.9-12.G.MG.1 Apply geometric concepts in modeling situations. Use geometric shapes, their measures, and their properties to describe objects (e.g., modeling a tree trunk or a human torso as a cylinder).

CC.9-12.F.IF.8 Analyze functions using different representations. Write a function defined by an expression in different but equivalent forms to reveal and explain different properties of the function.

List of materials:
Computer
Paper
Straight edge
Pen or pencil

Phase One Engage the Learner:
Why do architects need to work with angles?
Do interior designers need to know angle measures of polygons?

Phase Two Explore the Concept:
1.  Discuss the sum of the angles of a triangle.
2.  Draw different closed polygons (triangle, quadrilateral, pentagon and so on). 
3. Talk about dividing the polygons into non-overlapping triangles.
4.  Record the number of sides, the number of triangles and 180 times the number of triangles for each polygon in a table.
Convex Polygon
Number of Sides
Number of Triangles
Sum of the interior angle measures
Triangle



Quadrilateral



Pentagon




5. Graph the number of sides vs the number of triangles, in excel and add a trend line.

Phase Three Explain the Concept and Define the Terms:
Terms:  polygon, convex, trend line, regular polygon, and interior angles.

Phase Four Elaborate on the Concept:
Students will be asked a set of questions.
1. Is there a relationship between the number of sides of a polygon and the number of triangles?
2. What do you notice about the relationship between the number of sides of a polygon and the number of triangles based on your trend line?
3. Can you use the number of triangles to find the sum of the interior angle measures of a polygon?  If yes, how?
4. Fill in the sum of the angle measures for each polygon.
5. Graph the number of sides vs the sum of the interior angle measures.
6. Add a trend line.
7. What does the independent variable represent?
8. What does the dependent variable represent?
9. What is the equation of your line?  Can this equation be simplified?

Phase Five Evaluate Students' Understanding of the Concept:
When students have completed their graphs they will be asked how to use the number of sides to find the number of non-overlapping triangles in any convex polygon.  Then they will be asked to write their formula and test it for other convex polygons.  Lastly they will be asked if they can find the sum of the interior angles of a convex polygon if they know the number of sides in the polygon.  To expand I would ask them if they could find the measure of one interior angle of a convex polygon and explain their reasoning.



About the Blog:

Blog Posting - In order to post to the blog, you must be an author. In order to become one:1) Open the email invitation and accept it by clicking on the link in the message.
2) Use your email address and password to access the blog at http://usdmathandscience2011.blogspot.com/ 
3) Follow the instructions on the blog

9 comments:

Brian.Schmuck said...

https://docs.google.com/document/d/1TW28jhMxd7kCscTbKYAUxY_-bex5XpNO6riJ_fZe6RU/edit?hl=en_US

Brian.Schmuck said...

5 E Plan
Brian Schmuck
Theme: Scientific Process
State Standards
9-12.N.1.1. Students are able to evaluate a scientific
discovery to determine and describe how societal, cultural,
and personal beliefs influence scientific investigations and
interpretations.
9-12.N.1.2. Students are able to describe the role of
observation and evidence in the development and
modification of hypotheses, theories, and laws.
9-12.N.2.1. Students are able to apply science process skills to
design and conduct student investigations.
9-12.N.2.2. Students are able to practice safe and effective
laboratory techniques.
Pre-Reading: McDougall Littell Biology: Section 1.3 Scientific Thinking and Processes and Study Guide
Day 1
Engagement:
Bellringer: Ask students to imagine that all of the birds around school are dying. How would you investigate the problem? Write out a brief description of your investigation. What stages of the scientific process are represented in your answer? Discussion
Go over key terms: observation, data, hypothesis, experiment, independent variable, dependent variable, constant, and theory
Do Qualitative and Quantitative Data Analysis Lab
Assignment: Worksheet

Day 2
Exploration
Penny Lab
Materials:
Various Pennies
Various pipettes tips cut at various lengths
Various eye droppers
Breaker of water
Paper towel
Lab Procedure:
Each student will have one penny and one eyedropper or pipette with a beaker of water and paper towel at their lab station. Students will place penny on the paper towel either face up or down (must be reported). Drops of water from the eye dropper/pipette will be placed on the penny. Total drops will be reported on lab sheet. Three trials must be recorded. Average the trials and report results on my excel program which will project the results on the board.
Questions
1) How is our data dispersed?
2) Why is it dispersed this way?
3) Should the distribution be a parallel or should it be sloped?
Possible Answers
1) The data has an uneven distribution
2) Pipettes and eye dropper had various openings, some coins were face up and some face down, coins were in different conditions of wear, different people doing the experiment, not enough trials
3) The distribution should be close to be a parallel

Day 3
Explanation
Explain how experimentation must be consistent
Experiment must have the same conditions
Pipettes of the same type
Coin in same position (all heads or all tails) and condition (try to have new coins)
When working in pairs, same people doing the same part of procedure each time
Elaborate
Repeat experiment only using same pipettes, coins in same position, and coins of the same newest year, do five trials.
Record and post data.
Evaluate (Due on Day 4)
Graph personal data and class data
Questions:
1) Is our data now more equally dispersed? Why?
2) Why is it dispersed this way?
3) Is the distribution more parallel? Explain how you know this

jerseyinsd said...

Lesson Plan – Density, Standard Deviation and Confidence Value
Submitted as part of the class requirement, “Integration of Math & Science”
Sam Glantzow [jerseyinsd]
Selby Area HS

1. Engagement. A pre-assessment will be made of the students’ knowledge of calculating density, and their knowledge of Excel and its capabilities [especially graphing]. The lab will be explained: groups will be given some pennies. Some groups will be given pennies that were made pre-1982, while others will get post-1982. They will be told to calculate the density of the pennies, and then calculate if their answer falls within a 90% and 95% confidence range.

2. Exploration. Each group will be given at least 25 pennies. A member of the group will calculate the mass of a number of the pennies. They will not be told how many pennies to use, but they will be told they will be repeating their testing four times, and will have to use a different number of pennies each time. The same person should not do the calculating of the mass for the four tests. The mass will be recorded. Another member of the group will fill the graduated cylinder with water. The pennies will be added to the water and the difference in the water levels will be recorded. The calculation of the density should be done after all four tests are done.

It is especially during this step that my evaluation of their working will be crucial. Are they writing down their results in tables or not? Do they know the formula for calculating density and are they writing the answer next to the values, or not? Is more than one person doing the calculating, in order to confirm the answer being written? Most importantly, is everyone in the group participating in the exploration?

3. Explanation. At this point, the make-up of the pre-1982 and post-1982 pennies will be given, and the density of copper and zinc will be given to the students. Since neither of the two types of pennies is 100% pure copper or zinc, they will have to calculate the density of the mixture. This will be done algebraically. The groups will compare their answers to the calculated answers. Discussion will occur as to why the calculated answer is not the same as the answer they got in the lab.

4. Elaboration. At this point, the students will get a brief overview on standard deviation and confidence values. A visual demonstration using a meter stick and a penny will be done. The meter stick has been on my table since the class begun. They will be told that somewhere under the meter stick there is a penny. I will hold up my hands about 40 meters apart and as how sure they are the penny is between my hands. I will then widen the distance between my hands and as again. They will see that, as the distance increases, so too does their confidence that the penny is between them. Hopefully they will make the link to the lab: the 90% confidence range will be narrower than the 95% range. We will then go to the computer lab where I will demonstrate how Excel can calculate both standard deviation and confidence values, and we will calculate the lab’s figures. The students will then answer what the pre- and post-1982 pennies were made of.

Time permitting, the class could calculate the make-up of 1982 pennies. They will find that, if there are enough pennies in the mix, their answers will overlap the density of the pre- or post-1982 values only if the confidence range is larger than 95%, because the switch from mostly copper to mostly zinc occurred during the year, and there is a mix of both in circulation.

Tyler Dahl said...
This comment has been removed by a blog administrator.
Mr. Smalley said...

Here is my curriculum project. It deals with speed time graphs and slop. It could be used with Excel.

http://smalleylabs.net/smalley.pdf

or

http://smalley.us/smalley.pdf

Thanks for a great week!

Jason Smalley

Rita Pedersen said...
This comment has been removed by a blog administrator.
Rita said...

Here is my project!
https://docs.google.com/document/d/1xFxY_hQDqr2T3nTRuNHkL-xaM_WkdUezX0cpU9xpZKg/edit?hl=en_US

Tyler Dahl said...

Tyler Dahl
tyler.dahl@k12.sd.us
Middle School Science and Biology
Lesson Title: Squeeze Test- Incorporating Excel Graphing into the Science Environment

Lesson Objectives
Students will utilize excel to make graphs.
Students will design an experiment to test hand strength over one minute.

South Dakota Science Standards
8.N.2.1. Students are able to design a replicable scientific investigation.

Lesson Length:
1 Day (May need a second day to wrap up)

Lesson Overview
Students will use loggerpro and pressure sensors to test their hand strength over one minute. Students will design an experiment and present their plan to me prior to proceeding. They will be in groups of two or three. Every loggerpro computer program will record the pressure every five seconds that the student puts on the 20 ounce pop bottle. Each student will participate and create their own individual graphs.
Materials:
Laptops with excel
Loggerpro and pressure sensors
20 ounce plastic bottles (3 or 4 per group- Bottles lose shape over time)
Paper and pencil

Engaging the Learner
Ask students:
Have you ever shaken someone’s hand and they have nearly broken your hand due to their amazing squeezing strength in their hand?
Brett Favre would tell teammates to, “Put it in the vice”.
Today we are going to examine hand grip strength over time. You will design an experiment to test your hand strength over one minute and then use excel to graph your results.

Explore the Concept
Groups will conduct experiment after discussing a way to properly test their hand strength. After the experiment, they will input their data into excel and create their data.

Explain the Concept and Define the Terms
Watch air pressure video:
http://www.youtube.com/watch?v=eIRwLcQ709A
http://www.youtube.com/watch?v=UDdRNXhIDwA
Define pressure and x/y axis.

Elaborate on concept
Discuss and Answer as a Group:
1. Did hand strength remain the same over time? If you did multiple trials, did this impact your hand strength?
2. What hand was stronger?
3. What were some problems associated with experiment? How could these problems be corrected?
4. Did the bottle hold it shape? Would that impact your results?
5. When is pressure important in science? Daily life?
6. Was excel an easier way to make graphs than the old pencil and paper method? Which do you prefer and why?

Evaluate Students’ Understanding of the Concept
Students show and discuss graphs with the class. Discuss as a class whether they would use excel in the future for graphing and if it is a valuable tool to scientist.

References:
http://www.youtube.com/

janetliesinger said...

Lesson Plan
Motion Graphs Introduction
Janet Liesinger
Objectives
1. Graph the relationship between independent and dependent variables.
2. Interpret graphs
3. Recognize common relationships in graphs
4. Use features of excel for the graphs and their relationships
Standards Covered
Apply the skills necessary to conduct scientific investigations
Use a control and change one variable at a time
Use correlation coefficient with graphs
9-12.P.2.1 Students are able to apply concepts of distance and time to the quantitative relationships of motion using appropriate mathematical formulas, equations, and units.
Phase One
Show different types of graphs and charts. Lots of things are represented in charts and graphs. Physics uses graphs for lots of different things. Up to now you have had to make these graphs by hand. After this activity in my class you will use your computer and Excel to get the job done. Give a “pre-quiz” to check Algebra I understanding of graphing.
Phase Two
Give the linear graph reinforcement work sheet. No help. Work in small groups 2-3. Good review of Algebra I (done by hand in class) Works well as an introduction to graphical analysis and the integration of math in physics.





Phase Three
Now show how all that they just did could be done on excel . Have them do the chart and graph on excel linear regression and explain what that is and how it relates to the graph made and other physics concepts.
What Does Regression Mean?
A statistical measure that attempts to determine the strength of the relationship between one dependent variable (usually denoted by Y) and a series of other changing variables (known as independent variables

Phase Four






Phase Five
Retest on graphs and using excel for lab reports. This will continue throughout the year because excel will be used all year for lab reports. Additions and extensions to excel will be added with “hopefully” cooperation from the computer teacher and the math department to accomplish cooperative learning in these three areas.
janetliesinger