Illinois State University Mathematics Department

 MAT 326: Technology Tools for Secondary School Mathematics Dr. Roger Day (day@ilstu.edu)

### Session #5

17 September 2012

Warming Up: Free Rice, Anyone? or Algebra Problem of the Day

New Groups via SmartBoard shake-up.

Spreadsheet Warm-Ups: Work through these practice sets in groups of no more than three people.

• Set I
• Call up this Excel file (excelbasics01). With this Excel file open, open and view the following videos, in the order shown. As you view each video, modify the spreadsheet that you also have open. It will often be necessary to pause or replay the video!
• Set II
• Create one spreadsheet file to contain a separate tab (sheet) for each of the following situations.
• Create a spreadsheet that will allow a user to enter the coordinates of two points (ordered pairs) and the spreadsheet will then show two equations for the line containing those two points, including the point-slope form for a line and the slope-intercept form. Look at the video here for a guide to the format of your spreadsheet file. Name the tab (sheet) Linear Equation.
• Create a spreadsheet that will allow a user to enter a value for which a square root approximation is desired and the spreadsheet will then show the steps of Newton's Method in determining that approximation. Look at the video here for a guide to the format for this spreadsheet file. Name the tab (sheet) Newton's Method.
• Create a spreadsheet that will allow a user to enter the numerical coefficients of any fourth-degree polynomial together with a specific value of x and the spreadsheet will show an approximation for the numerical value of the derivative of the polynomial at the specified point. Look at the video here for a guide to the format for this spreadsheet file. Name the tab (sheet) Polynomial Derivative.
• When all three tabs (sheets) are complete in one file, name the file as follows: 326SSwarmup01name, where "name" is replaced by the last name of the person in your group who would be listed first in an alphabetized list of last names. Attach that file to an email and send it to me with the subject line, "Spreadsheet Warm-Up #1" (no quote marks). At the top of your email message, show the first name and last name of each person in your group.

Mobile Apps: A Preview

Here's an example of an iPad app that a school mathematics teacher might use.

Assignments for Session #6 (24 Sept 2012)

• Complete the Spreadsheet Warm-Up activities as described above, through the first item in the Set II spreadsheets, Linear Equations. Requirement: Spreadsheet file submission by email, due Saturday, September 22, by 9:54 pm. Note that one submission is required per group! Each group member, however, should retain a copy of the Excel file.
• Continue to look for and critique mobile apps that focus on school mathematics, preferably secondary school mathematics. More info on this to follow.
• Search for an online warm-up activity to share with others. Details to follow.

 Last Session Next Session 326 Homepage

Here is the guide for Phase II of the College Laundry Problem.

1. Load the Excel file named collegelaundry01.xlsx. The spreadsheet provides blanks for you to enter numerical values related to the problem.
2. Suppose a container with 128 ounces of detergent, selling for \$12.59, has a 2-ounce cap, and a capful of liquid is used for a full load of laundry.
3. Fix the add-back ratio at 50% (0.5). Vary the concentration threshold and observe the results. Write a sentence or two to describe your results.
4. Fix the concentration threshold at 75% (0.75). Vary the add-back ratio and observe the results. Write a sentence or two to describe your results.
5. Explore various combinations of add-back ratio (a value between 0 and 1) and concentration threshold (also a value between 0 and 1). Determine three different pairs (add-back ratio, concentration threshold) that seem to result in the most worthwhile application of this ad-back strategy. Be sure to include your definition of "worthwhile" here!
6. Write a few sentences in response to each question:
(a) How did this spreadsheet help or hinder your exploration of the problem?