Open Access. Powered by Scholars. Published by Universities.®

Education Commons

Open Access. Powered by Scholars. Published by Universities.®

Series

Science and Mathematics Education

Lesson Plans

Excel

Articles 1 - 29 of 29

Full-Text Articles in Education

The Rubber Duck Race, Amanda Klein, Mark Driesel Jul 2013

The Rubber Duck Race, Amanda Klein, Mark Driesel

Lesson Plans

This Noyce Scholarship Project has two purposes:

Mathematically the purpose of this exercise is to show that graphs are not a perfect representation of a concept; there are flaws and assumptions made. Students will be engaged in higher order thinking as they work through word problems for this demonstration.

Scientifically, the concept of erosion/deposition along a meandering stream and the water’s differential velocity can come into play in several areas of life. Recreationally; this would be important for rafting, canoeing, kayaking, fishing etc. When looking for a place to buy or build a house, erosional and depositional features ...


Blood Buffer Lesson Plan, Genevieve Criss, Theotis Daniels Jul 2013

Blood Buffer Lesson Plan, Genevieve Criss, Theotis Daniels

Lesson Plans

The intent of this lesson plan is to demonstrate a physiological model of the blood buffer system using an Excel Worksheet to calculate Henderson-Hasselbalch Equations for Bicarbonate/Carbonic Acid Buffer pair in Blood and an Agentsheets game to see a visual representation of the chemical process within the body. This will incorporate LeChatelier’s principle in regards to the equilibrium of acids and bases in a buffer system and show how to calculate the Henderson-Hasselbalch equation to understand the ratio of acid to base equilibrium.

The primary file is a lesson plan, accompanied by supplemental files.

In the supplemental zipped ...


The Stupendous Seismogram Study, Laura Arnold, Amanda Napieralski Jul 2012

The Stupendous Seismogram Study, Laura Arnold, Amanda Napieralski

Lesson Plans

This project addresses the following NYS Standards:

  1. STANDARD 1—Analysis, Inquiry, and Design: Students will use mathematical analysis, scientific inquiry, and engineering design, as appropriate, to pose questions, seek answers, and develop solutions.
  2. STANDARD 2 : Students will access, generate, process, and transfer information, using appropriate technologies.
  3. STANDARD 6—Interconnectedness: Common Themes : Students will understand the relationships and common themes that connect mathematics, science, and technology and apply the themes to these and other areas of learning.
  4. STANDARD 7—Interdisciplinary Problem Solving : Students will apply the knowledge and thinking skills of mathematics, science, and technology to address real-life problems and make ...


Blood Alcohol Content, Sarah Grossman, Nicson Martinez Jul 2012

Blood Alcohol Content, Sarah Grossman, Nicson Martinez

Lesson Plans

The way we can make use of this model in a classroom setting is by using it to explain to the students what Blood Alcohol Concentration (BAC) means, and how it affects the human body. The way this model works is the student will select a user to begin the simulation. Once they do that, the user character will appear in a party with a variety of drinks, both alcoholic and nonalcoholic. In this simulation the BAC of the user will increase by .05 (male) and .07 (female). If the BAC rate gets to .30 or higher, the user will ...


Ideal Gas Law, Daniel Burdette, Todd R. Thompson Jul 2012

Ideal Gas Law, Daniel Burdette, Todd R. Thompson

Lesson Plans

We created models with interactive physics, agent sheets, and excel and also found a web based application which could be used cohesively in a classroom to help students visualize the principles of the ideal gas law. The interactive physics and agent sheets models that we created represent what happens to a gas when it is compressed. The excel workbook helps the student understand the math behind the ideal gas law, and helps the student understand relationships of variables in an equation. The web based application mimics a physical experiment which displays the basic concepts of the ideal gas law.

This ...


Probability, Moneith Burney Apr 2008

Probability, Moneith Burney

Lesson Plans

Students will be able to solve probability problems and graph histogram.


Exploring The Area Of Rectangles And Their Applications, Brian Cheyne, Bonnie Bush, Dave Iacchetta, Pablo Lopez, Bruce Peachey Aug 2006

Exploring The Area Of Rectangles And Their Applications, Brian Cheyne, Bonnie Bush, Dave Iacchetta, Pablo Lopez, Bruce Peachey

Lesson Plans

We will explain how to find the area of rectangles using the TI 84 tutorial. We will use “Area Explorer” from Project Interactivate to demonstrate how to find the area of different rectangular shapes. A Pre-designed house plan from GSP will be given to the students (to be loaded in each computer) to simulate a floor renewal. Students will calculate different areas from the house floor plan and collect the data.


Modeling Precipitation And Water Budgets Using Stella, Sean Metz, Sandy Mcgreevy, Neill Paul Ii, Suzanne Wade, Kevin Westrich Aug 2006

