Standards-Based Grading SheetStandards-Based Grading Sheet

TomHinkle.net

Standards-Based Grading Sheet

A flexible, teacher-friendly Google Sheets template for standards-based grading.

This Google Sheets template provides a complete, customizable system for standards-based grading, inspired by the BTC Rubric and Building Thinking Classrooms. It features easy data entry with typable symbols, real-time feedback for students, and flexible configuration for mastery levels and grading logic.

Key Features:

  • Typable grading marks for fast entry
  • All grades in one sortable view—no tabs per student
  • Live student views and automatic grade calculations
  • Configurable mastery levels, streak requirements, and scoring logic
  • Automated setup and easy management of students and skills
  • Secure sharing: individual student views with read/comment access only

Instructions: The sheet includes a built-in guide with step-by-step instructions for setup, grading, and sharing student progress. Sections include About, Initial Setup, Students & Standards, Using the Gradebook, and Sharing Student Views.

Inspired by: BTC Rubric and Building Thinking Classrooms by Peter Liljedahl.

Tags

Tech used in this project:
Google Apps ScriptSpreadsheetSchoolProductivity