Spreadsheets
EXCEL

Home

What is a spreadsheet?
A spreadsheet can be compared to an accountant's ledger. When you create a new Excel file you create a workbook where you can store your information. A workbook contains one or more worksheets. Worksheets contains rows and columns. Each individual block is called a cell. A neat part about a spreadsheet is it's capability to create graphs.

Spreadsheet Help Document in PDF format

Tutorial Web Sites
Microsoft's In and Out of the Classroom - Windows , version 2000
http://www.microsoft.com/education/?ID=O2kTutorial

Microsoft's In and Out of the Classroom for Mac version 2001
http://www.microsoft.com/education/default.asp?id=macofficetutorial

Microsoft's In and Out of the Classroom for XP
http://www.microsoft.com/education/default.asp?ID=OfficeXPTutorial

NEW  TUTORIALS and TIPS for using  Excel
http://www.internet4classrooms.com/on-line_excel.htm

Basic Tutorial for Using Excel
http://www.usd.edu/trio/tut/excel/

Tutorial for Excel 2000 from Florida Gulf Coast University
http://www.fgcu.edu/support/office2000/excel/

Learning Microsoft Excel - Excel Spreadsheets: An Excel Shortcourse for Teachers
http://www.extension.iastate.edu/Pages/Excel/

 

Lesson Plans and Ways to Integrate Excel into the Classroom
Memory Game using Excel to create a word definition list and then merging into a Word document and printing out cards with word and definitions
http://www.atomiclearning.com/la_memgame

NEW Do Vampires Exist Lesson Plan? Using basic mathematical concepts and spreadsheets skills, students investigate the existence of vampires. The spreadsheet provides a computational tool that facilitates the investigative nature of the activity and allows students to solve a mathematical problem in an open-ended, exploratory manner.
http://www.microsoft.com/education/default.asp?ID=vampire
The ABC List of things to graph - a few things that elementary teachers can use to chart data.
 http://www.forsyth.k12.ga.us/kadkins/graphing_abc.htm

Fast Food Fun
Wonderful example of a lesson plan that incorporates spreadsheets, use of information off Internet, and word processing. Students compares calories and non-fat calories in fast food items.
http://www.wmburgweb.com/Resources/Lesson/index.htm  

Spreadsheets and Social Studies: A Match Made In Heaven
Links to web  sites that contain statistical data that can be used for studying population, social
trends, and economics.
http://www.wmburgweb.com/Resources/spreadsheets.html

Tutorials and lesson plan ideas.
http://www.forsyth.k12.ga.us/kadkins/technolo.htm#Microsoft%20Excel

Spreadsheets and Math Education
http://wwwstaff.murdoch.edu.au/~kissane/spreadsheets.htm

NEW Mathematics, Spreadsheets and Thinking
http://www.ceap.wcu.edu/houghton/EDELCompEduc/Ch4/Ch4-MathsprdsheetThink.html

NEW Using spreadsheets to calculate currency conversions –lesson plan sample
http://pages.nyu.edu/~dse7916/Lesson1.html

Templates
Template Gallery: (for Windows only)
This Microsoft Website contains many templates.  Look in the education section. You will find templates for certificates, seating charts, grade books set up by average, percentage or points (Excel), as well as multiple choice, T/F and essay test templates. Do a search for templates after opening up the Microsoft web site. 
http://www.officeupdate.microsoft.com/templategallery/