Transcript Technology Tools for Mathematics Instruction Andrew Worsey Department of Mathematical Sciences

Technology Tools for Mathematics
Instruction
Andrew Worsey
Department of Mathematical Sciences
Middle Tennessee State University
[email protected]
www.mtsu.edu/~ajworsey
Acknowledgements

Dept. of Mathematical Sciences, MTSU.

Faculty Development Grant, MTSU.

Instructional Technology Grant, MTSU.
Overview

Excel - solver.
 Solve

Linear systems/Linear Programming.
Live Math.
 Distributed

tools for interactive Learning.
Java applets.
 Web
Resources/ Conference Information.
Microsoft Excel - Solver

Linear equations:
2x + 3y = 4
3x - 5y = 6

Type data in Excel:
2x+3y=4
3x-5y=6
x
y
#VALUE!
#VALUE!
A
1
B
C
X
Y
2 2x+3y=4 =2*B1+3*C1
3 3x-5y=6 =3*B1-5*C1
Active Spreadsheet
Solver.








From Tools menu, select Solver. (Add as needed).
Select “target cell” as B2.
Select “Value of ” and enter “4” in box.
In the “By Changing Cells ” box, type B1,C1. (The
cells where you typed “x”, “y”.).
Click “Add ” under “Subject to Constraints ”. Now
click the cell with the formula for the L.H.S. of the
2nd. equation. Select “=”. In last box, enter “6”.
Click OK – to return to Solver menu.
Click Solve.
Answers for “x”, “y” will appear in cells B1,C1.
Linear programming

Maximize 6x – 3y
2x + 3y <= 48
7x + 3y <= 21
x >= 0, y >= 0

Type in Excel:
A
B
1
x
2
6x-3y
=6*B1-3*C1
3 2x+3y<=48 =2*B1+3*C1
4 7x+3y<=21 =7*B1+3*C1
5
x>=0
=B1
6
y>=0
=C1
C
y
Active Spreadsheet
x
y
6x-3y
#VALUE!
2x+3y<=48 #VALUE!
7x+3y<=21 #VALUE!
x>=0
x
y>=0
y
Now, simply run solver as before, suitably
modified:
Solver.








From Tools menu, select Solver. (Add as needed).
Select “target cell” as B2.
Select “Max ”.
In the “By Changing Cells ” box, type B1,C1. (The
cells where you typed “x”, “y”.)
Click “Add ” under “Subject to Constraints ”.
Add all constraints, in order.
Click OK – to return to Solver menu.
Click Solve.
Answers for “x”, “y” will appear in cells B1,C1
Live Math!





Basic Algebra through Advanced Calculus
WYSIWYG
Solve Problems in full detail
“Maker” software to develop applications
FREE plug-in
www.livemath.com
www.livemath.com/tour
Java Applets.

Web tools for Mathematics (T. Leathrum).


Web tools for Mathematics.


Follow “Mathlets” link for excellent Applets.
Emporia State Univ.
Learning Java - creating tools yourself.


Conference, June 22 - 23 2001 ($10!!).
Web Site http://mathcsjava.emporia.edu/.