Home

Student Environmental Database

Schmied/Hartford©2010

Well fed and content Red Legged Frog (Rana aurora) Tadpoles

Introduction:

Another way to enhance learning while raising frogs is to keep track of the environmental data the students collect as the frogs develop over time. By entering data gathered daily onto a simple database or spreadsheet, students can compare data from different schools, classrooms, and changes over time. Many different ideas and conclusions may be drawn from this data. Data can be directly graphed and printed if your software is so equipped, or students can manually plot the data for display.

You can create either a spreadsheet or a database in this format. Spreadsheets graph easily while databases sort information quickly. Some spreadsheets, like Excel, do both on the same document! You can use any program that fits your need! The framework below gives you an example of the different fields (categories) you can put in the software program you choose to use.

See our database objectives and project description below this example!

Date
Life stage
Temp in degrees F
Acc Temp Unit
Length in cm
Ammonia in ppm
pH
population
Tank Location
Recorder's Name
26Feb97
egg
65
33
.3cm
<0.01
7.0
250 eggs
Mann #1
Bill G.

Create and analyze a database that documents environmental parameters versus frog development.

Database Objective:

Students will be able to observe, record, search, sort, analyze, and share database information for use in identifying variables that affect the growth and development of frogs.

Database Activities

A database is used to record, sort, analyze and share information gathered by students about the frogs and their tank environment at and between each habitat. It is also used to analyze changes in environmental factors.

Product and Outcomes

  • Two working data bases are created, one at each habitat site.
  • Each is identical in construction and monitors similar variables with one distinct variable difference controlled for experimental comparisons.
  • Information is shared between classrooms via electronic chat line or email.

Assessment

  • Database includes name of recorder which is used to evaluate accurate recording of information.
  • Student's ability to do searching, sorting, and analysis of data are assessed commensurate with grade level using a performance based teacher checklist while in a computer lab setting.

Resources/Preparation

  • computer with database software
  • data base format designed in advance
  • discs for lab database work
  • internet bookmarks for amphibian sites. See our bookmarks and references page!
  • assign rotating database jobs among students
  • teacher checklist for database performance assessment
Home