Student Workshops for Spring 2021

Every semester, the Institute for Public Administration (IPA) offers a selection of workshops open to Biden School students. These workshops offer professional development opportunities focused on technical skills. Recordings and workshop material will be posted to this story after each event. 

Register in advance to receive the Zoom details for each event.  Contact Sarah Pragg with questions.

Introduction to Survey Design and Analysis

Mon. March 1, 12:15 to 1:15 p.m.

In this introduction to survey design, learn best practices for writing survey questions to ensure valid and reliable results. Participants will explore how choosing a question type (i.e., multiple-choice, Likert scale) will impact the experience of analyzing the results. This workshop will be taught by Tibor Toth.

View the Workshop Recording. View the Workshop Slides​.

Excel: Calculations and Key Tools

Mon. March 8, 12:15 to 1:15 p.m.

In this intermediate-level Excel workshop, learn how to use functions, formulas and other tools instead of manual calculations. This workshop will be taught by Ellen Schenk and Sarah Pragg.

View the Workshop Recording. Download the Excel File.

Excel: Data Visualization

Mon. March 15, 12:15 to 1:15 p.m.

In this intermediate-level Excel workshop, learn how to create charts and customize their appearance. This workshop will be taught by Ellen Schenk and Sarah Pragg.

View the Workshop Recording. Download the Excel File​.

Excel: Pivot Tables

Mon. March 22, 12:15 to 1:15 p.m.

In this intermediate-level Excel workshop, learn how to create a pivot table, sort and filter the data, and add calculated fields. This workshop will be taught by Ellen Schenk.

View the Workshop Recording​. Download the Excel File.​

The Art of the Cover Letter and Interview Prep

Mon. March 29, 12:15 to 1:15 p.m.

Learn how to craft a cover letter to make your application stand out from the stack. This session will also cover tips for preparing for interviews. This workshop will be taught by Adam Helgeson, Career Counselor, UD's Career Center.

View the Workshop Recording.​​ View the Workshop Slides​.

Stata: Working with Multiple Data Sets

Mon. April 12, 12:15 to 1:15 p.m.

Building on the tools learned last semester, this Stata workshop will explore cleaning data sets and running regression analysis on multiple years of data. We recommend that you review previous workshops on Stata​ prior to attending this event. This workshop will be taught by Ellen Schenk.

View the Workshop Recording​. D​​ownload the Practice Do File​, Practice Data, and Log File.

Additional Stata resources:

• Tutorials from Germán Rodríguez, Princeton University​​
• UCLA Institute for Digital Research & Education Stata Learning Module​
• Stata Video Tutorials
• Outreg2 Tutorial, Princeton University

Learn regression:

• Hacker Earth's Beginners Guide to Regression Analysis and Plot Interpretations​ ​(Note: Uses Python for examples at the end, but still a great resource) 
  
• Towards Data Science
  

Mon. April 26, 12:15 to 1:15 p.m.

In this introduction to Esri's ArcGIS Online, you will learn to access data, take an excel table to create a data layer, and create a map. Then you will learn how to take that map and create different kinds of mapping applications, such as a simple basic viewer and more complex story maps. Participating students will gain access to UD's ArcGIS Online Organizational Account. This workshop will be taught by Nicole Minni.​

View the Workshop Recording. Download the Workshop Slides, Step-By-Step Process​, and Excel Sample file​.