1 / 52

Enabling Public Use of Education Data with EdExplorer

2012 MIS Conference. Enabling Public Use of Education Data with EdExplorer. A Visualization Odyssey. Agenda. 1. Introductions 2. Background 3. Front Page 4. Performance Explorer 5. School Finder 6. Institution Profile 7. Future Plans 8. Demo and Questions. Introductions.

marshall-porter
Download Presentation

Enabling Public Use of Education Data with EdExplorer

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2012 MIS Conference Enabling Public Use of Education Data with EdExplorer A Visualization Odyssey

  2. Agenda 1. Introductions 2. Background 3. Front Page 4. Performance Explorer 5. School Finder 6. Institution Profile 7. Future Plans 8. Demo and Questions

  3. Introductions • Josh Klein, Chief Information Officer • Brett Luelling, Director of Application Development • With the Oregon Department of Education (ODE)

  4. Background, The Beginnings • Colorado’s visualization • Increased visualization for public consumption • Balancing needs of researchers and general public

  5. Background, Tool Selection • Cross functional team for evaluation • Several months were spent evaluating tools • Collaboration with Dundas and Microsoft • Examined other organizations' solutions • NAEP • Colorado • Arkansas

  6. Front Page • Redesign project was started in the Spring of 2010 • Goal was to reduce the number of clicks to critical pieces of information • Integrate new technologies and modernize the look and feel • New Front Page was released in November of 2010

  7. Front Page, Cont. • Old Front Page

  8. Front Page, Cont. • New front page takes advantage of rotators • Using the TelerikWeb toolkit • Presents news and school/district performance information • Uses roles to tailor the items presented

  9. Front Page, Cont.

  10. Front Page, Cont. • New Search • Based on Microsoft Sharepoint Search Express • The search crawls our website hourly for new links/content • Uses a combination of weighting and link popularity to elevate search results • Nightly categorization updating and optimization for following day

  11. Front Page, Cont.

  12. Performance Explorer • In 2005, the original Public Assessment Group Reports application was released. • Allowed the public to view the statewide assessment results by district, school, and various subgroups by subject.

  13. Performance Explorer, Cont. • Old Assessment Results Application

  14. Performance Explorer, Cont. • Project began in the Spring of 2010 • Goal was to provide charts that would help the public understand the statewide assessment results • Released in March of 2011

  15. Performance Explorer, Cont. • Application uses: • Infragistics map control • Silverlight • Dundas charts • OLAP Cube

  16. Performance Explorer, Cont. • Link to EdExplore

  17. Performance Explorer, Cont. • School District Map

  18. Performance Explorer, Cont. • Fast and easy way to get information by ESD

  19. Performance Explorer, Cont. • Allows for aggregation by County

  20. Performance Explorer, Cont. • Filters are fast and easy • Data updates as filters are chosen • Filters may change when a different chart is selected

  21. Performance Explorer, Cont. • Easy to switch from viewing data by chart or by a data grid • Export capability of the selected chart or both the data grid and chart

  22. Performance Explorer, Cont. • Charts • Performance Detail by Selected Subgroup • Performance Summary by Selected Subgroup • Mean Score and Standard Deviation • Performance Trend

  23. Performance Explorer, Cont. • Performance Detail by Subgroup

  24. Performance Explorer, Cont. • Performance Summary by Subgroup

  25. Performance Explorer, Cont. • Mean Score and Standard Deviation

  26. Performance Explorer, Cont. • Performance Trend

  27. Performance Explorer, Cont. • PDF and • CSV Export

  28. Performance Explorer, Lessons • Silverlight adoption was not as widespread as hoped • Challenges with mobile devices • OLAP Cubes provide quick access to aggregate data • Allows for Business Intelligence tools • Creates challenges in providing Quality Assurance of the data • Cultural shift for both customers and IT staff

  29. School Finder • Developed in conjunction with the Performance Explorer • Released in March of 2011 • Allows the public to search an address and find the school district and surrounding schools • Uses Bing maps

  30. School Finder, Cont. • Uses Bing Maps

  31. School Finder, Cont. • Infragistics map controls • Search features, and map navigation, are located on the left

  32. School Finder, Cont. • District highlighted in yellow • Entered address is yellow diamond • Surrounding schools are red diamonds

  33. School Finder, Lessons • GIS layer is not maintained by our office, which creates challenges • School District boundaries on the layer are drawn with “fat markers”

  34. Institution Profile • 1990 Measure 5 passed • Shifted funding for public education from local property tax to the state (equivalent to 70% of school funding). • 1997 HB3636 passed in the Legislature • Directed ODE to produce expenditure data for Schools and Districts, and to make the data publicly available. • The Database Initiative (DBI) was born.

  35. Institution Profile, Cont. • DBI was piloted with 16 Districts in September of 1997. • In 1999, ODE began a Statewide rollout.

  36. Institution Profile, Cont. • DBI allows for filter selection

  37. Institution Profile, Cont. • Example of the 2011-12, October 1st Enrollment by Ethnicity

  38. Institution Profile, Cont. • Statewide data can be downloaded into CSV

  39. Institution Profile, Cont. • Institution Profile Project began in 2011 to replace the DBI reports • Goal was to provide a visualization rich tool for the public • Allows for District/School Comparison • Will be released soon

  40. Institution Profile, Cont. • Select two Districts/Schools to compare

  41. Institution Profile, Cont. • Provides a range of data using tab display, grids, and charts

  42. Institution Profile, Cont. • Free and Reduced Lunch

  43. Institution Profile, Cont. • Spending per Student

  44. Institution Profile, Cont. • October 1 Enrollment

  45. Institution Profile, Cont. • PDF and • CSV Export

  46. Institution Profile, Cont. • Pivot control provides ad hoc queries

  47. Future Plans • ODE API • Student, Teacher, and Course Identifier provisioning Web services • Data from Institution Profile available via Web service

  48. Future Plans • Front Page • Implementation of Microsoft Sharepoint Fast Search • Continued streamlining of sub pages off front page • Implementation of Microsoft Sharepoint for Web Content Management

  49. Future Plans • Performance Explorer • Discipline Charts (coming in March) • English Language Proficiency Assessment Charts • Additional core subject charts • Career Technical Education Charts

  50. Future Plans • Institution Profile • Additional accountability measures (items from the School and District Report Card)

More Related