Create a PowerPoint presentation with detailed speaker notes in each content discussion slide

profileHealthy Student
Deliverable4.xlsx

Dashboard

DIABETES INDICATOR DATA
NATIONAL DATA INDICATORS COUNTY DATA INDICATORS
Race Age Prevalence Physical Inactivity Risk
Gender Education Obesity Risk

Percentage Total Population with Diabetes

Total 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 6 6.4 6.5 6.6 7 7.3 7.6 7.5 7.9 8.6 8.6999999999999993 8.4 8.4 8.6999999999999993 8.4 8.6999999999999993 8.5 8.5 9.1

Population with Obesity

Sum of Total_OBS 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0 0 0 0 0 20 21.3 23.6 23.9 23.8 25 24.5 24.9 24.1 24.3 25.3 26.7 26.3 26.1 Sum of Male_OBD_Pop. 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0 0 0 0 0 21 22.9 25.6 26.2 25.9 26.9 26.8 27.1 26.1 25.8 26.8 28.7 27.7 26.5 Sum of Female_OBS_Pop 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0 0 0 0 0 19 19.7 21.8 21.8 21.8 23 22.3 22.8 22.3 23 24 24.8 25 25.7

Race-Ethnicity

Sum of Hispanic 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 8.8000000000000007 9.1999999999999993 9.1999999999999993 8.5 10.1 9.6 10.3 10.9 10.8 12.2 13 11.9 12 12.3 11.8 12 11.7 12.5 12.4 Sum of Non-Hispanic White 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 5.2 5.6 5.8 5.9 6 6.6 6.7 6.3 7 7.6 7.5 7.2 7.2 7.6 7.1 7.4 7.4 7.3 7.8 Sum of Non-Hispanic Black 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 10.1 10.3 9.9 10 11.1 11.3 11.8 12.3 11.1 13 12.6 12.5 12.8 12.3 13 12.8 12.7 11 12.4 Sum of Non-Hispanic Asian 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 4.5 5 6.2 6.3 7.5 6.3 8.1999999999999993 8.6999999999999993 7.9 8.1 9 8.5 8.6999999999999993 8 7.5 8.5 7.4 8.6 10

Gender

Sum of Male_N 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 6.4 6.9 7.2 7.1 7.5 7.7 7.8 7.9 8.1 9.4 9.6 9 8.6999999999999993 9.1999999999999993 8.9 9.1999999999999993 9 9.5 9.8000000000000007 Sum of Female_N 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 5.6 6.1 6 6.1 6.5 7 7.4 7.3 7.8 7.9 7.9 7.9 8.1999999999999993 8.1999999999999993 7.9 8.3000000000000007 8.1999999999999993 7.6 8.6

Age

Sum of 18-44 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 1.9 2 1.9 1.9 2 2.4 2.7 2.2000000000000002 2.2999999999999998 2.9 2.7 2.4 2.4 2.7 2.4 2.2000000000000002 2.8 2.7 3.3 Sum of 45-64 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 8.3000000000000007 9.3000000000000007 9.3000000000000007 9.1 9.9 10.5 10.5 10.6 11.9 12.5 12.1 12 12.5 12.3 12 12.8 12.1 12.7 12.4 Sum of 65-74 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 15.8 16.7 17 17.600000000000001 18.5 18.600000000000001 18.2 20 19.8 19.899999999999999 21.4 22.2 20.5 21 21.5 22.1 22 19.100000000000001 21.4 Sum of 75+ 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 20 18 13.2 13.6 14.8 15.5 16 15.3 17.899999999999999 17.3 16.899999999999999 18.899999999999999 21.3 18.7 19.399999999999999 20.9 19.2 21.2 18.600000000000001 19 21.8

Education

Sum of < High School 2000 9.1999999999999993 Sum of High School 2000 5.9 Sum of > High School 2000 4.8

Prevalence (%)

Sum of Age-adjusted Rate (per 100)

Females Males Overall 13.7 10.4 12 Sum of Crude Rate(per 100)

Females Males Overall 13.1 9.9 11.5

Prevalence By Age (%)

