The learner will understand how to use conditional formatting in spreadsheets to color-code a grade book.
Teachers will apply conditional formatting to a Google Sheet based on grades of students and completed with all errors corrected.
Although this covers how to use it in a grade book, you can extrapolate to other Google Sheets uses. Make a copy of the prefilled template. It will be required for the training.
Follow along with the interactive presentation.