Build Automated Weighted Gradebooks with Progress Insights

Create an automated Google Sheets gradebook with weighted categories and clear student progress insights.

💸 Free⏱️ 35 min saved✅ 1734 runs

Get started with Trinity

Trinity is a conversational expert who works alongside you, following your screen and guiding you through each step. It's like having someone who really knows Google Sheets sitting right next to you.

What happens when you click "Start with Trinity"

1
Connect your microphone
Give permission for Trinity to access your microphone so you can ask questions and get Trinity's help as you go.
2
Share your screen
Share the screen you are working on so Trinity can see what you're doing and provide guidance.

Step-by-Step Guide

Step 1Plan your grading structure and open a named sheet

Step 2Build the main dashboard layout

Step 3Freeze headers and tidy the viewing area

Step 4Create separate sheets for each grading category

Step 5Copy the student roster into each category sheet

Step 6Set up assignment columns within each category sheet

Step 7Reference category averages back on the dashboard

Step 8Define and apply category weights

Step 9Calculate total percentage grade and letter grade

Step 10Add data validation and conditional formatting to scores

Step 11Track missing work and highlight at-risk students

Step 12Capture progress snapshots and build trend charts

Step 13Protect key formulas and set collaboration permissions

Step 14Save your gradebook as a reusable template

Get started with Trinity

What happens when you click "Start with Trinity"