This spreadsheet with graph tracks student grades by the 2-digit numerical percentage. It is set up with two seperate sheets for each nine weeks of a semester.
I have tried multiple different things to do weekly checks over the years: google forms, emails, paper forms, docs, google classroom updates, but THIS has been hands-down most successful method.
My students come in on Wednesdays, get out a chromebook, sign-in to their grade monitoring system and bring up the google sheet, that I have created and shared with them. They then check their grades and enter in the 2-digit current percentage they have for each hour. Once they have completed it for each class period, they bring the computer up to my desk with both their grade monitoring system still up as well as their Google Sheet. I can check the grades against the previous weeks reporting and look at specific classes if there was a decline and/or a failing grade.
Then, based on grades and missing work, I email teachers and case managers and/or parents and administrators. I have a running record of their grades throughout the semester which both holds the students accountable as well as the teachers in case there is an instance when a students grade is fine all semester, but then suddenly tanks due to a teacher either not updating grades regularly, or because the student did very poorly on a major assignment/assessment.
The visual graph is great for my students to see their progress, but it also allows me to note patterns in behavior and/or with certain classes and times of day.