{"id":23391,"date":"2021-04-21T20:51:50","date_gmt":"2021-04-22T00:51:50","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=23391"},"modified":"2021-04-21T20:51:53","modified_gmt":"2021-04-22T00:51:53","slug":"birds-eye-view-into-californias-public-schools-in-2019-20","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/birds-eye-view-into-californias-public-schools-in-2019-20\/","title":{"rendered":"Bird&#8217;s Eye view into California&#8217;s public schools in 2019-20"},"content":{"rendered":"\n<h2 class=\"has-text-align-left wp-block-heading\">INTRODUCTION<\/h2>\n\n\n\n<p>By some, education is considered <a href=\"https:\/\/www.globalpartnership.org\/results\/education-data-highlights\">a doorway to success<\/a> in life, such as it allows upward mobility to one\u2019s socioeconomic status, more opportunities in one\u2019s life, and a higher chance of one being healthier. However education in the United States is a multifaceted subject, in which multiple factors related to location and regional demographics impact the value of the education received by an individual.\u00a0<\/p>\n\n\n\n<p><br>Focusing on the United States, education is <a href=\"https:\/\/wenr.wes.org\/2018\/06\/education-in-the-united-states-of-america\">largely managed on a state level<\/a> with each state having their own way of managing and measuring the success of their education system. <a href=\"https:\/\/www.usnews.com\/news\/best-states\/california\">California is the most populous state<\/a>, but most importantly shares similar physical and qualitative characteristics as New York, especially in the area of education. This report will explore the various demographics captured by California in regards to its education system and visually outline what these factors look like from a geographic standpoint through Carto. It will also highlight insights related to questions about schooling options per county, funding structures available to schools, and much more.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">INSPIRATION<\/h2>\n\n\n\n<p>There have been countless articles written on the state of education in the United States and within each state, but the primary inspiration for this visualization stems from Julie Mehertu\u2019s artwork. <a href=\"https:\/\/whitney.org\/exhibitions\/julie-mehretu\">Julie Mehertu<\/a> is an Ethiopian painter whose art explores the lived experience and forces that impact it (i.e. migration, capitalism, climate change) through abstraction and architecture.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"video-wrapper\"><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/gaMM7g0uMcE?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/div>\n<\/div><figcaption>Interview with Julie Mehertu, Whitney Museum of Art<\/figcaption><\/figure>\n\n\n\n<p>Currently the Whitney Museum of Art is showcasing her 20-year career through the Julie Mehertu exhibition. From her work\u2019s oeuvre, her pieces from the late 1990s and early 2000s used cartographic designs and tools to discuss the topics of migration (<em>Migration Direction Map<\/em>, 1996) and climate change (<em>Black City<\/em>, 2007). Visually these pieces utilize the clean, fine lines typically associated with architecture design and vibrant bursts of color that insert an intentional chaos to each piece.<\/p>\n\n\n\n<div class=\"wp-block-jetpack-tiled-gallery aligncenter is-style-rectangular\"><div class=\"tiled-gallery__gallery\"><div class=\"tiled-gallery__row\"><div class=\"tiled-gallery__col\" style=\"flex-basis:53.01708%\"><figure class=\"tiled-gallery__item\"><img decoding=\"async\" srcset=\"https:\/\/i2.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/images-5.jpg?strip=info&#038;w=274&#038;ssl=1 274w\" alt=\"\" data-height=\"184\" data-id=\"23392\" data-link=\"https:\/\/studentwork.prattsi.org\/infovis\/?attachment_id=23392\" data-url=\"https:\/\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/images-5.jpg\" data-width=\"274\" src=\"https:\/\/i2.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/images-5.jpg?ssl=1\" data-amp-layout=\"responsive\" \/><\/figure><\/div><div class=\"tiled-gallery__col\" style=\"flex-basis:46.98292%\"><figure class=\"tiled-gallery__item\"><img decoding=\"async\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/960x0.jpg?strip=info&#038;w=600&#038;ssl=1 600w,https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/960x0.jpg?strip=info&#038;w=900&#038;ssl=1 900w,https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/960x0.jpg?strip=info&#038;w=959&#038;ssl=1 959w\" alt=\"\" data-height=\"727\" data-id=\"23393\" data-link=\"https:\/\/studentwork.prattsi.org\/infovis\/?attachment_id=23393\" data-url=\"https:\/\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/960x0.jpg\" data-width=\"959\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/960x0.jpg?ssl=1\" data-amp-layout=\"responsive\" \/><\/figure><\/div><\/div><\/div><\/div>\n\n\n\n<p>With my design, I wanted to precisely structure my data similar to Mehertu\u2019s architectural background, in order for the audience to understand what behaviors or information that my data carries. Then I wanted to use vibrant colors to highlight data points, based on location, and group information together seamlessly in a visual manner.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MATERIALS<\/h2>\n\n\n\n<p><a href=\"https:\/\/carto.com\/\">Carto<\/a>: This tool is a full-stack geospatial platform that visualizes location data from either its own dataset collection or a new dataset uploaded by the user. This technology was used to create my draft and final visualizations, from structuring the dataset\u2019s design format to stylizing the final design through color, borders, and label functionalities.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.18.43-PM-1024x590.png?resize=840%2C484&#038;ssl=1\" alt=\"\" class=\"wp-image-23394\" width=\"840\" height=\"484\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.18.43-PM.png?resize=1024%2C590&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.18.43-PM.png?resize=300%2C173&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.18.43-PM.png?resize=768%2C442&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.18.43-PM.png?resize=800%2C461&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.18.43-PM.png?resize=313%2C180&amp;ssl=1 313w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.18.43-PM.png?w=1073&amp;ssl=1 1073w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Entrance to the Carto website<\/figcaption><\/figure><\/div>\n\n\n\n<p><a href=\"https:\/\/hub.arcgis.com\/datasets\/CDEGIS::california-schools-2019-20?geometry=-145.664%2C31.022%2C-92.535%2C43.235\">California Schools 2019 &#8211; 20<\/a>: This public dataset showcases all the data points related to California\u2019s public schools between the year of 2019 to 2020. The data points highlight the schools\u2019 data about physical location (latitude and longitude), funding, district, county, and much more. For this report, the location data was the primary determinant of the cartograph and then the other data points painted the picture of each school\u2019s overall state in that year.\u00a0<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">PROCESS<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li><em><strong>Find a multifaceted dataset.<\/strong><\/em> In order to create a visualization on Carto, the dataset needs to have spatial data and\/or datapoints, such as the latitude and longitude of each value, in order to map out the geographical location properly. Then other additional data points need to be included or uploaded as well.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"499\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.21.37-PM-1024x608.png?resize=840%2C499&#038;ssl=1\" alt=\"\" class=\"wp-image-23395\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.21.37-PM.png?resize=1024%2C608&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.21.37-PM.png?resize=300%2C178&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.21.37-PM.png?resize=768%2C456&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.21.37-PM.png?resize=800%2C475&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.21.37-PM.png?resize=303%2C180&amp;ssl=1 303w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.21.37-PM.png?w=1259&amp;ssl=1 1259w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Overview of chosen dataset&#8217;s spreadsheet<\/figcaption><\/figure>\n\n\n\n<p> <strong>2. <em>Navigate the data\u2019s coding system.<\/em><\/strong> This public dataset had relatively straightforward labels, but there were a few values that required reviewing in the data\u2019s codebook in order to determine whether its value and whether the data should be highlighted in the visualization.<\/p>\n\n\n\n<p><strong> 3. <em>Design the data story and structure layers based on this focus.<\/em><\/strong> This visualization was interested in exploring Carto as a tool to answer the above questions about the state of education in California from 2019 to 2020. Number of schools per county, funding per school, and aggregation based on school count were important data points that I thought the audience would want filtered out as an overview into the schools\u2019 educational measurements. I either filtered these data points by creating a layer or adding a widget to view the trends on a microscale.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"514\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.24.15-PM-1024x626.png?resize=840%2C514&#038;ssl=1\" alt=\"\" class=\"wp-image-23396\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.24.15-PM.png?resize=1024%2C626&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.24.15-PM.png?resize=300%2C183&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.24.15-PM.png?resize=768%2C470&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.24.15-PM.png?resize=800%2C489&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.24.15-PM.png?resize=294%2C180&amp;ssl=1 294w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.24.15-PM.png?w=1205&amp;ssl=1 1205w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Workspace for creating widgets<\/figcaption><\/figure>\n\n\n\n<p> <strong>4. <em>Determine the best visual design to emphasize the story\u2019s narrative.<\/em><\/strong> Once the crucial data points were identified and filtered, I wanted to mimic the visual aesthetics of Mehertu\u2019s pieces. Each layer has bursts of color and different geometric shapes to create an intentional chaos and separation between the data points. Then I built supplemental materials for the audience to zoom in on each school or overall data point, such as a legend, widget, and zoom-through-scroll functionality.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"649\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.26.12-PM.png?resize=698%2C649&#038;ssl=1\" alt=\"\" class=\"wp-image-23397\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.26.12-PM.png?w=698&amp;ssl=1 698w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.26.12-PM.png?resize=300%2C279&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.26.12-PM.png?resize=194%2C180&amp;ssl=1 194w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><figcaption>Zoomed-In View of the Map&#8217;s Visuals<\/figcaption><\/figure><\/div>\n\n\n\n<p><strong> 5. <em>Publish design publicly.<\/em><\/strong> Once I felt the visualization was in a comfortable and final state, I wanted to share it with others and the public through Carto. I decided to share my cartograph as an embedded image so the audience can interact with Carto\u2019s functionalities.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">RESULTS<\/h2>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-rich is-provider-cartodb wp-block-embed-cartodb\"><div class=\"wp-block-embed__wrapper\">\n<iframe width='100%' height='520px' frameborder='0' src='https:\/\/ctenny.carto.com\/viz\/c3d16992-9b97-40e0-83b5-f14fb54d47b4\/embed_map' allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen><\/iframe>\n<\/div><figcaption>Version #1: Final Design from Carto<\/figcaption><\/figure>\n\n\n\n<p>After my peer review, I decided to have two final visualizations related to this dataset and its narrative. The first visualization (above) was my initial attempt at utilizing color and the aggregation functionality to highlight the varying volumes of the number of schools in an area. However it was insightfully noted that school types with the highest volumes were overwhelming the visual oeuvre of the map and the colorful separation between school types could only be seen if the audience zoomed in.&nbsp;&nbsp;<\/p>\n\n\n\n<p>With that said, I took my reviewer\u2019s advice in the second version and experimented with the blending options for the Aggregation layer as well as choose more contrasting colors between the two layers. Ultimately I decided to use the multiple option for the aggregation layer and this provided a heat map effect to the state from a bird\u2019s eye view. But if the user zooms into the map, you will notice that the aggregation layer is a gradient blend of magenta and the schools\u2019 locations are color-coded in color tones of blues and greens. Once zoomed in, the map looks like a colorful kaleidoscope and\/or terrain for the user to engage with.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-cartodb wp-block-embed-cartodb\"><div class=\"wp-block-embed__wrapper\">\n<iframe width='100%' height='520px' frameborder='0' src='https:\/\/ctenny.carto.com\/viz\/c3d16992-9b97-40e0-83b5-f14fb54d47b4\/embed_map' allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen><\/iframe>\n<\/div><figcaption>Second Version: Different Color Scheme and Shapes<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">REFLECTION<\/h2>\n\n\n\n<p>As a first-time user of this visualization tool, the visualization was a pleasure to create and easy to design with this dataset. The available functionalities were user-friendly and easy to incorporate for the final design and illuminate the dataset\u2019s insights. While I had no issues with the tool\u2019s design capabilities, I would be curious to integrate other public datasets from California in the same year to further investigate other demographical relationships between the public schools dataset and other factors, such as taxpayer funding per county or school district. This additional information would add another layer of oversight into California\u2019s educational system and what other factors should be considered when determining the value of education on a macro and micro level.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>INTRODUCTION By some, education is considered a doorway to success in life, such as it allows upward mobility to one\u2019s socioeconomic status, more opportunities in one\u2019s life, and a higher chance of one being healthier. However education in the United States is a multifaceted subject, in which multiple factors related to location and regional demographics&hellip;<\/p>\n","protected":false},"author":2021,"featured_media":23397,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[1078],"class_list":["post-23391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/04\/Screen-Shot-2021-04-21-at-5.26.12-PM.png?fit=698%2C649&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-65h","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/23391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/2021"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=23391"}],"version-history":[{"count":4,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/23391\/revisions"}],"predecessor-version":[{"id":23427,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/23391\/revisions\/23427"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/23397"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=23391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=23391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=23391"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=23391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}