Showing posts with label online database. Show all posts
Showing posts with label online database. Show all posts

Tuesday, January 9, 2018

Seeing the Forest Through The Data




How Do Teachers help their students to 

SEE Their TREES THROUGH THE DATA?  



Here's How One Teacher is Doing it...


Overlook Middle School Teacher, JoAnn Mossman continues to add layers of learning for her students eight years into Schoolyard Ecology study at Overlook Middle School.  


During the Looking at Data Workshop for Teachers at Harvard Forest on Dec. 8th,  JoAnn developed a series of resources to help students approach graphing their project data step by step. 


 Joanne's Data Goals :

I definitely want to have the kids do one graph by hand so I'm looking to see if there is an easier way to access the data using the online database for them to pull out the correct info. to graph. I also want them to learn to generate the graphs from the HF site like we can, maybe this would be appropriate for the more difficult graphs/data. They need both experiences. 


In this blog entry,  you will see how JoAnn breaks this down in a way students can understand and succeed in creating graphs of their own data.    She wants students students to learn to organize their data in such a way as to be able to represent the data visually in graphs that will help them to understand what story their data is telling. Each of the worksheets can be downloaded from our website for use in other classrooms.  Please see links at the bottom of this blog to access them. 

Step 1:


Students look at the growing season of all of our trees created with the HF graphing site. We have 2 years with particularly sharp drops in growing season. JoAnn left the graph up on the board the whole time. The class discusses what the Julian Day means and how it is easier to analyze data using that rather than a specific date.


The graph above, created using the online graphing tool, shows the Growing Season for all years based on the average 50% leaf fall date and average length of the growing season by year for Overlook MS.  




The graph  above, also created using the online graphing tool,  shows the selected variable as a function of date (one or more trees), day of the year (one tree), or year (one or more trees). The legend shows the ID number and species code for each tree.  Growing Season is the number of days between the 50% bud burst date and the 50% leaf fall date.

Step 2:


Teacher JoAnn Mossman,  passed out bud burst edited data and the graphing data worksheet as shown below.  She then  showed them how to find their tree and bud burst day. While they are working she walks around and tell them the Julian Day of their birthday so they get the idea. 


Note that this table would go on year by year to most recent data. In this case,  Overlook Middle School has data up through Fall 2017 to work with.  Full data for this site  is available on the database and as an Excel file in links below. 

Students  do the same with their leaf fall edited data packet.



Note that this table would also extend through most recent year's data. 
















Step 3. Students  calculate the growing season each year for their tree. 



Students then use the growing season data sheet to check their math.




Step 4:  Students graph their tree's growing season. 


It should look like the one up on the board (from the HF website). If it doesn't look the same the class will talk about why and check their data and graphing.



 









Students  combined growing season for all trees on the graph above using Google Sheets


Note: Teachers can choose to have students generate a graph using Excel or Google Sheets, such as the one above;   hand graph;  or use other graphing programs as preferred.

Step 5. Students  will analyze their graphs and answer questions such as:

     Which year did your tree experience the longest (and shortest) growing season? What factors may have contributed to the length of that season?
     Do you see a trend in the number of days for your tree's growing season (going up or down)? What is the average number of days?




 Links to the worksheets used for this sequence of lesson plans:


Mossman.2017. Budburst Data Table.

Mossman.2017. Leaf Fall Data Table.

Mossman.2017. Growing Season Data Table.

Link to Student Graphs: 


Links to Database:


Download Data_list.php

HF Online Graphing Tools.php


Links to more lesson plans and activities

 by Buds, Leaves and Global Warming Teacher, JoAnn Mossman: 


Mossman. 2011. Graphing Activities.

Mossman. 2014. Connections to MA Frameworks and Next Generation Science Standards for HF Schoolyard Ecology Buds, Leaves and Global Warming Study.

Mossman, J. 2017. Striving for Good Data. Oral Presentation

Mossman, J. 2017. Outdoor Field Visit Rubric


Friday, July 1, 2016

Pictures of Spring in Photos and Data

The Data is In; What did Spring Looking Like this Year?



On Friday we went up to the pool for the last time this year. We also returned some of the critters we had been keeping in the classroom. I also just uploaded all the data for this spring.

Judy Gibson, Francis Parker Charter School, Devens, Ma. 

---------------------------------------------------------------------------------------

NEW DATABASE FEATURE:

Field Site Photos can be shared in Field Site Description section of the online database.



Teachers can email their field site photos to Emery Boose to post on the online database at any time.
Excerpt from HF Schoolyard  Field Site Data Base with link to Photo Above

