Forum Discussion
Making personal student study plans for many students on Teams
There have been no answers yet, but I thought I should update this for if someone else is looking at doing something similar - and hopefully get a few constructive comments. Also, I'm okay with talking to myself 🙂
I have been thinking of two possible ways to do this:
1. User input via Forms
I'll use 'Forms for Excel' through OneDrive to create the input form. I'll do this through OneDrive so that the spreadsheet of data updates automatically.
What I would then like to happen is that when students press Submit, an automatic study plan will be generated and sent to them through email or Teams. This would be my next problem as there would be multiple plans depending on the students' choices.
2. Second possible method:
Make a user input form and use the OFFSET function so students will make their own study plan choices. This is then saved to a spreadsheet and the student report emailed or sent through Teams.
The positive aspect of this method is that students will create their own finished plan.
One negative with this is that Microsoft seems to have removed the functions on Mac computers for user-made forms (ie not made through the Forms app).
This is enough rambling for now. Thanks for reading.
- How did you get on with this wish-list?
I looked into Planner and can see that a student can set up their own plan.
Since you want to see that they are adhering to it, you need to get them to add you as a member of the team. (see link below)
https://support.microsoft.com/en-gb/office/manage-your-personal-tasks-with-planner-in-teams-e9449552-0e65-44ac-b53b-9bfcc2268080
