<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
OK-ACRL invites all members to<span class="ContentPasted0"> </span><a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fokacrl.wufoo.com%2Fforms%2Fz1hgyarf14hculo%2F&data=05%7C01%7Cjamie.holmes%40tulsacc.edu%7Cd781c1a1a12840899bb508dab5f91ca8%7Ceb5d9dc493c645578c2390ef7fa05b96%7C0%7C0%7C638022378794577820%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=u%2BDipQto16e2UnrPnCo8VCYodMKQR2LqkeUfYuvWUaQ%3D&reserved=0" target="_blank" rel="noopener noreferrer" data-auth="NotApplicable" data-safelink="true" data-linkindex="2" style="margin:0px" class="ContentPasted0">register
for a pre-conference Library Carpentry workshop</a><span class="ContentPasted0"> </span>on Tidy Data and OpenRefine, to be held on Thursday, November 10 from 9:00-12:00. This workshop is open to everyone, regardless of experience level. OK-ACRL is not charging
a registration fee for this class. However, we are accepting a suggested donation of $5 to the<span class="ContentPasted0"> </span><a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fwww.okacrl.org%2Fendowment%2F__%3B!!GNU8KkXDZlD12Q!9X_qlX0JYra-x4EYtWqmiN9wWcQgoT5nNuE6ZpWC8tWoEPN4RxgFEif8PzzVUWoxJGeRs-pErGnrcitMRj5ok_gLwWVrzgreJkI%24&data=05%7C01%7Cjamie.holmes%40tulsacc.edu%7Cd781c1a1a12840899bb508dab5f91ca8%7Ceb5d9dc493c645578c2390ef7fa05b96%7C0%7C0%7C638022378794577820%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=45mOfjtMYxzvxvMBoIfNqOO4V5SS2CnyfNcBLnCnIEY%3D&reserved=0" target="_blank" rel="noopener noreferrer" data-auth="NotApplicable" data-safelink="true" data-linkindex="3" style="margin:0px" class="ContentPasted0">OK-ACRL
Endowment</a>.</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;">
<b class="ContentPasted0">Please note that this is a separate registration from the<span class="ContentPasted0"> </span><a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fokacrl.wufoo.com%2Fforms%2Fzhpwfvt0kijl4e%2F&data=05%7C01%7Cjamie.holmes%40tulsacc.edu%7Cd781c1a1a12840899bb508dab5f91ca8%7Ceb5d9dc493c645578c2390ef7fa05b96%7C0%7C0%7C638022378794577820%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=MMnkZKm4FdPkcBgMLCg41AwEiChtCjbTNaZhPYRi8pk%3D&reserved=0" target="_blank" rel="noopener noreferrer" data-auth="NotApplicable" data-safelink="true" data-linkindex="4" style="margin:0px" class="ContentPasted0">OK-ACRL
Annual Conference, which is also now open</a>.</b></p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
Good data organization is the foundation of any research project. Most researchers have data in spreadsheets, so it’s the place that many research projects start. We organize data in spreadsheets in the ways that we as humans want to work with the data, but
computers require that data be organized in particular ways. In order to use tools that make computation more efficient, such as programming languages like R or Python, we need to structure our data the way that computers need the data. Since this is where
most research projects start, this is where we want to start, too! In this lesson, you will learn: good data entry practices, formatting data tables in spreadsheets, avoiding common formatting mistakes, and approaches for handling dates in spreadsheets.</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
Before you can analyze data you need to clean it. Data cleaning identifies errors and corrects formatting to create consistent data. This step must be taken with extreme care and attention because without clean data the results of analysis may be false and
non-reproducible. OpenRefine is a powerful free and open source tool for working with messy data: cleaning it and transforming it from one format into another. This lesson will teach you to use OpenRefine to clean and format data effectively and automatically
track any changes that you make. Many people comment that this tool saves them literally months of work trying to make these edits by hand.</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
9:00-10:00 – Tidy Data</p>
<p style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px;" class="ContentPasted0">
10:00-12:00 - OpenRefine</p>
<br>
</div>
<div class="elementToProof">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<table style="font-size: 15px; color: rgb(32, 31, 30); text-align: start; background-color: rgb(255, 255, 255); width: 337.5pt; border-collapse: collapse;">
<tbody>
<tr>
<td style="width:53.6pt">
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px 7.5pt 7.5pt 0px">
<a href="http://www.rsu.edu/library/" target="_blank" rel="noopener noreferrer" style="margin:0px"><span style="margin: 0px; font-size: 9pt; font-family: Helvetica, sans-serif; color: black;"><img class="EmojiInsert" alt="RSULibraries_AcronymLogo_vert_color_for email" style="margin:0px; width:45pt; height:74.24pt" data-outlook-trace="F:0|T:1" src="cid:image001.png@01D54932.464C84F0"></span></a><span style="margin: 0px; font-size: 9pt; font-family: Helvetica, sans-serif; color: black;"></span></p>
</td>
<td style="width:283.9pt">
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px"><span style="margin: 0px; font-size: 16pt; font-family: "High Tower Text", serif; color: rgb(31, 73, 125);">Ashley Bean</span></p>
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px"><span style="margin: 0px; font-family: "High Tower Text", serif; color: rgb(31, 73, 125);">First Year Experience & Distance Learning Librarian</span><span style="margin: 0px; font-size: 8pt; font-family: Calibri, sans-serif; color: rgb(195, 14, 46);"></span></p>
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px"><b><span style="margin: 0px; font-size: 11pt; font-family: "High Tower Text", serif; color: rgb(14, 34, 64);">Rogers State University</span></b></p>
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px"><span style="margin: 0px; font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(14, 34, 64);">918-343-7786</span></p>
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px"><u><span style="margin: 0px; font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(195, 14, 46);"><a href="mailto:abean@rsu.edu" target="_blank" rel="noopener noreferrer" style="margin:0px">abean@rsu.edu</a></span></u></p>
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px"><br>
</p>
<p style="font-size:12pt; font-family:"Times New Roman",serif; margin:0px"><a href="https://www.facebook.com/rsulibraries/" title="https://www.facebook.com/rsulibraries/"><img style="max-width:100%" data-outlook-trace="F:1|T:1" src="cid:d98216fb-967d-42b4-849d-9f2f8f215d2d"></a> <a href="https://www.instagram.com/rsulibraries/" title="https://www.instagram.com/rsulibraries/"><img style="max-width:100%" data-outlook-trace="F:1|T:1" src="cid:b712998f-c024-47d2-8ee4-58dcb070dd0e"></a> <a href="https://twitter.com/rsulibraries" title="https://twitter.com/rsulibraries"><img style="max-width:100%" data-outlook-trace="F:1|T:1" src="cid:e3ef1b93-c867-466d-898a-9569b5576a13"></a> <a href="https://www.youtube.com/channel/UCf_Ao2cPHhZkgJUr4HKChIQ" title="https://www.youtube.com/channel/UCf_Ao2cPHhZkgJUr4HKChIQ"><img style="max-width:100%" data-outlook-trace="F:1|T:1" src="cid:502869dc-0c4b-4799-aacc-c94873245771"></a><br>
</p>
</td>
</tr>
</tbody>
</table>
<br>
</div>
</div>
</div>
</div>
</body>
</html>