Titles Subjects
  New Titles   New Versions   Complete Listing

Best Seller!
ORDER NOW

Windows
Excel 5.0 and 7.0
ISBN 1-56396-640-9
Excel 97
ISBN 1-928550-08-8

Mac
Excel 5.0
ISBN 1-56396-156-3
Excel 98
ISBN 1-56396-156-3
Single copy $100.00
High School Site License $250.00
10-copy lab pack $400.00
RELATED TITLES

Excel Spreadsheet Tutorial with Workshop Physics Tools

John E. Gastineau
Margaret H. Gjertsen
John S. Risley
Paula V. Engelhardt
Scott F. Schultz
- North Carolina State University

Grant Braught
Priscilla W. Laws
- Dickinson College

Patrick J. Cooney
- Millersville University

The Excel Spreadsheet Tutorial consists of two elements which can be used together or independently of one another: The Excel Spreadsheet Tutorial and Workshop Physics Tools. The tutorial is a self-paced introduction to Excel designed for physics students. Skills from basic spreadsheet use to graphing and least-squares fitting are covered. Workshop Physics Tools is a set of macros that extend Excel to perform common graphing, curve fitting, and formula translation tasks.

Once students work through the eight-lesson self-study tutorial, taking a total of four hours, they are prepared to work most textbook spreadsheet problems and to perform laboratory data analysis and graphing on their own. The tutorial is directed at all the major skills students need for spreadsheet use in physics and addresses the common difficulties they face. Tasks within each lesson test the readiness to move forward. Each lesson concludes with a few exercises for the student to attempt on their own. Reference screens and formulas ensure that your students will remain on track.

The Workshop Physics Tools extend the functionality of Excel 4.0, 5.0, and 7.0 to facilitate ways that are commonly used in a laboratory-based science curriculum. The tools simplify tasks such as:

  • Creating XY Scatter Plots with title, axis, and series labels
  • Manipulation and analysis of XY Scatter Plots
  • Overlaying multiple XY Scatter Plots
  • Translating Excel spreadsheet formulas into pneumonic representations
  • Fitting polynomial functions to experimental data

The tools which provide this extended functionality are accessed with two custom toolbars: WP Standard and WP Active Chart, and the current Wptools menu which is added to Excel's menu bar.

System Requirements:
Your computer system and hardware configuration should be either an Apple Macintosh computer or a PC- compatible with the following features:

  • System 7.0 or higher (Macintosh)
  • 8 MB Ram allocated to Excel is recommended (Macintosh)
  • DOS 3.1 or higher with Windows 3.1 or higher (PC)
  • Microsoft's Excel 5.0 or 7.0 spreadsheet program
  • Mouse
  • Printer
  • Formatted diskette


Windows   for Excel 5.0 and 7.0
ISBN 1-56396-640-9
Windows   for Excel 97
ISBN 1-928550-08-8
Mac   for Excel 5.0
ISBN 1-56396-156-3
Mac   for Excel 98
ISBN 1-56396-156-3

Single copy $100.00
High School Site License $250.00
10-copy lab pack $400.00

Student Copy - Minimum of 10 copies of the program; Must be purchased in conjunction with a single copy of the developer's version. Additional copies $15.00 each.		 $150.00

© 1996 by Physics Academic Software Publishing Organization. All rights reserved.

 Part of the UTILITIES SERIES
 
REVIEWS
 
"Contains an elementary introduction to Excel using physics examples instead of accounting ones...This Software would be a very useful addition to anyone who uses Excel"
C.L. Waters
Australian & New Zealand Physicist, March/ April 1997
RELATED SUBJECTS