This file will be very useful when it comes to tracking the delivery of the different homework that you propose to your students on the different online platforms, for example, Seesaw or Google Class, for up to 9 weeks.

 I have put the subjects of Language Arts and Social Studies, Mathematics and Natural Sciences because they are the ones that concern me, but if you teach different subjects, you just must rename them. 

In the "Home" tab, the yellow one, you can see a clear and quick overview of how each of your students is working. In this tab, you don't have to enter more data than the name of the students and the ID if desired. It will be in the other three tabs, those referring to the mentioned subjects, where you will mark with a simple click who performs each of the assigned tasks. 

I use to send them a daily exercise for each subject. It will show us the number of daily homework performed and the grade of each student in each of the weeks. The range used is the following: a "1" if they deliver a weekly homework, a "2" if they deliver two, a "3" if they deliver three, and a "4" if they deliver four or five tasks throughout the week. Change the formula in the "Grade" column if you have a different string. 

In the first tab, called "Home", the number of assignments performed by each student in each subject will appear automatically below every week´s column. The grade that appears is the average grade for all the weeks to date. It does not matter if your quarter is nine weeks or less, the data that appears will always be according to the number of weeks entered. If there were no more than seven weeks, the marks will automatically be an average mark based on seven weeks and not nine. 

Finally, the orange tab helps me to know who gives me a series of WEEKLY exercises that in my class we call “Weekly homework”. It is marked who gives it and it shows us the total number of weekly tasks submitted and the percentage that it represents to date. So, if a student submits the Weekly Assignment for the first three weeks, it will reflect 100% in all of them, but if they stop delivering them, the percentage will gradually decrease until the last evaluation week. On the contrary, if the student does not present anything the first two weeks, but he does in the third, in the first two you could see 0% and in the third 33%, since that is what it represents to date.