Overview

You will be using Microsoft Excel to execute calculations for various assignments, and we have provided a complete list of tutorials below, for you to access and refer back to at any time throughout the semester. Take notes and complete the Excel worksheet(s) to help you work through your lab assignments.

Important: Install the desktop version of Microsoft Excel on your computer to complete your assignments. The online version of Excel looks and functions differently.

Tutorial Workbooks:

• Tutorials 1-16: Scientific Thinking Excel Tutorial Workbook
• Tutorial 17: Experimental Design Excel Tutorial Workbook (integral to Dreamscape Learn Genetics and Evolution, Act I: Paradise Lost)
• Tutorial 18: Exponential Growth Excel Tutorial Workbook (integral to Dreamscape Learn Population Biology, Act I: Dwindling Numbers)
• Tutorial 19: How to Estimate the Parameters of a Quadratic Polynomial Function Workbook (integral to Dreamscape Learn Population Biology, Act II: An Unexpected Guest)

Note: You must be logged in with your ASU email address to view and/or download the documents; you will NOT otherwise have access when using any outside accounts.

1. Getting Started

Download the transcript for "Getting Started."

2. Finding Stuff and Getting Around

Download the transcript for "Excel Interface: Finding Stuff and Getting Around."

3. Data: Entering and Formatting

Download the transcript for "Data: Entering and Formatting."

4. Data: Basic Calculations

Download the transcript for "Data: Basic Calculations."

5. Data: Sorting 

Download the transcript for "Data: Sorting."

6. Functions: Describing Data

Download the transcript for "Functions: Describing Data."

7. Functions: The Count Family and Absolute Cell References

Download the transcript for "Functions: The Count Family and Absolute Cell References."

8. Calculating Frequencies

Download the transcript for "Calculating Frequencies."

9. Saving Plots as Images

Download the transcript for "Saving Plots as Images."

10. Estimating Parameters of a Normal Probability Distribution

Download the transcript for "Estimating Parameters of a Normal Probability Distribution."

11. Calculating a Probability from a Normal Probability Distribution

Download the transcript for "Calculating a Probability from a Normal Probability Distribution."

12. Making a Scatter Plot

Download the transcript for "Making a Scatter Plot."

13. Modeling a Linear Relationship

Download the transcript for "Modeling a Linear Relationship."

14. Predicting the Value of a Variable from a Linear Model

Download the transcript for "Predicting the Value of a Variable from a Linear Model."

15. Modeling a Linear Relationship with a Categorical Independent Variable 

Download the transcript for "Modeling A Linear Relationship with a Categorical Independent Variable."

16. Making a Plot with Error Bars

Download the transcript for "Making a Plot with Error Bars."

17. Using the Random Function to Assign Subjects to Experimental Treatments 

Download the transcript for "Using the Random Function to Assign Subjects to Experimental Treatments."

18. Modeling the Exponential Growth of a Population

Download the transcript for "Modeling the Exponential Growth of a Population."

19. How to Estimate the Parameters of a Quadratic Polynomial Function

Download the transcript for "How to Estimate the Parameters of a Quadratic Polynomial Function."