MDL Tutorials
This guide helps you get started with the R and RStudio software and R code. You can install R from the R homepage. And you can install RStudio from the RStudio homepage. A more thorough introduction to the R language is covered here.
This guide helps users get started with writing a SAS program/code for RTRA purposes.
This tutorial introduces Gale's Digital Scholar Lab (DSL), a digital humanities tool. In this tutorial, you will learn how to:
- Build a collection of texts, including uploading your own materials
- Create collaborative workspaces
- Clean texts
- Run analytical tools on texts and visualize the results
- Download the data, graphs, and other visualizations produced through this tool
- Download the scanned texts in your collection, so that you can use them in other programs
- Find additional training and resources
Note: Gale periodically updates the Digital Scholar Lab, so some features of this tutorial might not always match the latest interface. This tutorial was last updated in March 2023.
This tutorial goes over how to download, install, and license ArcGIS Pro with your UTORid.
Please be advised that ArcGIS Pro and ArcGIS Desktop (including ArcMap) are also available on library computers on the St George campus.
This tutorial provides an opportunity to learn data visualization skills using a common data visualization tool, Tableau Desktop. People often say that they learn better when using data that resonates with them, so we are using COVID-19 data in this tutorial, as this topic is touching many people’s lives right now.
This is a beginner-to-intermediate level tutorial for Tableau Desktop version 2020.2. To acquire a free student, researcher, or instructor license for Tableau Desktop, please follow these licensing and installation instructions. If you want to learn this material in an online, self-paced course, with video instructions, you can self-enroll in our Practice with Tableau course.
This is a guide to installing and running Tableau Desktop on your personal computer. Please note that all computers in the Map and Data Library (on the fifth floor of Robarts) and in the computer labs on the fourth and fifth floors of Robarts Library already have Tableau Desktop installed.
This tutorial is an introduction to Piktochart, a popular online tool used to create infographics. This exercise will illustrate some infographic design principles and specific features of Piktochart to create an infographic about comparing housing in Vancouver vs Toronto. To complement this tutorial, you may want to explore the online self-paced course on Infographic Design.
In this tutorial, we will begin work on augmenting datasets.
Note: This is an advanced tutorial. If you are new to OpenRefine, please begin with OpenRefine tutorial 1. This tutorial has been developed for OpenRefine version 3.7.5
This tutorial will teach you how to use OpenRefine's reconciliation service to connect data in your dataset with Wikidata.
Note 1: Complete Augmenting activity 1 first before attempting this activity.
Note 2: In order to complete this activity, you need to be running the latest version of OpenRefine.
This tutorial has been developed for OpenRefine version 3.7.5
Update: please note that as of March 18, 2020, Open Data Toronto has suspended service and so their service is not available for API calls. Until service resumes, please skip step 3, and during step 5, please chose to Get Data From: This Computer and select the 311.json file in the packaged workshop files. This represents a snapshot of the data that will work with the exercises. Please feel free to email mdl@library.utoronto.ca if you run into difficulties.
Sometimes you don't have your data in a file. Instead you want to use an API call to pull data from elsewhere. OpenRefine can help you make these calls and parse the data you receive.
The goal of this activity is to create a new project by pulling in 311 call data from the City of Toronto into OpenRefine using an API call and then work with the data. You will construct an API call to download a subset of 311 call data in JSON format, and then use OpenRefine to parse that data and put it into a tabular format. You will then use GREL to further manipulate the data (especially working with date formats) and make some discoveries.
Note: This assumes that you have learned the basics of OpenRefine already through the Survey of Household Spending activity and the Citizen Science activity. This also assumes that you have a basic understanding of APIs and JSON. The 311 JSON dataset can be found in the sample data in case the API call does not work.
This tutorial has been developed for OpenRefine version 3.7.5
You were introduced to GREL in the previous activity, so you know that GREL is a powerful tool for cleaning/editing your data. You can make GREL even more powerful by learning how to use regular expressions (aka regex). A regular expression is a sequence of characters that define a search pattern – it is used to search for matches within text. In OpenRefine, you can use it in your GREL expressions to create sophisticated patterns describing what type of information you want to find within your dataset, then do something with the matching text (edit it, delete it, put it in a new column, etc.).
This activity assumes you have already completed the Survey of Household Spending and Citizen Science activities, have a familiarity with OpenRefine and know how to create simple GREL expressions. Before you begin, please download the OpenRefine workshop sample datasets, if you have not already.
This guide is suitable for new Tableau users looking for information on producing popular data visualizations in Tableau, such as bar graphs, line graphs, scatterplots, tree maps, and dashboards. If you are looking for more general data visualization tips, please see the Map and Data Library's Data Visualization Guide. You can find instructions on installing and acquiring a free academic license for Tableau here. If you are running Tableau on a Mac, please note that there may be some variation between the Windows version used to design this guide and the program as it appears on a Mac.
The data used in this guide are public datasets retrieved from the World Bank’s Open Data repository, the United Nation's Open Data Population Division, and the full text of Shakespeare's Romeo and Juliet available through MIT's website, with a frequency table generated through Voyant Tools. You can find more information regarding the data sources used in this guide in the subsection entitled "10. Data Sources".
This tutorial was created using Tableau Desktop version 2020.2.
This tutorial has been developed for OpenRefine version 3.7.5
We are going to work with a bit messier dataset now for the next few tasks. This is a citizen science dataset captured using an app called iNaturalist. The data was captured for a city nature challenge and shared on data.world. This activity will showcase some more features in OpenRefine.
The goal of this activity is to create a new project with this citizen science dataset and work with the data. You will use clustering to improve the consistency of the dataset. You will also perform various manipulations, such as split and concatenate. Finally, you will learn various ways to remove columns and rows, and work with the Undo/Redo features in OpenRefine.
Before you begin, please download the OpenRefine workshop sample datasets, if you have not already.
Note: This assumes that you have learned the basics of OpenRefine already through the Survey of Household Spending activity.
This is a guide to installing and running OpenRefine on your personal computer. Please note that all computers in the Map and Data Library (on the fifth floor of Robarts) and in the computer labs on the fourth and fifth floors of Robarts Library already have OpenRefine installed.
This tutorial has been developed for OpenRefine version 3.7.5
Please note that we also have converted some of this tutorial into a self-paced course with videos. U of T students, staff, and faculty can enroll in our OpenRefine Quercus course.
This is the first activity in this tutorial series, and assumes no prior knowledge of OpenRefine. In this activity you will be importing a spreadsheet of data into OpenRefine and exploring it. The goal of this activity is to use a simple dataset to introduce you to the OpenRefine user interface and some of the basic types of tasks you can accomplish. This dataset isn’t particularly “messy,” but provides some of the core knowledge needed to work with messier datasets in later activities.
If you need a copy of OpenRefine on your personal computer, please follow these installation instructions.
Before you begin, please download the OpenRefine workshop sample datasets.
This tutorial will help you install ArcGIS Pro on your Windows operating system offline (not connected to the internet). Authenticating ArcGIS Pro in this way will require relicensing each year. Almost all UofT users prefer to authenticate ArcGIS Pro using the UTORid/online method. Please follow the Licensing ArcGIS Pro instructions for this method.
Before beginning the installation process please request a license code. If you are a Mac user, please read this page about running Windows in OS X before requesting a code.
Link to a video tutorial on how to find statistics and manipulate tables to get the data you need.
This tutorial will take you through two ways of logging in to your ESRI ArcGIS Online account for the first time using your UTORid.
This tutorial provides an overview of the Online version of ArcGIS, one of ESRI's many mapping tools.
ArcGIS Online is a complete, scalable and secure software-as-a-service cloud-based mapping platform which can be used to make and share maps.
This tutorial covers two methods for clipping raster datasets from ArcMap.
This tutorial will cover how to download census data and census boundary files and matching them together in ArcMap for further analysis. Census data will be downloaded using CHASS.