Everything You Ever Wanted to Know About Spreadsheets…

<     Lesson Plans and Ideas          <

<    North Carolina's Infoweb of Spreadsheet Lessons

http://www.dpi.state.nc.us/Curriculum/Computer.skills/lssnplns/sstoc.html

This site offers several spreadsheet lessons for grades 6-8.

< Math Forum's Introduction to Math and Spreadsheets

http://forum.swarthmore.edu/sum95/math_and/index.html

Upper level applications focusing on using Claris but can be adapted to other software programs.

< PWCS's Teachers' Workroom Resources

http://www.pwcs.edu/i-tech/distanceacad/Distance.htm

Here are ready-made Excel spreadsheets for you to use in your classroom!
Cardiac Capers  -  Self-Checking Sheets   -   Temperature Graphs  -  Daily Weather Observations

< Data Analysis Ideas from the Real World

http://www.math.byu.edu/~lfrancis/readings302/Spreadsheets.html#Ideas

"Several ideas and sources for real world data which could be analyzed and/or graphed using spreadsheets."

< Addition Practice

http://www.essdack.org/tips/multadd.html

"Use If/Then formulas to create an addition practice skills sheet for younger students. The skills sheet will work like a grid: The teacher will enter numbers at random across row 1 and down column A. The student will add a number from row 1 with a number from column 1 and will enter the answer in the corresponding cell. Your formula will show the student if the answer is incorrect." This can be adapted to many other concepts!
This uses Claris…but can be adapted to Excel.

<   Lesson Plans Where You Can Use Spreadsheets

What Percentage of Your class is Right-handed or Left-handed?
http://math.rice.edu/~lanius/Algebra/rightleft.html

Get the Best Deal - Technology Comparisons
http://www.knowledge.state.va.us/cgi-bin/lesview.cgi?idl=290

Charts and Graphs from Spreadsheets
http://www.knowledge.state.va.us/cgi-bin/lesview.cgi?idl=118

Communication through Spreadsheets
http://www.knowledge.state.va.us/cgi-bin/lesview.cgi?idl=39

Pythagorean Theorem on Excel
http://www.knowledge.state.va.us/cgi-bin/lesview.cgi?idl=292

<  Three Lesson Plan Sites

BUT… look for the Excel symbol for specific spreadsheet lessons.

Geography and History Lessons
http://www.microsoft.com/education/lesson/productivity/geo.asp

Math, Economics, and Science Lessons
http://www.microsoft.com/education/lesson/productivity/math.asp

Language Arts and Social Studies Lessons
http://www.microsoft.com/education/lesson/productivity/arts.asp

< The ABC’s to Excel

http://www.mindspring.com/~kadkins/ABC.htm
This site offers almost 26 different ways to use spreadsheets and databases in the elementary classroom. Many ideas can be adapted to upper levels. Just click on the letters to see the ideas!

Below are some of the activities you can find on The ABC's to Excel:

< Life Saver Spreadsheet Project
http://www.pwcs.edu/pattie//projects/ls/ls_procedure.html
This is a science experiment that is fun for all.

< How to Make a Bingo Template

http://www.forsyth.k12.ga.us/kadkins/Excel%20Bingo%20Act2..htm

< The ABC List of Things to Graph
http://www.mindspring.com/~kadkins/graphing_abc.htm
Running out of things to graph…here is the place to look!
J

< Graphing M&M's
http://www.mindspring.com/~kadkins/M&Ms.html
The ever popular graphing M&M's activity.
(This one is also found on The ABC List of Things to Graph.)

< Self-Checking Skill Sheets
http://www.essdack.org/tips/selfcheck.html
This works well for any subject and is a neat concept!
J

< Temperature Stats
http://www.mindspring.com/~kadkins/Excel%20HTML/Tempstat%20Directions.html
Directions on how to use a spreadsheet to chart temperatures.

< Zillions of Other Stuff
http://www.mindspring.com/~kadkins/zillions.htm
Resources and lessons where you can apply databases and spreadsheets (graphs).


Created by Tracy Volz for Manassas City Public Schools     tvolz@manassas.k12.va.us       8/99
Last updated April 05, 2000

Tutorials Links

Terms and Tips Links

Spreadsheet Basics

Everything About Spreadsheets...