Classroom report

251 views
Skip to first unread message

Mark Monahan

unread,
Apr 6, 2020, 7:38:57 PM4/6/20
to GAM for G Suite
I've been writing a "gam print" command to look at Google Classroom submissions, but the resulting spreadsheet/Google Sheet is too big for Google to handle (in excess of 250 columns) In reality I only want a handful .
I have been able to do gam reports which allow me to specify parameters, such as classroom:timestamp_last_interaction but when using gam print for Google classroom submissions it says parameters are unknown.

Here is what I have been trying to do:

gam print course-submissions parameters classroom:CourseName,classroom:profile.emailAddress,classroom:profile.name.givenName,classroom:state,classroom:creationTime,classroom:profile.name.familyName,classroom:profile.name.givenName start -1d end -0d todrive



Ross Scroggs

unread,
Apr 6, 2020, 8:14:30 PM4/6/20
to google-ap...@googlegroups.com
Mark,


parameters are used in the Report API, the classrrom API uses fields. Unfortunately, the API doesn't return an user profile information; here are defined fields:
<CourseSubmissionFieldName> ::=
        alternatelink|
        assignedgrade|
        courseid|
        courseworkid|
        courseworktype|
        creationtime|
        draftgrade|
        id|
        late|
        state|
        submissionhistory|
        updatetime|
        userid|
        worktype


gam print course-submissions fields courseid,courseworkid,id,state,creationtime,userid start -1d end -0d todrive

Ross

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/78bd3f2e-5212-435d-a5d2-960f4c7b1e6b%40googlegroups.com.

Ross Scroggs

unread,
Apr 7, 2020, 11:42:17 PM4/7/20
to google-ap...@googlegroups.com
Mark,

I was correct in saying that the classrom API doesn't return user profile information; however, the showuserprofile
option causes GAM to display the user profile information by using additiona API calls to get the profile data.

Ross

Unhappy Buckaroo

unread,
Apr 8, 2020, 2:59:07 PM4/8/20
to GAM for G Suite
Hi Ross:
Our students are on a separate domain, which is whitelisted so we can use Classroom.
I don't suppose this works across domains?

On Tuesday, April 7, 2020 at 9:42:17 PM UTC-6, Ross Scroggs wrote:
Mark,

I was correct in saying that the classrom API doesn't return user profile information; however, the showuserprofile
option causes GAM to display the user profile information by using additiona API calls to get the profile data.

Ross
On Apr 6, 2020, at 5:14 PM, Ross Scroggs <ross....@gmail.com> wrote:

Mark,


parameters are used in the Report API, the classrrom API uses fields. Unfortunately, the API doesn't return an user profile information; here are defined fields:
<CourseSubmissionFieldName> ::=
        alternatelink|
        assignedgrade|
        courseid|
        courseworkid|
        courseworktype|
        creationtime|
        draftgrade|
        id|
        late|
        state|
        submissionhistory|
        updatetime|
        userid|
        worktype


gam print course-submissions fields courseid,courseworkid,id,state,creationtime,userid start -1d end -0d todrive

Ross
On Apr 6, 2020, at 4:38 PM, Mark Monahan <mmon...@srwa.co.uk> wrote:

I've been writing a "gam print" command to look at Google Classroom submissions, but the resulting spreadsheet/Google Sheet is too big for Google to handle (in excess of 250 columns) In reality I only want a handful .
I have been able to do gam reports which allow me to specify parameters, such as classroom:timestamp_last_interaction but when using gam print for Google classroom submissions it says parameters are unknown.

Here is what I have been trying to do:

gam print course-submissions parameters classroom:CourseName,classroom:profile.emailAddress,classroom:profile.name.givenName,classroom:state,classroom:creationTime,classroom:profile.name.familyName,classroom:profile.name.givenName start -1d end -0d todrive




--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

Ross Scroggs

unread,
Apr 8, 2020, 3:48:38 PM4/8/20
to google-ap...@googlegroups.com
Andrew,

Not at the moment, but I'm on the case.

  Find us on Facebook:
  Follow us on Twitter: 

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/a0d6375f-94a4-4e4a-baee-22e35a18ac5c%40googlegroups.com.

Penner, Andrew

unread,
Apr 8, 2020, 5:21:31 PM4/8/20
to google-ap...@googlegroups.com
That would be stupendous!
______________________________________________________
Andrew Penner, Technical Analyst III (A+, MCP, MCDST)
Office: 780-460-3712 (333)
60 Sir Winston Churchill Ave
St. Albert, AB T8N 0G4




To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/78bd3f2e-5212-435d-a5d2-960f4c7b1e6b%40googlegroups.com.


  Find us on Facebook:
  Follow us on Twitter: 

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/a0d6375f-94a4-4e4a-baee-22e35a18ac5c%40googlegroups.com.

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for G Suite" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/bGvor2xFgBQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/59D83EE7-1017-4E74-B216-063FE82B23F6%40gmail.com.

Ross Scroggs

unread,
Apr 8, 2020, 8:58:49 PM4/8/20
to google-ap...@googlegroups.com
Andrew,

5.02.00

