ipeds workshop

National Center for Education Statistics

IPEDS WorkshopIPEDS WorkshopSHEEO/NCES Network

ConferenceMay 8-10, 2007

St Petersburg FL


AgendaAgenda

• 2006-07 and Noncompliance• 2007-08• Help Desk report• AIR report• New IPEDS website• New PAS & DAS• Data Feedback Report and ExPT• Finance• Upcoming Reports and TRPs • Other NCES projects of interest


Acronyms UsedAcronyms Used

• PPA = Program Participation Agreement

• FSA = Office of Federal Student Aid• KH = keyholder• HD = Help Desk• TRP = Technical Review Panel• OMB = Office of Management &

Budget


IPEDS Survey IPEDS Survey ComponentsComponents

• Institutional Characteristics (IC)• Completions (C)• Human Resources (HR)• Enrollment (EF)• Graduation Rates (GRS)• Student Financial Aid (SFA)• Finance (F)


IPEDS Data ToolsIPEDS Data Tools

• COOL – College Opportunities Online Locator

• ExPT – Executive Peer Tool• PAS – Peer Analysis System• DCT – Dataset Cutting Tool• DAS – Data Analysis System


2006-07 data collection2006-07 data collection


Spring collectionSpring collection

• Closed 2 days later than scheduled due to Dept of ED network problems on 4/17

• HD and survey directors currently doing QC


Data collection Data collection system rewritesystem rewrite

• For 2006-07, using .NET and SQL2005

• New technology, allowed us to achieve increased efficiencies and do more cool stuff

• Thanks for your patience as we went operational


Noncompliance updateNoncompliance update


Mandatory Mandatory reporting of IPEDSreporting of IPEDS

• Reporting IPEDS is mandatory for all institutions with PPA with US Dept of ED for Title IV federal student financial aid

• Since 2002-03, FSA has been enforcing this with fines, warnings

• Penalties for noncompliance include• Fine of up to $27,500 per violation• Institution’s eligibility to participate in

Title IV programs can be suspended


FSA Noncompliance FSA Noncompliance Actions: Actions:

Total Fines AssessedTotal Fines Assessed

$1,241,000

$370,000

$175,500$67,500

$0

$200,000

$400,000

$600,000

$800,000

$1,000,000

$1,200,000

$1,400,000

2002-03 2003-04 2004-05 2005-06

Fines


7839 39

110

50

100

150

200

250

300

350

400

450

2002-03 2003-04 2004-05 2005-06

# Fined

# Warned

Total

FSA Noncompliance Actions:

Institutions Fined, Warned


2006-07 Nonresponse:2006-07 Nonresponse:# of Institutions# of Institutions

• IC = 2• C = 1• HR = 1

• EF = • GRS = • SFA = • F =


FollowupFollowup

• Unfortunately, it takes a lot of work to make these low numbers happen

• We are doing a lot of followup, during and after collections• Accepting data 2 wks after close

• This summer, we’ll send letter to CEO and KH of institutions that have had their one and only second chance


2007-08 data collection2007-08 data collection


Proposed changes Proposed changes for 2007-08for 2007-08

• Initial Federal Register notice placed January 24, 2007 which began a 60-day comment period through March 26

• On March 8, second notice in Fed Reg was posted that read…

March 8 NoticeMarch 8 Notice

• “The Department has received comments regarding some of the new questions included for the first time in this proposed IPEDS Information Collection Request (ICR). The Secretary has taken these comments into consideration and decided to revise the proposed collection by removing some of the new items proposed for this annual data collection.”



NEW proposed NEW proposed changes for 2007-08changes for 2007-08

• Another Federal Register notice will be posted beginning another 30-day comment period (soon)

• Most changes would be optional for 2007-08 and mandatory for 2008-09

• No race/ethnicity changes for 2007-08 included in changes sent to OMB


Institutional Institutional CharacteristicsCharacteristics

• Institutional identification: •Collect website addresses for

admissions and financial aid offices, instead of phone numbers



• Part C, Admissions Requirements & Services•Add question: Does your

institution have an online application? If yes, provide URL. Link will be added to COOL website.



• Part C, Admissions Requirements & Services• Eliminate option to choose

admissions reporting year; admissions information reported for current academic year only

• If approved by OMB, will be mandatory in 2007-08


EnrollmentEnrollment

• Parts E & F, 12-month Unduplicated Count and Instructional Activity• Remove from the Enrollment

component collected in winter and spring, and create new component (E12) to collect these data in the fall

• No changes to data collected, only to collection in which they appear

• If approved, will be mandatory in 2007-08


EnrollmentEnrollment

• Part G, Retention Rates•Rather than collect only the rates

for full-time and part-time students, collect the numerator and denominator and have the system calculate the rates


Graduation RatesGraduation Rates

• Sections V and VI, students receiving athletically related student aid• Eliminate these sections from IPEDS

GRS• Institutions will no longer be required

to report these data to IPEDS, but will still be required to disclose these data, per SRK

