The REL Mid-Atlantic develops tools to address the pressing needs of our stakeholders.
The automated teacher diversity district tool is designed to help state education agency staff support districts in identifying gaps in the diversity of their teacher workforces. It is an automated version of the prior Teacher Diversity District Tool. The automated tool generates district-level reports that provide the racial/ethnic make-up of a district's student and teacher populations and its three- and five-year teacher retention rates by race and ethnicity. The template can be used to prepare reports for any number of districts. Inputting the data could take as little as 30 minutes if the data are readily available. After gathering and entering the necessary data, the tool takes one to two minutes to generate district reports.
The automated teacher diversity district tool includes four components:
The teacher diversity district tool is designed to help state education agency staff support districts in identifying gaps in the diversity of their teacher workforces. The tool generates district-level reports that provide the racial/ethnic make-up of a district's student and teacher populations and its three- and five-year teacher retention rates by race and ethnicity. The template can be used to prepare reports for any number of districts but is intended to produce reports for around 20 to 30 districts. For 20 to 30 districts, the template will take approximately two to three hours to use, depending on the availability of the necessary data. For a larger number of districts, the template may take substantially longer to use.
The teacher diversity district tool includes three components:
Chronic absenteeism is particularly high in pre-kindergarten and kindergarten, compared with elementary and middle school. For a young child to succeed and develop a strong foundation for learning, he or she must attend school regularly. U.S. Department of Education’s Regional Educational Laboratory (REL) Mid-Atlantic has partnered with the New Jersey Department of Education (NJDOE) to provide support of their initiative called Go-Learn-Grow: Improving the School Attendance of New Jersey’s Youngest Learners.
NJDOE and REL Mid-Atlantic created this toolkit Strategies for Improving Attendance in Pre-Kindergarten and Kindergarten: Toolkit for Districts, Schools, and Early Childhood Providers, with simple, easy-to-use resources and handouts to support districts, schools, and early childhood providers in improving school attendance in pre-kindergarten and kindergarten. The goals of these materials are to:
REL Mid-Atlantic developed this tool to help users pool and summarize data with everyday programs like MS Excel, Google Drive, and Google Forms complete with step-by-step instructions. Pottstown School District asked REL Mid-Atlantic for help in improving the process of collecting data required for reporting and accountability. Specifically, the district was looking for solutions to overcoming the challenges of entering data manually from paper forms, obtaining data from online systems in a usable format, and automating agencies' and foundations' reporting requirements.
Teachers, principals, administrators, and analysts looking for ways to access data, improve reporting, and increase efficiency may use these templates to access, read, and interpret data from State Longitudinal Data Systems. These tools, developed by REL Mid-Atlantic, help to automate processes and document connections to relational databases. Specifically, you'll learn how to connect to data warehouse environments and how to automate Excel, SPSS, and SAS routines in a Windows environment using Task Scheduler.
Implementing Database Connections
Automating Data Acquisition
Get to know your students' interests, activities outside the school, and home life with this simple Excel template. This spreadsheet was inspired by the “I wish my teacher knew…” movement which gave students an opportunity to express needs that are not measured by standard student data collection methods.