# Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

###### Description

In this activity, students use the built-in functions in Excel or Google Sheets to explore different ways of filling in cells with a series of numbers, copying and pasting formulae, and referencing individual cells to use in calculations. Students apply what they learned by making different calculations with beak size measurements of Galapágos finches.

The activity introduces students to basic Excel functions routinely used in scientific research. They use these functions to calculate range, sum of squares, variance, and standard deviation.

You may download the Excel version of the activity or access the Google Sheets version.

###### Student Learning Targets

Use a spreadsheet program to calculate range, sum of squares, variance, and standard deviation.

##### Details

absolute reference, analysis, calculation, data, Galapágos finches, range, relative reference, variation

The resource is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license. No rights are granted to use HHMI’s or BioInteractive’s names or logos independent from this Resource or in any derivative works.

##### Curriculum Connections

Math.N-Q.1, Math.F-LE.5, Math.A-SSE.3, Math.A-REI.3, Math.S-ID.5, Math.S-IC.3; MP1, MP2, MP4, MP5