Converting Google Classroom gradebook to standards based report cards.

Number of assignments by reportable.¹

reportable	count
	28
CC	2
DC	2
EL	6
KC	2

Scores over time.

Student average score and mastery by reportable.²

Show entries

Search:

	name	reportable	average	mastery
1	Blankenship.Karen		3.625	Exceeding
2	Blankenship.Karen	CC
3	Blankenship.Karen	DC	4	Exceeding
4	Blankenship.Karen	EL	3.59	Exceeding
5	Blankenship.Karen	KC
6	Brown.Kailee		2.875	Meeting
7	Brown.Kailee	CC
8	Brown.Kailee	DC	4	Exceeding
9	Brown.Kailee	EL	3.7	Exceeding
10	Brown.Kailee	KC

Showing 1 to 10 of 75 entries

Previous1 2 3 4 5…8Next

Student average score and average mastery.³

name	pScore	mastery
Brown.Kailee	0.940000	Exceeding
Cooper.Kayleigh	0.930000	Exceeding
Blankenship.Karen	0.918000	Exceeding
Hanna.Anya	0.902000	Exceeding
Wolfe.Aimee	0.888000	Exceeding
Rush.Jamison	0.857340	Meeting
Ford.Abby	0.818000	Meeting
Moore.Dale	0.803340	Meeting
Schmidt.Santiago	0.800000	Meeting
Houston.Hazel	0.793340	Meeting
Parsons.Mateo	0.748000	Meeting
Solomon.Leila	0.418325	Approaching
Meza.Averie	0.375000	Approaching
Day.Kaleb	0.197500	Beginning
Hayden.Gunnar	0.155000	Beginning

Relationship between student overall mastery level and student-facing Google Classroom average.

How good of an indicator is Google Classroom average score (over all assignments) of overall level of mastery? If assignments are scored in Google Classroom, but are not tied to a reportable, a biased relationship will result.

If there is a difference between student mastery level categorization in the above figure and the below figure, as indicated by color, then the average score reported in Google Classroom may lead the student into believing they are doing better or worse in the class than they are actually doing. Whether the bias is in the better or worse direction can be determined from looking at whether or not points in the below figure are above or below the dotted line.

This provides a quick diagnostic to assess whether the scores available to students in Google Classroom are in line (or correlate) with the standards based grading framework used by the teacher.

Class average mastery by reportable.

reportable	average
	2.780556
CC	NaN
DC	3.200000
EL	2.717856
KC	NaN

Any unlabeled reportables in this report are for assignments in Google Classroom where no “Grade Category”, or in this case no reportable, was assigned.↩︎
Average numeric scores translate as follows: if average >= 3.5, then "Exceeding"; if average >= 2.5, then "Meeting"; if average >= 1.5, then "Approaching"; else "Beginning".↩︎
Mastery levels are indicated by color in graphs.↩︎