NS.Patterns in Penguin Data, Using Spreadsheet to enhance OpenSciEd Field Study Unit 8.6, Lessons2&3
Channel: James Emmerling
Date: 2021-02-11

When scientists gather data in the field, they keep record of it in a notebook and sometimes in a computer.  When they return to the lab or office, the data is usually entered in a spreadsheet program to help them organize and analyze the data.

This video provides instruction for using the Heritable Trait Variations Data in Penguins in a Google spreadsheet as an alternative to the penguin data strips in lessons 2 & 3 of OpenSciEd Unit 8.6.  It will show you how to use the data set, how to hide rows and columns, and how to share it with your students.

This is a link to a viewable copy of the NS.L2 Heritable Trait Variations in Penguin Google spreadsheet, https://bit.ly/381OBcJ  Make a copy of it so it can be used as described in the video and lessons.

UPDATE:  
1. All penguin names link to their data cards.  Also, the colored square on the bottom of the ancient penguin strips are linked to the map of that time period.  
2. A 4th sheet has been added in the tab, "4. Color Coded Variations".  This sheet is a copy of, "3. Penguin Traits" that has been Conditionally formatted so the variations are different colors.  This might make it easier to sort the data.  If you choose not to use this sheet, it can be deleted by right clicking on the tab, and selecting 'Delete'.  To teach students how to conditionally format data; 1. select the area to be formatted (click the empty box in the upper left corner of the sheet (left of 'A' and above, '1') to do the entire sheet).  Then click, 'Format' and select 'Conditional formatting'.  A 'Conditional format rules' toolbox should appear.  Click, 'Color scale', then 'Default' (under 'Preview') to select the desired color scheme.