Forum Discussion
Teacher Gradebook in Teams
- That feature is not a gradebook, it is just the scores and feedback from one assignment. Teachers want to be able to see the scores for all of the assignments to compare the progress that pupils are making. The feature did exist for a short while but was removed. The assignments were added to a single table but there was no logical order to the tasks (not date or alphabetical)
Hi Justin,
Thanks for picking up on this. Below are a few ideas that I've thought of, I'm sure however that others will have far more insightful ideas than me!
I think it would be really useful when setting up assignments to be able to select individual assignments to auto populate a grade book page within teams. At the moment we have to export an individual excel file for each assignment. It is important that assignments can be selected to be included or not of this as I assign both formative and summative tasks and I don't want my formative assignments to count towards the final semester grade.
The integration of Microsoft Forms would be really useful, so I can make quizzes in Forms, assign that quiz to a class and those grades could then also be automatically added to the grade book.
Within the grade book it would be useful also if we could add a weighting for each assignment so a small quiz isn't worth the same as a large multi week project.
The grade book tab should be visible and editable by all teachers assigned to the class so we can all collaborate and input grades.
Finally, it's important to be able to share grades and comments with students and parents to allow them to learn effectively from their experiences. So a student should be able to access their own grade book. Within the students grade book the grade could be displayed but if the student wishes to see the comments or the copy of the work submitted then that could be accessed directly by a link or expandable tab without them having to go back through the assignments tab to find their original work. The students could then be offered the ability to respond to their grade or the final comments given by the teacher by entering a comment. This would facilitate a grading conversation that can then be used by the teacher and student to really give personalised feedback.
In terms of sharing grades I also find it very useful at a parents evening to be able to show the parents the grade book. So the ability to hide or obscure the grades of other students in the class would be really useful. Maybe a right click function on a students name saying 'hide all other students'. This would mean I can then show students or parents their child's grades without sharing the whole class data.
So for me its more about having the features in Teams rather than integration with other platforms, although ultimately that would be great too.
Many thanks
Tom
- Justin Chando
Microsoft
Hi Rick - you can download all grades at the same time to excel TODAY :)
Go to Assignments tab -> then click the Review button. At the top right it will say "Export to Excel". Have you tried this yet?
I was recently looking online to see how to export a mass spreadsheet of all existing marks from assignments on my Microsoft Teams page for my classroom. I came across your reply to someone saying that if I go to the "assignments" tab and click on the "review" button that I could export a spreadsheet with all assignment marks collated. However, when using Teams there does not appear to be a "review" button as you mentioned. However, this post is 2 years old. Perhaps Teams has changed since. Are you aware of any current way I can export a collated spreadsheet of marks?
Thank you for your help
Jay Ewert
Arborg Early Middle Schoo
Evergreen School Division
Thanks for adding the export to excel, its a step in the right direction.
I noticed a little while ago that categories were added so I can now tag assignments but it seems to be a bit of a placeholder as I can't actually search or organize by tags.
I think that if we could add weighting to categories (ex. a simple example might be assignments 75%, tests 25%) and then tag our assignment accordingly and then have a gradebook tab that would collate all the assignment data and spit out an overall mark. There would also need to be a way to omit assignments (ie. do not count them towards the calculation).
I really like Teams but the lack of an easy gradebook is causing me to debate going back to using Moodle. Moodle was a nice way to organize course content with a slick gradebook that students could access at any time. I think if Teams can get this functionality integrated, it would really be a killer app. A lot of teachers I know are using tools like Schoology or Freshgrade which all have their shortcomings but the big advantage is they have an online gradebook. Please make this happen, Teams is great otherwise!
I've just tried it and it works! Thanks.
The formatting is a bit too simple and initially looks messy but being able to get them all in one spreadsheet is incredibly useful.
