Saturday, June 02, 2007

Analyzing data with spreadsheets

Over the years, spreadsheets have been one of the biggest times avers I have found. A few minutes spent thinking through what I want a spreadsheet to do and setting it up to do so saves hours of repetitive calculations.

If you are in the school business and want to learn how to use Excel to analyze your data, I have a recommendation for a great place to start. School Data Tutorials provides detailed instructions on setting up spreadsheets and writing formulas. The site uses Camtasia Studio to produce the tutorials, meaning you hear the instructor talking to you, view the instructor's screen, and see every move of the instructor's mouse. It's as if the instructor were sitting beside you. Best of all, the examples are germane to analyzing data in an educational setting.

P.S. Thanks to Jan Borelli for putting me onto this site. Jan is principal of Westwood Elementary (the Hippest School in America), located in Oklahoma City, Oklahoma. You can read some of her thoughts at Dr. Jan's Blog.

1 comment:

Unknown said...

Frank,

I would like to interview you for a podcast. Please email me, so we can begin a dialogue.

Jan

janborelli@gmail.com