Tips to handle a complex data request report with less anxiety
1 / 21

- PowerPoint PPT Presentation

  • Uploaded on

Tips to Handle a Complex Data Request/Report with Less Anxiety. TAIR Conference February 2008 Presenter: Salma Ferdous Office of Institutional Research The University of Texas at San Antonio . Overview. Data Processing in Absence of Data Warehouse IR Responsibilities

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about '' - tobit

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Tips to handle a complex data request report with less anxiety l.jpg
Tips to Handle a Complex Data Request/Report with Less Anxiety

TAIR Conference

February 2008

Presenter: Salma Ferdous

Office of Institutional Research

The University of Texas at San Antonio

Overview l.jpg
Overview Anxiety

  • Data Processing in Absence of Data Warehouse

  • IR Responsibilities

  • Steps of Data Analysis

  • Don’t be Stressed out

  • Data Request Example

  • Data Processing Methods

  • Questions/Answers

What to expect as an institutional researcher l.jpg
What to Expect as an Institutional Researcher? Anxiety

  • Institutional Researchers Often Get Complex Requests From Different Sources.

  • Institutional Researchers Often Face Multiple Demands With Tight Deadlines.

  • Institutional Researchers Obligated to Provide Quality Information, Research, and Analysis.

Potential ir responsibilities l.jpg
Potential IR Responsibilities Anxiety

  • Student Enrollments

  • Credit Hours Generated

  • Degrees Awarded

  • Retention and Graduation Analyses

  • Admission-related Analyses

  • Analyses of Teaching Loads and Class Size

  • Analyses of Grades

  • Analyses of Faculty

  • Analyses of Staff

  • Analyses of Levels of Research Support

  • Administration and Analysis of Surveys

  • Administration of Focus Groups of Students, Faculty, and/or Staff

  • Reports Summarizing Comparative Data of Peer Institutions

  • Requests for Ad Hoc Reports from Outside Agencies

Good ir professional requires l.jpg
Good IR Professional Requires: Anxiety

  • Familiarity with Fundamentals of IR (Students, Faculty, Finance, Facilities)

  • Technological And Analytical Skills (Research Design, Sampling Procedures, Statistics, Use of Excel, Word, Statistical Software)

  • Issues Intelligence (Knowledge of Major Issues or Decisions That Face Your Institution)

  • Contextual Intelligence (Understanding The Culture of Higher Ed and Your Particular Campus)

  • Communication Skill (Establish Friendly, Professional Relationship with Coworkers and with Important Campus Persons)

    (Dizinno and Gardner: 2007)

Stages of data analysis l.jpg
Stages of Data Analysis Anxiety

  • Identification - of Data And Data Sources

  • Acquisition - of The Needed Data

  • Conversion - to Readable, Usable Format

  • Auditing - Determining Data Accuracy & Validity

  • Preliminary Analysis

  • Full Analysis

  • Summary - Summarizing The Results

  • Presentation – Presenting The Results

    (Dizinno and Gardner: 2007)

You should not be stressed out l.jpg
You should not be Stressed Out Anxiety

There is Good stress and Bad stress.

Good stress helps keep us alert, motivates us to face challenges, and drives us to solve problems. Good stress increases our strength, speed and reaction time.

Bad stress or distress occurs when our bodies overreact to events. We react to many daily situations as if they were life or death issues.

As survivors in the field of Institutional Research, we would like to provide some of the insights and coping methods we have developed to manage the stress related to this line of work.

(Chrestman, James and Swink: 2003)

Utsa ir data sources l.jpg
UTSA IR Data Sources Anxiety

Raw Data

  • CB Reports

  • Banner DataMart

  • Define HR System

  • Various UTSA Servers

Published Data

  • UTSA Fact book

  • THECB Accountability Website

  • UT System Accountability Website

  • THECB PREP Query Tool

  • IPEDS Peer Analysis System

  • Census Data

  • Texas State Data Center and Office of the State Demographer