• Add item to report URL used for disclosure


XML upload optionXML upload option

• Currently working with Postsecondary Education Standards Council (PESC) on XML data upload option for 2007-08 IPEDS

• Will be another data submission option, along with • keying data into screens• fixed file upload • key value file upload


http://pesc.org/http://pesc.org/

• Non-profit, community-based, umbrella association of colleges and universities; professional and commercial organizations; data, software and service providers; and state and federal government agencies

• Mission is to lead the establishment and adoption of data exchange standards in education

• Michael Sessa, Executive Director (3:10 today)


PESC and IPEDSPESC and IPEDS

• Currently developing schemas• Working with PESC Change

Control Board• Holly Hyland, Dept of ED• Bruce Marton, U of TX at Austin• On track to release specs on

Aug 1


XML uploadXML upload

• First step: tackle Human Resources (HR) component survey• The most complicated•Has the most cross-section

dependencies

• The other survey components will then fall into place


Instr

.

IRP

S


<Institution> is a group of elements and UnitID attribute

<EAP>

<Institution>

<Salaries>

<Staff>

<HrDegreeGranting> element is a sequence of <Institution> elements

<Institution>

<HrDegreeGranting>

<Institution>

<Institution>

<Institution>

1

2

3


<EmployeesByAssignedPosition> is a group of elements

<TimeStatus>

<EmployeesByAssignedPosition>

<MedicalStatus>

<Count>

<PrimaryFunction>

<FacultyStatus>

1


<Amount>

< FullTimeInstructionalStaffBenefits > is a sequence of

<ContractLength>

FullTimeInstructionalStaffBenefits

<FringeBenefits>

<Count>

<Amount>

< FullTimeInstructionalStaffSalaries> is a sequence of

<ContractLength>

FullTimeInstructionalStaffSalaries

<FacultyStatus>

<AcademicRank>

<Gender>

<Count>

<Amount>

<Salaries> is a sequence of group of- <FullTimeInstructionalStaffSalaries> - <FullTimeInstructionalStaffBenefits>

<FullTimeInstructionalStaffSalaries>

<FullTimeInstructionalStaffBenefits >

<Salaries>

2


<Staff> is a choice of- <Staff15orMore> - <StaffLess15> elements

<Staff15OrMore>

<Staff>

<StaffLess15>

<Staff15orMore> is a sequence of

<FullTimeIRPSbyFacultyStatus>

<Staff15orMore>

<FullTimeIRPSbyContractLength>

<FullTimeProfessionalStaffbyPosition>

<FullTimeNonProfessionalStaffbyPosition>

<FullTimeIRPSNewHires>

3

A group of elements

<FacultyStatus>

<AcademicRank>

<RaceEthnicity>

<Gender>

<Count>

A group of elements

<ContractLength>

<SalaryRange>

<RaceEthnicity>

<Gender>

<Count>

A group of elements

<PrimaryFunction>

<SalaryRange>

<RaceEthnicity>

<Gender>

<Count>

A group of elements

<FacultyStatus>

<RaceEthnicity>

<Gender>

<Count>


<xs:complexType name="StaffType">

<xs:sequence>

<xs:choice maxOccurs="1">

<xs:sequence maxOccurs="unbounded">

<xs:element name="Staff15orMore" type="Hr15orMoreType" minOccurs="0" />

</xs:sequence>

<xs:sequence maxOccurs="unbounded">

<xs:element name="StaffLess15" type="FullTimeIRPSbyContractLengthType" />

</xs:sequence>

</xs:choice>

</xs:sequence>

</xs:complexType>

<xs:complexType name="HrInstitution">

<xs:all >

<xs:element name="Salaries" type="SalariesSectionType" minOccurs="0" />

<xs:element name="Staff" type="StaffType" minOccurs="0"/>

<xs:element name="EmployeesbyAssignedPositions">

<xs:complexType>

<xs:sequence maxOccurs="unbounded" minOccurs="0">

<xs:element name="EmployeesbyAssignedPosition" type="EmployeesbyAssignedPositionType" minOccurs="1" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="Caveat" type="xs:string" minOccurs="0" />

</xs:all>

<xs:attributeGroup ref="InstitutionAtrGrp"/>

</xs:complexType>

<xs:element name="HrDegreeGranting" >

<xs:complexType>

<xs:sequence minOccurs="1" maxOccurs="unbounded">

<xs:element name="Institution" type="HrInstitution" maxOccurs="unbounded" minOccurs="1" />

</xs:sequence>

</xs:complexType>

</xs:element>


Sample Element Sample Element


Collection scheduleCollection schedule2007-082007-08


RegistrationRegistration

Registration opens August 1

UserIDs to KHs August 1

Survey materials posted August 1

Status of registration taken

August 29

Letters to CEO (if KH not registered)

August 31


Fall CollectionFall Collection

Surveys

Institutional CharacteristicsCompletions12-month Enrollment** (***if approved by OMB)