Modeling Precipitation And Water Budgets Using Stella, Sean Metz, Sandy Mcgreevy, Neill Paul Ii, Suzanne Wade, Kevin Westrich

Lesson Plans

Students will be able to build water budget charts represent particular areas water budget using numerical and graphical models.


Moth Flakes Or Moth Nuggets, Jeff Mckinney Jul 2006

Moth Flakes Or Moth Nuggets, Jeff Mckinney

Lesson Plans

There are several topics being covered in this lesson (lab). The students will receive either moth flakes or moth nuggets. They will chart the freezing of these substances and compare their data with other groups. By creating a graph, students will learn that while a substance is going through a phase change, the temperature of that substance will not change. That is the primary goal of the lesson. Secondary to that is the fact that different substances freeze/melt and vaporize/condense at different temperatures. This illustrates that phase changes are characteristic properties and can help to identify substances as ...


Flooding Along The Lower Delaware River, Thomas Demond Jan 2006

Flooding Along The Lower Delaware River, Thomas Demond

Lesson Plans

The Delaware River valley has experienced a considerable amount of unexpected flooding this past year, and the Army Corps of Engineers has asked us to help come up with a plan to stop the high water from endangering communities along the lower Delaware River.

Of particular concern is the city of Port Jervis, NY and Matamoras, PA. These two towns are situated at the base of the Catskill Mountains and are in a low valley. To further compound the problem, the Neversink River feeds into the Delaware just South East of Port Jervis.

Back during the ice age, the glaciers ...


Ecological Footprints, Brian Cheyne, Brigitte Cerra Jan 2006

Ecological Footprints, Brian Cheyne, Brigitte Cerra

Lesson Plans

Students were asked to evaluate: What impact do we as individual have on our environment? What impact do we as a school have on our environment? In what ways can we reduce the impact we have on our environment?


Using The Difference In Daylight To Investigate Linear Relationships, Amy Lynn Cifelli Jan 2006

Using The Difference In Daylight To Investigate Linear Relationships, Amy Lynn Cifelli

Lesson Plans

My group of students was a mix of four ninth grade students enrolled in our Algebra I course. For our project I wanted to look at what was meant by linear and to see if they could tell the difference between linear and nonlinear relationships. I emphasized that there had to be a constant rate of change in order for a relationship to be linear. The relationship we looked at was the difference in amount of sunlight between Juneau Alaska and Albion New York. We started by looking at just the month of January. The students had to put the ...


Bullseye Models Using Excel And Geometer's Sketchpad, Heather Hoad Dec 2005

Bullseye Models Using Excel And Geometer's Sketchpad, Heather Hoad

Lesson Plans

Throughout this problem students explored the concepts of probability, percentage, and graphic representations of data. Students began by discussing the variables involved in playing a game of darts including: player skill level, strength, accuracy, coordination, gravity, etc. They then made hypothesized the number of darts out of 100 attempts that would land in each of the point value areas. During the remainder of the project, the class tested their hypothesis through a real life dart board model and an online dartboard simulation model. Students used a real-life magnetic dartboard to collectively gather data on 100 darts thrown and an online ...


Catapult - Throwing Device, Maria Huot Dec 2005

Catapult - Throwing Device, Maria Huot

Lesson Plans

Students will use multiple modeling tools to have conceptual, mathematical, and physical control over, at least, one of the variables in the design of a “Throwing Device”, to accomplish the desired goal. For safety reasons, all the devices must have a trigger mechanism.


Force And Extrusion In The Food Industry, David Rogers, Beth Hall Dec 2005

Force And Extrusion In The Food Industry, David Rogers, Beth Hall

Lesson Plans

Students will use Interactive Physics to “model” the forces needed to extrude Play-Doh. Modeling will allow the prediction of force to push flexible material through extruders. Students will compare surface area to force. Excel was used to collect data.


How Long Will The Earth’S Oil Reserves Last?, Miriam Santana-Valadez Mar 2005

How Long Will The Earth’S Oil Reserves Last?, Miriam Santana-Valadez

Lesson Plans

This is a model that examines the question of when the worlds oil will run out. Students can change variables such as average miles traveled per car, number of cars, and gas mileage to see the effects on the model as a whole.


Driven By Data, Larry Bedgood Dec 2004

Driven By Data, Larry Bedgood

Lesson Plans

Students should enjoy the experience of creating/designing their forms on the computer using WORD and EXCEL software. Students will use calculators at first to sum and find statistics, and later use EXEL and should be able to conclude it was easier to use EXCEL because or the additional reporting opportunities. Students will be exposed to work in STELLA.


