This is an example of the database after a two criteria search was performed (Female, White Forelock). As can be seen, in this class's sample, there were 26 Females that had white forelock.
Here is the data, graphically represented in Excel.
Welcome to the MS Computer Lab Blog!
The objective of our blog is to share information about how we integrate our technology curriculum into the subject area curriculum. The foundation of this effort is the methodology of team teaching the lessons with the Middle School subject area teachers. Each post describes a particular lesson, the software used, some of the skills that were targeted, and the number of days that were spent in the lab.
Click to enlarge
_________________________________________________________
Tuesday, October 21, 2008
Genetics, Filemaker Pro and Excel
The 8th Grade Science students surveyed 20 people for eight different physical traits. In the computer lab, they created a database with fields for these traits, entered the data from their survey and then exported that information in a file that they placed in their public folder. Later on, they imported all their classmates' data, which totaled more than 400 records. With this sample, they were able to sort the data and determine how frequently these traits occurred in males and females. Afterwords, the students made data tables in Excel and graphed their findings.
This is an example of the database after a two criteria search was performed (Female, White Forelock). As can be seen, in this class's sample, there were 26 Females that had white forelock.
Here is the data, graphically represented in Excel.
This is an example of the database after a two criteria search was performed (Female, White Forelock). As can be seen, in this class's sample, there were 26 Females that had white forelock.Here is the data, graphically represented in Excel.
