Excel for Algebra

This collection of documents is provided as handouts in Rik Littlefield's Math 101 course at WSU Tri-Cities.

• Lesson 1: Basic Concepts and “Button-ology”
• Discussion as PDF file
• Sample spreadsheet as XLS file
• Formula Construction Exercises as XLS file
  
• Lesson 2: Checking Algebraic Transformations
• Discussion as PDF file
• Sample spreadsheet as XLS file
  
• Lesson 3: “Consumer Loan Simulation”
• Discussion as PDF file
• Sample spreadsheet as XLS file
  
• Lesson 4: “Goal Seek”
• Discussion as PDF file
• Sample spreadsheet #1 as XLS file
• Sample spreadsheet #2 as XLS file
  
• Lesson 5: “The Solver”
• Discussion as PDF file
• Sample spreadsheet as XLS file
  
• Lesson 6: Basic Graphing
• Discussion as PDF file
• Sample spreadsheet as XLS file
  
• Lesson 7: Curve Fitting with “The Solver”
• Discussion as PDF file
• Sample spreadsheet as XLS file
  

Conversion notes

• Excel 2007 vs Excel 2003
• Discussion as PDF file
  
• Excel 2007 vs OpenOffice Calc
  
• Discussion as PDF file