{"id":20,"date":"2014-10-03T20:20:11","date_gmt":"2014-10-03T20:20:11","guid":{"rendered":"https:\/\/mrmclaughlin.com\/web\/?p=20"},"modified":"2022-11-21T21:03:44","modified_gmt":"2022-11-21T21:03:44","slug":"socrative-data-mining-using-google-sheets-10-3-2014","status":"publish","type":"post","link":"https:\/\/www.mrmclaughlin.com\/blog\/2014\/10\/03\/socrative-data-mining-using-google-sheets-10-3-2014\/","title":{"rendered":"Socrative Data Mining using Google Sheets 10\/3\/2014"},"content":{"rendered":"<p>I thought this might be a useful bit of information to post. \u00a0As part of my effective educator evaluation process in Pennsylvania I created a spreadsheet to data mine Socrative Quick Questions. \u00a0When you create a socrative quick question and finish it you are given the option of downloading an Excel sheet or saving it to google . \u00a0I wanted a way of collating multiple questions into one sheet. \u00a0I wrote a script in \u00a0Google sheets and created a Data mining spreadsheet. \u00a0Here is the\u00a0<a href=\"https:\/\/web.archive.org\/web\/20211023120354\/https:\/\/docs.google.com\/spreadsheets\/d\/1fy7h965fJzeiUoANBtkTii_RVluHgDIE3eUfY6PKsTM\/edit?usp=sharing\">link<\/a>. \u00a0Feel free to work from what I have to make it suitable for you. \u00a0Right now it only work on the free response quick question.<\/p>\n<p>&nbsp;<\/p>\n<p>Instructions:<\/p>\n<p>1) upload several quick questions to a folder in Google drive. (make sure you select that you want them converted to Google sheets)<\/p>\n<p>2) Open the SocrativeDataMine spreadsheet. (You NEEED to\u00a0save a local copy from the share link)<\/p>\n<p>3) Choose Data Mine from the Socrative Drop Down (the first time this runs you will need to approve the script)<\/p>\n<p>4) enter the name of the folder you stored the sheets in. (If you type in a folder that does not have the data or that you did not create it will probably crash and might mess up the SocrativeDataMine sheet. \u00a0If that happens just make another copy ..maybe even have your own backup copy just in case I disappear on Google.)<\/p>\n<p>5) Let the script run\u2026you will see some data appear on your spreadsheet. \u00a0The script also creates a new spreadsheet in your drive with all the collated data so feel free to run this again as it will create a new file each time.<\/p>\n<p>Hope this is useful please post any updates you make to this script on your own.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I thought this might be a useful bit of information to post. \u00a0As part of my effective educator evaluation process in Pennsylvania I created a spreadsheet to data mine Socrative Quick Questions. \u00a0When you create a socrative quick question and finish it you are given the option of downloading an Excel sheet or saving it [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-20","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/posts\/20","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/comments?post=20"}],"version-history":[{"count":1,"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/posts\/20\/revisions"}],"predecessor-version":[{"id":21,"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/posts\/20\/revisions\/21"}],"wp:attachment":[{"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/media?parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/categories?post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrmclaughlin.com\/blog\/wp-json\/wp\/v2\/tags?post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}