10 Excel Tips for Making Gradebooks – Teachers Guide to Microsoft Excel

10 Excel Tips for Making Gradebooks – Teachers Guide to Microsoft Excel

Need to construct a Gradebook or e-Markbook for your class? This Teachers Guide to Microsoft Excel will teach you step by step all the techniques you will need for creating feature rich and dynamic gradebooks, complete with a student summary page and flight paths.

This video series is accompanied by a workbook, also made in excel, which includes example of the formulas used and some tasks for you to complete to check your understanding and practice the skills.

Get the Series Workbook here:
►Download: https://mr.tompkins.online/excel

Channel Members and Patreon Members can get an enhanced version of this workbook, which includes my own template for emarkbooks and dynamic student summary page. Click the JOIN button below the video to become a channel member:
►Join: https://youtube.com/c/mrtompkinsedtech/join

Or sign up to Patreon here:
►Signup: https://mr.tompkins.online/patreon

#MicrosoftExcel #Gradebooks #Markbooks #Edtech #UKEdChat #EdChat #MrTompkinsEdtech #MIEExpert
This video is part of the following playlist series:

Teachers Guide to Microsoft Excel:

Using Microsoft Office 365 for Schools – A Teachers Guide

MrTompkinsEdTech on Social Media:
► https://www.facebook.com/MrTompkinsEdTech/
► https://twitter.com/AnthonyTompkins

For exclusive content, including an enhanced version of the accompanying excel workbook:
► Check out my Patreon page at: https://patreon.com/mrtompkinsedtech
Mr Tompkins Ed Tech uses the following for making videos:
►Blue Snowball Cardiod USB Microphone – https://amzn.to/2IPZqSd
► Camtasia Studio (video editing software)- https://amzn.to/2xhobV6

Find more calculators, teacher/student laptops and maths gift ideas in:
► My Store: https://amazon.co.uk/shop/mrtompkinsedtech

► AD: Try Audible and Get Two Free Audiobooks: https://amzn.to/2O8InNJ

► AD: Teachers! Claim your free £80 voucher for Naked Wines!: https://www.nakedwines.com/invite/anthony-tompkins
Did MrTompkinsEdTech help you with your teaching? Say thank you and
► Buy the creator a coffee at: https://www.paypal.me/MrTompkins

You can also show appreciation by purchasing something from amazon after visiting my storefront – you will pay the exact same price, but MrTompkinsEdtech will earn a small commission from the sale:
► My Store: https://amazon.co.uk/shop/mrtompkinsedtech
Mr Tompkins is a qualified teacher with 20+ years classroom experience. BSc (Hons) Mathematics, Post Graduate Certificate in Education, Certified Apple Teacher, Microsoft Certified Educator, and Microsoft Innovative Educator Expert. MrTompkinsEdTech is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Leave a Reply

Close Menu