BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Springshare//LibCal//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-TIMEZONE:America/Los_Angeles
X-PUBLISHED-TTL:PT15M
BEGIN:VEVENT
DTSTART:20220622T173000Z
DTEND:20220622T190000Z
DTSTAMP:20220622T000000Z
SUMMARY:Cleaning Spreadsheet Data with Open Refine
DESCRIPTION:Class Overview\n\nGot messy spreadsheets? Open Refine is a 
 powerful\, free\, open-source software tool for cleaning and transforming 
 data in a way that is easy to reproduce. This hands-on class is targeted at 
 people who need to clean messy data\, including spreadsheets of survey 
 responses\, patient encounters\, financial records\, or workshop 
 attendance. Together we will work through the basics of cleaning data in 
 OpenRefine. If you want something more powerful than Excel but don't want 
 to spend the time to learn a programming language like R or Python\, 
 OpenRefine could be the perfect tool for you! \n\nLearning Objectives: 
 \n\nBy the end of the class learners should be able to:\n\n\n	Explain how 
 OpenRefine works on their computer\n	Use OpenRefine to:\n	\n		Facet data to 
 quickly see a snapshot of the contents and find typos and errors\n		Cluster 
 data to easily correct errors at scale\n		Split data into multiple 
 columns\n	\n	\n	Export their cleaned data in a variety of formats\n	Save 
 their cleaning scripts so they can be re-used\n\n\nPrerequisites / 
 Preparation\n\nPlease complete the following tasks before coming to 
 class:\n\n\n	\n	Download OpenRefine here: 
 http://openrefine.org/download.html If you are having trouble with the 
 download\, you can refer to setup instructions here: 
 https://datacarpentry.org/OpenRefine-ecology-lesson/setup.html or email me 
 at ariel.deardorff@ucsf.edu\n	\n	\n	Download the class data file from the 
 course website\n	\n\n\nInstructor\n\nAriel Deardorff\, Data Services 
 Librarian\, UCSF Library\n\nWhen you register\, the Library reserves class 
 space for you. Since many of our classes have a waitlist\, please cancel 
 your registration if you can no longer attend.
LOCATION:Virtual\, Online
ORGANIZER;CN="Ariel Deardorff":MAILTO:ariel.deardorff@ucsf.edu
CATEGORIES:Data Management, Data Science, ZSFG
CONTACT;CN="Ariel Deardorff":MAILTO:ariel.deardorff@ucsf.edu
STATUS:CONFIRMED
UID:LibCal-9197517
URL:https://calendars.library.ucsf.edu/event/9197517
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT

END:VCALENDAR