Activity Types: Spreadsheet Analysis


Getting "Handy" in the classroom with technology integration!

What is a Spreadsheet Analysis?

A spreadsheet analysis is an analysis conducted using a spreadsheets—electronic  worksheets that solve problems involving numbers by organizing data in a matrix of rows and columns. The intersection of any given row and column is called a cell. Each cell can hold an item which is either text or a value or a formula. Each value can have a predefined relationship to the other values. If you change one value, therefore, you may need to change other values as well—the spreadsheet calculates these values. Think of it as a super-calculator! Spreadsheets can also produce graphs or charts that display these relationships.

North Canton School Excel Activities

HCISD Spreadsheet Activities for Students

Surveys are excellent ways to utilize spreadsheets to collect and then analyze data (example below):

Lynn Public Schools

Education World

Copyright 2002-2011 Handy4Class Project

Candace Figg, PhD
Brock University
Faculty of Education, Teacher Education Department
500 Glenridge, St. Catharines, Ontario, Canada L2S 3A1
(905.688.5550, x5347)

Jenny Burson, EdD
University of Texas at Austin (retired)
Education Department, Curriculum and Instruction