This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: 1 Using Microsoft Excel This document provides the instructions needed to use Microsoft Excel to complete assignments in both BioSci 0050 and 0060. In both courses, students will be required to construct tables and graphs for lab reports. These tables and graphs must be computer generated. Excel is the most efficient way of doing this. Because use of Excel is required throughout a college education, it is in the best interest of students to keep this document for future reference. If, after reading the instructions provided in this document, students are having trouble with Excel , they are encouraged to see their instructor for help. Table of Contents How to construct a Table ……………………………………………………..…… 2 Making column headings………………………………………………..…...2 Entering data into a table…………………………………………………..…3 Adding a title to a table……………………………………………………....4 Adding borders and lines to a table…………………………………………..5 Inserting a table into a Word document……………………………………5 How to construct a Graph ……………………………………………………….....6 Entering raw data………………………………………………………….....6 Putting raw data into graph form………………………………………….....6 Making a legend in a graph…………………………………………………..6 Adding axes labels and a title to a graph……………………………………..7 Chart placement in your document…………………………………………..7 Adjusting the axis scale…………………………………………………...…7 Adding a subtitle……………………………………………………………..8 Making a Figure description (caption)……………………………………… 8 Adding best fit curves to a graph……………………………………………..8 Making Graphs for the Enzymes II lab ……………………………………………9 Entering raw data……………………………………………………………10 Calculating statistics………………………………………………………...10 Mean………………………………………………………………...10 Standard Deviation………………………………………………….12 Adding a tangent line………………………………………………………..13 Calculating reaction rate and adding it to the graph………………………...13 Adding standard deviation bars (error bars) to your graph………………….14 Additional graphing instructions for the Enzymes II lab ……………………….15 2 By using Excel to store your data, you will be able to manipulate it in many ways....
View
Full
Document
This note was uploaded on 04/07/2008 for the course BIOSCI 0050 taught by Professor Carollafarve during the Fall '07 term at Pittsburgh.
 Fall '07
 CarolLaFarve

Click to edit the document details