Upcoming Data, GIS, and Mapping workshops

Data Documentation: An Introduction to Science Metadata
October 26, 2015  3:00-4:30pm
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: Formulas and Functions
October 27, 2015,  4:30-5:30pm
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.

Cleaning up Data: an Introduction to OpenRefine
November 3, 2015  2:00-4:00pm
OpenRefine is a free and powerful tool for exploring, cleaning up, 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, expand values into multiple columns, and bring in additional data from other sources.

CartoCamp Cornell
November 5, 2015 throughout the day
A day of CartoDB, the web mapping and analysis platform.  Join us for a single workshop, or stay for the whole day!  We'll begin with an overview and introductory workshop in the morning, followed by discussion and a slightly more advanced workshop in the afternoon.  Sessions will be led by Andy Eschbacher and Mamata Akella of CartoDB.  Register now to assure a seat at any or all of the sessions.  We will contact registrants with the full schedule as soon as it is finalized.

Data Publishing: How to get your data out there for others to find and use
November 9, 2015   3:00-4:30pm
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.

Using Excel with Research Data: Pivot Tables
November 10, 2015  4:30-6:00pm
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.

Introduction to ArcGIS I
November 13, 2015  10:00-11:30am
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.

Geospatial Analysis, Geo-Communications
November 19, 2015  2:00-4:00pm
Join Joseph Kerski of Esri as we explore methods and investigate topics in human health, natural hazards, population change, land use, and more, from local to global scale, using spatial analysis tools in ArcGIS Online, a powerful and easy-to-use web-based Geographic Information Systems platform.  We will also explore how to communicate the results of your research using web mapping applications, including storymaps, where you can merge audio, video, narrative, graphs, and live web maps, and share your results with your research group or with the world.

Introduction to ArcGIS II
November 20, 2015  10:00-11:30am
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.

Using Excel with Research Data: Macros
November 24, 2015  4:00-5:30pm
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.


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:30-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.