Home About Pricing Order Form NCTM Atlanta Samples Feedback Contents

 

 

NCTM Atlanta

 

This page has links to a modified flash movie of the presentation given at NCTM 2007 to launch the ICT4U Middle School Spreadsheet book.

 

Powerpoint Presentation

 

Spreadsheet Exercises

The first spreadsheet investigates the three different solutions relating to the cell phone problem in the ICT4U Middle School Spreadsheets Book.

The problem states that:

Juan and Sylvia each have a cell phone. They were comparing costs to see who has the better deal. Juan’s company charges 20c for making a call and then charges 60 c for each minute of the call. Sylvia’s company charges 30c perminute but charges 80c to make the call. All call charges are for 1 minute minimum. How many minutes can they talk on the phone so that their charges are equal?

This is answered in solution 1. The other 2 solutions explore other options. After completing the ICT4U Middle School Spreadsheet book student will be able to write their own spreadsheet investigations.

 

Cell Phone

 

These spreadsheets are the ones referred to during the PowerPoint presentation above. When you click on the link below, you will be asked if you want to Open or Save the file. If you do not have Microsoft Excel installed on your computer, you can download the Microsoft Excel File Viewer from Microsoft's web site. You can right-click each link below and save the Excel file directly to your computer.

Coins

Dice

Free Throw 50%

Free throw 50% 1000 trials

Variable Free throw

Winning Streak

 

Send mail to sales@ict4u.com with questions or comments about this web site.
Copyright © 2007 ICT4U EDUCATION LLC
Last modified: 11/07/07