Online PE record keeping system
Hi all - this is my first post in a forum so please excuse my amateur approach, but I need help!
A teacher has asked me (as the IT Technician) to create an online database of some sort, which will allow students who study years 7-9 Physical Education to update self-assessed records of their personal sporting achievments. Ideally he would like it to be as easy as possible for the kids to use, as they will need to add data a few times a year over the course of a couple of years. We also need to ensure that the students cannot see/edit each others data (which rules out a collabarative spreadsheet).
We are running a Sharepoint (services 2003) VLE and it would be really handy to develop a solution in conjunction with this, as it would integrate AD logins etc. and make authentication a whole lot easier.
In a perfect world, a student would login to the VLE, go to a form, enter their data, click submit and it would be added on to their individual record (which only they and their teacher could see). The teacher would then recieve an automated alert telling them who has/hasn't completed their records and he/see could also see a summary of all records.
I'd really appreciate some help/ideas with this! Can it be done?