Video Gallery

Using an Excel filter to find your Parent Teacher conference contact requests.

Go to Video Gallery Added Mar 17, 2021 •

Copy this URL:
Embed code:	<iframe class="edlio-embed-player" type="text/html" width="640" height="360" src="//www.richmondhillhs.org/apps/embed/?v=312960" frameborder="0" allowfullscreen></iframe> Change dimensions

Go HD

NOTE: If you are unfamiliar with turning on a filter in Excel please visit this site first - https://www.timeatlas.com/excel-autofilter/ Use this video to find parents who requested contact from you during Parent Teacher Conferences.

Show Transcript

in this video you will learn how to filter the data you will receive in the parent-teacher conference registration Google form to see which parents of your students would like contact you're going to receive a copy of this spreadsheet and your deal we email on Tuesday evening first let me show you had to go through each column then had to fill to your students if we look here the First, Co system Riverside Collins child last name first name column f is the parent name column G list the date on which they would like contact that she's in Thursday from 5:30 to 8 p.m. or Friday from 12:50 2:50 p.m. call Ameci's the parent phone number column ice email address column J is which type of contact they would like either phone call or Google meet columns K through us that's a departments in the guidance counselors in this is where you going to filter tool store here to example Colin K is English Department so let's filter by my dear friend mr. canzoneri at dropped on our right here and you'll see these are all the English Department teachers even the cotard classes so we check this box and that'll deselect all the English teachers and then he just wants him to stay canzoneri so we checked Mystic hands and everything okay now request 11 can I please scroll over to the date request these are the dates so they make V that you could also discount to make it more easy to read again and now Thursday listed on top and Friday list on the bottom so Mr canzoneri parents with eight of nine of them actually would like Thursday evening contact if possible and to her on Friday and also the phone call with a Google meet someone right here aspesi celaya would like a Google me on Friday I hope this video helps you have any questions don't hesitate to reach out

Uploaded by John Antinora. Listed in Staff Handbook & Resources

Video Gallery

Using an Excel filter to find your Parent Teacher conference contact requests.

Popular Videos