Teacher & Student Grade Tracking Spreadsheet
Overview
This resource is a Google Sheet Template that aids students and teachers in tracking individual student grades based on the number of points they've earned in the course compared to the total number of points available.
Teacher Instructions
This resources is a Google Spreadsheet Template that teachers and students can use to track their grade and progress in a course based on the number of points they have earned compared to the total number of points available.
The calculations on this spreadsheet are based on a grading system that DOES NOT include differing weights for categories. The calculations will only work if you calculate grades in your class with no weighted items.
This spreadsheet also calculates grades based on the following grade distribution:
Teachers who are familiar with Google Sheets and inputting calculations could easily adjust this grading scale if needed by adjusting the calculation in the "Earn at least this many points" column of the spreadsheet template.
Here are a few tips for using this spreadsheet successfully with your students:
1) The teacher should fill in the "Assignment #", "Assignment Name", "Priority Level", "Points Possible", and "Assignment Type" columns with the indicated information for their course. Do not trust students to input this correctly. They may make mistakes and assume they've earned a grade that they actually haven't due to their error.
2) Double check all the calculations to make sure they are calculating correctly for your course.
3) This grade tracking sheet can be useful for both the teacher and the student:
Teachers - this sheet is especially helpful when students ask you what they need to do to earn the grade they desire. It's also helpful when students have a lot of work to catch-up on and need a plan for getting on track.
Students - this sheet is helpful for students to see if they are on track for the grade they desire. It also helps them prioritize what work is most important to work on first.
4) Once all the information is filled in for your course, you can choose to let students make a copy of this spreadsheet for themselves to track their own grade. OR (my preferred method) you could make individual copies for the students who need it and share the sheet with them using the sheet's "Share" settings. This allows you, the teacher, to have oversight over the sheet and make sure it is being used correctly.
5) Consider using the grade tracking sheet during parent teacher conferences to help parents understand their student's progress in the class.
6) Keep a close eye on your tracking spreadsheets to make sure they are correct throughout the year. You don't want students making copies of incorrect information and basing their grade on it.