Spreadsheets for Humanities

The Doctoral College

Basic principles of how to organise such data in a spreadsheet to improve efficiency and accuracy

<h2>Intended audience</h2><p>PGRs and staff conducting, or supporting, research in humanities and qualitative social science.</p><h2>Prerequisite</h2><p>Please have either Excel, Google Sheets or Libre Office available on your computer.</p><h2>Learning objectives</h2><p>This session will help you to:</p><p>· Understand the principles of ‘Tidy data’</p><p>· Organise your material in a data table format</p><p>· Deal with some common formatting issues</p><p>· Ensure data quality</p><p>· Share and back-up your spreadsheet.</p><h2>Course overview</h2><p>Do you keep information in a spreadsheet, but are never quite sure if you are doing the right thing? This is the class for you!</p><p>Researchers in humanities and qualitative social science often end up using spreadsheets, even if they don’t intend to use any statistical methods later on. This could be to keep information about museum objects or archaeological finds, data abstracted from historic documents about people and places, summaries of interviews or photographs, records from library catalogues and so on.</p><p>In this practical class, we look at some basic principles of how to organise such data in a spreadsheet to improve efficiency and accuracy. We will also look how to share spreadsheets and how to ensure long-term access to your data.</p><p><strong><strong>Please note</strong></strong>: this is not a course on using Excel. Digital Services recommend this course for Excel users: <a href="https://uniofleicester.sharepoint.com/sites/University-Training/SitePages/Excel-take-time-to-learn.aspx" title="https://uniofleicester.sharepoint.com/sites/University-Training/SitePages/Excel-take-time-to-learn.aspx" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">https://uniofleicester.sharepoint.com/sites/University-Training/SitePages/Excel-take-time-to-learn.aspx</a></p><p>It is also not a course in statistics or data visualisation.</p><p><strong><strong>Trainer</strong></strong></p><p>Dr William Farrell, Library Research Services</p>

Choosing Where to Publish

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Spreadsheets for Humanities

More events from The Doctoral College

Discover more events from The Doctoral College, from Science & Tech to other experiences you might love.

Choosing Where to Publish

Spreadsheets for Humanities

More events from The Doctoral College

Discover more events from The Doctoral College, from Science & Tech to other experiences you might love.

Choosing Where to Publish

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.