My Class Rocks offers a dashboard of your Google Classroom teacher activity directly in Google Sheets. It pulls the teacher’s Classroom data into sheets in your active spreadsheet and calculates some useful statistics and charts aggregated at the course level and at the course work level.
Works with:
16K+
Overview
My Class Rocks allows to create aggregated views containing stats and charts from the classroom data. 
These views are useful to get an overview at a glance of  the teacher’s courses, course work, grades and aggregated stats. Most of these stats and charts are not surfaced in the Classroom UI, so they can add value for teachers who are tracking these metrics.

The add-on has two main functions:
Generation of course level aggregated stats. All courses in the teacher's classroom are imported in a single sheet entitled “Course Summary”. For each course it lists the course ID and name and calculates the following: number of students enrolled, homework completion rate, average completion time (days), average grading time (days), the final grades rate, as well as the average, maximum, minimum and median grades. The calculated stats take draft grades into account. 
Generation of course work level aggregated stats and charts. For each of the courses in the teacher’s classroom, a new sheet with the same name as the course is inserted. In each of these sheets there are three tables and a chart:
A table containing all the course work for the current course. For each course work, it calculates the following: homework completion rate, average completion time (days), average grading time (days), the fina grades rate (the percentage), as well as average, maximum, minimum and median grades. 
A table containing  the average grades for all the students enrolled in the current course. If a student did not turn in the submission for an assigned coursework, it counts as 0. If there is no course work assigned, then the grade is “N/A”. It takes into account the draft grades; if one or more grades are draft, then the row displays NO in the Is Grade Final column.
A table containing: course average grade, course median grade and course standard deviation
A histogram bar chart with the grade distribution for the current course
Bulk deletion of the previously inserted sheets. The add on provides 2 buttons that deletes in bulk the course summary sheet or the individual course sheets that were added via the add on. Note that sheets are identified by name. If you changed the name in the meantime, they would have to be deleted manually.
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
My Class Rocks will ask for the permissions shown below. Learn more
My Class Rocks will need access to your Google account
This will allow My Class Rocks to :
See, edit, create, and delete all your Google Sheets spreadsheets
See, edit, create, and permanently delete your Google Classroom classes
View the email addresses of people in your classes
View the profile photos of people in your classes
Manage your Google Classroom class rosters
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu