Help is on the Way
The following are tutorials on the basics of data collection, structuring, and data analysis, recorded at the DigiLab.
The following are tutorials on the basics of data collection, structuring, and data analysis, recorded at the DigiLab.
Instructor: Kyle Vanderniet
Kyle starts this series off by explaining the very basics and how to navigate through Excel. He goes over how to insert, copy, paste, drag, fill your data. Most people will know how to do this, but it is important to assure that everyone is on the same page before continuing throughout this website.
Kyle covers some more advanced topics on how to control the layout and structure of your data. Alignment, merge, filter, sorting, fill, color, and size are some of what Kyle dives into. He makes sure that the viewer has a good understanding of the different menus and the data tab in Excel to give the user more control over their workbooks.
Kyle uses this subject of conditional formatting to introduce the viewers to the logic of formulas that are discussed, specifically in the following video. He covers some of the most commonly used formulas (IF, SUM. COUNT, TRIM, VLOOKUP, CONCATENATE, DAYS, NOW, TODAY, ROUND, ETC). Also, Kyle breaks these down so learning how to nest certain functions makes more sense.
Functions and Nested Functions
Kyle introduces more functions and how to nest them inside another. This is one of Excel’s most powerful abilities and Kyle wants to help you grasp the concept. This ability is good for not only academia, but also the job market.
Excel’s most powerful feature are pivot tables. Kyle introduces them and teaches the viewer how to manage them. This feature allows the user to view and pull data in a new way. This topic is advanced, but well worth knowing if you are working with a lot of different data in Excel.
Instructor: Keith Knop
*OpenRefine is a free, and open source tool similar to Excel as in it can house your data along with cleaning, transforming, and extending it with web services. Keith goes through how to navigate, add, and clean existing data.
Learn R’s syntax, how to make variables, and basic functions. Learn to import multiple file types to be able to filter and extract portions of your data. Lastly where to go for help, both in R and on the internet. If you need assistance on downloading R and RStudio, here is Joey’s Handout
This is the ninth installment of the R workshop series in Spring 2018 and the second workshop that introduces functions from the “tidyverse.” This document will cover these introductory topics: (1) loading the familiarizing yourself with the data used in this workshop; (2) various ways of merging datasets together; (3) summarizing your data by group; and (4) reshaping your
data from tall to wide and vice versa.
*Downloads are in xls format, save it as csv for use with Tableau and R
*Downloads are in xls format, save it as csv for use with Tableau and R
Contact digi@uga.edu for the zoom link for future sessions.
Instructor: John Hale, Arch Professor of Linguistics
A growing collection of natural language corpora is now available to the UGA community. This colloquium offers a live demonstration of the search tool cqp, showing how corpora that are available right now may be used to address questions about how people use language, what words mean, and how authors achieve their literary ends. For access to the corpus server, email linglab@uga.edu
Instructor: Kyle Vanderniet PhD candidate in Linguistics
This tutorial offers an introduction to the Kucera server and a variety of corpora. Participants will explore these corpora to find new ideas about language use and about using big data in humanities research.
Instructor: Kyle Vanderniet PhD candidate in Linguistics
This session quickly reviews text queries in both CQP and Bash shell then sure how to sort, count, save, extract your date so that you can manipulate it with the program of your choice.
Make writing your thesis or dissertation easier with our LaTeX template which is approved for use by UGA’s graduate school.
New to LaTeX? See our series of workshops
Introduction to LaTeX
How to best use LaTeX and learn its syntax and logic.
Video recording
The UGA LaTeX Template
How to apply the UGA LaTeX template to your thesis or dissertation.
Video recording
Template and additional materials
Advanced Topics in LaTeX
Customize and use LaTeX for your own discipline.
Video Recording
Curated by Alan Liu, the DH Toychest offers a list of DH tools, sample datasets for practice, tutorials, and a wealth of other information and resources.
Let us know if you need additional help or would like to see a different kind of tutorial in the future.