Inside this 60-minute hands-on workshop, we’re going to get a bit geeky! We’ll explore how to handle zeroes, quickly identify missed work or areas of learner struggle, and how to set up your gradebook so you can use it all year!
This hands-on, intermediate-level workshop will show you how to take your basic percentage-based gradebook to the next level and save huge amounts of time come report card time.
By the end of this workshop, you’ll know how to handle and identify Zeros, explore Nesting formulas, add in drop-down options to minimize mistakes and simplify your grade book, utilize filters to identify struggling learners or missed work, and have a solution on how to support multiple terms within one Excel workbook.
New to this series? No worries! Click Here and you’ll gain access to Part 1 where we share the template and a few basic features of Excel to get your Gradebook started.
Thank you Microsoft Canada for funding this lesson so it can be FREE for all classrooms!