Schoolyard teacher, Janet Gordon has sent this photo of her field site from Tewksbury High School.  See all sites' field site data at:  http://harvardforest2.fas.harvard.edu/asp/hf/php/admin/k12/k12_sites_list.php




Views from New York City



     


Photos and Excerpts from Brooklyn Technical High School students led by teacher Elisa Margarita.  In her first year with the Schoolyard Ecology program, Elisa collaborated with veteran Schoolyard Teacher, Lise Letellier from Holyoke, Ma. to engage her students in analyzing and interpreting data.  


Mei Hua Mei's AP Environmental Science Harvard Forest Schoolyard LTER program Report. 



Explanation:
The question of global warming and climate change is the theme of this experiment and the effect of both may be demonstrated through this intensive research conducted by Harvard's long term ecological research. Although  the data presented above is only a small portion of the large platter of information presented to Harvard yearly, my data and the data collected this year is contributing to a larger look at the effects of climate change and global warming on our ecosystems. Climate change is creeping up on us, and we do not even realize it. Throughout the years, our ecosystems have been slowly changing and we may not have noticed because of these slow changes. With year after year of contributions to the study, Harvard is able to piece together a broad spectrum of the effects of Climate change; effects that may not to obvious to us in our day to day lives. 


Wrapping Up:
Through this experience, I was able to learn about collecting data and conducting research. It felt really great to be apart of a study that has been running for so long. It was truly an honor to be able to say “I am doing a project for Harvard.” Since this project started in the beginning of APES class, it was a good introduction to the skills we would need for the rest of the year. For example, we learned how to collect data, take measurements, identify trees, make observations, handle tools, work as a group, and more. So, not only was the Harvard Lab an honor to conduct, it was also a vital introductory project that would lead us to the rest of the course with an understanding for conducting research and working as scientists in a group. 
This project was very eye opening and interesting to conduct. However the class and I encountered some difficulties. Since we did not have(past) data for our trees, we had to use data from another school. This presented a loss of purpose for the assignment because a large portion of our report went to analysing information for a tree we did not observe. This problem can be easily fixed by entering the data for our trees onto the Harvard database. 
My favorite part of this project was having an opening and closing for our APES year. The Harvard Project was our opening assignment for the school year and one of the last assignments in the closing of the year. We started this project with all of our Firsts of the year. Our first time going to fort greene for class, our first time doing a lab, and our first time working in groups with kids that we barely knew. And by the end of the year, when we went out again to take our Spring data, it was our two hundredth time going to fort greene for class, our nine hundredth lab, and our fiftieth time working in groups with our closest schools friends.
-----------------------------------------------------------------------------------------------------------

Mohamad Amin                                                                                                                6/12/2016
AP Environmental Science

Harvard Forest Schoolyard Ecology - American Elm and Red Maple

            Our tree was an American Elm, or Ulmus Americana, it is a deciduous tree with a range all across the eastern United States, it favours a whole range of habitats but generally likes being near areas with lots of water. It is a highly resistant tree, the common enemy of this tree is the Dutch elm disease. It has elliptic to lanceolate leaves that are pinnate and serrated, the leaves are arranged alternately. This tree has a long growing season and can continue growing into the late fall, unaffected by the loss of sunlight.
            This experiment was a group project, as a group we were free to select a tree and we chose the American elm. During the autumn we measured the rate at which the leaves of the tree changed colour and when/if the trees finally separated from the branch. This was a weekly task and continued until winter. Once winter was over and spring began, the project restarted with a different focus; we were to measure the buds of the tree and see how long it took to begin sprouting new leaves.




            Due to complications involving our data, I was not able to complete this project using my own data. Instead I had to use data from the Harvard Tree database. As of such I chose a Red Maple from the data taken by Holyoke Catholic High School. The Red Maple is another extremely hardy species with a varied habitat.
The data taken from Holyoke indicated that this tree quickly bursts and gets it leaves during the end of April and beginning of May. The Red Maple would go from no leaves at all during the week of April 20th, it would have seventy percent budburst during the following week and by the tenth of May it would be fully opened.



 Leaf Length follows similar trends to the budburst. The tree is completely devoid of leaves until the end of April but once the buds have burst, the  leaves grow rapidly. They reach 2 centimeters by the end of April and quickly jump up to the 10 centimeters by around the beginning of May. After it has reached ten centimeters, it quickly flattens out and stops growing. This is indicative of quick growth and it would mean that Red Maples can quickly establish themselves.



Trends can also be seen with the changing of leaf colours for the Red Maple. The Red Maple seems to have a slight on or off switch with the colour change. For the majority of the year, since it gains its leaves they maintain a solid 2.0 tree color. However during the week of 23 October, the tree undergoes a radical shift and the leaf colour shifts radically. It gains its famous red coloration and is part of the standard colour changing during the autumn season. The colour changes rapidly from green to red, once the change begins and completes itself within the week, the colouration does not change much anymore.

