Digital Gradebook Google Sheets | Automatic Mark Calculation & Student Reports

Rated 4.85 out of 5, based on 651 reviews
651 Ratings
;
Lessons for Learning
4.3k Followers
Grade Levels
Not Grade Specific
Formats Included
  • PDF
  • Google Apps™
Pages
30 pages
$6.00
$6.00
Share this resource
Report this resource to TPT
Lessons for Learning
4.3k Followers
Includes Google Apps™
The Teacher-Author indicated this resource includes assets from Google Workspace (e.g. docs, slides, etc.).

What educators are saying

I'm not very familiar with Google Sheets yet, but wanted a simple online grade book. Love the tutorial for those who are new to Sheets, like me!
Helped me stayed organized and loved the aesthetics! Would love an option for a comment section to look back for reports and if there is a way to weight each assignment. Thank you!
Also included in
  1. This Digital Teacher Planner/Gradebook Bundle has everything you need to make the switch from paper to digital! The planner has two options - Google Sheets or Google Slides and the Gradebook is Google Sheets meaning you can access and edit anywhere. The planner includes 25 bonus stickers, multiple d
    Price $14.40Original Price $18.00Save $3.60
  2. This Digital Teacher Planner/Gradebook Bundle has everything you need to make the switch from paper to digital! The planner is intended to be used on a tablet or iPad with the Goodnotes app and the Gradebook is Google Sheets meaning you can access and edit anywhere. The planner includes 30 bonus sti
    Price $16.80Original Price $21.00Save $4.20
  3. This Digital Teacher Planner/Gradebook Bundle has everything you need to make the switch from paper to digital! The planner is Google Slides and includes FREE yearly updates to the calendar and the Gradebook is Google Sheets meaning you can access and edit anywhere. The planner includes 25 bonus sti
    Price $17.00Original Price $21.00Save $4.00
  4. This bundle has all of the teacher organization tools you need to keep track of your plans, assessments, grades and anecdotal records. Included is a digital teacher planner for Google Slides that has multiple templates, linked tabs and digital planner stickers as well as a Google Sheets Grade Book
    Price $20.00Original Price $26.00Save $6.00

Description

This Digital Grade Book will help you take control of your time and feel organized with all of your grading/marking this school year. There are 3 Gradebook files you will receive: one that automatically calculates numeric averages, one that automatically calculates mode (for level grades), and one that calculates points/percentages and numeric averages. This product will also pull individual student reports so that you can access a student's grades and profile quickly & efficiently.

This is a Google Drive, Google Sheets file which also means you can access it on any platform, meaning you don't have to worry about lugging a grade book around anymore!

What other teachers have been saying...

"This resource is GOLD! Makes marking/tracking marks SO much easier! Plus you'll never lose it since it's on your google drive, unlike paper copies!"

"This makes it so easy for me to stay on top of my grading. So easy to use and set up and I love that I can just keep it open while I'm grading and enter grades as I go!"

THE GRADE BOOKS:

  • Option 1: Grade Book for Percentage Grading Systems (e.g., 100%-0%) Automatically calculates the AVERAGE (sum of percentages divided by number of assignments) for your set of grades for each student!
    Please note: there is no option for weighted assignments at this time.
  • Option 2: Grade Book for Levelled Grading Systems (e.g., A, B, C, D or Level 4, 3, 2, 1) Automatically calculates the MODE (most frequently occurring grade) of your set of grades for each student!
  • Option 3: Grade Book for Percentage Grading Systems (e.g., 100%-0%) WITH automatic points totalling as well. For example, if you have a test out of 30 you can simply enter the point totals in the Points column (15/30) and have the average automatically calculated for you and counted towards the average final grade total!

WHAT'S INCLUDED?

  • 10 colour-coded google sheets w/symbols for each grade book
  • Completely editable files
  • 3 detailed video tutorials on how to use these files in google sheets to answer any questions you may have & streamline the grading process
  • 3 different google sheets files as listed above
  • FAQ document

WHAT IF I DON'T KNOW HOW TO USE GOOGLE SHEETS?

This product has been created to be as user-friendly as possible. It is simply a plug-and-play document but also includes a detailed video tutorial on how to use EACH of the three versions.

If you watch the tutorials, you should feel confident & ready to SAVE SOME TIME!

_________________________________________________________________

Want to SAVE MONEY on TPT? Consider leaving feedback! For every review you leave, you earn points that you can put towards future purchases. Simply go to "My Purchases" to leave a review on products you have purchased.

Follow Me to receive updates on new products. All of my products are on always on a significant sale for the first 24 hours.

Let's Be Friends! Check out my blog for tips and a free resource library!

Instagram | Pinterest

Total Pages
30 pages
Answer Key
N/A
Teaching Duration
N/A
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.

Reviews

Questions & Answers

4.3k Followers
TPT

TPT empowers educators to teach at their best.

More About Us

Keep in Touch!

Sign Up