DatabasED

Our guests this week are Dr. Shane Fairbairn and Sherod Keen from the North East Florida Educational Consortium, or NEFEC. NEFEC is a regional nonprofit educational service agency established to provide cooperative services to small and rural member districts. Through membership in NEFEC, districts are able to meet educational goals and objectives more effectively and affordably. They offer a wide range of programs and services, but today we will primarily be discussing their implementation of the Ed-Fi data standard. NEFEC was the first local education agency consortium to implement the Ed-Fi data standard, beginning in 2013 and serving 15 member districts. Shane, Sherod, and their other colleagues at NEFEC were instrumental in helping guide INsite's own implementation of the Ed-Fi data standard. During the episode, Shane shares his love of metaphors, Sherod predicts the future of Ed-Fi, and we learn that Rosh is chock-full of dependencies. Episode links: NEFEC (North East Florida Educational Consortium): https://www.nefec.org/ FLCODE (Collaborative on Operational Data for Educators): https://www.flcode.org/ CELT (Center for Educational Leadership and Technology): http://www.celtcorp.com/

“Everything we do supports the teacher-student relationship.” Adam Love, assistant principal at Decatur Middle School in the Metropolitan School District (MSD) of Decatur Township in Indianapolis, was one of the first school-level stakeholders to work closely with us on utilizing interoperable data to make a difference in the lives of students in his building, and his work ultimately resulted in the establishment of data-driven decision making processes across the district. His dedication to his students and teachers inspires us every day, and we are so pleased to share his story and vision with the DatabasED audience. Show notes: https://www.kotterinc.com/8-step-process-for-leading-change/ Kotter's model for organizational change. Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9 Support by RFM - NCM

In this episode, we talk with educational consultant, data scientist, book author, podcast host, and former educational psychologist Ryan Estrellado about living in the Venn diagrams of overlapping professional communities and finding your (our) place in those intersections. We talk about practical strategies for working with educators who have a wide variety of interests in data and specifically tools for data analysis, and about breaking down common misconceptions about data analysis or data science as it can be used to answer real questions in local educational settings. Although we had planned to focus the episode on Ryan's new book, we accidentally ended up spending an entire hour discussing about unusual professional trajectories and how data and coding have influenced all of us (for the better). Some day we will do another episode where we actually talk about Ryan's book, but in the meantime, we recommend that you go ahead and check it out! The content is truly accessible to all educators, wherever you happen to be in terms of your data journey (whether that journey was embarked upon voluntarily or otherwise). Check out the link below to get a 20% off code for the book! Abbreviations: IDE: Integrated development environment https://www.codecademy.com/article/what-is-an-ide Show notes: Go to ryanestrellado.com to download a free chapter of The K–12 Educator's Data Guidebook and a 20% off code The K-12 Educator's Data Guidebook: Reimagining Practical Data Use in Schools Donuts in the Lounge: A Podcast for Educators Follow on Twitter & Instagram @ry_estrellado Data Science in Education using R (free open-source book with hands-on activities to learn R using real-world education contexts): https://datascienceineducation.com/ Strategic Data Project at Harvard: https://sdp.cepr.harvard.edu/home South County SELPA at the San Diego County Office of Education: https://www.sdcoe.net/special-populations/selpas/scselpa Chase Jarvis, Creative Calling https://www.creativelive.com/class/creative-calling-chase-jarvis/lessons/amplify-your-community About Practice podcast (Ryan Estrellado & Joshua Rosenberg): https://open.spotify.com/show/4TzYLKTen3ZiJxiiKdHAsa R Studio (free download): https://www.rstudio.com/products/rstudio/ Tidyverse: https://www.tidyverse.org/ Hadley Wickham's website and list of books: https://hadley.nz/ Julia Silge: https://juliasilge.com/about/ Kieran Healy: Data Visualization: A Practical Introduction https://socviz.co/ Rosh's favorite vending machine video: https://www.youtube.com/watch?v=mMW6JKNop1Y Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9 Support by RFM - NCM

In part II of Episode 10 (or technically Episode 11, because Anchor does not recognize decimal points), we dive even deeper into the challenges and potential solutions to balancing the need for increased linkages between individualization and standardization of special education data, as well as the possible integration of compliance and accountability processes. Sarah has a data epiphany as well as an idea for a new grant proposal, Joel confesses his newfound love for data science, and Jennifer crosses "podcast guest" off her bucket list. Part II episode resources: SEA: State education agency Results-driven accountability (U.S. Department of Education): https://www2.ed.gov/about/offices/list/osers/osep/rda/index.html Results-driven accountability Indicators (Indiana): https://www.in.gov/doe/students/special-education/results-driven-accountability/ Discussion of federal policies increasing equity: https://learningpolicyinstitute.org/product/advancing-education-2020-brief Music: Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9 Support by RFM - NCM

