{"id":5332,"date":"2017-03-17T16:34:12","date_gmt":"2017-03-17T23:34:12","guid":{"rendered":"https:\/\/nnlm.gov\/evaluation\/blog\/?p=5332"},"modified":"2019-09-24T10:13:28","modified_gmt":"2019-09-24T17:13:28","slug":"uninspired-by-bars-try-dot-plots","status":"publish","type":"post","link":"https:\/\/news.nnlm.gov\/nec\/2017\/03\/17\/uninspired-by-bars-try-dot-plots\/","title":{"rendered":"Uninspired by Bars? Try Dot Plots"},"content":{"rendered":"<p><em>Thanks to Jessi Van Der Volgen and Molly Knapp at the NNLM Training Office for allowing us to feature their assessment project and for providing the images in this post.\u00a0<\/em><\/p>\n<p>Are you\u00a0<em>tired\u00a0<\/em>of bars?<\/p>\n<p>I don\u2019t mean the kind of bars where you celebrate and socialize. I mean the kind used in <a href=\"https:\/\/news.nnlm.gov\/neo\/wp-content\/uploads\/sites\/3\/2017\/05\/Slide12.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-5313\" src=\"https:\/\/news.nnlm.gov\/neo\/wp-content\/uploads\/sites\/3\/2017\/05\/Slide12.jpeg\" alt=\"Sliding scale question asking participant about her desired and current proficiency for conducting literature searches\" width=\"634\" height=\"330\" align=\"right\" hspace=\"10\" \/><\/a>data visualization. \u00a0My evidence-free theory is that people still succumb to using the justifiably maligned pie chart simply because we cannot face one more bar graph.<\/p>\n<p>Take heart, readers. Today, I\u2019m here to tell you a story about some magic data that fell on the NEO\u2019s doorstep and broke us free of our bar chart rut.<\/p>\n<p>It all began with a project by our NNLM Training Office (NTO) colleagues, the intrepid leaders of NNLM\u2019s instructional design and delivery. They do it all. They teach. They administratively support the regions\u2019 training efforts. They initiate opportunities and resources to up-level instructional effectiveness throughout the network. One of their recent initiatives was a national needs assessment of NNLM training participants. That was the source of the fabulous data I write about today.<\/p>\n<p>For context, I should mention that training is one of NNLM\u2019s key strategies for reaching the furthest corners of our country to raise awareness, accessibility and use of NLM health information resources. NNLM offers classes to all types of direct users, (e.g., health professionals; community-based organization staffs) but we value the efficiency of our \u201ctrain-the-trainer\u201d programs. In these classes, librarians and others learn how to use NLM resources so they, in turn, can teach\u00a0<em>their<\/em>\u00a0users. The national needs assessment was geared primarily toward understanding how to best serve \u201ctrain-the-trainer\u201d participants, who often takes multiple classes to enhance their skills.<\/p>\n<p>For the NTO\u2019s needs assessment, one area of inquiry involved an inventory of learners\u2019 need for training in 30 topic areas. The NTO wanted to assess participants\u2019 desired level\u00a0<em>and\u00a0<\/em>their current level of proficiency in each topic.\u00a0 That meant 60 questions. That was one heck-of-a-long survey. We wished them luck.<\/p>\n<p>The NTO team was undaunted!\u00a0 They did some research and found a desirable format for presenting this set of questions (see upper left). The format had a nice minimalist design. The sliders were more fun for participants than radio buttons. Also, NTO designed the online questionnaire so that only a handful of question-pairs appeared on the screen at one time.\u00a0 The approach worked, because NTO received responses from 559 respondents,\u00a0<em>and 472 completed the whole questionnaire.<\/em><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/news.nnlm.gov\/neo\/wp-content\/uploads\/sites\/3\/2017\/05\/dot-plot-2-1.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5314\" src=\"https:\/\/news.nnlm.gov\/neo\/wp-content\/uploads\/sites\/3\/2017\/05\/dot-plot-2-1.jpeg\" alt=\"Dot plots for four skill topic areas. Conducting literature searches (4=Current; 5=Desired) Understanding and searching for evidence-based research ( Current-3; Desired=5) Develop\/teach classes (Current-3; Desired=5; Create videos\/web tutorials Current-2; Desired=4)\" width=\"578\" height=\"422\" align=\"left\" hspace=\"10\" \/><\/a><\/p>\n<p>The NEO, in turn, consulted the writings of one of our favorite dataviz oracles, Stephanie Evergreen. And she did not disappoint.\u00a0 We found the ideal solution: dot plots! \u00a0Evergreen\u2019s easy-to-follow instructions from this\u00a0<a href=\"http:\/\/stephanieevergreen.com\/easy-dot-plots-in-excel\/\">blog post<\/a>\u00a0allowed us to create dot plots in Excel, using a few creative hacks. This approach allowed us to thematically cluster results from numerous related questions into one chart. We were able to present data for 60 questions in a total of seven charts.<\/p>\n<p>I would like to point out a couple of design choices I made:<\/p>\n<ul>\n<li>I used different shapes and colors to visually distinguish between \u201ccurrent proficiency\u201d and \u201cdesired proficiency.\u201d Navy blue for\u00a0<em>current proficiency\u00a0<\/em>was inspired from NNLM\u2019s logo. I used a complimentary green for the\u00a0<em>desired proficiency<\/em>\u00a0because green means \u201cgo.\u201d<\/li>\n<li>Evergreen prefers to place labels (e.g., \u201cconducting literature searches\u201d) close to the actual dots. That works well if your labels consist of one or two words. We found that our labels had to be longer to make sense. Setting them flush-left made them more readable.<\/li>\n<li>I suggested plotting medians rather than means because many of the data distributions were skewed. You can use means, but probably should round to whole numbers so you don\u2019t distract from the gaps.<\/li>\n<\/ul>\n<p>Dot plots are quite versatile. We used the format to\u00a0highlight gaps in proficiency, but other evaluators have demonstrated that dot plots work well for visualizing <a href=\"http:\/\/stephanieevergreen.com\/easy-dot-plots-in-excel\/\">change over time<\/a>\u00a0and\u00a0<a href=\"http:\/\/www.pewsocialtrends.org\/2015\/12\/17\/parenting-in-america\/st_2015-12-17_parenting-02\/\">cross-group comparisons<\/a>.<\/p>\n<p>Dot plots are not as easy to create as the default Excel bar chart, but they are interesting. \u00a0So give up bars for a while. \u00a0Try plotting!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Thanks to Jessi Van Der Volgen and Molly Knapp at the NNLM Training Office for allowing us to feature their assessment project and for providing the images in this post.\u00a0 Are you\u00a0tired\u00a0of bars? I don\u2019t mean the kind of bars where you celebrate and socialize. I mean the kind used in data visualization. \u00a0My evidence-free&#8230; <a href=\"https:\/\/news.nnlm.gov\/nec\/2017\/03\/17\/uninspired-by-bars-try-dot-plots\/\">Read More &raquo;<\/a><\/p>\n","protected":false},"author":2959,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[],"class_list":["post-5332","post","type-post","status-publish","format-standard","hentry","category-data-visualization"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p8ICUo-1o0","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/5332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/users\/2959"}],"replies":[{"embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/comments?post=5332"}],"version-history":[{"count":4,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/5332\/revisions"}],"predecessor-version":[{"id":6449,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/5332\/revisions\/6449"}],"wp:attachment":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/media?parent=5332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/categories?post=5332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/tags?post=5332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}