Skip to main content

Import Domain Google Classroom Assignment Details into a Google Sheet using GAMADV-XTD

If you want an overview of all of your Google Classroom Assignments across your domain, you can do this for free using GAMADV-XTD. There are paid for options to do this - but its pretty easy using GAM - in fact, a lot easier than I thought it would be!

Prerequisites

  • GAMADV-XTD setup on machine somewhere (I have a Virtual Machine just for GAM).
  • Optional - a list of all the classes you want to grab data for. You can do all your classes or just the active ones - but you may want to be selective. The command gam print courses todrive will export a list of all your domains classes to a Google Sheet. 
  • A target Google Sheet to receive the data.

To pull Classroom data into the sheet run the following command:

gam print course-work course "comma-separated list of classes"  creatoremail todrive tdfileid "idofsheet" tdsheet "Raw Data"

"comma-separated list of classes" = 1590000591,15942000091,15942120091 .... etc
"idofsheet" = the long string of characters in the url of the spreadsheet to dump the data into.
"Raw Data" = the name of the sheet in the spreadsheet

The creatoremail bit returns the email address of the teacher who made the assignment - you won't get this unless you include this option.

This takes about 10 minutes to run for around 500 classes. I run this command in a batch file as a scheduled task so the sheet gets updated every day.

Once you have the data in the sheet - I use an importrange function the pull the bits I want into another sheet which has various tabs for data anaylsis. Once you have the data in the sheet you can analyse it however you want.

There are lots of options for gam print course-work - so check out the link at the top.
Labels:

Comments

Post a Comment

Popular posts from this blog

Delete a specific email using GAM

If a user send an inappropriate email to a loads of people or get stung by some sort of email exploit you can quickly delete the email from all of the recipients using a GAM command. Step 1 - get the email header Go into Google Vault and search for the offending user or someone known to have got the message. Click show details and grab the email ID. This will be a long string of characters followed by @mail.gmail.com Step 2 - find out who has the email Go into Google Vault and find the original message sent by the offending user. Look at the details to see who got it. Copy the list and dump it into a spreadsheet. Clean up to just a list of emails with a column header 'mail'. Save as a csv file. Step 3 - delete messages with GAM Put your CSV file in your GAM folder - this e.g. assumes its called mail.csv Run: gam csv mail.csv gam user ~mail delete messages query rfc822msgid: MESSAGEIDHERE doit The alternative nuke option is: gam all users delete messages query rf...
Post a Comment
Read more

Adding subdomains to G Suite

This is how I add subdomains (so basically new schools) to out G suite setup. I've got these steps documented on a scruffy set of notes that I've now got in Keep - so time to document them - for myself as much as anyone else! Steps in order (roughly) Add the new domain Verify the new domain Add MX records to hosting Add SPF record for Google to hosting Turn on email authentication Add DMARC record to hosting Setup custom Directory and restrict students OU to this. Create an admin quarantine for the domain. Configure SPAM setting for the domain. Turn on and off services as appropriate. Map a blank Google Site to the naked domain - if required. Setup some basic groups - allstaff, allusers (for directory) and students with appropriate permissions. Deploy custom wallpapers. So the steps in a bit of detail: Add the new domain & Verify ownership Click on Domains in the admin console: Add/remove domains followed by "add a domain" At this...
Post a Comment
Read more

My favorite GAM commands - well a few of them at least!

Where would be without GAM? Paying for expensive syncing tools or doing tedious manual tasks in the admin console. GAM can automate most things you might want to do in G Suite. So these are a few of my favourite commands - one I use either as part of a batch file - or just standalone. There are loads more - but these are ones that are used daily. Classroom Create a spreadsheet of all your domains classes -  gam print courses todrive Create a spreadsheet of a teacher's classes:  gam print courses teacher fred@mydomain.com todrive Bulk create classes: gam csv classes.csv gam create course alias ~alias name ~alias section ~subject teacher ~teacher status ACTIVE where classes.csv is a list of classes you want to make. Add teachers: gam csv teachers.csv gam course ~alias add teacher ~teacher Add students: gam csv students.csv gam course ~alias add teacher ~student Sync Students (in this example to a group - but could be an ou/csv file) gam csv grou...
Post a Comment
Read more