Data Collection and Analysis Resources > DI Resources > MSM Resources > MSMP

ARTICLES

Scaffolding Math Learning with Spreadsheets by Margaret L Niess, Learning and Leading with Technology Magazine, Volume 32, Number 5. Students learn mathematics and how to spreadsheets simultaneously through teacher-designed problem solving activities.

Real-world Ratios: Modeling and Scaling Using A Spreadsheet - by William J. Sumrall, Learning and Leading with Technology Magazine, Volume 31, Number 3.A computer spreadsheet offers tools with which a model builder can determine appropriate dimensions based on materials and other factors. Using technologies that enable students to make multiple redundant calculations of data and to computer large quantities of data with relative ease.

Spreadsheet Magic by Pamela Lewis with a discussion of visual learning, higher order thinking skills, spreadsheets and mathematics, spreadsheet skills mastered by students K–8, Internet resources, and spreadsheet magic
http://www.digital-lessons.com/SpreadsheetMagic.html

Use Spreadsheet to Teach Mathematics and Meet Standards, with sample math spreadsheets. NECC 2001 presentstion by Pam Lewis. Spreadsheet assignments offer concrete ways to explore abstract concepts in mathematics and other subjects.
http://www.angelfire.com/wi2/spreadsheet/necc.html

Beyond Show and Tell: Using Spreadsheets to Solve Problems - by Mary Burns, Learning and Leading with Technology, Volume 31, Number 2. The spreadsheet’s power to both generate and display data in a visual format enriches the study of another subject are in a way most likely would not be possible without the tool.

____________________________________________________________________________________________________________

TOOLS & RESOUCES

Blooms Taxonomy and Spreadsheets - Teachers in K-12 classrooms use spreadsheet software to help students think about concepts behind numbers. Look at the chart below to see how students can use spreadsheets in the various levels of thinking.
http://edtech.boisestate.edu/bridges/cds/Wildlife/wildblooms.htm

Spreadsheet Problems for Teachers - Created by Dr. Maggie Niess, specialist in pedagogical uses of spreadsheets/spreadsheets as scaffolding tools. These spreadsheet problems were created as part of the EUSES research studies about teaching students to use spreadsheets. They have proven very useful and helpful to students so they are posted here for free use among teachers. Primarily these problems are of the level of middle to high school students and feature math concepts taught through the use of spreadsheets. The files used are available, you will need Microsoft Word and Excel.

Exploring Data - curriculum support materials for teachers of introductory statistics. From Boxplots and datasets to linear regression and probability, find everything you could possibly need. Many topics contain worksheets and downloadable files.

Swivel
Explore, edit, and compare existing public datasets, charts and graphs or upload your own at this social networking site that brings data to the masses for sharing and interpretation. Imagine the possibilities for your students! The front page always features an interesting selection of datasets related to current events and world topics of the day.

LT technologies, Link technology with teaching in order to maximize student achievement in the classroom. This website has .spreadsheet resources with lesson plans and other strategies for its use. - http://www.lttechno.com/links/spreadsheets.html

Create a Graph - An easy to use data entry and analysis tool for students and teachers. There has been a complete site redesign featuring tabbed interface with active help, examples, and templates.

Noodle Tools - Mathematical Literacy; Finding and Using Data. A website with advice on finding data and links to various data sources.

Zoho Sheet- Free online web based alternative to traditinal spreadsheet applications. You can create, edit, and share online.

Google Spreadsheets - Free resource. Create, edit and share basic spreadsheets online. Includes formatting abilities, sorting by column and formulas. Requires setting up a free Google account.

Integrating Spreadsheets in the Math Classroom - From the "Future of Math" web site.

Raw Data for the Mind - from David Warlick's site. A collection of links to data sites with recommendations for how they might be used in the classroom.

"What If?" Scenarios - Scenarios are a great way to explore different values in a spreadsheet and to test out "what-if" possibilities. Learn how to create them with this tutorial from Microsoft Education.