Skip to content
Instant digital downloads Secure checkout on Etsy 2027 calendars & planners are here Original designs, checked page by page Instant digital downloads Secure checkout on Etsy 2027 calendars & planners are here Original designs, checked page by page
Kids Learning & School

Teacher Gradebook Spreadsheet

Teacher Grade Book & Attendance Spreadsheet – an easy, automatic gradebook for Microsoft Excel and Google Sheets. Set your categories and weights once, type the points, and every…

$5.50 USD USD · digital download
Buy on Etsy
  • Instant download after checkout
  • Secure checkout on Etsy
  • Print at home or use digitally

Teacher Grade Book & Attendance Spreadsheet – an easy, automatic gradebook for Microsoft Excel and Google Sheets. Set your categories and weights once, type the points, and every student's overall %, letter grade, category averages and class average calculate for you. Track attendance by date with automatic totals and attendance %, then see the whole year on one term summary.

✦ WHAT'S INCLUDED (13 tabs)
• Start Here – step-by-step instructions + your class at a glance
• Settings – teacher & class details, term names and dates, grade categories with editable weights, editable letter-grade scale (A+ to F) and a list of no-school dates
• Roster – up to 35 students with ID, parent/guardian and contact columns; names flow to every tab
• Grades Term 1, 2, 3 & 4 – up to 40 assignments per term with name, category dropdown, date and points possible; overall %, letter grade, category % and class average per assignment calculate automatically
• Attendance Term 1, 2, 3 & 4 – dates fill in by themselves from your term start date, skipping weekends and your no-school dates (95 school days per term); pick P, A, T or E; present/absent/tardy/excused totals and attendance % update instantly
• Term Summary – each student's term grades, letter grades, absences, year average, year letter grade and year attendance %, plus a grade distribution table and chart
• Example – a filled-in sample gradebook (fictional students) so you can see how it works

✦ SMART FEATURES
• Choose weighted categories or total points grading with one dropdown
• Blank scores are not counted (perfect for excused work) – type 0 for missing work
• Low scores, failing grades and low attendance are highlighted automatically
• Class average and "scores not entered" count for every assignment
• Freeze panes keep student names in view while you scroll
• Print-ready: landscape Letter layout, student names repeat on every printed page

✦ PERFECT FOR
• Elementary, middle and high school teachers
• Homeschool parents, tutors and co-ops
• Quarters, trimesters or semesters (rename the terms and use the ones you need)
• Teachers who want a simple gradebook without learning new software

✦ FORMAT
• 1 XLSX file for Microsoft Excel (2010 or newer) and Google Sheets (free)
• No macros, no add-ons, no subscriptions
• Blank and ready to use – no real student data included
• Digital download – no physical item will be shipped

✦ HOW TO USE
1. Complete checkout
2. Go to You > Purchases and reviews on Etsy (or the link in your email)
3. Click Download Files. Open the file in Excel, or upload it to Google Drive and choose Open with > Google Sheets
4. Fill in Settings and Roster, then start entering grades and attendance. Make a copy of the file for each class you teach

✦ GOOD TO KNOW
• Works best on a computer; Google Sheets also works on tablets
• Formulas are in the shaded cells – type only in the white and cream cells
• This file will hold student information – store it securely and follow your school's privacy policy
• Personal and classroom use only; please do not share or resell the file
• Because this is a digital item, returns are not accepted – but if anything is wrong with your file, message us and we will fix it quickly

✦ ABOUT THIS DESIGN
Original design by Pagevine Studio, created with digital design tools (including AI assistance) and checked page by page before listing.

✦ MORE FROM PAGEVINE STUDIO
See more teacher printables, planners and spreadsheets in our shop: https://www.etsy.com/shop/PagevineStudio

How your download works

Check out on Etsy, then open You › Purchases and reviews to download right away (Etsy also emails you a link). Unzip if needed, then print, import to GoodNotes, or open in the app named in the listing. Full guide.

License & use

For personal use unless the listing says commercial use. Please don't share or resell the files. Colors can vary a little between screens and printers.

Need help?

If anything is wrong with a file, message us with your Etsy order number and we'll fix it quickly.

Teacher Gradebook Spreadsheet $5.50 USD Buy on Etsy