| Excel in Science - October 2000
When computers first arrived at Scarborough High School for classroom
use, students used word processing, web browsers, and e-mail. Very
few students knew what Microsoft Excel was.
A chemistry teacher approached me because she felt her students were
spending an enormous amount of time plotting and evaluating data collected
during classroom experiments. She was looking for a way to simplify
the process.
We decided on Excel. The approach would be:
1) Class demonstration of the main features of Excel utilizing the
computer and projector.
2) A tutorial that would walk the students through the process on entering
data and producing the desired graphs (charts). The data in the tutorial
was to be similar to that data they would collect but not exact.
3) The students would then collect the experimental data and apply
what they learned in part 1 and 2 to produce graphs in Excel for their
lab reports.
Click here to view the original
tutorial. |