VLOOKUP in Google Sheets for Teachers | Auto Gradebook Template

Tired of converting marks to grades manually? In this video, I’ll show you how to use Google Sheets and the VLOOKUP function to automatically assign grades based on your chosen grade boundaries. It’s a simple, time-saving system that keeps your grading consistent and accurate — perfect for teachers who want to streamline their markbooks. 💡 What You’ll Learn: How to set up grade boundaries in Google Sheets How to use VLOOKUP to assign grades automatically Tips for customising the gradebook for your own subjects How to download and start using the free template 📂 Free Gradebook Template: 👉 [Google Drive Link Here]: https://docs.google.com/spreadsheets/d/1IctnD_hMB5vjnP09R-k2lnUs9wLYpETdh-hNx9M1Kfc/edit?usp=sharing 🧮 Why It Helps: No more double-checking grades or recalculating cutoffs. Once you enter your students’ marks, the gradebook automatically fills in the correct grade — fast, reliable, and editable for any marking scheme. If you found this helpful, please like, share, and subscribe for more teacher tech tips and classroom tools. Business Inquiries contact us at beardsquared.bs@gmail.com