Semester: Fall, 2008
Professor: Carl Salter
Collier 228
Phone:
625-7920
email:
csalter at chem .moravian .edu
Catalog
Description: An
introduction
to the use of the computer in chemical experimentation and research,
including the production of research-quality manuscripts that include
scientific tables, figures, and chemical drawings. The
use statistical programs and experimental design will be covered.
Real-time data acquisition hardware and software
will be used by the students to gather data for analysis in
spreadsheets.
Students will be introduced to on-line searches of the chemical
literature
using Chemical Abstracts and the Science Citation Index. Fall. One 100
minute period each week. One-half unit credit.
Four lab reports 40%
Writing journal 25%
Reaction paper to Asimov essay 10%
Asimov's World of Nitrogen assignment 10%
"Forensics" letter 5%
Two “Dear Aunt Gladys” letters 10%
Tentative Schedule:
Week 1 Aug 25
Overview of laptops and computer
programs.
Introduction to MSWord and
ChemDraw. Introduction
to Excel. Moving charts and structures to documents.
Receive writing assignments from Asimov's World of Nitrogen and The Relativity of Wrong.
World of Nitrogen and World of Carbon are available in
the library.
Meter stick and mass experiments, add these graphs
and LINEST output to the Clipboard assignment.
Week 2 Sept 1 (Wednesday
only) multimeter experiment.
Week 3 Sept 8
Descriptive
Statistics using Excel. More about LINEST and Least
Squares. Experiment "Density of Pennies"
Lab report: Analyze
density of sugar solutions using Excel. Data from CRC
Handbook.
(lab
report using template
LR2)
Statistics: "Errors in
Measurements and their effect on Data Sets" in class
Turn in Clipboard
Assignment
Week 4 Sept 15
Introduction to spectroscopy:
Beer's Law.
Lab experiment: Copper sulfate
experiment
using Ocean Optics spectrometers.
Directions
for Copper sulfate experiment.
(lab report
using template
LR3)
Week 5 Sept 22
Complete Copper sulfate experiment and analyze unknowns.
1st
draft of "Relativity of
Wrong" and chapter requests for World of Nitrogen due Friday Sept 26
Week 6 Sept 29
Lab report: pH
titration experiment. (Your
own lab report format!)
titration instructions
(titration spreadsheet)
When you write the
report, follow the lab report format on my web site.
Be sure that there is one graph that contains all three titration curves!
"Forensics" test on
unknown
salt. (Write letter to defense
lawyers explaining results.)
Receive
Aunt Gladys assignments.
Week 7 Oct 6
Peer review of Relativity of Wrong draft
Statistics: The t test. The
F test. Introduction
to EXCEL Statistical functions.
Lab
experiment: M&M experiment
Directions
for M&M
experiment.
(lab
report
using template LR1)
Week 8 Oct 13
Introduction to Chemical
Abstracts using SciFinder Scholar.
Week 9 Oct 20
Experiment: Heat of fusion
of Ice: Excel spreadsheet analysis of data. Nonlinear fits
using Solver. (Turn in spreadsheet.)
Turn in both Asimov Assignments
Friday Oct 24
Week 10 Oct 27
Turn in first
drafts
of Freezing point and copper
sulfate LRs.
Submit
writing
journal for review. Friday Oct 31.
Week 11 Nov 3
Lab report workshop.
Peer review of Copper
Sulfate, and M&M lab reports. Revise as needed.
Week 12 Nov 10
Spectroscopy and kinetics experiment. Bleaching of dyes.
Fe(III) and thiosulfate. (Turn in spreadsheet.)
Week 13 Nov 24
(Monday only) multimeter experiment.
Week 14 Dec 1
Read out loud and turn in Aunt Gladys
letters.
Submit all Lab reports. Submit writing journal for
final grade.
Lab Reports: You will write
four
lab reports based on the lab experiments you do during the
course. An extensive
list of online advice about lab report
format, style, and content is available on my web site. For three
experiments you will
be provided with lab report “template” files that will help guide you
through
the process of inserting the right information and ideas into your
report.
For the titration experiment you will not receive a template file; you
must use the lab report format on my web site.
All three titration curves should appear in the same graph for easy
comparison. Include sample calculations of your data.
Clearly explain why you made your choices for the identities of X and Y.
You will not write a lab report for the
kinetics experiment; however, this
experiment must appear in
your
writing journal, and you must use the laboratory notebook style
suggested by Beall
&
Trimbur.
The Writing
Journal: A bound
notebook
of the type used for laboratories can be used to submit your writing
assignments
from the Beall & Trimbur textbook, A Short Guide to Reading and
Writing about Chemistry. The assignments from the
textbook
should be completed in the notebook--you may write them by hand, but I
must
be able to read them!
Divide your bound notebook in two main parts. Use the first
two-thirds for your writing journal; use the last third as a lab
notebook. Your notebook should contain information on all the formal experiments that we
do in lab: Copper sulfate, pH titration, heat of fusion of ice,
M&Ms, and the kinetics experiment. Your notebook should
include spreadsheet analysis of the data pasted into the book.
Here are the Assignments from the Short
Guide to Writing:
Chapter 2: Scientific Responsibility Page
32, writing
assignment 1
Chapter 7: Writing Research Proposals
Summarize a research proposal written by a member of Moravian's
chemistry or biology departments.
Spreadsheet Requirements For Data from
Experiments: Related lab work or assignments should be in
a single
excel file (a "book", as EXCEL calls it), each separate problem
should be on its own sheet, and each sheet should be named using the
chapter
and problem number; for example, "5-13" indicates problem 13 from
chapter
5. If a problem has several parts, all parts should be on one
sheet
proceeding DOWN the sheet (not across); keep similar quantities in the
same COLUMNS.
Data from each experiment should be in one file, and each
separate trial should be on a separate, labeled sheet. For example, all
titrations from one experiment should be in one book, and data from
each
individual titration should be on a separate sheet. Spreadsheets
for every experiment MUST have a summary sheet containing the
date
the experiment was performed and the identity of your lab partner(s).
The
summary must have concise tables presenting the key data from all the
experimental
trials, and the summary should have a brief written discussion of the
meaning
and importance of the data. The summary page should not contain
numbers
that are not mentioned in the discussion.