Sum of Estimated Cases ('000s)

18-64 65+ Total 1825.6 1043.7 2869.4 Sum of Estimated Cases Attributable to Diabetes ('000s)

18-64 65+ Total 985.3 422.5 1444.7

Total Affected Popultion in the County

Total 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0 0 0 0 0 7.5 7.3 7.8 7.7 8.3000000000000007 10.1 10.1 10.3 9.4 9.1999999999999993 9 9.1 8.5 9.1

Population Showing Phyiscal Inactivity

Sum of Total_PI_Pop 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0 0 0 0 0 19.2 19.600000000000001 21 20.5 20.3 20.2 20.7 20.399999999999999 20.399999999999999 19.899999999999999 19.7 19.899999999999999 19.899999999999999 21.3 Sum of Male_P.I_Pop 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0 0 0 0 0 16.5 17.2 18.8 18.2 18.2 18.100000000000001 18.600000000000001 18.3 18.5 18.600000000000001 18.399999999999999 18.7 18.8 19.7 Sum of Female_P.I_Pop 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0 0 0 0 0 21.7 21.9 23.1 22.6 22.4 22 22.4 22.3 22.1 21.1 21 20.9 20.8 22.8

Data Board

County Row Labels Sum of Total Pop. Affected_C Row Labels Sum of Total_OBS Sum of Male_OBD_Pop. Sum of Female_OBS_Pop Row Labels Sum of Total_PI_Pop Sum of Male_P.I_Pop Sum of Female_P.I_Pop Row Labels Sum of Male_C Sum of Female_C
2000 0 2000 0 0 0 2000 0 0 0 2000 0 0
2001 0 2001 0 0 0 2001 0 0 0 2001 0 0
2002 0 2002 0 0 0 2002 0 0 0 2002 0 0
2003 0 2003 0 0 0 2003 0 0 0 2003 0 0
2004 0 2004 0 0 0 2004 0 0 0 2004 0 0
2005 7.5 2005 20 21 19 2005 19.2 16.5 21.7 2005 8 7.2
2006 7.3 2006 21.3 22.9 19.7 2006 19.6 17.2 21.9 2006 8 6.7
2007 7.8 2007 23.6 25.6 21.8 2007 21 18.8 23.1 2007 8.7 7.1
2008 7.7 2008 23.9 26.2 21.8 2008 20.5 18.2 22.6 2008 8.7 6.9
2009 8.3 2009 23.8 25.9 21.8 2009 20.3 18.2 22.4 2009 9.2 7.6
2010 10.1 2010 25 26.9 23 2010 20.2 18.1 22 2010 11.1 9.3
2011 10.1 2011 24.5 26.8 22.3 2011 20.7 18.6 22.4 2011 11.2 9.3
2012 10.3 2012 24.9 27.1 22.8 2012 20.4 18.3 22.3 2012 11.4 9.5
2013 9.4 2013 24.1 26.1 22.3 2013 20.4 18.5 22.1 2013 10.3 8.6
2014 9.2 2014 24.3 25.8 23 2014 19.9 18.6 21.1 2014 10.1 8.4
2015 9 2015 25.3 26.8 24 2015 19.7 18.4 21 2015 9.7 8.4
2016 9.1 2016 26.7 28.7 24.8 2016 19.9 18.7 20.9 2016 9.7 8.6
2017 8.5 2017 26.3 27.7 25 2017 19.9 18.8 20.8 2017 8.8 8.3
2018 9.1 2018 26.1 26.5 25.7 2018 21.3 19.7 22.8 2018 9.6 8.8
Grand Total 123.4 Grand Total 339.8 364 317 Grand Total 283 256.6 307.1 Grand Total 134.5 114.7
Row Labels Sum of Total_N Row Labels Sum of < High School Sum of High School Sum of > High School Row Labels Sum of Hispanic Sum of Non-Hispanic White Sum of Non-Hispanic Black Sum of Non-Hispanic Asian
2000 6 2000 9.2 5.9 4.8 2000 8.8 5.2 10.1 4.5
2001 6.4 Grand Total 9.2 5.9 4.8 2001 9.2 5.6 10.3 5
2002 6.5 2002 9.2 5.8 9.9 6.2
2003 6.6 2003 8.5 5.9 10 6.3
2004 7 2004 10.1 6 11.1 7.5
2005 7.3 2005 9.6 6.6 11.3 6.3
2006 7.6 2006 10.3 6.7 11.8 8.2
2007 7.5 2007 10.9 6.3 12.3 8.7
2008 7.9 2008 10.8 7 11.1 7.9
2009 8.6 2009 12.2 7.6 13 8.1
2010 8.7 2010 13 7.5 12.6 9
2011 8.4 2011 11.9 7.2 12.5 8.5
2012 8.4 2012 12 7.2 12.8 8.7
2013 8.7 2013 12.3 7.6 12.3 8
2014 8.4 2014 11.8 7.1 13 7.5
2015 8.7 2015 12 7.4 12.8 8.5
2016 8.5 2016 11.7 7.4 12.7 7.4
2017 8.5 2017 12.5 7.3 11 8.6
2018 9.1 2018 12.4 7.8 12.4 10
Grand Total 148.8 Grand Total 209.2 129.2 223 144.9
Row Labels Sum of Male_N Sum of Female_N Row Labels Sum of 18-44 Sum of 45-64 Sum of 65-74 Sum of 75+
2000 6.4 5.6 2000 1.9 8.3 15.8 13.2
2001 6.9 6.1 2001 2 9.3 16.7 13.6
2002 7.2 6 2002 1.9 9.3 17 14.8
2003 7.1 6.1 2003 1.9 9.1 17.6 15.5
2004 7.5 6.5 2004 2 9.9 18.5 16
2005 7.7 7 2005 2.4 10.5 18.6 15.3
2006 7.8 7.4 2006 2.7 10.5 18.2 17.9
2007 7.9 7.3 2007 2.2 10.6 20 17.3
2008 8.1 7.8 2008 2.3 11.9 19.8 16.9
2009 9.4 7.9 2009 2.9 12.5 19.9 18.9
2010 9.6 7.9 2010 2.7 12.1 21.4 21.3
2011 9 7.9 2011 2.4 12 22.2 18.7
2012 8.7 8.2 2012 2.4 12.5 20.5 19.4
2013 9.2 8.2 2013 2.7 12.3 21 20.9
2014 8.9 7.9 2014 2.4 12 21.5 19.2
2015 9.2 8.3 2015 2.2 12.8 22.1 21.2
2016 9 8.2 2016 2.8 12.1 22 18.6
2017 9.5 7.6 2017 2.7 12.7 19.1 19
2018 9.8 8.6 2018 3.3 12.4 21.4 21.8
Grand Total 158.9 140.5 Grand Total 45.8 212.8 373.3 339.5
Row Labels Sum of Estimated Cases ('000s) Sum of Estimated Cases Attributable to Diabetes ('000s)
18-64 1825.6 985.3
65+ 1043.7 422.5
Total 2869.4 1444.7
Grand Total 5738.7 2852.5
Row Labels Sum of Age-adjusted Rate (per 100) Sum of Crude Rate(per 100)
Females 13.7 13.1
Males 10.4 9.9
Overall 12 11.5
Grand Total 36.1 34.5

Data

COUNTY NATIONAL DATA
TOTAL POPULATION AFFECTED RISK FACTORS GENDER EDUCATION RACE_ETHNICITY GENDER AGE
Year Total Pop. Affected_C Total_OBS Male_OBD_Pop. Female_OBS_Pop Total_PI_Pop Male_P.I_Pop Female_P.I_Pop Male_C Female_C Total_N < High School High School > High School Hispanic Non-Hispanic White Non-Hispanic Black Non-Hispanic Asian Male_N Female_N 18-44 45-64 65-74 75+
2000 0 0 0 0 0 0 0 0 0 6 9.2 5.9 4.8 8.8 5.2 10.1 4.5 6.4 5.6 1.9 8.3 15.8 13.2
2001 0 0 0 0 0 0 0 0 0 6.4 9.8 7 4.9 9.2 5.6 10.3 5 6.9 6.1 2 9.3 16.7 13.6
2002 0 0 0 0 0 0 0 0 0 6.5 9.8 6.9 5.3 9.2 5.8 9.9 6.2 7.2 6 1.9 9.3 17 14.8
2003 0 0 0 0 0 0 0 0 0 6.6 9.2 6.1 5.9 8.5 5.9 10 6.3 7.1 6.1 1.9 9.1 17.6 15.5
2004 0 0 0 0 0 0 0 0 0 7 9.8 7.1 5.9 10.1 6 11.1 7.5 7.5 6.5 2 9.9 18.5 16
2005 7.5 20 21 19 19.2 16.5 21.7 8 7.2 7.3 10.3 7.4 6.3 9.6 6.6 11.3 6.3 7.7 7 2.4 10.5 18.6 15.3
2006 7.3 21.3 22.9 19.7 19.6 17.2 21.9 8 6.7 7.6 9.9 8.2 6.5 10.3 6.7 11.8 8.2 7.8 7.4 2.7 10.5 18.2 17.9
2007 7.8 23.6 25.6 21.8 21 18.8 23.1 8.7 7.1 7.5 11.5 7.9 6.1 10.9 6.3 12.3 8.7 7.9 7.3 2.2 10.6 20 17.3
2008 7.7 23.9 26.2 21.8 20.5 18.2 22.6 8.7 6.9 7.9 11.9 9 6.2 10.8 7 11.1 7.9 8.1 7.8 2.3 11.9 19.8 16.9
2009 8.3 23.8 25.9 21.8 20.3 18.2 22.4 9.2 7.6 8.6 12.9 9.4 7.1 12.2 7.6 13 8.1 9.4 7.9 2.9 12.5 19.9 18.9
2010 10.1 25 26.9 23 20.2 18.1 22 11.1 9.3 8.7 12.5 9 7.5 13 7.5 12.6 9 9.6 7.9 2.7 12.1 21.4 21.3
2011 10.1 24.5 26.8 22.3 20.7 18.6 22.4 11.2 9.3 8.4 12.9 8.9 6.9 11.9 7.2 12.5 8.5 9 7.9 2.4 12 22.2 18.7
2012 10.3 24.9 27.1 22.8 20.4 18.3 22.3 11.4 9.5 8.4 12.3 9.5 7 12 7.2 12.8 8.7 8.7 8.2 2.4 12.5 20.5 19.4
2013 9.4 24.1 26.1 22.3 20.4 18.5 22.1 10.3 8.6 8.7 12.2 9.4 7.5 12.3 7.6 12.3 8 9.2 8.2 2.7 12.3 21 20.9
2014 9.2 24.3 25.8 23 19.9 18.6 21.1 10.1 8.4 8.4 12.9 9.5 6.7 11.8 7.1 13 7.5 8.9 7.9 2.4 12 21.5 19.2
2015 9 25.3 26.8 24 19.7 18.4 21 9.7 8.4 8.7 12.7 9.8 7.4 12 7.4 12.8 8.5 9.2 8.3 2.2 12.8 22.1 21.2
2016 9.1 26.7 28.7 24.8 19.9 18.7 20.9 9.7 8.6 8.5 12.9 9.4 7.2 11.7 7.4 12.7 7.4 9 8.2 2.8 12.1 22 18.6
2017 8.5 26.3 27.7 25 19.9 18.8 20.8 8.8 8.3 8.5 13.2 9.2 7.2 12.5 7.3 11 8.6 9.5 7.6 2.7 12.7 19.1 19
2018 9.1 26.1 26.5 25.7 21.3 19.7 22.8 9.6 8.8 9.1 13.4 10.2 7.8 12.4 7.8 12.4 10 9.8 8.6 3.3 12.4 21.4 21.8
Sex Age-adjusted Rate (per 100) Crude Rate(per 100)
Overall 12 11.5
Males 10.4 9.9
Females 13.7 13.1
Self-reported Severe Vision Impairment or Blindness
95% Confidence Interval
Age Group Estimated Cases ('000s) Crude Rate(per 100) Lower Limit Upper Limit Estimated Cases Attributable to Diabetes ('000s)
18-64 1,825.60 12.3 11.5 13.2 985.3
65+ 1,043.70 10.4 9.6 11.2 422.5
Total 2,869.40 11.5 11 12.1 1,444.70