Install, do" gam user us...@domain.com update serviceaccount
That's update, not check. You'll get a menu like oauth create, enable the Classroom API - Profile Emails scope, c to continue

Penner, Andrew

unread,
Apr 9, 2020, 11:29:18 AM4/9/20
to google-ap...@googlegroups.com
Excellent!
Thanks Ross. Now I can start gathering Classroom data.
______________________________________________________
Andrew Penner, Technical Analyst III (A+, MCP, MCDST)
Office: 780-460-3712 (333)
60 Sir Winston Churchill Ave
St. Albert, AB T8N 0G4



To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/E80F621C-AF99-455B-8F49-BB5C9BC3544F%40gmail.com.


The content of this message is confidential. If you have received it by mistake, please inform us by an email reply and then delete the message. Please do not copy, forward, or in any way reveal the contents of this message to anyone. The integrity and security of this email cannot be guaranteed over the Internet. Therefore, the sender will not be held liable for any damage caused by the message.

Wesley Strong

unread,
May 7, 2020, 8:06:11 PM5/7/20
to GAM for G Suite
Hey so I've been investigating the best data sources via GAM for much the same reasons to answer the following questions:
1. How many students login each day?
2. What is their activity level like?

I've  been able to pull the report for last interaction using:
gam report users parameters classroom:timestamp_last_interaction orgunit "/Student Body" range 2020-05-03 2020-05-04 todrive 

I've tried

gam print course-submissions fields courseid,courseworkid,id,state,creationtime,userid start -1d end -0d todrive

and have been getting this

"Print Failed: Request had insufficient authentication scopes."

I re-check and authorized all the scopes to no avail, still the same error. Any thoughts?


On Monday, April 6, 2020 at 8:14:30 PM UTC-4, Ross Scroggs wrote:
Mark,


parameters are used in the Report API, the classrrom API uses fields. Unfortunately, the API doesn't return an user profile information; here are defined fields:
<CourseSubmissionFieldName> ::=
        alternatelink|
        assignedgrade|
        courseid|
        courseworkid|
        courseworktype|
        creationtime|
        draftgrade|
        id|
        late|
        state|
        submissionhistory|
        updatetime|
        userid|
        worktype


gam print course-submissions fields courseid,courseworkid,id,state,creationtime,userid start -1d end -0d todrive

Ross
On Apr 6, 2020, at 4:38 PM, Mark Monahan <mmon...@srwa.co.uk> wrote:

I've been writing a "gam print" command to look at Google Classroom submissions, but the resulting spreadsheet/Google Sheet is too big for Google to handle (in excess of 250 columns) In reality I only want a handful .
I have been able to do gam reports which allow me to specify parameters, such as classroom:timestamp_last_interaction but when using gam print for Google classroom submissions it says parameters are unknown.

Here is what I have been trying to do:

gam print course-submissions parameters classroom:CourseName,classroom:profile.emailAddress,classroom:profile.name.givenName,classroom:state,classroom:creationTime,classroom:profile.name.familyName,classroom:profile.name.givenName start -1d end -0d todrive




--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

Ross Scroggs

unread,
May 7, 2020, 10:51:47 PM5/7/20
to google-ap...@googlegroups.com
Wesley,

Do the following to make sure that everyting is up to date.
gam update project
gam oauth create
gam user us...@domain.com check serviceaccount

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dd0c1886-d9dd-45f1-90cd-01f5f9c94131%40googlegroups.com.

Wesley Strong

unread,
May 11, 2020, 7:03:20 PM5/11/20
to GAM for G Suite
Hey folks, is it at all possible to filter what this report selects to only the records marked "TURNED_IN"? otherwise I have 80k plus records :O

I tried various iterations of submissionstates "TURNED_IN" and check the documentation which wasn't 100% clear. Ideas?


On Thursday, May 7, 2020 at 10:51:47 PM UTC-4, Ross Scroggs wrote:
Wesley,

Do the following to make sure that everyting is up to date.
gam update project
gam oauth create
gam user us...@domain.com check serviceaccount

Ross Scroggs

unread,
May 11, 2020, 7:52:32 PM5/11/20
to google-ap...@googlegroups.com
Wesley,

gam print course-submissions [todrive <ToDriveAttribute>*]
        (course|class <CourseEntity>)*|([teacher <UserItem>] [student <UserItem>] states <CourseStateList>])
(workids <CourseWorkIDEntity>)|((workstates <CourseWorkStateList>)*
(orderby <CourseWorkOrderByFieldName> [ascending|descending])*)
        (submissionids <CourseSubmissionIDEntity>)|((submissionstates <CourseSubmissionStateList>)*) [late|notlate]
        [fields <CourseSubmissionFieldNameList>] [formatjson] [quotechar <Character>] [showuserprofile]
        [timefilter creationtime|updatetime] [start|starttime <Date>|<Time>] [end|endtime <Date>|<Time>]

Show the command you're issuing.
This example filters for active courses, published work and turned_in submissions.
gam print course-submissions states active workstates published submissionstates turned_in fields ...

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/9fcfd834-4c76-487a-b701-09b3c61f586d%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages