Algebraic Problem-Solving Using Spreadsheets:

Setting Up a Problem on a Spreadsheet

by Margaret Sinclair


Back to Algebraic Problem-Solving using Spreadsheets || Math Units: Contents

The aims of this section are:


Problem 1: Animals in the farmyard

There are 53 horses and cows in Farmer Wren's farmyard. There are 21 more cows than horses. How many of each type of animal are there?

Think about the Problem:

Enter the Information

Once the information is entered, find the row that has 53 animals in the Total column. Look at columns A and B to discover how many cows and horses there are in Farmer Wren's farmyard. (You should have a row that shows 16 horses, 37 cows and a total of 53.)

If you haven't done so already, set your Web browser to use ClarisWorks as a helper application for these examples. Then open this spreadsheet to practice entering the formulas.

If you have Microsoft Excel, open this spreadsheet.


Experiment

Develop an Equation


Problem 2: Theater Tickets

For a play, the ticket prices were $5.00 per child and $8.50 per adult. The children bought 100 more tickets than the adults. The total box office income was $905.00.

Set up a spreadsheet to do the calculations and to work out how many tickets of each type were sold.

Think about the Problem

Enter the Information

Once the information is entered, find the row that has a total of $905.00 in column C. Look at columns A and B to discover how many children and adult tickets were sold.

If you have ClarisWorks, open this spreadsheet to find the solution yourself.

If you have Microsoft Excel, open this spreadsheet.


Experiment

Develop an Equation


[Graphing with Spreadsheets, from Suzanne Alejandre's math units.]
[Ask Dr. Math]

1. Formulas on a Spreadsheet 3. Spreadsheet problems
2. Setting up a problem on a spreadsheet 4. Follow-up in the classroom

_____________________________________
Suggestion Box || Home || The Collection || Help Desk || Quick Reference || Search
_____________________________________

Please mail comments and suggestions to
Margaret Sinclair