Google Sheets Teacher Markbook Tutorial
Learn how to setup your teacher mark book with this Google sheets Teacher Markbook Tutorial. It will take you through step by step how you can set up your markbook in Google sheets.
Subscribe for more Teacher Tech tutorials: / @humphrer2
Hire me to create your classroom: https://www.fiverr.com/share/Qrr39p
Please follow me on Social Media:
@humfteaches / humfteaches
@humphrer / humphrer
View my blog for other tips and content.
https://humfteaches.com
This video takes you through the full process of setting up your gradebook in Google Sheets. I use it to incorporate standardised data from CAT or INCAS scores that then allows me to benchmark class results to determine whether a pupil is making good progress.
I then like to use functions such as average and conditional formatting to easily identify progress, and average totals.
Further additional functions supplied by Google sheets are the "Rank" function that allows you to rank the results in order. I can then use this along side"Sparkline" that puts a small graph into a cell at the start of the markbook.
If you have any questions or observations then please get back to me.
In this video:
Setting up the markbook
Using previous reports
2.32 Calculating Average
3.42 Using $ sign to copy and paste
4.04 Reduce Decimal Places
3.25 Calculate pupil position in class
Using standardised data and Benchmarking
7.40 Paint Format
7.57 Rank Formula
10.47 Sparkline Formula