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.

In most classrooms, individualized learning is the norm, and it can be problematic for many teachers. How can a teacher possibly keep all the students learning at a level that is challenging for each of them? How can a teacher tap into students’ curiosity to keep them motivated to learn? And how can a teacher make sure that all students have access to learning all the content standards? Short videos may be the answer.

