Welcome to GradeBook

GradeBook is a comprehensive Google Sheets Add-on that transforms your spreadsheet into a powerful grade management system. Whether you’re a teacher managing a single class or an administrator overseeing multiple courses, GradeBook provides the tools you need to efficiently track student progress, generate reports, and integrate with Google Classroom.

GradeBook is available on the Google Workspace Marketplace. A valid license is required for most features.

What is GradeBook?

GradeBook is designed specifically for educators who want to:

Create and manage GradeBooks with multiple weighting methods (Standard, Category, and Total Points)
Import and sync grades from Google Classroom automatically
Generate Reports: Create student progress reports for students and parents
Track attendance and student participation
Customize views to display grades exactly how you need them
Share reports via email with personalized content

Key Features

🎯 Flexible Grading Systems

Choose from three grading calculation methods:

Standard Weighting: Assign individual weights to each assignment
Category Weighting: Group assignments by category with category-based weights
Total Points: Calculate grades based on total points earned

📊 Google Classroom Integration

Seamlessly import students, assignments, and grades from your Google Classroom courses with automatic syncing capabilities.

📝 Comprehensive Reporting

Generate detailed, professional reports as Google Docs that can be printed, emailed, or shared with students and parents.

📧 Email Integration

Send reports directly to students and guardians with customizable email templates and personalized messages.

🎨 Customization (Premium)

Add custom logos to reports
Configure performance color schemes
Advanced import options with CSV support

🔧 Utilities

Tools to help you manage and maintain your GradeBook:

Fix grade calculations
Reset configuration options
Copy GradeBooks for new terms
Customer support and subscription management

Requirements

To use GradeBook, you need:

A Google Workspace or personal Google account
Access to Google Sheets
A valid GradeBook license (available via Google Workspace Marketplace)
For Google Classroom features: An active Google Classroom account with teaching access

Premium Features

GradeBook offers premium features for enhanced functionality:

CSV Import: Import grades from CSV files exported from Google Classroom
Report Logo: Add custom logos to your generated reports
Performance Colours: Customize color schemes based on grade performance

Premium features require a premium subscription in addition to the standard license.

Getting Started

Ready to begin? Follow these steps:

Install GradeBook from the Google Workspace Marketplace
Open Google Sheets and create a new spreadsheet
Access the GradeBook menu from the Extensions menu
Create your first GradeBook using the “Create & View GradeBooks” option
Configure your settings and start adding students and assignments

For detailed instructions, see the Getting Started Guide.

Support and Resources

Customer Support: Access support directly from the add-on via Extensions → GradeBook → Support
Documentation: Browse this documentation site for detailed guides
Send Diagnostic Data: If you encounter issues, use the “Send Obfuscated GradeBook” feature to share diagnostic data with support

Use the navigation menu on the left to explore:

Getting Started: Installation and setup instructions
Features: Detailed guides for each menu option
FAQ: Common questions and troubleshooting
Premium Features: Information about premium functionality
Migration: Guidance for moving from GradeBook v5 to v6

Privacy Notice: GradeBook requires permissions to access your Google Sheets, Drive, and optionally Google Classroom. Your data remains private and is only used to provide GradeBook functionality. No student data is accessed or shared.