- This workshop has passed.
Continue Building your Percentage-Based Gradebook with Excel – Educator Workshop
February 24, 2022 at 7:30 pm - 8:30 pm EST
Free Funded by Microsoft Canada
You’ve started your percentage-based gradebook in Microsoft Excel and want to take it a step further!
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.
Frequently Asked Questions
You bet! Register below and receive the replay of the workshop on Friday, February 25th.
While we will be specifically looking at the functions inside Microsoft Excel, the ideas and formulas will translate to any spreadsheet software.
Of course! The knowledge and skills gained in this 60-minute workshop will be helpful in all sorts of other applications!
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!
