This project is to take the data from an excel spread sheet, export it to a list on an Ipad / iphone via wi fi and then update the spreadsheet from the iphone / ipad.
The tabs on the excel spread sheet become buttons or tabs on the app, in this case bus route numbers
the list on the app is populated from the headings on the spread sheet sheets, ie first name, second name
as a student is marked off the list, their name is hidden, this will help speed up the roll call as the list is getting shorter as each student is marked off.
there will need to be an undo last button, and an undo all button (with confirmation)
as each student is marked off, they need to be date stamped, this info will be updated back to the spread sheet.
currently our passes dont have bar codes, if this could be implemented using the camera it might be helpful to speed the whole process up, we print our own passes so adding a bar code is not a big issue
The Ipad / iphone will need to carry the data with them and update the master spreadsheet on return to the office (once in wifi coverage)
There might be more functionality needed into the future, but right now I simply need to see who is and who isnt using the bus service, and trying to get the drivers to keep their paper student lists up to date is a real PITA
Please have a look at the project and let me know your thoughts,Thanks