Electronic Spreadsheet & Word Processing
1
Electronic Spreadsheet & Word Processing
Following are the items you are expected to know how to do when using Electronic Spreadsheet and Word Processing.
Electronic Spreadsheet
: Microsoft Excel
•
input text
•
input numbers
•
input numbers with formula
•
align data and text
•
express values with correct significant figures
•
save data
•
exit
•
retrieve information from diskette
•
simple graphing of data
•
perform linear regression analysis with R
2
•
use primary and secondary axes for graphing
•
preview and print
•
edit
Word Processing
: Microsoft Word
•
Write chemical formula.
•
Enter an equation using Word and Equation Editor.
•
Import all or part of
Excel
data and individual plots to a Word document.
If you are totally unfamiliar with any of these basic operations, you should continue with the following tutorial.
If you
have used spreadsheet and word processing before, you may still want to glance over the following pages so that you are
aware of what is expected of you, as far as these two tools are concern, for this course.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentElectronic Spreadsheet & Word Processing
2
Electronic Spreadsheet & Word Processing
INTRODUCTION
The goals of this experiment are two fold: learn to use an electronic spreadsheet (ES) to organize, analyze, and display
experimental and/or calculated data and learn to use a word processor (WP) for writing chemical laboratory report.
Electronic Spreadsheet
.
ES was originally designed for business majors.
However, the concept of "checks and balances" is used in chemistry, too.
For example, the basis of stoichiometric calculation is that the total mass and charge of reactants and products in a chemical
reaction are conserved; when writing the electronic configuration for a certain element or ion, the sum of all the electrons
placed in various orbitals must be equal to the total number of electrons for that element or ion, etc.
.
Therefore, it is not
surprising that ES can also be used on chemical problems.
Chemical experiments usually involve collecting a set of data points.
These data are often processed through calculations
and/or graphical display.
The latter is very important.
There are two reasons why data are plotted.
(1) It is easier to spot if
any trend exists from a graph than from a set of numbers.
(2) When data points show some discernible pattern, the points
can generally be fitted with an equation.
The equation, in turn, allows one to estimate, by interpolation, extrapolation or
some other means, the behavior of the system under conditions NOT studied in the experiment.
Linear relationship of experimental data can be expressed in the form of
y
mx
b
=
+
.
For example, when the pressure
(P) of a gas is plotted against its volume (V), the result is a curve.
If the same P values are plotted against 1/V, it yields a
straight line.
This means that pressure is proportional to the reciprocal of the volume (P
∝
1/V) or pressure times volume is
equal to a constant (PV = k).
Of course, different systems behave differently.
This is the end of the preview.
Sign up
to
access the rest of the document.
 Winter '06
 Dai
 Electron, Dialog box, Double click

Click to edit the document details