Today we bring you the first segment of a very special two-part episode in which we get to speak with three guests representing all three of the focus areas that we've been working to bridge in this podcast: Joel Boehner, Assistant Director of Exceptional Learners at South Bend Community School Corporation, Dr. Sarah Hurwitz, associate professor in special education at Indiana University - Bloomington, and Dr. Jennifer Meller, Associate Manager for Special Education Consulting Services at PCG (Public Consulting Group), the vendor providing the statewide Indiana IEP (IIEP) software for managing data and documents related to the education of students with disabilities. In the first segment of this episode, we discuss how the connections among these individuals' work came about, as well as several relatively recent trends in the federal requirements for educating students with disabilities, such as the move from a focus on compliance to results-driven accountability (RDA) and the challenges and opportunities for utilizing a data standard with very individualized education goals and progress data. We hope you enjoy listening to this as much as we enjoyed recording it! Stay tuned for Part II next week. Show notes & abbreviations Joel Boehner: https://www.linkedin.com/in/joelboehner/ Dr. Sarah Hurwitz: https://education.indiana.edu/about/directory/profiles/hurwitz-sarah.html Dr. Jennifer Meller: https://www.publicconsultinggroup.com/leadership/education/dr-jennifer-meller/ Equity in Action: https://education.indiana.edu/community/aac-in-action/index.html Autism Research Collaborative: https://www.iidc.indiana.edu/what-we-offer/autism/ INSOURCE: https://insource.org/ PCG (Public Consulting Group): https://www.publicconsultinggroup.com/ Indiana graduation pathways: https://www.in.gov/doe/students/graduation-pathways/ RDA: results-driven accountability NWEA (MAP - Measures of Academic Progress test from the Northwest Evaluation Association) https://www.nwea.org/the-map-suite/ LEA: local education agency (school district/school corporation) IDEA: Individuals with Disabilities Education Act: https://sites.ed.gov/idea/ IEP: Individualized Education Program (a requirement of the federal Individuals with Disabilities Education Act) IIEP (Indiana IEP): software program to manage IEP data in Indiana (statewide) FAPE: Free, appropriate, public education (a requirement of the federal Individuals with Disabilities Act) FBA: Functional Behavioral Assessment (part of the federal Individuals with Disabilities Education Act; https://www.pacer.org/parent/php/php-c215a.pdf) LRE: Least restrictive environment (a requirement of the federal Individuals with Disabilities Act) Music: Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9 Support by RFM - NCM

This week we talk with two leaders from the Metropolitan School District (MSD) of Steuben County in Angola, Indiana, Chantell Manahan (Director of Technology) and Dr. Schauna Relue (Curriculum Director). Over the past two years, our guests have worked as a close, cross-sectional team on the district's use cases for student and district improvement as part of their implementation of the Ed-Fi data standard. In the episode, we discuss their strategies for data governance, the importance of professional development and support in changing data practices, and ways in which technology can enhance data-driven improvement processes such as “data war rooms.” Show notes and abbreviations: Metropolitan School District (MSD) of Steuben County - https://www.msdsteuben.k12.in.us/ CETL certification from the Consortium for School Networking (CoSN) Certified Educational Technology Leader https://www.cosn.org/careers-certification/cetl-certification/ NWEA (MAP - Measures of Academic Progress test from the Northwest Evaluation Association) https://www.nwea.org/the-map-suite/ CSV files: https://www.howtogeek.com/348960/what-is-a-csv-file-and-how-do-i-open-it/ SIS: student information system RACI (Responsible, Accountable, Consulted, Informed) Matrix: https://cio-wiki.org/wiki/RACI_Matrix WIDA: An assessment of academic English levels for non-native English speakers (https://wida.wisc.edu/) Eidex: https://www.eidexinsights.com/ Michigan DataHub: https://open.spotify.com/episode/43wLYDeU6Mi73ViGnW2d2u?si=3MmlfGVUTzC2hA1yY4_qoQ Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9 Support by RFM - NCM

