Simple and Effective Grade Book in Google Sheets
Вставка
- Опубліковано 27 гру 2020
- This is an easy way to create a grade book using google sheets. Within this grade book you can see whole class analytics, individual progress, reports, and more.
#edtech
________________________________________
Follow these simple steps:
1) Click "new" in top left of google drive
2) Hover over google sheets and click the left arrow
3) Scroll down to Education
4) Click on the Grade Book option
5) Import or add your students
6) Check individual and class reports using the tabs on the bottom
________________________________________
If you like this video please subscribe and like this video. If you have any questions or would like to request a specific video, please post in the comments.
how would you add different weights to the assignments
Hey, wondering how you would do it if a student is 'excused' from the assignment and you don't want to input a grade, but leave a cell blank. It automatically assumes it's a 0. Help!
Hi! Did you find the answer here? I am looking into the same issue. HEEEEEEEELP.
Hi Virginia. There seems to be no "simple" fix for this. That said, this will work. Let's say student missed one assignment and he will be excused. Click on his/her overall percent and change the formula. This is what the formula should say:
=sum($E7:$AB7)/TotalPoints
This will add up all of their points and then divide it by the total points. In this case you don't want to do this. So, instead, change the formula to subtract the assignment that you are excusing. For example:
=sum($E6:$AB6)/(TotalPoints-F3)
In this case the assignment that you wanted subtracted was F3. Now when you put a EX in for the assignment it will not count it against them.
If you want me to make a video on this please let me know!
Could you make the video on this?
I have 4 classes. How can I see the 4 separate classes on the overview page?
Hi Khelli. At this point in time I do not believe there is that functionality with this template.