{"id":7,"date":"2013-10-16T09:46:35","date_gmt":"2013-10-16T16:46:35","guid":{"rendered":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/?page_id=7"},"modified":"2013-11-02T11:32:19","modified_gmt":"2013-11-02T18:32:19","slug":"diy-analytics","status":"publish","type":"page","link":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/diy-analytics\/","title":{"rendered":"DIY Analytics"},"content":{"rendered":"<p><b>Welcome to Do It Yourself Learning Analytics<\/b><\/p>\n<p>In this section we will be taking you on a journey to explore how one can run a simple analysis on ones own classrooms grades.\u00a0We will be using Google Forms\/Spreadsheets to help us gather data and a combination of a script called <a href=\"http:\/\/www.flubaroo.com\/\" target=\"_blank\">Flubaroo <\/a>and excel to do our analysis.<\/p>\n<p>Below is a tutorial showing you how to setup a quiz and answer sheet. In addition, the finished products, both the quiz and results are available to you.<br \/>\n<strong>Tutorial:<\/strong><\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/Q-iVV8XVjFo\" height=\"315\" width=\"420\" allowfullscreen=\"\" frameborder=\"0\"><\/iframe><\/p>\n<p><strong>Finished products:<\/strong><\/p>\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/1818JmTi5erV-CMG3_grprEPrvcDlC9pVseA6tKRHZPM\/viewform\" target=\"_blank\">Quiz<\/a><a href=\"https:\/\/docs.google.com\/forms\/d\/1818JmTi5erV-CMG3_grprEPrvcDlC9pVseA6tKRHZPM\/viewform\"><br \/>\n<\/a><\/p>\n<p><a href=\" https:\/\/docs.google.com\/spreadsheet\/ccc?key=0Appk4D4WIEv8dEphb3QzRUhSSWdOUnR6cGdSeHF0ZkE&amp;usp=sharing\" target=\"_blank\">Results<\/a>\u00a0(there are 2 tabs on the bottom of the chart, click on the one entitled <em>Grades<\/em> to see Flubaroo&#8217;s results)<\/p>\n<p><b>Running Your Own Data Analysis<\/b><\/p>\n<p>Below are a series of steps you can follow to complete a data analysis on a post-assessment quiz that you would give your class before starting a unit.<\/p>\n<p><b>Laying the groundwork:<\/b><\/p>\n<ul>\n<li>Examine curricular target expectations<b><\/b><\/li>\n<li>Create a post-assessment<b><\/b><\/li>\n<li>Administer the post-assessment BEFORE teaching<b><\/b><\/li>\n<li>Pick a proficiency level<\/li>\n<\/ul>\n<p><b>Collect and chart data:<\/b><\/p>\n<ul>\n<li>Use the excel sheet below, input your data and examine student results. Please note there are 3 tabs in the excel sheet that allow you to input data for different situations\n<ul>\n<li>Individual Teacher<\/li>\n<li>Multiple Teachers teaching the same class<\/li>\n<li>Multiple Teachers with multiple items<b>\u00a0<\/b><\/li>\n<\/ul>\n<\/li>\n<li><b><a href=\"https:\/\/blogs.ubc.ca\/learninganalytics2013\/files\/2013\/10\/proficiency-tabulators.xlsx\">proficiency tabulators<\/a><\/b><\/li>\n<\/ul>\n<p><b>Analyze strengths and obstacles:<\/b><\/p>\n<p><b>\u00a0<\/b>Now that you have your data, you can use the questions below to help you reflect on what your data is telling you.<\/p>\n<ul>\n<li>On what areas of the assessment did the students perform well? (most frequently correct?)<\/li>\n<li>On what areas of the assessment did the students perform poorly? (most frequently missed?)<\/li>\n<li>To what do you attribute their lack of success in these areas? (type of instruction, time spent, feedback, previous formative assessment?)<\/li>\n<li>In what areas does your partner or other periods have similar results?<\/li>\n<li>In what areas does your partner or periods have different results?<\/li>\n<li>Are there any implications or changes that immediately come to the forefront with regards to future instruction? What will you do differently based on the results obtained?<\/li>\n<\/ul>\n<p><b>Comments<\/b><\/p>\n<ul>\n<li>Have you done your own data analysis? If yes, please share your experience<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to Do It Yourself Learning Analytics In this section we will be taking you on a journey to explore how one can run a simple analysis on ones own classrooms grades.\u00a0We will be using Google Forms\/Spreadsheets to help us<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/blogs.ubc.ca\/learninganalytics2013\/diy-analytics\/\">Read more &#8250;<\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":14637,"featured_media":0,"parent":0,"menu_order":2,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-7","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/pages\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/users\/14637"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":10,"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/pages\/7\/revisions"}],"predecessor-version":[{"id":172,"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/pages\/7\/revisions\/172"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/learninganalytics2013\/wp-json\/wp\/v2\/media?parent=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}