Home » 2017 » September

Monthly Archives: September 2017

Autumn Leaf Safari Ecology Data Collection Activity

energize education through open sourceOne of the two people who reviewed my book on Amazon stated that he was disappointed as he expected a collection of lesson plans with open source technology integrated into them.  My line of thought was that I’d put enough effort into researching, organizing and presenting the book’s contents that I really didn’t want to construct lesson plans to go with the software.  Here, I attempt to amend this.  This activity incorporates science (ecology), mathematics and physical fitness.  As this involves going outside, choose a week when the weather looks most cooperative.

This would work best with students in primary grades, but could be modified for intermediate-level students with ease.  The best time for this is at the height of the fall season, when plenty of leaves litter the ground.  Each student will need a plastic grocery bag or food storage bag.  Each student will also need a Leaf Sorting Sheet (see below) and access to an electronic spreadsheet.  In keeping with the open source theme of this blog, I chose Libenergize education,libreofficereOffice Calc, but any such application will do.  At the end of this article there are links to download the Leaf Sorting Sheet, in ODT format, and the Leaf Tally Sheet spreadsheet, which is in ODS format and can be used as a template to design your own.  Note that the species of trees listed on these two items are indigenous to the northeastern United States, so please feel free to adapt them to match species found in your vicinity.

Introduce the activity by asking if anyone knows what a safari is.   Tell your students that we’ll be going out to the playground on a leaf safari and, in so doing, will learn a little about local ecology.  They are to collect as many leaves as they can, but they should try to select a variety of leaves.  When we’re finished, we’ll take a look at what we’ve got and make spreadsheets and graphs showing our findings.

Head out to the playground, preferably between recesses, so your students will have fewer distractions.  Give them 20 minutes to complete this task.  They can work with a partner, if desired.  At the prearranged time, call them back and head back to the classroom.  Each student/group will need a Leaf Sorting Sheet.  Give the students 10 minutes to sort their leaves and be prepared to answer any questions that may arise regarding leaf types and sorting practices.

energize education thorugh open source,libreoffice calc
The author’s completed spreadsheet.

When the sorting is finished, you can have your students open the spreadsheet that you have previously created.  I’d suggest using mine as a template and make any changes needed to it.  Anyway, each student, or group of two students, should have his or her own spreadsheet into which they will enter the quantity of each collected leaf type.  When done, guide the students, if necessary, preferably using a projector connected to your computer, through the chart creation process.  This will provide them with a graphical representation of their leaf collections.  These graphs can be printed and put on display in the classroom.  For closure, ask students what they may have learned while doing this activity.  Were some species of leaves more prevalent?  What does this tell you about the kinds of trees that grow in this area?  Now that you now how to put data into a spreadsheet and to create graphs, in what other tasks could you use these tools?

I hope you’ll find this activity useful and that you and your students both enjoy and learn from it.  I welcome any comments or ideas.


Leaf Sorting Sheet

Leaf Tally Sheet

LibreOffice Web Site