| 503 | 2021-01-26T05:00:00Z | <img alt="" src="/news/PublishingImages/student-workshops-spring-2021.png" style="BORDER:0px solid;" /> | Student Workshops for Spring 2021 | <p>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. </p><p><a href="https://forms.gle/1cFp52jYGGWKNymcA" target="_blank">Register in advance to receive the Zoom details for each event.</a>  Contact <a href="mailto:pragg@udel.edu">Sarah Pragg</a> with questions.<br><br></p> | <h3>Introduction to Survey Design and Analysis </h3><p><strong>Mon. March 1, 12:15 to 1:15 p.m.</strong></p><p>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.</p><p>View the <a href="https://capture.udel.edu/media/Student+WorkshopA+Introduction+to+Survey+Design+and+Analysis/1_qkjcf4dk" target="_blank">Workshop Recording</a>. View the <a href="/news/Documents/20210301SurveyworkshopBiden%20school.pdf?csf=1&e=hW3eAV" target="_blank">Workshop Slides​</a>.</p><h3>Excel: Calculations and Key Tools</h3><p><strong>Mon. March 8, 12:15 to 1:15 p.m.</strong></p><p>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.</p><p>View the <a href="https://capture.udel.edu/media/Student+WorkshopA+ExcelA+Calculations+and+Key+Tools/1_ent0as41">Workshop Recording</a>. <a href="/news/Documents/excel-functions-030821.xlsx">Download the Excel File</a>. </p><h3>Excel: Data Visualization</h3><p><b>Mon. March 15, 12:15 to 1:15 p.m.</b></p><p>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.</p><p>View the <a href="https://capture.udel.edu/media/Student+WorkshopA+ExcelA+Data+Visualization/1_vr70qipm">Workshop Recording</a>. <a href="/news/Documents/Excel-DataViz-031521.xlsx">Download the Excel File​</a>. </p><h3>Excel: Pivot Tables</h3><p><strong>Mon. March 22, 12:15 to 1:15 p.m.</strong></p><p>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.</p><p>View the <a href="https://capture.udel.edu/media/Student+WorkshopA+ExcelA+Pivot+Tables/1_meed5xfm" target="_blank">Workshop Recording​</a>. <a href="/news/Documents/pivot-table-workshop.xlsx" target="_blank">Download the Excel File.​</a></p><h3>The Art of the Cover Letter and Interview Prep</h3><p><strong>Mon. March 29, 12:15 to 1:15 p.m.</strong></p><p>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.</p><p><a href="https://capture.udel.edu/media/Student+WorkshopA+The+Art+of+the+Cover+Letter+and+Interview+Prep/1_2e5qt0kj" target="_blank">View the Workshop Recording.​​</a> View the <a href="/news/Documents/coverletter-interviews.pdf?csf=1&e=mMb3hG">Workshop Slides​</a>.</p><h3>Stata: Working with Multiple Data Sets</h3><p><strong>Mon. April 12, 12:15 to 1:15 p.m.</strong></p><p>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 <a href="/_layouts/15/FIXUPREDIRECT.ASPX?More=IPA&FName=student-workshops-fall2020.aspx&WebId=16ebe55b-c309-476f-80f4-adafc08430c6&TermSetId=ffea7d44-d746-4327-a9ac-2b17d9b38580&TermId=dc03c4c8-73cd-41c9-9cdc-aa772b40b59a&UrlSuffix=student-workshops-fall2020" target="_blank">previous workshops on Stata​</a> prior to attending this event. This workshop will be taught by Ellen Schenk.</p><p><a href="https://capture.udel.edu/media/Student+WorkshopA+Stata+Regression+Analysis/1_qgmna9oq">View the Workshop Recording​</a>. D​​ownload the Practice <a href="/news/Documents/Regression-Workshop.do?csf=1&e=d4fmPh">Do File​</a>, <a href="/news/Documents/Head-Start-Evaluation-Data.dta?csf=1&e=nNv4av">Practice Data</a>, and <a href="/news/Documents/Regression-Workshop.log?csf=1&e=JXidgs">Log File</a>.<br></p><p>Additional Stata resources: </p><ul><li><a href="https://data.princeton.edu/stata">Tutorials from Germán RodrÃguez, Princeton University​​</a></li><li><a href="https://stats.idre.ucla.edu/stata/modules/">UCLA Institute for Digital Research & Education Stata Learning Module​</a></li><li><a href="https://www.stata.com/links/video-tutorials/">Stata Video Tutorials</a></li><li><a href="https://www.princeton.edu/~otorres/Outreg2.pdf">Outreg2 Tutorial, Princeton University</a></li></ul><p>Learn regression:</p><ul><li><a href="https://www.hackerearth.com/practice/machine-learning/machine-learning-algorithms/beginners-guide-regression-analysis-plot-interpretations/tutorial/">Hacker Earth's Beginners Guide to Regression Analysis and Plot Interpretations​ ​</a>(Note: Uses Python for examples at the end, but still a great resource) <br></li><li><a href="https://towardsdatascience.com/the-complete-guide-to-linear-regression-analysis-38a421a89dc2">Towards Data Science</a><br></li><h3><ul><br></ul></h3></ul><span style="font-family:"segoe ui semilight", "segoe ui", segoe, tahoma, helvetica, arial, sans-serif;font-size:20px;font-weight:700;">​</span><span style="font-family:"segoe ui semilight", "segoe ui", segoe, tahoma, helvetica, arial, sans-serif;font-size:20px;font-weight:700;">​</span><span style="font-family:"segoe ui semilight", "segoe ui", segoe, tahoma, helvetica, arial, sans-serif;font-size:20px;font-weight:700;">The Geograp</span><span style="font-family:"segoe ui semilight", "segoe ui", segoe, tahoma, helvetica, arial, sans-serif;font-size:20px;font-weight:700;">hic Part of the Story – Maps, Map Apps and Story Maps</span><br><p><strong>Mon. April 26, 12:15 to 1:15 p.m.</strong></p><p>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.​<br></p><p>View the <a href="https://capture.udel.edu/media/Student+WorkshopA+The+Geographic+Part+of+the+Story+%e2%80%93+Maps%2c+Map+Apps+and+Story+Maps/1_alsnthhp" target="_blank">Workshop Recording</a>. Download the <a href="/news/Documents/AGOLStudentWorkshop_042621.pdf?csf=1&e=94t6YD" target="_blank">Workshop Slides</a>, <a href="/news/Documents/StepsforMakingMapandMapApps_IPAStudentWorkshop_GIS%20Training04262021.docx?csf=1&e=s1hVd9" target="_blank">Step-By-Step Process​</a>, and <a href="/news/Documents/Exceltable_example.csv?csf=1&e=c7SKdp" target="_blank">Excel Sample file​</a>.<br></p> | | | | | | | Hosted by the Institute for Public Administration | | | | | | | | <img align="right" alt="Student Workshops Spring 2021" src="/news/PublishingImages/student-workshops-spring-2021.png?RenditionID=4" style="BORDER:0px solid;" /> | | | | | | | | | | | | | | | | | https://www.bidenschool.udel.edu/news/Pages/student-workshops-spring2021.aspx | |
