MDL Tutorials

In this tutorial, we will use the Postal Code Conversion File (PCCF) to match postal codes to dissemination areas in order to incorporate additional neighbourhood-level demographic data into your dataset.

In this tutorial, we will use the Postal Code Conversion File Plus (PCCF+) to match postal codes to dissemination areas in order to incorporate additional neighbourhood-level demographic data into your dataset.

NVivo can handle many types of files, such as text, audio, videos, images, etc. You would import these from the Data menu, by choosing the appropriate option. However, this tutorial will show you two common sources of data that you might want to code in NVivo that are a bit more complicated to import.

NVivo can handle many types of files, such as text, audio, videos, images, etc. You would import these from the Import Ribbon, by choosing the Files option. However, this tutorial will show you two common sources of data that you might want to code in NVivo that are a bit more complicated to import.

To get started with intermediate R, enroll in this Intermediate R quercus course here. To enroll, you will need to use your UTORid login. This course consists of demonstration videos. By enrolling in this course, you can keep track of your progress! If you are a member of the public and you do not have a UTORid login, you can access the videos in the following guide below. 

This is a beginner to intermediate level tutorial for Excel, a popular spreadsheet software that allows you to organize, modify and analyse your data. This tutorial assumes you have used Excel before at a basic level, but haven’t explored all it has to offer. The goal is to show you alternate ways to do things you already know how to do, as well as help you pick up some new Excel skills.

This tutorial wil guide you through many of the Excel tools available including: data types, filtering, transposing, formulas, formulas, functions, nested functions, charts, and pivot tables. There are no prerequisites or assumptions of knowledge of math, statistics, or programming.

Before you begin, make sure you have Excel installed. UofT members can download Excel as part of Microsoft Office 365.

Note: This workshop works with Excel with Microsoft 365 for Windows – if you are using an older version or Excel for Mac, availability and location of some features may differ – a quick Internet search will usually reveal the steps to access a feature in a particular version.

This tutorial is intended for Mac users. If you are using Windows, check out this tutorial instead.

This tutorial is adapted from a recorded Excel workshop, which you can view here.

This is a beginner to intermediate level tutorial for Excel, a popular spreadsheet software that allows you to organize, modify and analyse your data. This tutorial assumes you have used Excel before at a basic level, but haven’t explored all it has to offer. The goal is to show you alternate ways to do things you already know how to do, as well as help you pick up some new Excel skills.

This tutorial wil guide you through many of the Excel tools available including: data types, filtering, transposing, formulas, formulas, functions, nested functions, charts, and pivot tables. There are no prerequisites or assumptions of knowledge of math, statistics, or programming.

Before you begin, make sure you have Excel installed. UofT members can download Excel as part of Microsoft Office 365.

Note: This workshop works with Excel with Microsoft 365 for Windows – if you are using an older version or Excel for Mac, availability and location of some features may differ – a quick Internet search will usually reveal the steps to access a feature in a particular version.

This tutorial is intended for Windows users. If you are using a Mac, check out this tutorial instead.

This tutorial is adapted from a recorded Excel workshop, which you can view here.

Constellate is a browser-based tool for creating datasets from collections, such as JSTOR, and then teaches and facilitates text analysis on those datasets.

Return to the main Gale Digital Scholar Lab tutorial

Here is how to collaborate between users in the Gale Digital Scholar Lab using the Workspace and Notes features. This allows for a shared workspace and options for documenting your steps.

Python is a simple programming language that is popular for being easy to learn to read, write, and understand. You can use Python for automating repetitive tasks like cleaning data, creating data visualizations, analyzing data, conducting complex statistical calculations, or even building machine learning algorithms. Its ease of use and versatility means that many tools have been built on top of Python, but being able to explore those requires a good foundation and understanding of the language itself first!

UofT currently subscribes to NVivo 12. Consult our NVivo software license page to request a license key. Consult our getting started guide for NVivo 12 for tutorials, resources, and workshop recordings to help you get started using the software.

If you have an audio or video file that you need to get transcribed, this page describes some automated options to consider. But keep in mind, though, that none of these options (including NVivo transcription) provides a 100% perfectly accurate transcript. You will always have to go back in and correct your transcript.

Note: If you want to pay a human to transcribe things accurately (so no or minimal correction is needed later), you could try Rev or Transcript Divas.

This page provides an overview and tips for working as a team using NVivo.

This tutorial will help you get up and running querying the Canadian Intellectual Property Office (CIPO) Patent PostgreSQL Database. It will cover accessing the high performance computing environment, querying the database via SQL statements and from within a python script, and downloading the results of the query.

You will need a Compute Canada account with the proper credentials to access this database. If you haven’t done so already, you should first follow the instructions to get your account set up.

Note: This tutorial is intended for Windows users. If you are using a Mac, check out this tutorial instead.

This tutorial will help you get up and running querying the Canadian Intellectual Property Office (CIPO) Patent PostgreSQL Database. It will cover accessing the high performance computing environment, querying the database via SQL statements and from within a python script, and downloading the results of the query.

You will need a Compute Canada account with the proper credentials to access this database. If you haven’t done so already, you should first follow the instructions to get your account set up.

Note: This tutorial is intended for Mac users. If you are using Windows, check out this tutorial instead.

Learn the basics of GIS with open source software, QGIS (https://qgis.org). This tutorial/workshop is made up of three modules.

• Module 1. Getting started
• Module 2. Making a map using layouts
• Module 3. Manipulating geospatial datasets

Download the datasets used for this workshop at this location: https://maps.library.utoronto.ca/workshops/QGIS/2022/QGIS.zip

Note that while the examples shown in this tutorial were captured using the windows version of QGIS, all modules and operations can be completed using the linux or mac OS version of QGIS.

For a gentle and thorough introduction to R, enroll in this Introduction to R quercus course here. To enroll, you will need to use your UTORid login. This course consists of demonstration video, activity and quizzes. By enrolling in this course, you can keep track of your progress! If you are a member of the public and you do not have a UTORid login, you can access the videos in the following guide below. 

This is a beginner level tutorial for NVivo 12 for Mac. The goal of this tutorial is to learn about the basic features in NVivo that will allow you to organize and analyze qualitative data. Part 1 will go over the basics of navigating the NVivo interface, importing data, and coding with nodes. Part 2 will explore the different types of queries you can run in NVivo. If you already have a grasp of the basics and are just interested in learning about queries, you can jump right to Part 2.

This tutorial outlines the steps taken in the demonstration during the live workshop on an Introduction to Data Visualization Using Tableau Desktop. This is a companion tutorial, but can also be used as a stand-alone introduction to Tableau Desktop.

This is a beginner level tutorial for NVivo 12 for Windows. The goal of this tutorial is to learn about the basic features in NVivo that will allow you to organize and analyze qualitative data. Part 1 will go over the basics of navigating the NVivo interface, importing data, and coding with nodes. Part 2 will explore the different types of queries you can run in NVivo. If you already have a grasp of the basics and are just interested in learning about queries, you can jump right to Part 2.

SimplyAnalytics is a web-based data visualization application that can be used to create simple thematic maps and support analyses of socio-demographic data. This tutorial introduces SimplyAnalytics and its capabilities with the help of videos produced by our colleagues at UTSC.

ArcGIS Pro is a desktop GIS software developed by Esri and is intended to replace ArcMap. 

ArcGIS Online is a web-based mapping software that allows you to build, share, and access interactive web maps.

ArcGIS StoryMaps is an online storytelling tool that allows users to craft and publish powerful narratives using maps.