PubPol 647

PubPol 647: Excel for Public Policy

Winter 2022
Tuesday, Thursday
4:00-5:20 pm EDT
Course Location
3117 Weill Hall
Course Section
U-M Course Number
Credit Hours

This course is an accelerated introduction to a variety of Public Policy research and analysis-related skills in the Microsoft Excel environment. This course is designed to familiarize students with core skills in data access, manipulation, analysis, and presentation using Excel (and Excel-like alternatives). Spreadsheet programs remain an important part of professional life, and this course will prepare students for basic and intermediate use of aspects of the program in that setting.

This course covers data import, formatting, and management. Analysis topics include: producing tables (including summarization), visualizations, varieties of statistical analysis (ANOVA, regression, etc.). The course is graded credit/no credit (pass/fail), with weekly review tasks in Excel. No prior knowledge of Excel is expected, but familiarity with basic concepts of statistics is recommended.

This course meets in the second half of the semester (March 7 - April 19).

*Non-Ford students can enroll Ford elective courses beginning December 7.*