2008 USM Summer Math Institute

Co-Sponsored by

Institutions of Higher Learning (IHL) U.S. Department of Education

(

No Child Left Behind

Funding)

The Center for Science and Mathematics Education The Department of Mathematics College of Science and Mathematics College of Education and Psychology TI 84 Cellsheets, Pizza Spreadsheet and monthly budget Day Eight

1

2008 U

SM S

ummer

M

ath

I

nstitute

Your Mathematics Instructors, Staff and Partners

• • •

Ms. Michelle Green, Co-Director and Co-Instructor for ( SM) 2 I

– Stringer Attendance Center – National Board Certified/Early Adolescence – Email

[email protected]

, Phone 601-428-5508

Dr. Myron Henry, Director and Co-Instructor for ( SM) 2 I

– Department of Mathematics and the Center for Science and Mathematics Education – Johnson Science Tower 314 – Email

[email protected]

, Phone 601-266-4739 or 266 6516

All Participants

(that’s you) 2

Day Eight of

( SM) 2 I

1.

2.

3.

4.

Cellsheets and tips Pizza Spreadsheet Pie and bar charts A monthly budget: by you!

3

Spreadsheet on TI-84 Plus Silver Edition Using APPS • To activate the Spreadsheet through [APPS]  • • The

CellSheet Help

window shows which buttons access the functions needed to do operations.

• The top left hand corner shows the name of the spreadsheet (S01) Listed is check amounts before taxes for eating out:

A Problem:

– $ 42.95

– $ 13.77

– $ 78.00

– $ 25.88

• Use the spreadsheet to compare 15% tips with 20% tips. Also compare the 15% tip rate with the estimation method of doubling the tax.

4

5

Ginno’s of Times Square Type Pepperoni + cheese Sausage + green pepper Onion, green pepper + tomato Diameter

22 in 18 in 14 in price $24.99

$20.99

$16.99

Gessepi’s at Central Park Type Pepperoni + cheese Sausage + green pepper Onion, green pepper + tomato Diameter

20 in 16 in 12 in price $22.99

$15.99

$14.99

6

• What do we mean by best buy?

• What headings should we have?

• What columns might we need?

• How about formulas?

• Any body hungry?

7

1 2 A B

Pizza type

3 4 5 6 7

Ginno's

peperoni + cheese sausage + green pepper onion, green pepper + tomato 8 9 10 11 12 13 14 15

Gissepi's

peperoni + cheese sausage + green pepper onion, green pepper + tomato C D E F

Which Pizza is the Best Value?

G H I

Pizza Diameter (in.) Area of pizza (in 2) Price of pizza ($) Price per square inch ($/in 2) Best buy same ingredients Best buy overall Rank

J 22 18 14 20 16 12 379.94

254.34

153.86

314.00

201.06

113.10

$24.99

$20.99

$16.99

$22.99

$15.99

$14.99

$0.066

$0.083

$0.110

$0.073

$0.080

$0.133

1 2 1 2 1 2 yes no no no no no 2 3 1 4 5 6 8

Building a Chart

• Build a Spreadsheet • Headings • Spreadsheet data • Highlight data • Insert Chart • Pie + Data • Bar + Data 9

Highlight Cells + Columns from Pizza Spread Sheet

• Highlight data F6:F8 • Insert Column Chart • Design, select data, edit series, highlight Gino’s, o.k.

• Edit horizontal category, highlight B6:B8, o.k.

• Add series • Highlight Gessepi’s • • Highlight data F11:F13, o.k.

• Layout, Chart Title , Pizza Comparisons

Format, Right Click, Axis, Alignment

10

$0.140

$0.120

$0.100

$0.080

$0.060

$0.040

$0.020

$0.000

Pizza Comparison

gino's gessipie's 11

Pie Charts, Bar Graphs, and all that Jazz!

A 1 5 6 2 3 4

Class

Sixth Grade Seventh Grade Eighth Grade Ninth Grade B C D Peru Middle School Enrollment Attrition

Enrollment

80 65

Enrollment Percentage from sixth grade

100% 81% 0% 19% E

Attrition Rate from sixth grade Annual Attrition Rate Magnifying the Decimal

0% 19% F 100 81 50 45 63% 56% 38% 44% 23% 10% 63 56 12

40 30 20 10 0 90 80 70 60 50 80 65 Sixth Grade Seventh Grade

Peru Enrollments

50 Eighth Grade 45 Ninth Grade Peru Enrollment by Grade 13

A Pie Chart

Attrition Rate from sixth grade

19% 44% Seventh Grade Eighth Grade Ninth Grade 38% 14

A Bar Graph

80 30 20 10 0 80 70 60 50 40 Enrollment Percentage of Sixth Grade Sixth Grade 80 100% 65 Seventh Grade 65 81% 50 45 Eighth Grade 50 63% Ninth Grade 45 56% Enrollment Percentage of Sixth Grade 15

A Monthly Budget

• $36,000 annual salary • $24,000 take home pay • Monthly expenses – Food $400 – Rent $700 – Car payment $250 – Electric + gas $250 – Insurance $200 – Savings + entertainment $200 • Monthly income and expenses – Total monthly income – Expenses as a percentage of monthly income 16

The Task

1. Build a spreadsheet 2. Construct a pie chart 3. Construct a bar graph 4. Construct a linear graph 17