Standards Based Grading Is New to Me.

Our district has turned to standards based grading.  They have altered our report cards to reflect this, along with any assessment we give, we have to grade with a scale of 1-4.  I wondered how I would grade without percentages.  I was graded with percentages as a student myself, and have been grading with percentages for my 23 year career.  This would be a big shift for me.

As I attempt to wrap my head around this shift, (which is a good shift, in my opinion) I struggled with how I would grade my students.  So I created Google sheets to do this.  The research says you do not give an average, instead the child's score is the mode that happens most closely to report card date.  For example, the student below would earn a 3.

Standards based grading is intended to show the student and the parent the child's growth.  Most students when they are first assessed on a standard they more than likely will be getting 1, because they have not been exposed to this standard and have had no experience with it, but over time the child will become proficient.

I thought putting the standards in sheets would be easy for me to figure out the grade when it was time to give the child a progress report or report card.  In addition, Google Sheets will allow me to record the assessment that I will be using and can easily refer to it.

If you have never used Google Sheets and want to see how I use mine, click here for a link to YouTube to watch me manipulate my sheets.

If you scroll to the bottom of my sheet, I have added on each sheet, the range in order for the child to score what they did.

This way I can be consistent with my scoring.
The sheets a fully editable so if I want to change the wording, I can easily do this.
There are some standards that have an overarching standard with sub-standards below it. In those cases I have added a sheet that will calculate the average of the scores.  Take a look.
I have included space for 30 students and 40 spaces for assessment scores.  I have included all the California Common Core State Standards in ELA, Writing, Foundational Skills, Informational Text, Reading Literature, Language, and Speaking and Listening.

Here's a helpful resource, these are all of the keyboard shortcuts in Google Sheets.

If this is something you may be interested in here's a link to my Teachers Pay Teachers' Store.