When it comes to working with student data, most tech-savvy educators know how powerful spreadsheets can be. A basic knowledge of formulas and functions makes it possible for a teacher to generate quality information, reports, and charts. But the typical teacher grade book doesn’t allow for much data manipulation. Student scores on particular assignments in a grade book don’t necessarily show teachers whether students have mastered the material.
While grade books are probably here to stay, there is an additional tool that can help teachers gather more information from their students’ grades, including student mastery and testing information. It’s the Conditional Formatting function in Google Sheets.