Spreadsheet Exercises in Ecology and Evolution by Therese M. Donovan

By Therese M. Donovan

Each one spreadsheet workout offers a listing of goals, history fabric, and annotated step-by-step directions (Windows and Macintosh) for making a version on a given subject. scholars then research how quite a few parameters impact version results and, via a suite of guided questions, are challenged to improve their version extra. within the technique, they develop into educated with a number of the capabilities to be had on such a lot spreadsheet courses and discover ways to write and enhance their very own macros. This identify can be utilized independently because the foundation of a laboratory direction, or can complement quite a few texts. method necessities are Microsoft Excel or different spreadsheet software.

Show description

Read or Download Spreadsheet Exercises in Ecology and Evolution PDF

Best science for kids books

Technology, Science Teaching, and Literacy: A Century of Growth

This publication profiles the academic use of expertise within the technology school room from 1900 to the current day. Drawn from a spread of assets - from instructor bills of lecture room perform, and modern learn money owed of the simplest instructing practices with know-how - it examines styles of implementation with admire to the study room use of know-how.

Materials Science Research Trends

Fabrics technology comprises these components of chemistry and physics that care for the houses of fabrics. It encompasses 4 periods of fabrics, the research of every of that could be thought of a separate box: metals; ceramics; polymers and composites. fabrics technological know-how is usually known as fabrics technological know-how and engineering since it has many functions.

STEM to Story: Enthralling and Effective Lesson Plans for Grades 5-8

Deliver STEM to life for students with zombies, rockets, celebrities, and extra STEM to tale: enchanting and potent Lesson Plans for Grades 5-8 evokes studying via enjoyable, attractive, and significant lesson plans that fuse hands-on discovery in technological know-how, expertise, engineering, and math (STEM) with artistic writing.

Extra resources for Spreadsheet Exercises in Ecology and Evolution

Example text

For all functions, use the Paste Function menu (the Paste Function button, fx, or open Insert | Function) to locate the appropriate function, review the function’s formula palette, and complete the entries. You can double-check your results with ours at the end of the section. 1. Set up new headings as shown in Figure 13. 3 4 5 6 7 8 9 10 11 12 13 14 15 D E Simple functions Count Sum Average Median Mode Min Max Stdev 4th large Rand Randbetween Figure 13 2. In cell E5, use the COUNT spreadsheet function to count the total number of individuals in the sample.

2. Edit your graph to improve readability. Change to an uncolored background. Often, the shaded background and default colors of data markers and lines are difficult to see and print poorly, especially on black-and-white printers. To change to an uncolored (clear) background, double-click inside the graph axes, away from any lines or data markers, and you should see the dialog box shown below. Click on the buttons labeled None for Border and Area, as shown in Figure 7. Figure 7 3. Make all data lines and markers black and give each function an easily distinguished marker or line type.

This lets the program label the graph legend correctly. Click on the Chart Wizard icon or open Insert | Chart. Follow the steps given in Section B1 on linear functions. 12. Edit your graph to improve readability. Your graph should resemble the one in Figure 14. Graphing each function separately reveals the shapes of their graphs. Follow the steps given in Section B2 on linear functions: Remove gridlines and label the graph and its axes. Remove background color and change all lines and data markers to black.

Download PDF sample

Rated 4.92 of 5 – based on 4 votes