The duty dog bites

I have built and trialed a spreadsheet that I built in numbers for male duty. The spreadsheet has:

• Pictures of the students (and their geographic location in dorm)
• Drop down menues for student status (in, out, away, sick, ect)
• Effort grades for each student
• Sports choices
• Phone List
• House parents e-mails

The following are cogitations that I wrote after the first duty trial:

Blog Notes: Duty

Last night I trialed my duty spreadsheet during duty.

There were a number of kids away and. It was nice to be able to check them off of my spreadsheet during the day so that I would know that they were gone when prep started.

I need to have a few more drop down menu options for eventualities, though more options will mean more clutter when I am trying to quickly check them in.

I would like to be able to reset the drop downs or store the info I collected and then start a fresh set of data. This will involve linking the spreadsheet with another sub table, but would be worth it's I think.

I am in the process of getting a sports list that would allow us to keep track of what sport each student was in. This would come in handy at 2:30-3:30.

Of course it would be great to have this pad update something more accessible to all online, I will look into shared online formats of spreadsheets for the iPad.

I would love to have the house parent e-mails hyperlinked, but "numbers" seems to be unable to do that.

I would like to have a way of resetting the check boxes for future uses on future duties.

I hope to streamline the formatting a little too, so that there is no lag when I open the effort grade spreadsheet (ie remove unwanted/unneeded fields)

Anyways for those of you who would like to have a look at it follow the link below ... Ooops. If you would like to check it out, come and see me, there is sensitive information on the spreadsheet that shold only be accessed by KES staff. Gee, self publishing certainly makes it easy to put lots of personal info out there really quickly and easily. All you have to do is click "share with the world".