





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…
- 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.