What Are My Grades?

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.

Image of a gradebook spreadsheetOnce 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.

Image of an individual student's grade spreadsheetAll 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s