Potential And Kinetic Energy With A Pendulumn, Jacqueline Keily, Frank Rinere, Annette Pennella Aug 2004

Potential And Kinetic Energy With A Pendulumn, Jacqueline Keily, Frank Rinere, Annette Pennella

Lesson Plans

Students will learn that Energy and matter interact through forces that result in changes in motion, potential and kinetic energy are directly related to the operation of a pendulum.


Early Evolution, Daniel Esler Jul 2003

Early Evolution, Daniel Esler

Lesson Plans

Upon completion of this lesson, students will: · Have a better understanding of the characteristics of early Earth · Have a better understanding evolution · Be able to manipulate parameters in Agentsheets · Be able to create spreadsheets in Excel


The Big Dig!, Chioma Owunwanne Jul 2003

The Big Dig!, Chioma Owunwanne

Lesson Plans

How do Archeologists and Forensic Scientists determine the height, build and age of a person based upon the lengths of major bones such as the humorous, radius or tibia?


Ny State Standard :Key Idea 7 Patterns/Functions, Dion Rahill Jul 2003

Ny State Standard :Key Idea 7 Patterns/Functions, Dion Rahill

Lesson Plans

By the end of this lesson, all students will be able to calculate the amount of monthly payments at a given interest rate for a specific loan using Excel. They will also calculate the total cost of the loan.


Ice Cream Graphing Lab, Julia Maloney Jul 2003

Ice Cream Graphing Lab, Julia Maloney

Lesson Plans

Guided data collection through graphing with provided example.

Student survey will be conducted in the classroom, focusing on the (3) favorite flavors of ice cream, frequency of eating ice cream, soft versus hard and preference for brand of ice cream.


Does Exercise Affect A Person’S Heart?, Lisa Englert Jul 2003

Does Exercise Affect A Person’S Heart?, Lisa Englert

Lesson Plans

1. Students will count off 1-7 forming 7 groups of 4. 2. Assign each group an exercise: sit-ups, jump rope, running in place, hand weights, walking and jumping jacks. One group will be a control at rest. 3. Each student in the group will perform the exercise for a total of 20 minutes, taking a pulse rate every 2 minutes and record. 4. Students are to enter the data onto an EXEL Spreadsheet. A summation of the “20 minute” data for the 4 students is then averaged. 5. A class data is added to spreadsheet by having the students post ...


Oh, Deer (Population Dynamics Using Excel), Paul Geary Jul 2003

Oh, Deer (Population Dynamics Using Excel), Paul Geary

Lesson Plans

The learner will be able to identify the carrying capacity, and population trends of an animal population. The learner will be able to understand the interaction of one population is dependent upon another in an ecosystem and see how non living factors play a vital role in that ecosystem. The learner will demonstrate their proficiency in their understanding in these things by participating in and completing the “Oh Deer” lab.


How Does A Little Add Up To A Lot?, Stephanie Monk-George Jul 2003

How Does A Little Add Up To A Lot?, Stephanie Monk-George

Lesson Plans

Students find the amount of water wasted due to a leaky faucet as a result of designing and carrying out their own experiments that model this common, real-world situation. Graphing their data, students are then able to write an equation for the line of best fit. This equation, in turn, allows them to make predictions concerning the amount of water wasted over a long period of time or the amount wasted by multiple leaks.


How To Manage Your Money, Maria Roman Jul 2003

How To Manage Your Money, Maria Roman

Lesson Plans

This lesson will teach students how to manage the money earned from a summer business. Students will have a lemonade stand, offering lemonade, ice tea, cookies, and twinkies. They will use Microsoft Excel to calculate the amount they need to start up the business, and to keep track of their expenses and revenue each week. They only need Microsoft Excel to do this lesson. They will also have to create their own spreadsheet according to their needs and vision.


Population Simulation With M&Ms, Michael Baskin Jul 2003

Population Simulation With M&Ms, Michael Baskin

Lesson Plans

This activity involves two simulations with M&M`s® to explore population growth and decay. The follow-up activity, Population Simulations with Calculators introduces NOW-NEXT or recursive equations as an accessible way to model this behavior and expand to other population models.


Ecological Equilibrium, Daniel Esler Jul 2003

Ecological Equilibrium, Daniel Esler

Lesson Plans

Upon completion of this lesson, students will: · Have been introduced to computer modeling. Have a better understanding of setting up and utilizing the functions of Microsoft Excel. Have a better understanding of the complexities of the ecological equilibrium time and evolution have created


Toothpickase Activity, Karen Mccann Jul 2003

Toothpickase Activity, Karen Mccann

Lesson Plans

1. Enzyme activity 2. Enzyme reaction rates/slopes 3. Use of the TI-83 4. Use of Excel 5. Regents Living Environment Standard 1 and 4