How to Make a Teacher Data Hub for Daily Use with Rick Meyer
From Transformative Principal · Hosted by Jethro Jones
Episode summary
In this episode of Transformative Principal: Rick Meyer, an elementary principal in Sidney, Nebraska, built a teacher data hub in Google Sheets and Google Forms that puts student data in one place. Teachers enter nothing. Paraprofessionals, students and the principal feed it, and teachers open one tab to see their own class.
Original publisher description
Rick Meyer, an elementary principal in Sidney, Nebraska, built a teacher data hub in Google Sheets and Google Forms that puts student data in one place. Teachers enter nothing. Paraprofessionals, students and the principal feed it, and teachers open one tab to see their own class. Meyer's daily student check-in shows what it looks like. Students pick a feeling on a Google Form each morning, and teachers see who marked sad, tired, worried or mad. Average tired students per day dropped from 48.9 in August to 20.7 in November, which Meyer credits partly to parents becoming aware. What you'll learn Decide what data you want teachers to see and who will enter it before you build anything.Have students, paraprofessionals and admin enter data through Google Forms so teachers never have to.Keep one locked master sheet of test scores and import scores into every other sheet so nobody can change them.Tie every sheet to one class list that your secretary updates so new students appear everywhere at once.Share monthly trends with parents, as Meyer did with a Canva pie chart of student feelings. Chapters 0:00 Why a data hub puts data in teachers' hands6:26 Google Sheets, Google Forms and who enters data10:26 Daily student check-in dashboard and tired-student trend23:04 Weekly progress monitoring and Sonday Phonics pacing30:42 Protecting data with locked sheets and lookups34:07 Raider badges and Freckle intervention standards43:51 Behavior data and parent reports50:46 What to collect first and archiving each year Times are for the episode without ads. Your player may be off by the length of any ads. Questions this episode answers How can a principal give teachers student data without adding work? Meyer uses Google Forms that feed Google Sheets. Paraprofessionals enter progress monitoring scores, students enter their own check-ins and badges, and he or his coach enters major test scores three times a year. Teachers only open their tab and read. How do you protect school data in a shared spreadsheet? Meyer locks his master test score sheet so only two people can open it. Every other sheet pulls scores with import ranges and lookup formulas, so teachers see the data but cannot change or fudge it. What data should go in a teacher data hub? Meyer's hub covers daily check-in and attendance, weekly progress monitoring with a goal line, monthly PBIS badges and Freckle intervention standards, and behavior logs as needed. He says to start by choosing what you want teachers to have at their fingertips. About Rick Meyer Elementary principal in Sidney, Nebraska, with 19 years in education as a kindergarten teacher, district technology coordinator and administrator. Working on this at your school? Get a free preview of a 10-week leadership pathway built from episodes like this one at transformativeprincipal.com/start. Thanks to our Sponsor Broadcast Made Easy who help you start a news broadcast at your school by having everything you need in one easy-to-download place. Check it out today and get your kids creating. We’re proud to be sponsored by IXL. IXL’s comprehensive teaching and learning platform for math, language arts, science, and social studies is accelerating achievement in 95 of the top 100 U.S. school districts. Loved by teachers and backed by independent research from Johns Hopkins University, IXL can help you do the following and more: Simplify and streamline technologySave teachers’ timeReliably meet Tier 1 standardsImprove student performance on state assessments 🚀 Ready to see why leading districts trust IXL for their educational needs? Visit IXL.com/BE today to learn more about how IXL can elevate your school or district.