Google Sheets Basics – Making an Interactive Gradebook

by Mike Still
Google Sheets Basics – Making an Interactive Gradebook

The other weekend I presented at the Google for Education AppsEvents South Korea Summit.  I took advantage of this amazing networking opportunity and taught a small group of teachers how to use Google Sheets to create an interactive gradebook.   My session went well but I definitely learned a lot for the next time around.  Check it out below.  If you have any questions drop a comment and I’ll do my best to trouble shoot for you!

This presentation will teach you how to use Conditional Formatting and a handful of other features of Google Sheets (a cloud version of Excel) to create a gradebook.  Low or high grades will automatically pop out, absent marks get highlighted and best of all you can access it from any computer or device.  Its easily shareable for collaboration across a team of teachers too!

Google photo (1)If you ever get a chance to join a conference (either as a presenter or participant) make sure you go to the networking events after!  The AppsEvents crew treated everyone to a delicious chicken & beer restaurant where I was invited to speak in Taiwan!  The good news is I was already planning on celebrating Lunar New Year there and will easily be able to add 2 days to my vacation for a second chance at presenting!

Mike Still on FacebookMike Still on InstagramMike Still on PinterestMike Still on Twitter
Mike Still
Mike is a travel enthusiast, photographer and teacher. He loves adventure travel, meeting the locals and exploring new culture. As an outdoor enthusiast you can often find him hiking mountains or exploring forests trying to capture the beauty of mother nature. In 2013 he founded as he left his home in America and has been teaching or traveling around the world ever since!

You may also like


Presenting at Taiwan’s Google For Education | Live, Travel, Teach January 25, 2016 - 11:21 am

[…] weeks I present at Taiwan’s Google for Education Conference!  I’ll be bringing my Interactive Gradebook presentation back and putting the finishing touches on a Genius Hour presentation too.  If you or […]

Grading With Google Forms – EDUC 932 | Live, Travel, Teach July 11, 2016 - 3:43 pm

[…] Our next assignment was to create a practical Google Form. One that can be used as a teacher or supervisor in an assessment or evaluation. Below you’ll find my example that can be used to efficiently grade a student on reading comprehension.  Answering the form will automatically put it into a spreadsheet which can easily become your gradebook. […]


Leave a Reply