David A. Horner  Harold & Eva White Distinguished Professor in the Liberal Arts  Professor of Physics and Chemistry  North Central College, 30 N. Brainard St., Naperville, IL  60540    Office:  201 Kroehler Science Center  Office phone:  (630) 637-5192  FAX:  (630) 637-5180  e-mail: dahorner@noctrl.edu

 

Spring 2012 Office Hours

MWF   9:15 - 11:00 a.m.

other times by appointment

My office hours vary slightly from week to week.  Check the weekly calendar on my office door for precise times.

 

Courses
CHM/PHY 340:  Thermodynamics

CHM 341:  Kinetics, Quantum Theory, and Spectroscopy
PHY 105:  Physics of Music

PHY 141:  Physics I

PHY 142:  Physics II

PHY 143:  Physics III

PHY 151:  Introduction to Special Relativity

PHY 244:  Physics IV

PHY 245:  Physics V: Quantum Physics
PHY 251:  Molecules and Solids

PHY 450:  Advanced Laboratory

SCI 210:  Landmark Discoveries in Natural Science

 

Research
Computational Materials Science

 

Significant Figures Tutorial

 

Excel Tutorials & Examples 

Getting Started with Excel

Graphing with Excel (includes information about trendlines and error bars)

How to do a Linear Regression with Excel (Excel's regression tool gives you the uncertainties on the slope & y-intercept)

Weighted Least Squares example (the proper way to do a linear regression when the uncertainties on the y values are not all the same)

Solver example (Solver is useful for doing nonlinear regressions)

MacroBundle   Robert de Levie's free collection of ready-to-use Excel macros.  Very useful for laboratory data analysis.  A description of each macro as well as instructions for installing Macrobundle in Excel may be found at the beginning of the document. 

Excel file with Macrobundle installed

 

Mathcad Tutorials & Examples (save file to your desktop, then open it with Mathcad)

Mathcad is installed on computers in the Science labs
Mathcad tutorial by S. Young & T. J. Zielinski, revised by D. A. Horner ( includes an introduction to error propagation)

Solving a System of Equations

Error Propagation

 

Other Mathcad tutorials

Mathcad tutorial 1 by R. D. Poshusta

Mathcad tutorial 2 by R. D. Poshusta

Personal
My Background

 

---

The content and opinions expressed on this page belong to David Horner and are not endorsed by North Central College.
North Central College accepts no responsibility for the contents of these pages.