Idea for reading records in Office 365

[rpain]

Hi,

 

We are looking to move our Reception-Yr2 reading records to the cloud so they can be reviewed and added to by both parents and TAs electronically. The requirements are that they are easy to add to, TAs can easily see all boys records but parents can only see their own children's. We now have parents handling Office 365 and Onenote fairly competently.

 

My ideas:

 

1. We could go for putting an editable spreadsheet into a onenote page in each child's onenote but that's a little fiddly to enter into and not especially speedy for the TAs to be able to go to

2. We could set up an ms form which parents and TAs could fill in at each sitting which would add to an ongoing spreadsheet. Downside is that TAs would still need to open up a separate spreadsheet for each pupil

3. Set up an Access database (shiver...)

 

I know there are systems out there that do this nicely but we want to avoid extra cost along with the need for parents to have to remember yet another login.

 

Any ideas would be most welcome.

 

Thanks,

Richard

[gmonks]

We were thinking about a spreadsheet which parents could fill in, but not sure there is a way you could restrict a parent from just inputting their own childs other score? You wouldn't want them editing others. You might have GDPR considerations too, if the last name of the child is present on any shared spreadsheet. If you had a a spreadsheet per pupil it may get a bit messy.

 

I think for now we're just asking parents to send the scores in via Classdojo and then the teachers will add to a spreadsheet.

[rpain]

Thanks - I don't think they're going to be putting in scores. Basically something like:

 

10/7 | "Charlie and the Chocolate Factory" | Read Page 45-55 | 'Enjoyed reading comment etc'

[gmonks]

Forms could work, you can export all the responses into 1 single spreadsheet.

[labstermpa]

I would set this up as a SharePoint list with a power app front end. You can then make is as simple or advance as you want.

[rpain]

Thanks - that sounds like an idea :-)

 

Now just got to look up about power apps.