Federal Research and Federal Research and Evaluation DatabasesEvaluation Databases

TAA and WIA Diagnostic TAA and WIA Diagnostic and Planning Toolsand Planning Tools

2

AgendaAgenda• Overview of the toolsOverview of the tools• TAA and WIA application menusTAA and WIA application menus• Exploring menu optionsExploring menu options• Questions?Questions?

3

Overview of the ToolsThe Federal Research and Evaluation Database (FRED) The Federal Research and Evaluation Database (FRED) enables analysis of the Trade Act Participant Report (TAPR) enables analysis of the Trade Act Participant Report (TAPR) and the WIA Standardized Record Data (WIASRD). Both and the WIA Standardized Record Data (WIASRD). Both data files are annually submitted by states on TAA and WIA data files are annually submitted by states on TAA and WIA exiters' demographic characteristics, the services they exiters' demographic characteristics, the services they received, and the outcomes they achieved after exit. received, and the outcomes they achieved after exit.

• Currently contains data on exiters from the PY03 WIASRD and Currently contains data on exiters from the PY03 WIASRD and FY02 TAPRFY02 TAPR

• Examine performance, caseload and program information from the Examine performance, caseload and program information from the national, regional, state and local levelsnational, regional, state and local levels

• Display trends in performance by quarter as well as the Display trends in performance by quarter as well as the characteristics of the exiter cohortcharacteristics of the exiter cohort

• Create comparison groups based on parameters Create comparison groups based on parameters set by the user set by the user

• Create cross tabulation tables and correlationsCreate cross tabulation tables and correlations

4

Applications MenusApplications Menus

Go to http://www.fred-info.orgGo to http://www.fred-info.org

5

Accessing the WIA Applications MenuAccessing the WIA Applications Menu

6

Program Program Area Area

SpecificSpecific

Funding Funding Formula Formula SpecificSpecific

7

WIA Program-Specific MenuWIA Program-Specific Menu14

App

licat

ions

14 A

pplic

atio

ns

8

Accessing the TAA Applications MenuAccessing the TAA Applications Menu

9

TAA Program Applications MenuTAA Program Applications Menu10

App

licat

ions

10 A

pplic

atio

ns

10

Selected Menu OptionsSelected Menu OptionsDrill down-all measuresDrill down-all measuresDrill down by measureDrill down by measureBenchmark performance against peersBenchmark performance against peersCreate a performance adjustment model and worksheetCreate a performance adjustment model and worksheetCalculated performance by rolling quartersCalculated performance by rolling quartersProfiles by program areaProfiles by program areaFind the top performers for a given performance measureFind the top performers for a given performance measureAd hoc analysisAd hoc analysis

11

Drill Down: All MeasuresDrill Down: All Measures

This tool allows the user to drill down into program This tool allows the user to drill down into program year and levels of program administration to year and levels of program administration to examine performance. The examine performance. The All MeasuresAll Measures selection selection allows the user to examine performance for all allows the user to examine performance for all measurement groups at once.measurement groups at once.

12

13

14

15

16

17

18

Drill Down: By MeasuresDrill Down: By Measures

Focusing on a single measure at a time, this tool Focusing on a single measure at a time, this tool allows the user to drill down into program year and allows the user to drill down into program year and levels of program administration to examine levels of program administration to examine performance. The performance. The By MeasuresBy Measures selection allows selection allows the user to examine the effect of client the user to examine the effect of client characteristics and program services on a characteristics and program services on a performance outcome. performance outcome.

19

20

21

22

23

24

25

26

Downloaded file is in a comma Downloaded file is in a comma separated value (CSV) formatseparated value (CSV) format

27

Benchmark PerformanceBenchmark Performance

This tool allows the user to benchmark the This tool allows the user to benchmark the performance of a given state or local area against performance of a given state or local area against the performance of other areas with similar the performance of other areas with similar customer characteristics, program services and customer characteristics, program services and local economic conditions.local economic conditions.

28

29

30

31

32

33

Performance Adjustment ModelPerformance Adjustment Model

This tool allows the user to develop a performance This tool allows the user to develop a performance adjustment model to help in understanding the adjustment model to help in understanding the impacts of various factors on performance at the impacts of various factors on performance at the state, regional or national level. The model is state, regional or national level. The model is displayed as a worksheet. The user can adjust the displayed as a worksheet. The user can adjust the factors included in the worksheet on-line to explore factors included in the worksheet on-line to explore the impacts resulting from changes in customer the impacts resulting from changes in customer characteristics, program services, and economic characteristics, program services, and economic conditions. conditions.

34

35

36

37

38

This link This link provides provides detailed detailed results from results from the the regression regression procedure, procedure, including including correlation correlation coefficients. coefficients.

39

Calculated Performance by Rolling Calculated Performance by Rolling QuartersQuarters

This tool allows the user to analyze performance This tool allows the user to analyze performance trends that reflect a four quarter average. Looking trends that reflect a four quarter average. Looking at a year’s worth of data each quarter removes at a year’s worth of data each quarter removes cyclical quarter to quarter fluctuations to more cyclical quarter to quarter fluctuations to more clearly see overall performance trends.clearly see overall performance trends.

40

41

42

43

44

Area ProfilesArea Profiles

This tool allows the user to display customer and This tool allows the user to display customer and program service profiles by funding stream during a program service profiles by funding stream during a given program year. Profiles may also be created given program year. Profiles may also be created to reflect national, regional, state or LWIA to reflect national, regional, state or LWIA characteristics. characteristics.

45

46

47

48

49

Top PerformersTop Performers

This tool allows the user to display the top This tool allows the user to display the top performing state or local area for a given performing state or local area for a given performance measure and a specific customer performance measure and a specific customer characteristic.characteristic.

50

51

52

53

54

Ad Hoc AnalysisAd Hoc Analysis

This tool allows the user to choose the combination This tool allows the user to choose the combination of variables of interest to create and display cross-of variables of interest to create and display cross-tabulation tables. The user can also display the tabulation tables. The user can also display the results by a third variable of interest.results by a third variable of interest.

55

56

57

58

59

For More InformationFor More Information

ETA’s Performance and Results Web PageETA’s Performance and Results Web Pagehttp://www.doleta.gov/performance/http://www.doleta.gov/performance/

ETA’s Administrative Data Research and ETA’s Administrative Data Research and EvaluationEvaluation (ADARE) ProjectADARE) Project

WebsiteWebsitehttp://www.ubalt.edu/jfi/adare/partners/maryland.htmhttp://www.ubalt.edu/jfi/adare/partners/maryland.htm