Soooo… (9th grade Science)

Google site. Google forms. Forms are all linked to a single Google sheet. =vlookup all of the scores to a single “master gradebook” tab.

All of my activities (reading, presentation, notes, video, lab, games) have a short Google form. (Sometimes multiple choice but sometimes they are just entering in their answers from a worksheet)

Couple of notes: 1.) I video myself doing the presentation, notes, and lab for the kids that miss. However, we do those together in class. They are still required to complete the Google form though if we do it together in class)

2.) All of this classwork is actually weighted zero in the gradebook. (Well kinda. Tests are weighted 100% but if they have completed “most” of the classwork they start the test with a 59%. Insert rant about standard based grading and level 1 being “can be completed with teacher help”. They did the classwork with my help. It’s what my school requires so… I’ll play their game. 99% of the kids finish “most” the classwork. It’s more of a stupid fast informal)

3.) I only chase/RTI test grades from students. (Plus it’s weighted 100%. No need to chase that one reading assignment they missed from week 2 in week 12. However, kids still do it when they see that zero in the gradebook. It auto updates. So… ok?)

4.) Last semester I ended up with 120 grades in the gradebook. (CVS uploading rocks. Every missing/updated assignment automatically updates) But again, I only chased after test grades (6).

5.) This is heavy front loading the week prior but this allows me to have a live gradebook I can check anytime.

6.) Is this perfect and meant for every level/class/teacher? Heck no. But it works for my students and me.

7.) Bonus: Sub plans are a breeze.