Dr. Alice Christie's Using Spreadsheets in K-12 Classrooms

You are here:

Dr. Christie's Using Spreadsheets in K-12 Classrooms
Existing Data \| Interactive Data \| Teacher Samples \| Lesson Plans Downloadable Files \| Glossaries \| Online Resources Articles \| Arizona Standards
Click on each thumbnail to see the larger picture.
Existing Data to Download or Import into Excel Math Forum's Exploring Data Math Forum's Data Sets US Census Bureau's Data Sets Carnegie Mellon University Data Sets Pew Internet & American Life Data Sets NYU: USA stocks, bonds and bills from 1928 - 2011 Statistical Science Stats Kathy Adkins' Data Library Interactive Data Data Picking Interactive data collection from BBC that provide students a game to test their knowledge of what is collected and make comparisons. A MUST use site! Excel Shopping Spree WebQuest Students use Excel to track purchases at www.etoys.com, www.toysrus.com, and www.bestbuy.com Climate Data Workbook An interactive charting workbook that lets you compare the climate of two U.S. cities. MathsNet Interactive Spreadsheets Create a Graph What is the average height of your class? Statistics Canada is sponsoring this simple Internet exercise to reinforce lessons on measurement (specifically height), data analysis, measures of central tendency, graphing and self-concept. Basketball Math Interactive An interactive math game that highlights a bar graph as one of the items. Global Grocery List Project An opportunity for students to gather data and submit online to a collaborative project. Math Forum's Collaborative Projects National Library of Virtual Manipulative's for Interactive Mathematics Harcourt Interactive, Grade 3 Collecting & Organizing Data Making Bar Graphs Recording Results of Experiments Harcourt Interactive, Grade 4 Organizing Data Finding the Median and the Mode Exploring Double-Bar Graphs Finding the Mean Predicting Outcomes Harcourt Interactive, Grade 5 Finding the Median and Mode Making Circle Graphs Probability Experiments Harcourt Interactive, Grade 6 Exploring Box-and-Whisker Graphs Exploring Circle Graphs Simulations Spreadsheet Examples by Teachers & Students Kathy Adkins' Excel in the Classroom Site To Excel in the Classroom The ABCs to Excel Excel Classroom Strategies Graphing Ideas Excel-lent Links Teacher Resources Create a Timeline in Microsoft Excel TeachersNet.com Graphing Fun A long list of graphing ideas! Spreadsheet Ideas for Teachers Population Hunt Graphing Our Favorite Foods Graphing Your Favorite Pizza Toppings Franklin Institute Group Graphing Wisconsin Kindergarten's Use of Graphs Data Types and Matching Graphs Excel Template Examples ThinkQuestSchool Spreadsheet Safari At this website you'll learn about the history of spreadsheets, how to use them, and vocabulary. You will find out how spreadsheets can be used in a variety of school subjects and how they can help you organize information and practice skills. There are also some cool quizzes and puzzles. Faubion Middle School's Noon Shadow Observation Project Carol Hurst's Data Gathering and Analyzing Lots of resources linking literature to data gathering and analysis. Online Lesson Utilizing Spreadsheets Creating Pictographs in Excel Lesson Plan Objective - Students will complete a survey in Excel and create a spreadsheet using their data. MiddleSchool.net Lessons Daily Math Graph & Yes/No Questions You Can Make a Graph! Directions for making graphs Spreadsheet Activities Good ideas including Timelines, Interview Forms, Simple Graphing, Civil War & More Simple Graphing, Not So Simple Graphing, Probability Experiment - though difficult to read! Describe the Graph Interpretation of Graphs - Elementary and Middle School Glossaries Teach-Nology: Spreadsheets The A to Z of Spreadsheets A spreadsheet glossary Spreadsheet Guys Glossary Spreadsheet Glossary Flash Cards Online Resources Fibonacci Numbers and Nature Fibonacci numbers can be generated on a spreadsheet. This site looks in detail at where, how and why they occur in the natural world. There are many colorful, clear diagrams, and animations of growing plants. Sabine Parish School District Excel Resources and Ideas LT Technologies Spreadsheet Resources MathsNet: Spreadsheet Animations Graphing and Computers in Grades 3-5 by Fred Ventura, Ph.D. Everyday Spreadsheets in the Classroom Ideas for Using Spreadsheets in the Classroom Articles Middle School Math Lessons \| Using Excel in the classroom Arizona Standards Academic K-12 Standards