Student Resources

Tutorial Videos

Working in Microsoft Word

These videos show you how to program AutoCorrect to replace long words, format sub- and superscripted expressions, and italicize scientific names automatically.

• Tutorial 1: AutoCorrect Mac Version
• Tutorial 1: AutoCorrect Windows Version

These videos show you how to make professional-looking equations with Equation Editor.

• Tutorial 2: Equation Editor Mac Version
• Tutorial 2: Equation Editor Windows Version

These videos show you how the Comments and Track Changes features are used to provide feedback in an electronic document.

• Tutorial 3: Comments and Track Changes Mac Version
• Tutorial 3: Comments and Track Changes Windows Version

These videos show you how to format documents at the word and symbol level.

• Tutorial 4: Formatting Words and Symbols Mac Version
• Tutorial 4: Formatting Words and Symbols Windows Version

These videos show you how to format documents at the paragraph level.

• Tutorial 5: Formatting Paragraphs Mac Version
• Tutorial 5: Formatting Paragraphs Windows Version

These videos show you how to format documents at the page level.

• Tutorial 6: Formatting Pages Mac Version
• Tutorial 6: Formatting Pages Windows Version

Working in Microsoft Excel

These videos are an introduction to basic formulas and functions: mathematical operators, relative cell references, the SUM function, the AVERAGE function, and copying formulas using the fill handle.

• Tutorial 7: Applying Formulas to Data, Part 1 Mac Version
• Tutorial 7: Applying Formulas to Data, Part 1 Windows Version

These videos are an introduction to basic formulas and functions: absolute vs. relative cell references, the order of operations, pasting values without the associated formula, rounding.

• Tutorial 8: Applying Formulas to Data, Part 2 Mac Version
• Tutorial 8: Applying Formulas to Data, Part 2 Windows Version

These videos show you how to make and format an XY graph with a linear trendline.

• Tutorial 9: Formatting XY Graphs Mac Version
• Tutorial 9: Formatting XY Graphs Windows Version

These videos show you how to save the custom format of a graph and apply it to a new data set.

• Tutorial 10: Saving Graphs as Chart Templates Mac Version
• Tutorial 10: Saving Graphs as Chart Templates Windows Version

Lab Reports

A template for a lab report that includes prompts and formatting to help you become familiar with scientific paper format and content.

• Biology Lab Report Template (DOC)

A checklist that can be used in both preparing and reviewing lab reports.

• Scientific Writing Checklist (DOC)

Common mistakes made in both content and format of lab reports.

• Proofreading Marks and Lab Report Errors (DOC)

Oral Presentations

A form to use for evaluation of oral presentations

• Evaluation Form for Oral Presentations (DOC)

Chapter 2 - Check Your Understanding

Resources to accompany the Check Your Understanding activity from Chapter 2.

• Chapter 2 - Check Your Understanding: "Should I get a flu shot?" (DOC)

Chapter 6 - Replication Code

Replication code for Chapter 6: Data Analysis Using Statistics.

• Chapter 6 - Replication Code

Poster Presentations

A form to use for evaluation of poster presentations

• Evaluation Form for Poster Presentations (DOC)

Sample posters and evaluations

• Sample Poster 1 (PDF)
• Sample Poster 1 Evaluation (DOC)
• Sample Poster 2 (PDF)
• Sample Poster 2 Evaluation (DOC)
• Sample Poster 3 (PDF)
• Sample Poster 3 Evaluation (DOC)
• Sample Poster 4 (PDF)
• Sample Poster 4 Evaluation (DOC)
• Sample Poster 5 (PDF)
• Sample Poster 5 Evaluation (DOC)
• Sample Poster 6 (PDF)
• Sample Poster 6 Evaluation (DOC)
• Sample Poster 7 (PDF)
• Sample Poster 7 Evaluation (DOC)
• Sample Poster 8 (PDF)
• Sample Poster 8 Evaluation (DOC)
• Sample Poster 9 (PDF)
• Sample Poster 9 Evaluation (DOC)
• Sample Poster 10 (PDF)
• Sample Poster 10 Evaluation (DOC)
• Sample Poster 11 (PDF)
• Sample Poster 11 Evaluation (DOC)