{"id":2491,"date":"2014-09-22T14:33:53","date_gmt":"2014-09-22T21:33:53","guid":{"rendered":"http:\/\/blogs.reed.edu\/ed-tech\/?p=2491"},"modified":"2014-12-03T15:42:54","modified_gmt":"2014-12-03T23:42:54","slug":"clickers-in-chemistry","status":"publish","type":"post","link":"https:\/\/blogs.reed.edu\/ed-tech\/2014\/09\/clickers-in-chemistry\/","title":{"rendered":"Clickers in chemistry: a classic case of data munging"},"content":{"rendered":"<p>Clickers are a common piece of educational technology across college campuses, used\u00a0for in-class quizzes or to allow many voices to &#8220;speak&#8221; in a<a href=\"http:\/\/www.educause.edu\/ero\/article\/clickers-classroom-active-learning-approach\"> class discussion<\/a>. At Reed, clickers are most commonly used in the first two years of Chemistry courses, which are some of our larger classes (75 students per section in Chem 101) and bring together students from a variety of academic backgrounds. Clickers allow faculty to check student comprehension throughout class and actively engage students in a larger lecture environment.<\/p>\n<p><!--more-->In addition to on-the-fly uses in class,\u00a0the data from clicker polling could be used to check student comprehension over time. Are a handful of students consistently incorrect in their answers? (If so, the instructor may be able to reach out to those students and offer additional assistance.) At a more basic level, &#8220;clicking in&#8221; could be used as a metric for attendance.<\/p>\n<figure id=\"attachment_2533\" aria-describedby=\"caption-attachment-2533\" style=\"width: 300px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2533 size-medium\" src=\"https:\/\/blogs.reed.edu\/ed-tech\/files\/2014\/09\/python-300x237.jpg\" alt=\"python\" width=\"300\" height=\"237\" srcset=\"https:\/\/blogs.reed.edu\/ed-tech\/files\/2014\/09\/python-300x237.jpg 300w, https:\/\/blogs.reed.edu\/ed-tech\/files\/2014\/09\/python.jpg 784w\" sizes=\"auto, (max-width: 300px) 85vw, 300px\" \/><figcaption id=\"caption-attachment-2533\" class=\"wp-caption-text\">A friendly (bit of) Python<\/figcaption><\/figure>\n<p>However, before any of\u00a0<em>that\u00a0<\/em>happens &#8212; one\u00a0would need information on the clickers themselves, the individual students, and what person\u00a0is connected to what device.<\/p>\n<p>Ladies and gentlemen, welcome to a classic data problem. We will solve this given three pieces of information, a good dose of logic, and a little help from our friends (in the form of a Python script).<\/p>\n<p>Here are our three pieces of (separate but equally useful) information:<\/p>\n<p>1) <strong>Class lists<\/strong>. These come by request from the Registrar&#8217;s Office, and contain:<\/p>\n<ul>\n<li>Student first name<\/li>\n<li>Student last name<\/li>\n<li>Student Reed ID number<\/li>\n<li>Student email (e.g. bottk@reed.edu)<\/li>\n<li>Course name and number (Chem 201 + Chem 101)<\/li>\n<li>Course section (two sections each)<\/li>\n<\/ul>\n<p>This should represent the population of clicker users for the term.<\/p>\n<p>2)\u00a0<strong>Clicker sales<\/strong>. The Reed Bookstore manages clicker sales, and is kind enough to provide reports featuring:<\/p>\n<ul>\n<li>Clicker number<\/li>\n<li>Student name (last, first)<\/li>\n<li>Student full name<\/li>\n<li>Reed ID (number) of student<\/li>\n<\/ul>\n<p>However, not all students buy clickers from the Bookstore. Someone enrolled in Chem 201 may still have a clicker from Chem 101; a student may buy or borrow a clicker from a friend. So we need a way to capture those not purchased this term.<\/p>\n<p>3)\u00a0<strong>Clicker self-report<\/strong>. Students in Chem 101\/201 are asked to fill out a <a href=\"http:\/\/www.google.com\/forms\/about\/\">Google Form<\/a>\u00a0with their:<\/p>\n<ul>\n<li>Clicker number<\/li>\n<li>Full\u00a0name (first last)<\/li>\n<li>Reed username (e.g. bottk)<\/li>\n<li>Course name<\/li>\n<li>Course number<\/li>\n<li>Section number<\/li>\n<\/ul>\n<p>These three pieces can certainly be combined manually. You might start with the class list, add data from the bookstore file one-by-one, and then flesh out the rest with the self-report data. If matching manually, you might use student name as your criteria for a match, or Reed ID, depending on what data you are linking together. These\u00a0<em>primary keys<\/em> uniquely identify datapoints, and are crucial\u00a0when combining datasets.<\/p>\n<p>This same process can be executed using scripting tools; in this case, I worked with a colleague to write a Python script that would combine all relevant pieces of information in a few seconds. This required knowing what information we (a) had available as inputs (b) trusted as inputs and (c) needed for the final output.<\/p>\n<p>You can find the script <a href=\"https:\/\/blogs.reed.edu\/ed-tech\/files\/2014\/09\/student_join2.pdf\">here<\/a>. The basic\u00a0steps are:<\/p>\n<ul>\n<li>tell the script where to look for files<\/li>\n<li>define your input datafiles and all fields<\/li>\n<li>define an error file and output files<\/li>\n<li>use data dictionaries to match individuals across datasets<\/li>\n<li>write errors to file<\/li>\n<li>write outputs to file<\/li>\n<\/ul>\n<p>This is one example of a data management problem which mirrors work I see students doing in their theses:\u00a0understanding input data from different sources, making decisions about what data one believes; designing a data structure and defining specific goals for the data project.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Clickers are a common piece of educational technology across college campuses, used\u00a0for in-class quizzes or to allow many voices to &#8220;speak&#8221; in a class discussion. At Reed, clickers are most commonly used in the first two years of Chemistry courses, which are some of our larger classes (75 students per section in Chem 101) and &hellip; <a href=\"https:\/\/blogs.reed.edu\/ed-tech\/2014\/09\/clickers-in-chemistry\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Clickers in chemistry: a classic case of data munging&#8221;<\/span><\/a><\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[69,70],"class_list":["post-2491","post","type-post","status-publish","format-standard","hentry","category-general-instructional-technology","tag-data","tag-python"],"_links":{"self":[{"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/posts\/2491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/comments?post=2491"}],"version-history":[{"count":13,"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/posts\/2491\/revisions"}],"predecessor-version":[{"id":2665,"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/posts\/2491\/revisions\/2665"}],"wp:attachment":[{"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/media?parent=2491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/categories?post=2491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.reed.edu\/ed-tech\/wp-json\/wp\/v2\/tags?post=2491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}