Working with Authentic Data

These examples are provided as resources for professional development sessions provided by authorized eMINTS instructors and staff and may not be copied or redistributed without the express written consent of the eMINTS National Center. To request permission, contact emints-info@emints.org.

Session Resources

Excel Project

eMINTS National Center. (2005). Color and Consumer Choice.
http://resources.emints.org/modresources/activities/excel/colorchoice

Downloading Internet Data into Excel

Warlick, D. (1997). Raw Data. Landmarks for Schools.
http://landmark-project.com/page.php?stamp=1155138431&pn=4&psn=&cat=22

Application of Excel with Students

Inquiring Minds
http://resources.emints.org/modresources/activities/excel/inquiringminds

General Resources

Classroom Activities

Adkins, K. (June 2000). To Excel in the Classroom is Elementary. Forsyth County
Schools.
http://www.forsythcountyschools.org/its/kadkins/spreadsheet.htm

Alejandre , S. (1994). Math Forum Web Units. Math Forum. Drexel University.
http://mathforum.org/alejandre/spreadsheet.html

Garton , J. L. (October, 2002). Using MS Excel in the Classroom. Fusion. Willard R2 School District.
http://edteching.com/graham/summer_2003/Moen/Fusion%20Using%20MS%20Excel%20in%20the%20Classroom.htm

Hale, P. Spreadsheet Activities. East Ramapo Instructional Technology. East Ramapo CSD. Spring Valley, NY.
http://www2.lhric.org/eastramapo/techweb/integration/spreadsheet_activities.htm
Links to activities for all grade levels.

Lewis, Pamela. (2001). Spreadsheet Magic—40 Lessons Using Spreadsheets to Teach Curriculum in K-8 Classroom. ISTE.

LT Technologies. (2005). Spreadsheet Resources.
http://www.lttechno.com/links/spreadsheets.html
Spreadsheet resources for all grade levels.

The Natural History Museum. (2005). Downloadable Dinosaur Data for Spreadsheets. London, UK.
http://internt.nhm.ac.uk/jdsml/nature-online/dino-directory/about-teachers.dsml

Reese, G. The Cereal Box Problem: A Lesson in Expected Value. The Office for Mathematics, Science, and Technology Education. University of Illinois at Urbana-Champaign.
http://www.mste.uiuc.edu/reese/cereal/intro.html

Seastone, S. (1997). Exploring Data. Urban Systemic Initiative. Math Forum. Drexel University.
http://mathforum.org/workshops/usi/dataproject/
The data opens automatically into an Excel spreadsheet, but Winzip is required to extract the file.

White, K. (1995). Ken White's Coin Flipping Page. SHAZAM.
http://shazam.econ.ubc.ca/flip/

Record-Keeping

Microsoft Office Online. Microsoft Templates.
http://office.microsoft.com/en-us/templates/CT101527321033.aspx

Reviewed September 8, 2008.