USM 2003 Summer Math Institute Your Mathematics Instructors and Partners

1
2005 USM Summer Math Institute
Co-Sponsored by Institutions of Higher Learning
(IHL) U.S. Department of Education (No Child Le
ft Behind Funding) The Center for Science and Mat
hematics Education The Department of Mathematics
College of Science and Technology College of
Education and Psychology
Day Eight
2
2005 USM Summer Math InstituteYour Mathematics
Instructors, Staff and Partners

• Ms. Michelle Green, Co-Director and Co-Instructor
  for (SM)2I
  
• Stringer Attendance Center
• Eighth Grade Teacher
• Email mdwgreen_at_hotmail.com, Phone [phone]
• 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 myron.henry_at_usm.edu, Phone [phone] or
  266-6516
  
• All Participants (thats you)

3
Day Eight of (SM)2I

• CelSheets, Lists, and Tips
• Kitty Perry
• Amy Bullock
• Shauna Hedgepeth
• Problem Simulation (teams)
• Pizza Spreadsheet
• Pie and bar charts
• A monthly budget by you!

4
(No Transcript)
5
Pie Charts, Bar Graphs, and all that Jazz!
6
Building a Chart

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

7
05Peruattritonesm2i03.xls
A Pie Chart
Peru Middle School Enrollment
8
A Bar Graph
Peru Middle School
9
Peru Middle School Enrollments and Attrition The
Whole Story!
510Peruattritfnlsm2i03.xls
10
(No Transcript)
11

• What do we mean by best buy?
• What headings should we have?
• What columns might we need?
• How about formulas?
• Any body hungry?

12
(No Transcript)
13
510pizzacmprsm2ifnl05.xls
14
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

15
The Task

• Build a spreadsheet
• Construct a pie chart
• Construct a bar graph
• Construct a linear graph

Monthlybudgetone.xls
Monthlybudgettwo.xls