Sheets

Grade Book

One way to use Google Sheets as a teacher is for keeping a grade book. Many of the functions of Sheets help teachers elevate from a basic grade book.

Teachers can keep track of scores on assignments and use formulas within Sheets to find data such as averages and to track improvement over the course of a unit. In my example, I used the data validation function to enter grade levels, and I used conditional formatting to add the colors to the cells on the sheet. If a score was less than or equal to 5, I set the formatting to turn the cell red. If the score was 6 or 7, I set the formatting to turn the cell yellow. If the score was greater than or equal to 8, I set the formatting to turn the cell green. This use of conditional formatting would allow me to visualize the data and see how students are doing throughout the unit.

I also kept track of how much the student gained over the unit by using a formula within Sheets to subtract the score of the Pre-Test from the score of the Post-Test.

The last thing I tracked within this Sheet was the amount of low scores the students had in the unit on the assignments.

Attendance

Another potential use of Google Sheets as a teacher would be to create an attendance sheet. My example shows the attendance of a class throughout a week, and I decided to keep track of absences and tardies. I used conditional formatting to highlight the cells that contained the text "Tardy" or "Absent." I also used a formula to add the total amount of tardies and absences for the week. Then I added notes about the tardies and absences. Sheets would help teachers keep track of their students' attendance and have a good representation of that data.