Admissions | UW Medicine | News | Sports | Alumni | Visit the UW
Title Image

Data Management Committee

Top 5 Deans’ and Chancellors’ Questions Project

Goals

  • Create UW-wide agreement on "institutional" answers to Top 5 questions Deans and Chancellors ask about their schools, colleges, and campuses.
  • Provide these answers through a single, easy-to-access Web portal.
  • Create a foundation and repeatable methodology for continuing to define our institutional data.
  • Inform the build-out of our Enterprise Data Warehouse to support our data needs at both central and local levels.

Roles

  • Sponsor:
    • Ana Mari Cauce, Executive Vice Provost
  • Deans’ and Chancellors’ Advisory Group:
    • Ron Irving, Interim Dean, College of Arts and Sciences
    • Arthur Nowell, Dean, College of Ocean and Fishery Sciences
    • Pat Wasley, Dean, College of Education
    • Nancy Woods, Dean, School of Nursing
    • John Sahr, Associate Dean, Undergraduate Academic Affairs
    • Beth Rushing, Vice Chancellor for Academic Affairs, Office of Academic Affairs
    • Susan E. Jeffords, Vice Chancellor, University of Washington, Bothell
    • Matt O'Donnell, Dean, Engineering, Bioengineering
  • Top 5 Sub-Committee:
    • Jeanne Marie Isola, Associate Vice Provost, Strategic Projects and Portfolios, OIM
    • Todd Mildon, Registrar, Office of the University Registrar
    • Brandon Whitehead, Manager, Academic Personnel Information
    • Rhonda Forman, Assistant Vice Provost, Academic Personnel
    • Elizabeth Coveney, Executive Director, HR Administration and Information Systems
    • John Drew, Director, Computing and Information, Graduate School
    • Phil Hoffman, Director, Office of Institutional Studies
    • Bill Yock, Associate Vice Provost, Enterprise Information Services, OIM
    • Charles Bennett, Director, Decision Support Center, Financial Management
  • Project Manager:
    • Laura Walker, Strategic Projects and Portfolios

Guiding Principles

  • Meet UW needs first! (i.e., answers to the Top 5 meet internal UW purposes as opposed to state or accreditation requirements).
  • "Answers" to Top 5 represent 80% of the needs across schools, colleges, and campuses (may have more than one "answer" if needed to meet need).
  • Initial audience is the deans (future iterations can broaden to other audiences)
  • Report will provide answers to these questions longitudinally, by school, college, campus, and UW-wide.
  • Provide clear documentation (in "simple English") on how reports are defined, generated, and utilized.
  • Do not go through "heroics" to generate this data; generate it using a repeatable report process on existing databases OR outline the work necessary to generate this data from the Enterprise Data Warehouse.

Teams

  • Student Task Team
    • Questions:
      • Student Headcount
      • Student Credit-hours
    • Members:
      • Todd Mildon, University Registrar (Lead)
      • John Drew, Graduate School (Facilitator)
      • Ann Wunderlin, Officeof Information Management
      • Dave Asher, Educational Outreach
      • Denis Brasfield, School of Public Health and Community Medicine
      • Bill Yock, Office of Information Management
      • Andrew Hummel-Schluger, Office of the Registrar
      • Julie Katz, School of Nursing
      • Carol Kalfelz, School of Education
      • James Posey, UW Tacoma
      • Jeff Peterson, Student Fiscal Services
      • Phil Hoffman, Institutional Studies
      • Collin McDonell, Office of the Registrar
  • Faculty Task Team
    • Questions:
      • Faculty Headcount by Appointment Type
      • Faculty FTE by Appointment Type
    • Members:
      • Rhonda Forman, Academic Personnel (Lead)
      • Phil Hoffman, Institutional Studies
      • Laurie Bryan, College of Ocean & Fishery Sciences
      • Brandon Whitehead, Academic Personnel Information
      • Liz Coveney, Human Resources
      • Lawrie Robertson, School of Public Health and Community Medicine
      • Stacey Fauchald, School of Medicine
      • Charlene Gilder, School of Medicine
      • Ruchi Aggarwal, College of Engineering
      • Kellie R Holden, University of Washington, Bothell
      • Robert A. Blum, College of Arts & Sciences
      • Jean Garber, School of Dentistry
  • Financial Task Team
    • Questions:
      • Permanent Operating Budget by GOF, DOF, and RCR
    • Members:
      • Bev Anderson, College of Forest Resources
      • Charles Bennett, Financial Management Decision Support
      • Bill Christenson, Financial Reporting
      • Mary Clark, Information School
      • Gary Farris, Graduate School
      • Amy Floit, Budget Office
      • Mary Jo Hershly, Grant and Contract Accounting
      • Phil Hoffman, Institutional Studies
      • Nancy McDonald, School of Medicine
      • Jan Rutledge, University of Washington, Tacoma
      • JR Sloan, Financial Management Decision Support
      • Tom Sparks, College of Engineering
      • Bill Yock, Information Management

Project Status - Updated 4/9/2008

  • March 2008:
    • Published the Top 5 documents and reports on the Web site.
    • Presented the Top 5 project to the Board of Deans and Chancellors.
    • Met with the Deans’ and Chancellors’ Advisory Group.
    • Completed Phase 1 of the project.
  • February 2008:
    • Created first draft of reports for Finance, Faculty, and Student areas.
    • Created new Top 5 Web site with issues, definitions, and reports for each of the areas.
    • Met with Jim Fine to discuss inconsistency in counting faculty.
    • Prepared for the final Deans’ and Chancellors’ Advisory Group meeting in March.
  • January 2008:
    • Student issues document updated with decisions made by the Deans’ and Chancellors’ Advisory Group and sent to stakeholders for review.
    • Revised student data issues document sent to Deans’ and Chancellors’ Advisory Group
    • Faculty data issues document sent to Deans’ and Chancellors’ Advisory group
    • Finance data issues discussed with Ana Mari Cauce
    • Deans’ and Chancellors’ Advisory Group met and made decisions on the two remaining student data issues and discussed first three faculty issues. Identified action items.
  • December 2007:
    • Discussed faculty data issues with Ana Mari Cauce
    • Revised faculty data issues and readied them for discussions with Deans’ and Chancellors’ Advisory Group
    • Generated definitions and designed the report template for the Finance Task Team
    • Discussed finance data issues with Mike Eisenberg in anticipation of discussions with Ana Mari Cauce
  • November 2007:
    • Finance Task Team meetings designed and team kicked off to begin answering Deans’ and Chancellors’ finance-related Top 5 question
    • Finance Task Team generated "institutional" definitions
    • Faculty data issues discussed with Mike Eisenberg in anticipation of discussions with Ana Mari Cauce
    • Draft of Deans’ and Chancellors’ Advisory Group decisions sent to stakeholders for comments before sending out to Deans’ and Chancellors’ Advisory Group
  • October 2007:
    • Deans’ and Chancellors’ Advisory Group met and made decisions on three of five issues related to student data.
    • Provost Phyllis Wise was briefed on Top 5 project
    • ITRSG was briefed on Top 5 project
    • Project update provided to Data Management Committee
  • September 2007:
    • Sample report and data issues developed by Student Task Team presented to project sponsor Ana Marie Cauce.
    • Related to the faculty questions, Faculty Task Team developed:
      • Faculty data the Deans and Chancellors want to know
      • Why the Deans and Chancellors need this information
      • Issues related to faculty data
    • Initial planning for the Finance Task Team: Team membership solidified and project logistics underway.
    • Draft of Project Communications Plan developed and presented to Top 5 sub-committee for input.
  • August 2007:
    • Faculty Task Team meetings designed and team kicked off to begin answering Deans’ and Chancellors’ faculty-related questions.
    • Student Task Team completed initial set of five meetings and identified issues related to student data.
    • Initial planning for Finance Task Team: potential task team members contacted and invited to join team.
  • July 2007:
    • Project manager and project assistant hired to take on overall project management and create repeatable process to define institutional summary rules for Top 5 type questions.
    • Student Task Team explored current reporting, data sources and business rules as part of work on answering Deans’ and Chancellors’ student-related questions.
    • Initial planning for Faculty Task Team: Team membership solidified and project logistics completed.
  • June 2007:
    • Defined a project structure, identified Executive Vice Provost Ana Mari Cauce as the project sponsor and the Deans’ and Chancellors’ Advisory Group as the “decision makers.” The Top 5 sub-committee, a subset of the Data Management Committee (DMC), acts as the project team and the DMC provides policy and technical guidance. Project structure includes a task team for each of the Top 5 question areas: student, faculty and finance.
    • Student Task Team meetings designed and team kicked off to begin answering Deans’ and Chancellors’ student-related questions.