**DESCRIPTION **

Computers in Science (CHEM 325) is
designed to introduce students to the use of computers as tools for data
analysis, problem solving and data presentation. This is a hands-on course. In most classes the student will be seated at
a computer either following the direction of the instructor or working on a
problem with help available from the instructor as needed. Students who successfully complete the course
will be able to use a computer to do unassisted and productive data analysis,
data presentation and problem solving.

**Text**

The course manual is required and is
available in the bookstore.

**Prerequisites**

There are no course prerequisites but
students should be familiar with how to use Windows and with basic file
manipulations.

**CLASS HOURS**

** **

** **MWF 9:10-10:00

**OFFICE HOURS**

MWF 10:10-11:00, MW 3:10-4:00, T 4:10-5:00, F 1:10 – 2:00 or by appointment

Office
: Byrd Center 315
304-876-5430 ddilella@shepherd.edu

web
page:
http://WEBPAGES.SHEPHERD.EDU/DDILELLA/

**ATTENDANCE POLICY**

Students
are expected to attend all classes.
Makeup assignments will not be available without a valid written excuse.

**ACADEMIC
HONESTY**

Cheating in all its forms, including
plagiarism and cheating on visual work, is considered an academic matter and
will result in automatic dismissal from the course and will be recorded on the
official transcript.

**Computer Lab**

The class will generally meet in the
computer lab (White 204 or 209). In most
classes, the student is at a computer either being guided through the use of
software or working on an assignment with the instructor available for
help. If a class is to meet elsewhere
(for a lecture, demo, etc.) the special location will be announced in the
previous class.

**Grading**

The final grade will be based on the
following scale

A 90 %
to 100 %

B 80 %
to 89+ %

C 70 %
to 79+ %

D 60 %
to 69+ %

**ASSIGNMENTS AND TESTS**

There will be 10 to 12 assignments
and several in-class quizzes.

Assignments 65%

In-Class Quizzes 35%

**FINAL – Wednesday
December 7, 2011 9:00 – 11:00 AM**

**Topics Covered**

*Data analysis with spreadsheets*.

Working
with numeric and text data

Creating
and working with formulas in spreadsheets

Copying and
moving data and formulas

Documenting
a spreadsheet

Using
built-in functions

Designing
a spreadsheet to do repetitive calculations

Designing
a spreadsheet that can be reused.

*Calculations with spreadsheets*

* *Entering complicated expressions

Using mathematical and statistical
functions in spreadsheets.

Solving linear and non linear
equations with spreadsheets solver tools.

*Preparing scientific plots with
spreadsheets*.

Types of plots used in science.

Making a good XY chart, converting
data to useful plots, formatting plots

Adding a least squares line and
error bars to a plot.

Calibration curves

Creating a histogram

Making a histogram plot

Creating combination plots

Calculating and adding error bars

*Linear Regression*

Using linear** **regression to fit lines to data.

Making and using calibration curves ** **

Determining uncertainties in
quantities determined from linear regression

Modifying data to produce a linear
plot

Using linear regression to determine
physical quantities from slopes and intercepts

Using weighted least squares
analysis

*Using a spreadsheet for statistical
analysis*

* *Using statistical
functions for data analysis:

standard deviation, confidence limits

correlation, t-tests, F tests, ANOVA

*Programming*

Creating user-defined functions

Creating and using macros

Basic
concepts in computer programming - variables, decision making structures,
looping structures, procedures

*Word-processing for scientific reports*

Generating, organizing and
formatting tables.

Creating complex mathematical and
chemical equations.

Preparing reports that include text,
tables, plots, symbols and equations.

*Presentations*

Preparing effective presentations
for scientific reports

Transferring tables, graphs and
pictures between documents