EduTip 29: Build relationships with a spreadsheet.

The Cult of Pedagogy Podcast

Jennifer Gonzalez

Education, Teaching, Instruction, Classroommanagement, Educationreform

4.8 • 2.4K Ratings

🗓️ 4 May 2025

⏱️ 5 minutes

🔗️ Recording | iTunes | RSS

🧾️ Download transcript

Summary

Lots of teachers give students some kind of questionnaire at the beginning of a school year to get to know them, but what do you do with that information after you get it? By putting responses into a spreadsheet, you'll have a relationship-building tool you can use all year.

-------------------

Thanks to Studyo for sponsoring this tip. You can find written and video versions of these at cultofpedagogy.com/edutips.

Transcript

Click on a timestamp to play from that location

0:00.0	Welcome to EduTip 29, where I'll be sharing how to build relationships with a spreadsheet.
0:06.4	Edutututips is a side project of the Cult of Pedagogy podcast where I share one quick idea to make your teaching better.
0:13.2	This is Jennifer Gonzalez, and I am your host.
0:16.7	EduTip 29 is sponsored by Studio.
0:19.8	Studio is a planning tool which allows students to track and plan all of their classwork by estimating how much time a task will take and dividing larger tasks into smaller steps. This is a valuable tool to support parent conversations and help each student plan their work and pace themselves.
0:38.6	Coaching students on better organization has a direct impact on their grades as well as their
0:43.7	long-term success. Studio offers a free plan that allows students and parents to view all Google
0:50.7	classroom assignments and allows teachers to post to Google Classroom directly
0:55.8	from their schedule as well as track student organization. School and district plans come
1:01.5	with added features like centralized timetables, workload management, and more LMS integrations.
1:09.2	Visit Studio.co slash Pedagogy, that's sTU-D-Y-O dot CO slash pedagogy, to create your free account now and get your students planning.
1:22.6	Today's edut tip is build relationships with a spreadsheet. Lots of teachers give their students some kind of
1:29.3	questionnaire at the beginning of a school year or semester, a forum where they can tell you about
1:34.6	their interests, preferences, things you should know about them as a student, favorite movies, books,
1:40.4	TV shows, all kinds of things. I gave one of these to every student in every class every year,
1:46.9	and I loved reading them and learning more about the people I would spend the next school year with.
1:52.0	But I made one mistake with those surveys that took me years to correct. I would read them only once,
1:59.2	put them in a file, and if I ever looked at them again, it wasn't until much later in the school year. I would read them only once, put them in a file, and if I ever looked at them again, it wasn't
2:02.7	until much later in the school year, often because I happened to stumble on the folder and go,
2:07.7	oh yeah, these things, and sometimes I'd flip through them, usually finding a few surprises on them.
2:14.4	By that point in the year, I had gotten to know my students a lot better, or so I thought,
2:19.4	and while lots of things were right in line with what I knew about most kids, there were always
	...

Please login to see the full transcript.

Previous episode | Next episode

Disclaimer: The podcast and artwork embedded on this page are from Jennifer Gonzalez, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Jennifer Gonzalez and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.