Tutorials

Help is on the Way

The following are tutorials on the basics of data collection, structuring, and data analysis, recorded at the DigiLab. (For links to resources used here, as well as many others, visit our Resources page!)

Data Visualization Tutorials

Instructor: Kyle Vanderniet

Handout
  • Use this handout to follow along with Kyle’s Excel videos.
Sample Data
  • Use this data to work alongside Kyle.
Videos

Excel Basics 1

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.

Excel Basics 2

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.

Conditional Formatting

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.

Pivot Tables

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.

Google Sheets
  • Watch this video for help with Google Sheets

Excel Guide Book

This user-friendly guide book created by Joey Stanley covers a wide range of topics, including: (1) different versions of Excel; (2) the absolute basics; (3) useful techniques like search & replace and sorting & filtering; (4) the awesome power of pivot tables; (5) getting started with functions; (6) lookup tables; (7) visualizations and how to make some simple graphs and charts; and (8) some miscellaneous little tips and tricks.

Data

Use the sample datasets below to follow along.

 *These datasets came from the Linguistics Atlas of the Gulf Seas and Cowlitz Country.

Instructor: Keith Knop

Handout
  • Use this handout to learn about OpenRefine.
Data

*OpenRefine is a free, 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.

Basic and Advanced R Series
Instructor: Joey Stanley
Introduction to R

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.

Visualizations I: Introduction to ggplot2

This will cover some of the basics of visualization including the following topics: (1) general concepts relating to data visualization, software, and data types; (2) download and installation; (3) plotting two continuous variables as a scatterplot; (4) plotting one variable as a bar plot or a histogram; (5) plotting one continuous variable and one categorical variable as a boxplot or a violin plot; and (6) where to go for help with ggplot2.

Visualizations II: Customizing Plots in ggplot2

We unfortunately do not have a recording for part 2 of ggplot2. If you are interested in some intermediate content regarding ggplot2, This handout will cover additional topics in ggplot2 that let you customize plot in various ways: (1) adding and changing titles and axis labels; (2) custom colors; (3) renaming and reordering things; (4) legends; (5) faceting; (6) themes; and a custom section on saving plots.

Building Interactive Webpages in R: Introduction to Shiny Part 1

This video covers some of the basics of the Shiny package built in R. We unfortunately did not get the second part recorded but everything for both parts can be found online. Since Shiny is used for web applications and can be dynamic, Joey decided to make this tutorial a web page so you can see shiny in action.

Communicating to Your Audience with R Markdown

This will cover these introductory topics: (1) an introduction to the tool and why it might be handy; (2) the “narrative” or the non-code portion of the document and how to format it; (3) inserting code and how to modify code block; and (4) output formats and ways to modify how the final document looks.

Clean and Tidy Data: Tidyverse Part 1

This is the seventh installment of the R workshop series in Spring 2018, and the first of two workshops that introduces the tidyverse suite of packages. This document will cover introductory topics in dplyr, tidyr, forcats, stringr, readr, and readxl that let you clean and tidy your data in various ways: (1) an introduction to the suite of packages; (2) getting data into R from various formats and saving data to your computer; (3) reordering and removing
columns using select, with a tangent into the “pipe” (%>%); (4) creating new columns and modifying existing ones with mutate; and (5) miscellaneous functions like filter for subsetting and rename for renaming columns.

Reshaping and Transforming Your Data: Tidyverse Part 2

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.

Text Analysis in R

Instructor: Katie Kuiper, PhD Candidate in Linguistics

For information about how to conduct text analysis in R, see Katie’s two series in Text Analysis Tutorials below.

This series of workshops will demonstrate how to create basic visualizations using Excel, Tableau Public, and RStudio.
Each platform can create the graphs, charts, and visualizations below, though each has their own method and differs in complexity, aesthetics, and learning curve. Choose the one that best fits your skills and your needs. The handouts and data used for each workshop session are listed below.

 

Make sure you have Tableau Public and RStudio installed and refer to our tutorials for installing and getting started if you need help.

 

Instructor: Katie Kuiper
Intro to data visualization resources at UGA and beyond
Bar graphs and histograms in Excel, Tableau, and R

*Download here is in xls format, save it as csv for use with Tableau and R. Dataset from Kaggle.

Scatterplots in Excel, Tableau, and R
Data*

*Downloads are in xls format, save it as csv for use with Tableau and R

Area Graphs in Excel, Tableau, and R
Data*

*Downloads are in xls format, save it as csv for use with Tableau and R

Spring into Research Presentation

Instructor: Katie Kuiper and Keiko Bridwell, PhD candidates in Linguistics

While not part of the Data Visualization Workshop Series, this presentation gives an overview of Excel, Tableau, and R; guidelines for approaching data visualization, and links to many websites and books that provide more information about ways to present data!

Creating Graphs

Here you can find information about how to organize your data and begin plotting it in Excel and R, as well as online options for creating graphs.

Tableau Tutorial

For written instructions on how to use Tableau Public, click the link above.

Network Tools

Working with data that explores the connections between individuals?  The tutorial at the link above explains the basics of network analysis, how to prepare your data to visualize it as a network, and how to use the Cytoscape software to create those images.

Text Analysis Tutorials

Text Corpora That You Can Use

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

Big Data: Text Mining

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.

Advanced Text Mining

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.

Text Analysis Series 1

Instructor: Katie Kuiper, PhD Candidate in Linguistics

To follow along with Katie, download the sample data below, as well as the code provided under each workshop. R Studio is free and available for download here.

Data
Text Analysis Workshop: Text Analysis Resources
Text Analysis Workshop: Jupyter Notebooks and Python
Text Analysis Workshop: R for Text Analysis
Text Analysis Workshop: Advanced R for text Analysis
Text Analysis Series 2

Instructor: Katie Kuiper, PhD Candidate in Linguistics

Text Analysis 101: Text Analysis Basics
Text Analysis 101: Text Analysis for Literature and Beyond
Text Analysis 101: Creating your own Social Media Corpus
Text Analysis 101: Analyzing Social Media

Text Analysis Methods and Tools

If you’re interested in looking at patterns within a text, this tutorial provides an introduction to Voyant Tools and topic modeling.

Mapping Tutorials

GIS Tutorials

To learn how to set up and format your data for mapping, check out Meagan Duever’s step-by-step tutorials on how to use the QGIS app.  Additional GIS tools and references are also provided!

Mapping Methods and Tools

Need to visualize geographic data?  Here you can find a list of tools for mapping and spatial analysis, including story maps, interactive web mapping programs, and desktop programs.

Templates

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

Intro to LaTeX materials

 

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

Advanced LaTeX handout

Outside Resources

A directory of different lessons on R, JavaScript, Python, mapping and more, tailored to the humanities.

Digital Text Methods site that offers tutorials, programming scripts etc for analyzing text.

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.