Skip to main content

Upcoming Data and GIS workshops at Mann and Olin Libraries


Intro to ArcGIS
February 8, 2016;  2:00-4:00pm;  Mann Library, Stone Classroom
Learn the basics of mapping and geospatial analysis using ArcMap (ArcGIS), Esri’s desktop GIS application. We will work together through examples of loading common types of data, modifying the display styles, and performing some basic analysis.

Using Excel with Research Data: Formulas and Functions
February 24, 2016;  4:30-6:00pm;  B05 Uris Library Classroom
Much of Microsoft Excel’s data-crunching power lies in Excel functions and Excel formulas, which allow all sorts of data analysis, from simple sums to lookup tables and everything in between. In this one hour workshop, we’ll talk about some of our favorites, and then have hands-on practice building formulas and using Excel functions. We will also have time for you to bring your data and questions for personalized help.

Intro to QGIS
February 29, 2016; 2:00-4:00pm;  Mann Library, Stone Classroom
Learn the basics of mapping and geospatial analysis using QGIS, the popular open-source desktop GIS application. We will work through examples of loading common types of data, modifying the display styles, and performing some basic analysis.

Managing data to facilitate your research
March 8, 2016;  4:30-6:00pm; 112 Mann Library, CIT Lab
Learn how to manage data in order to facilitate research. Major funders are requiring data management plans with grant applications (including dissertation improvement grants!), and data management is equally important for the individual researcher trying to document and organize files, track scientific output, and perform quality control.

Using Excel with Research Data: Pivot Tables
March 9, 2016;  4:30-6:00pm;  B05 Uris Library Classroom
Sometimes it is difficult to analyze all of the information in your Microsoft Excel worksheet. PivotTables can help make your worksheets more manageable by summarizing data and allowing you to manipulate it in different ways. In this workshop, we’ll have hands-on practice using a pivot table to manipulate and summarize a dataset so that you’ll leave with a greater understanding of how and when to use this handy tool with your data.

Data Cleaning: an Introduction to OpenRefine
March 15, 2016;  2:00-4:00 pm; Mann Library, Stone Classroom
Got messy data? OpenRefine is a free and powerful tool for exploring, normalizing, and manipulating tabular data. This introductory workshop will teach you the basics of OpenRefine, including how to import data, discover and clean up inconsistent values, reformat dates, and expand values into multiple columns.

Data Documentation: An Introduction to Science Metadata
March 22, 2016;  4:30-6:00pm;  112 Mann Library, CIT Lab
How do you describe your digital data and document the steps you take to analyze it? Are your files sufficiently organized and have you created the metadata so that others can interpret what you’ve done? What about yourself, three months from now? This workshop will offer some best practices and strategies to adopt in order to organize and describe your science research data for yourself and others.

Using Excel with Research Data: Macros
March 23, 2016;  4:30-6:00pm;  B05 Uris Library Classroom
Macros in Excel enable you to automate a repetitive task so that you can do the task again with a single click. During this workshop, we’ll teach you how to record a macro and introduce you to the Visual Basic Editor for more advanced macro programming. You’ll leave with a greater awareness of when macros might be useful, as well as hands on practice creating macros, and resources to continue your learning.

Data Cleaning: Advanced OpenRefine
April 5, 2016;   2:00-4:00 pm; Mann Library, Stone Classroom
Building on the basic capabilities of OpenRefine, join us in exploring advanced data manipulation using GREL, joining tables, installing extensions, and reconciling and enhancing data using local or remote services.

Introduction to Tableau Public

April 8, 2016;  10:00-11:30am;  B05 Uris Library Classroom
Tableau Public is a free data visualization tool. It requires no plug-ins and no API. You can create interactive graphs, dashboards, maps and tables from virtually any data. The tool includes a free desktop product that you can download and use to publish interactive data visualizations to the web.

Data Publishing: How to get your data out there for others to find and use
April 12, 2016;   4:30-6:00pm;  Mann Library, Stone Classroom
Data journals, data sharing policies, institutional and subject repositories:… Are you confused about how to maximize your research data’s potential? In light of developing funder requirements around public access to data, researchers need to have a strategy for publishing their data. So what data should you share, where can you put it, and what should you think about when doing so? During this workshop, we’ll discuss eCommons (Cornell’s digital repository), some other sharing strategies, and will introduce a set of criteria upon which to base your decision.

Intro to CartoDB
April 14, 2016;  2:00-4:00pm;  Mann Library, Stone Classroom
An introduction to CartoDB, a popular online tool for mapping and analysis. Learn how to set up a free account, load data, and quickly make maps in a variety of styles.

Introduction to ArcGIS I
April 15, 2016;  10:00-11:30am;  B05 Uris Library Classroom
This workshop will familiarize you with some of the basic concepts and features of ArcGIS and some fundamentals of GIS mapping and analysis. You will work with map layers and attribute data tables for U.S. states, counties and cities. You will learn where and how to get the necessary data. You will also learn how to build a map from existing GIS data.

Introduction to ArcGIS II
April 22, 2016;  10:00-11:30am;  B05 Uris Library Classroom
Prerequisite: Session I on November 13th. You will learn to create, import and display coordinates, import and join data spreadsheets and other advanced features of the software, e.g. tabular editing with the field calculator, geocoding and georeferencing, and conversion of KML format files to ArcGIS.

Consultation Hours

RDMSG Online Office Hours: The Research Data Management Service Group consultants are available to answer data management questions during online office hours,  Monday-Friday from 2:00-3:00 PM.  The RDMSG is also available for longer consultations, either in-person, or via email or telephone.

GIS Help Desk: Mann Library offers walk-in help at the GIS Help Desk, located in the consulting area just outside Stone Classroom. Open Monday-Friday, 2-4pm, when classes are in session.  If the weekday afternoon hours are not convenient for you, please request a one-on-one consultation to fit your schedule. Mann Library also offers online tutorials in GIS.


Print Friendly, PDF & Email


Comments are closed.