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.
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.
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.
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.
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.
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.
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.
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.
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.
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.