Skip to main content
HHMI BioInteractive
  • Español
  • Site Search
  • Log In/Create Account
  • BioInteractive Resources
  • Planning Tools
  • Professional Development
  • About Us

Spreadsheet Tutorial 1: Formulae, Functions, and Averages

Image from the activity

Topic

  • Evolution
  • Speciation
  • Math & Computational Skills
  • Data Analysis
  • Statistics

Resource Type

  • Activities
  • Lessons

Level

High School — GeneralHigh School — AP/IBCollege
Used In
1 BioInteractive Playlists
Saved By
20 Users
Share This

Description

In this activity, students use the built-in functions in Excel or Google Sheets to calculate the mean and median. Students apply what they learned to a dataset beak measurements of Galapágos finches.

The activity serves as an introduction to spreadsheet programs. It describes the basic organization of a worksheet, how to organize and format data, how to perform simple mathematical calculations, how to use built-in mathematical functions, and how to select and manipulate a range of numbers.

Student Learning Targets

Using spreadsheet functions, calculate the mean for a set of measurements.

Estimated Time

One to two 50-minute class periods.

Key Terms

analysis, calculation, column, data, formula, function, Galapágos finches, range, sorting, variation

Terms of Use

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.

Version History

Date Published 09.15.15
Date Updated 04.22.16

Common Core (2010)

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

AP Biology (2019)

SP5

Materials

Worksheet (Google Sheets link)
Worksheet (Excel) 88 KB

Additional Materials

If using the Excel Worksheet (optional), students will need access to a spreadsheet software for analysis and graphing.

Use This Resource With

Activity Resource
Evolution in Action: Data Analysis

Educator Tips

Hear how educators are using BioInteractive content in their teaching.
Educator standing in front of an image of a spreadsheet. Play Video Next Slide Next Slide
/
1-Minute Tips

Spreadsheet Tutorials

Takisha Reece describes how her students use BioInteractive's spreadsheet tutorials to learn how to use spreadsheet applications for data analysis and statistics. Her students use these applications to analyze their data, and then to produce charts and graphs for their poster projects.
View Article
Previous Slide Next Slide
Close Modal

Explore Related Content

Other Resources About Spreadsheets

Showing of
Image of an animal drinking from a watering hole
Lessons
Building Ecological Pyramids
Image from the activity
Lessons
Spreadsheet Tutorial 4: t-Test
Image from the activity
Lessons
Spreadsheet Tutorial 5: Histogram
Image from the activity
Lessons
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
Image from the activity
Lessons
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean

Other Related Resources

Showing of
Image from the activity
Lessons
Spreadsheet Tutorial 4: t-Test
Image from the activity
Lessons
Spreadsheet Tutorial 5: Histogram
Image from the activity
Lessons
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
Image from the activity
Lessons
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
Photos of four lizards taken from the interactive.
Virtual Labs
Lizard Evolution Virtual Lab
Photo of elephants in the wild
Lessons
Using Data to Investigate Elephant Evolution
Data Explorer text on a background of charts and graphs
Tools
Data Explorer
Image from the activity
Lessons
Evolution in Action: Data Analysis
Screenshot of the virtual lab
Virtual Labs
Stickleback Evolution Virtual Lab
Image of stickleback cards from the activity
Card Activities
Using Genetic Crosses to Analyze a Stickleback Trait

This Resource Appears in the Following Playlists

Showing of
hhmi-card
Teaching Statistics and Math Using Spreadsheet Tutorials and Galapágos Finches
Teaching Statistics and Math Using Spreadsheet Tutorials and Galapágos Finches
5 Resources
By: BioInteractive
HHMI BioInteractive
  • Facebook
  • Instagram
  • Twitter
  • YouTube
  • Newsletter Signup
  • HHMI.org
  • Terms of Use
  • Privacy Policy
  • Accessibility