Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Do More with Google Classroom Data

Google Classroom data helps us to help more students from falling through the cracks.
Do More with Google Classroom Data

Google Classroom provides a lot of data that can be used to improve student learning. This data can be accessed through Google Classroom and through 3rd party applications such as http://schoolytics.io. If you missed the EdWeb presentation myself and Aaron Wertman did on Doing More with Google Classroom we hope you will check out the recording:

New Activity Tab

Coming soon Google Classroom will be adding a new Activity tab. I have been using the Beta and am loving it. It helps me significantly with knowing when the last time a student engaged with Google Classroom. Especially helpful when I am counseling with a student or having a meeting with a parent. The last submission allows me to respond quickly to students, which improves student engagement in the class, and helps me to keep up.

Do More

I teach high school math part time and I am a developer for schoolytics.com part time. When I run into some limitations with what Google Classroom can provide I try to code some solutions to help me. I have helped Schoolytics with creating a more extensive activity feed. Teacher accounts are FREE. Login and click on “Student Work” on the left hand side to see, sorted by timestamp of activity, what has been submitted. This is across all of my classes. Click the “Class name” at the top to select a subset of classes.

To Review

The To Review page in Google Classroom provides a quick way to see which assignments have submitted work. My goal is to get the “Turned in” number to zero. This helps me to know that students have submitted work after I last reviewed an assignment.

Return EVERYTHING in Google Classroom

Google Classroom is designed to RETURN work back to students. This releases their score and rubrics. They can not see their score or the rubric edits you left until you Return.

Shortcut to To Review

On the Stream, on the left hand side, is the “Upcoming” bubble. Click on “View all” to quickly get to the To Review page, filtered for that class, in Google Classroom.

Data Studio

Google Data Studio is an advanced way for you to examine data and to create data dashboards. Many schools are creating custom Google Classroom reports with Data Studio.

Free for Teachers

While Data Studio is a free tool, it does require some advanced skills to create the reports. If you are looking for faster access to reports about your students Google Classroom progress check out Schoolytics. It is free for teachers.

Individual Student View

I use this a LOT in Google Classroom. Click on the People tab and select the students name you wish to review.

Progress Reports

The Individual Student View is a progress report for students. Click on the mail icon at the top of the Individual Student View to send a progress report to students and/or guardians.

Be sure to select “Student and Guardian” because the default is only student. You will also need to check the checkbox to include the “Student work summary.” This progress report is sent via email, but not through your email. There will be no record of this in your Gmail sent mail.

Progress Report in Google Docs

Also as part of my work with Schoolytics I realized there is a need for progress reports in Google Drive. If students do not have email accounts then sharing through Google Drive is necessary. In Schoolytics.io click on Students on the left hand side and click on the profile icon to review progress reports and save to a Google Doc.

Sharing Google Docs

A challenge with Google Docs in general is they are by default private. While it is fairly easy to click the Share button to share the Google Doc, check out my Chrome extension AnyoneCanView that will automatically change the sharing permissions from private to “Anyone with the link can view.” It will also copy the link to the clipboard, making it easy to paste the link to the Google Doc into the Private Comments in Google Classroom or into an email for parents.

Missing Assignments

The individual student view of Google Classroom also provides a missing assignments filter. Click on “Missing” on the left hand side to show only assignments that have not been submitted.

Schoolytics also has a missing assignments report that can be exported as a Google Doc if desired.

Guardian Summaries

If allowed by your Google Workspace Apps Admin, you can enable Guardian Summaries in the settings of Google Classroom. This allows the guardian to get a daily or weekly summary of assignments that are missing or upcoming. This is not a progress report. It is simply a quick snapshot of recent activity by the teacher in Google Classroom.

Grades Tab

Utilize the Grades tab in Google Classroom to see a grid view of student scores. You can enter scores on this page. Remember, scores are not released to the student until you RETURN them. Hover over. a score and click on the 3 dots to “Return” or “View submission.”

View Assignment Stats

Gain additional insights to how students are performing on assignments by using the Assignments option in Schoolytics. Review this assignment report I exported to Google Docs.

Good Data is by Design

The key to having the data you need to inform decisions on how to improve student learning and engagement is planning for what data you need. Consistently post everything into Google Classroom. This provides parents and students with a single key place to know what is being done in class. It also provides you with the key data you need about the students overall progress in the class.

Add Hashtags to the Description

For years I have been adding hashtags to my assignment descriptions to allow me to better filter Gmail messages about Google Classroom assignments. I have extended this idea to my work at Schoolytics. A beta feature in Schoolytics now will allow you to use hashtags in your assignment descriptions to create reports and filters.

Click on TOPICS on the left hand side (after enabling it in the settings) to review statistics around those hashtags as topics.

Export Scores

Open ANY Google Classroom assignment and click on the cog in the upper right to “Export grades to Google Sheets.” This is a great way to export Google Classroom data and manipulate the data using filters and pivot tables in Google Classroom.

1 thought on “Do More with Google Classroom Data

  1. Thank you for this super great information. I love how you added visuals to help me grasp the concepts and complex areas of google classroom. This will allow so much information to be stored online to be able to access it all at anytime and any place. Google classroom will allow for a less amount of physical papers to keep track of and organize, this website is a great tool to create less chaos and disorganization. As a future educator, this blog was super insightful and I will keep google classroom in mind for my future.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.