{"id":90,"date":"2018-10-19T20:59:48","date_gmt":"2018-10-19T20:59:48","guid":{"rendered":"https:\/\/cohort21.com\/lesliefarooq\/?p=90"},"modified":"2018-10-19T21:00:52","modified_gmt":"2018-10-19T21:00:52","slug":"on-the-back-end-of-a-google-form","status":"publish","type":"post","link":"https:\/\/cohort21.com\/lesliefarooq\/2018\/10\/19\/on-the-back-end-of-a-google-form\/","title":{"rendered":"On the back end of a Google Form."},"content":{"rendered":"<figure id=\"attachment_92\" aria-describedby=\"caption-attachment-92\" style=\"width: 238px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/cohort21.com\/lesliefarooq\/files\/2018\/10\/Screen-Shot-2018-10-19-at-4.57.26-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-92\" src=\"https:\/\/cohort21.com\/lesliefarooq\/files\/2018\/10\/Screen-Shot-2018-10-19-at-4.57.26-PM-300x279.png\" alt=\"\" width=\"238\" height=\"221\" srcset=\"https:\/\/cohort21.com\/lesliefarooq\/files\/2018\/10\/Screen-Shot-2018-10-19-at-4.57.26-PM-300x279.png 300w, https:\/\/cohort21.com\/lesliefarooq\/files\/2018\/10\/Screen-Shot-2018-10-19-at-4.57.26-PM-768x715.png 768w, https:\/\/cohort21.com\/lesliefarooq\/files\/2018\/10\/Screen-Shot-2018-10-19-at-4.57.26-PM-1024x954.png 1024w, https:\/\/cohort21.com\/lesliefarooq\/files\/2018\/10\/Screen-Shot-2018-10-19-at-4.57.26-PM.png 1254w\" sizes=\"auto, (min-width: 960px) 75vw, 100vw\" \/><\/a><figcaption id=\"caption-attachment-92\" class=\"wp-caption-text\">Jon Snow and Arya Stark, October 2018<\/figcaption><\/figure>\n<p>Google Apps for Education, or <a href=\"https:\/\/twitter.com\/hashtag\/gafe?f=tweets&amp;vertical=default&amp;lang=en\">#GAFE<\/a> as they are known on Twitter, include very powerful tools to help educators help themselves get faster at algorithmic tasks. This frees us up to spend more time focusing on heuristic tasks, the ones that require adaptive, responsive decision making in the face of ever changing conditions. At least that&#8217;s my take on why we would leverage technology at the substitution end of the <a href=\"https:\/\/www.schoology.com\/blog\/samr-model-practical-guide-edtech-integration\">SAMR model<\/a>\u00a0even though it has been extensively frowned upon.<\/p>\n<p>Perhaps you have asked every student in your school to complete a Google Form about their preferred choice for a specialty club or to collect all of their &#8220;How might we&#8230;&#8221; questions into one convenient alphabetically sorted location. Now you have all their data, or do you? Staring down the &#8216;Email Address&#8217; column of the resulting Google Sheet, you wonder if you should apply a filter and alphanumerically sort a live Google Sheet. What if an absent student fills in the form at a later date? Will it record properly if you manipulate that sheet before every student has completed it?<\/p>\n<p>You could cross reference the Google Sheet upon which the Google Form is feeding with an alphabetically sorted paper list of student names or you could even go split-screen and do the very same by comparing the window containing the Google Sheet to the window containing the student list. I&#8217;ve done this so many times that I know it&#8217;s a thing that teachers do; comparing lists of names is a common occurrence in schools. What a waste of time though!<\/p>\n<p>If you&#8217;ve ever wondered how to make life easier but didn&#8217;t know who to ask, I&#8217;ve got you. Here you will find a <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1uKGtx0mkSIMnFEzXCJlk60tOZ9rUh313rHncC0bHlO8\/edit?usp=sharing\">Google Sheet<\/a> featuring the feigned Google Form input from all the cats I&#8217;ve known and a second tab with the quick magic you need to know who is missing so you can target them directly.<\/p>\n<p>Things you will need:<\/p>\n<ul>\n<li>a Google Form that automatically collects student email addresses and a linked Google Sheet<\/li>\n<li>a second Google Sheet tab with an alphabetically sorted list of student names and their email addresses<\/li>\n<li>a command, for example:\u00a0<span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">countif<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">&#8216;Form Feed&#8217;!B:B<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">B2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/li>\n<\/ul>\n<p>What this command means:<\/p>\n<p>Count if (&#8216;range I have indicated&#8217;,specific cell). The spreadsheet code above indicates that I have asked a specific cell (C2 on the linked Google Sheet) to look in the entirety of the B column on the first tab to find the thing present in the B2 cell on the active tab. My B2 cell says\u00a0<span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;vinniecollins@notreallyanemailaddress.com&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">vinniecollins@notreallyanemailaddress.com and it turns out that Vinnie Collins has completed this Google Form once. What a good cat!<\/span><\/p>\n<p>What stands out in data such as this are the starting points for conversations with students who haven&#8217;t done what was requested of them at that time. For example, both Oates cats did not complete the survey as evidenced by their zero counts. Perhaps they were absent? In addition, Princess Rand and Jon Snow have completed the survey twice. Perhaps they changed their mind about their original answer and resubmitted? Finally, Vito Collins has completed the survey three times. He might need some help with how to complete a Google Form or maybe he is just excited. This data lets you quickly know where to being having heuristic conversations with the students in your charge.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Apps for Education, or #GAFE as they are known on Twitter, include very powerful tools to help educators help themselves get faster at algorithmic tasks. This frees us up to spend more time focusing on heuristic tasks, the ones that require adaptive, responsive decision making in the face of ever changing conditions. At least &hellip; <a href=\"https:\/\/cohort21.com\/lesliefarooq\/2018\/10\/19\/on-the-back-end-of-a-google-form\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;On the back end of a Google Form.&#8221;<\/span><\/a><\/p>\n","protected":false},"author":257,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":0,"footnotes":""},"categories":[10,11],"tags":[12,16,17,14,15,13],"class_list":["post-90","post","type-post","status-publish","format-standard","hentry","category-resources","category-technology","tag-edtech","tag-google-forms","tag-google-sheets","tag-how-to","tag-student-lists","tag-tools"],"_links":{"self":[{"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/posts\/90","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/users\/257"}],"replies":[{"embeddable":true,"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":2,"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/posts\/90\/revisions"}],"predecessor-version":[{"id":94,"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/posts\/90\/revisions\/94"}],"wp:attachment":[{"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/media?parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/categories?post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cohort21.com\/lesliefarooq\/wp-json\/wp\/v2\/tags?post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}