Collection open September 5

Keyholder close October 17

Coordinator close

October 31


Winter CollectionWinter Collection

SurveysHuman ResourcesEnrollment (available)Finance (available)

Collection open December 5

Keyholder close January 23

Coordinator close February 6


Spring CollectionSpring Collection

Surveys

Enrollment FinanceStudent Financial AidGraduation Rates

Collection open March 5

Keyholder close April 16

Coordinator close April 30


Additional NotesAdditional Notes

• Ideas for comment:•Keep Enrollment, Finance open

between Winter and Spring collections

•Close Enrollment, Finance for last week of Winter collection


Followup scheduleFollowup schedule

Email to KH (collection open) OpenLetter to CEO (no registered KH) Close – 4wksEmail to KH (no data) Close – 4wksPhone to CEO (no registered KH) Close – 3wksPhone to CEO/KH (no data) Close – 2wksEmail to KH (no data, not locked) Close – 2wksEmail to KH (no data, not locked) Close – 1wk


Race/ethnicityRace/ethnicity


Race/ethnicityRace/ethnicity• Proposed Dept of ED guidance on

Maintaining, Collecting, and Reporting Data on Race and Ethnicity posted in Federal Register 8/7/06

• For implementing 1997 OMB standards

• Public comment period ended 9/21/06• TRP held in November• Final guidance will be posted

(when???)


First-professional First-professional degree classificationdegree classification


First-professional First-professional degree classificationdegree classification

• After 2 TRPs and 2 suggestion postings and 2 comment periods…

• Plan posted: http://nces.ed.gov/ipeds/whatsnew.asp


Here’s the plan:Here’s the plan:

• Eliminate First-professional degree category

• Report in appropriate degree level category:• Master’s degrees• Doctor’s degrees – research/scholarship• Doctor’s degrees – professional practice• Doctor’s degrees – other


Here’s the plan Here’s the plan (cont)(cont)::

• Eliminate First-professional certificate category

• Report in Postmaster’s certificate category


Possible Possible ImplementationImplementation

Optional Mandatory

IC 2008-09 2009-10

EF 2008-09 2009-10

C2009-10 (awards granted 7/1/08 – 6/30/09)

2010-11 (awards granted 7/1/09 – 6/30/10)


Help Desk ReportHelp Desk Report


AIR ReportAIR Report


New IPEDS WebsiteNew IPEDS Website


Redesign of IPEDS Redesign of IPEDS WebsiteWebsite

• http://nces.ed.gov/ipeds/• Develop user-friendly website for

IPEDS• Reorganize content into intuitive,

logical information and architecture• Simplify site structure so users can

find info• Update content• Enhance site appeal• Create design that enhances usability


PASPAS

New Features


New Features PASNew Features PAS

• Multiple year selection for variables

• Variable search feature• New navigation• PowerUser upload• Built-in trend reports• Grad rates templates


DAS UpdateDAS Update


Data Feedback Report Data Feedback Report & ExPT& ExPT


Data Feedback Report Data Feedback Report & Executive Peer Tool& Executive Peer Tool

• 2006 report available through ExPT at http://nces.ed.gov/ipedspas/

• 2007 report will incorporate changes suggested by TRP held March 2006


DFR & ExPT 2007DFR & ExPT 2007

• Enhance ExPT •Replicate full version of DFR

in .pdf•Upload comparison group files•Add new figures (ExPT only)

• Generate auto comparison groups using 2005 Carnegie Basic


New figures for ExPTNew figures for ExPT

• Enrollment – detail by level• Transfers-in (2008)• Admissions

• Yield rate, SAT/ACT, selectivity index

• Personnel services by function (salaries, benefits) as % of total operating expenses

• Core revenues and expenses figures by both percentage distribution by source and by per FTE enrollment

• Endowment per FTE


DFR & ExPT 2007DFR & ExPT 2007

• 2007 custom comparison group upload•Open through July 1• Instructions at

http://nces.ed.gov/ipeds/comp_gp.asp

•On-demand webinar at http://airweb.org


FinanceFinance


Improving Finance Improving Finance DataData

• TRP held Jan 17-18; results will be posted for comment after OMB Clearance for this year completed

• Discussed future enhancements, addition of new data items

• Goal: to increase comparability between forms• greater utility of data• improve financial transparency of the

institutional finance data being reported


Upcoming Reports and Upcoming Reports and TRPsTRPs

• Finance Validity Study•Currently being revised

• Minimum Dataset Study•Currently being revised

• HR Validity Study• Early draft being reviewed

• Next TRP: Online IPEDS State Profiles Tool (July)


Other NCES Other NCES Projects of InterestProjects of Interest


NCES Projects of NCES Projects of InterestInterest

• The new COOL• NPEC state consumer website

project• Pilot proposal for student

longitudinal data

ipeds workshop

Documents

education statistics2006

qcnational center

suspendednational center

warnednational center

education statistics2007

operationalnational

education statisticsagenda2006

data collectionnational