Automated Excel Tracker on Teams
Hi guys, I have a question related to both Teams and Excel functions, wondering if anyone of you has any ideas? 🙂 Our team is going to hold a 2-month training where there will be 15 trainees with 5 trainers. Trainees have to submit their assignments, trainers will grade and update comments on a tracker. I'm under the impression that this can be done with the Teams education account, but we are using the Teams business account Here is what we would like to see/do: 1. Method to submit assignments: - Is there any easy way for all trainees to submit their individual test via Teams? (Only trainers can review/download/grade the test, trainees won't be able to see each other tests) - Once trainees have submitted the test, is it possible to automatically update in a tracker (would be great if timestamp is included) and notify his/her own trainer? 2. Method to track grades/feedback - Ideally, trainees have their own benchmark tracker and we can link their data into a master grades/feedback tracker that only trainers can see. - Once trainers have updated the master tracker, trainees can see their own grades in their own benchmark tracker - If that’s not possible, we either have to copy and paste in people’s data to master or give people a blinded ID for anonymity. Or we can set one Excel tracker, where trainees can only see their individual scores, and trainers can see all scores. Not sure if there is other Teams app that is applicable for this situation (e.g. power automate), would be great if you guys can share some insights, thank you so much! 🙂Introduction to Auto Assessment and Grading with PyBryt for Python
We continuously interact with computerized systems to achieve goals and perform tasks in our personal and professional lives. Therefore, the ability to program such systems is a skill needed by everyone. Consequently, computational thinking skills are essential for everyone, which creates a challenge for the educational system to teach these skills at scale and allow students to practice these skills. To address this challenge, we present a novel approach to providing formative feedback to students on programming assignments. Our approach uses dynamic evaluation to trace intermediate results generated by student’s code and compares them to the reference implementation provided by their teachers. We have implemented this method as a Python library and demonstrate its use to give students relevant feedback on their work while allowing teachers to challenge their students’ computational thinking skills