The amount of leaves that have fallen from the trees followed similar trends too. The tree would be completely fine for most of the year until a week in October. The week of October 29th saw the Red Maple completely lose all of its leaves. It was not even a period of a week, it was closer to four or five days, but in that time the Red Maple managed to go from 0% leaf lost to 100% leaves lost. During this time, Data was only taken twice between the time it went from 0 to 100 percent lost. At one point it was at 40 percent but by the next time of data collection, all of the leaves had fallen.

This project was a complicated a long term one. The American Elm tree that we originally selected was a major part of it, we got a lot of data on it but the fact that it was not very organized (the Spring data was submitted and we didn’t have a backup) meant that it could not actually be used for this report.



Spring Budburst Data Looks Like this from across 4 Schools: 


Westfield, Mass.  


Easthampton Mass.

  
 Holyoke Mass.




Worcester, Mass. 


Explore more data from this year


To see all data entered to our database this year go to:


download Schoolyard data


To see sites and their data on our interactive site map go to: 

Interactive site-data map















To graph data from any of our Schoolyard field sites, go to:

Online graphing tool



Stay Tuned for part 2 of Looking at What Spring Data Looks Like..from Harvard Forest Ecologists and Schoolyard resources..Coming Soon

Tuesday, October 28, 2014

We are serious about your data!  

Harvard Forest LTER Schoolyard Ecology recognizes that without data, the scientific process in not complete.


So your students have gone outside to collect data at or near your schoolyard-Wonderful!!!  We are thrilled that you were able to set up your field site and do the extra organizational work of getting your kids outside!  We know that that alone is further than most teachers get in engaging their students in real science in their local environment. Congratulations!  You have succeeded in a crucial part of your Schoolyard Ecology study.  

Now, we want you to make sure that you and your students are able to make meaning out of what you have done in the field.   We need you to submit your data onto our online database in order to understand what the field data is saying.   While the data is fresh, enter it on our simple  online database.




We will post the data on our website so it is available to you and your students over time. It will also be available to other sites who may want to compare their field site data to diversity of locations to make even more meaning of their study. 

Once your data is on our database, you and your students can begin to represent your data in tables and graphs so that it can be more easily interpreted.  You may want to lead your students in hand graphing, or try a computer-based graphing system such as Excel.  Perhaps the quickest approach is to try out our 
online graphing tool


 We recommend that you do take the time to have students hand graph, and/or create graphs using a software system that requires them to think about how to organize the data, label axis, and other graphing skills.  Our online graphing tool is designed to add to these other more time and thought intensive ways of representing student data.  

Teachers- We invite 1st year teachers who would like to get started on learning how to manage project data to come to our: 
Level 1 Data Workshop for Teachers on November 5th at Harvard Forest. 

Information Manager, Emery Boose, will briefly show teachers how professional ecological data is stored and managed at Harvard Forests. He will then focus on how Schoolyard data is stored and managed;how to input data using our online data base; and how to create instant graphs 
using the online graphing tool. Break out project groups will meet with ecologists to talk over any field issues, questions, and data related issues and questions.  Teachers will go away from the workshop understanding how to input project data onto the database; how to graph project data on the online graphing tools: and how to engage their students in better understanding what their data is saying.  

Teachers who have already successfully mastered the online data input process, are invited to attend our more advanced data workshop called, LOOKING AT DATA:  Organizing, representing, interpreting your students’ data.


See Advanced Data Workshop Highlights to get a peak at how this workshop went last year. Teachers at this workshop choose to work at level 2 or 3 on this day.  Level 2 teachers  work on structured graphing exercises that help provide experience using Excel to graph project data. See the  Graphing Manual   and Graphing Exercises that form the basis of this workshop developed by ecologist, Betsy Colburn.  At the end of level 2, teachers go away having created a series of data tables and graphs from real Schoolyard data sets that are preselected by Harvard Forest staff.    

Those teachers who have completed level 2 previously, are encouraged to work on graphing their own project data, in ways that tell a story that will be meaningful to their own students. For that reason, teachers in level 3 decide on their own focus prior to attending the workshop. 

 Harvard Forest provides mentors that support teachers in determining  how to organize their data, and helps trouble shoot throughout the graphing process. Usually level 3 folks go away having created one or more graphs of their students' data that is specifically tailored to their learning goals.  To see examples of graphs and datatables that level 3 teachers have created in the past, go to: Data Level 3 graphs and tables

So join us for a data workshop this fall and ...

SHOW US YOUR DATA!