In this episode, Silvia Brunet-Jones, Technical Program Director of the K-12 Technology portfolio at the Michael & Susan Dell Foundation, gives us the origin story of Ed-Fi, which goes all the way back to Hurricane Katrina and student relocations from Louisiana to Texas. She highlights the early focus in the development of Ed-Fi of providing value both for state accountability reporting and for local district operational data use for teaching, learning, intervention, research allocation, and other purposes. In discussing current needs and priorities, Silvia speaks about humanizing the data, providing agency and empowerment for data owners and users, and the need for cross-sectional teams and empathy among different stakeholders. Listen to the end to enjoy a brief blooper reel. Correction: The number of students displaced by Hurricane Katrina and relocated to Texas is cited as at least 46,000 (exact number unknown due to record keeping). https://www.edweek.org/leadership/post-katrina-some-students-gave-up-home-for-a-better-school/2015/08 Show notes and resources: Silvia Brunet-Jones: https://www.dell.org/employee/silvia-brunet-jones/ The Ed-Fi Academy: https://academy.ed-fi.org/ Balfanz, R., Herzog, L., & Mac Iver, D. J. (2007). Preventing student disengagement and keeping students on the graduation path in urban middle-grades schools: Early identification and effective interventions. Educational Psychologist, 42(4), 223-235. Acronyms: XML (6:12): https://www.howtogeek.com/357092/what-is-an-xml-file-and-how-do-i-open-one/ ODBC (13:59): https://docs.microsoft.com/en-us/sql/odbc/microsoft-open-database-connectivity-odbc?view=sql-server-ver15 SQL (14:26): https://www.khanacademy.org/computing/computer-programming/sql CSV (22:19) and comma delimited files: https://kb.blackbaud.com/knowledgebase/Article/75155 FTP (23:06): https://en.wikipedia.org/wiki/File_Transfer_Protocol API (23:35): https://www.ibm.com/cloud/learn/api SIS (38:44): Student Information System (student information databases within school districts) Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9Support by RFM - NCM: https://bit.ly/2xGHypM

In this episode, we reminisce with Tim Pritchett, Technology Director at Monroe County Community School Corporation here in Bloomington, about our experiences moving through the early and difficult stages of implementing Ed-Fi and how we all ended up safely on the other side. We touch on personal and professional development, having faith in big ideas, and the power of multiple sectors being focused on one goal. Episode Resources: Sample Data Generator (Ed-Fi Tech Docs): https://techdocs.ed-fi.org/display/SDG/Sample+Data+Generator Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9 Support by RFM - NCM: https://bit.ly/2xGHypM

In this episode, we talk with Don Dailey, the 'Don' of Ed-fi collaboratives, about how he heralded the dawn of interoperability technology to Michigan's state education data systems (last godfather pun, we promise). But seriously, he does take us back to the days before personal computers, when student information and district finance systems were on mainframes. Don is the Director of Systems Integration and Interoperability providing leadership to the Michigan Data Hub project as part of the Michigan Association of Intermediate School Administrators. He spearheaded the Michigan Data Hub's implementation of the Ed-Fi data standard nearly 9 years ago, and he won the Ed-Fi Ambassador of the Year award in 2017. Don and his team have done an amazing job of successfully coordinating data and technology stakeholders, educators, researchers, and even state legislators and other policymakers. We have learned much from him over the years and are excited to have him share a slice of his knowledge in this episode. Show notes: Michigan Data Hub: https://www.midatahub.org/what-is-midatahub/what-is-the-midatahub/ Legislative Reports: https://www.midatahub.org/documentation/legislative-reports/ ROI Study: https://www.midatahub.org/downloads/data_integration/michigan_data_hub_roi_study_1.pdf Product Catalog: https://www.midatahub.org/product-catalog/ Michigan Association of Intermediate School Administrators: https://www.gomaisa.org/projects/michigan-data-hub/ Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9 Support by RFM - NCM: https://bit.ly/2xGHypM

In this episode, we talk with Dr. John Watson, data scientist at the San Diego County Office of Education, about the ways in which data scientists provide value for education organizations. We touch on the evolution of standards in education and the need to be aware of multiple intelligences (both within students and within educators looking at data); the (ideally) iterative process of data solutions and output within education agencies; the “emergency data collection” that occurred at the beginning of the pandemic; the development and limits of standards in the health and education sectors; and trying to balance rapid technological advances with the need for stability and investment in training. Episode resources: San Diego County Office of Education: https://www.sdcoe.net/Pages/Home.aspx Baker, R. S., Berning, A. W., Gowda, S. M., Zhang, S., & Hawn, A. (2020). Predicting K-12 dropout. Journal of Education for Students Placed at Risk (JESPAR), 25(1), 28-54. (early access version: https://www.upenn.edu/learninganalytics/ryanbaker/PredictingK12Dropout.pdf) Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9Support by RFM - NCM:

