ucla luskin school of public affairs alumni data prepared by kristen figueira up 206a midterm...

10
UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Upload: suzanna-marilyn-owen

Post on 03-Jan-2016

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

UCLA Luskin School of Public AffairsAlumni DataPrepared by Kristen FigueiraUP 206A Midterm Project

Page 2: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Data

Luskin Alumni Data (~3000 Alumni)• Obtained from Sherry Dodge and VC Powe• Public Policy = 235 Alumni Responses• Social Work = 1375 Alumni Responses• Urban Planning = 1086 Alumni Responses

2010 Urban Planning Alumni Survey • Obtained from Robin Liggett• Sample Size= 588 Alumni Responses

• 466 valid responses • Majority live in California (~400 Alumni)

Page 3: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

UCLA Luskin School of Public Affairs Alumni

Legend

Luskin Alumni Employment Location

Luskin Alumni Working in Each State

No Alumni

1 - 16 Alumni

17 - 28 Alumni

29 - 60 Alumni

61 - 2218 Alumni

No Data Available

Luskin Alumni Data, Sample Size= 2696 Skills Used: Geoprocessing, Geocoding

Page 4: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Urban Planning Alumni

Legend

! Urban Planning Alumni

Alumni Living in Each State

No Alumni

1 - 5 Alumni

6 - 10 Alumni

11 - 15 Alumni

16 - 40 Alumni

41 - 354 Alumni

No Data Available

2010 Urban Planning Alumni Survey, Sample Size= 466 Skills Used: Geoprocessing, Geocoding

Page 5: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Urban Planning Alumni

Legend

Alumni Living in Each County

1 - 2 Alumni

3 - 7 Alumni

8 - 15 Alumni

16 - 31 Alumni

32 - 208 Alumni

Alumni Living in Each State

No Alumni

1 - 5 Alumni

6 - 10 Alumni

11 - 15 Alumni

16 - 40 Alumni

41 - 354 Alumni

No Data Available

2010 Urban Planning Alumni Survey, Sample Size= 466 Skills Used: Geoprocessing, Geocoding, Graduated Symbols

Page 6: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Urban Planning Alumni in California

California = ~400 Alumni

Average Commute is ~16 miles(SCAG Report, 2001)

Legend

! Urban Planning Alumni

Cummute Buffer

San Francisc

o

Sacramento

Los Angeles

San Diego

Skills Used: Geoprocessing, Geocoding, Buffering

Page 7: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

California Comparison

Legend

Urban Planning Alumni

ABAG Region

SCAG Region

• Imperial• Los Angeles• Orange• Riverside

• San Bernardino• Ventura

¯ • Alameda• Contra Costa• Marin • Napa• San Francisco• San Mateo

• Santa Clara• Solano• Sonoma

Note: Councils of Governments were derived by querying County_Clip for each county and exporting to a new shapefile layer

ABAG (82 Alumni)

SCAG(269 Alumni)

Skills Used: Inset, Geoprocessing, Geocoding, Buffering, Attribute Sub-Sets Selections

Page 8: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Type of Organization

Government 32%

Private For-Profit Firm28%

Non-Profit Organization 22%

Educational Institution14%

Other4%

Alumni Living in SCAG Region

2010 Urban Planning Alumni Survey, Sample Size= 46 Skills Used: Geoprocessing, Geocoding, Graduated Symbols

Page 9: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Conclusion

Immediate Application:

• Luskin Public Affairs Welcome Days in April

Looking Ahead:

• Need more complete data for Alumni Networking,

Recruitment, Career Center, etc.

Future Mapping:

• Luskin Alumni by Industry, 5-10-15-year Incomes,

Residential Patterns

Page 10: UCLA Luskin School of Public Affairs Alumni Data Prepared by Kristen Figueira UP 206A Midterm Project

Skills Used

Inset map

Graduated symbols

Attribute sub-sets selections Councils of Governments were derived by querying California

counties for each county (For example: CA_County_Clipped, “Name” = ‘Los Angeles’ OR “Name” = ‘’Riverside’ OR “Name” = ‘San Bernardino’ OR “Name” = ‘Ventura’ OR “Name” = ‘Orange’ OR “Name” = ‘Imperial’

Buffering

Geoprocessing

Geocoding