{"id":486,"date":"2018-04-05T12:34:04","date_gmt":"2018-04-05T17:34:04","guid":{"rendered":"http:\/\/web.education.wisc.edu\/nwhillman\/?p=486"},"modified":"2018-04-05T12:35:27","modified_gmt":"2018-04-05T17:35:27","slug":"state-funding-trends-in-motion-chart","status":"publish","type":"post","link":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/2018\/04\/05\/state-funding-trends-in-motion-chart\/","title":{"rendered":"State higher education funding &#8211; motion charts"},"content":{"rendered":"<p>Each year, State Higher Education Executive Officers (SHEEO) produces the go-to guide for state-level trends in higher education finance, downloadable and interactive data <a href=\"http:\/\/www.sheeo.org\/projects\/shef-%E2%80%94-state-higher-education-finance\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>Using this data, I created the following motion chart where each bubble represents a state. Pressing the play button shows how appropriations (x-axis) and net tuition revenue (y-axis) change over time.<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1_9Jh1UsZI_LjZfqIcssqJbTq50XTyPbSVglHQBbXVAA\/edit#gid=704665724\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-488\" src=\"http:\/\/web.education.wisc.edu\/nwhillman\/wp-content\/uploads\/sites\/16\/2018\/04\/motionchart-300x233.png\" alt=\"\" width=\"400\" height=\"300\" \/><\/a><\/p>\n<p>You can select individual states and change the bubble color\/size. All financial data are presented in 2017 dollars based on CPI and the &#8220;tuition-to-appropriations&#8221; ratio is simply that: net tuition relative to net appropriations, where values over 1 indicate the state generates more revenue from tuition than it appropriates. For more details on the data, see their <a href=\"http:\/\/www.sheeo.org\/projects\/shef-%E2%80%94-state-higher-education-finance\" target=\"_blank\" rel=\"noopener\">report<\/a>.<\/p>\n<p>I hope you find this tool helpful! I like using it as a teaching tool, so please feel free to use and share. I sometimes run into trouble depending on the browser I&#8217;m using, so just a heads-up on that front. Unfortunately, Google <a href=\"https:\/\/gsuiteupdates.googleblog.com\/2017\/06\/charts-in-sheets-updates_1.html\" target=\"_blank\" rel=\"noopener\">retired<\/a> Motion Charts, but I was able to update this with the most recent data so hopefully it has some shelf life.<\/p>\n<p>Please let me know if you see any bugs or if you find interesting patterns!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Each year, State Higher Education Executive Officers (SHEEO) produces the go-to guide for state-level trends in higher education finance, downloadable and interactive data here. Using this data, I created the following motion chart where each bubble represents a state. Pressing the play button shows how appropriations (x-axis) and net tuition revenue (y-axis) change over time. [&hellip;]<\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-486","post","type-post","status-publish","format-standard","hentry","category-community-college-research"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/comments?post=486"}],"version-history":[{"count":0,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/486\/revisions"}],"wp:attachment":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/media?parent=486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/categories?post=486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/tags?post=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}