Google Classroom

StAwash · May 26, 2022

Hi,

Any automated tools that can manage, access, aggregate data, and basically control and run Google Classroom as an admin?

I do not want to hear "Just get the teacher to add you to the classroom", as I'm a tech that has come in mid-implementation on this campus, various teachers have left and joined (so some classes are just inoperable!), and to top it off the previous tech stupidly left the option to allow students to make their own classrooms! I am surely not getting added to student ran classrooms.

I have access to the Google API for classrooms: https://developers.google.com/classroom

I'm also a programmer (skill is yet to be seen) so I can technically write my own tools. I just don't want to right now.

Any help, because I am drowning in student led classrooms here and I need to start getting them into the suspended status asap!

Sonic007 · May 26, 2022

I looked into this and as far as I could see you needed to be a teacher of each class to be able to make changes which means having to put yourself in each one.

I guess you could at the start of term create all the classes and add each teacher in too. Then you regain control of them but you'l receive all the notifications about assignments, students chatting, etc which is annoying so bare that in mind.

StAwash · May 26, 2022

I looked into this and as far as I could see you needed to be a teacher of each class to be able to make changes which means having to put yourself in each one.

I guess you could at the start of term create all the classes and add each teacher in too. Then you regain control of them but you'l receive all the notifications about assignments, students chatting, etc which is annoying so bare that in mind.

Using the tools on the link above, as they include the tools to test (ON LIVE DATA! BE WARNED), I have managed to: create a classroom; delete a classroom; list all classrooms associated with our organisation (up to 200!); add myself as a student and as a teacher into a classroom; and pull user information out of a classroom.

So adding myself into each class isn't strictly necessary. Easier, perhaps, but not necessary. So the API to build these tools is most definitely there, I was just curious if anyone else had capitalised on it because Google sure hasn't!

Have come across GAM, like 30 seconds after posting, which is my usual way when doing stuff like this... Search search search, can't find anything, post for help and instantly find what I need!

GAM might not be comprehensive enough though, still looking through the notes.

F_admin · May 26, 2022

GAM would allow you to manage Google Workspace through a CLI - you can add and remove teachers from Classrooms etc.

Here's the link to the resource:

https://github.com/taers232c/GAMADV-XTD3

Here's a good list of commands and what they can achieve:

https://sites.google.com/jis.edu.bn/gam-commands/home

I've not had to set it up myself but I must say that it is a brilliant tool.

EDIT: Here's the link to actually select the service you wish to run a command for and view commands:

https://sites.google.com/jis.edu.bn/gam-commands/services

Edited May 26, 2022 by F_admin

ITGuyNW · May 26, 2022

These are some handy GAM commands I have on a spreadsheet here. Replace bold with the information you have.

[TABLE=width: 512]

[TR]

[TD=colspan: 3]Adding student to a class[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 5]gam course course id add student email address[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 3]View course participants[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 6]gam print course-participants course course id todrive[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 2]Inviting Guardians[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 6]Gam create guardianinvite parents email pupils email[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 4]Find out Submissions information[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 6]gam print course-submissions student email address todrive[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 5]Find out what courses a student has signed up for[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 6]gam print courses student/teacher email address todrive[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 4]Find out all courses Information[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 3]gam print courses todrive[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 5]Add students to a course from email addresses[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 6]gam csv c:\.csv gam course course ID add student ~Email[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 4]Find out all courses inc owner email[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 5]gam print courses state active owneremail todrive[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 3]Add admin to all courses[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 8]gam print courses | gam csv - gam course ~id add teacher email address[/TD]

[/TR]

[TR]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 4]Update list of courses to Archived[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=colspan: 7]gam csv c:\unknown.csv gam update course ~id state ARCHIVED[/TD]

[TD][/TD]

[/TR]

[/TABLE]

David44 · May 26, 2022

Look at https://psgsuite.io/ if you want to do it via PowerShell. That's what we do.

paulkerton · May 26, 2022

Install GAM on Cloud Shell. Doesn't matter where you are, or what machine you're on then - and you can secure it behind your Google Login/2SV

https://basuta.com/posts/installing-google-apps-manager-gam-on-google-cloud-shell/

RLR · May 26, 2022

+1 for GAM / GAM3. It does so much more than google classroom too just in case you need to do other google related jobs.

jthompson · May 26, 2022

Yeah, even if a nice management webapp for Google Classroom does come along, you'll still want a GAM or an equivalent CLI tool on hand for plenty of other little tasks for which there is no GUI option available: hiding a group, setting signatures, delegating mailboxes, subscribing users to calendars, etc.

highsky · May 27, 2022

This is like an exposed set of gam commands to your Google sheets, it's an add-on

https://www.goldyarora.com/classright/

There's the same for the generic g workspace task

Google gave us a call about our experience and our main complains was the luck of a classroom management

and the bug where a class owned by a deleted staff is unmanageable from the administrators, with gam or no gam.

You can manipulate classes ownership as long as the owner is live or suspended.

The issue is when you delete them.

I haven't played with the option to transfer the ownership of their files during the deletion, but then this will take up space...

Google Classroom

Recommended Posts

StAwash

Sonic007

StAwash

F_admin

ITGuyNW

David44

paulkerton

RLR

jthompson

highsky

Create an account or sign in to comment

Create an account

Sign in

Recent Threads

Confirm acknowledgement of parental consent requirement for the Additional Google services

Lenovo Tablet Firmware

Outloook 365 - Classic

Home

Forums

What's New