USA: +1(669)289-8683 
Sign in
SCI L233: Physical Science Excel Graphing Lab I
Microsoft Excel in Scientific Applications
Introduction
Computers and computer-based instrumentation are used in science courses. The analysis and reporting of experimental data is an important aspect of working in a scientific laboratory. In order to display and graph collected data, scientists often rely on computer applications called spreadsheets. To be prepared to work in any college or professional laboratory, you must be familiar with spreadsheets and other computer-based methods of data collection and analysis.
Learner Outcomes
Upon completion of this laboratory activity, the student should be able to
· demonstrate basic computer survival skills
· opening, closing and saving files
· formatting text and/or cells
· enter formulas and perform calculations using Microsoft Excel
· perform statistical analyses of data using Microsoft Excel
· prepare and display different types of graphs of data
Assignment
This is not a typical physical science lab with reactions to investigate and discuss. Therefore, the format for this lab will be different than for the others. Instead of having the typical components of title, experimental design, results, and so on, you will follow the format described below and email the file to your instructor using the Course Message tool on Blackboard.
REMINDER: Save your data early and often in order to avoid the accidental loss of your work. Use the following convention for naming your files: “lastname_lab#”. The last number represents the lab number for the Term. This lab may be done totally paperless, so follow directions carefully.
The spreadsheet you will be creating will be submitted electronically via Course Messages Tool on Blackboard.
1. Enter the data in Columns A and B from
Figure 1
onto Sheet 1 of an Excel spreadsheet. Then perform the following operations on each row of data.
· In Column C, use a formula to add the value in Column A to the value in Column B.
· In Column D, use a formula to subtract the value in Column B from the value in Column A.
· In Column E, use a formula to multiply the value in Column A by 5 and divide the product by the value in Column B. Adjust the decimal place so that each answer in Column E has two places after the decimal.
· Label each of the columns: Addition, Subtraction, Multiplication/Division (5 points)
Figure 1
*Make sure you perform the calculations in the Excel worksheet.
2. Plot a X-Y scatter graph using the data given in the table below. Make sure you have an appropriate title, label the X and Y Axis WITH UNITS. (10 points)
Time (s)
Distance (m)
0
0
2
20
4
80
6
180
8
320
10
500
Highlight the numbers only by putting the cursor on the first cell containing information and hold down the left mouse button and dragging over all the cells with numbers in them. They should be highlighted blue. Click on the Chart Wizard on the top toolbar. Select the XY(scatter).
3. Use the following data to calculate the percentage of each type of tree in the Wisconsin Hardwood Trees. To do this, divide the number of each type of tree by the total number of trees and multiply by 100. (20 points)
Type of tree
Number found
Oak
600
Maple
750
Beech
300
Birch
1200
Hickory
150
Total
3000
Example: x 100 = 20% oak x 100 = 25% maple
4. Plot a pie graph using the calculated percentages. You should have two columns of information: one with the type of tree and one with the percentages. Make sure you have an appropriate title explaining what the pie graph represents. (10 points)
5. Plot a bar graph using the data in the table below. Make sure you have an appropriate title, label the X and Y Axis WITH UNITS. (10 points)
Material
Density (g/cm3)
Wood
0.705
Water
1
Sugar
1.560
Glass
2.8
Iron
7.9
lead
11.3
Mercury
13.5
Please submit your assignment via Course Messages on Blackboard to Ms. Hudson. This assignment is due
August 17, 2013 by 11:59 pm.
Sheet1
X Y
850 27
428 77
126 82
323 64
988 88
358 62
XY
85027
42877
12682
32364
98888
35862
Sheet1
X Y
850 27
428 77
126 82
323 64
988 88
358 62
