Create a Percentage-Based Gradebook with Excel – Educator Workshop
January 25 at 7:30 pm - 8:30 pm ESTFree 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!