Presenter.. Rick Bell

Level......... Intermediate

Common spreadsheet uses are embedded in several of the MN Academic Standards for Math. Spreadsheet programs, such as Microsoft Excel, have become necessary tools to collect, sort, and display data. Unfortunately, Excel is a program that receives little attention in the curriculum. Learn how to use this powerful tool in your math classroom. You will receive hands-on instruction, step-by-step tip sheets, and a website resource containing links and notes from the presentation.

Session Outline:

 Presentation Countdown-Excel.ppt 

How has the state integrated spreadsheets into math standards?

• MN Dept of Education: Mathematics
•  MathStandards_2007.doc
•  Spreadsheet Standards.xls

How will MS Excel help you to meet these standards? 

Introduce:

• Basics
• Charts
• Equations
•  Excel-lent Math Standards worksheet.xls

• TIP Sheet:  MS Excel.doc
  • Tutorials for basic and advanced functions
    • Worktime: Interact with Excel

• Conversion from 2002 to 2007
  • Interactive Reference Guide (very helpful)   

Example activities

•  baseball.xls
•  12days.xls
•  pulse.xls
•  vacation.xls
•  frootloops.xls
•  heart.xls 

Resources

• Why Teach Spreadsheets by Terry Freedman
• Excel in the Classroom > What's the Hype by TeAchnology
• North Canton Schools Excel Resources
• Spreadsheets in the classroom
• Google Spreadsheets