Utsa data manipulation methods l.jpg
UTSA Data Manipulation Methods Anxiety

  • MS Access

    • To pull the data from different Databases

    • To link different tables to get desired data

    • To use different criteria in the queries

    • To get Pivot Table View of the required data

  • MS Excel

    • To generate statistical data using formulas

    • To get Pivot Table View of the required data

    • To deliver final results

  • SPSS

    • To generate statistical data specially for huge datasets

    • To get custom outputs of the required data

    • To handle data programmatically

Let s work on a data request l.jpg
Let’s Work on a Data Request Anxiety

These are the Portions of a Data Request:

  • Ph.D. student enrollment for each of the 20 doctoral degree programs offered at UTSA for the last 5 years and then the breakdown of that total number by Gender, Ethnicity, Department and College.

  • Total number of Ph.D. students Applied and Accepted for the past 5 years and then the breakdown of that total numbers by Gender and Ethnicity.

  • Graduation Rate of Ph.D. students in each department for the past 5 years and then the breakdown of that total number by Gender and Ethnicity.

Form before l.jpg
Form Before Anxiety

  • Data Request Form

Form after l.jpg
Form After Anxiety

Questions to ask yourself l.jpg
Questions to Ask Yourself Anxiety

  • What are the items being requested?

  • What sources of data can you use to get the information you need?

  • Do you have all the tables updated to be used for the request?

  • Are you familiar with all the data requested?

What are the items this request asking for l.jpg
What are the Items this Request Asking for? Anxiety

  • Student Enrollment in Doctoral Level for 5 Years

  • Doctoral Degree Programs Offered at UTSA

  • Total Numbers by Departments and Colleges

  • Total Numbers by Gender and Ethnicity

  • Number of Ph.D. Students Applied, Accepted

  • Graduation Rates of Ph.D. Students

What sources of data can you use l.jpg
What Sources of Data can You Use? Anxiety

  • Need to have a Cumulative CBM001 table

  • Need to have a Validation/Crosswalk table of the Programs, Departments and Colleges

  • Need to have Cumulative Admission table

  • Need to have Cumulative Graduation table

Are you familiar with rules of the data requested l.jpg
Are You Familiar with Rules of the Data Requested? Anxiety

  • Enrollment

    • Correct Level of Students

    • Correct Term Codes

    • Exclude Flex (Katrina) Students

  • Programs

    • Correct College Structures

  • Admission

    • Correct Level of Students

    • Select students with Decision Made

    • Exclude “Denied” Students

  • Graduation

    • Correct Level of Students

    • First-Time Full-Time Students (for Undergraduate)

    • 4, 5, 6 yrs graduation rates

    • Exclude Deceased Students

Procedures to compile data l.jpg
Procedures to Compile Data Anxiety

  • Start with CBM001 for 5 Academic Years Enrollment in Ph.D. Level

  • Gender and Ethnicity data should come from CBM001

  • Link CBM001 with Program/Department/College table for Program Codes, Names, Department and College

  • Use CBM00B or Admission Data Table to get number of students Applied and Accepted.

  • Use CBM009 or Graduation Data Table to obtain number of students graduated within last 5 Academic Years

Write a memo l.jpg
Write a Memo Anxiety

  • Write the data sources used for the request

  • Write major steps needed for the request

  • Write reports that are easy to understand

  • Keep reports brief and concise

  • Save all Memos for future references.

Tips to handle complex requests l.jpg
Tips To Handle Complex Requests Anxiety

  • Learn Basic Higher Education Rules

  • Learn Your Institution’s Decisions

  • Keep Your Primary Data Sources Updated

  • Make Cumulative Data Tables

  • Keep Historical Data Saved

  • Maintain Data Request Database with Job Numbers

  • Write the Procedures for Future Reference

  • Try to Use Statistical Software

  • If you have Data Warehouse, you know how the data is being executed

References l.jpg
References Anxiety

  • Strategies for the Practice of Institutional Research by Gerry Dizinno and Denise Gardner: 2007

  • Survival Skills for Institutional Research by Ronnie Chrestman, Nancy James and Jessica Swink: 2003

Questions l.jpg
Questions? Anxiety