index.html

---
layout: workshop      # DON'T CHANGE THIS.
root: .               # DON'T CHANGE THIS.
venue: "UW Madison"        # brief name of host site without address (e.g., "Euphoric State University")
address: "Orchard Room, Discovery Building, 330 Orchard St., Madison, WI"      # street address of workshop (e.g., "123 Forth Street, Blimingen, Euphoria")
country: "us"      # country (lowercase two-letter ISO code such as "fr" - see https://en.wikipedia.org/wiki/ISO_3166-1)
language: "en"     # language (lowercase two-letter ISO code such as "fr" - see https://en.wikipedia.org/wiki/ISO_639-1)
latlng: "43.0728339,-89.4103303"       # fractional latitude and longitude (e.g., "41.7901128,-87.6007318"; you can use http://www.latlong.net/)
humandate: "January 8-9, 2018"    # human-readable date (e.g., "Feb 17-18, 2020")
humantime: "8:30am - 4:30pm"    # human-readable time (e.g., "9:00 am - 4:30 pm")
startdate: 2018-01-08      # use YYYY-MM-DD format like 2015-01-01
enddate: 2018-01-09        # use YYYY-MM-DD format like 2015-01-02
instructor: ["Trisha Adamus","Alex Bajcz","Karl Broman","Michelle Craft","Lauren Michael"] # list of names like ["Kay McNulty", "Betty Jennings", "Betty Snyder"]
helper: ["Cameron Cook",  "Steve Goldstein", "Maria Kamenetsky","Andy Pohl"]     # list of names like ["Marlyn Wescoff", "Fran Bilas", "Ruth Lichterman"]
contact: "ContactACI@lists.wisc.edu "      # contact email address for workshop organizer, such as "grace@hopper.org"
etherpad: http://pad.software-carpentry.org/2018-01-08-uwmadison-dc       # optional (insert the URL for your Etherpad if you're using one)
eventbrite: 39736673460 # optional (insert the alphanumeric key for Eventbrite registration, e.g., "1234567890AB")
day1_am: "Data organization in spreadsheets and OpenRefine"
day1_pm: "SQL for data management"
day2_am: "Introduction to R"
day2_pm: "Data analysis and visualization in R"
---
<!--
  HEADER

  Edit the values in the block above to be appropriate for your
  workshop.  Run 'tools/check' *before* committing to make sure that
  changes are good.
-->

<!--
  EVENTBRITE

  This block includes the Eventbrite registration widget if
  'eventbrite' has been set in the header.  You can delete it if you
  are not using Eventbrite, or leave it in, since it will not be
  displayed if the 'eventbrite' field in the header is not set.
-->
Registration is required and will be available just below, starting at 5:00pm on Monday, December 11.
Make sure to read all details below before registering and to choose appropriately between UW-Madison's
<a href="https://uw-madison-aci.github.io/2018-01-08-uwmadison-dc/">Data Carpentry</a> and
<a href="https://uw-madison-aci.github.io/2018-01-10-uwmadison-swc/">Software Carpentry</a> workshops.

{% if page.eventbrite %}
<iframe
  src="https://www.eventbrite.com/tickets-external?eid={{page.eventbrite}}&ref=etckt"
  frameborder="0"
  width="100%"
  height="206px"
  scrolling="auto">
</iframe>
{% endif %}

<h2>General Information</h2>

<!--
  INTRODUCTION

  Edit the general explanatory paragraph below if you want to change
  the pitch.
-->
<p>
<a href=http://datacarpentry.org>Data Carpentry</a> workshops are for any researcher
who has data they want to analyze, and no prior computational experience is required.
This hands-on workshop teaches basic concepts, skills and tools for working more
effectively with data.
</p>
<p>
We will cover {{page.day1_am}}, {{page.day1_pm}}, {{page.day2_am}} and {{page.day2_pm}}.

Participants should bring their laptops and plan to participate actively. By the end of the workshop learners should be able to more effectively manage and analyze data and be able to apply the tools and approaches directly to their ongoing research.
</p>

<p>

For researchers who have already been programming and seek to expand their capabilities, our
  UW-Madison <a href="https://uw-madison-aci.github.io/2018-01-10-uwmadison-swc/">Software Carpentry workshop (Jan 10-11)</a> will likely be more appropriate.
  These two workshops are NOT intended to be taken back-to-back, and you can learn about
  future workshops at UW-Madison by joining the <a href="wisc.us9.list-manage.com/subscribe?u=c3aae71670855b66d79d170b8&id=6d65510fb6">mailing
  list</a> of UW-Madison's <a href="http://aci.wisc.edu/">Advanced Computing Initiative</a>.
