VIRTUAL CONFERENCE ictcm.com | #ICTCM 32 nd International Conference - - PowerPoint PPT Presentation

▶
virtual conference
SMART_READER_LITE
LIVE PREVIEW

VIRTUAL CONFERENCE ictcm.com | #ICTCM 32 nd International Conference - - PowerPoint PPT Presentation

Mar 21, 2023 155 likes •396 views

32 nd International Conference on Technology in Collegiate Mathematics VIRTUAL CONFERENCE ictcm.com | #ICTCM 32 nd International Conference on Technology in Collegiate Mathematics VIRTUAL CONFERENCE #ICTCM Spreadsheets for Quantitative

slide-1
SLIDE 1

32nd International Conference on Technology in Collegiate Mathematics

ictcm.com | #ICTCM

VIRTUAL CONFERENCE

slide-2
SLIDE 2

32nd International Conference on Technology in Collegiate Mathematics VIRTUAL CONFERENCE

#ICTCM

Spreadsheets for Quantitative Reasoning:

An Excel-lent Way to Engage Students

Outline:

  • Why QR?
  • QR Course:
  • Proportional Reasoning
  • Spreadsheets
  • Examples

Eric Gaze

Director of the QR Program Bowdoin College egaze@Bowdoin.edu

slide-3
SLIDE 3

32nd International Conference on Technology in Collegiate Mathematics VIRTUAL CONFERENCE

#ICTCM

Why QR? 87% of U.S. Adults Cannot Read or Write…

…With Numbers. They are Quantitatively Illiterate.

slide-4
SLIDE 4

Only 13% U.S. Adults Proficient In QL

slide-5
SLIDE 5

National Assessment of Adult Literacy: Proportional Reasoning Only 13% of U.S. Adults can:

  • Calculate annual from monthly costs
  • Determine flooring units per square foot

Over half of U.S. adults cannot:

  • Calculate cost of child as % of budget
  • Determine if car has enough gas
  • Calculate total cost of ordering supplies
slide-6
SLIDE 6

Current State of Affairs: Numeracy (OECD 2013 PIAAC)

Proportional Reasoning

U.S. is Significantly Last (p < .05)

slide-7
SLIDE 7

Current State of Affairs: Technology Problem Solving

Modeling with Spreadsheets

U.S. beat Poland

slide-8
SLIDE 8

Working with Data: Proportional Reasoning in Action!

  • 5,000.0

10,000.0 15,000.0 20,000.0 25,000.0 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010

Mortality Rates per 100,000

Over 85 75-84 65-74 55-64 45-54 25-44 Below 25

slide-9
SLIDE 9

Working with Data: Proportional Reasoning in Action!

  • 5,000.0

10,000.0 15,000.0 20,000.0 25,000.0 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010

Mortality Rates per 100,000

Over 85 75-84 65-74 55-64 45-54 25-44 Below 25

  • 20.0

40.0 60.0 80.0 100.0 120.0 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010

Mortality Rates per 100,000 (1968 = 100)

Over 85 75-84 65-74 55-64 45-54 25-44 Below 25

= B4/B$3*100

slide-10
SLIDE 10

Rationality quotient

 Are “smart” people good at reasoning correctly?  Three forms of intelligence:  Analytic (Intelligence Quotient)

 IQ scores, SAT

, emphasized in school education, how to run a statistical test

 Practical

 Knowing when to run the statistical test and why!

Communicating results. Creating graphics using spreadsheets!

 Creative

 Questioning assumptions. What-if analysis.  Modeling with Spreadsheets!

slide-11
SLIDE 11

Quantitative Reasoning (QR):

Mathematics and Democracy (2001)

“Quantitative reasoning empowers people by giving them tools to think for themselves, to ask intelligent questions of experts, and to confront authority confidently.”

slide-12
SLIDE 12

Quantitative Reasoning (QR):

A Program for Student Success “I came to a drastic realization, I actually enjoyed doing math! Thank you. Last semester was the first time in my life that I looked forward to a math class, and applied what I learned outside of the

  • classroom. Therefore, I REALLY want to take

another math class like this.”

  • Fiona
slide-13
SLIDE 13

Quantitative Reasoning (QR):

