Loading Workshops

« All Workshops

  • This workshop has passed.

Create a Percentage-Based Gradebook with Excel – Educator Workshop

January 25, 2022 at 7:30 pm - 8:30 pm EST

Free Funded by Microsoft Canada

If you assess using percentage-based grades, this workshop is for you.

We’ll explore and learn how to save time in creating a percentage-based gradebook in Microsoft Excel all in 60-minutes.

This hands-on, intermediate-level workshop will show you how to take your basic spreadsheet skills to the next level and save huge amounts of time come report card time.

There’s no time like the present to master a spreadsheet and take control of your data!

At the end of this workshop you’ll know how to calculate overall grades using Spreadsheet formulas, learn how to modify our template to add more classes, units and assignments and know how to use this data to influence your next lesson!  You’ll discover data about your classes (using conditional formatting in Excel) to identify struggling students more easily.

Frequently Asked Questions

You bet!  Register below and receive the replay of the workshop on Wednesday, January 19th.

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!

Thank you Microsoft Canada for funding this lesson so it can be FREE for all classrooms!


January 25, 2022
7:30 pm - 8:30 pm EST
Workshop Categories:


The Cobblestone Collective
View Organizer Website


The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available