</p>

<!--
  AUDIENCE

  Explain who your audience is.  (In particular, tell readers if the
  workshop is only open to people from a particular institution.
-->
<p>
  <strong>Who:</strong>
  The course is aimed at UW-Madison-affiliated graduate students, staff, and other researchers.
</p>

<!--
  LOCATION

  This block displays the address and links to maps showing directions
  if the latitude and longitude of the workshop have been set.  You
  can use http://itouchmap.com/latlong.html to find the lat/long of an
  address.
-->
{% if page.latlng %}
<p>
  <strong>Where:</strong>
  {{page.address}}.
  Get directions with
  <a href="//www.openstreetmap.org/?mlat={{page.latlng | replace:',','&mlon='}}&zoom=16">OpenStreetMap</a>
  or
  <a href="//maps.google.com/maps?q={{page.latlng}}">Google Maps</a>.
</p>
{% endif %}

<!--
  SPECIAL REQUIREMENTS

  Modify the block below if there are any special requirements.
-->
<p>
  <strong>Requirements:</strong> Participants should plan to attend BOTH days of the workshop and bring a
  laptop with a Mac, Linux, or Windows operating sytem (not a tablet, Chromebook, etc.) that they have
  administrative privileges on. They should have a few specific software packages installed (listed
  <a href="#setup">below</a>). They are also required to abide by
  Data Carpentry's
  <a href="{{site.dc_site}}/code-of-conduct/">Code of Conduct</a>.
</p>

<!--
  CONTACT EMAIL ADDRESS

  Display the contact email address set in the header.  If an address
  isn't set in the header, the Software Carpentry admin address is
  used.
-->
<p>
  <strong>Contact</strong>:
  Please mail
  {% if page.contact %}
    <a href='mailto:{{page.contact}}'>{{page.contact}}</a>
  {% else %}
    <a href='mailto:{{site.contact}}'>{{site.contact}}</a>
  {% endif %}
  for more information.
</p>

<hr/>

<h2 id="setup">Setup</h2>

<!-- DO NOT EDIT SURVEY LINKS -->

<p>
To participate in a Data Carpentry workshop, you will need working copies of the
described software. Please make sure to install everything (or at least to download
the installers) before the start of your workshop. Participants should bring and use
their own laptops to insure the proper setup of tools for an efficient workflow
once you leave the workshop.
<p>
Please follow these <a href=install.html>Setup Instructions</a>.

<p>
  We maintain a list of common issues that occur during installation as a reference for instructors
  that may be useful on the
  <a href = "https://github.com/swcarpentry/workshop-template/wiki/Configuration-Problems-and-Solutions">Configuration Problems and Solutions wiki page</a>.
</p>

<p><em>Surveys</em></p>
<p>Please complete this survey before the workshop!</p>
<p><a href='{{ site.dc_pre_assessment }}'>Pre-workshop Survey</a></p>

<!-- DO NOT EDIT SURVEY LINKS -->
<!-- <p><em>Surveys</em></p>
<p>Please be sure to complete these surveys before and after the workshop.</p>
<p><a href='{{ site.dc_pre_assessment }}'>Pre-workshop Survey</a></p>
<p><a href='{{ site.dc_post_assessment }}'>Post-workshop Survey</a></p> -->

</hr>

<!--
  SCHEDULE

  Show the workshop's schedule.  Edit the items and times in the table
  to match your plans.  You may also want to change 'Day 1' and 'Day
  2' to be actual dates or days of the week.
-->
<h2>Preliminary Schedule</h2>

<!--
  ETHERPAD

  Display the Etherpad for the workshop.  You can set this up in
  advance or on the first day; either way, make sure you push changes
  to GitHub after you have its URL.  To create an Etherpad, go to

      http://etherpad.mozilla.org/YYYY-MM-DD-site

  where 'YYYY-MM-DD-site' is the identifier for your workshop (e.g.,
  '2015-06-10-esu'.
-->
{% if page.etherpad %}
<p>
  <strong>Etherpad:</strong> <a href="{{page.etherpad}}">{{page.etherpad}}</a>.
  <br/>
  We will use this Etherpad for chatting, taking notes, and sharing URLs and bits of code.
</p>
{% endif %}

<a href="https://www.rstudio.com/resources/cheatsheets/">R Cheatsheets</a>

<div class="row">
  <div class="col-md-6">

       <h3>Day 1</h3>
    <table class="table table-striped">
      <tr> <td>8:30 - 9:00</td>  <td>Installation Help</td> </tr>
      <tr> <td>9:00 - 9:10</td>  <td><a href="2018-01-08_DC_intro.pdf">Introduction</a></td> </tr>
      <tr><td>9:10 - 10:30</td> <td><a href="https://lmichael107.github.io/spreadsheet-ecology-lesson/">Data Organization in Spreadsheets</a></td></tr>
      <tr><td>10:30 - 10:45</td> <td>Break</td></tr>
      <tr><td>10:45 - 12:00 </td> <td><a href="http://www.datacarpentry.org/OpenRefine-ecology-lesson/">Data Cleaning with OpenRefine</a></td></tr>
      <tr><td>12:00 - 1:00</td> <td>Lunch Break</td></tr>
      <tr><td>1:00 - 2:15</td> <td><a href="http://www.datacarpentry.org/sql-ecology-lesson/">Data Management with SQL</a></td></tr>
      <tr><td>2:15 - 2:30</td> <td>Coffee</td></tr>
      <tr><td>2:30 - 4:00</td> <td><a href="http://www.datacarpentry.org/sql-ecology-lesson/">Data Management with SQL</a></td></tr>
    </table>


    <h3>Day 2</h3>
    <table class="table table-striped">
      <tr> <td>8:30 - 9:00</td>  <td>Installation Help</td> </tr>
      <tr><td>9:00 - 9:15</td> <td><a href="http://kbroman.org/datacarpentry_R_2018-01-08/AlexBajcz/DC_Day_2_Intro_slides_+_challenges_v2_Jan_2018.pdf">Day 2 intro </a></td></tr>
      <tr><td>9:15 - 10:30</td> <td>Intro
                to R [<a href="http://kbroman.org/datacarpentry_R_2018-01-08/AlexBajcz/DC_Day_2_R_Lesson_Intro_+_dplyr_Jan_2018.pdf">Lesson narrative</a> | <a href="http://kbroman.org/datacarpentry_R_2018-01-08/AlexBajcz/R_handout_for_DC.pdf">Handout</a> | <a href="https://raw.githubusercontent.com/kbroman/datacarpentry_R_2018-01-08/master/AlexBajcz/code_for_intro_R_workshop_section_v2_Jan_2018.R">Lesson R script</a> | <a href="https://raw.githubusercontent.com/kbroman/datacarpentry_R_2018-01-08/master/AlexBajcz/Intro_to_R2.R">R script from workshop</a>]

</td></tr>
      <tr><td>10:30 - 10:45</td> <td>Break</td></tr>
      <tr><td>10:45 - 12:00</td> <td>Data manipulation with dplyr [<a href="https://raw.githubusercontent.com/kbroman/datacarpentry_R_2018-01-08/master/AlexBajcz/code_for_dplyr_workshop_section_v1_Jan_2018.R">Lesson R script</a>]</td></tr>
      <tr><td>12:00 - 1:00</td> <td>Lunch Break</td></tr>
      <tr><td>1:00 - 2:30</td> <td><a href="http://kbroman.org/datacarpentry_R_2018-01-08/03-ggplot2.html">Data Visualization with
                            ggplot2 </a> [<a href="https://raw.githubusercontent.com/kbroman/datacarpentry_R_2018-01-08/master/2018-01-09_ggplot2.R">R script from workshop</a>]  </td></tr>
      <tr><td>2:30 - 2:45</td> <td>Coffee</td></tr>
      <tr><td>2:45 - 3:15</td> <td><a href="http://kbroman.org/datacarpentry_R_2018-01-08/04-rmarkdown.html">Reproducible reports with R Markdown</a> [<a href="https://raw.githubusercontent.com/kbroman/datacarpentry_R_2018-01-08/master/2018-01-09_rmarkdown_example.Rmd">R Markdown example</a>]
              </td></tr>
      <tr><td>3:15 - 4:00</td> <td><a
      href="http://kbroman.org/datacarpentry_R_2018-01-08/capstone.html">Capstone
        project</a> [Solutions: <a href="https://raw.githubusercontent.com/kbroman/datacarpentry_R_2018-01-08/master/capstone_soln/capstone_soln.Rmd">Rmd</a> | <a href="http://kbroman.org/datacarpentry_R_2018-01-08/capstone_soln/capstone_soln.html">html</a>]
      </td></tr>
      <tr><td>4:00 - 4:15</td> <td>Wrap up and fill out the post-workshop survey (see below)</td></tr>
      <tr><td>4:15 - 5:00</td> <td>Join the Data Carpentry team for drinks and snacks at the Sett</td></tr>

  </table>
 </div>
</div>

<p><a href='{{ site.dc_post_assessment }}'>Post-workshop Survey</a></p>

<p><strong>After the workshop</strong>: We will be hosting a follow-up session on R during the week of
    January 16 - 19.  See <a href="https://uw-madison-aci.github.io/2018-01-post-workshop/">this page</a> for
more details. </p>

<!--
  SYLLABUS

  Show what topics will be covered.

  1. If your workshop is R rather than Python, remove the comment
     around that section and put a comment around the Python section.
  2. Some workshops will delete SQL.
  3. Please make sure the list of topics is synchronized with what you
     intend to teach.
  4. You may need to move the div's with class="col-md-6" around inside
     the div's with class="row" to balance the multi-column layout.

  This is one of the places where people frequently make mistakes, so
  please preview your site before committing, and make sure to run
  'tools/check' as well.
-->
<!--
<h2>Syllabus</h2>

<div class="row">
  <div class="col-md-6">
    <h3>The Unix Shell</h3>
    <ul>
      <li>Files and directories</li>
      <li>History and tab completion</li>
      <li>Pipes and redirection</li>
      <li>Looping over files</li>
      <li>Creating and running shell scripts</li>
      <li>Finding things</li>
      <li><a href="{{site.swc_lessons}}/ref/01-shell.html">Reference...</a></li>
    </ul>
  </div>
  <div class="col-md-6">
    <h3>Programming in Python</h3>
    <ul>
      <li>Using libraries</li>
      <li>Working with arrays</li>
      <li>Reading and plotting data</li>
      <li>Creating and using functions</li>
      <li>Loops and conditionals</li>
      <li>Defensive programming</li>
      <li>Using Python from the command line</li>
      <li><a href="{{site.swc_lessons}}/ref/03-python.html">Reference...</a></li>
    </ul>
  </div>

  <div class="col-md-6">
    <h3>Programming in R</h3>
    <ul>
      <li>Working with vectors and data frames</li>
      <li>Reading and plotting data</li>
      <li>Creating and using functions</li>
      <li>Loops and conditionals</li>
      <li>Using R from the command line</li>
      <li><a href="{{site.swc_lessons}}/ref/06-R.html">Reference...</a></li>
    </ul>
  </div>

</div>

<div class="row">
  <div class="col-md-6">
    <h3>Version Control with Git</h3>
    <ul>
      <li>Creating a repository</li>
      <li>Recording changes to files: <code>add</code>, <code>commit</code>, ...</li>
      <li>Viewing changes: <code>status</code>, <code>diff</code>, ...</li>
      <li>Ignoring files</li>
      <li>Working on the web: <code>clone</code>, <code>pull</code>, <code>push</code>, ...</li>
      <li>Resolving conflicts</li>
      <li>Open licenses</li>
      <li>Where to host work, and why</li>
      <li><a href="{{site.swc_lessons}}/ref/02-git.html">Reference...</a></li>
    </ul>
  </div>
  <div class="col-md-6">
    <h3>Managing Data with SQL</h3>
    <ul>
      <li>Reading and sorting data</li>
      <li>Filtering with <code>where</code></li>
      <li>Calculating new values on the fly</li>
      <li>Handling missing values</li>
      <li>Combining values using aggregation</li>
      <li>Combining information from multiple tables using <code>join</code></li>
      <li>Creating, modifying, and deleting data</li>
      <li>Programming with databases</li>
      <li><a href="{{site.swc_lessons}}/ref/04-sql.html">Reference...</a></li>
    </ul>
  </div>
</div>


<hr/>
-->

<!--
  SETUP

  Delete irrelevant sections from the setup instructions.  Each
  section is inside a 'div' without any classes to make the beginning
  and end easier to find.

  This is the other place where people frequently make mistakes, so
  please preview your site before committing, and make sure to run
  'tools/check' as well.
-->