Most parents and students would like to know what their grades are in my class. As a teacher, I wanted to find a way to share my students’ grade so they know exactly where they stand in class at any given moment throughout the school year. Of course there are many awesome yearly prepaid grading programs out there, but I wanted one that can easily be share with their school gmail. Thus, I decided to go with Google Sheets. Since Google Sheet can be share with students flawlessly.
Once I created this master Google Sheet to keep track of my students’ grades, I ran into a problem. I realize that if I share my master sheet, my students will get to see all their classmates’ grades. So I decided to research online and found a solution.
All I needed to do was create a separate Google Sheet for each of my students. I used the formula =importrange(“mastersheet google sheet name”,”A1:A9”) to import those cells to each individual student’s Google Sheet. This way they will only see their grades and not the whole class.
By seeing their grades live, I notice a few benefits among parents, students, and myself. Most students tend to want to turn in their classwork/homework ontime. In addition doing their best on the test as this helps improve their overall grades. Most importantly, I don’t have any parents or students complaining about their grades by the end of each trimester.