In this episode, we talk with Dr. Michael Gottfried, applied economist at the University of Pennsylvania, and Dr. Kent McIntosh, professor at the University of Oregon and co-director of the US Department of Education's Office of Special Education Programs' National Technical Assistance Center on Positive Behavioral Interventions and Supports (PBIS). Dr. Gottfried and Dr. McIntosh are experts on the use of transactional attendance and discipline/behavior data, respectively, in educational research and practice. We hear about their recent research findings and how these findings can be used by school and district staff to reduce inequitable outcomes among students by race/ethnicity. We also discuss the range of implications that pandemic-related school closures have had on research in these areas, and ideas for future research on student engagement and behavior beyond attendance and discipline records. Episode resources: Michael Gottfried: https://www.gse.upenn.edu/academics/faculty-directory/gottfried https://www.gse.upenn.edu/news/california-district-study-finds-latinx-students-latinx-teachers-attend-more-school Gottfried, M., Kirksey, J. J., & Fletcher, T. L. (2021). Do high school students with a same-race teacher attend class more often? Educational Evaluation & Policy Analysis. https://journals.sagepub.com/doi/full/10.3102/01623737211032241 Kent McIntosh: https://education.uoregon.edu/directory/faculty/all/kentm "A school-wide intervention that increases racial equity in exclusionary school discipline." https://www.apa.org/pubs/highlights/spotlight/issue-228# McIntosh, K., et al. (2021). Equity-focused PBIS approach reduces racial inequities in school discipline: A randomized controlled trial. School Psychology, 36(6), 433-444. https://doi.org/10.1037/spq0000466 Schoolwide Information System (SWIS) and Positive Behavior Intervention Support Apps (PBISapps.org): https://www.pbisapps.org/products/swis https://www.pbisapps.org/resource/referral-category-definitions https://www.pbisapps.org/resource/referral-form-examples-2

Andrew Rice, CEO of the nonprofit organization Education Analytics, joins us to discuss the roles that research and technology each have to play--separately and together--in the education data/analytics environment. Andrew is trained as an economist and has unique perspectives on the ways in which different sectors can complement each other to meet the needs of K12 education. We also discuss the challenges and rewards of hiring talented, creative, and multidisciplinary people to work in the not-for-profit and/or public sector.

In this episode, the INsite team talks with K12 analytics engineer Marcos Alcozer about his experiences and opinions with the idea of "real time" data and analytics in educational settings. We discuss the importance of understanding users' needs, get into operational databases versus denormalized data warehouses, consider the tradeoffs around performance and cost, and Marcos gets vulnerable about data governance. Episode resources: Marcos' youtube channel: https://www.youtube.com/channel/UCMtiBvdj_XGP4gDjh24Z0rw Dagster: https://dagster.io/ Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9Support by RFM - NCM: https://bit.ly/2xGHypM

“Data cannot speak for itself.” In our first episode, we speak with Dr. Alex Bowers, Professor of Education Leadership at Teachers College, Columbia University, about the topics of data analysis, predictive analytics, and working with educators to leverage data for student and community growth. We discuss his four A's of early warning systems, which should be Accurate, Accessible, Actionable, and Accountable, as well our experiences with the skillful and collaborative data work that classroom teachers and school leaders are doing across the country. We also touch on the differences between standardized assessments, classroom grades, and other measures of learning and performance; the multiple purposes of schooling in the U.S. and why we have local control; and how tech developers and researchers can better work with educators to help students and communities. Episode links: Alex Bowers: https://www.tc.columbia.edu/faculty/ab3764/ OECD Digital Education Outlook 2021: https://www.oecd-ilibrary.org/education/oecd-digital-education-outlook-2021_589b283f-en Bowers, A. J. (ed.) (2021). Data visualization, dashboards, and evidence use in schools: Data collaborative workshop perspectives of educators, researchers, and data scientists. New York, NY: Teachers College, Columbia University. https://doi.org/10.7916/d8-jj2g-e225 WWC rpt: https://ies.ed.gov/ncee/wwc/Docs/ReferenceResource/Distance_Learning_RER_508c.pdf Tamara Munzner: https://www.cs.ubc.ca/~tmm/ Peter Senge: https://www.systemsawareness.org/person/peter-senge/ Brookhart, et al. (2016). A century of grading research: Meaning and value in the most common educational measure. Review of Educational Research, 86(4), 803-848. https://journals.sagepub.com/doi/abs/10.3102/0034654316672069 Bowers, Sprott, & Taff. (2012). Do we know who will drop out? A review of the predictors of dropping out of high school: Precision, sensitivity, and specificity. The High School Journal, 96(2), 77-100. https://academiccommons.columbia.edu/doi/10.7916/D8FB5CZH/download UC Consortium on School Research: https://consortium.uchicago.edu/high_school The Data Wise Project: https://datawise.gse.harvard.edu/ Jim Popham: https://education.asu.edu/inside-the-academy-of-education/honorees/w-james-jim-popham Music: Exploring The World by Vlad Gluschenko is licensed under a Creative Commons License. https://creativecommons.org/licenses/... https://soundcloud.com/vgl9Support by RFM - NCM: https://bit.ly/2xGHypM