USM 2003 Summer Math Institute Your Mathematics Instructors ...

USM 2003 Summer Math Institute Your Mathematics Instructors ...

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 USM Summer Math Institute Your Mathematics Instructors, Staff and Partners Ms. Michelle Green, Co-Director and Co-Instructor for (SM)2I Stringer Attendance Center National Board Certified/Early Adolescence Email [email protected] , Phone 601-428-5508 Dr. Myron Henry, Director and Co-Instructor for (SM)2I Department of Mathematics and the Center for Science and Mathematics Education Johnson Science Tower 314 Email [email protected], Phone 601-266-4739 or 2666516 All Participants (thats you)

2 Day Eight of (SM)2I 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) A Problem: Listed is check amounts before taxes for eating out: $ 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 Ginnos of Times Square Type

Diameter price Pepperoni + cheese 22 in $24.99 Sausage + green pepper 18 in $20.99 Onion, green pepper + tomato 14 in $16.99 Gessepis at Central Park Type Diameter price Pepperoni + cheese

20 in $22.99 Sausage + green pepper 16 in $15.99 Onion, green pepper + tomato 12 in $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 A

B C Pizza type 3 4 6 7 8 9 10 11 12 13 14 15 E F G H I Which Pizza is the Best Value?

1 2 5 D Area of pizza Pizza Diameter (in.) (in2) Price of pizza ($) Price per square inch ($/in2) Best buy Best buy same overall ingredients Rank Ginno's peperoni + cheese 22 379.94

$24.99 $0.066 1 yes 1 sausage + green pepper 18 254.34 $20.99 $0.083 2 no 4 onion, green pepper + tomato 14 153.86 $16.99

$0.110 1 no 5 peperoni + cheese 20 314.00 $22.99 $0.073 2 no 2 sausage + green pepper 16 201.06 $15.99 $0.080

1 no 3 onion, green pepper + tomato 12 113.10 $14.99 $0.133 2 no 6 Gissepi's 8 J 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 Ginos, o.k. Edit horizontal category, highlight B6:B8, o.k. Add series Highlight Gessepis Highlight data F11:F13, o.k. Layout, Chart Title, Pizza Comparisons Format, Right Click, Axis, Alignment 10

Pizza Comparison $0.140 $0.120 $0.100 $0.080 $0.060 gino's $0.040 gessipie's $0.020 $0.000 11 Pie Charts, Bar Graphs, and all that Jazz! A B 5 6 E F Class Enrollment Enrollment Percentage from

sixth grade Attrition Rate from sixth grade Annual Attrition Rate Magnifying the Decimal Sixth Grade 80 100% 0% 0% 100 Seventh Grade 65 81% 19% 19% 81

Eighth Grade 50 63% 38% 23% 63 Ninth Grade 45 56% 44% 10% 56 2 4 D Peru Middle School Enrollment Attrition 1 3

C 12 Peru Enrollments 90 80 70 60 50 40 30 20 10 0 80 65 50 45 Peru Enrollment by Grade Sixth Grade Seventh Grade Eighth Grade Ninth Grade 13

A Pie Chart Attrition Rate from sixth grade 19% Seventh Grade 44% Eighth Grade Ninth Grade 38% 14 A Bar Graph 80 80 70 60 50 40 30 20 10 0 65 50 Enrollment Percentage of Sixth Grade Sixth Grade Enrollment Percentage of Sixth Grade

45 Eighth Grade 50 Ninth Grade 80 Seventh Grade 65 100% 81% 63% 56% 45 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

Recently Viewed Presentations

  • PowerPoint 簡報 - National Dong Hwa University

    PowerPoint 簡報 - National Dong Hwa University

    Livingston and O'Neil examine the virtues and drawbacks of three archetypical fund class structures: Class A shares have a front-end load of 5.75 percent and a 0.25 percent annual distribution (Rule 12b-1) fee; Class B shares have a 5 percent...
  • PowerPoint Presentation

    PowerPoint Presentation

    Texture Mapping Ed Angel Professor of Computer Science, Electrical and Computer Engineering, and Media Arts University of New Mexico Objectives Introduce Mapping Methods Texture Mapping Environment Mapping Bump Mapping Consider basic strategies Forward vs backward mapping Point sampling vs area...
  • Understanding DNA

    Understanding DNA

    Gene Mutations Sickle Shaped Red Blood Cells
  • ΑΡΘΡΟΛΟΓΙΑ-ΣΥΝΔΕΣΜΟΛΟΓΙΑ

    ΑΡΘΡΟΛΟΓΙΑ-ΣΥΝΔΕΣΜΟΛΟΓΙΑ

    ΑΡΘΡΟΛΟΓΙΑ-ΣΥΝΔΕΣΜΟΛΟΓΙΑ Τα είδη των αρθρώσεων είναι: ΣΥΝΑΡΘΡΩΣΕΙΣ ΧΩΡΙΣ ΚΙΝΗΤΙΚΟΤΗΤΑ
  • Graphic Sources - Jefferson County Schools, TN

    Graphic Sources - Jefferson County Schools, TN

    Graphic Sources Fourth Grade Unit 4 Week 4 Kristi Waltke Graphic Sources A graphic source, such as a picture, a map, or a chart, organizes information and makes it easy to see. You can use a graphic source to help...
  • Presentazione di PowerPoint

    Presentazione di PowerPoint

    Il giuramento, infatti, non si richiama all'ira divina, che non esiste, ma alla tutela della giustizia e della fede" "Sed in iureiurando non qui metus sed quae vis sit, debet intelligi; est enim iusiurandum affirmatio religiosa; quod autem affirmate quasi...
  • Modern World History - Central Bucks School District

    Modern World History - Central Bucks School District

    History is similar to building a house. You cannot understand certain events out of context. You must understand what occurred before in order to move on and Unit I provides the foundation for understanding the remaining content of the course
  • PowerPoint Presentation Template for all UFIT Units V.1

    PowerPoint Presentation Template for all UFIT Units V.1

    One.uf.edu - Schedule of courses currently in Beta Replace the existing systems that are used to manage prospecting and recruiting activities. Streamline processes that are managed in different systems.