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.
рдмрдирд╛рдиреЗ рд╡рд╛рд▓реА рдХрдВрдкрдиреА:
рдЗрдирдХреЗ рд╕рд╛рде рдХрд╛рдо рдХрд░рддрд╛ рд╣реИ:
18┬ард╣рдЬрд╝рд╛рд░+
рдЕрд╡рд▓реЛрдХрди
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.
рдЕрддрд┐рд░рд┐рдХреНрдд рдЬрд╛рдирдХрд╛рд░реА
рдХреАрдорддрдЙрдкрд▓рдмреНтАНрдз рдирд╣реАрдВ
рдбреЗрд╡рд▓рдкрд░
рдбреЗрд╡рд▓рдкрд░ рдХреЗ рд╡реНрдпрд╛рдкрд╛рд░реА рд╣реЛрдиреЗ рдпрд╛ рди рд╣реЛрдиреЗ рдХреА рдЬрд╛рдирдХрд╛рд░реА рдирд╣реАрдВ рд╣реИ
рд╕рд╣рд╛рдпрддрд╛рдЙрдкрд▓рдмреНтАНрдз рдирд╣реАрдВ
рд╕реЗрд╡рд╛ рдХреА рд╢рд░реНрддреЗрдВ
My Class Rocks рдиреАрдЪреЗ рджреА рдЧрдИ рдЕрдиреБрдорддрд┐рдпреЛрдВ рдХреЗ рдРрдХреНрд╕реЗрд╕ рдХрд╛ рдЕрдиреБрд░реЛрдз рдХрд░реЗрдЧрд╛. реЫреНрдпрд╛рджрд╛ рдЬрд╛рдиреЗрдВ
My Class Rocks рдХреЛ рдЖрдкрдХреЗ Google рдЦрд╛рддреЗ рдХреЗ рдРрдХреНрд╕реЗрд╕ рдХреА рдЬрд╝рд░реВрд░рдд рд╣реЛрдЧреА
рдЗрд╕рд╕реЗ My Class Rocks рдХреЗ рджрд╛рдпрд░реЗ рдореЗрдВ рдпреЗ рдЕрдиреБрдорддрд┐рдпрд╛рдВ рднреА рд╢рд╛рдорд┐рд▓ рд╣реЛ рдЬрд╛рдПрдВрдЧреА :
рдЖрдкрдХреА рд╕рднреА Google Sheets рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯ рджреЗрдЦрдирд╛, рдЙрдирдореЗрдВ рдмрджрд▓рд╛рд╡ рдХрд░рдирд╛, рдирдИ рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯ рдмрдирд╛рдирд╛, рдФрд░ рдЙрдиреНрд╣реЗрдВ рдорд┐рдЯрд╛рдирд╛
Google Classroom рдореЗрдВ рдореМрдЬреВрдж рдХреНрд▓рд╛рд╕ рдХреА рдЬрд╛рдирдХрд╛рд░реА рдХреЛ рджреЗрдЦрдирд╛, рдЙрд╕рдореЗрдВ рдмрджрд▓рд╛рд╡ рдХрд░рдирд╛, рдФрд░ рд╣рдореЗрд╢рд╛ рдХреЗ рд▓рд┐рдП рдорд┐рдЯрд╛ рджреЗрдирд╛
рдЕрдкрдиреА рдХрдХреНрд╖рд╛рдУрдВ рдореЗрдВ рдореМрдЬреВрдж рд▓реЛрдЧреЛрдВ рдХреЗ рдИрдореЗрд▓ рдкрддреЗ рджреЗрдЦреЗрдВ
рдЕрдкрдиреА рдХрдХреНрд╖рд╛рдУрдВ рдореЗрдВ рдореМрдЬреВрдж рд▓реЛрдЧреЛрдВ рдХреА рдкреНрд░реЛрдлрд╝рд╛рдЗрд▓ рдлрд╝реЛрдЯреЛ рджреЗрдЦреЗрдВ
рдЕрдкрдиреЗ Google Classroom рдХреА рдХрдХреНрд╖рд╛ рдХреА рдирд╛рдорд╛рд╡рд▓реА рдкреНрд░рдмрдВрдзрд┐рдд рдХрд░реЗрдВ
рдЖрдкрдХреЗ Google рдЦрд╛рддреЗ рдХрд╛ рдореБрдЦреНрдп рдИрдореЗрд▓ рдкрддрд╛ рджреЗрдЦрдирд╛
рд╕реЛрд╢рд▓ рдореАрдбрд┐рдпрд╛ рдкрд░ рджреА рдЧрдИ рдХрд┐рд╕реА рднреА рдЬрд╛рдирдХрд╛рд░реА рдХреЗ рд╕рд╛рде, рдЕрдкрдиреА рдирд┐рдЬреА рдЬрд╛рдирдХрд╛рд░реА рджреЗрдЦреЗрдВ
рд╕рдореАрдХреНрд╖рд╛рдПрдВ
рднрд╛рд╖рд╛:
рдЗрд╕ рдХреНрд░рдо рдореЗрдВ рд▓рдЧрд╛рдПрдВ:
Google, рд╕рдореАрдХреНрд╖рд╛рдУрдВ рдпрд╛ рд░реЗрдЯрд┐рдВрдЧ рдХреА рдкреБрд╖реНрдЯрд┐ рдирд╣реАрдВ рдХрд░рддрд╛. рд╕рдореАрдХреНрд╖рд╛рдУрдВ рдХреЗ рдмрд╛рд░реЗ рдореЗрдВ реЫреНрдпрд╛рджрд╛ рдЬрд╛рдиреЗрдВ
рдХреЛрдИ рдЯрд┐рдкреНрдкрдгрд┐рдпрд╛рдВ рдирд╣реАрдВ
рдЦреЛрдЬреЗрдВ
рдЦреЛрдЬ рд╣рдЯрд╛рдПрдВ
рдЦреЛрдЬ рдмрдВрдж рдХрд░реЗрдВ
Google рдРрдк
рдореБрдЦреНрдп рдореЗрдиреНрдпреВ