Stakeholder Engagement Tracker
Hello, I need a way of tracking stakeholder engagement for the project I'm working on, we have different sub teams (e.g. delivery, business change) talking to the same stakeholders, duplicating conversations, and want to be more joined up. I'd like to create a stakeholder engagement tracker in SharePoint, essentially a calendar supported by a form where users can select from a list of stakeholders and indicate the purpose of the discussion, who created the meeting and who else will be attending. Each meeting might also have a 'proposed' or 'confirmed' status so we can plan and then validate that plan with other sub team through regular catch ups. I used to use SharePoint for stuff like this, but it's been more than 10 years since I did. If anyone can give me a few bullet points of what I would need to build (lists, web parts, apps etc.) and a few words of instruction that would be really appreciated. Thanks in advance!
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! 🙂
