Spreadsheet & Word Processing

Spreadsheet & Word Processing - Electronic Spreadsheet...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Electronic 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.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/02/2011 for the course CHEM 100A taught by Professor Dai during the Winter '06 term at UCSD.

Page1 / 32

Spreadsheet & Word Processing - Electronic Spreadsheet...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online