Start a new topic

Query for getting Teacher Website and Meeting data

As an administrator, is there a way that I can do a query to get the Teachers info they input for Teacher Website and Meeting?  Having the ability to pull that up quickly to  see who is missing either their Teacher Website or Meeting info would be great.  


3 people have this question

Is it safe to assume that if the Website_URL has a classroom.google.com... that the teacher has linked their gradebook to a particular Google Classroom?


LIST MSS MST TCH MST.TN TCH.TE MST.PD MSS.SE MSS.NM MSS.SV MSS.DTS BY MST.TN MST.PD IF MSS.NM = "WEBSITE_URL" AND MSS.SV : CLASSROOM 



Lists Teachers who have a linked Classroom

LIST MSS MST TCH MST.TN TCH.TE MST.PD MSS.SE MSS.NM MSS.SV MSS.DTS BY MST.TN MST.PD IF MSS.NM = "WEBSITE_URL" AND MSS.SV : CLASSROOM


Lists Teachers who do not have a linked classroom

LIST MSS MST TCH MST.TN TCH.TE MST.PD MSS.SE MSS.NM MSS.SV MSS.DTS BY MST.TN MST.PD IF MSS.NM = "WEBSITE_URL" AND MSS.SV = " "


 

 

 

We have some teachers who have Google Classrooms and linked to the gradebook, however, the classroom summary does not indicate as such.  


The Master Schedule displays the Website URL for Google Classroom, but it does not appear to be linked in Classroom Summary.  It is misleading.  


Can Aeries have it link automatically so that it does not look like the teacher does not have a Google Classroom?


In gist, why would Classroom Summary graphically indicate that the Google Classroom is not linked with an Aeries Gradebook?

Figured out it's stored in the MSS table for MST based sites, so a query to see by teacher and period is:


LIST MSS MST TCH CRS TCH.TE MST.PD MSS.SE CRS.CO MSS.SV BY TCH.TE MST.PD IF MSS.NM = "OnlineMeeting_URL" 


For elementary based sites it's stored in the gradebook options table, GBO but I have not been able to link it back to the teacher table. GBO does have an ID field that is the gradebook number, but it's not cooperating with any queries using GBK. 


LIST GBO IF GBO.OPN = "Website_URL"

Login to post a comment