Week #2

 

This weeks lab has the following objectives.

  1. Discuss last weeks readings related to the scientific method.

  2. Introduce you to basic functions in Microsoft Excel.

  3. Introduce reading material for next week's lab session.

  4. Install Analysis Tool-Pak on your computer.

  5. Discuss case study on experimental techniques and the treatment of data.

The following assignment(s) is(are) associated with this week's lab.  The assignment(s) is(are) due at the start of next week's lab.

  1. Homework #1 for 1/19.

Read and/or review the material found at each of the following links:

General Excel Help (Review this material as required based upon your knowledge of Excel)

Introduction #1 - General Introduction: http://help.unc.edu/?id=2058

Introduction #2 - Formatting & Editing:  http://help.unc.edu/?id=2146

Introduction #3 - Formulas & Functions:  http://help.unc.edu/?id=2281

Elementary instructions from www.statsteacher.com

Analysis ToolPak Installation

 

Making Excel Graphs

Required

Great graph creation instructions from www.statsteacher.com

Supplemental

Georgetown Psychology tutorial on graphing:  http://www.georgetown.edu/departments/psychology/researchmethods/computer/excel2.htm

General graphing information: http://help.unc.edu/?id=2197

Occidental University tutorial: http://www.oxy.edu/departments/its/training/excel/excel_charts.html

Writing a Research Question

Required: http://www.esc.edu/esconline/across_esc/writerscomplex.nsf/3cc42a422514347a8525671d0049f395/f87fd7182f0ff21c852569c2005a47b7?OpenDocument

 

Required: Parts of a Research Manuscript: http://www.wisc.edu/writing/Handbook/ScienceReport.html

What is Science? (http://books.nap.edu/html/obas/)

Experimental Techniques and the Treatment of Data

Required - http://books.nap.edu/html/obas/contents/experimental.html

& the Appendix section associated with this reading!