1 / 18

Using Microsoft Access to Assess Your Office Strategic Goals and Objectives

Using Microsoft Access to Assess Your Office Strategic Goals and Objectives. by Sheilynda Stewart, Director Office of Institutional Research. East central University. Project Process Diagram. Integrated Functions of Institutional Research. New Technology: “Instant Information” Age.

alden
Download Presentation

Using Microsoft Access to Assess Your Office Strategic Goals and Objectives

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Microsoft Access to Assess Your Office Strategic Goals and Objectives by Sheilynda Stewart, Director Office of Institutional Research East central University

  2. Project Process Diagram

  3. Integrated Functions of Institutional Research

  4. New Technology: “Instant Information” Age

  5. How much time was spent on that project? The surveys are completed!

  6. ECU IR Mission Statement The mission of the Office of Institutional Research is to provide timely, reliable, and user-friendly data and research services to all units at East Central University and external agencies that is integral to the strategic planning of the University.

  7. ECU Institutional Research Project Management

  8. Project Management • Does not align project completion time to goals. • Can track department and resources, but can not • track details about the client and their location. • Unable to easily generate a report to show amount of • hours spent on specific project that are tied to • department and division goals.

  9. Timetracker Project • Purpose: • Increase efficiency by establishing tracking metrics for • success that are linked to measurable milestones. • To assess how well the IR Office is meeting stated goals. • To determine the amount of hours spent on internal/external • projects.

  10. Academic Affairs Priorities and Goals Academic Priority 1.15: Maintain membership in the Voluntary System of Accountability. Academic Priority 4.3: Disseminate accurate information to prospective and current students.

  11. IR Research Strategic Goals Goal 1: Provide decision-support data, research and analysis to facilitate the University’s strategic planning process, accreditation, assessment, and institutional effectiveness [IP1; AAP1.15] Goal 2: Provide accurate, timely, and user-friendly information. [IP4; SG1; AAP4.3]

  12. ECU Institutional Research Timetracker Process Model Main Menu View Project Information Update project information Add New Projects Preview Report Reports Access DB

  13. Data Integrity MS Access DB This isn’t what I had expected!! Input Data Output

  14. Database Entities Clients Name, Email, Department Departments Dept Name, Division, Internal/External Institutional Research Goals Academic Affairs Goals Projects Total Hours Worked, Description, Client, Project Notes, Dates: Open/Closed/Due Date Year Academic Year, Fiscal Year

  15. Entity Relationship Diagram

  16. Aligning Projects with IR and Academic Affairs Goals Projects are added to the Timetracker database IR and Academic Affairs goals are selected. Existing project/client information s can be updated when needed. Reports are generated to show amount of hours dedicated to complete a project.

  17. Aligning Projects with IR and Academic Affairs Goals Timetracker Project Demonstration

  18. Questions and Discussion Contact Information: Sheilynda Stewart Director of Institutional Research East Central University sstewart@ecok.edu 580-559-5668

More Related