{"id":11104,"date":"2016-11-22T11:22:09","date_gmt":"2016-11-22T15:22:09","guid":{"rendered":"http:\/\/tiie.w3.uvm.edu\/blog?p=11104&#038;preview=true&#038;preview_id=11104"},"modified":"2016-11-22T11:22:09","modified_gmt":"2016-11-22T15:22:09","slug":"use-google-forms-to-streamline-your-workflow","status":"publish","type":"post","link":"https:\/\/tiie.w3.uvm.edu\/blog\/use-google-forms-to-streamline-your-workflow\/","title":{"rendered":"3 ways to use Google Forms to streamline your workflow"},"content":{"rendered":"<h1>For exit tickets, student support &amp; action research<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-11235\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/techrescue.jpg\" alt=\"use Google Forms to streamline your workflow\" width=\"150\" height=\"151\" \/>Using Google Forms and Google\u00a0 Sheets together can streamline your process and make all your tasks feel just a little more manageable.<\/p>\n<p>As an educator, it can be a bit overwhelming trying to keep all your different data streams organized, not to mention the finding the time to analyze and interpret that data! Let&#8217;s take three examples of how Google Forms can cut down on your paperwork flurries.<\/p>\n<p><!--more--><\/p>\n<h2>How schools are using Google Forms to streamline workflow<\/h2>\n<h3>1. Exit tickets &amp; feedback forms<\/h3>\n<p>The past few summers, at the <a href=\"https:\/\/tiie.w3.uvm.edu\/blog\/2016-middle-grades-institute\/\">Middle Grades Institute<\/a>, we&#8217;ve used a Google Form exit ticket to quickly understand how participants are doing at the end of each day and quickly assess their needs for the next day. The responses are really easy to share with other facilitators or participants!<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/1rz6d_kuCr7lZl5t33YugupQqUIv2hv6QFz2v5a7m5tc\/viewform?edit_requested=true\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-11192\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/Screen-Shot-2016-11-18-at-8.58.39-AM-300x158.png\" alt=\"screen-shot-2016-11-18-at-8-58-39-am\" width=\"750\" height=\"396\" srcset=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/Screen-Shot-2016-11-18-at-8.58.39-AM-300x158.png 300w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/Screen-Shot-2016-11-18-at-8.58.39-AM-768x405.png 768w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/Screen-Shot-2016-11-18-at-8.58.39-AM.png 1024w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/Screen-Shot-2016-11-18-at-8.58.39-AM-619x326.png 619w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11195 size-full\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms.jpg\" alt=\"mgi_2016_team_d_exit_day_1_-_google_forms\" width=\"770\" height=\"690\" srcset=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms.jpg 770w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms-300x269.jpg 300w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms-768x688.jpg 768w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms-619x555.jpg 619w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The beauty of this tool is we can look at a summary of responses or by individual, if you require a name.<\/p>\n<p><a href=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11196 size-full\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms.png\" alt=\"mgi_2016_team_d_exit_day_1_-_google_forms\" width=\"764\" height=\"195\" srcset=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms.png 764w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms-300x77.png 300w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/MGI_2016_Team_D_Exit_day_1_-_Google_Forms-619x158.png 619w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><\/p>\n<p>Along these same lines, it&#8217;s conference season around here and it seems to becoming a common practice to survey parents, students, and teachers after the conference. Here, is an example from Crossett Brook Middle School:<\/p>\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSfOB7GnMyFk4sK80AZYlwkbC0snWisHtXZ7mn75u69P3qM2CA\/viewform\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11207 size-full\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/crossett.png\" alt=\"crossett\" width=\"781\" height=\"593\" srcset=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/crossett.png 781w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/crossett-300x228.png 300w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/crossett-768x583.png 768w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/crossett-619x470.png 619w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This information can be so valuable for understanding someone&#8217;s experiences as well as working towards improving the next round of conferences. To me, it also helps everyone feel like valued partners in this journey.<\/p>\n<p>&nbsp;<\/p>\n<h3>2. Student support teams<\/h3>\n<p>In every school there are students who need some additional level of support to be successful. One of the best ways to support these students is for everyone in their circle to be on the same page. This involves a lot of input from various sources and can be difficult to coordinate and organize.<\/p>\n<p>Recently, Kate Grodin and her team at Winooski Middle School have started to implement this data collection process through Google forms. They used the <a href=\"https:\/\/www.youtube.com\/watch?v=knlHjsMr9Qc\">conditional formatting<\/a> feature to direct people to the appropriate section of the form.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/formatting.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11205 size-full\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/formatting.jpg\" alt=\"formatting\" width=\"761\" height=\"291\" srcset=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/formatting.jpg 761w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/formatting-300x115.jpg 300w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/formatting-619x237.jpg 619w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><\/p>\n<p style=\"text-align: left;\"><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSdr01AVN9GcJit9a9Tu_Ho-sfNgMkqsRDUNjSS0A75xA1jFKA\/viewform\">Link<\/a> to the full Google Form<\/p>\n<p>One form can be used for the initial data collection as well as subsequent collections that measure the success of different interventions. Multiple teachers can input data and easily report out.<\/p>\n<h3>3. Action Research<\/h3>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1wwbLdujC21LNh00T8FwygFvgep7sL6EJzig7MgSUx94\/edit#\">Action research<\/a> has been a consistent vehicle for educators to engage in meaningful inquiry about a problem or question. We encourage all participants at the <a href=\"https:\/\/sites.google.com\/site\/mgcsummerinstitute2016\/\">Middle Grades Institute<\/a> to complete an action research project. Data collection is paramount in this process and, again, we have found Google Forms to help tremendously in this process.<\/p>\n<p>Whether your data is qualitative or quantitative Forms has a way to collect and organize your information.<\/p>\n<p>This data-driven action research project undertaken by educators at Mill River Union High School shows just how powerful Google Forms can be for research data. The educators sought to answer the question: &#8220;How does professional development affect technology integration?&#8221;<\/p>\n<div class=\"epyt-video-wrapper\">\n<div  style=\"display: block; margin: 0px auto;\"  id=\"_ytid_34108\"  width=\"525\" height=\"295\"  data-origwidth=\"525\" data-origheight=\"295\" data-facadesrc=\"https:\/\/www.youtube.com\/embed\/Z7guE1t9jeU?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=1&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;modestbranding=1&#038;rel=0&#038;fs=1&#038;playsinline=1&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;\" class=\"__youtube_prefs__ epyt-facade epyt-is-override  no-lazyload\" data-epautoplay=\"1\" ><img decoding=\"async\" data-spai-excluded=\"true\" class=\"epyt-facade-poster skip-lazy\" loading=\"lazy\"  alt=\"How does PD affect technology integration?\"  src=\"https:\/\/i.ytimg.com\/vi\/Z7guE1t9jeU\/maxresdefault.jpg\"  \/><button class=\"epyt-facade-play\" aria-label=\"Play\"><svg data-no-lazy=\"1\" height=\"100%\" version=\"1.1\" viewBox=\"0 0 68 48\" width=\"100%\"><path class=\"ytp-large-play-button-bg\" d=\"M66.52,7.74c-0.78-2.93-2.49-5.41-5.42-6.19C55.79,.13,34,0,34,0S12.21,.13,6.9,1.55 C3.97,2.33,2.27,4.81,1.48,7.74C0.06,13.05,0,24,0,24s0.06,10.95,1.48,16.26c0.78,2.93,2.49,5.41,5.42,6.19 C12.21,47.87,34,48,34,48s21.79-0.13,27.1-1.55c2.93-0.78,4.64-3.26,5.42-6.19C67.94,34.95,68,24,68,24S67.94,13.05,66.52,7.74z\" fill=\"#f00\"><\/path><path d=\"M 45,24 27,14 27,34\" fill=\"#fff\"><\/path><\/svg><\/button><\/div>\n<\/div>\n<p>They used Google Forms to collect both quantitative:<\/p>\n<p><a href=\"https:\/\/tiie.w3.uvm.edu\/blog\/how-does-professional-development-affect-technology-integration\/#.WDRemJI7qUA\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11238\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/qualitative2.jpg\" alt=\"using Google Forms to streamline your workflow\" width=\"619\" height=\"328\" srcset=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/qualitative2.jpg 619w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/qualitative2-300x159.jpg 300w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><\/a><\/p>\n<p>and qualitative data:<\/p>\n<p><a href=\"https:\/\/tiie.w3.uvm.edu\/blog\/how-does-professional-development-affect-technology-integration\/#.WDRemJI7qUA\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11239\" src=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/quantitative.jpg\" alt=\"using Google Forms to streamline your workflow\" width=\"619\" height=\"409\" srcset=\"https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/quantitative.jpg 619w, https:\/\/tiie.w3.uvm.edu\/blog\/wp-content\/uploads\/2016\/11\/quantitative-300x198.jpg 300w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><\/a><\/p>\n<p>to measure changes they made to their teaching practice.<\/p>\n<p>&nbsp;<\/p>\n<h2>Where else could you see Google Forms simplifying your school&#8217;s workflow?<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>For exit tickets, student support &amp; action research Using Google Forms and Google\u00a0 Sheets together can streamline your process and make all your tasks feel just a little more manageable. As an educator, it can be a bit overwhelming trying to keep all your different data streams organized, not to mention the finding the time &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/tiie.w3.uvm.edu\/blog\/use-google-forms-to-streamline-your-workflow\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;3 ways to use Google Forms to streamline your workflow&#8221;<\/span><\/a><\/p>\n","protected":false},"author":31,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[251,304,178],"class_list":["post-11104","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-crossett-brook-middle-school","tag-google-forms","tag-winooski-middle-school"],"_links":{"self":[{"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/posts\/11104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/users\/31"}],"replies":[{"embeddable":true,"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/comments?post=11104"}],"version-history":[{"count":0,"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/posts\/11104\/revisions"}],"wp:attachment":[{"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/media?parent=11104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/categories?post=11104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tiie.w3.uvm.edu\/blog\/wp-json\/wp\/v2\/tags?post=11104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}