slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Research, Education, and Economics Information System PowerPoint Presentation
Download Presentation
Research, Education, and Economics Information System

Loading in 2 Seconds...

play fullscreen
1 / 14

Research, Education, and Economics Information System - PowerPoint PPT Presentation

  • Uploaded on

REEIS. Research, Education, and Economics Information System Food and Agriculture Education Information System Panel of Experts July 15, 2003 Presented by: Michel Desbois, Director of Applications. ISTM Organizational Structure. Part of One Solution. Overview.

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

Research, Education, and Economics Information System

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


Research, Education, and Economics Information System

Food and Agriculture Education Information System Panel of Experts

July 15, 2003

Presented by:

Michel Desbois, Director of Applications

istm organizational structure
ISTM Organizational Structure

Part of One Solution

  • Mandated by Congress to satisfy federal program and budget performance requirements
  • Objective - “Measure the impact and effectiveness of research, extension, and education programs.”
  • How?
    • By bringing together a diverse set of USDA information on project, programs plans and outcomes and linking it with appropriate and relevant information.
    • In order to identify trends, evaluate programs, measure impact, answer key questions.

Target set of

~ 30 databases

overview cont
Overview (Cont.)
  • Examples of key questions:
  • What’s being done in e-Coli research by state?
  • What kind of programs is REE conducting on food safety, what is it costing and what is the taxpayer getting in return?
  • How are 1890 and 1994 institutions funded for research initiatives compared to 1862 institutions?
  • How many female students graduated during academic year 1999 with a bachelors degree or higher degree in Agricultural Teacher Education from an 1890 Land Grant Institute.
  • Create and maintain a user-friendly, web-based, stable and secure system that ensures high data quality
  • Provide linkages to programs/projects/activities with similar content
  • Satisfy program and budget accountability requirements – Costs associated with programs/projects
  • Provide public access to relevant data
  • Engage the community to ensure they are informed, listened and responded to, and informed.

Not data for the sake of data

  • Diverse customer base
    • Administrators, program managers, faculty, and researchers from USDA, universities, industry, and cooperative extension offices, Congress and state legislatures
    • Public users
  • Security provided through restricted access to sensitive

data based on user profiles

  • Analytical support desk to assist end users
reeis architecture and data
REEIS Architecture and Data

End User

Source data

Current Research


System (CRIS)

Annual 4H

Youth Development


Report (4H)

Ag Census



Data Load

National Science

Foundation (NSF)

Food and









Education Data

System (IPEDS)






Near term target sources

4 H Data

Expanded Food

and Nutrition

Education Program


current system content
Current System Content
  • REEIS contains:
    • 7 active data sources – 3 additional data sources in progress
    • 400 + tables
    • 3 layers – 3 step process to import databases
    • 5 classification standards
    • 35 + million rows of data

Current System Content (cont.)

  • Text searching of selected research data
  • Direct access to data sources (traceability), metadata, and integrated data sets
  • Current classification scheme standards in REEIS
    • Country and country subdivisions
    • U.S. States and outlying areas
    • Classification of Instructional Program (CIP)
    • Gender
    • Ethnicity
data warehoused in reeis
Data Warehoused in REEIS
  • Source data is added in a 3 step process
  • 1) - Original data is loaded and captured and a unmodified set of data is retained for validity and integrity purposes
  • 2) – Data is transformed and cleansed using standard classification schemes, i.e. gender, educational institution
  • 3) – A new schema, “simplified view” of the data is created for query purposes.
the faeis reeis connection
The FAEIS / REEIS Connection
  • REEIS is now an historical resting ground for 1993-2000 FAEIS data acquired from Texas A&M in 2002
  • Data from 2001(partial, due to transition) is in the process of being loaded into REEIS.
  • Many dynamic reports are available on the REEIS website.

The FAEIS / REEIS ConnectionContinued

  • 1993-2000 FAEIS data loaded from Excel spreadsheets
  • Exchange mechanism between FAIES and REEIS TBD?

The FAEIS / REEIS ConnectionContinued

  • REEIS Website –
  • Click the tab for “Reports”.
  • Click the tab for “FAEIS”.
  • Currently 12 dynamic reports exist, covering enrollments, degrees awarded, and faculty.
  • Special reports can be requested through the Data Analysis Help Desk at REEIS.
development schedule
Development Schedule
  • Next Release (Fall 2003) – Release 3.0 (Currently on 2.1)
    • Additional views and reports
    • Fluid front end
    • Integration of FAEIS and IPEDS into 2nd Education Data Mart
    • Two more data sources (EFNET, 4H)
    • Additional views and reports
    • Search and categorization tools
    • Other features to be determined