CIS101/120 Extra Credit Solution for Excel Calculating Grades
In this video, I'm demonstrating a solution to a recent extra credit challenge students had where they needed to calculate weighted average, use conditional formatting with a formula, and create a nested function calculation.
If you'd like to try this, STOP watching the solution. Download the starting file from https://docs.google.com/spreadsheets/... and try it for yourself. Afterward, watch my demo and see how it worked out. There are multiple solutions for both. Several of my students used different, accurate techniques that I thought were quite clever.