A Program for Student Success “Tonight at dinner my brother and relatives were discussing the time value of money. After hearing my businessy-brother compare fund quotes over different years I whipped out my CPI’s and apples to oranges argument and supported it with equations and QR logic snippets.”

  • Fiona
slide-14
SLIDE 14

Quantitative Reasoning (QR):

A Program for Student Success

“As the (very-labeled) humanities and arts child, it got me quite a few points. So THANK YOU, for enabling me to argue with my brother on his own playing field. That aside I learned a LOT this semester.”

  • Fiona
slide-15
SLIDE 15

The Wrong Way to Teach Math

“Ours has become a quantitative century, and we must master its language. Decimals and ratios are now as crucial as nouns and verbs.”

  • Andrew Hacker Professor Emeritus CUNY

New York Times February 27, 2016

  • http://www.nytimes.com/2016/02/28/opinion/sunday/the-wrong-way-to-teach-

math.html

slide-16
SLIDE 16

Modeling as Business Math

Circa 2015 CE

slide-17
SLIDE 17

The Right Way to Teach Math

“For there is a much more recent implementation of al-Khwarizmi's method of algebra--one of immediate use to everyone in today's world: the electronic spreadsheet. A perfectly correct description of Microsoft Excel is that it is a computer implementation of algebra…”

  • Keith Devlin February 29, 2016
  • http://www.huffingtonpost.com/dr-keith-devlin/andrew-hacker-and-the-

cas_b_9339554.html

slide-18
SLIDE 18

Algebra as Business Math

“The spreadsheet changes the way people in business think about and approach problems as well as the way they work through results. It enables them to quantify a whole new range of problems.” “Mathematical reasoning in workplaces differs markedly from the algorithms taught in school.”

slide-19
SLIDE 19

Quantitative Reasoning (QR): A Program for Student Success “QR was one of the most useful courses I have taken at Bowdoin. I am interning at IBM this summer as a part of their Watson Sales Enablement team and constantly use spreadsheets and

  • QR. Thank you for bringing in and

teaching this course!”

  • Daniel
slide-20
SLIDE 20

32nd International Conference on Technology in Collegiate Mathematics VIRTUAL CONFERENCE

#ICTCM

Contact Information

Name: Eric Gaze Title: Director of QR Program Institution: Bowdoin College Email: egaze@Bowdoin.edu Social Media handle/name

slide-21
SLIDE 21

Modeling Car Cost: Proportional Reasoning in Action!

Focus Prius Cost 20,000.00 $ 33,000.00 $ Gallons per 100 miles MPG Hway 28 45 3.571 2.222 MPG City 22 37 4.545 2.703 Gallons Used Miles Hway

8,000

285.71 177.78 Miles City

12,000

545.45 324.32 Price per Gallon

3.86 $

Total Gallons: 831.17 502.10 Cost: 3,208.31 $ 1,938.11 $ Gas Savings per year: 1,270.20 $ Extra Cost: 13,000.00 $ Years to recoup: 10.23 years

slide-22
SLIDE 22

Modeling Car Cost

Focus Prius Cost 20,000.00 $ 33,000.00 $ Gallons per 100 miles MPG Hway 28 45 3.571 2.222 MPG City 22 37 4.545 2.703 Gallons Used Miles Hway

8,000

285.71 177.78 Miles City

12,000

545.45 324.32 Price per Gallon

3.86 $

Total Gallons: 831.17 502.10 Cost: 3,208.31 $ 1,938.11 $ Gas Savings per year: 1,270.20 $ Extra Cost: 13,000.00 $ Years to recoup: 10.23 years

Is Algebra Necessary? Yes! And we can use spreadsheets and modeling to help teach students why. Handouts have more examples  Which parameter has the greatest impact on the years to recoup extra cost of the Prius?

  • 1. Cost of Prius
  • 2. MPG City Focus
  • 3. Cost of Focus
  • 4. MPG City Prius
slide-23
SLIDE 23

Scaffolding Student Success

 Math 1050: QR is an ENTRY point  Math 1050: QR as a foundation for Calculus and Social

Science

 Math 1050: QR is an EXIT point  Future Work

Low QR skills High QR skills Weak Foundational Knowledge Strong Foundational Knowledge Underprepared Students Successful Students Note that IQ is not on this chart! We can build the skills and knowledge needed for success.

THANK YOU! Questions?