{"id":2784,"date":"2024-10-24T09:27:44","date_gmt":"2024-10-24T12:27:44","guid":{"rendered":"https:\/\/ccdhhn.ca\/?post_type=tribe_events&#038;p=2784"},"modified":"2024-10-24T09:35:37","modified_gmt":"2024-10-24T12:35:37","slug":"tidy-data-using-spreadsheet-programs-for-data-organization","status":"publish","type":"tribe_events","link":"https:\/\/ccdhhn.ca\/fr\/workshop\/tidy-data-using-spreadsheet-programs-for-data-organization\/","title":{"rendered":"Tidy data (using spreadsheet programs for data organization)"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"159\" src=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-05-at-4.13.12\u202fPM-1024x159.png\" alt=\"\" class=\"wp-image-2004\" srcset=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-05-at-4.13.12\u202fPM-1024x159.png 1024w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-05-at-4.13.12\u202fPM-300x47.png 300w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-05-at-4.13.12\u202fPM-768x119.png 768w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-05-at-4.13.12\u202fPM.png 1135w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div  class=\"tribe-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Event Language<\/h3>\n\tEnglish<\/div>\n\n\n<div  class=\"tribe-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Format <\/h3>\n\tvirtual\/virtuel<\/div>\n\n\n<div  class=\"tribe-events-single-section tribe-events-section-category tribe-clearfix\" >\n\t<dt class=\"tribe-events-event-categories-label\">Cat\u00e9gorie d\u2019\u00c9v\u00e8nement:<\/dt> <dd class=\"tribe-events-event-categories\"><a href=\"https:\/\/ccdhhn.ca\/workshops\/category\/1-4-hour-workshop\/\" rel=\"tag\">1-4 hour workshop<\/a><\/dd><\/div>\n\n\n\n<p>Date: 4 November  2024<\/p>\n\n\n\n<p>This workshop aims to teach researchers, librarians, and information professionals basic concepts, skills, and tools for working with data to get more done quickly and with less pain. In this lesson, you will learn good data entry practices, how to avoid common formatting mistakes, approaches for handling dates in spreadsheets, basic quality control and data manipulation, and exporting data from spreadsheets. This domain-specific workshop focuses on examples and challenges from Humanities, Social Sciences, and library research fields and uses&nbsp;<a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/can01.safelinks.protection.outlook.com\/?url=http%3A%2F%2Flibrarycarpentry.org%2F&amp;data=05%7C02%7Cmhowse%40stfx.ca%7C58de1f335bd54cc8fa2908dcf38e83d6%7C8c46abc7960b412489501628b2b192f9%7C0%7C0%7C638653040639423308%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=GvbZ2x4LDqtKOnTtsWXGY6SYG5n8QS7xtw0DXyP%2BZpA%3D&amp;reserved=0\">librarycarpentry.org<\/a>&nbsp;materials.<\/p>\n\n\n\n<p><strong>Technical requirements:<\/strong>&nbsp;have spreadsheet software installed prior to the workshop.&nbsp;<a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/can01.safelinks.protection.outlook.com\/?url=https%3A%2F%2Flibrarycarpentry.org%2Flc-spreadsheets%2F%23setup&amp;data=05%7C02%7Cmhowse%40stfx.ca%7C58de1f335bd54cc8fa2908dcf38e83d6%7C8c46abc7960b412489501628b2b192f9%7C0%7C0%7C638653040639444583%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=2p399ENVLmvkiqTLGkZfKbvlsNp80ecFuTbfMCV1ZXs%3D&amp;reserved=0\">Library Carpentry suggests LibreOffice<\/a>.<\/p>\n\n\n<div  class=\"tribe-block tribe-block__event-website\" >\n\t<a\n\t\thref=\"https:\/\/engagedri-ca.zoom.us\/meeting\/register\/tZwucOGspjMrEtZa3UOGYnn_U0lajdXwasto\"\n\t\ttarget=\"_self\"\n\t\t\t>\n\t\tLink to register\t<\/a>\n<\/div>\n\n\n<div  class=\"tribe-block tribe-block__organizer__details tribe-clearfix\" >\n\t<div class=\"tribe-block__organizer__title\">\n\t\t<h3><a href=\"https:\/\/ccdhhn.ca\/fr\/organisateur\/digital-research-alliance-of-canada\/\" title=\"Digital Research Alliance of Canada\" target=\"_self\" rel=\"\">Digital Research Alliance of Canada<\/a><\/h3>\n\t<\/div>\n\t\t\t\t<p class=\"tribe-block__organizer__website\"><a href=\"https:\/\/alliancecan.ca\/\" target=\"_blank\" rel=\"noopener noreferrer\">View Organisateur Website<\/a><\/p>\n\t\t<\/div>\n\n\n<div  class=\"tribe-block tribe-block__venue tribe-clearfix\" >\n\t\n\t\t\n\t<\/div>\n\n\n\t<div  class=\"tribe-block tribe-block__events-link\" >\n\t\t<div class=\"tribe-events tribe-common\">\n\t\t\t<div class=\"tribe-events-c-subscribe-dropdown__container\">\n\t\t\t\t<div class=\"tribe-events-c-subscribe-dropdown\">\n\t\t\t\t\t<div class=\"tribe-common-c-btn-border tribe-events-c-subscribe-dropdown__button\">\n\t\t\t\t\t\t<svg\n\t class=\"tribe-common-c-svgicon tribe-common-c-svgicon--cal-export tribe-events-c-subscribe-dropdown__export-icon\" \taria-hidden=\"true\"\n\tviewBox=\"0 0 23 17\"\n\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n>\n\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M.128.896V16.13c0 .211.145.383.323.383h15.354c.179 0 .323-.172.323-.383V.896c0-.212-.144-.383-.323-.383H.451C.273.513.128.684.128.896Zm16 6.742h-.901V4.679H1.009v10.729h14.218v-3.336h.901V7.638ZM1.01 1.614h14.218v2.058H1.009V1.614Z\" \/>\n\t<path d=\"M20.5 9.846H8.312M18.524 6.953l2.89 2.909-2.855 2.855\" stroke-width=\"1.2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/>\n<\/svg>\n\t\t\t\t\t\t<button\n\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__button-text\"\n\t\t\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\t\t\taria-controls=\"tribe-events-subscribe-dropdown-content\"\n\t\t\t\t\t\t\taria-label=\"View links to add events to your calendar\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\tAjouter au calendrier\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\t<svg\n\t class=\"tribe-common-c-svgicon tribe-common-c-svgicon--caret-down tribe-events-c-subscribe-dropdown__button-icon\" \taria-hidden=\"true\"\n\tviewBox=\"0 0 10 7\"\n\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n>\n\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M1.008.609L5 4.6 8.992.61l.958.958L5 6.517.05 1.566l.958-.958z\" class=\"tribe-common-c-svgicon__svg-fill\"\/>\n<\/svg>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"tribe-events-subscribe-dropdown-content\" class=\"tribe-events-c-subscribe-dropdown__content\">\n\t\t\t\t\t\t<ul class=\"tribe-events-c-subscribe-dropdown__list\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--gcal\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"https:\/\/www.google.com\/calendar\/event?action=TEMPLATE&#038;dates=20241104T000000\/20241104T235959&#038;text=Tidy%20data%20%28using%20spreadsheet%20programs%20for%20data%20organization%29&#038;details=%3Cfigure+class%3D%22wp-block-image+size-large%22%3E%3Cimg+src%3D%22https%3A%2F%2Fccdhhn.ca%2Fwp-content%2Fuploads%2F2024%2F01%2FScreenshot-2024-01-05-at-4.13.12%E2%80%AFPM-1024x159.png%22+alt%3D%22%22+class%3D%22wp-image-2004%22%2F%3E%3C%2Ffigure%3E%3Cp%3EDate%3A+4+November++2024%3C%2Fp%3E+%3Cp%3EThis+workshop+aims+to+teach+researchers%2C+librarians%2C+and+information+professionals+basic+concepts%2C+skills%2C+and+tools+for+working+with+data+to+get+more+done+quickly+and+with+less+pain.+In+this+lesson%2C+you+will+learn+good+data+entry+practices%2C+how+to+avoid+common+formatting+mistakes%2C+approaches+for+handling+dates+in+spreadsheets%2C+basic+quality+control+and+data+manipulation%2C+and+exporting+data+from+spreadsheets.+This+domain-specific+workshop+focuses+on+examples+and+challenges+from+Humanities%2C+Social+Sciences%2C+and+library+research+fields+and+uses%26nbsp%3B%3Ca+rel%3D%22noreferrer+noopener%22+target%3D%22_blank%22+href%3D%22https%3A%2F%2Fcan01.safelinks.protection.outlook.com%2F%3Furl%3Dhttp%253A%252F%252Flibrarycarpentry.org%252F%26amp%3Bdata%3D05%257C02%257Cmhowse%2540stfx.ca%257C58de1f335bd54cc8fa2908dcf38e%3C%2Fp%3E+%28View+Full+%C3%A9v%C3%A8nement+Description+Here%3A+https%3A%2F%2Fccdhhn.ca%2Ffr%2Fworkshop%2Ftidy-data-using-spreadsheet-programs-for-data-organization%2F%29&#038;trp=false&#038;ctz=America\/Halifax&#038;sprop=website:https:\/\/ccdhhn.ca\/fr\/\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tGoogle Agenda\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--ical\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tiCalendar\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--outlook-365\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tOutlook 365\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--outlook-live\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tOutlook Live\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Date: 4 November 2024 This workshop aims to teach researchers, librarians, and information professionals basic concepts, skills, and tools for working with data to get more done quickly and with [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":2004,"template":"","meta":{"_tec_requires_first_save":false,"_EventAllDay":true,"_EventTimezone":"America\/Halifax","_EventStartDate":"2024-11-04 00:00:00","_EventEndDate":"2024-11-04 23:59:59","_EventStartDateUTC":"2024-11-04 04:00:00","_EventEndDateUTC":"2024-11-05 03:59:59","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"https:\/\/engagedri-ca.zoom.us\/meeting\/register\/tZwucOGspjMrEtZa3UOGYnn_U0lajdXwasto","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"$","_EventCurrencyCode":"CAD","_EventCurrencyPosition":"prefix","_EventDateTimeSeparator":" @ ","_EventTimeRangeSeparator":" - ","_EventOrganizerID":[2003],"_EventVenueID":[],"_OrganizerEmail":"","_OrganizerPhone":"","_OrganizerWebsite":"","_VenueAddress":"","_VenueCity":"","_VenueCountry":"","_VenueProvince":"","_VenueState":"","_VenueZip":"","_VenuePhone":"","_VenueURL":"","_VenueStateProvince":"","_VenueLat":"","_VenueLng":"","_VenueShowMap":false,"_VenueShowMapLink":false,"_tribe_blocks_recurrence_rules":"","_tribe_blocks_recurrence_description":"","_tribe_blocks_recurrence_exclusions":"","_ecp_custom_2":"English","_ecp_custom_3":"virtual\/virtuel","_tribe_events_status":"","_tribe_events_status_reason":"","_tribe_events_is_hybrid":"","_tribe_events_is_virtual":"","_tribe_events_virtual_video_source":"","_tribe_events_virtual_embed_video":"","_tribe_events_virtual_linked_button_text":"","_tribe_events_virtual_linked_button":"","_tribe_events_virtual_show_embed_at":"","_tribe_events_virtual_show_embed_to":[],"_tribe_events_virtual_show_on_event":"","_tribe_events_virtual_show_on_views":"","_tribe_events_virtual_url":"","footnotes":""},"tags":[],"tribe_events_cat":[3],"class_list":["post-2784","tribe_events","type-tribe_events","status-publish","has-post-thumbnail","hentry","tribe_events_cat-1-4-hour-workshop","cat_1-4-hour-workshop"],"_links":{"self":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/2784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":1,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/2784\/revisions"}],"predecessor-version":[{"id":2785,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/2784\/revisions\/2785"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media\/2004"}],"wp:attachment":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media?parent=2784"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tags?post=2784"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events_cat?post=2784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}